Symptom
Wrong currency exchange rates used in transactional data
Environment
SAP S/4HANA Cloud Public Edition
Cause
You have selected the Inverse checkbox for an Exchange Rate Type in the configuration activity Check Exchange Rate Types (102349). When this checkbox is selected, the inverse rate is automatically used to translate a currency, but only when no separate exchange rate is specified.
SAP delivers exchange rates with your initial SAP S/4HANA Cloud Public Edition configuration. Unless you delete the SAP delivered rates, they will be used even if you have the Inverse checkbox selected. An individually specified exchange rate always takes precedence over the Inverse checkbox.
The combination of the selected Inverse checkbox and the exchange rates delivered by SAP can lead to unintended currency exchange rates being used in your transactional data.
Example
The Inverse checkbox is selected in the Check Exchange Rate Types configuration activity as follows:
Exchange Rate Type |
Inverse |
M |
X |
The following exchange rates exist in the Currency Exchange Rates app:
Exchange Rate Type |
Currency Pair |
Valid From |
Rate 1:1 |
M |
XXX/YYY |
09/30/2021 |
2.0 |
M |
YYY/XXX |
01/01/2021 |
1.0 |
M |
XXX/ZZZ |
09/30/2021 |
2.0 |
These entries can result in the following postings:
1) With YYY as the transaction currency and XXX as the company code currency, the exchange rate M YYY/XXX 1.0 is used because a separate exchange rate exists in the Currency Exchange Rates app.
2) With ZZZ as the transaction currency and XXX as the company code currency, the inverse exchange rate M XXX/ZZZ 0.5 is used because the inverse checkbox is selected for Exchange Rate Type M and there is no separate exchange rate in the app for that currency pair. (1.0/2.0 = 0.5)
Resolution
To prevent exchange rates that are different than you expect, review your exchange rates and take the following steps:
- Delete exchange rates that aren’t necessary for your business
- Update existing exchange rates with the current exchange rates in both your test and production systems before you go live.
You delete and update exchange rates in the Currency Exchange Rates app.
Keywords
F3616, Currency Exchange Rates, Currency Translation, Currencies, Check Exchange Rate Types, 102349, Inverse Rates, Currency, Fiori, Currency Configuration, Configure Your Solution, Manage Your Solution, Exchange Rates , KBA , fiori , currency , currency translation , check exchange rate types , configure your solution , currencies , currency exchange rates , 102349 , currency configuration , manage your solution , f3616 , FI-FIO-GL-CA , Cross Application Configuration in General Ledger , FI-FIO-GL , Fiori UI for General Ledger Accounting , FI-FIO-GL-CA-2CL , Cross Application Configuration in General Ledger (Publ Cld) , Problem