Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script logic to add YTD values

Hi,

The below logic works fine for calculating Account ACCPYCALC(Periodic)=PYACCRUAL(Periodic)PYACCRELEASE(Periodic)PYACCACT(Periodic).

But we need to caculate Account ACCPYCALC(Periodic)=PYACCRUAL(YTD)PYACCRELEASE(YTD)PYACCACT(YTD).

Please provide your inputs.

-


*XDim_Memberset FBCategory=ACTUAL

*XDim_Memberset FBAccount=PYACCRUAL,PYACCRELEASE,PYACCACT

*XDim_Memberset FBEntityCostCenter=CEGB1129310Q01

*XDim_Memberset FBRptCurrency=GBP

*XDIM_REQUIRED=FBYEAR

*XDIM_REQUIRED=FBTIME

*WHEN FBACCOUNT

*IS PYACCRUAL,PYACCRELEASE,PYACCACT

*REC(FBACCOUNT=ACCPYCALC)

*ENDWHEN

*COMMIT

Former Member
Former Member replied

What if you built a 2 stage process to aggregate the YTD account values into seperate accounts using Business Rules (CalcAccount), then use script logic to add the 3 accounts to the final account. Wouldn't that work just as easily.

hope this helps.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question