Skip to Content
0
Former Member
May 05, 2010 at 08:52 PM

Data Validation (Asset = Liability) mismatch issue.

22 Views

Hi Experts

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

Script logic

*RUN_PROGRAM VALIDATION

CATEGORY = %C_CATEGORY_SET%

CURRENCY = %GROUPS_SET%

TID_RA=%TIME_SET%

OTHER=[ENTITY=%ENTITY_SET%]

*ENDRUN_PROGRAM

(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.

Thanks

Ritesh