Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

IC145

IC145 - Stock Status Report

Run this program to print the Stock Status Report. Run this report to
determine item availability based on the actual supply and demand.

This report prints the following quantity totals. These totals are derived
from open customer orders created in the Order Entry and Requisitions systems,
purchase orders created in the Purchase Order system, work orders in the Work
Order system, case carts in the Case Carts system, and open intransit
transfers created in the Inventory Control system.

      Unallocated      Allocated    Backordered    Stock-On-Hand
      Picked           On-Order     Intransit      Available

Item records print in item number sequence and includes the buyer code,
inventory major and minor classes, movement class, auto PO flag, leadtime, and
stock unit of measure. This information is derived from the Item Master and
Item Location file(s) (IC11, IC12 or IC10).

Updated Files

    CKPOINT    - Used in backout or restart information.

    ICCOMPANY  - Used to validate the existence of the company.

    ITEMLOC    - Used to update the activity flag if the update option is
                 selected.



Referenced Files

    APCOMPANY  - Used to validate the Accounts Payable company and obtain the
                 vendor group.


    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.


    APHLDINV   - The Hold file contains records of vendors, invoices, and
                 payments that are on hold.


    APVENCLASS - Used in an Accounts Payable common routine.

    APVENGROUP - Used to validate the vendor group.

    APVENMAST  - Used to validate the vendors.

    GLCODES    - Used in a General Ledger common routine.

    ICBIN      - Used to validate and extract bin number information.

    ICCATEGORY - The GL Account Category file is a master file that defines the
                 inventory and offset general ledger accounts used to post
                 inventory transactions.


    ICLOCATION - Used to validate the existence of the location.

    ICRPTGRP   - Used to validate the report group.

    ITEMMAST   - Used to print the item number description and unit of measure.

    MAJORCL    - Used to validate the major class.

    MINORCL    - Used to validate the major-minor class.

    RQLOC      - Used to retrieve Requisition location names.

    WHDEMAND   - The Demand file contains all the records that the Warehouse
                 system needs for processing demands.


    WHDEMNDHDR - The Demand Header file contains document header records.