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, POS Invoices and Bar Tabs 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, POS Invoices and Bar Tabs recorded during the period specified here.
- Price List
- Paste Special
Price List register, Pricing module
- Range Reporting Alpha
- Specify here the Price List whose sales statistics are to be shown in the report. You can also specify a range of Price Lists, separated by a colon (:).
- If you leave the field empty, all sales (from Invoices, POS Invoices and Bar Tabs 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.
- 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 the specified Price List(s). For each Item, the report will show the Item Number and Name, the quantity sold and the average sales price.
- Detailed
- This option will contain separate sections for each Price List in the specified range, showing the Base Price, the Profit, the GP% and the Turnover for each Item sold. If you left the Price List field above empty, the report will also contain a section for Items sold without a Price List.
- Registers
- Use these options to specify whether the statistics in the report should be calculated from Invoices, POS Invoices or Bar Tabs, or any combination.
- Status
- Use these options to specify whether the statistics in the report should be calculated from Invoices that have been marked as OK, Invoices that have not been marked as OK or both. In the case of POS Invoices and Bar Tabs, these options will include or exclude records that have been marked as Finished in the calculations.
- Exclude Voids/Returns
- A void Item is one that you have added to a Sales Ledger Touch-Screen Invoice, POS Invoice or Bar Tab and then removed using a "Void Item" button. A returned Item is one with a negative quantity, added to the transaction using a "Return" button. By default, void and returned Items will not be shown in the report. Deselect this option if you would like them to be included.
---
In this section:
Go back to:
Sissejuhatus
