Scenario
- Create new or update Inventory Item via Lists > Accounting > Items > New> Inventory
- Create new Matrix Item via Lists > Accounting > Items > Matrix Item Assistant
- Create new or update Inventory Item or Matrix Item via CSV Import
Results:
Error: "You may not use duplicate accounts on an item"
Cause:
Manual (Accounting tab of item record) or CSV:
The error is encountered when the same account value is entered in more than one account field for the item
Examples:
- Entering in 1000 COGS under the COGS Account and Intercompany COGS field
- Entering in 2005 Variance Expense under Customer Return Variance Account and Vendor Return Variance Account (not applicable for CSV Import)
Matrix Assistant:
Field values used by Matrix Assistant to create the Matrix Item record source from Setup> Accounting > Accounting Preferences > Items/Transactions tab > Accounts portlet
An error is encountered when the same account value is entered in more than one field in the Accounting Preferences
Example: Entering in 2000 Sales under Default Income Account and Default Intercompany Income Account fields.
Solution
Ensure that accounts are unique across all of the Accounting Account Fields. If accounts are not included in the CSV Import File, check the Default Accounts by navigating to Setup > Accounting > Accounting Preferences > Item/Transactions Subtab > Accounts