You’re offline. This is a read only version of the page.
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?
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.
Share
Report
All responses (
Answers (
