Manual Synchronization of Table Mappings | Microsoft Docs

An integration table mapping associates a Business Central table (record type), such as customer, with a Dynamics 365 for Sales entity, such as an account. Synchronizing an integration table mapping enables you to synchronize data in all records of the Business Central table and Dynamics 365 for Sales entity that are coupled. Additionally, depending on the configuration of the table mapping, synchronization can create and couple new records in the destination solution for uncoupled records in the source.

Manually synchronizing integration table mappings can be useful during the initial set up of an integration, and when diagnosing synchronization errors.

This article describes three methods for manually synchronizing integration table mappings. Each method provides a different level of synchronization.

Run a Full Synchronization

A full synchronization runs all the default integration synchronization jobs for synchronizing Business Central records and Dynamics 365 for Sales entities, as defined on the Integration Table Mappings page.

A full synchronization performs the following operations For Business Central or Dynamics 365 for Sales records that are:

The jobs are run in the following order to avoid coupling dependencies between entities.

  1. CURRENCY - Dynamics 365 for Sales synchronization job
  2. SALEPEOPLE - Dynamics 365 for Sales synchronization job
  3. UNITOFMEASURE - Dynamics 365 for Sales synchronization job
  4. CUSTOMER - Dynamics 365 for Sales synchronization job
  5. CONTACTS - Dynamics 365 for Sales synchronization job
  6. RESOURCE-PRODUCT - Dynamics 365 for Sales synchronization job
  7. ITEM-PRODUCT - Dynamics 365 for Sales synchronization job
IMPORTANT

You typically only use the full synchronization when you initially set up integration between Business Central and Dynamics 365 for Sales and only one of solutions contains data, which you want to copy to the other solution. A full synchronization can be useful in a demonstration environment. Because the full synchronization automatically creates and couples records between the solutions, it makes it faster to start working with synchronizing data between records. On the other hand, you should only run a full synchronization if you want a record in Business Central for each record in Dynamics 365 for Sales for the given table mappings. Otherwise, you can have unwanted or duplicate records in either Business Central or Dynamics 365 for Sales .

See the process for a full synchronization

To run a full synchronization

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter Microsoft Dynamics 365 for Sales Connection Setup, and then choose the related link.
  2. Choose the Run Full Synchronization action, and then choose the Yes button.
  3. When the full synchronization is completed, you can specify whether to allow scheduled synchronization jobs to create new records.

    If you want all synchronization jobs to create new records in the destination for uncoupled records in the source, choose Yes. This sets the Synch. Only Coupled Records field on the table mappings that are used by the synchronization jobs.

    If you want synchronization jobs to run as they did before the full synchronization with regard to creating new records, choose No. This sets the Synch. Only Coupled Records field to the setting it had before the full synchronization.

You can view the results of the full synchronization on the Integration Synchronization Jobs page. For more information, see View the Status of a Synchronization.

Synchronizing All Modified Records

You can use the Microsoft Dynamics 365 for Sales Connection Setup page to synchronize changes to data in all integration table mappings. This is similar to a full synchronization. It will synchronize data in all coupled records in the Business Central tables and Dynamics 365 for Sales entities that are defined in the table mappings. By default, only records that have been modified since the last time they were synchronized will be synchronized. The table mappings are synchronized in the following order to avoid coupling dependencies between the entities:

  1. CURRENCY - Dynamics 365 for Sales synchronization job
  2. SALEPEOPLE - Dynamics 365 for Sales synchronization job
  3. UNITOFMEASURE - Dynamics 365 for Sales synchronization job
  4. CUSTOMER - Dynamics 365 for Sales synchronization job
  5. CONTACTS - Dynamics 365 for Sales synchronization job
  6. RESOURCE-PRODUCT - Dynamics 365 for Sales synchronization job
  7. ITEM-PRODUCT - Dynamics 365 for Sales synchronization job

You can view the results of the synchronization on the Integration Synchronization Jobs page. For more information, see View the Status of a Synchronization.

TIP

By modifying the integration table mapping in advance, you can configure the synchronization with filters to control which records are synchronized, or configure it to create new records in the destination solution for uncoupled records in the source. For more information, see Modify Table Mappings for Synchronization.

To synchronize records for all tables

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter Microsoft Dynamics 365 for Sales Connection Setup, and then choose the related link.
  2. Choose the Synchronize Modified Records action, and then choose Yes.

Synchronize Individual Table Mappings

You can use the Integration Table Mappings page to run a synchronization job specific table mappings. This will synchronize data in all coupled records in the Business Central table and Dynamics 365 for Sales entity that are defined by the table mapping. By default, only records that have been modified since the last time they were synchronized will be synchronized.

By modifying the integration table mapping in advance, you can configure the synchronization job to create new records in the destination solution for uncoupled records in the source.

To synchronize records of an integration table mapping

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter Integration Table Mappings, and then choose the related link.
  2. Choose the Synchronize Modified Records action, and then choose Yes.

See Also

Synchronizing Business Central and Dynamics 365 for Sales
Setting Up Dynamics 365 for Sales Integration in Business Central



© 2019 Microsoft. All rights reserved.