This report gives you an overview of the current inventory value of selected items and specifies the cost of these items as of the date specified in the Valuation Date field on the Option tab. It includes all costs, both those posted as invoiced and those posted as expected.
For each of the items that you specify when setting up the report, the printed report shows quantity on stock, the cost per unit and the total amount. For each of these columns, the report specifies the cost as the various value entry types.
You can specify what is included in the report by setting filters. If you do not set any filters, the report will include all your records.
On the Item tab, you can fill in the standard field filters, or you can select additional filters. To do this, press F3, click the AssistButton and then select the relevant filter(s). You can also determine what is shown in the report by filling in the date field on the Options tab.
To print the report, click Print. To see the report on the screen before printing it, click Preview.
To set filters in the report, fill in the fields as follows:
No.: In the Filter field, you can specify the numbers of the items that you want to include in the report.
Inventory Posting Group: In the Filter field, you can specify the inventory posting groups that you want to include in the report.
Statistics Group: In the Filter field, you can specify the statistics groups that you want to include in the report. The field can only be used if the corresponding field on the item card is filled in.
Click the up-arrow in the lower left-hand corner of the window to see the result of the filters you have defined for the table.
To see the sorting keys and determine the order in which the information will be displayed in the report, click Sort.
Valuation Date: If you enter a date in this field, the report will calculate the inventory valuation as of this date.