need to change the data status in Impacted into an insertion point rule
I put a custom calculation into the FCCS_10 insertion point rule. This calculation calculates a ratio for an entity (B) based on the account values inserted on another entity (A). I try to explain better with a example:
- Entity "A" declares values for intercompany revenues and expenses on icp entity "B":
- expense = 1000 on ICP_B, revenue = 1500 on ICP_B. The ratio is (1500-1000)/1500 = 0.33. On the insertion point rule, I write this ratio directly on entity B. This calculation works to me.
Unfortunately, if entity B has a data status OK before entity A changes values on those accounts, the ratio is not updated on entity B because during a Consolidate, FCCS calculates only the entities with data status "Impacted".