cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member186338
Active Contributor

Sorry, but looks strange...

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

former_member186338
Active Contributor
0 Kudos

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:

Former Member
0 Kudos

Hello Vadim,

Thank you for your time.

I tried to add this business rule,

but with these source flow, i am not getting expected answer. I am getting the values as normal conversion would give.

Using periodic calc and without it, giving me same values after conversion package.I have tried several other combinations to run this business rules the way you have mentioned , but not successful in getting the expected values.

Can you please specify more details.

former_member186338
Active Contributor
0 Kudos

Sorry, but looks like you are doing something wrong and not providing full info.

By the way AVG in formula has to be in brackets [AVG]

Please reproduce my test case and you will see correct results.

Former Member
0 Kudos

Hi Vadim,

Thanks for your reply, please details below:

former_member186338
Active Contributor
0 Kudos

Sorry, but you are not reproducing my test case (you have 2010.12 and 2011.01). You have to use months of the same year.

Also syntax of rule is incorrect: AVG in formula has to be in brackets [AVG]

Former Member
0 Kudos

Thank you, I will try it in the same year.

former_member186338
Active Contributor
0 Kudos

Start with the same settings of my test case. Using YTD model with INC account.

Former Member
0 Kudos

Hi Vadim,

Thank you so much.

i have been able reproduce the same test case. Thank you for your help .

former_member186338
Active Contributor
0 Kudos

Then please accept the correct answer and close the question!

Former Member
0 Kudos

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.

former_member544285
Participant
0 Kudos

As Vadim pointed, this is common requirement and BPC already has a standard working solution called the Currency Conversion business rules. You can set it up under 10 minutes and it would work perfectly without writing any logic script. General rule of thumb is to use standard function before resorting to logic script.

Have you tried setting up the business rule?

former_member186338
Active Contributor
0 Kudos

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?

Former Member
0 Kudos

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.

former_member186338
Active Contributor