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