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
-
Go to the Business Configuration work center.
- Go to the Overview view.
- Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
- Under Account Determination section, click Tax.
- Go to the Tax Payments tab.
- Notice that account AAA is maintained for Tax Payable and Tax Pre-Payment (AAA represents a G/L Account ID).
- Click Add Row.
- Enter G/L Account BBB for Tax Payable, Tax Pre-Payment or both (BBB represents a G/L Account ID).
- 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-TAX , Tax Management , How To