Sales Order Colour Code

Olive

No invoice number, Nothing on Order and No Delivery Docket, ie a Cancelled Order

OMOH:LSTINVNO = '' AND OMOH:SALEAMT  = 0 AND OMOH:DELDKT = '' 

Blue

Order is Overdue

OMOH:LSTINVNO = '' AND OMOH:SALEAMT  <> 0 AND (OMOH:DATEDUE < today()) 

Silver

Order delivered, but not yet Invoiced

OMOH:LSTINVNO = '' AND OMOH:SALEAMT  <> 0 AND OMOH:DELDKT <> '' 

Yellow

Back Order

OMOH:LSTINVNO <> '' AND OMOH:SALEAMT  <>  0 

Green

Order Complete

OMOH:LSTINVNO <> '' AND OMOH:SALEAMT  = 0 

No Colour

Order has not had a DD raised, and hence no action has been taken to supply

Nil