When I populate the Build assemblies table from Quickbooks, I keep getting this error.
Failed: Violation of PRIMARY KEY constraint ‘PK_buildassembly’. Cannot insert duplicate key in object ‘dbo.buildassembly’. The duplicate key value is (5EB3-1230830875).: componentitemline in table buildassembly:-2147217873
I deleted it out and tried again, and then it fails on the next record. If I look in the componentlineitemdetail the records are all duplicated. I deleted 4 records and keep getting this error. So I think it is more than just a bad record in Quickbooks?
How do I prevent this error from happening?