Forum Discussion

DCarrillo's avatar
DCarrillo
New Contributor III
7 months ago

USD Override is aggregating with translated balance

I created a USD Override form, however the translated value and the override value are both getting to the Top member. I was expected the override value to be getting to Top.  Here is the fo...
Consolidation
Henning's avatar
Henning
Valued Contributor II
7 months ago

Hi, the first thing you might want to do is to set the aggregation weight of your override member to 0, this way this does not roll up into the top member (assuming a standard setup):

 

And you might want to clear the translated data on your closing member when you execute the override translation for USD. There are different ways, but I guess in your case this seems easiest. E.g.

Api.Data.ClearCalculatedData("F#EndBal_Input", False, True, False)

 

And I do not follow what you describe around A#399500. I hope the above helps, otherwise I would need some more information.