Symptom
The system has been set up to invert the exchange rates. The currency pair rate has also been maintained for e.g. EUR to USD with recent and updated values and also an old/outdated entry for USD to EUR (entry not invalidated yet).
A source document in USD (transaction currency) has been created with the expectation that the system will invert the quotation of EUR to USD using the most recent rate. However, the old entry for USD to EUR was derived by the system.
Environment
SAP Business ByDesign.
Cause
The system will only invert an exchange rate if the required rate is not available. In the above example, since EUR to USD is maintained and valid, this entry is used.
In the Help documentation Configuration: Exchange Rate Types the following is quoted:
"If you select this checkbox, inverted exchange rates will be used for currency conversion if the required exchange rate is not available.
For example, if conversion from USD to EUR is required but only the EUR to USD exchange rate is available, the system will invert the EUR to USD exchange rate and use the resulting inverted exchange rate in the currency conversion."
Resolution
In this example, for the system to use the inverse rate of EUR to USD, the exchange rate for USD to EUR needs to be removed.
See Also
Keywords
Exchange Rate. Mid Rate. Invert. , KBA , SRD-FIN-GL , General Ledger , How To