Easy Connect Master Data Handling

Swedish Business Central view name: Easy Connect Master Data Handling

Master Data Handling in Easy Connect controls which tables and fields are synchronized from the Central company to subsidiary companies.
The purpose is to ensure that article data, price lists, and other master data remain consistent across all companies — eliminating manual duplication of work.

---

Overview #

Master Data Handling consists of two configuration layers:

Tables to synchronize #

Defines which Business Central tables the Central company will distribute.

Fields to synchronize #

Defines how each field is handled, including:

• whether it should sync or not
• value substitutions
• translations
• formula-based modifications

Synchronization direction #

Master data always flows from Central → Subsidiary.

Job Queue execution #

All master data is synchronized by the job:
WCM Job Queue Master Data

(Insert Image — Job Queue Entry Card)

This job can run on a schedule (recommended daily) and will automatically update all active master data mappings.

---

Master Data Handling – Table Level #

On this page you define which tables are included in the master data sync.

Field descriptions #

Field	Description
Company Name	Subsidiary company receiving the master data.
Table-ID	Business Central table ID (e.g., 7001 = Price List Line).
Active	Enables or disables synchronization for this table.
Table Name	Name of the table being synchronized.
Last Timestamp	Timestamp of the most recent successful synchronization.
Filter String	Business Central filter defining which records should be synchronized.
Syn. Message	A status message for the last run (success/error).

Example:
Only internal price lists where Field1 = INTERN-UK are sent to the UK subsidiary.

---

Easy Connect Master Data fields #

To go to master data field:

1. Easy Connect Master Data Handling
2. Click on Fields

Fields define the actual structure of how values are synchronized.

Field descriptions #

Field	Description
Table-ID	Business Central table the field belongs to.
Table Name	Business Central name of the table.
Field No.	Field number in Business Central.
Field Caption	Business Central name of the field.
Const. To Company Curr.	Converts values to the target company’s currency.
Sync. Field Only	Syncs only this field regardless of other settings.
Translation Table-ID / Name / Field No.	Optional value translation via lookup (e.g., language, country codes).
Translation Type	Defines how translations are applied (e.g., Language).
Formula Type / Value	Allows formula-based modifications (rare).
Substitute Value Type	Fixed Text or Field Value.
Substitute Value	Fixed override value (e.g., currency code should always be SEK).
Substitute Field No.	If substitute value comes from another field.

---

Typical Use Cases #

• Internal Pricing
  Automatically generate internal sales and purchase price lists between companies.
• Centralized Item Management
  Maintain article registry once and distribute everywhere.
• Vendor Mapping
  Subsidiary companies can automatically receive Central as the vendor.
• Value Translations
  Useful when different companies use different:
  • languages
  • country codes
  • naming conventions
  • category structures
    

---

Examples #

Example	Meaning
Substitute Value = P00001	Vendor is always set to Central company.
Substitute Value = SEK	Currency code should always be SEK
Substitute Value = IC-AS	Customer number for IC pricing is always IC-AS.

---

Synchronization Execution via Job Queue #

All master data synchronization runs via the job: WCM Job Queue Master Data

What the job does #

• Processes all active master data tables.
• Applies field-level substitution or translation.
• Respects filter strings.
• Updates only changed records for efficiency.
• Logs results on each table line.

Recommended configuration #

Setting	Recommendation
Recurrence	Daily (1D)
Start time	Outside business hours
Job Timeout	12 hours (default)
Monitor Active	Optional, depending on customer size

---