Failed to execute query because no root data source on the form matches the root datasource on the query.

-
My friend was creating custom lookup and he encounter following error.





This error usually occur when the table name differs in SysTableLookup::newParameters() with the table that is used in query.

Comments

  1. Erik Kornerup24 September 2020 at 00:18

    In D365 it can be caused by a property at the menuItem.
    If the property Copy Caller Query is enabled the error will occour when you use the hyperlink

    ReplyDelete

Post a Comment

Popular posts from this blog

X++ Get Start Date and End Date of Month

-
Use following methods to get Month Start Date and Month End Date. Pass any date of month in parameter. Month Start Date :    TransDate dateInMonth=today(); TransDate firstDateOfMonth; ; firstDateOfMonth = DateStartMth(dateInMonth); Month End Date : TransDate dateInMonth=today(); TransDate endDateOfMonth; ; endDateOfMonth= endmth(dateInMonth);
Read more

Dynamics AX 365 : The name does not denote a class, a table or an extended data type

-
Image
I was getting following error during customization of Dynamics AX. After some debugging i found that it is due to model. Error can be resolved by updating model. In this blog i am working with smmActivities but it can applied for any table. Goto your table in AOT you will see model name in square brackets in light color grey. You have to add this model to resolve issue. In my case model name is "Case Management". In toolbar go to Dynamics 365 →Model Management → Update model parameters. Select your model in which you are doing your customization, in my case it is "testModel" and click on next, scroll down and select "Case Management" and select next and then click on finish. Build your solution error should be gone now.
Read more