script logic issue??

[former_member225916]

Hi All,

*WHEN FB_ACCOUNT

*IS 20100

   *WHEN FB_MONTH

  *IS 2013.APR

*REC(EXPRESSION = %VALUE%* 0.1119*1/12,FB_ACCOUNT=30900,FB_DATASRC=LEVELS)

   *ENDWHEN

in the above logic, 20100(source) is AST type and 30900(destination) is INC type.

While i was running the evdre report, i was getting data with Negative sign.

               2013.APR        2013.MAY      2013.JUN

30900    -4407.063568   -8856.430081  -13325.79297

Can anybody pls help me how logic executed and why it showing negative values??

Thanks and Regards,

Naidu

[Former Member · Accepted solution]

Hi Naidu,

In BPC INC and LEQ are stored in negative signs (or reverse sign). So account 20100 (AST)must have positive number and when it is going to account 30900 (INC) its sign is getting reversed.

For more details, please refer the following link:

http://scn.sap.com/docs/DOC-26973

Hope this helps.

Regards,

Kalyan.

[Former Member]

Hi Naidu,

Currently you are working on AST Account that's store in BPC Database having sign that is multiply with any positive Data it will place in INC Account as sign - value.  For that u will use multiply with Negative Data then it is store as Positive value in INC Account.

Hope it will help you.

Regards,

Vinod Kumar.

[former_member186498]

Hi Naidu,

remember that INC and LEQ are stored with minus sign, so the data will be stored on reverse sign respect to AST and EXP.

Kind regards

     Roberto