Shipping nearing deadline notification
Could a report - or a view - be created that looks at the following cells and then gives a report of what is coming up so my order processing staff know what orders to prioritize getting tracking numbers entered for?
Item Status = Ordered
Tracking Number = Empty
Shipping - Status =/= Complete
Then compare Ship By Latest to the Current time of the day and if it is within 6 hours of the deadline (for example), a notification is sent. That could run every 6 hours and generate a notification or report.