Process FedEx Report From Mailing Services To Get List Rates

Owned by
Justin Porter
Last updated: Oct 20, 2022Version comment
2 min read

This process should be used to gather the FedEx listed rates for shipments that have been processed by Printing & Mailing Services.

Step-by-step guide

  1. First, run The Report from the mailing software.  (Rebecca Lucas has the specifics)
  2. Place the resulting Excel file in the folder H:\Shared\FASSIT\FedExRates\

  3. Wait up to 30 minutes, and an email should be sent out including the newly processed file with some additional columns.  Note that the script must be edited directly to change who the email is sent to.

    The newly added columns are as follows:

    List Rate - This shows the returned list rate including any requested or automatic surcharges

    Unlisted Surcharges - This totals up non-automatic surcharges from the report, such as insurance and some handling charge types.

    List Rate + Unlisted Surcharges - This combines the two columns together to give you a good total for comparison.  This should match the rate if you were hand-entering a shipment on the FedEx website.  This should be the rate used to charge the customer.

    Notes - This will show any errors that arose while the script runs.  Also, it shows which surcharges were included with the returned rate request, so we can ensure none of those extra services were missed.

  4. The old file will be moved to H:\Shared\FASSIT\FedExRates\Processed\

  5. The new file will also appear in H:\Shared\FASSIT\FedExRates\Processed\, with the same filename + "WITH LIST RATES".


Notes

Filename does not matter - as long as the file extension ends in .xls, it will be processed.

If column headers change, the script will need to be edited to match.