Skip to main content

Notifications

Announcements

No record found.

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

Business Central Dynamics 365 CRM Integration - Customer Name issue

(0) ShareShare
ReportReport
Posted on by 15,433

Hi 

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 

  • Samantha73 Profile Picture
    Samantha73 2,480 on at
    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).  

  • MahGah Profile Picture
    MahGah 15,433 on at
    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?  

  • MahGah Profile Picture
    MahGah 15,433 on at
    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.

  • MahGah Profile Picture
    MahGah 15,433 on at
    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. 

    pastedimage1669817814113v1.png

  • Samantha73 Profile Picture
    Samantha73 2,480 on at
    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.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: Business Central Dynamics 365 CRM Integration - Customer Name issue

    Hi,

    Customer is already having a Bidirectional in field mapping.

    pastedimage1669798980075v1.png

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

    pastedimage1669799021288v3.png

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    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.

  • MahGah Profile Picture
    MahGah 15,433 on at
    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.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,274 Super User 2024 Season 1 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,602 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans