Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC170


IC170 - Freeze Selected Items

**Form Purpose
Run Freeze Selected Items (IC170) 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 application involves
several steps.

**Processing Effect
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.

**More Information
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.


INVOKED Programs

    ICI1