Finance | Project Operations, Human Resources, ...

GROUP BY is not working for Data entity - D365 F&O

(0) Share

Report

Posted on by d365Dev

110

Hi all,

I have a requirement to display the same as ON hand inventory details page in UI as output for data entity.

I have created a custom data entity which has InventSum as primary data source and InventDim,InventTable as other two data sources with Inner join and relations.

I am able to fetch correct data as for ON hand inventory form , but when I am trying to group by dimensions -Site and Inventory status ID in data entity, these records are not getting clubbed. Please suggest.

Reference screenshot:

Thank you in advance !!

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Dean Stegmiller Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi D365Dev,

This is a little old but I came across this similar post where the answer was that group by is not supported by data entities and odata. That might explain the issue you are seeing.

Thanks

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!

Hi,

As a workaround, the view can be created for InventSum+InventDim with grouping and view used in an entity as data source.

Also, there is an Inventory visibility add-on is available (maybe it's still in preview) and it can be used as an additional integration endpoint to provide information about inventory level.

docs.microsoft.com/.../inventory-visibility

Was this reply helpful? Yes No