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 AD2Note: 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.
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |