web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Entity for on hand inv...
Supply chain | Supply Chain Management, Commerce
Answered

Entity for on hand inventory by location dimension

(1) ShareShare
ReportReport
Posted on by MacNeg 133
Hello, 
 
I am trying to build a simple canvas app that will list available on hand inventory by item and need help in determining which entity to use.  I only see one that is by warehouse id. I need one that breaks it down by location dimension.  I dont have access to dev environment or source codes :( 
 
Thanks! 
 
Joseph 
 
I have the same question (0)
  • Suggested answer
    AR-01121610-0 Profile Picture
    AR-01121610-0 4,967 Moderator on at
    Hy,
     
    when you are using extended Warehouse management (WMS) the first apporach would be to use WMS mobils app
     
    If you don't use WMS module there are three entities that have the Location inside:
    - InventInventoryOnhandReportStorageV2Entity
    - InventInventoryOnHandMobileEntryEntity
    For the *ReportStorage* entitiy I assume you need to have the inventory report storage setup to be updated periodically.
    For the third one you can also try to use that one,
     
    As a datasource for the mobile app I would reecommend to use "virtual entity" instead of a query to D365FO connector.
     
    For searching entities and fields you can use the tool for entity research
     
    Hope this helps.
     
     
     
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at
    Hi MacNeg,
     
    The following entities can be considered for on hand inventory by item in the canvas app.
    1. InventOnHandStorageReportingLine
    2. InventLocationBIEntity (Closest to inventory breakdown by location)
    3. InventInventoryOnhandReportStorageV2Entity
    4. InventLocationAIEntity (Introduced with v10.0.40, the other one which you can consider)
     
    Happy to answer questions, if any.
  • MacNeg Profile Picture
    MacNeg 133 on at
    Thanks for the reply andreasraithel and Navneeth! I verified in powerapps with the Fin and ops apps D365 connector and these entities are not showing up.  Maybe these are not publicly available? I also tried using postman to query some data and I am getting the response no route data found for this request.  Our finops version is 10.0.38.  I also checked it thru Data Manaement - Data Entities and did not see these entities. :( 
     
    Thanks! 
     
     
  • Verified answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at
    Hi MacNeg,
     
    Added the recommended entities in bold. InventInventoryOnhandReportStorageV2Entity is the best one to leverage but it has no public collection name. Checked all the details in the Application explorer. 
     
    S.No Data Entity Name Public Collection Name Data Management Enabled Comments
    1. 
    		 InventOnHandAIEntity InventoryOnHandForAI No Introduced with  v10.0.40 and can use public collection nam. Found this entity closest to retrieving Onhand inventory with product and location details. Need to add the field InventLocationId in the data entity to retrieve the warehouse, site,location and product details.
    2. InventLocationBIEntity  InventLocationBIEntities No Need custom development. Need to add product id and product details.
    3. 
    		 InventInventoryOnhandReportStorageV2Entity No Public Collection Name No Available in v10.0.38 and v10.0.40 too. Public collection name not available and data management not enabled for this entity. Best entity to be leveraged in PowerApps. 
    4.
    		 InventLocationAIEntity  InventoryWarehousesForAI No No location name and product names in here. Need to add those fields.
     
    Hope this helps.  Happy to answer questions, if any.
  • MacNeg Profile Picture
    MacNeg 133 on at
    Thanks a lot Navneeth! 
     
    Have a great day! 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 293 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 142 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 46

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans