Item Price List Statistics
The Item Price List Statistics report, available in both the Sales Ledger and the Point of Sales module, lists the Items you have sold in Invoices and POS Invoices with a specified Price List. This can be useful if you have connected a particular Price List to a marketing campaign and you need to gauge its effectiveness.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end date of the reporting period. Depending on which Registers options below you choose, the statistics in the report will be compiled from Invoices and POS Invoices recorded during the period specified here.
- Price List
- Paste Special
Price List register, Pricing module
- Specify here the Price List whose sales statistics are to be shown in the report.
- If you leave the field empty, all sales (from Invoices and POS Invoices with and without Price Lists) will be included in the report.
- Item
- Paste Special
Item register
- If you need to see the sales of a particular Item when sold with a particular Price List, specify that Item here.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- If you need to see the sales of Items belonging to a particular Item Group when sold with a particular Price List, specify that Item Group here. You can also specify a range of Item Groups, separated by a colon (:).
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- If you need to see the sales of Items with a particular Item Classification when sold with a particular Price List, specify that Item Classification here. If you enter a number of Classifications separated by commas, only those Items with all the Classifications listed will be included in the report.
- Registers
- Use these options to specify whether the statistics in the report should be calculated from Invoices, POS Invoices or both.
- Function
- Use these options to specify the level of detail that you need to be shown in the report.
- Overview
- This version of the report is a simple list of the Items sold with a particular Price List. For each Item, the report will show the Item Number and Name, the quantity sold and the average sales price.
- Detailed
- In addition to the information shown in the Overview, this option will show the Base Price, the Profit, the GP% and the Turnover for each Item. If you left the Price List field above empty, the report will contain separate sections for each Price List, and a section for Items sold without a Price List.
---
In this section:
Go back to: