Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

IC130

IC130 - General Ledger Interface

Run this program to update the General Ledger File with inventory
transactions processed in the Inventory Control system. This form produces
three reports, the General Ledger Transaction Register, General Ledger Posting
Report, and the General Ledger Summary Posting Report.

The General Ledger Transaction Register provides an audit trail of all
inventory transactions, such as issues, receipts, and transfers created in the
Inventory Control system. The General Ledger Posting Report lists the general
ledger transactions created as a result of these transactions and prints in
company, posting date, document type, accounting unit, and account number
sequence. The General Ledger Summary Posting Report summarizes totals for the
company, accounting unit(s) and general ledger account(s) and lists general
ledger transaction in company, intercompany, accounting unit, and posting date
sequence.

This form requires you to print reports in report or update mode and specify
a post through date. You have the option to summarize transactions by general
ledger account or post transactions in detail. If you print in report mode you
can review general ledger transactions before they are updated to the general
ledger interface file. Otherwise, you can update the general ledger file
immediately.

This form only posts transactions with a general ledger posting date less
than or equal to the specified post through date. The general ledger posting
date indicates which general ledger period to post transactions. If the
posting date is earlier than the current general ledger period, transactions
backpost if the appropriate general ledger period is open. Otherwise,
transactions post to the current general ledger period. If the posting date is
later than the current general ledger period, transactions remain on the
general ledger file until the appropriate general ledger period becomes
current.

Updated Files

    ACCOMMIT   - This file contains commitments not yet posted to the general
                 ledger.


    ACCOMMITX  - This file contains commitment details that have not yet posted
                 to the general ledger.


    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.


    ICHISTORY  - The Transaction History file contains the history of an item's
                 inventory transactions summarized by transaction type and
                 period or year.


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


    MMDIST     - This record holds an account number and possibly an activity
                 code intended for a general ledger distribution of an inventory
                 item.


    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.


    SYSTEMCODE - This file contains system code information used for remote
                 site processing.



Referenced Files

    ACACCTCAT  - Used to validate account categories maintained in the Activity
                 Management system.


    ACACTGRP   - Highest reporting level in the Activity Management system.

    ACACTIVITY - Used to validate the activities maintained in the Activity
                 Management system.


    ACCAL      - Contains calendar information from the Activity Management
                 system.


    ACCALX     - Contains detail calendar information from the Activity
                 Management system.


    AMASSET    - Used to validate the asset numbers maintained in the Asset
                 Management system.


    AMTEMPLATE - Used to validate the asset template numbers maintained in the
                 Asset Management system.


    CUCONV     - This file maintains rate tables for each defined currency
                 relationship.


    CURELAT    - Used to validate currency relationships.

    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.


    GLINTCO    - This file contains interzone and intercompany relationships.

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


    ICCOMPANY  - Used to validate the company number.

    ICLOCATION - Used to validate the inventory location.

    ITEMLOC    - The Item Location file contains the dynamic information for an
                 inventoried item at a stock location.


    ITEMMAST   - The Item Master file stores static information about each item
                 such as description, classes, units of measure, and weight.



INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFFC
    IFGT
    IFOB
    IFRS
    IFSC
    SLSB
    SLTV
    SLFD