on 12-05-2017 2:51 PM
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
Sorry, but looks strange...
Have you read about "Periodic Calc" in the rule setup?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please read:
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.