InventTable Query Not Showing any Columns or Data

Finance and Operations/AX Developer Forum
1

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:

ItemLookup1.png
ItemLookup1.png777×429 30 KB

While if I change the field to “Product” on the same table, the lookup works normally:

ItemLookup2.png
ItemLookup2.png788×451 57.9 KB

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:

ItemLookup3.png
ItemLookup3.png1725×423 77.6 KB

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