Reports Menu > Sales Analysis > Sales Report Generator > Sales Report Generator - PTD/YTD |
The Sales Report Generator - Period-By-Period allows users to generate a report on invoice based sales data grouping and summarising by all invoice, customer and product properties, displaying quantity, sales $, cost $, profit $ and G/P % for period to date and year to date of the selected period, and of the same period in the previous financial year if required. Please refer to Sales Report Generator for more information.
Sales Report Generator - PTD/YTD Screen
Parameter Name |
Description |
Focus Period |
The period to focus on. Clicking the drop down arrow allows users to select a different period. |
Show Previous FY |
Yes - Will display sales |
Warehouse Code |
The warehouse code or click to search. Leave blank to include all warehouses. |
Starting Customer Ending Customer Selected Invoice Rep Codes Selected Account Managers Selected Market Codes Selected Customer Classes Selected Referral Sources Selected Customer Groups |
Parameters to restrict which customers you wish to see on the report. |
Starting Product Code Ending Product Code Selected Product Groups |
Parameters to restrict which products you wish to see on the report. |
Starting Primary Vendor Ending Primary Vendor |
Parameters to restrict which products primary vendors' you wish to see on the report. |
Include Invs Excluded from S/A |
Yes - Will include invoices that have been marked to be excluded from the sales analysis. |
Include Freight |
Yes - Freight charges will be included on the report. |
Report Level 1 Report Level 2 Report Level 3 Report Level 4 Report Level 5 |
Users can select up to five reporting levels to sort and sub-total the report by each level. The lowest level selected (the level with the highest number) is the item that the reporting figures are displayed against, while each of the higher levels will be used to sort and sub-total the report. |
When the required parameters have been entered, the Sales Report Generator - PTD/YTD will be generated.
Example of Sales Report Generator - PTD/YTD