End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I've read a few posts about SysMultiTableLookup class but I don't appear to have it in AX 2012 R2.
Is this only available in a certain build?
Could someone send me an xpo with the class or post the code for it so I can copy it as I require it for a complex lookup override.
I cannot find it in fully patched R1,R2 or R3.
I think this class is not standard in AX 2012 -> I have also downloaded this class as an xpo an made a few corretions in the code.Here's a link where you can download the class:
Thanks for clarifying this for me Stephan, I thought I was going mad when I couldn't find it in the AOT, despite some forum posts mentioning it.
In addition to this, I am trying to override the customer lookup on the SalesCreateOrder form, I had presumed this is controlled by the form CustTableLookup but this doesn't seem to be the case, could you direct me on how this lookup is controlled?
I would simply override the code on the form, but when I add in the tableMethodStr name to return the customer name, I get a blank value.
Hoping to return the customer name by using the name display method against the CustTable
I came across this article on a post elsewhere - I have employed this mechanism to achieve what I need - it is actually very easy to do and makes sense.
It is actually very easy to combine multiple datasources in a sysTableLookup. Here is the trick I used to be able to filter on the name from the EcoResProductTranslation in the lookup for items.
1) Create a view that combines all your datasources and add the fields you would like to see in your lookup to the view.
2) Create a query from the view created in step 1.
3) Use these to perform your lookup as follows...
static client void lookupItemActive(FormStringControl _ctrl)
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(<ViewName>),_ctrl);
Query query = new Query(queryStr(<QueryName>));
Just found this post while replying on another thread.
Here's the original blog post of mine about this class, the guy in the other blog post is a shameless copy/paster :(
Business Applications communities