Activities

Activity Area Description

Actions on pulled master record in source company

Master Data Management

In the target company, you can pull master data from the source company. When you have done so, depending on the status of the master record, data steward actions can be required in the source company:

Master record status Required actions in source company
New As a data steward in the source company, approve, release, and send the master record.
Approved As a data steward in the source company, release and send the master record.
Released

As a data steward in the source company, send the master record.

Note: If you pull master data with status Released, and on the Pull master data dialog, in the 'Send master data' field, you select 'Yes', the master data is directly sent to the target company or to the MDM staging journal. The source company data steward does not have to send the master data.

Approve master record

Master Data Management You can approve the master data records that you have edited.

Cancel master record change request

Master Data Management

When you have decided to not make the requested changes to a master record, mark the change request as Cancelled.

Cancel master record release

Master Data Management

You can change a master record after it is released. To do so, cancel the release of the master record. As a result, the status of the record is changed to Cancelled.

You can again edit, approve, and release a cancelled master record.

Complete master record change request

Master Data Management When you have finished making the requested changes to a master record and have sent it to the applicable target companies, mark the change request as Completed.

Create master record change requests

Master Data Management

In the target company, a change can be required for a master data record. To inform the source company of the required change, create a master record change request.

When created, the change request is shown in the source company and can be picked up for further processing in the source company.

Create MDM project

Master Data Management
Use a Connectivity studio project as the basis for master data management setup. Most Connectivity studio elements are linked to a project, for example, documents, connectors, and messages. Because these elements are related to a project, you can also use a project to deploy MDM studio setup and do version management.
For a project that is used for master data management setup, make sure to set the project Purpose to 'Mdm'.

Define master records

Master Data Management For each master data entity, you can define which records are master records. To make a master data entity record a master record, subscribe it to a company. If a master data entity record has a subscription to a company, the record is defined as master data for that company.

Discuss master record change request

Master Data Management The data steward of the source company can start a discussion on the created master record change request. The discussion is shown in the Discussion section of the Master record change request page.
This topic explains how to enter a response to the source company data steward.

Edit master record

Master Data Management

With MDM studio you can manage master data. For a master data record, you can edit the:

  • Status
  • Responsible data steward
  • Subscribed target companies
  • Related D365 FO record

Monitor master data errors

Master Data Management

As a data steward in the source company, you can monitor the errors that occurred when master data was sent to the target company.

You can monitor master data errors on the Master data management - Operation workspace, on the Master data errors tab. This tab shows the same data as the Master data inbox in the target company. However, here only the master data records are shown for which an error occurred when sent.

The error can for example be a data error, an error in the message, or an error in the message run.

To investigate the master data error, you can follow the steps to:

  • Monitor the master data inbox.
  • Monitor the master data staging journal, if staging is applicable.

Monitor Master data inbox

Master Data Management

When a source company releases a master record, it is added to the Master data inbox of the target company.

The added record has the status To be processed. You can only view the record.
When the source company runs an MDM message and no errors occur, in the Master data inbox, the status of the record is changed to processed. This indicates that the master data is imported in the database of the target company or in the staging journal.
Possible statuses of the Master data inbox are:
  • To be processed: Status after the record is released.
  • In processes: The MDM message is running.
  • Processed: The master data is imported in the database of the target company or in the staging journal.
  • Cancelled: The release of the record is cancelled by the data steward of the source company.
  • Error: An error occurred when running the MDM message.
Note: Monitor the Master data inbox in the target company.

Monitor master record change requests

Master Data Management In the target company, a change request can be created for a master data record.
As a data steward of the source company, monitor the master record change requests in the source company.
You can start a discussion with the user who created the change request in the target company.
When the required changes are clear and agreed upon, as a next action, you can start making the changes.

Monitor MDM staging journal

Master Data Management

If you use staging in your master data process, master records are imported into the staging journal by the ‘Data to staging’ message. You can monitor the master record staging journals in the target company.
Each time a ‘Data to staging’ message is run, all related master records (with status Released) are imported into the staging journal. For each message run and target company combination, a journal is added to the MDM staging journal. Each processed master record results in a line in the relevant journal. For each line, all the fields, as defined in the document, are shown with the related values.

Staging journal validations

The master records in the staging journal can be validated according to the applicable staging journal validation setup. If the applicable validation rules are:

  • Met, the staging journal line is automatically approved. Depending on the master data entity setup, the approved lines are processed automatically by the 'Data from staging' message or you must manually run this message.
  • Not met, an error or warning is given. Before the line can be processed further, review the errors and warnings, and take appropriate actions.

If you use data comparison, you can also apply a staging journal validation. This validation defines what happens with journal lines with data differences. If you manually generate a data comparison, make sure the data comparison is done before you manually apply staging journal validations.

To apply a staging validation, in Connectivity studio, in the Staging display options, for the desired record, set up a validation with the BisValidationMdmDifference validation class. The Exception behavior and Type settings of the validation setup define what happens if differences are found. For more information, refer to Set up staging validations

Pull master data

Master Data Management

In the target company, as a data steward, you can pull master data from the source company.

Pull master data with dynamic button

Master Data Management

In the target company, as a data steward, you can use a dynamic button to pull master data from the source company.

From which pages you can use the dynamic button is defined by the dynamic button setup.

Release master record

Master Data Management

You can release approved master records.
If you release a master record, it is added to the Master data inbox of the target company.

You cannot change a released master record.

Send master record

Master Data Management Run the master data messages to send released master records to the target companies or to the MDM staging journal. All messages, as defined for the master data entity, are run.
The master data entity messages process all Released master records of the master data entity.

Set up dynamic button to pull master data

Master Data Management

In the target company, to any D365 FO page, you can add a dynamic button to pull master data from the source company.

