Jump to content


Luke

Member Since 13 Jan 2005
Offline Last Active May 25 2005 07:08 AM
-----

Topics I've Started

UPS Tracking No. Look-up

17 January 2005 - 08:04 PM

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.