Hi i would like to send a sql query down to a store from HQ to re-open a PO which has been closed at the store in error. Is there a sql query available which can: a) re-open the PO b) reinsert the original PO quantities/lines as the PO order quantities & items are adjusted/removed when a PO is closed.
Any help would be greatly appreciated