Re-Set an Order
Sometimes we need to ‘re-set’ an order so a buyer can re-approve it.
Use this SQL statement; you will need to find the buyer, location, supplier ID, and PO# of the order to reset:
UPDATE k3s_5dta.k_suplsoq SET so_po# = ‘ ‘, so_soqtype = ‘ND’
WHERE so_buyr = ‘X’ and so_locn = ‘X’ and so_supl = ‘X’
and so_suplsub = ‘X’ and so_po# = ‘X’
