Creating Custom Balancing rule in FCC
Summary:
Custom Balancing insertion point rule to replace OOB does not return correct value and returned vlaue does aggregate/consolidate to parent entities.
Content (required)
I am attempting to create a custom balance rule in FCC. The rule has been created as an insertion point and runs as part of the consoldiation. The consoldiaton runs and the AC_Balance_Validation accounts is populated, however the data is not correct and the account balance does not aggregate/consolidate to the parent. I have isolated the incorrect data to the equity portion of the rule. I was unable to use *FIX(@REMOVE(@RELATIVE("AC_Unallocated_Ret_Earn",0),"AC_Balance_Validation")) as the consoldiation would not complete. I modified my rule to add the accounts to the right hand side of the equation and for the equity section I included