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