Inventory Valuation (IC233)

Run Inventory Valuation (IC233) to print a report of inventory valuation. The report also values stock-on-hand quantities based on a specified costing method (Standard, Average, LIFO, or FIFO). By default, inventory valuation is based on the costing method defined for the company. Refer to the Inventory Control User Guide for costing method calculation formulas.

You can select the inventory valued on this report by location, report group, and general ledger category. Otherwise, inventory valuation is based on all locations and general ledger categories. This report lists general ledger category, location, and company summarized totals. The default parameters include item detail and exclude items with zero stock-on-hand quantities. The detail report prints by location and general ledger category. Details include the item number, description, unit of measure, unit cost, Intransit quantity, On Hold quantity, Stock On Hand quantity, Stock On Hand Value, Preferred Bin (if it exists), and Total Value.

Note: The report prints the run date and time and lists a composite total of Item Location records as of that run date and time. The report multiplies the current stock-on-hand times the unit cost. It does not take into consideration when the transaction that updated the inventory took place. If all inventory transactions (including Order Entry, Purchase Order, and Requisitions) have been processed to the General Ledger application, the report should balance to general ledger account totals. The preferred bin is for reference only. Stock On Hand may be located in additional bins. Use the Drill feature on the item to view the actual quantities and locations.