When working with Customer Part Numbers, users may encounter the following error while adding a Customer Part Number to an item record:
“The customer part code already exists for this customer. Enter another code or select another customer.”
Why This Error Occurs:
A Customer Part Number can only be associated with a customer once, regardless of:
- The item on which it was originally created
- Whether the Customer Part Number record is active or inactive
If the same Customer Part Number already exists for the customer on another record, NetSuite prevents it from being used again and displays the error message above.
In some cases, if the Customer Part Number is inactive, it is not visible under the item’s Customer Part Number subtab, even though it still exists in the system.
How to Locate the Existing Customer Part Number:
One way to identify the existing inactive Customer Part Number record is by creating a saved search.
- Go to Lists > Search > Saved Searches > New
- Select Customer Part Number as the search type.
- Under the Criteria tab, add the appropriate filters (for example the item involved).
- Click Preview.
If an inactive Customer Part Number record is found, it may still prevent the creation of another record using the same Customer Part Number for that customer.
Solution:
If the inactive record is no longer needed, deleting it may allow a new Customer Part Number to be created successfully.
In another case, changing the record from Inactive to Active and saving it made the Customer Part Number visible again under the item’s Customer Part Number tab.
Note:
The ability to enter multiple Customer Part Names for a single customer per item record is currently a system limitation. An enhancement request has been logged:
Enhancement 508378: Customer Part Number > Allow the ability to enter multiple Customer Part Names for one customer per item record
