Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

IC840

IC840 - Cart Par Location Conversion

Run IC840 to load the cart/par location records into the Lawson database
files.  The load process takes the input CSV file and edits it as if it were
going  through  the IC81 edit screen in Inventory Control. The load process
then  updates the  following  tables: RQLOC, ICLOCATION, BINGROUP, ITEMLOC,
ICBIN,  and BINGRPDTL.

Before running the conversion job, the General Ledger and Accounts Payable
systems must be set up.

Before running the conversion job, ICCATEGORY, ICLOCATION, ITEMMAST are tables
that must be populated with data.

Before running the conversion job, the ITEMLOC record must exist for
replenishment  locations. If the ITEMLOC record already exists for the
location, the input CSV file will automatically update the record.

Updated Files

    BINGROUP   - Used to validate bin group name.

    BINGRPDTL  - Used to edit on a delete. Cannot delete a bin if used in a bin
                 group.


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


    ICBIN      - Used to extract bin information.

    ICLOCATION - This file is used to validate the inventory location.

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


    RQLOC      - Used to validate requesting location.


Referenced Files

    APCOMPANY  - This file contains information for each Accounts Payable
                 company.


    APCPYVND   - This file contains default codes assigned a vendor or
                 alternate vendor location at the company level.


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


    APVENCLASS - This file contains all vendor class records for a vendor group.


    APVENGROUP - This file contains all vendor group records in the Lawson
                 Accounts Payable system.


    APVENLOC   - This file contains all location code records for alternate
                 vendor locations defined for accounts payable vendors.


    APVENMAST  - This contains accounts payable vendor records, including
                 one-time vendors defined during invoice entry.


    GLSYSTEM   - This file contains company information used by the Lawson
                 General Ledger system and subsystems.


    ICCATEGORY - Used in a Requisitions common routine.

    ICCOMPANY  - Used to validate company number.

    ITEMMAST   - Used to print the item description. Also returns unit of
                 measure conversion information.