Hi,
First of all as per the error, it is likely related to permissions of the user you are using in BC or in NAV (if on premise) to connect to CRM.
Please check that the user is administrator, and has all the related permissions coming from the BC / NAV solution imported in CRM by the wizard (if you used it) or manually by you.
Afterwards, when you have some data inconsistency, it is usually related to some issues in the Integratino ID, let me explain this a bit:
The actual link between Dynamics NAV records and Dynamics CRM records is done via two tables:
- Table 5151 Integration Record
- Table 5331 CRM Integration Record
Integration records can be created automatically by running an action on CRM connection Setup page:
![]()
The problem is to create CRM Integration records. They contain a "CRM ID" - primary key of CRM entity and "Integration ID" that is primary key of Integration record that you have just generated via Generate Integration ID’s. Here we need some code that would go through all Dynamics NAV records and find a couple in Dynamics CRM.
E.g. Dynamics NAV Customer 10000 has a couple in Dynamics CRM where there is a field "Number" that also contains 10000. It can be other fields that are more or less unique: name, phone number etc. That will be different from table to table. Depends on actual data and the way they used it in old connector. This is the reason Microsoft did not create a topic on MSDN how to upgrade from CRM/NAV Connector to Dynamics NAV CRM Integration Solution.
When a couple is found, you have a RecordID for NAV record and CRM ID for CRM record. So you can create a CRM Integration record linking these two recs.
Unfortunately we never created such a tool that would help you linking NAV to CRM records based on some field matching. Though this will also consume a lot of time as you need to search for each record in Dynamics CRM. In next release of Dynamics NAV/BC, we are thinking og generating ID’s on the fly so that we do not have to run the action causing lots of time as it will do this for all tables. Generating IDs opens ability to link to the existing record or let the system create a new record in Dynamics CRM.
====
just to summarize, you can use the option 'generate Integratino ID' to solve some Integration ID discrapencies.
=======================================================================
As Per the documentation about the integration, we have plenty of articles to explain this, all around NAV as it is almost the same flow as in BC, but if you need an easier allrounder, please check these 2 videos, I think they are pretty good:
https://www.youtube.com/watch?v=A7OUwAnsmpg
https://www.youtube.com/watch?v=etJ7hT6Dquo
another one with business central is this one:
https://www.youtube.com/watch?v=i_3lUlilGUQ
Not mentioning everything but agood start.
I hope this helps.
Rahman
