Tallying Trial Balance in BPC EVDRE

[Former Member]

Hello Experts,

We are on SAP BO BPC 7.5 NW, SP07.

We have uploaded the Trial Balance directly from BI Infocube. In the transformation file, CREDITPOSITIVE=YES, therefore, in the backend BI signs remain as they are in SAP ECC but in EVDRE all credits (LEQ and INC) are positive, which is ok.

Now, when i run EVDRE for P/L items there is a balance is say INR 100 (FLOW=F_999) which is profit for the period. Similarly, when I run EVDRE for B/S items there is a balance of INR -100 (FLOW=F_999), therefore, overall TB balance is zero. When we upload data through BI, due to Default logic F_RES gets updated with INR -100. This is where the problem arises, if I see TB with F_999 and F_RES, I get a diff of INR -100. I am confused, if this correct. Kindly help remove my confusion. Secondly, should F_RES get updated with only I_NONE or with all Inter-company transations? I have commented I_NONE in the script logic below.

Thanks for all your help.

Below in my Default logic file

//----

---

// Calculating 10080 - F_RES: Net income of the period in the balance sheet

//----

---

// Information: [XDIM_MEMBERSET FLOW=<xx>] is mandatory in the default logic

*XDIM_MEMBERSET FLOW=F_RES

// F_RES must be included in order to enable difference calculation

//*XDIM_MEMBERSET IntCo=I_NONE

*XDIM_MEMBERSET Groups=NON_GROUP

*XDIM_MEMBERSET C_ACCT<>10080

*XDIM_MEMBERSET FLOW<>F_RES

// Excludes flow F_RES and account 10080 from the source data region

*WHEN C_ACCT.ACCTYPE

*IS "INC"

*REC(FACTOR=1,C_ACCT="10080",FLOW="F_RES")

*ELSE

*WHEN C_ACCT.ACCTYPE

*IS "EXP"

*REC(FACTOR=1,C_ACCT="10080",FLOW="F_RES")

*ENDWHEN

*ENDWHEN

*COMMIT

[Former Member]

Hi Rajat,

This is normal based on your description. Without updating your retained earnings with the total income statement value (100 in your case) the total trial balance will be 0. As soon as you update ret/ear your total TB will be out of balance by 100 as you describe.

This is not a problem. Either you look at your balance sheet which would be 0, or you look at your total TB excluding the ret/ear account, this will also be 0.

Tom.