InventTable Query Not Showing any Columns or Data

Hi All,

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?

Thank you