Microsoft Dynamics NAV 2017 Error: “The record already exists”
Issue:
While trying to integrate records from SFDC to Dynamics NAV 2017, I faced an issue in Scribe saying “The record already exists.”.
When I checked in Dynamics NAV 2017, there were no records similar to the one I was trying to integrate when the error occurred. Additionally, when I tried to create a new record in NAV, I got the same error if I filled some other field before filling out the ‘Name’ field.
Solution:
After some trial and error, I found that this error gets triggered when there is a record not having a value for ‘No.’ which is the Primary Key.
Once I deleted this record, creating new records in NAV was no longer an issue for Scribe.