Exchange rate not getting picked up correctly when converting from foreign currency to local currency in a document.

[polaggari]

Hi All,

I maintained Co. code xxx currency as USD. maintained exchange rates for type M as show in the attached image.

I posted two vendor line items one on 4/18/2014 and other on 5/18/2014  in VEF. when I display those two document I see the amount both in document currency and local currency but the conversion from VEF to USD is happening at a rate @0.23256 which is valid till 02/13/2013 only.

I update the currency after 2013 twice but it is still picking the old conversion rate only.

could somebody tell me what could have gone wrong.

[vinod_vemuru2 · Accepted solution]

Hello,

If above suggestions are not the reason, check if there is any alternate exchange rate type assigned between VEF/USD and USD/VEF in table TCURF. Also, check your posting date. System always picks up the latest available exchange rate as on given translation date.

Thanks,

V V

[former_member688259 · Accepted solution]

Hi Vinod,

I am not getting exact exchange rate (V) from substitution whenever using from BAPI_ACC_DOCUMENT_POST. But it is getting correctly in FB01 postings. Can you have any idea on this ? Because SAP is not supporting substitution exchange rate whenever it is posting from BAPI.

Regards,

Venkat PPM

[Former Member]

Hi Sreeni,

Referring to the " but the conversion from VEF to USD is happening at a rate @0.23256 which is valid till 02/13/2013 only" part in your post, the date given in OB08 for currency rate is valid from and not valid till.  Hence, please check the setting once.  Once you enter the rate from 02/13/2013, the rate is valid till you enter another date later than 02/13/2013.

Regards,

[former_member183424]

Are the both transactions taking same exchange rate ? Even though it has posted in different month.

Can you check is it picking from any other exchange rate type ?

Can you check the default exchange rate for the document type in OBA7.

[Former Member]

Hi ,

Please check your setting in OB22 and also refer below documents

Exchange Rate Customizing - ERP Financials - SCN Wiki

Many Thanks

[polaggari]

Hi Deepthi,

thanks for your reply. let me look in to right away.

[Former Member]

Hi

One more ,

Please check that Ratio is valid after that 13/02/2013 and also check that OB07  You haven't tick Inversion

I hope YOu did not enter any Exchange rate while posting Invoice in F-02 . Becuase you get this option on hearder

[polaggari]

Hey Preeti,

I found the solution. in t code OBBS where we actually maintain currency translation ratios; for exchange rate type M alternate exchange rate type is also maintained.

hence the exchange is getting picked from not type M but  from the alternate exchange rate type.

thanks for your reply though.