I have a problem in Data Validation rule for Asset = Liability
I have created Validation Rule and SCript logic for data validation
1 ValDiff Asset=Liability = INTCO=NON_INTERCO FEB 0
Validation Rule detail :
1 ValDiff Asset Flow_Cl 1 Liab Flow_Cl 1 Asset=Liability
CATEGORY = %C_CATEGORY_SET%
CURRENCY = %GROUPS_SET%
(Note : Assets is main Group under that we have several sub groups and under that GLs, same with Liab)
If I run Data Validation with Above Configuration, I can run data validation, but when I see balance of Data Validation, Its huge and incorrect. ( Example If Asset = 100 and Liab = 120, ValDiff should be 20, but it shows completely diff wiered amount.)
But wher as if I try to replace Group Asset to Any GL account say 100000 and Liab to another GL sau 200000 and then try to run Data Validation, it shows proper difference value.
Kindly advise what could be the issue and how to resolve the same.