Update on order quantities
Update IV00102
Set QTYONORD = '0.00000'
Where (ITEMNMBR = '4030')
AND (LOCNCODE = 'DALLAS')
Update IV00102
Set QTYONORD = '0.00000'
Where (ITEMNMBR = '4030')
AND (LOCNCODE = '')
(May need to delete po in some cases)
Delete from pop10100 where ponumber = 'PO89766'
Delete from pop10110 where ponumber = 'PO89766'