Non-controlling Interest of Grand-child to be posted to the Parent company

[edwardcs]

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.

[HengyeZhu · Accepted solution]

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

[Annafri · Accepted solution]

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. 

[HengyeZhu · Accepted solution]

Please refer to KBA 2946165 - Group Reporting: Flat list of consolidation groups in Data / Consolidation Monitor

[edwardcs · Accepted solution]

Many thanks Henye for your prompt response. I will check your proposed solution and comeback in couple of days

[edwardcs · Accepted solution]

Hi HengyeZhu, can you please ellaborate this 'NCI is 2% ties to G_1000 against' ? Is it possible to post the NCI 2% against D? Thanks in advance