Small and medium business | Business Central, N...

Integration Between Bussiness Central and Dataverse(CRM)

(0) Share

Report

Posted on by Inkey Solutions

2,100

Hi,

We face below Integration Synchronization Errors while we do the integration between the Business Central and Dataverse (CRM).

Table Name: Customer

Integration Table Name : Account

Error 1. The data could not be updated because of the following error: The record is not open.

Error 2. Cannot couple {GUID} to this Customer record, because the Customer record is already coupled to {GUID}.

We could not sync all the records because of these errors, Can anyone please provide a solution for this?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

S.Kawamura 1,530 on at

Like (0)

Report

Hi,

As the error message says, the cause of the error is that you tried to couple an Account record in CRM (relationship is Customer) to a Customer in BC, but the Customer in BC has already been coupled to another Account record in CRM.

If the CRM Account record already coupled to the BC Customer record is an incorrect relationship, try decoupling it once and recoupling it again.

I hope this helps you

S.Kawamura

Was this reply helpful? Yes No
Inkey Solutions 2,100 on at

Like (0)

Report

Hi, we Tried this solution, we did decoupling and recoupling it again but still we get some another errors.
When we are trying to Run Dataverse Full Synch. Review Page we found the error in the field From Int. Table Job Status for a customer Name field.

Now, When we drill down on the error page we found the below error that says Customer already has a Contact Business Relation with Contact.

because of these errors,we can not sync all the records from the Dynamic CRM account table to the customer table in Business Central. please provide a solution for this?

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

The contact has a relation with a customer. You probably only decoupled the customer and now the contact is connected to another customer, etc.

Some cleanup in the data must be done to resolve the issues. To do so, also uncouple the contact belonging to C99990, etc. Verify if the contact is linked to what account in CRM, etc.

Thanks.

Was this reply helpful? Yes No