Old Reports - Sales by Salesperson

Parent Previous Next

Bug

The Sales by Product report (Tools → Old Reports → Sales Analysis → Sales by Salesperson menu) only includes the default stock item type. It does not include any other stock item types (e.g. ten (10) stock item types i.e. Sales, Sales (No Stock), Purchases, Purchases (No Stock), Financial Entry, Option Item, Option Item (No Stock), BOM (Bills of Materials), BOM (Production), Linked Sale).

This option allows you to view and analyse your Sales by Salesperson. This report may be retrieved on a summarised level to see the totals of Invoices and Credit Notes for each Salesperson, or to view the details of your Invoices and Credit Notes for each Salesperson.

This report summarises or lists all the Invoices, Point-of-Sale Invoices and Credit Notes issued by each salesperson within a selected period or range of dates. You will be able to analyse the sales invoice totals and credit note totals, and the net total, for all salespersons or a selected salesperson.

Print Sales by Salesperson Reports

To Generate a Sales by Salesperson Report:

1.Click on the Tools  → Old Reports → Sales Analysis → Sales by Salesperson menu.

Ctrl + Alt + S

The Sales by Salesperson Options screen is displayed:

2.Send Report To - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Salesperson - Select to list the all your Salespersons or a specific Salesperson.

b)Show Details - If this field is left blank, you will view the totals of documents (Invoices and Credit Notes) issued by each Salesperson.

If this field is selected, the detail of the Invoices and Credit Notes (the date and number) the Debtor (Customer) Account, as well as the Gross Profit percentage will be displayed for each individual Invoice and Credit Note. The total for each Invoice and Credit Note and for each Salesperson, as well as a grand total of your sales, will be displayed.

c)Show Stock Groups - If this field is selected, it will print Stock Group 1 / Stock Group2 descriptions instead of the Stock Item Code.

This field will only be activated, if the Show Details field is selected. If you have set your Stock Groups up in the Setup → System parameters → Groups menu on the Stock Groups tab, and you select this field, the Sales for each of your Stock Groups will be displayed.

d)From ... To - Select the start and end date to include in this report.

4.Click on the OK button to send the report to the medium selected in the Send Report to field.

View Sales by Salesperson Reports

An example of the Sales by Salesperson report, reflecting the details (if the Show Stock Groups field is not selected), is:

This report consists of eight (8) columns, reflecting the following information for the Salespersons:

1.Items Code - The Stock Item codes for all the stock items on Invoices and Credit Notes, will be listed for each Salesperson.

If the Show Stock Groups field is selected on the Sales by Salesperson Options screen, the Stock Item Codes will be replaced by the descriptions (name) of Stock Group 1. To view the details of Stock Groups, the Stock Items must be linked to an Stock Group.

2.Invoice Number - The Invoice, Point-of-Sale Invoice or Credit Note number as generated by TurboCASH.

3.Debtor Code - The Debtor (Customer) Account Code or Number for the Debtors for whom an Invoice or Credit Note was generated by a Salesperson.

4.Invoice Date - The date when the Invoice, Point-of-Sale Invoice or Credit Note was generated.

5.Net Sales Amount - This is the total amount of the selected selling prices (selling price 1 /2 / 3) for all the selected stock items on the Invoice, Point-of-Sale Invoice or Credit Note.

6.Net Cost Amount - The total cost price (average or latest cost) for all the selected stock items on the Invoice, Point-of-Sale Invoice or Credit Note.

7.Gross Profit - This is the difference between the Net Sales Amount and the Net Cost Amount.

8.Gross Profit % - The percentage of the Gross Profit for the Invoice, Point-of-Sale Invoice or Credit Note.

These amounts or totals are exclusive of VAT/GST/Sales Tax.

Totals will be displayed for each type of document (Invoices and Credit Notes) for each of the Salespersons, and a grand total for all the Salespersons included in this report.


Created with the Personal Edition of HelpNDoc: Create cross-platform Qt Help files