Skip to Content
avatar image
Former Member

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

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 17, 2017 at 07:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2017 at 07:50 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 07:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2017 at 05:19 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded