Unit Groups and Measure when syncing Items to Dataverse

(6) Share

Report

Posted on by AXEON Man

1,075

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 95,716 Super User 2025 Season 2 on at

Like (2)

Report

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,075 on at

Like (2)

Report

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,075 on at

Like (2)

Report

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. 20,441 Super User 2025 Season 2 on at

Like (3)

Report

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

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

Like (4)

Report

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

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

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