Coupling and Synchronizing Records between Dataverse and Business Central

This topic describes how to couple one or more records in Business Central with records in Dataverse or Dynamics 365 Sales. Coupling records lets you view Dataverse information from Business Central, and vice versa. The coupling also enables you to synchronize data between the records. You can couple existing records, or create and couple new records.

Note

Coupling and synchronizing data is available only if your system administrator has created a connection between Business Central and Dataverse or Dynamics 365 Sales. A quick way to check is to open the Customer card and look for the Set Up Coupling action. If the action is available, the apps are connected.

Video Example

This video shows coupling and synchronizing data in the context of an integration with Dynamics 365 Sales.

To couple a record

  1. In Business Central, open the card for the record you want to couple. For example, the Customer or Contact card.

    You can also just open the list page and select the record that you want to couple.

  2. Choose the Set Up Coupling action.

  3. Fill in the fields, and then choose OK.

To synchronize a single record

  1. In Business Central, open the card for the record you want to couple. For example, the Customer or Contact card.
  2. Choose the Synchronize Now action.
  3. If a record can be synchronized in one direction, select the option that specifies the direction of data update, and then choose OK.

To synchronize a single record from Dynamics 365 Sales

  1. In Dynamics 365 Sales, open the form for the record you want to couple. For example, the Account card or Contact card form.
  2. Choose the Business Central action in the ribbon to open and couple record automatically.

Note

You can synchronize a single record from Dynamics 365 Sales automatically only when Sync. Only Coupled Records is disabled and the synchronization direction is set to Bidirectional or From Integration Table on the Integration Table Mapping page for the record. For more information, see Mapping the Tables and Fields to Synchronize.

To couple multiple records using match-based coupling

You can specify the data to synchronize for an entity, such as a customer or contact, by coupling records based on matches. You can refine the matches by making the search case sensitive, and assigning a priority for each match. If no match is found, you can also specify that you want to create the entity in Dataverse. For more information, see Customize the Match-Based Coupling.

  1. In Business Central, open the list page for the record, such as the Customers or Contacts list pages.
  2. Choose the Match-Based Coupling action.
  3. Fill in the fields as necessary. Hover over a field to read a short description.

To synchronize multiple records

  1. In Business Central, open the list page for the record, such as the Customers or Contacts list pages.
  2. Select the records that you want to synchronize, and then choose the Synchronize Now action.
  3. If records can be synchronized in one direction, select the option that specifies the direction, and then choose OK.

Uncoupling Records

You can uncouple one or more records from list pages or the Coupled Data Synchronization Errors page by choosing one or more lines and choosing Delete Coupling. You can also remove all couplings for one or more table mappings on the Integration Table Mappings page.

See Also

Use Dynamics 365 Sales from Business Central

Business Central on Microsoft Learn