Currency translation in default logic BPC 10

[Former Member]

Hello,

We have written currency translation in default logic but due to some reason if we post 3 records for example it is posting 293 records in the backend.

I have checked and even the business rules doesn't have any rule which makes it post to other accounts. Because of this all out P&L goes out if we we make an adjustment in 1 account using an input schedule.

Script as below which runs in default:

*FOR %TIME% = %TIME_SET%

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %VERSION_SET%

TIME =%TIME%

OTHER = [COMPANY = %COMPANY_SET%;PROFITCENTRE = %PROFITCENTRE_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*NEXT

Is it something I can do in scoping of default logic but according to me it should post according to the context and selection from input schedule and in any case it should not post to any other accounts.

regards,

Dolly Katyal

[former_member193143]

Hello Dolly,

Are you posting the data via input schedule or via DM package..?

Thank you

Saida Reddy Gogireddy

[Former Member]

Input schedule.

Dolly.

[former_member193143]

Hello Dolly,

Please check whether do have any write back badi for retraction process, in our project we implemented like that only.

In our case user enter data for respective cost center once data in saved it will show as 3 records saved.

So its depends on the BadI how they implemented.

This might be one possibility.

Regards,

Saida Reddy Gogireddy

[former_member186338]

P.S. And please, before default.lgf test the logic in UJKT

[former_member186338]

Syntax???

Look on the syntax from help:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %C_Category_SET%

GROUP = %GROUPS_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = Global

*ENDRUN_PROGRAM

TID_RA, Not TIME!

Vadim

[Former Member]

Thanks for the reply Vadim, but the time scoping is correctly happening according to the periods posted in  input schedule.

We have been using this since long but no idea how this issue is suddenly occurring. Still let me try TID_RA.

Regards,

Dolly

[former_member186338]

Please, test in UJKT and provide logs...

[former_member186338]

And as far as I remember, *RUN_PROGRAM CURR_CONVERSION supports multiple months in TID_RA=%TIME_SET% - you don't need FOR/NEXT at all!

Vadim

P.S. And I can't see in your code the line:

GROUP = %GROUPS_SET%

or:

CURRENCY=USD,EUR //some list of currencies

[Former Member]

Tried that as well. removed *for but still posts the same number of records. The accounts in which the entries are posted are no where coming from the input schedule. But company code and profit center remain the same as posted in schedule

regards,

Dolly Katyal

[former_member186338]

1. Test in UJKT! Post UJKT results - 3rd time!

2. Try OTHER = [COMPANY = %COMPANY_SET%;PROFITCENTRE = %PROFITCENTRE_SET%;ACCOUNT=%ACCOUNT_SET%]

[Former Member]

LGX:

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = VE_FY16_F03

TID_RA =2016.03

OTHER = [COMPANY = CO_7211;PROFITCENTRE = PC_70034]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

FILE:\ROOT\WEBFOLDERS\SAPBPC \ADMINAPP\Planning\TEST.LGF

USER:KATYALD

APPSET:SAPBPC

APPLICATION:Planning

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

Validates successfully when I do Execute(simulate).

Regards,

Dolly katyal

[former_member186338]

Ups, this log shows that the script is not working!

[Former Member]

But this scipt pushes in 292 entries for 3 records from IS

never seen this weird issue

Regards,

Dolly

[former_member186338]

I have done some tests on the copy of ENVIRONMENTSHELL with a simple model:

UJKT (single value was changed in the model!):

2 records submitted - for 2 currencies, no issues!

And if I put the same script in default.lgf it will also work correctly!

Vadim

P.S. You can't put ACCOUNT dimension in OTHER - no effect! But currensy conversion is performed only for changed accounts...

[former_member186338]

And in your UJKT - no lines:

GROUP = %GROUPS_SET%

or:

CURRENCY=USD,EUR

[Former Member]

Hello Vadim,

This is a financial planning application, hence no Groups. Currency i tried but no improvements. even I tried to run the fx restatement instead of default logic on this data, and same results were shown that is it posted data in other accounts as well.

IS this something to do with that, we are posting data in AUD which is the reporting currency. And if we are posting in AUD do we need to change something in the "currency" that we mention in the fxtrans.lgf code?

FYI..In Audit report we see that the extra entries are posted using "Business rule execution".

regards,

Dolly Katyal

[Former Member]

Hi Dolly,

Try to write simple logic for currency translation.Removed next and for which is not necessary also remove profit center from logic script.Change the DM prompt from group to currency.There is no need any extra setting for AUD. Check IS_Converted properties value =Y in audittrail dimension.I think you write GLOBAL in capital letter in RATEENTITY dimension.

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %VERSION_SET%

CURRENCY=%RPTCURRENCY_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%COMPANY_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

Khokan

[former_member186338]

Hi Dolly,

"This is a financial planning application, hence no Groups." - then CURRENCY is mandatory! You have to specify list of target currencies for conversion.

Always show the results of UJKT instead of general "no improvements", not working, etc... unable to help!

"IS this something to do with that, we are posting data in AUD which is the reporting currency." - you have to post in LC!

Please read the basics:

Vadim