I am facing a strange issue in AX2012 R3, the standard Items query is not showing any columns or data as you can see in the screenshot below:
While if I change the field to "Product" on the same table, the lookup works normally:
I suspected the issue to be related to some related tables in the query so I created a new query with only 1 datasource (InventTable) and the same issue persists here:
I have a mixture of items in the system, some were imported using DIXF and others were created manually on the system.
Has anyone faced such an issue before?