Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Get the Item Unit of Measure conversion from Business Central to Dynamics CRM using custom integration.

Posted on by Microsoft Employee

Hi Expert

So from what I understand when we do out-of-the-box integration BC Unit of Measure and Common Data Service Unit Group gets synched.


8508.BC_5F00_UOM.png1581.CRM_5F00_UnitGroup.png

But if we see the "Item unit of measure" of BC Item which is coupled with CRM Product we see the unit of measure conversions in Business central but not in the CRM Product, see below screenshots.

7120.BC_5F00_Item_5F00_UOM.png0121.CRM_5F00_Unit.png

Now I want to synch the unit of measure conversion which are in BC "Item unit of measure table" with the "Unit" entity in Common Data Service to get the item unit of measure conversions in CRM side. Please correct me if i am wrong and also guide me on how it can be done?

Categories:
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Get the Item Unit of Measure conversion from Business Central to Dynamics CRM using custom integration.

    Hello,

    In table 27 in BC, there is ItemUnitOfMeasure. You need to figure out if it should go to CRM Product or CRM UoM.

    More information here:

    docs.microsoft.com/.../administration-custom-cds-integration

    Thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Get the Item Unit of Measure conversion from Business Central to Dynamics CRM using custom integration.

    Hi Marco

    I do understand that out of the box integration does not support what I have described, but is there a way to develop custom integration with Common Data Service to synchronize Business central "Item unit of measures" with Common Data Service.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Get the Item Unit of Measure conversion from Business Central to Dynamics CRM using custom integration.

    Hello,

    I did setup an integration between BC v170 and CDS/CRM. After performing a full synch, the results are like this:

    pastedimage1603116151255v1.png

    The default out of the box Units of Measures have been synched successfully.

    pastedimage1603116199135v2.png

    So I did create a new one:

    pastedimage1603116429297v3.png

    After creating a new Item in BC and after synchronizing the record to a product in CRM, the following result:

    pastedimage1603116874730v4.png

    Looking at integration table mapping, I do not see if there is a support for what you describe. 

    pastedimage1603119731470v8.png

    You may want to raise this via a feature request as I think that this is a good addition: https://aka.ms/bcideas .

    Thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Get the Item Unit of Measure conversion from Business Central to Dynamics CRM using custom integration.

    Hi Marco Mels

    Thanks for letting me know.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Get the Item Unit of Measure conversion from Business Central to Dynamics CRM using custom integration.

    Hello,

    I do have a task scheduled for a few other postings to setup an internal repro and then come back to you after I am done. I will add this posting to the list.

    Thanks.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans