Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GL141


GL141 - Consolidation Unload



Run Consolidation Unload (GL141) to consolidate financial information
for a general ledger company that processes General Ledger transactions
on more than one machine by transferring balances and transaction
data. This process creates summarized balance information on the target
machine for each posting account for a fiscal year.



**Processing Effect


UNIX platform: This program creates a work file of balance data.
Balances come from the General Ledger Consolidation (GLCONSOL) file.
Transaction data comes from the Currency Amounts (CUAMOUNT) file,
General Ledger Units (GLUNITS) file, or both.

If you are transferring Balance information, GL141 creates the
following work file: $LAWDIR/productline/work/mastrel.csv

If you are transferring Transaction information, GL141 create
the following work file: $LAWDIR/productline/work/transrel.csv



IMPORTANT  If you choose to summarize data using GLCONSOL and
you have non-base transaction amounts, these values will NOT be maintained.
The transaction amount and the transaction currency will default to
the base amount and base currency. If the data contains transaction
currency amounts, you will want to use the level 5 posting option
in the Consolidate Level field to maintain the integrity of the amounts.


System i platform: This program creates a work
file of balance data. Balances come from the General Ledger Consolidation
(DBGLGCN) file. Transaction data comes from the Currency Amounts (DBGLCAM)
file, General Ledger Units (DBGLGLU) file, or both.

If you are transferring Balance information, GL141 creates the
following work file: LAWDIR/productline/work/mastrel.csv

If you are transferring Transaction information, GL141 create
the following work file: LAWDIR/productline/work/transrel.csv



IMPORTANT  If you choose to summarize data using DBGLGCN and
you have non-base transaction amounts, these values will NOT be maintained.
The transaction amount and the transaction currency will default to
the base amount and base currency. If the data contains transaction
currency amounts, you will want to use the level 5 posting option
in the Consolidate Level field to maintain the integrity of the amounts.







Updated Files

    ADDRDATA   -

    CKPOINT    -


Referenced Files

    CUAMOUNT   -

    GLADDRESS  -

    GLAMOUNTS  -

    GLCGCPY    -

    GLCHART    -

    GLCONSOL   -

    GLCPYGRP   -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLUNITS    -

    INSTCTRYCD -

    WFSETUP    -


INVOKED Programs

    IFOB
    IFSG