Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

IC820

IC820 - Beginning Balance Load

Run IC820 to create and update the stock-on-hand quantity fields required for
the Inventory Control database with data from another system. IC820 creates
the following files:
- Stock on Hand Detail,
- Serial Number Control, and
- Lot Control.

IC820 produces a report that lists fatal and nonfatal errors. IC820 does not
create or update to the database any records with fatal errors.

Updated Files

    CKPOINT    - This file is used in the event of a program or system failure
                 to enable a batch update program to continue from where it left
                 off.


    ICLOT      - The Lots with Expire Date/On Hold file stores the expiration
                 dates and/or the hold flag for lots.


    ICRECEIPTS - The cost history file which is used for LIFO and FIFO costing.


    ITEMLOC    - The Item Location file contains the dynamic information for an
                 inventoried item at a stock location.


    ITSERIAL   - This file stores the valid serial numbers currently in stock
                 and issued.


    SOHDETAIL  - The Stock On Hand Detail File contains the detail quantities
                 for an item at a location, if the item is controlled by bin or
                 lot/sublot or multiple units of measure.



Referenced Files

    GLCODES    - This file holds information relating to systems, source codes,
                 folders and process groups.


    ICBIN      - The Bin Numbers file is a master list of valid bin numbers in
                 a location used for tracking items by bin.


    ICCOMPANY  - Used to validate the company number.

    ICLOCATION - Used to validate the inventory location.

    ITEMMAST   - The Item Master file stores static information about each item
                 such as description, classes, units of measure, and weight.