Home > Blog > The Tale of the Missing Datasource in AX 2012

The Tale of the Missing Datasource in AX 2012

My topic for discussion in this post is a missing Datasource in AX 2012. This is something that at first glance looks rather strange, but upon digging into the details make a lot of sense, and leverages functionality that was introduced in AX 2012.

This started while working on a customization.  I needed to make some modification to the purchase agreement functionality, and was working on the purchase agreements form (PurchAgreement form in the AOT).  I was going to modify the form layout, so I found a field in the location where I wanted to make the modification, and right clicked, personalize to see the information.  The control was named AgreementLine_AgreementLineQuantityCommitment_CommitedQuantity.  Quite a name.  So, examining the properties of the control, I find the following:

Datasource: ALine_AgreementLineQuantityCommitment
DataField: CommitedQuantity

What threw me was looking at the datasources, there is a datasource named ALine (tied to the AgreementLine table) but there is no datasource named ALine_AgreementLineQuantityCommitment.  How is this possible?

So, I go back to look at the AgreementLine table in the AOT, and I find that the table property Abstract is set to Yes, and SupportInheritance is set to Yes.  That explains it.  This is the root table of a series or hierarchy of tables that are inherited.  This means that on the form, my ALine datasource is the ROOT table of a series of tables.  By looking under the Derived Datasources node of the form datasource ALine, I now see where my data is coming from.

It’s one of those situations that you just don’t think of right away while working with tables as form datasources, but once you do the research, it makes perfect sense as to what you are seeing.

For more information on table inheritance and derived datasources, please see the following link: http://msdn.microsoft.com/en-us/library/hh272120.aspx

Our Verified Expert

Bill Thompson

Bill Thompson is a seasoned developer for MIcrosoft Dynamics 365 Finance & Supply Chain and Microsoft Dynamics AX, specializing in X++ development and report customizations. Having spent 11 years at Microsoft, supporting partner and ISV development teams, Bill is known for his ability to break down complex technical concepts and foster knowledge growth across user communities.

Recent engagements include working as a Principal Developer for clients implementating D365 Finance and Supply Chain or upgrading from Dynamics AX, delivering advanced customizations, mentoring internal developer teams, and leading training sessions at industry events. Bill's passion for learning and teaching foster a collaborative, solutions-oriented environment.

Read More from Bill Thompson

Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.