Blog

Microsoft Dynamics AX Blog

5

Populating Data from Different Companies

I came across a case where I needed to select a field value from different companies in Dynamics AX.

Simply what you have to do is the following (I choose ItemId to be taken from different companies as an example):

  1. Create a field in your table with an ExtendedDataType than has NO relation, MyNewItemIdEDT in our example
  2. Create an ItemCompany field, put the extended data type as dataAreaId
  3. Create a Relation in that table with the following elements (Normal relation elements):
    • <<NewTableName>>.MyNewItemId == InventTable.ItemId
    • <<NewTableName>>. ItemCompany = InventTable.dataAreaId

 

By this you would be able to select the ItemId field based on the selected dataareaid without writing any code even. :)

Dynamics AX 2012 Event

Recent Posts

Tags

Archives

Random Testimonial

  • ~ Ahmad Al-Shanshoury, Senior Dynamics AX Consultant at Al-Fanar IT

    ahmed el shanshoury"I am pleased to be able to write this recommendation for Mr. Amer Atiyah, I was lucky to work with Amer during our implementation of Dynamics AX at AlOthaim company. Since the day one, I know him as an energetic and goal-oriented person Amer demonstrated a strong work ethic and a dedication to success. His efforts have produced high quality results time and time again.His extraordinary ability to analyze problems and outline necessary courses of action was invaluable, simply I can see Amer innovative, creative, intelligent and ambitious, in addition of his powerful Technical background. Seldom have I been able to recommend someone without reservation. It is a pleasure to do so in the case of Amer"

  • Read more testimonials »