Blog

Microsoft Dynamics AX Thoughts

5
Posted February 6, 2011 in Blog, Dynamics AX by Amer

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. :)

5 Comments to “Populating Data from Different Companies”

  • Abdullah S
    March 20, 2011 at 8:27 am

    Hi Amer,

    I tried this but it did not work! how a company can check another company’s data?

    Reply
    • Amer
      March 20, 2011 at 9:31 am

      Hi Abdullah,
      Are you sure that you followed exactly the same steps? I just executed what I have written in my post.. and it did work.

      The Result is whenever you selected the “ItemCompany” field, when you go to select the ItemId field… the items shows are the items from the select company (that you selected in ItemCompany).

      Still did not show the expected results? If yes, let me please send you the table that I created as an XPO :) .

      Reply
      • Abdullah S
        March 22, 2011 at 9:02 am

        Hi Amer,

        Thanks for replying, here what I did:

        I have a new table called “Trips”, this table has a field “TripNo” (already created an extended datatype), I added this field to “InventTransferTable” table, also another field “ItemCompany” (Extended datatype is dataAreaId), and relations for “InventTransferTable” table as follows:
        * InventTransferTable. TripNo == Trips.TripNo (even it’s already point from the extended datatype)
        * InventTransferTable. ItemCompany == Trips.dataAreaId

        When inserting records to “InventTransferTable” table, the “ItemCompany” field is somehow set to the company which I want “TripNo” to be fetched from.

        I dragged “TripNo” field to some form from “InventTransferTable” table, it’s keep listing values from the existing company and not the company set in “ItemCompany” field.

        Did I miss anything or my case does not match the purpose of your post? If you send me an XPO project, that will be amazing :)

        Reply
        • Amer
          March 22, 2011 at 9:45 am

          Hi Abdullah,

          It looks that I have been trying an example and pointing out another example in my post just to give a clearer picture of what I want to say! It is my mistake.

          What I had to mention is that the EDT of the “ItemId” field should NOT have any relation (otherwise that realtion will overwrite).

          So to run YOUR example properly, you have to create an EDT that DOES NOT point to any table. And assign this new EDT to the “InventTransferTable.TripNo” field.

          And to run MY example properly, I should not select the “ItemId” EDT to my field; I should have created a new EDT that does not point to the “InventTable.ItemId” instead.

          Apologies for inconvenience! Thank you so much Abdullah for notifying me.

          Reply
          • Abdullah S
            March 22, 2011 at 2:16 pm

            Thanks Amer it works :)

Post comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">

Dynamics AX 2012 Event

Recent Posts

Tags

.NET .NET Business Connector AIF Amer Arabic Architecture Book CLR Interop Community Database Development Dynamics AX Dynamics AX 6.0 Dynamics AX 2009 Dynamics AX 2009 SP1 Dynamics AX 2011 Dynamics AX 2012 Dynamics AX Brains Enterprise Portal Error Event GDC Hijri IIS Implementation Integration Kerberos Ledger Journal Materials Microsoft stack MorphX MSDynamicsWorld.com ODC Files Presentation Sales Order Web Service Saudi Arabia SureStep Training VISUAL STUDIO.NET WF Workflow Workflow Approval Workflow Task X++ X++ Editor

Archives

Random Testimonial

  • ~ Mohammad A-Awami, Dynamics AX Specialist at WorleyParsons

    AlAwami"I worked with Amer for WorleyParsons. I found him very cooperative. He is able to help me in a lot of issues that related to ax. His ability to solve the problems is fascinating me. It is so fast and done on the best practice. His ability on business analysis and implantation are done on the best methods."

  • Read more testimonials »

Posting tweet...

Powered by Twitter Tools