Item Statistics
This report is available from the Sales Ledger only. It displays sales statistics for each Item, including turnover, quantity and gross profit.
When printed to screen, the Item Statistics report has Hansa's Drill-down feature. Click on any Item Number to open the corresponding Item record.
Leave all the fields blank if the report is to cover all the Items in the Item register. If it is necessary to restrict the coverage of the report, use the fields as described below.
- Item No.
- Paste Special
Item register
- Range Reporting Alpha
- Use this field to limit the report to a single Item, or range of Items.
- Customer
- Paste Special
Customer register
- To limit the report to sales to a single Customer, enter a Customer Number here.
- Categories
- Paste Special
Customer Categories setting, Sales Ledger
- Range Reporting Alpha
- Use this field to limit the report to sales to Customers of a single Category or range of Categories.
- Item Classification
- Paste Special
Item Classifications setting, Stock module
- Select an Item Classification. Sales of all Items with that Classification will be included in the report. If you enter a number of Classifications separated by commas, only Items featuring all the Classifications listed will be included in the report.
- Classification
- Paste Special
Customer Classifications setting, CRM module (if installed)
- Select a Customer Classification. Sales to all Customers with that Classification will be included in the report. If you enter a number of Classifications separated by commas, only sales to Customers featuring all the Classifications listed will be included in the calculations.
- Item Groups
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- To limit the report to a single Item Group, enter an Item Group Code here.
- If both a range of Items and a range of Item Groups are specified, the report will cover only those Items in the range which are members of the specified Item Groups.
- Department
- Paste Special
Departments setting, Assets module
- To limit the report to Items of a single Department, enter a Department Code here. The Department of an Item is specified on the 'Stock' card of the Item screen.
- 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 a Price List is specified here, the Price according to that Price List is shown as well.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end date of the reporting period.
- Function
- These settings control the level of detail included in the report.
- Overview
- This option offers a single line per Item displaying sales statistics, including turnover, quantity and gross profit.
- Detailed
- In addition to the information offered by the previous option, this choice also shows quantities in stock and on order, and the Base and Cost Prices for each Item. If a Price List is specified 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, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.
- If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.