web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

MDM

(0) ShareShare
ReportReport
Posted on by 58

 

Hello,

I'm working on a multi-company MDM (Master Data Management) architecture in Business Central and I'm running into several errors and questions. I'll detail the full context so it's clear.

COntext / architecture:

I Have an OPERATIONS company, which is my parent company and centralizes all the information for all companies in the group.

My goal is to create several distinct subsidiary companies (a French one, a European one, an American one...) that retrieve, via MDM, only the OPERATIONS information that's relevant to them (for example, only France-related data for the French company)

To prepare this rollout, I created a PARAM company, which is a copy of OPERATIONS, set up for MDM: I selected all the synchronization tables I'm interested in, configured match-based coupling by choosing generally two fields per table, with "Synchronize after coupling" and "Create if no match is found" enabled.

I then copied PARAM to create my actual subsidiary companies (for example, a company "AX"). These companies automatically inherit the same MDM settings as PARAM, since they are direct copies of PARAM.

On each subsidiary company (AX), I configured MDM by choosing OPERATIONS as the parent/source company for synchronization — this is a single, active connection to OPERATIONS (PARAM only serves as the initial setup template, with no active synchronization connection).

Problem #1: local modification conflict

For a while, I didn't check the AX company. In the meantime, new vendors were created directly in OPERATIONS. The ongoing synchronization was supposed to automatically bring these new vendors into AX, but it didn't work: I got the following error:

"The data could not be updated due to the following error: Vendor record: V01276 has been modified locally since the last synchronization, and a different value for the field VAT Bus. Posting Group (FR-EXO) is being synchronized from the source record. Before retrying, open the synchronization tables, select Vendor, choose the Fields action, and either disable synchronization of VAT Bus. Posting Group, or set it to overwrite local changes. You can also choose to overwrite local modifications in the table."

I resolved this error by going to Synchronization Tables → Vendor → Fields, and checking "Overwrite local changes" on the VAT Bus. Posting Group field.

Problem #2: "account already exists" errors after resolving problem #1

Once this first conflict was resolved, I ended up with two new errors indicating that the (bank) account for certain vendors already existed. I don't understand the cause of these new errors, which seem to appear right after fixing problem #1.

Question about company-copy best practice:

When I copy PARAM to create a new subsidiary company, should I systematically:

 
 
  1. Remove "Create if no match is found" on all synchronization tables,
  2. Run the initial synchronization,
  3. Then re-enable "Create if no match is found" afterward?

Is this the standard procedure to apply every time a new company is copied from a template that already has "Create if no match is found" enabled, in order to avoid duplicate-record errors at startup?

Additional questions about the job queue

 
 
  1. I set the job queue's inactivity timeout to 5 minutes — is this a correct/recommended value for MDM synchronization, or is there a risk that this timeout is too short and causes tasks to be suspended prematurely?
  2. What is the exact benefit of having a dedicated service account for MDM, compared to using a personal or temporary user account?
  3. For some tables, I have no entries at all in the job queue. Does this mean these tables synchronize automatically and continuously without any way to verify whether synchronization actually occurred, or is this a sign that synchronization isn't scheduled for these tables at all?

Thank you in advance for your help.

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,960 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,299 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,131 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans