Dispatch Issues

Trucks Disappear from Schedule Screen

If Dispatch End of Day is run without date selection, trucks that are currently out on loads will disappear from the Schedule screen. Additionally, the trucks will not appear in the Available Trucks grid.

To remedy this situation, run the following query, substituting today's date where you see 6/29/07:

UPDATE DITPRJLD
SET STATUS_COL = 8, RETURN_DT = CURRENT_TIMESTAMP
WHERE
 (SCHED_DATETIME BETWEEN '6/29/07 00:00' AND '6/29/07 23:59') AND
 (STATUS_COL <> 8) AND
 (RETURN_DT IS NULL) AND
 (NOT EXISTS
  (SELECT SESSION_NO FROM ARTPTKHD TK
   WHERE (TK.ORDER_SESSION_NO = DITPRJLD.ORDER_SESSION_NO) AND
         (TK.ORDER_TRANS_NO = DITPRJLD.ORDER_TRANS_NO) AND
         (TK.ORDER_LOAD_NO = DITPRJLD.LOAD_NO)))