Share
ReportDoes anyone know how to modify custom reports, namely the " item movement report with on hand" so that it includes the "on order" field also?
*This post is locked for comments
You’re offline. This is a read only version of the page.
67
Does anyone know how to modify custom reports, namely the " item movement report with on hand" so that it includes the "on order" field also?
*This post is locked for comments
This is not a simple field to add. The on-order quantity comes from summing the quantityordered = quantityreceivedtodate from the purchaseorderentry table. There can be multiple entries for each item within that table, which means you would need a group by clause as part of the query for the report.
You can not realistically add a group by clause to that report due to the Union All statement
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,013
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
All responses (
Answers (
