Background: Inventory Valuation Report

Use the Inventory Valuation Report (IVL) program to print a report of the current value of inventory based on standard, actual, or average cost. See Road Map for work flow.

The report prints in item number sequence unless you select other Sort options.

The report includes this information:

  • Branch

  • Item number

  • Item description

  • Quantity on hand

  • Quantity in floor stock

  • Std cost: Standard unit cost if you selected STD for the Print Std, Act, or Avg cost Program option. The standard cost for  configured products is the average standard cost for those currently on hand. Each configured product carries a unique cost.
    Act cost: Actual unit cost if you selected ACT
    Avg cost: Average unit cost if you selected AVG

  • Value: based on your Print Std, Act, or Avg cost Program option selection:
    Std value: (Quantity on hand + Quantity in floor stock) x Standard unit cost if you selected STD for the Print Std, Act, or Avg cost Program option
    Act value: (Quantity on hand + Quantity in floor stock) x Actual cost if you selected ACT
    Avg value: (Quantity on hand + Quantity in floor stock) x Average cost if you selected AVG

  • Product class

  • Inventory account code

  • Stocking unit of measure

  • Order code

  • Total standard, actual, or average value of all items

  • * ABC class

  • * Make/Buy/Kit code

  • * Primary warehouse

  • * Primary bin location

  • * Buyer code

  • * Planner code

  • * Status code

  • * Product subclass

* these fields are output only if your output device is a text file or Microsoft Excel.