Item Statistics
This page describes the Item Statistics report in the Sales Ledger.
---
The Item Statistics report in the Sales Ledger is a list of the Items you have sold during the report period (i.e. the Items included in Invoices, POS Invoices and Bar Tabs from that period). This list displays sales statistics from that period for each Item, including quantity sold, gross profit and margin and turnover (i.e. total sales value).
When printed to screen, the Item Statistics report has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on any Item Number to open the corresponding Item record.
An alternative method that you can use to produce an Item Statistics report for an individual Customer is to produce a Customer Statistics report and drill down from a Customer Number in that report.
Leave all the fields blank if the report is to cover all the Items in the Item register. If you need to restrict the coverage of the report, use the fields as described below.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end date of the reporting period. The sales statistics in the report will be compiled from Invoices, POS Invoices and Bar Tabs recorded during the period that you specify here.
- Item No.
- Paste Special
Item register
- Range Reporting Alpha
- If you need the report to show sales statistics for a particular Item, enter its Item Number here. You can also enter a range of Item Numbers separated by a colon (:).
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- Enter an Item Classification here if you need the report to list statistics for Items with a particular Classification. You can enter a number of Classifications separated by commas, in which case only Items featuring all the Classifications listed will be shown in the report. If you enter a number of Classifications separated by plus signs (+), Items featuring at least one of the Classifications listed will be included in the report. If you enter a Classification preceded by an exclamation mark (!), all Items featuring any Classification except the one listed will be included.
- For example:
- 1,2
- Lists Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).
- 1+2
- Lists Items with Classifications 1 or 2.
- !2
- Lists all Items except those with Classification 2.
- 1,!2
- Lists Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.
- !1,!2
- Lists all Items except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Lists all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not be listed).
- !1+2
- Lists Items without Classification 1 and those with Classification 2 (Items with Classifications 1 and 2 will be listed).
- (1,2)+(3,4)
- Lists Items with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Lists Items with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Lists Items with Classifications beginning with 1 but not 1 itself.
- *1
- Lists Items with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Lists Items with Classifications beginning and ending with 1.
- Item Groups
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- If you need the report to list statistics for the Items that belong to a particular Item Group, specify that Item Group here.
- If you specify both a range of Items and a range of Item Groups, the report will only list the Items in the range that are members of the specified Item Groups.
- Customer
- Paste Special
Customers in Customer register
- If you need the report to list the Items you have sold to a particular Customer, enter the Contact Number for that Customer here.
- Categories
- Paste Special
Customer Categories setting, Sales Ledger
- Range Reporting Alpha
- If you need the report list the Items you have sold to Customers belonging to a particular Customer Category, specify that Category here. You can also enter a range of Categories separated by a colon (:), in which case the report will include separate sections for each Category.
- Department
- Paste Special
Departments setting, Assets module/System module
- To list Items belonging to a particular Department in the report, enter that Department here. The Department of an Item is taken from the 'Stock' card of the Item window.
- Branch
- Paste Special
Customers in Contact register
Specify a Branch if you only want the statistics in the report to be compiled from Invoices, POS Invoices and Bar Tabs featuring that Branch. This will be useful if your company has several Branches (e.g. several shops): the Branch where each transaction was created will automatically be recorded (for example, on the 'Del. Terms' card of the Invoice window), taken from the Local Machine setting in the User Settings module.
- Bar Tab Class
- Paste Special
Bar Tab Classes setting, Restaurant module
- Specify a Bar Tab Class if you only want the statistics in the report to be compiled from Bar Tabs featuring that Class. If you specify a Bar Tab Class in the Local Machine setting in the User Settings module on a particular computer or till, it will be copied to all Bar Tabs created on that machine. If you want waiters to be able to change the Class in a particular Bar Tab, add a "Set Tab Class" button to the Bar Tab window.
- Price List
- Paste Special
Price List register, Pricing module
- This field is only used by the Detailed version of the report, which prints the Base and Cost Prices of each Item. If you specify a Price List here, the Price according to that Price List will be shown as well.
- Location
- Paste Special
Locations setting, Stock module
- Range Reporting Alpha
- Specify a Location if you only want the statistics in the report to be compiled from Invoices, POS Invoices and Bar Tabs issued from that Location. You can also enter a range of Locations separated by a colon (:).
- Show All Locations
- If you have not specified a Location or have specified a range of Locations in the field above, the report will display total figures for sales made from all Locations or from all Locations in the range. Select this option if you would like individual sales figures for each Location to be displayed as well.
- For example, if you have sold three units of an Item from Location 1 and four from Location 2 during the report period, the default version of the report will show that you have sold seven units. If you select this option, the report will show that you have sold seven units, and on the following lines it will show the three and four units that you have sold from each Location. If you have a Location 3 that did not sell any units, that Location will not be listed.
- Function
- Select one of these options to specify the level of detail that you need to be included in the report.
- Overview
- This option offers a single line per Item showing the quantity sold, the gross margin and profit and the turnover during the report period.
- Detailed
- This option compares the quantity sold, gross profit and turnover of each Item during the report period with the same figures for the current Fiscal Year. This option also shows for each Item its Cost and Base Prices (from the Item record), its unit stock value (calculated using the usual Cost Model) and the quantities in stock and on order. Finally, if you have specified a Price List in the field above, the Price according to that Price List is shown as well.
- Values in
- If you are using the Dual-Base system, use these options to specify whether the values in the report are to be shown in Base Currency 1 or 2.
- If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.
---
Go back to:
|
Introduction to Item Reports
