Error: "You’ve entered a value that has been assigned to another record..."

You’ll see the error “You’ve entered a value that has been assigned to another record. You can’t have two records with the same value” in Sage 50 Accounting for different reasons. Here are nine steps to help fix it.

Install the latest version on all computers

• Verify you've installed the latest version of Sage on all users' computers

Transaction accuracy

1. Verify if the item, customer, vendor, or project already exists.
2. Use the item, customer, vendor, or project number in the transaction.

Turn off the module and turn back on

1. Select Setup, User Preferences, then View.
2. Uncheck the affected module.
3. Select OK.
4. Close and re-open Sage 50.
5. Select Setup, User Preferences, then View.
6. Check the affected module.
7. Select OK.
8. Verify you no longer receive the message.

Remove all passwords

1. Open your company file in single-user mode with the sysadmin user.
2. Go to Setup, Set up Users & Roles.
3. Enter the sysadmin password.
4. Take a screenshot of the user’s setup screen (because you’ll have to recreate these users).
5. One by one, select each user and click Remove User, except the sysadmin.
6. Select the sysadmin and click Modify User.
7. Remove the sysadmin password: enter a character in the Enter Password box, press the Backspace key, and click OK.
8. Recreate the usernames and passwords for all users.
   • Add the email address if this is a file shared with RDA

Run DButil

1. Follow How to use the Database Utilities (Sage_SA_dbutil.exe).
2. Verify you no longer receive the message.

Problems creating a new customer or vendor record

1. Open the Purchase or Sales Invoice window.
2. Manually type in the new vendor or customer name.
3. Press the Tab key on your keyboard.
4. Select Quick Add - Just add the name for now. You can add detailed information later by editing the record.
5. Select OK.
6. Close the invoice.
7. Open the vendor or customer list and find the newly added vendor or customer.
8. Enter the vendor or customer information and select Save and Close.

The issue is related to adding a new inventory item 

1. Ensure the item name and number is different from other inventory items already stored.
2. Go to Reports, Lists, Inventory & Services.
3. Put a checkmark to include inactive items and internal services activities.
4. Select OK to preview the report.
5. Go to the top of the report.
6. If you see a blank line for item number with a quantity or value of 0.00, rename the item.
   • Open the inventory record with a blank inventory item number or description
   • Change the inventory number and name to something like 'missing' with a 'do not use' description
7. Save the record.
8. Verify you can create a new inventory record now.

The issue is related to a purchase order, sales order, or invoice

• Contact Sage Technical Support at 1-888-522-2722 for further help

Issues with the database

• Contact Sage Technical Support at 1-888-522-2722 for further help

 I can't add a new inventory item.