News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Fetch inventory ohand ...

Supply chain | Supply Chain Management, Commerce

Suggested answer

Fetch inventory ohand for warehouse enabled items

(1) Share

Report

Report

Posted on by udaY-ch

4,624

Hi

We are exporting tables from dynamics 365 using synapse link to external database

We have build a query to fetch onhand details using inventsum table and we see difference in the qty against the front end screen (inventavailabilityProvider is used to get the values on the inventonhand form.) for warehouse enabled items.

what is the table or entity that can be used to get correct onhand qty informations.

Thanks

Udhay

Categories:

Dynamics 365 Supply Chain Management

All responses Img

All responses (2)

Answers Img

Answers (0)

udaY-ch 4,624 on at

Like (0)

Report

Fetch inventory ohand for warehouse enabled items

Yes, we have reviewed those views, but we use inventory batch and WMS locations, while those views mainly rely on site and warehouse. We're unsure whether we can depend on the WHSInventReserve table for on-hand information for items with warehouse enabled.
Suggested answer

CU09101616-0 30 on at

Like (0)

Report

Fetch inventory ohand for warehouse enabled items

Hi,

I had a similar requirement from my client and noticed the following:

When I check on-hand list and inspect the form information I can see the form InventOnHandItem which looks pulling from multiple tables:

Although, I have found that the best tables to export are InventorySiteOnHandV2 or InventWarehouseOnHandV2 depending if you want to look site specific or warehouse specific.

Please let me know if this works for your business case.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans