Is there a quick and easy way to find out where a particular item is committed?
I have an item that shows one on hand and one committed (zero available) but cannot find an open work/back/layaway order for the item anywhere.
Any advice would be appreciated.
Tom
I'm guessing you already ran all reports for both open and closed orders...did you check the orderentry table? Try a sample query...replace XXX with your itemlookupcode....hope this helps
select itemlookupcode, orderid, type from orderentry left join item on orderentry.itemid = item.id left join [order] on orderentry.orderid = [order].id where item.itemlookupcode = 'XXX'
"Terrible Tom" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required