COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Controller => Topic started by: stutch on 24 Apr 2017 03:52:40 PM

Title: Intercompany Elimination
Post by: stutch on 24 Apr 2017 03:52:40 PM
Hi all,
I am just wondering if it was possible in Cognos Controller to produce a consolidated trial balance that either:
Right now, when a consolidated trial balance is run it is shown as below:

Entity A   Entity B   Entity C   Eliminations   Group Total
10                10     10                 5                25

Is it possible to either show it as:

1. Entity trial balance after intercompany eliminations; or

Entity A   Entity B   Entity C   Group Total
10               8                 7       25

2. Entity trial balance and the intercompany eliminations that are relevant to each company

Entity A    |    Entity A Elimination    |    Entity B    |    Entity B Elimination    |    Entity C    |    Entity C Elimination    |    Group Total
10                            -                          10                      (2)                             10                    (3)                                   25

Thanks