Hi Experts,
We have a scenario where we need to report on sub-consolidations. We have 200+ Cons Units and a statutory and management view and sub-cons within them.
Where there is a parent holding an investment in a sub, I understand we will need to setup a CG.
However, for just intercompany elims - how do we avoid setting up cons groups for each sub-consolidation sub-grouping?
A simple example: In the statutory view there is CU 1-7 where CU 3 is the parent of 4 & 5. Graphical below.
If we want to report on consolidated 3 group - this would mean that we have to setup CG-A: 1-7; CG-B for 3 4 and 5.
If I run on CG1 and select 3,4,5 or a CU hierarchy included 3 4 and 5, in Group Data Analysis, I believe the result will display consolidated including eliminations for any CU in CG1 not just 3,4,5.
Asking since we are working with Group Reporting 2023 OP FP01
GRDC is not available, and the site updated from EC-CS where Cons Group hierarchies are successfully used to meet this requirement.
Multiply this requirement by sub-cons for both statutory and management (with 5 sub-groups) and the result is many Cons Groups to run consolidation and roll forward every year.
How do we avoid creating all this effort for the users?
They will need to run tasks and reconcile data.
Regards,
Eyal
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.