Consolidate Summarized G/L Trx


This is a maintenance utility that can be added to an Additional Options menu as it is not on a standard menu.

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:

Balance Sheet
Income Statement

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

Note: If Summarize G/L For Financial Statements is re-run for a parent company after the summarized totals have been consolidated using Consolidate Summarized G/L Trx, then the totals will have been refreshed for the parent, and are no longer based on the consolidated values.
i.e. If posting changes are made that need to be reflected in the reports re-run the complete summarize/consolidation process.
Topic Keyword: GLGL24
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)