How To Fix PZ850 - Database tables T042I and T042Y are not consistent

SAP Error Message - Details

• Message type: E = Error

• Message class: PZ - Messages: Payment program for payment requests

• Message number: 850

• Message text: Database tables T042I and T042Y are not consistent

What causes this issue?

The tables for G/L account determination for payment transactions with
customers and vendors (Customizing the FI payment program, bank
selection, bank accounts) and between bank accounts (Customizing the
payment program for payment requests, general ledger accounts, bank
account determination) are inconsistent.

How to fix this error?

Execute the consistency check for payment requests in the configuration
menu for the payment program and eliminate the inconsistencies.
INCLUDE 'CUSTOMIZED_MESSAGE_INFO' OBJECT DOKU ID TX
Note that it is a good idea to turn off this message for all users, not
just for individual users.
________________________________________________________________________

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message PZ850 - Database tables T042I and T042Y are not consistent ?

  The SAP error message PZ850 indicates that there is an inconsistency between the database tables T042I and T042Y. These tables are related to the configuration of the system's financial accounting and controlling modules, specifically concerning the assignment of account determination for various transactions.
  Cause:
  The inconsistency between T042I and T042Y can arise from several factors, including:
  
  Data Corruption: Data might have been corrupted due to system errors, improper updates, or failed transactions.
  Manual Changes: Manual changes made to the configuration settings without proper checks can lead to inconsistencies.
  Transport Issues: If changes were transported from one system to another (e.g., from development to production), inconsistencies may occur if the transport was not executed correctly.
  Custom Development: Custom programs or enhancements that interact with these tables may inadvertently cause inconsistencies.
  
  Solution:
  To resolve the inconsistency between T042I and T042Y, you can follow these steps:
  
  
  Check for Inconsistencies:
  
  Use transaction code OBYC to check the account determination settings.
  Use transaction code SE11 to view the structure of the tables T042I and T042Y and identify the specific records that are inconsistent.
  
  
  
  Run Consistency Check:
  
  You can run a consistency check using transaction code SAP Note 000000 or specific reports that check the consistency of account determination settings.
  
  
  
  Correct the Data:
  
  If you identify specific records that are inconsistent, you may need to manually correct them. This could involve adding missing entries or correcting existing ones.
  Ensure that the entries in T042I (which contains the account determination for inventory postings) match those in T042Y (which contains the account determination for valuation).
  
  
  
  Transport Issues:
  
  If the inconsistency arose from a transport issue, ensure that all relevant transport requests are correctly imported and that the system is in sync.
  
  
  
  Consult SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates that can resolve known issues.
  
  
  
  Backup and Test:
  
  Before making any changes, ensure you have a backup of the current configuration. After making changes, test thoroughly to ensure that the issue is resolved and that no new issues have been introduced.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as OBYC (Automatic Account Determination), SE11 (Data Dictionary), and SE38 (ABAP Program Execution).
  SAP Notes: Regularly check for SAP Notes related to financial accounting and controlling, as they may provide additional insights or solutions for similar issues.
  Documentation: Review SAP documentation on account determination and configuration to ensure that you understand the relationships between the tables and the implications of any changes you make.
  
  If the issue persists after following these steps, it may be advisable to consult with your SAP Basis or functional team, or reach out to SAP support for further assistance.