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