Skip to Content
avatar image
Former Member

Logic script for Currency conversion in SAP BPC 10.1 NW using PVA method for P&L

Hi, in IFRS consolidation as per the business requirement, currency conversion has to be done using different methods for BS & P&L accounts .for conversion of BS accounts they are using VAL method and for P&L accounts PVA method.

for balance sheet account:

for P& L account:

P&L will be calculated as:

P01= 100/0.5 =200

P02= 300-100=200/0.6=333+200=533

P03= 600-300=300/0.7=429+533=962

To achieve above calculation Script i have written is :

*XDIM_MEMBERSET TIME = %TIME_SET%,TMVL(-1,%TIME_SET%)

*WHEN ACCOUNT.ACCTYPE

*IS "INC", "EXP"

*REC(EXPRESSION = %VALUE%-[TIME].TMVL(-1,%TIME_SET%),[TIME] = %TIME_SET%)

*ENDWHEN

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %VERSION_SET%

GROUP = %SCOPE_SET%

OTHER = [ENTITY = %ENTITY_SET%]

FXRATENTITY = GLOBAL

*ENDRUN_PROGRAM

*WHEN ACCOUNT.ACCTYPE

*IS "INC", "EXP"

*REC(EXPRESSION = %VALUE% + [TIME].TMVL(-1,%TIME_SET%),CURRENCY = EURO,[TIME] = %TIME_SET%)

*ENDWHEN

Please help me to write the logic script for the same.or what can be done in sap bpc 10.1 nw to achieve this

pl.png (12.6 kB)
bs.png (11.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 05, 2017 at 03:41 PM

    Sorry, but looks strange...

    Have you read about "Periodic Calc" in the rule setup?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2017 at 03:35 PM

    Looks like you don't understand what I am talking about!

    For P&L accounts use rule like:

    With Periodic Calc checked you will have the required results like in your report in the original question without any extra script.

    Sample result:

    With rates:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2017 at 08:36 AM

    Hi Vadim,

    Thanks for your reply. Can i add business rule to achieve this where :

    P&L will be Coverted as:

    P01= 100/0.5 =200

    P02= 300-100=200/0.6=333+200=533

    P03= 600-300=300/0.7=429+533=962

    And BS accounts ll converted as:
    P01= 100/0.5 =200

    P02= 300/0.6=500

    P03=600/0.7=857

    Please help us resolve this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2017 at 01:52 PM

    Hello Vadim,

    I checked the SAP notes.thank you for those.

    This business requirement can be achieve with logic script i feel.I am trying to shorten the scope. so scoped time dimension.Getting error in ujkt: UJK_VALIDATION_EXCEPTION:Invalid TMVL return value

    *XDIM_MEMBERSET TIME = 2010.02,TMVL(-1,%TIME%)

    *WHEN ACCOUNT.ACCTYPE

    *IS "INC", "EXP"

    *REC(EXPRESSION = %VALUE%-[TIME].[TMVL(-1,%TIME%)],TIME = "2010.02")

    *ENDWHEN

    *RUN_PROGRAM

    CURR_CONVERSION

    CATEGORY = %VERSION_SET%

    GROUP = %SCOPE_SET%

    OTHER = [ENTITY = %ENTITY_SET%]

    FXRATENTITY = GLOBAL

    *ENDRUN_PROGRAM

    *WHEN ACCOUNT.ACCTYPE

    *IS "INC", "EXP"

    *REC(EXPRESSION = %VALUE% + [TIME].[TMVL(-1,%TIME%)],CURRENCY = EURO,[TIME] = "2010.02")

    *ENDWHEN

    Can you please help.

    Add comment
    10|10000 characters needed characters exceeded

    • In his script the question author is already using standard currency conversion rule logic. But looks like without understanding: for example TID_RA is not set. May be it's some student training?