Freight Charges Summary Report

Purpose: Use this report to review a summary, by ship via, of the freight charges you are paying to ship packages compared with the charges collected on customer orders to ship those packages.

How to print: Complete the Freight Charges Report Screen with the Details flag unselected.

To review: You can review this report by selecting FrtChgSumm at the Document Management Screen, or by selecting the report icon () next to your current session (such as QPADEV00B3) at the Job Management Screen. You can also select this report directly on the Document Management Screen.

For more information: See the sample report in PDF format.

Note: This report is also available as a CSV (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel^®. See Reports Available in CSV (Spreadsheet) Format for more information.

Note:

• Any packages shipped outside of the manifest station (such as through manual confirmation) are not included on the report totals.

• If you use Best Way shipping at the manifest station, the ship via on the order header might be different from the ship via on the report that includes the shipment. For example, the order header might show ship via 1 (UPS), but the manifest might determine that ship via 3 (FedEx Ground) costs less, so it sends the package that way. In this situation, the shipment totals are included for ship via 3 on the report.

Contents:

• Header area:

• Date Range: The Start Date and End Date you selected at the Freight Charges Report Screen

• Division: The Division, if any, you selected at the Freight Charges Report Screen. The description of the division is to the right. If you did not select a division, the report indicates a selection of ALL

• Ship Via: The Ship Via, if any, you selected at the Freight Charges Report Screen. The description of the ship via is to the right. If you did not select a ship via, the report indicates a selection of ALL

• For each ship via that you used to ship any packages during the date range:

• Ship Via: The numeric code that uniquely identifies a ship via, as set up through Working with Ship Via Codes (WVIA)

• Description: The description of the ship via, as set up through Working with Ship Via Codes (WVIA)

• Collected: The total amount of Freight and Additional freight charges that customers are paying for the shipments in the selected date range for the ship via.

Note: If the Consolidated Invoice (B49) system control value is selected and there are multiple shipments for a single invoice, the total freight and additional freight charges are included in the totals for the first ship via listed on the report, and the Collected amount on the report for the invoice where it is listed for additional ship vias is zero.

Example: The Consolidated Invoice (B49) system control value is selected, and you print pick slips for an order that includes an item flagged for overnight shipment (ship via 50) and additional items that use a standard ship via (ship via 1). Both packages ship the same day, and create a single invoice. The total shipping charges for the order include $10.00 freight and $15.00 additional freight. The report includes $25.00 in the Collected total for ship via 1, and 0 in the Collected total for ship via 50.

• Billed: The total freight charges that you are paying to the shipper, as calculated by adding the meter charges passed from the manifesting station and stored in the Manifest Upload Audit table. If multiple labels were scanned at the manifesting station for a single pick slip, this total includes the meter charges for all labels.

• Difference: The total freight and additional freight charges collected from the customer minus the total meter charges billed by the ship via. If the meter charges billed by the ship via exceed the freight and additional freight charges collected from the customer, the Difference listed on the report is a negative number.

Example: The total meter charges billed by ship via 1 were $200.00; however, you are running a “free shipping” promotion during this time period and the total freight and additional freight collected was $50.00. The Difference listed on the report is -150.00.

• Total Packages: The total number of packages shipped by this ship via, calculated by adding the total number of pick label numbers scanned at the manifesting station.

• Average Package Cost: The average cost of shipping each package, calculated by dividing the Billed amount by the Total Packages.

• Final Totals (PDF format only):

Note: If you selected a single Ship Via for the report at the Freight Charges Report Screen, the grand totals below will be the same as the totals for the ship via.

• Collected: The total amount of Freight and Additional freight charges collected on orders for all ship vias listed on the report for the selected date range. See the Collected field above for a discussion.

• Billed: The total freight charges that you are paying to all ship vias listed on the report for the selected date range. See the Billed field above for a discussion.

• Difference: The total freight and additional freight charges collected from the customer on all shipped orders, minus the total meter charges billed by all ship vias listed on the report for the selected date range. See the Difference field above for a discussion.

• Total Packages: The total number of packages shipped by all ship vias listed on the report for the selected date range.