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?


Report
All responses (
Answers (