Question Re: Dynamic script calculation on St Date and En Date in Financial Management Q&A

Dynamic script calculation on St Date and En Date

BalaValluru — Thu, 11 Apr 2019 09:15:24 GMT

Dear Experts,

We have a scenario, were logic based on start date and end date of PO. Calculate the logic (total area* rate per sf= Base Rent) and post respective time periods dynamically.

Total area and rate per sq ft and Base rent are Account dimension members

Start date and End date maintained properties in PO dimension.

can some one help to post results dynamically to time period based on st date and ed date.

Thanks

Kishore V

Re: Dynamic script calculation on St Date and En Date

former_member186338 — Thu, 11 Apr 2019 09:38:36 GMT

Sorry, but do you really using SAP Business Planning and Consolidation, version for the Microsoft platform ????

Re: Dynamic script calculation on St Date and En Date

BalaValluru — Thu, 11 Apr 2019 09:42:01 GMT

vadim.kalinin

🙂 sorry wrongly tagged to MS version now corrected

Re: Dynamic script calculation on St Date and En Date

former_member186338 — Thu, 11 Apr 2019 10:03:17 GMT

It's possible to create a script logic that will perform required calculations for SINGLE PO!

//PO - dimension purchase order
//%PO_SET%=PO1 - single value
*SELECT(%START%,START_DATE,PO,ID=%PO_SET%)
*SELECT(%END%,END_DATE,PO,ID=%PO_SET%)
*SELECT(%STARTTID%,TIMEID,TIME,ID=%START%)
*SELECT(%ENDTID%,TIMEID,TIME,ID=%END%)
*SELECT(%PERIODS%,ID,TIME,TIMEID>=%STARTTID% AND TIMEID<=%ENDTID%)
//%PERIODS% - target periods between dates
...

But to process multiple PO you will have to execute this script using RUNLOGIC_PH badi with CHANGED parameter - PO (so the script will be executed for each PO member separately). For sure the performance will be awful!!!!

For this requirements the right solution is to develop CUSTOM LOGIC Badi!

Re: Dynamic script calculation on St Date and En Date

BalaValluru — Thu, 11 Apr 2019 10:58:25 GMT

vadim.kalinin

Thanks Vadim for providing code for dynamic Time calculation . Can I extend below to your code for results Total Area* Rate Sqft = Base_Rent. I will this scenario for single PO and let me check the performance.

*XDIM_MEMBERSET CATEGORY=FORECAST
*XDIM_MEMBERSET PURCHASEORDER=P1234567
*XDIM_MEMBERSET AUDITTRAIL=Input

*WHEN ACCOUNT
*IS Total_Area
*REC(EXPRESSION=%VALUE%*[ACCOUNT].[Total_Area],ACCOUNT=Base_Rent,AUDITTRAIL=Input_BR)
*ENDWHEN

*WHEN ACCOUNT
*IS Rate_Sqft
*REC(EXPRESSION=%VALUE%*[ACCOUNT].[Rate_Sqft],ACCOUNT=Base_Rent,AUDITTRAIL=Input_BR)
*ENDWHEN

Re: Dynamic script calculation on St Date and En Date

former_member186338 — Thu, 11 Apr 2019 11:04:31 GMT

valluru

Looks like you don't want to read my answer to the end!

Script logic will not work for multiple PO members processing!

Use custom logic badi!

Re: Dynamic script calculation on St Date and En Date

BalaValluru — Thu, 11 Apr 2019 11:20:26 GMT

vadim.kalinin

yes, I understood that your suggesting Custom_BADI. We have only less then 10 PO 's at present.

Trying to achieve in Script:)

Thanks

Kishore V

Re: Dynamic script calculation on St Date and En Date

former_member186338 — Thu, 11 Apr 2019 11:24:40 GMT

valluru

Only very bad consultants assume that the number of PO will not increase! Sorry!

Re: Dynamic script calculation on St Date and En Date

BalaValluru — Thu, 11 Apr 2019 11:42:24 GMT

vadim.kalinin

These are related to Rent on property business will not increase every time. Not regular one PO

Re: Dynamic script calculation on St Date and En Date

former_member186338 — Thu, 11 Apr 2019 12:44:45 GMT

If you have only 10 PO, then instead of script logic create EPM input form and perform calculations using Excel formulas 🙂