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
On Order field in report
Dec 02, 2009
1 Replies
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,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required