Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 55
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 
 
  • MacNeg Profile Picture
    MacNeg 55 on at
    Entity for on hand inventory by location dimension
    Thanks a lot Navneeth! 
     
    Have a great day! 
     
  • Verified answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,399 Super User 2024 Season 2 on at
    Entity for on hand inventory by location dimension
    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 55 on at
    Entity for on hand inventory by location dimension
    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! 
     
     
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,399 Super User 2024 Season 2 on at
    Entity for on hand inventory by location dimension
    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.
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,828 Super User 2024 Season 2 on at
    Entity for on hand inventory by location dimension
    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.
     
     
     

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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans