How To Fix RTC_CT_01143 - Equity reconciliation check error: &1 (FI) and &2 (AFD) for &3 in &4

SAP Error Message - Details

• Message type: E = Error

• Message class: RTC_CT_01 - Real consolidation - currency translation

• Message number: 143

• Message text: Equity reconciliation check error: &1 (FI) and &2 (AFD) for &3 in &4

What causes this issue?

You have configured currency translation for additional financial data -
investee equity, thus the group amount data will be retrieved from
additional financial data. However, if you have not maintained the
additional financial data correctly, incorrect currency translation
results will be generated.
Validation checks are performed before currency translation execution.
This error message means that the validation checks have failed.

System Response

This entity stops processing.

How to fix this error?

On the <LS>SAP Easy Access</> screen, choose <LS>Accounting -> Real-Time
Consolidation -> Periodic Processing -> Maintain Investment/Equity
History Data</> (alternatively, enter transaction code
<DS:TRAN.RTCAFD>RTCAFD</>).
Enter the necessary parameters, and choose <LS>Display</>.
To see more detailed reconciliation results, choose <LS>Check</>.
Maintain your additional financial data here to ensure it is reconciled
with accounting data.

Procedure for System Administrators

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 RTC_CT_01143 - Equity reconciliation check error: &1 (FI) and &2 (AFD) for &3 in &4 ?

  The SAP error message RTC_CT_01143 pertains to equity reconciliation checks in the context of financial accounting (FI) and asset accounting (AFD). This error typically arises during the reconciliation process when there are discrepancies between the equity accounts and the asset accounts.
  Cause:
  The error message RTC_CT_01143 indicates that there is a mismatch or inconsistency between the equity account balances and the asset account balances. This can occur due to several reasons, including:
  
  Data Entry Errors: Incorrect postings in either the equity or asset accounts.
  Configuration Issues: Incorrect settings in the financial accounting or asset accounting configuration.
  Missing Transactions: Transactions that should have been posted to either the equity or asset accounts may be missing.
  Currency Differences: Discrepancies due to currency conversion if transactions are recorded in different currencies.
  Timing Issues: Transactions recorded in different periods that should have been reconciled.
  
  Solution:
  To resolve the RTC_CT_01143 error, you can follow these steps:
  
  
  Review the Error Message: The error message will provide specific details about the accounts involved. Analyze the details for &1 (FI), &2 (AFD), &3, and &4 to understand which accounts are causing the issue.
  
  
  Check Account Balances: Verify the balances of the equity and asset accounts involved. Ensure that they match as expected.
  
  
  Audit Transactions: Review the transactions posted to both the equity and asset accounts. Look for any missing or incorrect postings.
  
  
  Reconcile Accounts: Perform a reconciliation of the accounts to identify discrepancies. This may involve running reports or using transaction codes like FBL3N (for G/L accounts) or AW01N (for asset accounts).
  
  
  Adjust Entries: If discrepancies are found, make the necessary adjustments to correct the entries. This may involve reversing incorrect postings or posting missing transactions.
  
  
  Configuration Check: Ensure that the configuration settings for both financial accounting and asset accounting are correct. This includes checking the settings for reconciliation accounts and asset classes.
  
  
  Consult Documentation: Refer to SAP documentation or help resources for specific guidance on equity reconciliation and the error message.
  
  
  Seek Support: If the issue persists, consider reaching out to your SAP support team or consulting with an SAP expert for further assistance.
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as FBL3N (G/L account line items), AW01N (Asset Master Record), and others that may help in analyzing the accounts.
  SAP Notes: Check for any SAP Notes related to RTC_CT_01143 for additional insights or patches that may address known issues.
  Training and Documentation: Ensure that users involved in financial postings are adequately trained to minimize data entry errors.
  
  By following these steps, you should be able to identify and resolve the cause of the RTC_CT_01143 error in your SAP system.