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

PZ850 - Overview

• 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