BPC Periodic model - can a P&L account be translated at YTD rates

[dcanhnguyen]

In a BPC periodic model, can a P&L account be set to be translated at YTD rates?

E.g. rate for Jan is 3 and rate for Feb is 4

Value for Jan

Periodic: 100 YTD: 100

Value for Feb

Periodic: 100 YTD: 200

Can the YTD amount of 200 for Feb be translated at the rate for Feb? (4)

[dcanhnguyen]

Thanks Vadim!

FYI, I have used a script logic to work around it, the steps are:

1. Copy the LC of Audit trail 1 into Audit trail 2

2. Copy the LC of last month of Audit trail 2 into this month in Audit trail 2

So for periodic in Audit trail 2, the amount is equal to YTD in Audit trail 1. This amount is then translated at the YTD rate. After that at the translated currency level (e.g. USD), I just copy the USD from Audit trail 2 minus that of last month into Audit trail 1. This effectively gives YTD rates.

[former_member186338]

Sorry, but not clear.

[former_member186338]

Yes, copy from periodic to ytd model can be done using script logic:

*XDIM_MEMBERSET P_ACCOUNT AS %PL%=BAS(RootPandL)
*XDIM_MEMBERSET P_ACCOUNT = %PL%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET CURRENCY = LC
*XDIM_MEMBERSET MEASURES = YTD

*DESTINATION_APP = YTDmodel

*WHEN CATEGORY
*IS *
*REC(EXPRESSION = %VALUE%)
*ENDWHEN

P.S. Before copy it's better to clear scope in YTDmodel. Then you have to implement RUNLOGIC_PH badi to launch script in destination model.

[dcanhnguyen]

Thanks Vadim, I suspected that as well. I think I will have to use script logic to work around it then.

[former_member186338]

Sorry but in periodic model ytd value is calculated. You can't translate it.

You can create a ytd model and copy data from periodic to ytd model.