Good Afternoon ~ I wanted everyone to be aware that the ...



1. From the Main Menu in AMS, click on Administrative Menu. See Below:

[pic]

2. Click on General File Download. See Below:

3. At this screen you will only see the latest Tracking information displayed. To see the latest information, click on Download.

To Display earlier information, click on Display Inactive and you can search for the date you need. Once you find the date you are looking for, follow the same instructions for downloading the latest Tracking Information Excel File.

[pic]

4. The tracking information will open up in an Excel File. Here you can do a Data Sort to help you find the information you are looking for in a timely manner. For some helpful tips on Sorting Data in Excel, read further.

[pic]

Helpful Tips for Sorting Data in Excel:

 

• Each column is labeled for you clearly at the top and each can be put in ABC order to assist in locating the information quickly.

• Column A contains the tracking numbers and Column B contains the project numbers.

• Column C or Column T will contain the store numbers for the particular job.  If you do not find it in one column you will find the store number in the other.

• Column D thru Column L will not be used much, they contain information regarding the kit itself, the weight and delivery results.

• Column M will be used most frequently.  This contains the names of the agent’s who will be receiving the kits; the only time you would use another column to locate the tracking would be if you did not know who the kit was shipped to.

• To Sort Data in Excel, click on Data and then Sort. (Located at the top of the screen.) A box will pop-up giving you the option to sort by a column. The easiest way to sort is by the Ship To Name column. Click on Ship To Name and click OK.

[pic]

Your Data will sort by the Ship to Name, where you can locate the agent you are looking for easily. Once you locate the agent’s name, scroll to Column A and copy the Tracking Number.

[pic]

After copying the Tracking Number, go to , paste it in the Tracking box and click Track.

[pic]

 

 

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download