Stock Sales - By State (#121) 
Stock Sales - By State (#121)
This report shows sales by individual product, by state and stock or supplier group, for a date or transaction number range. Specific stock groups or supplier groups can be included or excluded from the report. The report may also be limited to a particular range of product codes.
The basic lay-out of this report is:
State: QLD
Stock Group: A
Product ABC Description 5 50.00
Product XYZ Description 2 20.00
Stock Group: B
Product GHI Description 1 10.00
State: NSW
Stock Group: A
Product DEF Description 1 10.00
State
Enter the state code only if you wish to limit the report to a single state, otherwise leave blank to include all states.
Account Type
Enter the customer account type to include on the report. The default of "Regular" should be fine under most circumstances.
From Product Code
You may limit the analysis to a particular range of product codes. Enter the first product code here, if applicable. If this is left blank, the first product code in the stock file will be included.
To Product Code
Enter the last product code to include on the report for analysis. If this is left blank, the last product code in the stock file will be included.
Include Tax
By default, the tax portion of the sales item is not included as part of the sales total. Tick 
to include tax in the sales figures on the report.
Hints & Tips
State by state analysis is determined by the state code of the customer account address. (The state specified on individual transactions is not used. This allows users the ability to correct input errors more easily before running this report.)
If the report is run in 'summary' mode then individual stock items will not be listed on the report. Only group totals will be included.
If the 'New Page Per Group' option is selected, a new page per state grouping (not stock or supplier grouping) is applied.
The contents of kits are not decomposed on this report.
Cash orders and lay-by sales are included.
As this is a stock analysis report, sales that do not have an associated product code are excluded from the report.
____________________________
Related Topics:
 |