Skip to Content
0

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

Nov 17, 2017 at 05:46 AM

49

avatar image
Former Member

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)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Nov 17, 2017 at 07:20 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 17, 2017 at 07:50 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 17, 2017 at 07:57 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 19, 2017 at 05:19 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but not clear.

0