This report displays inventory valuation for selected items in your inventory. It also shows information about the value of increases and decreases in inventory over a selected period.
The printed report always shows actual (invoiced) amounts, that is, the cost of entries that have been posted as invoiced. The report will also print the expected cost of entries that have posted as received or shipped, if you insert a check mark in the Include Expected Cost field on the Options tab.
The printed report groups entries by inventory posting groups. For each inventory posting group, the report shows a group total for invoiced costs. If you have placed a check mark in the Include Expected Cost field, the document will also show a group total of invoiced and expected costs.
Before you run this report, you should run the Adjust Cost - Item Entries batch job. If you do this, the values shown in the Inventory Valuation report will be up-to-date. If you run this report without first running the batch job, the values in the report may be different from those in the Status and the Invt. Valuation - Cost Spec. reports.
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 fields 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 be used only 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 results 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.
Starting Date: In this field, you can enter a date to specify the beginning of the period covered by the report. The program will use this date to filter on the Posting Date of the value entries.
Ending Date: In this field, you can enter a date to specify the end of the period covered by the report if you want to calculate inventory value for a specific period. The program will use this date to filter on the Posting Date of the value entries.
Include Expected Cost: In this field, you can enter a check mark if you want the report to also show entries that only have expected costs.