Sales Order Colour Code
We have recently introduced colours to signify the status of Sales Orders.
Colour | Status | Formula |
|---|---|---|
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 |
Copyright Programmed Network Management PL 2023