...
- First, run The Report from the mailing software. (Rebecca Lucas has the specifics)
- Place the resulting Excel file in the folder H:\Shared\FASSIT\FedExRates\
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.
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.
The old file will be moved to H:\Shared\FASSIT\FedExRates\Processed\
- The new file will also appear in H:\Shared\FASSIT\FedExRates\Processed\, with the same filename + "WITH LIST RATES".
...