How to reopen a closed order in TMW, to make modifications

How to reopen a closed order in TMW, to make modifications

Update invoice/order in SQL TMW_LIVE using the following script to move it to an On Hold (HLD) status.
This allows for modifications to be made to a load that has already been closed, and is in a Printed or Transferred status.
 

select * From invoiceheader
where ivh_invoicenumber = '1774962A'


begin tran
update invoiceheader
set ivh_invoicestatus = 'HLD'
where ivh_invoicenumber = '1774962A'
rollback tran


Now the order can be modified in Admin Dispatch.




PND = Pending
PRN = Printed
NPD = Not prepared
PPD = Prepared
XFR = Transfered
HLD = Hold






*take a smoke break