Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Blogs / Rahul Mohta blog for Microsoft Dynamics 365 Fin... / Inventory on-hand report st...

Inventory on-hand report storage - PU36 10.0.11 new feature in Microsoft Dynamics 365 Finance and Operations

Rahul Mohta Profile Picture Rahul Mohta 21,014

Inventory on-hand report storage - PU36 10.0.11 new feature in Microsoft Dynamics 365 Finance and Operations

pastedimage1591000064919v1.png

Similar to inventory ageing and inventory cost storage reports

This feature provides a new way of executing the inventory on-hand report and is helpful in cases where the output contains a large number of lines. For example, without the feature, if you request the inventory onhand by item, site, and warehouse, and you have 50,000 items and 300 stores, you will get a long report that is difficult to review. With the Inventory onhand report storage feature enabled, you can sort and filter results, and export results to an external system.

Comments

*This post is locked for comments

  • C. Marquardt Profile Picture C. Marquardt
    Posted at
    Hi, I found the solution for my question below. The Name of the Entity is InventoryOnHandReport. If you activate the Entity and start the Report you can find als this Entity.
  • C. Marquardt Profile Picture C. Marquardt
    Posted at
    Hi, this is a very nice feature. But I have a question to this new feature: In the short documentary docs.microsoft.com/.../inventory-on-hand-report-storage It is writen in the last text block that you can access trough an entity? What is the name of this entity? I do reports often with PowerQuery or PowerBI. But I can not find a way to extract this data? Is there another way to fully automate the export of this data? Is there a way to export the data to Sharepoint with PowerAutomate (Former: MS Flows)? It would be very helpful to get an advice from anybody. Thank you. Greatings from Germany