Support

How can we help you today?

Creating and Printing a UPS End of Day Report

Modified on: Wed, 1 Feb, 2017 at 12:33 PM

Note: this procedure is no longer necessary if you are using the UPS OnLine Tools system.

Our integration with UPS generates a UPS label with a package and bow-tie icon at the bottom right of the label. This indicates to drivers that the packages are pre-paid and prescanned. When packages are processed using the OnLine Tools system, an “End of Day” report is not required and UPS drivers do not need to scan each package. At most, all you would need to give them is a total package count that they would enter into their PDA. If your driver insists on scanning each package, provide him/her with an End of Day report.

Figure 1.1: The bow-tie indicates that your package was pre-scanned into the UPS OnLine Tools system.

Creating the UPS End of Day Filter

1. From the Manage tab, click Filters > New Filter.

2. Enter a name for the filter, e.g. "UPS End of Day" and then click "Next."

2. Indicate "For any shipment in the order...":

2a. After “If All of the following conditions are met…” click the “Add Condition” icon .

2b. Click Order Total and change it to For any > Shipment using the dropdown menu provided.

3. Set the provider condition for the filter.

Under the line "For any shipment in the order...", leave “If All of the following conditions are met…” and click the “Add Condition” icon .

Leave the default "ProviderEquals" as is, and select UPS from the drop-down menu.

4. Set the Processed Status condition.

Again, under the line "For any shipment in the order...", click the “Add Condition” icon .

Change the second condition by clicking Provider and selecting Processed Status from the dropdown menu.

Select Processed from the dropdown menu.

4. Set a branch for the next conditions (ship date and processed dates).

Under the line "For any shipment in the order...", click the “Branching” icon .

Leave And as is.

Change "If All..." to "If Any of the following conditions are met."

5. Set the ship date today condition:

- Click the Add conditions" icon .

- Change Provider to Ship Date, then click Equalsand select Is Today from the drop-down menu.

6. Repeat as in step 5 to set up the Processed Date today condition:

- Click the Add conditions" icon .

- Change ProvidertoProcessed Date.

- Click Equalsand selectIs Todayfrom the drop-down menu.

Your filter setup should now look like this:

7. Click "Next" to save your changes.

8. (OPTIONAL) Adjust any grid columns according to your own business practices.

9. Click "Finish" and "Close".

Once you've finished setting up your UPS End of Day filter, you'll print this report for your records.

Printing the UPS End of Day Report

Templates format your data in an easy-to-read way, either in an email to customers, invoices, packing slips, or reports. If you navigate to Manage > Templates, you can see all of the default templates ShipWorks has available. The template used in the end of day report is the “Shipping Profit and Loss” template.