GL141 - Consolidation Unload
Run GL141 (Consolidate Unload) to consolidate and transfer financial
information for a general ledger company that processes transactions on more
than one machine. You can transfer period balance data, which creates
summarized balance information for each posting account for a fiscal year to
transfer summarized transaction data, which creates summarized balance
information for each posting account for each period of a fiscal year.
TRANSFERRING PERIOD BALANCE DATA
GL141 creates a work file of balance data from the General Ledger Amounts
(GLAMOUNTS) file, General Ledger Consolidation (GLCONSOL) field, and General
Ledger Units (GLUNITS) file. 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
Move the work file to the target machine, and then use an import command to
load the data into the General Ledger Balance Conversion (GLMASTREL) database
file. This creates a run group called GL141. Run GL167 (Balance Conversion) to
convert the records in the General Ledger Balance Conversion (GLMASTREL) field
to create records in the General Ledger Amounts (GLAMOUNTS), General Ledger
Units (GLUNITS), and General Ledger Consolidation (GLCONSOL) files.
TRANSFERRING SUMMARIZED TRANSACTION DATA
GL141 creates a work file of balance data from the General Ledger Amounts
(GLAMOUNTS) file, General Ledger Units (GLUNITS) file, or both. GL141 creates
the following work file:
$LAWDIR/productline/work/gl141D/gl141D
Move the work file to the target machine, and then use the import command to
load the transaction data into the General Ledger Transaction Conversion
(GLTRANSREL) file.
This process creates a run group called GL141. Run GL165 (Transaction
Conversion) for the run group to convert the transaction data to the General
Ledger Transaction (GLTRANS) file, and then run GL190 (Journal Posting) to
post converted transactions on the target machine.
Updated Files
CKPOINT - Used for report updates, not used for restart.
Referenced Files
CUAMOUNT -
GLADDRESS - Used by common library; not referenced in this program.
GLCGCPY -
GLCHART - Used by common library; not referenced in this program.
GLCONSOL - Used to access consolidated account balances.
GLCPYGRP -
GLMASTER - Used to validate posting account information.
GLNAMES - Used to validate accounting units.
GLSYSTEM - Used to validate companies.
GLUNITS - Used to access posting account unit balances.
WFSETUP -
INVOKED Programs
IFSG
|
