Sales Turnover

Report Options

Field

Description

Sequence

Indicate one of the following sequences in to generate the report:

Invoice number
If you select this sequence, then the report is printed in document type sequence (e.g. Credit notes, Debit notes, Invoices).
If you do not select this as your report sequence, then you cannot select the option: Highlight missing invoices.
Invoice within register no.
Invoice within branch
Invoice within salesperson
Invoice within customer
Invoice within geographic area

Turnover

Daily

Select this to list all invoices not printed since this report was last run, using the invoice date as a selection criterion

When you select this option and you set the Invoice date selection to Single then all invoices are printed for the Date specified. This is irrespective of whether they have previously been printed. This enables you to reprint the report for a single day.

Monthly

Select this to list all invoices posted since the last time the Month end function of the AR Period End program was run.

Month/year to print

This defaults to the current Accounts Receivable period and year.

Month

Indicate the financial period (within the financial year indicated) for which to generate the report.

Year

Indicate the financial year for which to generate the report.

Invoice date selection

All

Select this to generate the report for all invoice dates.

Single

Select this to generate the report for a invoice specific date. You indicate this date in the Date field.

Date

Indicate the single date for which to generate the report.

All invoices for this date are printed, irrespective of whether they have previously been printed.

Options

Highlight missing invoices

This option is enabled by default when the Report sequence is Invoice number, regardless of whether you select to generate a Daily or Monthly report.

If you leave this as selected, then the invoices included in the report are sequenced by invoice number to identify those invoice numbers that are out of sequence. An error message is printed on the report if any invoice numbers are found to be out of sequence.


	Only invoices for the selected date(s) or month/year combination are included in the sequence check. Credit notes, Debit notes and Finance Charge invoices are excluded from the sequence check. This option cannot be applied when the AR Invoice Number key type is set to alphanumeric (Set Key Information) as it is impossible for the program to assume a sequence and therefore to determine missing invoice 'numbers'.

Page break after totals

Select this to print the totals of each register, branch, salesperson or area on a separate page.

This option is not available when generating the report in Invoice number sequence.

If you do not select this option, then the totals of the register, branch, salesperson or area are printed on the same page.

Print misc/freight charge lines

Select this to include non-merchandise costs for freight and miscellaneous charges in the report.

Note that this option only applies to the Sales Turnover by Product Class report.

Include TPM values

Enable this to deduct Trade Promotions values from the relevant sales order lines when calculating the Sales value. This also affects the Profit value and Profit percentage. By default, Trade Promotions amounts are excluded from the Sales value which means that the Sales value, Profit value and Profit percentages are overstated for Sales orders that include Trade Promotions.

Note that this option only applies to the Sales Turnover report.

Additional Options

Selection criteria

Selection	Description
Branch	Indicate the Accounts Receivable branches for which to include sales in the report. Only sales for customers belonging to the branch(es) selected are included.
Geographic area	Indicate the geographic area(s) for which to include sales in the report. Only sales for customers belonging to the geographic area(s) selected are included.
Salesperson	Indicate the salesperson(s) for which to include sales in the report. This selection is disabled when generating the report for All Branches. This is to prevent duplicate entries on the report for sales persons with the same salesperson's code in different branches.
Customer	Indicate the customer(s) for whom to include sales in the report.
Order type	Indicate the order type(s) for which to include sales in the report.
Customer class	Indicate the customer class(es) for which to include sales in the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

The DTcolumn on the report indicates the document type; C - credit note; D - debit note, and blank indicates an invoice.

Sales transactions created as inter-branch transfers in Sales Order Entry are reflected as IBT documents and their value is shown separately at the end of the report.

Non-merchandise sales are only included in the Total section of the report.

Only merchandise costs are included in the report.

Stocked and non stocked items linked to an underscore product class, such as _OTH, _FRT, _FIN, are included in the report as merchandise items.

Sales values, Profit values and Profit percentages are calculated without taking Trade Promotions into account, unless the Include TPM values option is enabled.

Notes and warnings

Program access

You can only access this program when the Sales Analysis module is installed.

Restrictions and limits

Sales transactions created using the AR Initial Invoice Capture program are ignored by the report.

Error messages

Missing invoice number

This message is displayed before the invoice number when the invoice number was assigned to a sales order, but the invoice has not yet been printed.

Missing invoice numbers are printed with leading zeroes, because the data for numeric keys is right-aligned with preceding zeros, and the report requires all the characters of the invoice number to determine if any invoices are missing.

Refer to Missing Invoice Numbers for additional information on the occurrence of missing invoice numbers.