web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Get InventOnHand quant...

Finance | Project Operations, Human Resources, ...

Unanswered

Get InventOnHand quantity values as a View

(0) Share

Report

Report

Posted on by Tim Made

47

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

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)

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 303,383 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

André Arnaud de Cal... 512 Super User 2026 Season 1

#2

Giorgio Bonacorsi 386

#3

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans