Group Currency Exchange rate type.

[Former Member]

Hi

We wanted to post a foreign currency document, with a specific Exchange rate, that is specified in the Document type.

Doument Currency is getting converted into Local Currency (Company code currency) based on the exchange rate type specifed in the Document type used for posting.

But, the Group Currency is getting converted from Document currency based on the Exchange rate type : "M" but based on the Exchange rate type specified in the Document type.

Is there any way, apart from specifying Exchange rate type in Parallel Currencies.

We wanted the conversion of Both Local (Company code) & Group currencies be converted based on the Exchange rate type specified in the document type, for some specific postings.

Following is our Scenario :

Co.Code Cur - EUR

Doc.Cur GBP

Grp Cur USD

Document type : XY -- Exchange rate type "1111" specified in the document type.

Now when a document is posted with Document type "XY" in Document Cur : GBP.

Both Local & Grp currency to be converted based on the Exchange rate type " 1111".

Thanks

Kalyan

[Former Member · Accepted solution]

Kalyan,

Apart from Ray's excellent post, you can also specify the 'source currency' used for translation in OB22. There are two options:

1 Translation taking transaction currency as a basis

2 Translation taking first local currency as a basis

So, you can configure your group currency to translate either from the transaction currency i.e. GBP (option 1) in your example or EUR (option 2).

regards,

vishal.

[Former Member · Accepted solution]

Hi Ray / Vishal,

Thanks for your quick response.

I am working on a Production system, and the company code that i am looking for the above functionality is co-shared by other Business units and they dont require this.

I have explored the Parallel currency customization earlier, as i am in a productive system and co-shared by other Business units i cannot change the OB22 settings as they are at Co.Code level.

Apart from OB22, is there any other way, that i can convert post my group currency values, with a specific rate type apart from default "M" type.

Appreciate your thoughts on the same.

Thanks

Kalyan

[Former Member · Accepted solution]

You might have to look for an enhancement. As of now I don't know of any. Check out for user-exits or BTE's or BADI's around that functionality. Take help from your ABAPer to determine in an accounting document posting where and how the currency translation occurs. Try to find an enhancement there.

regards,

vishal.

[gladys_xing]

Hi Kalyan

Please refer to my reply in the following thread:

I think it will helpful for you as well.

Best Regards,

Gladys xing.

[raymond_moynihan]

Hello Kaylan,

I will try to explain the system behavior, regarding to the exchange

rate question, "M" is standard exchange rate type used in R/3 so it's

not possible to change this default setting. However you can assign the

exchange rate type to each FI document type at transaction OBA7. The

exchange rate type assigned here applies to both online/batch postings.

Therefore you can assign a different exchange rate type to the document

types, but not per company code. The exchange rate that you customize at

document type level is validfor the first local currency. However, for

parallel currencies, the system will always use the exchange rate type

defined in transaction OB22. Please, check your customizing there to

check your changes.

If you want to use exchange rate type B, for example, instead of M, in

customizing you have to give Alt Ex.Type as B against M. So that it will

take B rate whenever M is applicable. If you want this B rate to be

applicable for specific document types then you can do the same at

document type definition itself. Otherwise you can do the same at

payment program level/ Revaluation. These are the only places where

exchange type comes into picture.

See also the following attached OSS notes notes for details:

335608 Trnsln of 2nd and 3rd lcl crcy fm 1st lcl/trns crcy

526623 Different treatment of local and parallel currency in ML

547946 FAQ Interface: Currency translation, rounding, field status

518114 FAQ: Goods movements in foreign currency

regards

Ray