Notifications
Announcements
No record found.
Hi All
On F&O 10.0.0.23
Anyone know which entity I would use to get onhand inventory for a given legal entity using oData?
Thanks
Mark
Hi Mark,
There are various different entities. Which one to use depends on your requirements and inventory break-down per e.g. site or warehouse. All these entities do contain 'OnHand' in the name.
e.g:
- CDSInventoryOnHandEntitiy
- InventorySiteOnHand
- WarehouseOnHandV2
You also might have a look at a new Inventory visibility service which can be used for external calls also: Inventory Visibility Add-in overview - Supply Chain Management | Dynamics 365 | Microsoft Docs
I think this new service might be the future direction from Microsoft.
FYI
/data/WarehousesOnHandV2?&cross-company=true&$filter=dataAreaId eq 'xxxx' and InventoryWarehouseId eq 'yyyy' - works
/data/InventorySitesOnHandV2?&cross-company=true&$filter=dataAreaId eq 'xxxx' and InventoryWarehouseId eq 'yyyy' - works, but cannot get or filter by warehouse name
The public collection name for the CDS entity is "CDSInventoryOnHandEntries", but I just get this response. Not sure why
So I got this working, but unfortunately, I'm missing the batch ID's anyone know how to get onhand with batches via oData?
Related to your follow-up question, you already created another post on this forum. There are already two answers to your question: How to get onhand inventory WITH batch numbers via oData - Dynamics 365 Finance Forum Community Forum
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
