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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Add an Entity to Maste...
Microsoft Dynamics AX (Archived)

Add an Entity to Master Data Management in AX 2012 R3

(0) ShareShare
ReportReport
Posted on by Ajay Kumar Y 218

Hi,

 I want to enable one standard entity to Master Data Management in AX 2012 R3 environment.

 I added one of the standard entities to MDM by following the steps mentioned in technet and I am able to replicate the data between legal entities in one AX instance.

But I want to do the same for another standard entity. The table which is part of this entity has no natural key. There the issue comes. To enable any entity to MDM, I have to use the natural key on the table which is part of that staging table in of the steps.

Since there is no natural key on this table, how can I enable it for MDM ?

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,880 Most Valuable Professional on at

    What does prevent you from creating a key?

    Even if forget MDM for a moment, how would you work with an entity without a key? How would you say during import whether a particular record already exists or not?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

    Hi Ajay,

    Can you tell which field or type of fields are in this table? Is it a standard or custom table?

  • Ajay Kumar Y Profile Picture
    Ajay Kumar Y 218 on at

    In continuation to the above query ...

     I have to use the below line of code while adding an entity to MDM.

     this.AxMdmCode = this.<staging table natural key field>;

    I have two scenarios where I need to implement MDM for the standard entities. So in this table,

    1. If there is no natural key for this table, how can I override the staging table insert method with the above line of code ?

    2. If there is a natural key with multiple fields for this table, how can I override the staging table insert method with the above line of code ?

  • Ajay Kumar Y Profile Picture
    Ajay Kumar Y 218 on at

    Hi Martin,

    Thank you for the reply.

    I want to use the standard entities like for example InventItemBarCode. I can not make natural key with the existing fields. If I do so, the existing data may be lost.

    More over, for this table, there is no natural key, but the for the staging table of this table has natural key on DisplayProductNumber.

    While importing, If I give the records in CSV file with same products, throwing error as "Error occurred while doing bulk copy from temp table to entity table-Violation of PRIMARY KEY constraint 'I_100476PRODUCTIDX'. Cannot insert duplicate key in object 'dbo.DMFPRODUCTBARCODEENTITY'. The statement has been terminated.'0' 'Barcode' record(s) inserted in staging" Because of the natural key exist on the staging table, it is not allowing me insert one more record.

    But I can create the same two records with the same products from UI (Bar code form). Since I have the duplicate record in original table, I am not able to update the second record through DIXF import.

  • Ajay Kumar Y Profile Picture
    Ajay Kumar Y 218 on at

    Hi André,

     I am using the standard entity. There are no custom fields even.

     For example, please consider the table 'InventItemBarCode' and the corresponding staging table is 'DMFProductBarcodeEntity'

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans