IC170 - Freeze Selected Items Run this program to generate a freeze file for current item stock quantities. A freeze file is a snapshot of current records for a select ID defined in IC70.1 (Select IDs). After you create a freeze file you can print count sheets and/or tags in IC270 (Count Sheets) for recording purposes. Performing cycle counts using the Inventory Control system involves several steps. Actual counts are entered in IC72.1 (Counts by Page), IC73.1 (Count Detail), or IC74.1 (Random Counts). Item counts are updated to inventory when you run IC175 (Update Variances) in update mode. Prior to update you can run IC175 in nonupdate mode to print the Variance Report, then explain variances in any count entry form. After the update you must use IC76.1 (Variance Reasons) to explain variances. You must delete freeze records before you can use the select ID again for another physical inventory count. When you delete records depends on when you explain variances. If you explain variance prior to update, you can delete records in IC175 (Update Variances). If you explain variances after updating you must delete records in IC179 (Delete Freeze Records). If an item location is frozen, you cannot enter an inventory transaction with a transaction date less than the freeze date. However, you can enter a transaction with a transaction date equal to or greater than the freeze date. 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. ICCOMPANY - Used to validate the company number. ICFREEZE - ICFREEZE is the control record for the physical inventory counting process. ICSELECT - Used to determine the items to be frozen for counting for the physical inventory process. ITEMLOC - The Item Location file contains the dynamic information for an inventoried item at a stock location. 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 BINGROUP - Bin groups are used in the Physical Inventory module for selection of bins to be counted. BINGRPDTL - The Bin Group Detail file contains all valid bins associated with the bin group. 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. ICCATEGORY - The GL Account Category file is a master file that defines the inventory and offset general ledger accounts used to post inventory transactions. ICRECEIPTS - The cost history file which is used for LIFO and FIFO costing. ICRPTGRP - The Report Group file stores the valid report groups used to define groups of locations for reporting purposes. ITEMMAST - The Item Master file stores static information about each item such as description, classes, units of measure, and weight. ITSERIAL - This file stores the valid serial numbers currently in stock and issued. |