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

Business Central Dynamics 365 CRM Integration - Customer Name issue

(2) Share

Report

Posted on by MahGah

15,529

I have tried BC/CRM integration but ran to the issue. If I turn "bidirectional" in D365 Connection than in Field Mapping I have "Customer Name" field. But if I turn off "bidirectional" than I do not have that field which creates Quote/SO in CRM without customer name. But "bidirectional" does not sync Quote between BC/CRM. (meaning quote from BC does not create Quote in CRM).

How you can integrate BC and CRM that first populate customer name and second integrate Quote from BC to CRM?

Thanks

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

DAnny3211 11,391 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

hi

look this

community.dynamics.com/.../issues-in-business-central-and-d365-for-sales-integration

DAniele

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Thanks DAnny3211

I reviewed that post but still if I do not select "bidirectional" than customer name is missing from BC Table/field mapping. Only "bidirectional" shows that field. Which as a limitation does not let to sync quote. I tried all suggestions in that post without the success.

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Hello,

Not sure if I understand the issue but if you leave everything default as out of the box, the issue does not occur? You may want to set a filter if you do not want to synch specific records to synch to the other app / other way around.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Hi,

Customer is already having a Bidirectional in field mapping.

Also you can work on Sales order from Sync BC to CE not Quote, as in standard system this not available.

Was this reply helpful? Yes No
Samantha73 3,205 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Are you sure "bidirectional" sync for quote is available in BC standard? Can you refer to MS documentation? Last time I checked, you have to develop this.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Hi Marco Mels

Thanks. As you suggested maybe I am missing something here.

If I leave "bidirectional" off then go to Integration Table Mapping -> SALESORDER-ORDER -> Mapping -> Fields then I do not see "sell to customer no" field. This field is only available if I turn on "Bidirectional". As a result if I turn off "bidirectional" than in Fields I setup "bidirectional" than all SO will created in CE but without customer name.

I wonder why this field is missing when "bidirectional" is off.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Hi Nitin

Thanks. That makes sense. If this is not available than I am good. My confusion was with turning off "bidirectional" if you turn that one off then in filter section of Integration Table you can filter Quote/SO. My assumption was if you can filter here than sync should happen. but looks like I was wrong.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

Samantha73 I was under assumption that if I turn off "bidirectional" than go to "integration table" then you can set the filter for Quote. Which means based on documents it should sync quote. But looks like my understanding was not accurate.

I know you have worked on this before. Based on your experience what is the best setup here? and if you did customization for quote how you did it?

Was this reply helpful? Yes No
Samantha73 3,205 on at

Like (0)

Report

RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

My view is that it's almost impossible to implement BC--CRM sync without customisation. Normally I change the unique field to sync as well - for example, Account number to BC customer code. Add fields as required. The tricky bit is document sync as the two systems have different design principles (archiving in BC and versions in CRM for instance).

Was this reply helpful? Yes No
SamikK 46 on at

Like (0)

Report

Business Central Dynamics 365 CRM Integration - Customer Name issue

That’s a classic pain point with the standard connector. For more control over the mapping (including customer name) and sync quotes reliably from BC to CRM, you might check out Skyvia, a third-party tool. It is one option that gives more flexibility here.

Was this reply helpful? Yes No