Sage 50 Duplicate Entry Error

Mistakes do happen and they are a part and parcel of life. Right? Mistakes may happen while using a user-friendly accounting software like Sage 50 as well. One day, you may suddenly discover you have actually paid a customer twice inadvertently. This is the reason why we keep getting queries such as ‘How to resolve the Sage 50 Duplicate Entry Error’. The frequency of such questions has made us believe that this is a pretty common issue experienced by Sage 50 users.

If you are using Sage 50, you are nicely covered, even if you have made duplicate entries or payments. Whenever any duplicate entry is made, the user will get an error message as shown below-

Sage Error: “You have entered a value that has been assigned to another record. You cannot have two records with the same value.”

In this blog, we will look at a step-by-step procedure to resolve the issue of the Sage 50 Duplicate Entry Error.

Before diving into the troubleshooting part, let’s first have a look into why this issue occurs at all..

Read More : Reduce a Data Entry Errors

What Causes of Sage 50 Duplicate Entry Error?

Many technical issues often lead to the occurrence of this error message. Here are the most prominent ones-

• There is a duplicate entry in a customer, inventory item, project or vendor 
• An inventory item has become corrupt
• A project module has become corrupt
• Damaged company data file 
• A customer record has become corrupt

What is the Procedure to Fix Sage 50 Duplicate Entry Error?

Here, we will provide multiple solutions to fix this issue-

Method 1: If the Issue is Related to an Invoice, Purchase Order or Sales Order

You can perform the steps below:

• Go to the Maintenance section
• Click on Advance Database Check
• Choose File
• Click on Save as and type ‘test’ as the file name
• Open the Sales/Purchase Order that is leading to the issue
• Delete a line item and convert it into an invoice
• Try posting the invoice now
• If it posts alright then the deleted inventory item was corrupt. (if the invoice does not post, try Deleting another line item and converting it to an invoice)
• When the invoice gets posted, alter the inventory item name to ‘Not in Use’ or something similar
• Create a fresh item in the inventory list 
• Adjust the original order by adding this new item
• Post the order again
• Now post the invoice

Method 2: Turn off and on the Module

• Choose Setup
• Go to User Preferences
• Click on View
• Now uncheck the affected module
• Click OK
• Now close the Sage application
• Open the Sage program again
• Click Setup 
• Go to User Preferences
• Click on View
• Now check the affected module
• Click OK
• You should no longer receive the error message

Method 3: If you are Having Issues Creating a New Customer/Vendor Record

• Launch the Purchase/Sales Invoice window
• Go to Vendor/Customer
• Type the new vendor name 
• Press Tab on your keyboard
• Choose “Quick Add – Just add the name for now. You can add the detailed information later on by editing the record” 
• Click OK
• Next, close the invoice
• Open the vendor/customer list 
• Locate the vendor/customer added just now
• Type in the relevant vendor/customer information 
• Finally, click Save and Close

Method 4: Remove all Passwords

• Log in as a sysadmin user
• Open the company file in the single-user mode 
• Navigate to Setup / Setup Users
• Enter your sysadmin password
• Take a screenshot of the setup screen of the user for future reference 
• Select each user one by one and click on Remove User (except for the sysadmin user)
• The sysadmin user will be left after removing all the other users
• Click on it and click on the Modify User tab
• Remove the sysadmin password
• Type a character in the Enter Password box
• Press the Backspace key 
• Click OK to continue
• Now, recreate the usernames and passwords for all the users

Also Read : Detect Duplicate Emails in Sage CRM

Final Words

In the discussion above, we have shown you the step-by-step procedure to resolve the Sage 50 Duplicate Entry Error. If you are still troubled by this issue, or, if you are finding it difficult to perform these steps, we would recommend you to consult with some of the authorized Sage experts.

Frequently Asked Questions (FAQs)