Forum Discussion

YanSavinsky's avatar
YanSavinsky
New Contributor III
1 year ago

Calculated IC Account Balance Not Elliminating

I have an issue I would be very interested in getting community's take on and I would greatly appreciate any direction:

I am trying to deal with the case of a nested ownership: one  of our 100% owned subs owns a minority stake in the other sub, At the top consolidated level there should be no Minority Interest , but at intermediary consolidated level there should be. I created an intercompany account that is calculated at that intermediary consolidated level. Calculation seem to work fine. However, when consolidation reaches the first common parent between the 2 subs, elimination of this new account is not being triggered, even though correct partner is assigned (IC Matching report matches the relevant amounts)

Here is the calculation:

If (api.Cons.IsRelationshipLevel And api.Entity.OwnershipType().ToString = "Custom1")
	
	Dim entityID As Integer = api.POV.Entity.Memberpk.Memberid
	Dim parentID As Integer = api.POV.Parent.Memberpk.Memberid
	Dim pOwn As Decimal = api.Entity.PercentOwnership(entityID, parentID)
'	Dim entityName As String = api.Pov.Entity.Name.ToString
	Dim entityName As String = api.Entity.Text(8)	
	
	api.Data.Calculate("C#Elimination:A#399600_IC:F#EndBalCalc:I#" & entityName & ":O#Elimination = C#Local:A#EquityToCommon:F#EndBalCalc:I#None:O#Top * " & (1 - pOwn/100))	
	api.Data.Calculate("C#Elimination:A#399999000:F#EndBalCalc:I#None:O#Elimination = C#Local:A#EquityToCommon:F#EndBalCalc:I#None:O#Top * " & (1 - pOwn/100) * -1)
	
End If

 

399600_IC is the Minority Interest Account

399999000 - is the plug account

Here is the level where Minority Interest is calculated.

 

Here is the "first common parent" level:

 

Workflow IC Matching

 

 

 

Finance
XFBR

4 Replies

  • KarlT's avatar
    KarlT
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    Hi

    Have you done any error logging to check whether the system is executing this calculation on the expected data units? Where is this calculation included (i.e. member formula, business rule, custom elimination script)?

    Regards,

    • YanSavinsky's avatar
      YanSavinsky
      New Contributor III
      1 year ago

      Thank you for the reply, Karl.

      The calculation of the Intercompany Minority Interest is done via member formula and is triggered by a spesific value (Custom1) in the "Ownership Type" property of the partially owned entity. The amount is being correctly calculated and correct IC partner is being assigned. However the IC elimination is not happening for this amount at the first common parent level and we are struggling with why.

      We do not use custom elimination logic, relying instead on the standard IC elimination functionality, which works fine in all the other cases.

      I looked through both error log and task log and I cannot see anything related to the issue. However, I might not be technically savvy enough to understand the logs completely.

      • KarlT's avatar
        KarlT
        Icon for OneStream Employee rankOneStream Employee
        1 year ago

        Okay - If i'm understanding you correctly, your member formula in the screen shot above is executing and you want the results of that to then be eliminated later at the common parent?

        If that's the case, i suspect the issue is that you're writing the result to O#Elimination. I don't believe this will be picked up by the standard consolidation for eliminations.

        regards,