Currency conversion issue

[former_member1192543]

Hi,

I am facing a problem when i am trying to run the urrency conversion..

Below are the Setting done for Currency conversion..

1.Account--rate Type

2.Entity--Currency

3.Time--Year,MonthNUm,TimeID and Period..

4.Datasrc--Datasrc_Type,IS_Converted..

5.RPTCurrency--Currency_type,reporting..

Business rule Configuration:

Account Rate Type Formula

AVG [AVG]

END [END]

FXTrans Logic..

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %T_CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%T_ENTITY_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*COMMIT

RATE Application has been loaded the rates for GLOBAl Entity...

After Running the package we are getting error..

Package Log:

/CPMB/MODIFY completed in 0 seconds

/CPMB/FX_RESTATMENT_LOGIC completed in 1 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

-

---

(Member Selection)

T_ENTITY: IND01

T_CATEGORY: PLAN

RPTCURRENCY: USD

TIME: 2010.JAN

[Messages]

-

---

RUN_LOGIC:Run program error, Message Number: ""

Failed

Application: PL Package status: ERROR

Formula Log:

LOG BEGIN TIME:2011-06-01 10:42:16

FILE:\ROOT\WEBFOLDERS\TrainingBPC\ADMINAPP\PL\FXTRANS.LGF

USER:CTS\229773

APPSET:TrainingBPC

APPLICATION:PL

RUN CURRENCY CONVERSION

EXCEPTION OCCURRED WHEN RUNNING PROGRAMS:

Error found in BPC

LOG END TIME:2011-06-01 10:42:17

Please let me know where i am going wrong..

Thanks,

Naresh.K

[Former Member]

Naresh,

Did you try to run the script using UJKT? Some times it tests our patience, best way is:

1.Recheck the required settings again.

2. Chek the data in Rate application ( USD=1, EUR=1.2 , check USD value is there are not)

3. See the Data in Finance Application (Make sure it is in LC)

4. Try the logic given below in UJKT, by hard coding values.

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %T_CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

//OTHER = ENTITY=%T_ENTITY_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*COMMIT

Thanks

[former_member209721]

There are many posts that raise the same issue - Search on this forum, you'll find the solution to your problem

[former_member1192543]

Hi,

Searched many but didn't find a single sol proper..

Thanks,

Naresh.K

[Former Member]

Hi,

Could you check if you have done following settings?

1. INPUTCURRENCY Dimension needs to be set up giving all the currencies, in which you need to maintain (M)ultiply, (D)ivision in MD property of this dimension

2. All the entities should have CURRENCY set up. Example, GB10 would have GBP and IN10 would have INR as currency in ENTITY dimension

3. If the reporting currency is GBP, then in RATE dimension GBP will have '1' in the signed data.

If problem still persists, then please let me know which BPC version that you are working on?

Hope this helps.

Regards,

Rashmi

[former_member1192543]

Hi Rashmi,

I allready done all those basic settings what ever your suggestting..but still i am getting the said error.

Thanks,

Naresh.K

[Former Member]

Hi Naresh,

What is the BPC version, service pack & patch level that you are on?

It would be great if you could send the the data (master as well as the transaction data) along with the script logic. I'll try to find out the error.

Regards,

Rashmi

[former_member1192543]

Hi,

The version including SP is:7.50.07..

I cant send the Master and Transaction data..

Thanks,

Naresh.K

[Former Member]

Hi Naresh,

I understand you cannot send the data ... you give me the settings mentioned above, one data that you want to do currency conversion and the rate associated to it.

Hope you have gone thru the ho-to document on Currency conversion.

Could you also maintain the OWNER property on Entity Dimension (SAP NOTE: 1503306)

Hope this helps.

Else you can raise a OSS message with SAP.

Regards,

Rashmi