SAP Knowledge Base Article - Public

2857528 - Exchange rate difference accounts are incomplete for account

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

  1. Journal Entries are created for which exchange rate differences will arise on clearing/foreign currency valuation.

  2. Example on Clearing Clear G/L Accounts (App ID F1579) Error occurs on Simulate or Post.

EX.RATEDIFFERENCE.png

Cause

The accounts for posting exchange rate differences could not be determined.

Resolution

  1. In Configuration Activity Automatic Account Determination ID 100297
    Select:
    Area: Financial Accounting
    Sub Area: General Ledger Accounting
    Process: Define Accounts for Exchange Rate Differences

  2. Click button Step 2
    Select
    Transaction Key KDF (Exchange Rate Dif.:Open Items/GL Acct
    Chart of Accounts concerned.

  3. Click on Button Step 3.

  4. Click on Add and scroll down to newly added fields.

  5. 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).

    KDF.png

    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.


  6. 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

Product

SAP S/4HANA Cloud Public Edition all versions