How To Fix FINS_RECON_2064 - &1: Mismatch of aggregated amount between source/target ledger &2 &3 &4

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 064

• Message text: &1: Mismatch of aggregated amount between source/target ledger &2 &3 &4

What causes this issue?

The sum of at least one of the amount fields TSL, HSL, KSL, OSL, VSL,
BSL, CSL, DSL, ESL, FSL or GSL differs between source and target ledger.
The amounts are aggregated by your selection in the customizing step
<DS:SIMG.FINSVC_SIF_RECON>Define Account Assignment for Reconciling
Aggregated Values</>.

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FINS_RECON_2064 - &1: Mismatch of aggregated amount between source/target ledger &2 &3 &4 ?

  The SAP error message FINS_RECON_2064 indicates a mismatch of aggregated amounts between the source and target ledgers during a reconciliation process. This error typically arises in the context of financial accounting and can occur during processes such as data migration, reconciliation, or when running reports that compare balances between different ledgers.
  Cause:
  
  
  Data Inconsistency: The most common cause is that the amounts in the source ledger do not match the amounts in the target ledger. This can happen due to:
  
  Incorrect postings in one of the ledgers.
  Missing or incomplete data in either the source or target ledger.
  Differences in currency conversion rates if the ledgers are in different currencies.
  Manual adjustments that were not reflected in both ledgers.
  
  
  
  Configuration Issues: There may be configuration issues in the system that lead to discrepancies in how amounts are aggregated or reported.
  
  
  Timing Issues: If transactions are posted at different times in the source and target ledgers, this can lead to temporary mismatches.
  
  
  Solution:
  
  
  Data Verification: 
  
  Check the amounts in both the source and target ledgers for the specified period. Ensure that all transactions are posted correctly and that there are no missing entries.
  Use transaction codes like FB03 (Display Document) or FBL1N (Vendor Line Item Display) to review individual postings.
  
  
  
  Reconciliation: 
  
  Perform a reconciliation process to identify the specific transactions that are causing the mismatch. This may involve comparing totals and line items between the ledgers.
  Use the FINS_RECON transaction to analyze the reconciliation results and identify discrepancies.
  
  
  
  Adjustments: 
  
  If discrepancies are found, make the necessary adjustments in the appropriate ledger to ensure that the amounts match.
  Ensure that any manual adjustments are documented and reflected in both ledgers.
  
  
  
  Configuration Review: 
  
  Review the configuration settings for both ledgers to ensure they are set up correctly and consistently.
  Check for any customizations or enhancements that may affect how amounts are aggregated.
  
  
  
  Consult Documentation: 
  
  Refer to SAP documentation or support notes related to the specific error message for additional guidance and troubleshooting steps.
  
  
  
  Engage SAP Support: 
  
  If the issue persists and cannot be resolved through the above steps, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes for financial reporting and reconciliation, such as FBL3N (G/L Account Line Item Display) and FAGLB03 (Display G/L Account Balances).
  SAP Notes: Check for any SAP Notes that may address this specific error or provide additional troubleshooting steps.
  User Forums: Engage with SAP community forums or user groups where similar issues may have been discussed.
  
  By following these steps, you should be able to identify the cause of the mismatch and implement a solution to resolve the error.