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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Get InventOnHand quantity values as a View

(0) ShareShare
ReportReport
Posted on by 47

I have a requirement to extend an existing query based Report to now include the On-hand List values as shown here:

pastedimage1677909405063v1.png

from (Stock) Inventory Management >> Inquiries and Reports >> On-hand list

Can I get all the exact stock values in an existing View? Or is this futile?

I have attempted to use a view named InventOnHandBySite but the values are not matching the system report on screen above.

I also tried to re-create a SQL query but no luck yet. The Stock quantities per Item on report must match the on-screen values.

Please what is best way to display these quantity values in a query based report? 

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    300,714 Super User 2025 Season 2 on at
    RE: Get InventOnHand quantity values as a View

    Hi Tim,

    The form is using various calculations to aggregate data from the InventSum table based on user settings. You can use this table as base for your report.

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

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 724 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 400 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans