Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Data entity InventInve...
Supply chain | Supply Chain Management, Commerce
Answered

Data entity InventInventoryOnhandReportStorageV2Entity

(1) ShareShare
ReportReport
Posted on by TK-07060900-0 27
Hi all, 
 
I would like to have a data entity where both the warehouse and location for an item are displayed. 
 
In previous question on this forum data entity InventInventoryOnhandReportStorageV2Entity was recommended. 
 
However, this data entity (from table INVENTONHANDSTORAGE) is empty. I do have inventory onhand in my environment. 
 
Can somebody please explain or advice a different standard data entity to use? 
 
Thanks in advance. 
 
 
Categories:
Supply Chain Management
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    Data entity InventInventoryOnhandReportStorageV2Entity
    Hi,
     
    For me, the link provided by Martin is not working directly, but I tried to share it again: Inventory on-hand report storage - Dynamics 365 Release Plan | Microsoft Learn
     
    There are two entities you can try to use having the Location ID as an attribute: InventInventoryOnhandReportStorageV2Entity and InventInventoryOnHandMobileEntryEntity.
  • TK-07060900-0 Profile Picture
    TK-07060900-0 27 on at
    Data entity InventInventoryOnhandReportStorageV2Entity
    Hi all, thanks for the help.
     
    INVENTWAREHOUSEONHANDV2ENTITY does not have the location dimension. I am looking for "warehouse + location" . 
     
    Only INVENTORYWAREHOUSEID is populated in this entity
     
     
     
  • Martin Dráb Profile Picture
    Martin Dráb 229,993 Most Valuable Professional on at
    Data entity InventInventoryOnhandReportStorageV2Entity
    InventOnHandStorage is a table that must be populated before you can export data from it. You can learn a bit more about it in Inventory on-hand report storage. According to cross-references, the data can be generated by Inventory management > Inquiries and reports > On-hand list (if the feature is enabled).
  • Suggested answer
    andreasraithel Profile Picture
    andreasraithel 4,813 Super User 2024 Season 2 on at
    Data entity InventInventoryOnhandReportStorageV2Entity
    Hy,
     
    you should use INVENTWAREHOUSEONHANDV2ENTITY, the other one seems to be for AI usage.
     
     
    And you can use this public Entity Research tool 
    Microsoft Power BI

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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans