Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC130


IC130 - General Ledger Interface

**Form Purpose
Run General Ledger Interface (IC130) to update the General Ledger File with
inventory transactions processed in the Inventory Control (IC), Purchase Order
(PO), Requisitions (RQ), and Warehouse (WH) applications. This form produces
three reports, the General Ledger Transaction Register, General Ledger Posting
Report, and the General Ledger Summary Posting Report.

**Processing Effect
The General Ledger Transaction Register provides an audit trail of all
inventory transactions, such as issues, receipts, and transfers created in IC,
as well as the inventory transactions created by purchase order receipts and
adjustments and inspection rejections.

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.

For Retail Financial Reporting

As records are processed in IC130, they are checked against the MAFRXEXP
table to determine if that record needs to be processed for Retail Financial
Reporting. If it does, the PULL-FOR-FR-FL field on MMDIST is set to Y. Only
type PO and PT records are processed for Retail Financial Reporting. Then run
Build IC Financial Reporting File (IC131) to extract these records for use in
your non-Lawson retail system.




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.

    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.

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

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

    MMUAVAL    -

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

    TXCOMPANY  -

    TXTAXCODE  -


Referenced Files

    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.

    APACCRCODE -

    APCOMPANY  -

    APVENGROUP -

    BUYER      -

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

    CURELAT    -

    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    -

    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.

    ICBIN      -

    ICCATEGORY -

    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.

    ITEMSRC    -

    MACOMPANY  -

    MAFRXREF   -

    POLINE     -

    PORECADJLN -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    PURCHORDER -

    REQLINE    -

    RQLOC      -


INVOKED Programs

    API4
    ACAC
    ACCL
    IFCU
    IFSG
    IFAC
    SLSE
    SLSU
    IFFC
    IFGT
    GLCC
    IFAU
    IFOB
    IFRS
    IFSC
    SLSB
    SLSS
    IFJR
    POIF
    API3
    POIG
    POIM
    SLFD