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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Dynamics 365 Sales integration

(0) ShareShare
ReportReport
Posted on by

Hello,

Did anyone managed to synchronize custom fields between Dynamics 365 Sales and Business Central?

I managed to do all the settings for the integration, to sync accounts, articles etc. but we cannot add our custom fields (or other standard fields in addition to the default ones) in the Integration Field Mapping List.

Thank you

I have the same question (0)
  • Andy Sather Profile Picture
    on at
    RE: Dynamics 365 Sales integration

    After some research, if we look through the documentation, where give example code on how to do this: docs.microsoft.com/.../administration-custom-cds-integration, It does look like you have to have a Primary ID.

    "

    To connect a Business Central table record with a Common Data Service entity record, you create a coupling. A coupling consists of the primary ID, which is typically a GUID, from a Common Data Service record and the integration ID, also often a GUID, from Business Central.

  • Terrance Morgan Profile Picture
    515 on at
    RE: Dynamics 365 Sales integration

    Integrating the applications lets you access data in Sales from Business Central, and in some cases the other way around. You can work with and synchronize data that both services have in common, such as customers, contacts, and sales information, and keep the data up to date in both applications.

    For example, a salesperson in Dynamics 365 Sales can use the price lists from Business Central when they create a sales order. When they add the item to the sales order line in Dynamics 365 Sales, they can see the inventory level (availability) of the item from Business Central.

    Conversely, order processors in Business Central can handle sales orders that are automatically or manually transferred from Dynamics 365 Sales. For example, they can create and post-sales order lines for items or resources that were entered in Dynamics 365 Sales as write-in products. For more information.

  • Community Member Profile Picture
    on at
    RE: Dynamics 365 Sales integration

    Thank you for your answer, but I think I haven't made myself clear on what my problem is.

    I will try to be more specific.

    Out customer has some custom fields created in Dynamics Sales on the product table. We created the same fields in Business Central in an extension for the Item table. Now, how do I map those custom fields? How do I add them on the Integration Field Mapping List below? (the list for the Item table of course, not the Contact as presented in this image). Because this page has the property insert allowed set to false.

    integration_5F00_table_5F00_field_5F00_mapping_5F00_contact_5F00_detail.png

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Dynamics 365 Sales integration

    We managed to solve this problem by creating an extension that adds from AL new record in the Integration Field Mapping List.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,275

#2
Sumit Singh Profile Picture

Sumit Singh 2,677

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans