Skip to main content

Error: 'You have entered a value that has been assigned to another Transaction. You cannot have two Transactions with the same value. , ID: E95'

How to resolve the ID: E95 error in AutoEntry (integrating with Sage 50 Canada)

Sukhi avatar
Written by Sukhi
Updated this week

You are integrated with Sage 50 Canada, and when publishing an invoice, the following error occurs:

You have entered a value that has been assigned to another Transaction. You cannot have two Transactions with the same value. , ID: E95

Resolution

To clear the error, follow the steps below in Sage 50:

  1. Backup your Sage data by going to File > Backup.

  2. Close Sage.

  3. In your PC's File Explorer, paste in the path C:\Program Files (x86)\Sage 50 202x\dbverifier (replace 'x' with the year of your program's edition).

  4. Click into dbverifier > Sage_SA_DBVerifier.exe and run that program. If you have setup sysadmin password for the data file, you will be asked to key in the sysadmin password when running the test.

  5. Once these steps have been completed, try to publish the affected invoice again in AutoEntry.

📌TIP: For more information on this process, check the article from Sage knowledge base How to use the Database Utilities.

If the error persists

Depending on your set up the following error can occur after the above steps:

This company is shared. You cannot user sage 50 file check & repair tool to scan this company.

You need to contact Sage 50 support to help you troubleshoot this issue.

📌TIP: Always check your Sync App integration status. This could also solve the issue.

Did this answer your question?