How To Fix FINS_RECON685 - Invalid entries in field XLGCLR of BSEG_ADD: &1 message(s)

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 685

• Message text: Invalid entries in field XLGCLR of BSEG_ADD: &1 message(s)

&Diagnosis&
There are line items in table BSEG_ADD which contain "/" or "\" in field
clearing specific to ledger groups (XLGCLR). The clearing specific to
ledger group field is a flag field which should only contain "X" or " ".

System Response

The system informs about this inconsistency which has to be corrected in
your productive system before starting the data migration.

How to fix this error?

This inconsistency can be corrected by program 'FIN_CORR_MIG_ERROR_SFIN'
in the original source system (i. e. your productive system):
If you want to correct inconsistencies concerning this field found in
migration to S/4HANA Finance, then you have to start program
FIN_CORR_MIG_ERROR_SFIN in the original source system. The
inconsistencies which have to be corrected are determined by a RFC-call
from the original source system to this system. For more information,
read the program documentation of program FIN_CORR_MIG_ERROR_SFIN in the
original source system.
This procedure of correction in the original source system will ensure
that these inconsistencies will not occur in future test migrations any
more.

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

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_RECON685 - Invalid entries in field XLGCLR of BSEG_ADD: &1 message(s) ?

  The SAP error message FINS_RECON685 indicates that there are invalid entries in the field XLGCLR of the BSEG_ADD table. This error typically arises during financial reconciliation processes, particularly when dealing with line item accounting in SAP.
  Cause:
  The error is usually caused by one or more of the following issues:
  
  Invalid Data: The field XLGCLR may contain values that do not conform to the expected format or range. This could happen due to incorrect data entry or data migration issues.
  Missing Entries: There may be missing entries in related tables that are required for the reconciliation process.
  Configuration Issues: There could be configuration settings in the financial module that are not set up correctly, leading to inconsistencies in the data.
  Custom Code: If there are custom programs or enhancements that manipulate the BSEG_ADD table, they may introduce invalid data.
  
  Solution:
  To resolve the error, you can take the following steps:
  
  
  Check the Data:
  
  Use transaction codes like SE16 or SE11 to view the contents of the BSEG_ADD table and specifically check the XLGCLR field for invalid entries.
  Identify any entries that do not meet the expected criteria.
  
  
  
  Correct Invalid Entries:
  
  If you find invalid entries, you may need to correct them directly in the database (if you have the necessary authorizations) or through the appropriate transaction in SAP.
  Ensure that the data adheres to the expected formats and values.
  
  
  
  Review Configuration:
  
  Check the configuration settings in the Financial Accounting (FI) module to ensure that everything is set up correctly.
  Consult with your SAP Basis or FI consultant if you suspect configuration issues.
  
  
  
  Check for Missing Entries:
  
  Ensure that all necessary entries in related tables are present. This may involve checking other financial tables that interact with BSEG_ADD.
  
  
  
  Debug Custom Code:
  
  If there are custom programs or enhancements, review the code to ensure that it does not introduce invalid data into the BSEG_ADD table.
  
  
  
  Consult SAP Notes:
  
  Search for relevant SAP Notes that may address this specific error. SAP frequently releases notes that provide solutions or workarounds for known issues.
  
  
  
  Testing:
  
  After making corrections, perform tests to ensure that the error no longer occurs and that the reconciliation process works as expected.
  
  
  
  Related Information:
  
  BSEG_ADD Table: This table is an extension of the BSEG table, which contains line item details for accounting documents.
  XLGCLR Field: This field is used for clearing information in the context of financial transactions.
  Transaction Codes: Familiarize yourself with transaction codes like SE16 (Data Browser), SE11 (Data Dictionary), and others relevant to financial accounting.
  
  If the issue persists after following these steps, it may be beneficial to engage with SAP support or your internal SAP team for further investigation.