Skip to Content
0

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

Dec 05, 2017 at 02:51 PM

126

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Dec 05, 2017 at 03:41 PM
1

Sorry, but looks strange...

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 06, 2017 at 03:35 PM
0

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:


percalc.png (22.0 kB)
percalcrep.png (25.5 kB)
percalcrates.png (5.6 kB)
Show 8 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

pl.png (13.7 kB)
avg1.png (8.3 kB)
0

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.

0
Former Member

Hi Vadim,

Thanks for your reply, please details below:

details1.png (83.0 kB)
details2.png (83.3 kB)
0

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]

0
Former Member

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

0

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

0
Former Member

Hi Vadim,

Thank you so much.

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

0

Then please accept the correct answer and close the question!

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

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
0
avatar image
Former Member Dec 06, 2017 at 01:52 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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?

0

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?

0