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:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.