SAP Knowledge Base Article - Public

2676441 - Error Message in Tax Subledger: Change or delete duplicate rows with key 'ABC' 'ABC' in 'Tax: Tax Payments'

Symptom

Error message is thrown when maintaining accounts for Tax Payable and Tax Pre-Payment within Tax subledger > Tax Payments tab:

Change or delete duplicate rows with key 'ABC' 'ABC' in 'Tax: Tax Payments'

ABC represents the Chart of Accounts ID.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Under Account Determination section, click Tax.
  5. Go to the Tax Payments tab.
  6. Notice that account AAA is maintained for Tax Payable and Tax Pre-Payment (AAA represents a G/L Account ID).
  7. Click Add Row.
  8. Enter G/L Account BBB for Tax Payable, Tax Pre-Payment or both (BBB represents a G/L Account ID).
  9. Click Save.

Error message is thrown:

Change or delete duplicate rows with key 'ABC' 'ABC' in 'Tax: Tax Payments'

Cause

For Tax Payments only one entry for Tax Payable and Tax Pre-Payment can be maintained per Account Determination Profile/Chart of Accounts.

Resolution

The system is behaving as expected. If there's the need of assigning more than one account for Tax Payable and Tax Pre-Payment, a new Chart of Accounts should be created. If that is the case, please refer to help document About Copy Chart of Accounts, available in the Help Center.

Keywords

Tax; Tax subledger; Tax Payments; Tax Payable; Tax Pre-Payment; , KBA , tax , tax subledger , tax payments , tax payable , tax pre-payment , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions