account type INC and EXP

[Former Member]

Hello,

one question regarding account type in P&L Planning.

we calculate Revenues like Amount(EXP) * Price(EXP) = Revenue (INC)

20 * 3 = - 60  --> revenue Accounttype = INC,

for retraction to ERP I also want to retract - 60 (negativ Value) but ia TA LISTCUBE my planed revenues are stored +60. (in BPC EXCEL Frontend they are negativ (-60)

revenues account is INC.

now when I retract data to ECC, I have positiv revenues - but I need negative Revenues to be in line with SAP general logic. do you have a recommendation to solve this issue in a smart way?

Is there any recomandation or experience to solve this problem?

coding

*XDIM_MEMBERSET VERSION=%VERSION_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS %TIME_SET%

*WHEN P_ACCOUNT

*IS 930000484100

*REC(EXPRESSION=%VALUE%*[P_ACCOUNT].[900000484100],P_ACCOUNT="10000000484100")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

930000484100 = EXP (Amount)

900000484100 = EXP (price)

10000000484100 = INC (p&l revenues Account)

[former_member186338 · Accepted solution]

There is no issue, just you have to understand that revenue is NEGATIVE! And in BW it has to be stored as NEGATIVE!

Your script (launched by DM package) has to be:

...

*REC(EXPRESSION=-%VALUE%*[P_ACCOUNT].[900000484100],P_ACCOUNT="10000000484100")

...

-%VALUE%!!!

Vadim

P.S. Please don't use absolutely useless COMMIT!

[former_member186338 · Accepted solution]

"(in BPC EXCEL Frontend they are negativ (-60)" - In the report - has to be POSITIVE!

[former_member186338 · Accepted solution]

Sample (In BW):

Revenue: -60 (INC)

Expenses: +40 (EXP)

Net Income: -20 (INC)=-60+40