Items-on-Hand Valuation Report
The Items-On-Hand Valuation Report provides the cost basis value of inventory stock on-hand as of a specified date.
This report can be used to substantiate the value of the company's inventory asset, and is often printed on a monthly or quarterly basis for inclusion in the company's accounting records. This report is used when reconciling inventory with the General Ledger.
The report may be printed in Summary, in Detail, or in Standard Cost format, which prints one line per item and uses standard cost rather than "actual" cost. The Standard Cost format might be used for insurance replacement-cost planning. Any of these reports may be printed for items with non-zero value, negative value, zero value, or all of the above.
The table below describes the different calculations found on each report format:
Format |
Calculations |
|---|---|
Summary |
This format calculates the total cost and quantity for all inventory layers and then divides the total cost by the total quantity to calculate the average cost. This format is used to reconcile to the General Ledger. |
Standard Cost |
This format calculates the total quantity of all inventory layers and then multiplies the quantity by the warehouse-specific standard cost to come up with a standard cost valuation. If the warehouse-specific standard cost is blank or zero, the standard cost from the Item Main Properties will be used to calculate the standard cost valuation. |
Detail |
This format displays the inventory layers. This report does NOT use the date listed on the selection screen; it is a listing of inventory layers "as of today." |
Items-On-Hand Valuation Report, Summary – Pos/Neg
