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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Unit of Measure not in Integration Table Mappings

(1) ShareShare
ReportReport
Posted on by 12
Hi experts,
 
I've just created a new company in Business Central. Just like the other companies I like to connect the new company to Dataverse and our Dynamics 365 CRM.
First I've run the /Dataverse Connection Setup/ and tested the connection. I got a /The connection test was succesful. The settings are valid/ response.
After that I ran the /Microsoft Dynamics 365 Connection Setup/. This connection is also working.
 
When I look at the /Integration Table Mappings/ there are a number of tables present but the /Unit of Measure/ table is missing.
This prevents me from coupling the items.
 
Does anybody know how I can get the Units of measure table in the Integration Table Mappings?
 
Thanks,
Paul
I have the same question (0)
  • CU08051312-0 Profile Picture
    2 on at
    Hi Paul, 
    We're running into the same problem you had in 2023. If you remember the resolution or if anyone can help us unblock this, I'd appreciate it.

    Macarena.
  • Suggested answer
    Saif Ali Sabri Profile Picture
    2,351 Super User 2025 Season 2 on at
    To resolve the issue of the "Unit of Measure" table missing from the Integration Table Mappings in Business Central when setting up a new company for integration with Dataverse (Dynamics 365 CRM), follow the steps below:

    ✅ Solution: Add Missing Integration Table Mapping
    1. Go to "Integration Table Mappings"
      • In Business Central, search for "Integration Table Mappings".
      • Confirm that the Unit of Measure mapping is indeed missing.
    2. Open "Integration Table Mapping Setup"
      • Search for "Integration Table Mapping Setup".
      • Select "Default Setup" (or create a new one if none exists).
    3. Run the Setup Wizard to Repopulate Mappings
      • In the Integration Table Mapping Setup, click "Actions" > "Functions" > "Create Default Mappings".
      • This action will repopulate the standard mappings, including Unit of Measure and others that may be missing.
    4. Confirm the Table Now Exists
      • Go back to "Integration Table Mappings".
      • Search for Unit of Measure. It should now be listed (typically as mapping to unitofmeasure in Dataverse).
    5. Publish Integration Table Mappings
      • Still within Integration Table Mappings, make sure to publish the mapping if it isn't already.
      • Optionally run "Synchronize Modified Tables" to ensure schema alignment with Dataverse.

    Additional Notes:
    • Make sure that the "Integration Synchronization Jobs" are running and that the Unit of Measure entity is selected for synchronization.
    • You may need to manually map or confirm mappings under "Integration Field Mappings" if you have customizations in Dataverse.
  • Sagar Dangar, MCP Profile Picture
    799 Super User 2025 Season 2 on at
    Hi,
     
    Issue:
    When you have Unit group mapping flagged ON you wouldn't find "Unit of measure" table in integration table mapping.
     
    Solution: 
     
    1. Disable sales integration setup
    2. make unit group mapping flag OFF
    3. enable Sales integration setup
    4. check integration table mapping, you will find "Unit of measure" table
     
     
    Thanks,
    Sagar Dangar,
    Microsoft Certified Business Central Developer

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,990

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,028 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans