Often times our S&H crew will have a UPS tracking number and need to find out which MOM customer corresponds to that TN. Before, they would call UPS for the receiver's name. Now they use DBFview (http://www.dbfview.com/) to search the TRACKINGNO column of BOX.dbf. Then they scroll over to the first column which contains the order number, then go back into MOM and search for that order.
It's pretty simple, but basically it boils down to me not wanting to make the S&H crew operate a DBF viewer (they don't even use MOM).
dbfview may or may not have the ability to automate the task, I just haven't tackled that yet.
Luke
Member Since 13 Jan 2005Offline Last Active May 25 2005 07:08 AM