GL Multi Company Consolidation

Setup

1. In the financial statement format within the consolidated company, you need to have this command:

   SET FORMAT Company Consolidation YES

2. Within the consolidated company, the tables GLTACCT, GLTACGRP and GLTTRX must be left empty.
3. Within the consolidated company, the GLTPERIOD table must be properly setup. This table will be copied to each of the companies that are to be consolidated.

Printing Financial Statements

1. Start Financial Statements
   1. Set Date and other setting on the Option Tab
   2. Select appropriate reports on the Report Selection Tab
2. Select Consolidation Settings Tab
   1. Check each company desired
   2. Set a modifier for each company (e.g. 1,2,3)
   3. Setup G/L Account Mask using lower case c to represent the company modifier. e.g. c.##.#### for company 1

Processing

1. The tables Z$GLTCONSTRX (current session only), GLTACCT and GLTACGRP within the consolidated company are cleared.
2. For each of the companies to be consolidated:
   1. The GLTPERIOD table is copied from the consolidated company.
   2. The G/L groups are added to the consolidated company.
   3. The G/L accounts are added to the consolidated company, applying the account mask defined in the system options using the "Modifier" column from the "Consolidation setup" grid.
   4. The G/L transactions are added to the consolidated company, applying the account mask defined in the system options using the "Modifier" column from the "Consolidation setup" grid.
   5. The GLTPERIOD table is cleared.
3. The financial statement is printed.
4. The Z$GLTCONSTRX is cleared (current session only.)