As a result, to the Action Pane of the D365 FO page, the Master data management tab is added with the dynamic button. The dynamic button opens a page showing the available records. Which page is opened, is defined in the Dynamic menu form setup of the applicable master data entity.

For example, to the Sales orders (SalesTable) page, you can add a dynamic button to pull customer accounts to the current company.

Set up external company

Master Data Management Set up an external company for each external application to which you want to send master data.

Set up master data entity

Master Data Management

Use a master data entity to define:

  • Which table holds master data.
  • Who sends this master data.
  • Where you send this master data to.
  • How you select the right master record.

Prerequisites:

  • Company setup
  • Connectivity studio setup

Set up MDM message - Data from staging

Master Data Management

To send data form a staging journal to a target company, you need two connectors, two documents, and a message.
For the 'Data from staging' message, you can re-use the connectors and documents that are used for the 'Data to staging' message. 
Make sure you use the:

  • Source connector and document of the ‘Data to staging’ message as target connector and document on the ‘Data from staging’ message.
  • Target connector and document of the ‘Data to staging’ message as source connector and document on the ‘Data from staging’ message.
Note: This results in a mirrored mapping compared to the mapping of the ‘Data to staging’ message. The target records and fields become the source records and fields, the source records and fields become the target records and fields.

For more information on setting up connectors, documents, and messages, refer to Connectivity studio.

Set up MDM message - Data to staging

Master Data Management

To send data from a source company to a staging journal, you need two connectors, two documents, and a message. 

To set up these components for MDM studio, some specific setup is required:

Component Description
Source connector

Use a source connector of type 'D365 FO'.

Target connector

Use a target connector of type 'Staging journal'. Make sure the 'BisConnectorStagingJournal' handler class is used.

Source document

The required setup for a source document is:

  • Document type: D365 FO
  • Handler: BisMdmDocumentAxDatabase
Target document

The required additional setup for the target document is:

  • On the document header:
    • Document type: 'Staging'
    • Journal type: Enter the name of the staging journal.
    • Number sequence: Select the number sequence for the staging journal.
    • Journal table: Select 'BisStagingBufferOrderJournal'. Usually, this journal table is used.
  • On the document lines:
    • For each record, in the Record table field, enter 'BisStagingBufferTable'.
Message

The required setup for a 'Data to staging' message is:

  • On the message header, in the 'Update source status' section:
    • Status field: MessageStatus
    • Processed status: Processed
    • Error status: Error
  • On the message header, in the 'Custom' section:
    • Handler: BisMdmMessageRunDirectV2 

For more information on setting up connectors, documents, and messages, refer to Connectivity studio.

Set up MDM message - Direct

Master Data Management

To send data directly from a source company to a target company, you need two connectors, two documents and a message.

To set up these components for MDM studio, some specific setup is required:

Component Description
Source connector Use a source connector of type 'D365 FO'.
Target connector Use a target connector of type 'D365 FO'.
Consider re-using the source connector as target connector.
Source document The required specific setup for a source document is:
  • Document type: D365 FO
  • Handler: BisMdmDocumentAxDatabase
Target document The required specific setup for a target document is:
  • Document type: D365 FO
  • Handler: BisMdmDocumentAxDatabase
Consider re-using the source document as target document.
Message The required setup for a 'Direct' message is:
  • On the message header, in the 'Update source status' section:
    • Status field: MessageStatus
    • Processed status: Processed
    • Error status: Error
  • On the message header, in the 'Custom' section:
    • Handler: BisMdmMessageRunDirectV2

For more information on setting up connectors, documents, and messages, refer to Connectivity studio.

Set up MDM message - External application

Master Data Management

To send data from a source company to an external application or location, you need two connectors, two documents, and a message. 
To set up these components for MDM studio, some specific setup is required:

Component Description
Source connector

Use a source connector of type 'D365 FO'.

Target connector

Use a connector of a type other than 'D365 FO' or 'Staging', for example, ODBC or Windows folder. 

Source document

The required setup for a source document is:

  • Document type: D365 FO
  • Handler: BisMdmDocumentAxDatabase
Target document

Use a target document with the desired external document type, for example, XML or JSON.

Message

The required setup for an 'External application' message is:

  • On the message header, in the 'Update source status' section:
    • Status field: MessageStatus
    • Processed status: Processed
    • Error status: Error
  • On the message header, in the 'Custom' section:
    • Handler: BisMdmMessageRunDirectV2 

For more information on setting up connectors, documents, and messages, refer to Connectivity studio.

Set up MDM messages with wizard - Direct

Master Data Management

In MDM studio, you can use the Create MDM message wizard to create the message for an internal direct master data setup. With an internal direct master data setup, you send data from the source (master data) company directly to the target company.

With the wizard, you create the:

  • Documents that are used in the MDM message.
  • MDM message.

Set up MDM messages with wizard - Staging

Master Data Management

In MDM studio, you can use the Create MDM message wizard to create the messages for an internal staging master data setup. With an internal staging master data setup, you send data from your source company to a staging journal. The target company triggers the message to send the data from the staging journal to the target company.

With the wizard, you create the:

  • Documents that are used in the MDM messages.
  • MDM message to send data from the source company to the staging journal (data to staging message).
  • MDM message to send data from the staging journal to the target company (data from staging message).

Set up staging

Master Data Management In MDM studio, you can use a staging journal to send master data. If you send data, it first goes to the staging journal.
This topic explains how to initialize staging for a document.

Set up standard company

Master Data Management

For each standard company, define the data stewards. 

A data steward is a user in D365 FO who can send and release master data for the sending company and can receive the data for the target company.

Set up target group

Master Data Management If you send the same master data in the same way to several companies, you can group these companies in a target group. 
You are advised to use separate target groups for standards companies and external companies.

Provide feedback