Hello,
Can someone send me the query that would allow me to view an item's ON ORDER qty in a report?
I can seem to manipulate every other field accept for the ON ORDER field for some reason.
Thx, Peter
- posted
14 years ago
On Order field in report
Loading thread data ...
- Vote on answer
- posted
14 years ago
Hi Peter - "on order" is not a column on the item table, or any table - there is a view I believe called viewonorder that calculates open PO qties by item. Your report will need to join the item table to the view - in store operations the join would be item.id = viewonorder.itemid.
I believe there is a custom report you can download from customersource that already includes this for you.
H> Hello,