Skip to Content
0
Jun 30, 2016 at 11:03 AM

Exchange Rate Type M is not determined during Invoice Posting

1629 Views

Hello Experts,

Exchange rate type M is not determining while posting FI invoices using F-43 & FB60 (Co.Cd currency USD and transaction currency is EUR) . Whereas the other exchange rate type EURX is determined during invoice posting. When I checked into translation ration setting (OB22), where Alternative exchange rate type EURX is maintained for M exchange rate type as shown below.

Exc.Rate Type From Curr To Curr Valid From Ratio (from) : Ratio (To) Alt.Exc.Rate Type M USD EUR 01.01.1800 1 : 1 EURX

I tried the following options, in order to determine M exchange rate type, but system always picks EURX by default.

1. Removed EURX from OB22 setting and tried with invoice posting - System determined EURX only.

2. Maintained a new entry with a different valid from date (01.01.2016) and retaining the old entry as shown in the above table - System determined EURX only.

3. Removed the original entry as shown above and tried with invoice posting - System determined EURX only.

Also checked in the document type (KR- used for vendor Invoice posting) and there were no mention about the Exchange rate type setting.

Below is the setting in OB22:

Crcy type 10 Company code currency Currency USD Valuation 0 Legal Valuation ExRateType M Standard translation at average rate Srce curr. 1 Translation taking transaction currency as a basis TrsDte typ 3 Translation date Crcy type 30 Group currency Currency EUR Valuation Legal Valuation ExRateType M Standard translation at average rate Srce curr. 2 Translation taking first local currency as a basis TrsDte typ 3 Translation date Crcy type 40 Hard currency Currency USD Valuation Legal Valuation ExRateType M Standard translation at average rate Srce curr. 2 Translation taking first local currency as a basis TrsDte typ 3 Translation date

Other thought:

Suppose if the exchange rate is maintained for the same currency pair USD/EUR in OB08, for both exchange rate types (M & EURX) but with different "Valid From" date , say EURX has the latest valid from date, whereas M has older valid from date, does it have any impact on the exchange rate determination in the invoice document? I could see the entries as described in my system as shown below.

Exc.Rate Type Valid From Indir.Quote X Ratio (From) From = Dir.Quote X Ratio (To) To M 23.10.2012 1,30055 X 1 USD = X 1 EUR EURX 08.05.2015 112,145 X 1 USD = X 1 EUR

Can anyone guide me to understand how exchange rate type EURX is determined in the invoice postings? Please let me know if you need further details.

Thanks a lot.

Regards

Sathyaraj R