• de
  • en
    Search Results for

      Show / Hide Table of Contents

      Synchronizing Data in Business Central with Common Data Service

      When you integrate Common Data Service with Business Central, you can decide whether to synchronize data in selected fields of Business Central records (such as customers, contacts, and sales people) with equivalent records in Common Data Service (such as accounts, contacts, and users). Depending on the type of record, you can synchronize data from Common Data Service to Business Central, or vice versa. For more information, see Integrating with Dynamics 365 Sales.

      Synchronization uses the following elements:

      • Integration table mappings
      • Integration field mappings
      • Synchronization rules
      • Coupled records

      When synchronization is set up you can couple Business Central records to Common Data Service records to synchronize their data. You can start a synchronization manually, or based on a schedule. The following table provides on overview of the ways you can synchronize records.

      Type Method See
      Manual synchronization Synchronize on a record-by-record basis.

      You can synchronize individual records in Business Central, such as a customer, with a corresponding Common Data Service record, such as an account. This is typically how users will work with Common Data Service data in Business Central.
      Couple and Synchronize Records Manually
      Synchronize on a table mapping basis.

      You can synchronize all records in a Business Central table with an entity Common Data Service entity.
      Synchronize Individual Table Mappings
      Synchronize all modified records for all table mappings.

      You can synchronize all of the records that have been modified in Business Central tables since the last synchronization.
      Synchronizing All Modified Records
      Full synchronization of all data for all table mappings.

      You can synchronize all of the data in Business Central tables and Common Data Service entities that are mapped, and create new records in the destination solution for uncoupled records in the source solution.

      Full synchronization synchronizes all data and ignores coupling. Typically, you do a full synchronization when you set up the integration and only one of solutions contains data. A full synchronization can also be useful in a demonstration environment.
      Run a Full Synchronization
      Scheduled synchronization Synchronize all changes to data for all table mappings.

      You can synchronize Business Central with Common Data Service on scheduled intervals by setting up jobs in the job queue.
      Schedule a Synchronization

      Standard Entity Mapping for Synchronization

      Entities in Common Data Service, such as accounts, are integrated with equivalent types of entities in Business Central, such as customers. To work with Common Data Service data you set up links, called couplings, between entities in Business Central and Common Data Service.

      The following table lists the standard mapping between entities in Business Central and Common Data Service that Business Central provides.

      Business Central Common Data Service Synchronization Direction Default Filter
      Salesperson/Purchaser User Common Data Service -> Business Central Common Data Service contact filter: Status is No, User Licensed is Yes, Integration user mode is No
      Customer Account Business Central -> Common Data Service and Common Data Service -> Business Central Common Data Service account filter: Relationship Type is Customer and Status is Active. Business Central filter: Blocked is blank (Customer is not blocked).
      Vendor Account Business Central -> Common Data Service and Common Data Service -> Business Central Common Data Service account filter: Relationship Type is Vendor and Status is Active. Business Central filter: Blocked is blank (Vendor is not blocked).
      Contact Contact Business Central -> Common Data Service and Common Data Service -> Business Central Business Central contact filter: Type is Person and the contact is assigned to a company. Common Data Service contact filter: The contact is assigned to a company and the parent customer type is Account
      Currency Transaction Currency Business Central -> Common Data Service

      Tip for Admins: Viewing Entity Mappings

      You can view the mapping between the entities in Common Data Service and the tables in Business Central on the Integration Table Mappings page, where you can also apply filters. You define the mapping between the fields in Business Central tables and the fields in Common Data Service entities on the Integration Field Mapping page, where you can add additional mapping logic. For example, this can be useful if you need to troubleshoot synchronization.

      See Also

      Couple and Synchronize Records Manually
      Schedule a Synchronization
      Integrating with Dynamics 365 Sales

      In This Article
    • Privacy Policy
    • Legal Notice
    • © 2022 BEYONDIT GmbH