Please see attached images from the "Entity Details" window - we are seeing situations in our HFM 11.1.2.1 app where the total value of an account in a parent entity does not equal the sum of its children.
Normally, we see this with intercompany accounts that eliminate, but that's not the case here - this is occurring with non-IC Backlog accounts with roll-forward calculations.
If we view the "Entity Details" from other accounts for the same entity, such as NetIncome or Assets, then we have the sum of the children equal the amount we see in their parent, as normally expected.
The backlog calculations were initially not well-written (back in ~2004!). For example:
HS.Exp "A#BegBklgCalc=A#EndBklg.S#Actual.P#Last.Y#Prior"
Of course, we know nowadays that to prevent an "explosion of data", it should have been more like:
HS.Exp "A#BegBklgCalc<Entity Currency>=A#EndBklg.V#<Entity Curr Total>.S#Actual.P#Last.Y#Prior"
I have now revised the rules to follow that best practice, but there was residual data in <Entity Curr Adjs>, so before the above line, I had to add:
HS.CLEAR "A#BegBklgCalc<Entity Curr Adjs>"
I mention this because this may have something to do with [Contribution] and/or [Proportion] not staying equal to <Entity Curr Total> or [Parent Total], but I'm not certain.
I've searched all over, but I've not found many discussions on how [Contribution] is determined.
As for [Proportion], I suspect that is related to the Equity Pickup Module but we are not using that feature (if we were, other accounts for
the same entity, such as NetIncome or Assets, would also not sum up properly, but they do, and the “Entity Details” screen looks normal for all accounts
except these backlog accounts).
So I'd love to hear from anyone with thoughts on what, besides the Equity module, causes [Contribution] and/or [Proportion] to deviate from <Entity Curr Total> or [Parent Total], and more importantly, how do I stop this from happening.
Could I/should I run a HS.CLEAR on BegBklgCalc for [Contribution] and/or [Proportion], and if so, what's the syntax?