Consolidate Summarized G/L Trx

General Ledger data that has been summarized within multiple individual "child" SRM companies, can be consolidated with the summarized data of a "parent" company, for the purpose of financial management reporting.
All companies must be in the same instance of Oracle for Texada SRM.

Note: This feature is available to an Oracle data base and on our SaaS servers.

The reports that utilize consolidated summarized data across companies include:

Parent/Child Setup for Consolidation:
To setup the parent/child relationship, copy the 'Parent Consolidation ID' code from the existing Parent company, found in the Summarize G/L Settings in the Company Posting Parameters, and paste it into the 'Consolidation ID' field for the Child company also found in the Summarize G/L Settings in the Company Posting Parameters.
A Parent company can have multiple children that can be consolidated, as well as being a Child or sub-set of another company.
Once the Consolidation ID is defined in the Child Company in the Company Posting Parameters then the Child will show in this G/L Consolidation table in the Parent company.

Note: For report results to be accurate all child companies must share the same account structure in Chart Of Accounts with the parent.

In preparation for consolidating, all children and parents first need to summarize account activity for the same accounting period dates using Summarize G/L For Financial Statements.
i.e. After summarizing the updated summarized dates in the Summarize G/L Settings in the Company Posting Parameters will match for children and parents.

Then this option can be used by the parent to consolidate the summarized data of its children with its own.

If there are sub layers of parents and children, work from the bottom up when consolidating. This means that any "lower" level parents need to each be consolidated using Consolidate Summarized G/L Trx before the higher level parent is consolidated.

Example tree structure of sub layers of parents and children:

                               A
                               |
       ------------------------------------------------
       |               |               |              |
       AA              AB              AC             AD <=="lower" level parents must
       |               |               |              |       be consolidated before higher
  -----------     -----------          |         -----------      level parent
  |    |    |     |    |    |          |         |         |
 AA1  AA2  AA3   AB1  AB2  AB3        AC1       AD1       AD2