Business Central Master Data Management feature

Master Data Management feature

Master Data Management permits you to synchronize data between companies and maintain them in synch after the initial synchronization. Master data management is intended for scenarios where you want to move the setup in one company to another company in the same environment. It’s also built as a data synchronization engine that lets you keep data in the companies synchronized after the initial move.

The following capabilities are added for managing master data:

  • Moving master data works when a company subscribes to data from another company (please remember this! It’s not handled in a push way, but it’s based on a pull).
  • You can define the tables and fields to synchronize. For more control over the synchronization, you can filter on table records. You can also set up more advanced synchronization couplings.
  • Changes in the main company are immediately pulled to the receiving companies by the job queue.
  • Users in the receiving company can review synchronization logs.

How does it work?

To start using the new Master Data Management feature, from a company where you want to have data synchronized with a master company, open the Master Data Management Setup page and here select the Source Company and turn on Enable Data Synchronization:



The tables that will be synchronized from the Master company can be specified by using the Synchronization Tables page:



Here you can specify what are the tables to synchronize and for each table you can specify the fields and the filters to apply on records:



Now click on Start Initial Synchronization to start the first data synch:



The Master Data Initial Synchronization page opens. Here you can see the list of tables that are synchronized and the relative Synchronization Mode:

  • Full Synchronization: creates a new record based on the record in the soiurce company
  • Match-Based Coupling: existing records are matched with records from the source company accordingly on the criteria that you can set:


When you specify the fields to synchronize for each table, you can also specify if the field must be validated or if you need to overwrite local changes:



From the Master Data Initial Synchronization page you can select all the records you want to synch and then click Start All to start the first synchronization:



A job for scheduling data synch starts and you can see the results directly from the Master Data Initial Synchronization page:



If you have synchronization errors (like in VAT Posting Setup table in my case) you can click and inspect the error details:



For each synchronized tables you can check the Synchronization logs:



If you search for the Integration Synchronization Jobs page you can see the list of synchronization jobs executed and its corresponding details in terms of records synched:



    • Related Articles

    • Get Ready to Synchronize Master Data

      When two or more companies use some of the same master data, you can synchronize the data rather than add it manually in each company. For example, synchronizing data is useful when you're setting up new subsidiary companies. Master data includes ...

    • Master Data Synchronization (VIDEO)

      - Setting up synchronisation between companies. - Customising tables and fields for synchronisation. - Handling local changes to data in subsidiary companies. - Monitoring job queues and integration statuses. Timestamps: 0:01 Introduction 0:14 ...

    • Manage master data synchronization

      After you set up master data synchronization and synchronize for the first time, records in the selected tables are coupled and a recurring job queue entry is created for each table. The job queue entries automatically synchronize data in the ...

    • Count, Adjust, and Reclassify Inventory Using Journals

      In this article To count physical inventory To do cycle counting To adjust the quantity of one item To synchronize the adjusted warehouse entries with the related item ledger entries See also Physically count all of the items in inventory to ensure ...

    • Count and Adjust Inventory Using Documents

      In this article To create a physical inventory order To create a physical inventory recording To finish a physical inventory recording To complete a physical inventory orderShow 4 more You can take a physical inventory of your items by using physical ...