The BC–Dataverse Integrator ensures consistent data synchronization between Microsoft Dynamics 365 Business Central (BC) and Dataverse. One important area requiring special consideration is the synchronization of Units of Measure (UoM).
Business Central and Dataverse use different data structures and architectures to store and manage Units of Measure. While Business Central defines Units of Measure within its own application framework, Dataverse manages them through its distinct unit and unit group model. Because of these structural differences, Units of Measure cannot be synchronized using a simple one-to-one approach.
This guide explains how the integrator bridges the architectural gap between the two systems, how mappings are established, and how to sync Units of Measures across Business Central and Dataverse.
Sync Unit of Measure from Business Central to Dataverse
- Navigate to the Integration Foundation Setup page
- Under the Business Central Setup menu tab, click on Create UOMs
For each Business Central Item, the integrator creates a Unit Group (uomschedule) in the following format:
| Name | <<Company Name>> – <<Item No.>> |
| Base Unit Of Measure | <<CompanyName>> – <<Item No.>> – <<Item Base UOM>> |
| Description | <<Company Name>> – <<Item No.>> |
For each additional Item Unit of Measure related to the item that is not the Base Unit of Measure, the integrator creates a new Unit of Measure in Dataverse under the Unit Group created for the item in the previous step and linked to the base unit of measure automatically created in Dataverse upon creation of the unit group, in the following format;
| Name | <<Company Name>> – <<Item No.>> – <<Item UOM Code>> |
| Quantity | <<Item UOM Qty. per Unit of Measure>> |