Road Map: Inventory Listing

Use the Inventory Listing (IL) program to print a listing of inventory items. 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:

  • 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.

  • 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 classes.

  • Product Subclass Maintenance (TSP) to set up product subclasses.

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

After you run this program

You will most likely run these programs:

  • 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.

  • Inventory Sales Report (ISR) to print a report that shows sales for the last twelve periods and the quantity sold, revenue, cost, and gross profit percent for the current period-to-date, year-to-date, and each of the preceding four years.

  • Inventory Usage Report (IUR) to print a report that shows the quantity of components used by manufacturing  for the last twelve periods, the current period-to-date, year-to-date, and each of the preceding four years.

  • Inventory Valuation Report (IVL) to print a report of the current value of inventory based on standard, actual, or average cost.

    OR

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

    OR

    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

  • Inventory Safety Margin Report (ISMR) to print a report that compares quantity on hand with safety stock to determine a safety margin.