Sage 50 Duplicate Entry Error

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.

Accounting Professionals & Specialized Experts

Want quick help from accounting software experts? Get in touch with our team members who can install, configure and configure your software for you. Proficient in fixing technical issues, they can help you quickly get back to work whenever you encounter an error in Sage software. Our team is available 24/7 365 days to assist you. To get in touch.

Frequently Asked Questions (FAQs)

Is it Possible to Delete Duplicates in Sage 50?

Yes, this can be done in the following manner:
1. Navigate over to Banking
2. Next select the relevant bank account.
3. Go to the Activity tab
4. Next select the tick box located to the left of the transactions you wish to delete.
5. A toolbar will now be displayed above the list.
6. Go to the toolbar
7. Finally select the Delete icon.

How can a User Check for Duplicates in Sage 50?

In order to do this, you need to: 
1. Start by Clicking on Transactions.
2. Next click on Accounts audit.
3. Now Select the Identify possible duplicate transactions check box 
4. Next click OK.
5. Finally Enter the date range you want to check 
6. Lastly click OK.

What is the Reason for the Sage 50 to keep Crashing Down?

This problem could simply be because of the the access level within your Windows user. TIn order to test this, you need to log on as an administrator and try to launch Sage 50 Accounts. If you are still unable to log on as an administrator, try to run Sage 50 Accounts as an administrator: 
1. Start by Right-clicking on the Sage 50 Accounts shortcut
2. Next click Properties.

Related Posts

Further Reading