Road Map: 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 Background for more information.

Before you run this program each time

You should run these programs: None required

Before you run this program the first time

You should run these programs:

  • System Options Maintenance (XM) (Inventory Control Options) to set the Manage negative inventory and Update actual and average costs? options.

  • Enterprise Item Maintenance (IM) to set up items for your enterprise.

  • Branch Item Maintenance (IMB) to set up items for your branch.

  • Item Cost Maintenance (ICM) to enter item costs.

  • Standard Cost Rollup (MCR) to update the standard cost of items and update the general ledger if you have inventory interfaced to the GL.

  • Branch Maintenance (TBM) to set up branches.

  • Branch Groups Maintenance (TGM) to set up branch groups.

  • Product Class Codes Maintenance (TPC) to set up product class codes.

  • Inventory Account Codes Maintenance (TAC) to set up inventory account codes.

  • Item Status Codes (TISM) to set up item status codes.

  • ABC Class Update (HAA) to define the criteria for ABC classes and assign classes (A through J) to items based on these criteria.

  • Buyer / Planner Codes Maintenance (TNM) to set up buyer codes.

  • Output Device Maintenance (XDM) to set up the output devices you plan to use.

  • Date-Output Device Maintenance (ZE) to select your default output device and set whether you can override that device.

After you run this program

You will most likely run these programs:

  • Inventory Value for Buy Items (IVLB) to print a report that calculates the variance between extended actual and standard cost for items you buy.

  • Inventory Valuation for Make Items (IVLM) to print a report that shows your choice of standard or extended material, labor, overhead, and outside service costs for items you make.

  • Item Status Report (ISS) to print a report that shows on-hand, floor stock, obligated, available, intransit, on-order, and committed quantities and can include a listing of supply and demand orders.