Symptom
You have noticed an unposted source document and an error message which prevents the document from being posted. The error message is:
Currency conversion failed due to missing exchange rates. Maintain the exchange rates for conversion from ABC to XYZ for Mid Rate
ABC means the Source Currency.
XYZ means the Target Currency.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Closing Cockpit view.
- Go to the Source Documents subview.
- Search for your Source Document ID, in this case the Source Document is a Purchase Order.
- Select the ID and under the Details section you can see this error:
Currency conversion failed due to missing exchange rates. Maintain the exchange rates for conversion from ABC to XYZ for Mid Rate
Cause
You are using Currency Conversion Profile DEF and which uses Posting date as conversion date. This Purchase Order has items with a delivery date of MM-DD-YYYY and for those items, the exchange rate cannot be derived.
- Go to the Business Configuration work center.
- Select the View Implementation Projects.
- Choose option Open Activity List.
- Show All.
- Find Currency Conversion Profiles activity.
- Open the Activity.
- In new screen, find Currency Conversion Profiles and click to open.
- Here you are able to check that Business Transaction Type Purchase Order for the profile DEF uses the Conversion date 2 - Posting Date.
DEF means the Currency Conversion Profile.
Resolution
You need to maintain exchange rate from ABC to XYZ as of delivery date of MM-DD-YYYY.
- Go to the General Ledger work center.
- Open the Edit Exchange Rates view in the Common Tasks section.
- Maintain the relevant exchange rate between Source Currency: ABC to Target Currency: XYZ.
- Confirm the entries by clicking Save and Close.
Now you will be able to post the Unposted Source Document.
Keywords
currency conversion; mid rate; purchase order; delivery date; posting date; source currency; target currency; business transaction; unposted , KBA , SRD-FIN-GL , General Ledger , How To