EURX Conversion Exchange Rate Calculation

User raised a question on the exchange rate calculation when creating purchase order when 3 currencies were involved.
Vendor Master – EUR
Purchase Info Record – USD
Material Master – SGD

Answer

It had taken me sometime to figure out this with some discussion with the SAP FICO Consultant for PO creation that was using currency EUR in Vendor Master and Purchase Order using USD.

As you can see from the PO, it is not using the Exchange rate provided in the Header.  For normal cases, it should be converted to local currency then to vendor master currency.

PIR (USD) -> Local Currency -> Vendor Master (EUR) 

Vendor Master Currency

The first check was transaction OBBS in order to know whether any Alt. ERT was used.

SPRO -> SAP NetWeaver -> General Settings -> Currencies -> Define Translation Ratios for Currency Translation

Define Translation Ratios for Currency Translation

Once you know that Alt. ERT was being used, you can now calculate the PO price.
For example USD to EUR conversion in Purchase Order
Vendor Master (EUR)
Purchase Info Record (USD)  4.56
Purchase Order Item Condition price = 4.56 / 1.5 = 3.04 EUR
You just need to directly convert it using the EUR rate provided for USD which is 1.50000

Tcode: OB08

SPRO -> SAP NetWeaver -> General Settings -> Currencies -> Enter Exchange Rates

Enter Exchange Rates

Another SAP MM ticket mystery solve.

SAP MM Tips

See also
PO Terminated When Display Delivery Address

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.