How To Fix FINS_RECON004 - &1: Balance in BSEG is not zero in third local currency &2

SAP Error Message - Details

• Message type: E = Error

• Message class: FINS_RECON - SAP S/4HANA Finance Migration: Reconciliation

• Message number: 004

• Message text: &1: Balance in BSEG is not zero in third local currency &2

What causes this issue?

You have performed a reconciliation after data migration to <LS>SAP
Accounting powered by SAP HANA</>. For document &V1&, third local
currency &V2&, the balance is not zero:
Sum of debit amounts: &V3& &V2&
Sum of credit amounts: &V4& &V2&

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FINS_RECON004 - &1: Balance in BSEG is not zero in third local currency &2 ?

  The SAP error message FINS_RECON004 indicates that there is a discrepancy in the balance of the BSEG table (which contains line item data for accounting documents) in the third local currency. Specifically, it states that the balance is not zero for the specified currency, which can lead to issues in financial reporting and reconciliation.
  Cause:
  
  Currency Conversion Issues: There may be issues with how transactions were recorded or converted into the third local currency.
  Incomplete Transactions: Some transactions may not have been fully processed or posted, leading to an imbalance.
  Manual Adjustments: Manual entries or adjustments in the accounting records may not have been properly reflected in the third local currency.
  Configuration Errors: Incorrect configuration in the currency settings or in the financial accounting module can lead to discrepancies.
  Data Migration Issues: If data was migrated from another system, there may have been errors in how the third local currency was handled.
  
  Solution:
  
  Check Transaction Entries: Review the relevant transactions in the BSEG table to identify any entries that may not have been posted correctly. Look for any missing or incorrect entries in the third local currency.
  Reconcile Balances: Perform a reconciliation of the balances in the third local currency against the expected values. This may involve checking the source documents and ensuring that all transactions are accounted for.
  Review Configuration: Check the configuration settings for currencies in the SAP system. Ensure that the third local currency is set up correctly and that all relevant accounts are configured to handle it.
  Adjust Entries: If discrepancies are found, make the necessary adjustments to the entries in the BSEG table. This may involve creating correcting entries or re-posting transactions.
  Consult SAP Notes: Look for any relevant SAP Notes that may address this specific error or provide guidance on how to resolve it.
  Use Transaction Codes: Utilize transaction codes like FB03 (Display Document) to view the documents in question and FBL1N (Vendor Line Item Display) or FBL3N (G/L Account Line Item Display) to analyze the balances.
  
  Related Information:
  
  BSEG Table: This table contains line item data for accounting documents, including details about amounts in different currencies.
  Local Currency: In SAP, local currency refers to the currency in which the company is primarily operating. The third local currency is often used for reporting purposes and may be different from the company code currency and the group currency.
  Transaction Codes: Familiarize yourself with relevant transaction codes for financial reporting and analysis, such as S_ALR_87012301 (G/L Account Balances) and S_ALR_87012302 (G/L Account Line Items).
  SAP Support: If the issue persists, consider reaching out to SAP support for further assistance, especially if it involves complex configurations or data integrity issues.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve the balance discrepancy in the third local currency.