Using Value ECT causes calculation to be run twice
Hi all,
I wrote a validation rule that calculates the difference between a balance sheet account and a movement account. After running calculate using process control screen; validation is not calculated properly. Only after running force calculate right after calculating, the validation works fine.
validationdifference = HS.GetCell("A#BS20714000.C2#[None].V#<Entity Curr Total>"&topsxc2) - HS.GetCell("A#BS20714000.C2#MOV_TNG.V#<Entity Curr Total>"&topsxc2)
Detailed explanation is below.
- Balance sheet accounts have adjustments over Entity Currency figures, so IFRS figures sit on <Entity Curr Total> Value member. First line in the table below.
- But for movements IFRS figures are manually entered so they have no adjustments.