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

  • ~ Mohamad Al-Shami, Chief of Finance and IT at WorleyParsons

    shamiii"Amer Atiyah has provided us a full time support. His involvement has crossed project management, Installation, data migration, system analysis and design for Payroll. Amer has a proven "can do" attitude and prepared to roll up his sleeves and get the job done. He has, and are continuing to, assist us with the successful delivery of our Dynamics AX ERP Implementation."

  • Read more testimonials »