Item History
The Item History is a report listing each goods in and goods out transaction for individual Items.
When printed to screen, the Item History report has the HansaWorld Enterprise Drill-down feature. Click on any stock transaction number (e.g. Delivery Number, Goods Receipt Number or Invoice Number) to open the corresponding record.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end date of the report period, separated by a colon (:).
- Item No
- Paste Special
Item register
- Range Reporting Alpha
- To restrict the report to particular Items, enter an Item Number or a range of numbers here.
- Group
- Paste Special
Item Group register, Sales Ledger
- Enter an Item Group number, to include in the report only those Items belonging to the Item Group.
- Classification
- Paste Special
Item Classifications setting, Stock module
- Enter a Classification Code in this field if you want to list Items with a certain Classification. If the field is empty, all Items, with and without Classification, are included. If you enter a number of Classifications separated by commas, only those Items featuring all the Classifications listed will be shown. If you enter a number of Classifications separated by plus signs (+), all Items featuring at least one of the Classifications listed will be shown. If you enter a Classification preceded by an exclamation mark (!), all Items featuring any Classification except the one listed will be shown.
- 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.
- Classification Types
- Paste Special
Classification Types setting, CRM module
- Enter a Classification Type in this field if you want to list Items with a Classification belonging to that Type. If the field is empty, all Items, with and without Classification, are included. If you enter a number of Classification Types separated by commas, Items featuring a Classification belonging to any of those Types will be shown.
- Location
- Paste Special
Locations setting, Stock module
- To limit the report to a specific stock Location, enter its code here.
- Department
- Paste Special
Departments setting, Assets module/System module
- Range Reporting Alpha
- Enter a Department Code, to include in the report only those Items assigned to a particular Department (specified on the 'Stock' card of the Item record).
- Default Supplier
- Paste Special
Suppliers in Contact register
- If a Supplier Code is entered here, only those Items whose Default Purchase Item features that Supplier will be shown in the report.
- Registers
- Select one or more transaction types for inclusion in the report.
- Only Stocked Items
- Use this option to exclude Plain, Structured and Service Items from the report.
- Show Balance for Items with no History
- By default, only those Items for which at least one stock transaction was entered during the report period will be shown in the report. Items that were received into stock before the report period and that were not subject to any subsequent movement will not be listed. If you would like to include such Items in the report together with opening balance figures, use this option.
- Include Future Records
- Usually, the report does not include Sales and Purchase Orders, because these do not directly result in any movement of stock (their stock implications are more correctly represented by Deliveries and Goods Receipts).
- Check this box if you would like to have certain Sales and Purchase Orders included in the report: this could help with planning future requirements for particular Items. To be included in the report, Sales and Purchase Orders must be unfulfilled and must have a Planned Delivery Date that falls within the report period. The Planned Delivery Date field must use the Date format, set in the Planned Delivery setting in the Sales Orders module.
- Per Location
- By default, the report is a list of Items. For each Item, the stock transactions are listed in Cost Date or Transaction Date order (determined by the Sorting options below). The stock transactions are not sorted by Location.
- If you choose this option, the report will be a list of Locations. For each Location, there will be a list of Items. Then for each Item, the stock transactions will be listed in Cost Date or Transaction Date order.
- Function
- Use these options to control the level of detail shown in the report.
- Overview
- The report will contain one row per Item, showing for each the quantity received and the quantity removed from stock over the report period. If the Item is a component and has been used in Stock Depreciations as part of a Structured Item, these movements will be shown separately.
- Detailed
- For each Item, the report will list all stock transactions during the period. Locations are also shown.
- Function
- Use these options to determine which figures are shown in the report.
- Quantities
- The report will contain only stock quantities.
- Amounts
- The report will show stock values and, if the Detailed option has been chosen, quantities.
- Function
- Use these options if you have some Items for which stock levels can be expressed using different units of measurement (e.g. metres and yards, litres and gallons, etc). These Items should be configured with a main Unit on the 'Pricing' card and a Unit 2 (the secondary Unit) and Coefficient (the relationship between the two Units) on the 'Stock' card. For example, an Item sold in litres and gallons should have "LITRE" as the main Unit, "GALLON" as the Unit 2 and "0.22" will be the Coefficient. The Quantity 2 figure in this report will be the quantity measured in gallons.
- You can only use these options in the Detailed version of the report, and when you are also using the Quantities option described above.
- Don't show Quantity 2
- Use this option to express stock quantities using the main unit of measurement (litres in the example).
- Show Quantity 2
- Use this option to express stock quantities using both units of measurement (litres and gallons in the example). Quantity 2 figures will only be shown for Items that have a Unit 2 and a Unit Coefficient specified on the 'Stock' card. You cannot use this option if you are producing the Detailed version of the report together with the Amounts option.
- Show Coefficient
- Use this option to express stock quantities using the main unit of measurement, together with the Coefficients where appropriate. You cannot use this option if you are producing the Detailed version of the report together with the Amounts option.
- Sorting
- Use these options to specify how the stock transactions will be sorted in the report. Usually the Cost Date and the Transaction Date will be the same, but they may be different if you have some Returned Goods and you are using the Insert At Original Position in Cost Queue option in the Cost Accounting setting. In this case, the Transaction Date will be the date of the Returned Goods record, while the Cost Date will be the date of the original Goods Receipt.
|