Data Validation (Asset = Liability) mismatch issue.

[Former Member]

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

[Former Member]

Any Updates Experts??

[Former Member]

Hi,

If you are trying in your test system.. try this solution had seen in NW sometimes bpc infocube dont gets rolled up until we do the optimisation in the front end.. have nt got any clue for the reason but never seen in live system.

regards

suresh rao

[Former Member]

Hi Ritesh,

You can try looking at the below point (may not be th case but worth looking)

The asset and liability are members of your GL account dimension. They will have a property ACCTYPE. Based on this ACCTYPE, any asset member will have the values as negative and any liability will have the value as positive. This might be a reason for having a huge difference.

I hope this helps.

[Former Member]

Well

I ll look in to that but to tell u When I take only individual GLs i.e. One Asset GL and One Libility GL, It works..