Unit Groups and Measure when syncing Items to Dataverse

(6) Share

Report

Posted on by AXEON Man

1,155

We are migrating to BC from a legacy Accounting Solution but have been Dynamics CRM users since 3.0.

I'm at the point of integration to get our product catalog imported into BC and sync it to Dynamics CRM/Sales.

I have two test items in BC and when I sync them, I get a new "Active Unit Group" each time to accommodate the "Pcs" unit of measure.

This is the result:

The "Item 1003... and Item 1004..." are the result of manually coupling/creating products in Sales from BC.

I've got something like this in each for Associated Unit Groups:

I certainly don't need a new Unit Group or Unit of Measure for every item I syn with CRM/Sales.

How can I make this work?

Oh, this is my current Integration Table Mappings:

Thanks,

Jason

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

YUN ZHU 97,970 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, it looks like the Unit Group is not enabled? Try enabling it and try again.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
AXEON Man 1,155 on at

Like (2)

Report
Copy link

Link copied!

That checkbox is just to limit sync jobs to already coupled-records. It is in the tables list and syncing, just doing it wrong.

Was this reply helpful? Yes No
AXEON Man 1,155 on at

Like (2)

Report
Copy link

Link copied!

Do I just need to accept that every item sync'd from BC will create a new Unit Group -I've got nearly 1000 items, that seems very messy when the actual unit of measure is the same from multiple items and I don't need new unit groups, or shouldn't need them as I see it.

Was this reply helpful? Yes No
Verified answer

Khushbu Rajvi. 21,573 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Please check if this helps: https://www.youtube.com/watch?v=vdmb6sp0Nl8

Was this reply helpful? Yes No
AXEON Man 1,155 on at

Like (4)

Report
Copy link

Link copied!

THANK YOU! My Google-Fu couldn't find that video. Perfect.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,666 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/admin-prepare-dynamics-365-for-sales-for-integration

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/data-synchronization

Was this reply helpful? Yes No