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

• Related Articles

• How to Bill a Customer

• Running Percentage Pay Update

• Creating a new Team Leader

  1. Open System Administration 2. Login 3. Click on the down arrow (Labels) in the menu bar 4. Click on the drop down for "Field Name:" and select "TeamLeader" 5. Click on Insert in the menu bar (The instated field will populate at the bottom) 6. ...

• Missing Customer in Turvo - How to Add and Link the TMW Bill To ID to Turvo

• How to fix EDI Failures

  1. Connect to the remote server FS-TRANZTEC and login 2. There should be an error message given for the failure, click "Copy the message to the clipboard" 3. Open SQL, sign in to fs-tmw3, click on "New Query" and paste the error message that was ...