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.