For Closed / Shipped orders - Please copy your waybill number, click on relevant link and paste for tracking results.

Notes on SQL :

This query is not case sensitive. Will Ship Date for Direct Ship Orders is the day the shipment will arrive at customers site.

Will Ship Date for orders shipping from  AMKET in Limerick is the day the shipment will leave AMKET.  

The results of this query are displayed as follows:

(a) by Line Item Status in descending order (Open items first inc. partial qty and then closed items inc. partial qty)

(b) by Amket Reference (PO) in descending order

(c) by Will Ship Date in ascending order

(d) by Invoice Number in ascending order

_sQry="SELECT * FROM ORDER_TRACK WHERE (PO = '::PO::' AND Reference = '::Reference::') ORDER BY Status DESC,PO DESC,Will_Ship_Date ASC,Invoice ASC"