Error message in eConnect for Microsoft Dynamics GP: "Error Number = 3761 Record already exists, cannot insert"

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now


When you try to use eConnect to pass in a transactional document, eConnect for Microsoft Dynamics GP logs the following error message:

Error Number = 3761
"Record already exists, cannot insert"

This problem occurs if multidimensional analysis (MDA) is not registered.


This problem occurs because MDA data exists in the company database. This can occur when the Registration window is used to turn off MDA after transactions have already been created that contain MDA records.


To resolve this problem, follow these steps:


Make a backup of the company database.


Start the Support Administrator Console, Microsoft SQL Query Analyzer, or Microsoft SQL Server Management Studio. To do this, use one of the following methods, depending on the program that you are using.

• SQL Server Desktop Engine (also known as MSDE 2000): Start the Support Administrator Console. To do this, click Start , click All Programs , click Microsoft Administrator Console , and then click Support Administrator Console .
• SQL Server 2000: Start SQL Query Analyzer . To do this, click Start , click All Programs , click Microsoft SQL Server , and then click Query Analyzer .
• SQL Server 2005: Start SQL Server Management Studio . To do this, click Start , click All Programs , click Microsoft SQL Server 2005 , and then click SQL Server Management Studio .


Run the following SQL statements against the company database: delete DTA00100 delete DTA00200 delete DTA00300 delete DTA00301 delete DTA00700 delete DTA10100 delete DTA10200

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.