Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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 to you 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.

    Info

    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".

...

Info
titleNotes

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

The script must If column headers change, the script will need to be edited directly to change who the email is sent toto match.


Filter by label (Content by label)
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "KB"
labelskb-how-to-article

...

Page Properties
hiddentrue


Related issues