Data Entity not exporting Data

Finance and Operations/AX Developer Forum
1

I am creating a new data entity that is primarily sourced by InventTable. Brought in a few fields from the table, and the solution had successfully built, and the DB Sync had been successful. I had also refreshed entities list and that was also successful.

However, whenever I try to export this entity, 0 rows end up exporting. And this is just InventTable. I even tried creating a new entity where it was inventtable with all the fields, and again nothing is exporting. I see 0 rows have been exported, but everything has been mapped correctly, and I have not done any other transformation on it. And the staging tables also have the fields. Created plenty of custom entities and never had this issue before.

Is there something that I am missing? Is this an inventtable issue perhaps?

2

Try the underlying view directly. Open SQL Server Management Studio, select the database and run a select statement against the view with the same name as your entity. If it returns data, add a WHERE condition for your DataAreaId.

If it works correctly, the problem is somewhere in the export, not in your entity as such.

If it doesn’t work, find the entity under Views, go to its design and explore the select statement.

I’m assuming that you have some data in InventTable.