Symptom
Possible symptoms:
- Ex.rate diff.accts are incomplete for account issued on clearing of open item managed account .
- Acct determination is incorrect: Comp. Code &1 - Val. Area &2 - Acct &3 issued on Foreign Currency Valuation .
- In configuration activity Automatic Account Determination for Define Accounts for Exchange Rate Differences, Enter Account to Value: Result No Matching Items found, No items or Conditions selected
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Journal Entries are created for which exchange rate differences will arise on clearing/foreign currency valuation.
- Example on Clearing Clear G/L Accounts (App ID F1579) Error occurs on Simulate or Post.
Cause
The accounts for posting exchange rate differences could not be determined.
Resolution
- In Configuration Activity Automatic Account Determination ID 100297
Select:
Area: Financial Accounting
Sub Area: General Ledger Accounting
Process: Define Accounts for Exchange Rate Differences - Click button Step 2
Select
Transaction Key KDF (Exchange Rate Dif.:Open Items/GL Acct
Chart of Accounts concerned. - Click on Button Step 3.
- Click on Add and scroll down to newly added fields.
- Add Account involved in clearing and other relevant details including Loss and Gain Account in section Exchange Rate Difference Realized. (note if account is to be valuated in Foregin Currency Valuation ensure that loss, gain and B/S Adjmt are also filled in section Valuation - otherwise error FR670 will occur).
Note:
The Currency Type field is only relevant for Valuation .
For Clearing the document Currency is relevant in customizing for the exchange rate difference realized not the currency type. - Click on Review and Save.
General Information:
Prepare Automatic Postings for Foreign Currency Valuation
In this activity you define the numbers of the accounts to which you want the system to automatically post exchange rate differences when valuating open items and foreign currency balances.
You can also define the accounts for realized exchange rate differences during open item clearing.
You can use the currency type to control account determination during open item valuation and exchange rate difference posting. You could, for example, post gains in local currency and gains in group currency to separate accounts.
When valuating open items the system posts to a balance sheet adjustment account and to an account for exchange rate differences that occur during the valuation. Exchange rate differences could be either a gain or a loss. You store the account numbers accordingly.
The valuation of foreign currency balances requires a special key that is assigned the gain and loss accounts for posting any exchange rate differences that occur during valuation. You can freely define this key. You then enter it in the master records of the accounts that you want to valuate. To post the differences that are determined from a group of G/L accounts to the same gain or loss accounts, enter the same key for all these G/L accounts.
Note
You can differentiate the accounts by currency. Exchange gains and losses are then posted to the accounts designated for the currency involved. You must not change your accounts for the valuation posting after the first valuation run has taken place. Otherwise the postings can no longer be reversed.
If you do not want to differentiate the accounts by currency, do not make any entry in the Currency field (this is the default value), and also do not enter an exchange rate difference key in the company code area of the G/L accounts.
Standard settings
Posting keys are already defined in the standard system for posting the results from valuating open items and balances.
See Also
Automatic Account Determination
KDF_Exchange Rate Dif: Open Items/GL Acct
3400680 - Release Information Note: Automatic Account Determination for SAP S/4HANA Cloud Public Edition Edition 2402
Keywords
F1579, KDF, F5063, CLOUD, outgoing, incoming, payment, FR670, Acct determination is incorrect: Comp. Code &1 - Val. Area &2 - Acct &3, Manage Automatic Payments, F0770 , KBA , FI-FIO-GL-CA-2CL , Cross Application Configuration in General Ledger (Publ Cld) , FI-FIO-AP , Fiori UI for Accounts Payable , How To
SAP Knowledge Base Article - Public