Background: Inventory Valuation by Location Report

Use the Inventory Valuation by Location Report (IVLR) program to print a report of the current value of inventory in each warehouse location based on standard, actual, or average cost.

The report prints in warehouse and bin location sequence unless you select other Sort options.

The report includes this information:

  • Branch

  • Warehouse

  • Bin location

  • Item number

  • Item description

  • Last receipt date

  • Unit of measure

  • Quantity on hand

  • 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

  • Standard, actual or average value: based on your Print Std, Act, or Avg cost Program option selection. Quantity in floor stock is not added to the Quantity on hand in the calculations below if you chose Do not include floor stock for the Extended value calculation option.
    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

  • Primary warehouse

  • Primary bin

  • Product class

  • Inventory account code

  • Item status

  • Total quantity on hand in the locations printed

  • Total standard, actual, or average value of inventory in locations printed