Skip to main content
B
BCG
May 19, 2023

Subsidiary Consolidation

  • May 19, 2023
  • 1 reply
  • 0 views

Hi Experts,

I have subsidiary entity where it needs to be consolidated 100% but with other line of adjustments as below

NCI calculation on equity portion/Share capital elimination.

in HFM, We used to write on default consolidation rule first and then method specific rule on top of this

if same thing is to be applied in Onestream, can i follow as below ?

If entity method is subs then

Step1 api.ExecuteDefaultShare() to consolidate every account 100% firstly

User defined tagging=> Text tagging to Equity related accounts to pull accounts for NCI portion calculation.

Step2 Text specific Source accounts are reversed with Minority portion(%) into Elimination member and same writing to offset NCI account into the Elimination member like HFM ??

 

 

    1 reply

    C
    ChristianW
    May 19, 2023

    Yes, in principle it works the same way as in HFM. You calculate the share/proportion in the share section, if you don't need special treatment like a change in scope of consolidation flow, you can use api.ExecuteDefaultShare() to populate share. And then you can write a custom rule for equity accounts.

    B
    BCGAuthor
    May 19, 2023

    Thank you so much for the explanation ChristianW

    Kindly also help understand which combinations I need to take to store the elimination values for Origin & Consolidation dimensions especially with these node level calculation. for instance we pass the values in HFM parent total into elimination with reversal of proportion for equity accounts and offset them into NCI accounts to show them separately into Equity section of BS

    C
    ChristianW
    May 19, 2023

    The consolidation dimension is set by the dataunit.

    Origin member Elimination can only be used, if the business rule runs in the c#elimination dataunit.

    Typically you run it in the

    Case Is = FinanceFunctionType.ConsolidateElimination

    section of the Finance Business rule (or better in a sub-procedure).

    So you only need to set the origin dimension:

    O#Elimination

    or

    TargetCell.DataBufferCellPk.OriginId = dimconstants.Elimination

    By the way, there is also an "api.ExecuteDefaultElimination" command, that runs the intercompany elimination for you.

    Terms & ConditionsAccessibility statement