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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Integration table mapp...
Small and medium business | Business Central, N...
Suggested Answer

Integration table mapping in Business central with Dynamics field service (through dataverse) doesn't show all the tables

(2) ShareShare
ReportReport
Posted on by Smehra33 143

I successfully created a connection between CRM SAndbox environment and the Business central Sandbox env using dataverse connection. But the integration table mappings do not show all the tables which are present in CRM for mapping.

Please help, is it because I connected to the sandbox environment 

I have the same question (0)
  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,530 on at

    Hi,

    You need to add a record to integration table mapping, and below walkthrough help you to add a record.
    It is better you to read all the page's contents, especially the section "Create default integration table mappings and field mappings".

    Customizing an Integration with Microsoft Dataverse - Business Central | Microsoft Docs

    S.Kawamura

  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,530 on at

    Additional info

    Detail of the walkthrough above is below link. This is Zhu Yun's blog post. What he writes here is matching my experience.

    Dynamics 365 Business Central: Customizing an Integration with Microsoft Dataverse (Integrate custom tables) | Dynamics 365 Lab (yzhums.com)

    S.Kawamura

  • Smehra33 Profile Picture
    Smehra33 143 on at

    Thank you for the reply, but i am not even getting the basic integration table provided by crm and business central.

    pastedimage1638451217608v1.png

    If you can help please.

  • Smehra33 Profile Picture
    Smehra33 143 on at

    Just a quick info, I have not migrated my data from GP yet and integrating CRM to BC is that the right way to do. I am new to Dynamics ecosystem. Please guide me

  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,530 on at

    In the default setting, there are only less than 10 records in the Integration Table Mapping. 
    To add records to the Integration Table Mapping, you need to follow the steps described in the "Create default integration table mappings and field mappings" section of the Walk Through.
    And to perform the steps in this section, you need to start with the first section "To create the integration table for the worker table in Business Central".

    It is easy to link less than 10 tables that are prepared by default, but to link tables that are not prepared by default, we need to implement a long procedure as described in the walk through. Unfortunately, this is the fact that we are here.

  • inli Profile Picture
    inli 7 on at

    have you found an answer to your question please ? product and items must be a standard mapping. thanks

  • Elly Walker Profile Picture
    Elly Walker 119 on at

    Another option for integration is Skyvia. It is freemium and has a very intuitive UI.

  • Samantha73 Profile Picture
    Samantha73 3,247 on at

    Looking at the image you are missing the CRM integration. There are 2 components - base dataverse and CRM. Those tables are from the base so need to install CRM and you will see products. It's easy to add tables however the logic different status in D365 cRM vs BC is different making some integrations like Quotes very difficult

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans