Open topic with navigation

Select Inventory Management Reports menu > Inventory Valuation Report.

Use Inventory Valuation Report to determine the value of the on-hand quantity of each item. The value is calculated by multiplying the unit cost (based on the valuation method established for the item in Item Maintenance) by the quantity on hand.

The report can be produced as a summary by item and/or warehouse or the report can include cost tier information for all FIFO, LIFO, lot, and serial items. Detail cost information for these items includes the receipt number and date, the quantity received on hand, the actual received unit cost, and the extended inventory value.

Lot and serial item detail also includes costing detail by lot and serial number. The inventory value for each receipt (cost tier) is calculated individually, based on the valuation method specified for that item.

You can enter a selection of item codes, product lines, primary vendor numbers, item descriptions, and warehouses to print. By entering these selections, you can obtain a list that allows you to identify pertinent information.

Note If you are using this report as an audit tool or for comparison purposes with general ledger balances, select the Print Inactive Items check box to include recorded history for any inactive items.

Note This report prints the item's primary vendor information and does not include other vendors associated with the item.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks