SAP Knowledge Base Article - Public

3680085 - Duplicate Postings in Advanced Foreign Currency Valuation in SAP S/4HANA Cloud Public Edition

Symptom

Delta difference was posted again when running Advanced Foreign Currency Valuation two times in one period.

Environment

  • SAP S/4HANA Cloud Public Edition
  • Schedule General Ledger Jobs - Advanced Foreign Currency Valuation Template

Reproducing the Issue

  1. Open the app "Post General Journal Entry".
  2. Post balance in Foreign Currency Y for G/L Account X without Open Item Management and Balance only in Local Currency, as well as with FX semantic tag assigned.
  3. Open the app "Manage G/L Account Master Data".
  4. Tick "Balance only in Local Currency" for G/L Account X in Company Code - Account Control Section.
  5. Save the change.
  6. Change the exchange rate for the respective Foreign Currency/Local Currency.
  7. Run "Advanced Foreign Currency Valuation" in Update Run after the exchange rate is valid.
  8. Notice that G/L Account X / Foreign Currency Y Group ID, Delta Difference is calculated and posted.
  9. Run "Advanced Foreign Currency Valuation" in Update Run again on the same key date as the first run.
  10. Notice that G/L Account X / Foreign Currency Y Group ID with the same Delta Difference as the first run is posted again.

Cause

"Only manage balances in local currency" indicator was activated while the G/L Account still had a Foreign Currency balance.

Resolution

  • If account valuation is required:
    1. Reverse the duplicate entries generated using the app "Manage Journal Entries".
    2. Remove the setting "Only manage balances in local currencies".
  • If account valuation is not required:
    1. Reverse the duplicate entries generated using the app "Manage Journal Entries". 
    2. Remove the semantic tag FX from the G/L Account.
  • Before implementing any changes, test them in a test system to prevent any negative impact on the production environment.

See Also

Keywords

duplicate postings, advanced foreign currency valuation, delta difference, revaluation, G/L account, manage balances in local currency, FX semantic tag, update run, SAP S/4HANA Cloud Public Edition, period-end, closing operations , KBA , FI-GL-GL-G-2CL , Closing Operations / Period-End (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions