Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
I am getting the following error with a custom lookup method.
"Failed to execute query because no root data source on the form matches the root datasource on the query"
The main datasource in the form is a temporary table, and the filter I am implementing in the custom lookup uses a separate set of tables, albeit the return type EDT is the same.
Any help appreciated.
Try creating a separate form that shows that data, with the same data source setup.
If that works, you'll just be able to reuse it as your lookup form.
If it doesn't, in the process you should be able to see the wrong of your ways. :)
The above sounds incorrect. The EDT has nothing to do with selecting the data.
Kashperuk Ivan (Vanya)
My blog: http://kashperuk.blogspot.com
This error can occur when the wrong TableId is passed in SysTableLookup::newParameters(). Make sure you use the table you want to do the lookup in (not the table you're doing for).
The main datasource of your query must be the same as the main datasource in the form.
If you want to show fields from other tables, you can use this:
sysTableLookup.addLookupMethod(tablemethodstr(tableName, methodName));
where the method is a display method and the table is the same as the main datasource!
I hope it can help you!