Show TOC

Object documentationInventory Valuation Simulation Report - Detailed Locate this document in the navigation structure

 

Note Note

If your company manages nonperpetual inventory, the name of this report is Inventory Valuation Report.

End of the note.

If you want to view the result of the next item, in the toolbar, click the Next Record (Next Record) icon. You can use the Next Record (Next Record) and Previous Record (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 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.
Inventory Valuation Simulation Report Fields
Posting Date, Reference

Contain the date and the type/number of the posting that was used to move the item.

Warehouse, Quantity

Contain the issuing/receiving warehouse of the goods movement, along with the quantity of the item recorded in the document.

Price

The unit price of the item in the document (for inventory receipts) or the calculated price (for issue from stock).

Total

Total document value. The value is calculated as Qty X Price.

Cumulative Qty

The cumulative quantity of an item inventory after the goods are moved.

Cumulative Value

The cumulative value (in local or in foreign currency) after the goods are moved.

Note 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 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.

End of the recommendation.