Symptom
You have posted a Supplier invoice with an amount in currency PQR (where PQR stands for the transaction currency). The exchange rate for this invoice was maintained manually.
The Journal Entry takes into account the exchange rate maintained on the invoice, however, when trying to create the payment for this invoice, error message: Conversion rate for Currency PQR and DEF missing on DD.MM.YYYY is raised (where DEF stands for the expected conversion currency).
Therefore it is not possible to clear this invoice with its payment.
Reproducing the Issue
-
Go to the Supplier Invoicing Work Centre.
-
Go to Invoices and Credit Memos View.
-
Search for Invoice XXX (where XXX stands for the Invoice ID).
-
Click on Edit and then View All.
-
In the General tab you can see that amount is maintained in currency PQR.
-
Navigate to the Exchange Rates subtab.
-
The Exchange Rate has been maintained manually with unit Currency being PQR and and Quoted currency being DEF.
-
Now, navigate to the Document Flow.
-
Open the associated posting for Supplier Invoice XXX.
-
For the relevant Line items, the Exchange rate is being applied:
Transaction Currency Amount is in currency PQR.
Company Currency Amount is DEF.
-
Now navigate to the Payables work centre.
-
Open the Supplier Account view.
-
Search for Supplier YYY (where YYY stands for the Supplier ID).
-
Click on View.
-
Navigate to the Trade Payables tab - Invoices / Payments.
-
Select Document ID XXX - amount displayed is in currency PQR
-
Click on the Pay Manually By button.
-
Choose the relevant Payment Method.
-
On the new payment screen, error message is raised:
Conversion rate for Currency PQR and DEF missing on DD.MM.YYYY
Cause
This is the expected system behavior, this error message is being raised because the relevant Exchange Rates have not been maintained for the involved transactions.
Even if you maintain the Exchange Rate manually on the Supplier Invoice, this rate will not be picked up during your payment transactions as this is not the system's logic.
Resolution
- Navigate to the General Ledger work center.
- Go to Common Tasks.
- Open Edit Exchange Rates.
- Maintain the relevant Exchange Rates expected for your transactions.
You are now able to proceed with the payment and clearing of Supplier Invoice XXX.
See Also
For further information, please refer to Help Documents available from the Help Center: Exchange Rates Quick Guide and Exchange Rate, Exchange Rate Type, and Conversion Type.
Keywords
KBA , SRD-FIN-ACP , Payables , How To