Freight Charges Detail Report

Purpose: Use this report to review a breakdown, by invoice, 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 selected.

To review: You can review this report by selecting FrtChgDtl 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.

• 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 report lists ship via 3.

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. 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. If you did not select a ship via, the report indicates a selection of ALL

• Ship Via: The report includes a separate page for each ship via that processed shipments during the selected date range. The information listed for each ship via includes:

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

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

• For each invoice billed during the selected date range:

• Invoice #: The invoice number that identifies a shipment for an order, or all shipments for an order (including multiple shipping addresses) on the same date if the Consolidated Invoice (B49) system control value is selected. You can review the invoices for an order at the Display Invoices Screen in standard order inquiry.

• Order #: A unique number to identify the order for a customer.

• Collected: The total amount of Freight and Additional freight charges that the customer is paying for this invoice. If there are multiple shipments for a single invoice, the total freight and additional freight charges are included in the invoice for the first ship via listed on the report, and the Collected amount listed for this invoice under additional ship vias on this report 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 to be shipped by 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.

Note: If you prorate freight (based on the setting of the Prorate Freight Charges (D39) system control value and the shipment method defined for the source code), Freight charges are prorated across multiple invoices for the same order. See that system control value for a discussion.

• Billed: The total freight charges that you are paying to the shipper for the shipment(s) against this invoice, 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 (the Collected amount) minus the total meter charges billed by the ship via (the Billed amount). 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 $7.00; however, you are running a “free shipping” promotion during this time period and the total freight and additional freight collected was zero. The Difference listed on the report is -7.00.

• Totals for Ship Via:

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

• Billed: The total freight charges that you are paying to this ship via for shipments during 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 this ship via for shipments during the selected date range. See the Difference field above for a discussion.

• Final Totals:

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 the shipper for 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.