News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Integration Manager: &...

Finance | Project Operations, Human Resources, ...

Answered

Integration Manager: "cannot insert duplicate key in object...SOP10106..."

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello:

Integration Manager is not importing sales invoices due to an error message that states something along the lines of "cannot insert duplicate key in object...SOP10106...".

There are no duplicate records in this User-Defined Work and History table and, in fact, the only field in Integration Manager's mapping is represented by a script as follows:

If(SourceFields("TYPEInv") = "5") then

CurrentField.Value = "Member"

else

CurrentField.Value = "Employer"

end if

Do you all have any thoughts on how to eliminate this error?

Thanks!

John

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

GMA 1,072 on at

Like (0)

Report

RE: Integration Manager: "cannot insert duplicate key in object...SOP10106..."

I took a look at the key for table SOP10106 and it is just SOPNUMBE and SOPTYPE. Are you certain none of the records you are importing match those two fields with anything already in the table?

Another idea would be if source file you are using has the data duplicated.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans