Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC175


IC175 - Update Variances

**Form Purpose
Run Update Variances (IC175) to update physical inventory counts to the
Inventory Control application and print the count variance report.

**Processing Effect
This program compares freeze quantities created in IC170 (Freeze Selected
Items), with item counts entered in IC72.1 (Counts by Page), IC73.1 (Count
Detail), and/or IC74.1 (Random Counts) and creates variance transactions for
any variances found. Variance transactions are updated to the General Ledger
application when you run IC130 (General Ledger Interface).

**More Information
To run this program you must enter the company, select ID, and update option.
Item counts are updated to inventory and variance transactions are created for
general ledger when you run this program in update mode. Before update, you
can run this program in nonupdate mode to print the variance report, then
explain variances by reason code in any count entry form (IC72, IC73, or
IC74). After update you can only explain variances in IC76.1 (Variance
Reasons).

This program also lets you delete freeze records. You must delete freeze
records for a select ID 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 variances prior to update, you can delete records
when you run this program in update mode. If you want to explain variances
after update, you must select not to delete records in this form and run IC179
(Delete Freeze Records) to delete freeze records after variances are
explained.

Note This program creates negative stock-on-hand quantities only if your
company is set up to allow negative stock-on-hand. If your company does not
allow negative stock-on-hand, this program prints a list of all items that
would have been adjusted negatively. It does not update the variance.




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.

    ICACCURACY - Used to track the accuracy of the physical inventory process.

    ICCOMPANY  - Used to validate the company number.

    ICFREEZE   - ICFREEZE is the control record for the physical inventory
                 counting process.

    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.

    ICSELECT   - Used to determine the items to be frozen for counting for the
                 physical inventory process.

    ICTRANS    - Contains all the inventory transactions entered in the
                 Inventory Control system.

    ICTRANSDTL - The Inventory Transaction Detail file is created for lot or
                 serial number tracked items or for a multiple bin or unit of
                 measure transaction.

    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

    GLADDRESS  - This file contains the name, address, and communication
                 numbers for the company and needed accounting units.

    GLCHART    - This file contains chart and system account information in the
                 General Ledger system.

    GLCODES    - This file holds information relating to systems, source codes,
                 folders and process groups.

    GLSYSTEM   - This file contains company information used primarily by the
                 General Ledger system, but is also referenced by Lawson
                 subsystems.

    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.

    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.


INVOKED Programs

    ICI1
    IFAC
    ACAC
    ACCL
    API4
    IFCU
    IFSG
    SLSE
    SLSU