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 GLADDRESS - Used by common library; not referenced in this program. GLAMOUNTS - Used to access posting account balances. GLCHART - Used by common library; not referenced in this program. GLCONSOL - Used to access consolidated account balances. 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. INVOKED Programs IFSG |