on 2024 Nov 01 4:33 AM
Dear SAP GR Experts,
We have the following consolidation scenario:
G_1000 is the consolidation group for the full consolidation (3-level consolidation).
G_3000 is the consolidation group between D and E.
E is 100% owned by A = 63% via D + 37% directly owned by A.
Per our knowledge and experience, the 37% NCI of E should be posted against E during the consolidation process. However, our user requirement is to post the 37% NCI of E against the parent company, A.
Please help to share what would be the best solution for above scenario.
Thank you.
Edward.
Request clarification before answering.
If you are using new reporting logic, which means it is green field GR on S/4 HANA 1909 and onwards, the group is flat without hierarchy. So in "Sub" Group G_3000, it is between D and E, 37% NCI is tied to G_3000. For "Parent Group" G_1000, A owns E = 0.63*0.97 (indirect)+ 0.37 ( direct ) =0.98 -> 98%. NCI is 2% ties to G_1000 against.
G_1000 A->E 98%
A->D 97%
There is no A->D->E
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have 2 questions:
1. I believe that Group reporting can calculate Indirect share which is 0.63*0.97 since COI will calculate it automatically, but how to calculate the result of indirect share + 0.37 (as direct share)?
2. in G_1000 Group, if in consolidation unit "D", user will upload Trial Balance Consolidation which is the result of G_3000 and the trial balance will be consisted of the NCI value of 37% which is tied in "D" consolidation unit, thus the value of 0.37 will be posted twice in D and also in A.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.