Synchronize master data across companies
Master data synchronization across companies in Business Central: how to set up a source and subsidiary companies to pull customer, vendor, item, and employee data, and how to manage and troubleshoot the synchronization afterward. It answers setup, coupling, scheduling, and maintenance questions.
- 2Learn pages
- 1videos
- 6AL objects
Path: Development and administration > Synchronize master data across companies · tier official · system administration · narrative reviewed (checked by Opus)
Overview
This section describes how to keep master data consistent between companies. A source company provides customer, vendor, item, and employee data, and subsidiary companies pull it in one direction. Updates run automatically through job queue entries.
The two pages follow the lifecycle. “Set up companies to synchronize master data” covers the initial configuration: export and import setup, table filtering, match-based coupling of existing records, initial synchronization, and job queue scheduling. “Manage master data synchronization” covers ongoing work: monitoring, handling schema changes, coupling records, overwriting local changes, and troubleshooting.
Start with the setup page if synchronization is not yet configured. Use the management page once it is running or when something goes wrong.
Key points
- Synchronization is uni-directional: subsidiary companies pull data from a source company.
- Supported master data includes customers, vendors, items, and employees.
- Updates run automatically through job queue entries, which can be scheduled.
- Setup involves export and import configuration, table filtering, and an initial synchronization.
- Match-based coupling links existing records between companies.
- Management tasks include coupling records, overwriting local changes, and running a full synchronization.
- Field mapping can be updated to handle schema changes.
- Synchronization can be monitored to troubleshoot issues.
Learn pages
- Manage master data synchronization: Learn how to manage master data synchronization.
- Set up companies to synchronize master data: Learn how to set up one or more companies to synchronize master data.
Videos and posts
Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.
- Copy Data Between Companies in Business Central (2 Built-In Methods You’re Probably Missing) (video): “copying data between companies; master data management; company synchronization”
Business Central pages and reports
The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.
- Page 672 “Job Queue Entries” · on Table 472 “Job Queue Entry”
- Page 5338 “Integration Synch. Job List” · captioned “Integration Synchronization Jobs” · on Table 5338 “Integration Synch. Job”
- Page 7230 “Master Data Management Setup” · on Table 7230 “Master Data Management Setup”
- Page 7233 “Master Data Synch. Tables” · captioned “Synchronization Tables” · on Table 5335 “Integration Table Mapping”
- Page 7234 “Master Data Full Synch. Review” · captioned “Master Data Initial Synchronization” · on Table 7233 “Master Data Full Synch. R. Ln.”
- Page 7236 “Master Data Synch. Fields” · captioned “Synchronization Fields” · on Table 5336 “Integration Field Mapping”
Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.