SAP Knowledge Base Article - Public

2902957 - Error message "Balance in local currency & is too large for automatic adjustment" raised while reprocessing bank statement items.

Symptom

In the app Reprocess Bank Statement Items, while reprocessing bank statement items in foreign currency, error message "Balance in local currency & is too large for automatic adjustment; Message no. F5061" is raised.

Environment

  • Financial Accounting (FI)
  • SAP S/4HANA Cloud Public Edition
  • SAP Fiori 

Reproducing the Issue

  1. Access the app "Reprocess Bank Statement Items".
  2. Select the bank statement item to be reprocessed.
  3. Payment currency is different from company code currency
  4. Select the journal entry to be cleared or post the amount to GL/AR/AP account.
  5. Ensure the balance is zero.
  6. Simulate and post

Cause

  • The exchange rate between the foreign currency and local currency will be different from the Bank Statement date and the reprocessing date.
  • Eventhough the amount in transaction currency balances to zero, the balance in all other currencies are supposed to balance to zero for posting the bank statement items.

Resolution

If you want to have the Subledger Accounting document(posting area 2) to be posted with the same exchange rate as the bank accounting document(posting area 1), you can flag the checkbox “FX Rate First Item” in the app “Edit Options for Journal Entries - My Settings".

Please refer to the Open Help for the flag “FX Rate First Item” to know more.

Edit User Settings for Journal entries.jpg

Keywords

FI-FIO-AR, FI-BL-PT-BA, F1520, FEB_BSPROC, S4HC, S4_PC, Translation rate, Exchange rate, Value date, Translation date, Currency, F5061 , KBA , FI-FIO-AR , Fiori UI for Accounts Receivable , FI-BL-PT-BA , bank statement , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions