Note
If your company manages nonperpetual inventory, the name of this report is Inventory Valuation Report.
If you want to view the result of the next item, in the toolbar, click the (Next Record) icon. You can use the (Next Record) and (Previous Record) icons to navigate through the list of valuated items.
If you selected the Detailed Receipts/Releases option in the Inventory Valuation Simulation Report - Selection Criteria window, the Inventory Valuation Simulation Report window displays all the document details for each item you have selected.
The upper section of the window indicates the:
Valuation method chosen for the report
Currency in which the report was prepared
Specified reporting date for valuation
The display also contains the number and a description of the selected item.
If you set the flag for an additional foreign currency in the selection window, you can switch to the display in this foreign currency here.
Note This topic documents fields and other elements in this window that either are not self-explanatory or require additional information. End of the note. |
Contain the date and the type/number of the posting that was used to move the item. |
Contain the issuing/receiving warehouse of the goods movement, along with the quantity of the item recorded in the document. |
The unit price of the item in the document (for inventory receipts) or the calculated price (for issue from stock). |
Total document value. The value is calculated as Qty X Price. |
The cumulative quantity of an item inventory after the goods are moved. |
The cumulative value (in local or in foreign currency) after the goods are moved. Note The total balances for the quantities and values appear near the bottom of the list. End of the note. |
If you only need to compare the warehouse inventory value with the balance sheet value, you do not have to run the detailed format of the report. The totals display with one row per item will suffice for this purpose.
Recommendation
The preparation of the warehouse inventory valuation with the detailed option for displaying all the documents for an item can take a long time. Therefore, we recommend that you start this report at the end of the workday.