FXTRANS Currency translation for plananing application

[Vishwanathg7]

Dear Freinds !

I had read many blogs on currency translation but not able to do currency translation with 7.5NW SP 09 even after following SAP Note 1254330 .

Planning appliation had 1.C_Category dim ( default) 2.N_ACCT ( copy of C_ACCT) 3.Entity(Default)4.Time(Default)5.RptCurrency(Default) Referenec to RATE APP ( Default)

RATE APP 1. C_Category dim ( default) 2.R_ACCT ( Defalut) 3.R_Entity(Default)4.Time(Default)5.InputCurrency(Default) Referenec to RATE APP ( Default)

All properties are manined as mentioned in note 1254330.

systemconstants file

*FUNCTION THISAPP=PLANNING

*FUNCTION RATEAPP=RATE

*FUNCTION RATEENTITYDIM=RateEntity

*FUNCTION RATEACCOUNTDIM=RATE

*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY

*FUNCTION RATEENTITYMBR=Global

*FUNCTION RATESRCCALCMBR=Global

*FUNCTION AVGRATEID=AVG

*FUNCTION ENDRATEID=END

Data enetered for C5000 (JAPAN) INCOME ACCOUNT LC in planning application

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %C_CATEGORY_SET%

CURRENCY=%RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY =GLOBAL

OTHER = ENTITY=%ENTITY_SET%

*ENDRUN_PROGRAM

DM package ran inputed provided is EUR it shows running sucessfully but log say zero record submited/generated

DM package ran inputed provided is blank it shows error LC does not exit

Kindly help me understand why it is not working

[Former Member · Accepted solution]

Hi,

Please check/correct the following and see if this solves your problem:

- NW is case-sensitive in most places, you please check that you are referencing the dimensions/apps correctly

- In your system constants you are defining RateEntity but your dimension is R_Entity. Please make sure these are matching

- In your logic, you must have the "Other" section in square brackets as so (these are not sq brackets because this blog turns them into a URL): OTHER={ENTITY=%ENTITY_SET%}

- Check that in RPTCURRENCY dim that LC is labelled as L and EUR is labelled as R

- Have you ensured that you have put FX rates in the Rate app in the correct period/group as your entered data?

- In the Datasrc dim, have you entered a Y in the property "Is_Converted" for the Datasrc you have entered data into?

- Do the accounts that you have entered data against have a valid value entered against property "RateType"? This must then be reference in your FX business rule

If none of these things solve your problem, please show me what you have put in your FX business rule - as this definition was missing from your post.

Tom.

[Vishwanathg7 · Accepted solution]

Tom Thanks ! for reply

1. N_ACCT ACCTYPE RATETYPE

4000000 INC AVG

2 ENTITY CURRENCY

C5000 JPY

3. RptCurrency REPORTING CURRECNCY_TYPE

EUR Y R

LC L

USD Y R

4. R_ACCT RATETYPE

AVG FX

In business rules table only formula is updated [AVG]

I want all my LC currency need to be converted in to LC

In Rate application for sale category & time fx rates are updated for JPY.

Calulation Log : shows calulation run sucesfully but submitted/ success records are zero.

[Former Member · Accepted solution]

Hi,

Im not sure if you made a typing mistake on the last reply, but you cant convert numbers from LC to LC. It must go from a currency marked with an "L" - in this case LC, into a currency marked with an "R" - this is multiple currencies like EUR, JPY, GBP etc.

You will therefore never see the converted records in LC.

Even though you entered a rate against JPY, you need to also enter a record for the same time period for USD (for example) so that the JPY amount knows which currency to convet to. The Rate application works by converting based on relative positions to Group currency. For example:

INPUTCURRENCY RATE CATEGORY VALUE

USD AVG ACTUAL 1

JPY AVG ACTUAL 4

Then when you run currency, it will take the amount you entered against entity C5000 and divide it by (4/1). Without the entry against USD it will not be able to convert.

Hope this is clear.

Tom.

[Vishwanathg7 · Accepted solution]

Dear Tom,

Thanks ! for your reply. Its my mistake that I had mentioned LC to LC it is LC to Reporting currency .

I had entered the values againt all reporting currencies but still after running stand datamanager package in formula log values are zero.

Few thing is not clear to me :

What setting we need to do to system to identify WHAT ALL LC need to be translated to WHAT Reporting Currency ?

Is system understands using Entity Hierarchy ?

Is system translate all LC data to all Reporting Currency for all accounts were ratetype property is defined assuming business rules are perfectly configured?

Thanks ! in advance