Trial Balance , Income Statement from GL Consolidated Company (Holding Company) Company wise

SUGGESTED

HI,

We have a group of companies having one Holding company and 14 companies. we are using Sage 300 GL Consolidation and it is working fine. we have Created a Source Code for each Company like (ZC-01 for company A, ZC-02 for Company B, and so on). when we do the GL Consolidation we are able to extract only one Trial Balances and Financial Statements.

Secondly, we are using the same chart of accounts Across all companies so the data is going to one GL Account if the same account is used in multiple companies. the GL Transaction listing is showing the Correct Source Code (Company Code ZC-01 or ZC-02) but when we do the financial rollover then it is processing with one source Code GL-CL and then we are not able to split the TB based on the companies. 

the same thing is happening with Revaluation as well. 

Is there a way that we can take at least we generate the Trial Balance from the Holding company.