Consolidation Unload (GL141)

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

Note: 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.

IBM 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

Note: 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.