Skip to Content
0
Former Member
Feb 08, 2011 at 06:40 PM

OUTOFBALANCE Issue

39 Views

Hi experts ,

A quick change to only check at the TRIAL_BALANCE level rather than each individual data source,there might be a new bug in the logic engine causing the signed data function do not work.

The V_OUTOFBALANCE calculations uses like "If the data is greater than 100,post a 1 in the V_OUTOFBALANCE account.If the data is <-100,post a 1 in the V_OUTOFBALANCE account,If it is neither ,post a 0"

Now it is posting a 1 if the data is >0 or <0. It seems to be ignoring the >/< 100/-100 pats altogether.

Ex : Entity is out of balance by 240 in GL_INPUT data source and -180 in EXCEL_INPUT.Net they are +60 out of balance.This divided by 200=0.3.This 0.3 rounded to 0 decimal=0. Result =0 in V_OUTOFBALANCE .

Why is this changed neded?Is there any bug in the logic engine where it is no longer recognizing "WHEN SIGNEDDATA IS SUCH-AND-SUCH" commands.

But it does recognize"WHEN SIGNEDATA IS <>0".

So let's make sure our accounts are always either 1's or 0's for now.

Note : V_OUTOFBALANCE check for work status is calculating incorrectly after applying BCP 7 SP9 patch 1Any help,

regards

Ravi