When to try processing the Reconcile – Remove Sales Orders Utility in Sales Order Processing you receive the following error message:
“Violation of PRIMARY KEY constraint 'PKSOP30200. Cannot insert duplicate key in object 'dbo.SOP30200”
This message may indicate that the same order or invoice exists in both the SOP Work and SOP History table.
Determine if there are duplicate records between the SOP Transaction Work and SOP Transaction History. To have us determine if there are duplicate records for you, go to the "Fix it for me" section. To determine if there are duplicate records yourself, go to the "Let me fix it myself" section.
Option #1: Fix it for meTo determine if there are duplicate records automatically, click the Fix this problem button or link. Click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.
Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
Option 2: Let me fix it myself
Identify duplicate records in the Sales Order Processing tables yourself. The tables are:
SOP10100 - Sales Transactions Work
SOP30200 - Sales Transactions History
There is an Automated Solution available to perform this task titled "Duplicates in SOP". For more information about how to identify Sales Order Processing duplicate records, visit the Automated Solutions Page at the following link:
Note The Automated Solution will only find and report any existing duplicate records between the tables. It will not correct the issue. You must determine which records are duplicates and then you must manually delete those records after researching which record is incorrect.
Step 2: Delete duplicate records
Once you have determined which records are duplicates, research them to determine which record is valid and manually delete the duplicated record using SQL Server Management Studio. If you want assistance deleting duplicated records, contact your Partner, Technical Support for Microsoft Dynamics at 1-8888-477-7877, or open a chargeable support case.