web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

CRM Sales Order to BC Sales Order Integration

(0) ShareShare
ReportReport
Posted on by

Hi,

I'm looking at the Sales Order integration from CRM to Business Central. I'd like to see which fields integrate.

When I look at the Integration Table Mappings in BC I see everything (Contact, Account, Product etc.) but I don't see anything for Sales Order!

Where can I see which fields from Sales Order integrate to BC? Why does the Sales Order entity not integrate?

Integration-Page.PNG

Thanks, Steve

Categories:
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    The Sales Order Integration can be enabled on the Microsoft Dynamics 365 Connection Setup and this is the only entity where you can switch this functionality on or off. Then there is also the option to automatically create sales orders on the same page. There is indeed no visibility of a specific Integration Table Mapping created. A logical reason could be that Dynamics CRM in general is quite different from Dynamics BC and that these fields are already part of other integration table mappings though codeunit 5343 CRM Sales Order to Sales Order has been created specifically for this purpose. There is however a integration table mapping for Sales Invoices.

    If the above is not sufficient, I could of course ask around internally.

    Thanks.

  • Community Member Profile Picture
    on at

    There is an intermediate step when processing as well.  CRM creates a quote, then a CRM sales order that has to be submitted to BC.  Then inside of BC there is a separate list view of sales orders from CRM.  There you have to convert it into a BC Sales Order.  

    Best of luck!

  • sgtilt Profile Picture
    45 on at

    you can have orders created automatically by clicking the tickbox in the connection setup.

  • Mary Myers Profile Picture
    2 on at

    Marco,

    Do you know what the table name is for the sales order that get caught on the D365 Sales Order screen when they are missing a coupling.  THis is the table between CRM and the actual Sales order table

  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hi,

    Type ID Name

    1 5353 CRM Salesorder

    1 5354 CRM Salesorderdetail

    Thanks.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans