How To Fix G0036 - The totals table already contains entries for partner &1

G0036 - Overview

• Message type: E = Error

• Message class: G0 - Messages for SAP Consolidation

• Message number: 036

• Message text: The totals table already contains entries for partner &1

What causes this issue?

You want to change the length of consolidation units in dimension
<ZH>&V2&</>. However, entries with the partner <ZH>&V1&</> as the
account assignment already exist in the totals database. You should
only change the length of cons units in a dimension in exceptional
cases and if absolutely necessary.

System Response

If you want to continue and make the change, a new cons unit will be
created for third parties. The unit <ZH>&V1&</> will not be deleted for
reasons of consistency.

How to fix this error?

If you are sure that you want to make the change, you need to reverse
and repost all entries posted to the totals table, journal entries
table and financial data tables in the current fiscal year with the
cons unit <ZH>&V1&</> as an account assignment.

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 G0036 - The totals table already contains entries for partner &1 ?

  The SAP error message G0036, which states "The totals table already contains entries for partner &1," typically occurs in the context of financial postings, particularly when dealing with account balances and partner accounts in the General Ledger (G/L) or during the posting of documents that involve partner accounts.
  
  Cause:
  This error usually arises when there is an attempt to post a transaction that would create a duplicate entry in the totals table for a specific partner account. The totals table is designed to maintain unique entries for each partner account, and if an entry already exists for the specified partner, the system will prevent the new entry from being created to maintain data integrity.
  Possible Scenarios Leading to the Error:
  
  Duplicate Posting: The same transaction might have been posted previously, leading to an attempt to post it again.
  Incorrect Configuration: There may be issues with the configuration of the partner accounts or the way transactions