on 06-22-2010 7:05 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.