Pacejet

STANDARD REPORTS: Shipment Summary XLS

Use

List of shipments by status, period, or carrier with details such as transaction IDs, reference fields, carriers, services, and containers.


Functionality Overview

  • Only the first 25000 records are returned.

  • Only allows the last 30 days of orders.

  • Date on the report is in UTC time, not your local browser time.

  • Grid sorted by Ship Date.

  • Grid displays one line per Handling unit.

  • The Minimum search criteria must be defined by:

    • A site name

    • Start date of the search

    • End Date of the search

    • Sales Order number search requirements

      • Exact Sales Order Number

      • Start date (Does not have to match order)

      • End date (Does not have to match order)

  • Optional search criteria can be included to narrow the search results:
    o Warehouse name (Default - All)
    o Carrier (Default - All)
    o Status

  • Report is designed to be exported locally as a spreadsheet then manipulated to your requirements.


Where To Find the Shipment Summary XLS Report

shipment_summary_XLS.png


Example Of Shipment Summary XLS Report


mceclip1.png


mceclip5.png


Example Of Shipment Summary XLS Report For A Specific Sales Order

mceclip7.png

A date range is required to generate a report but not used as a criteria when searching for a specific Sales Order.


Columns Included In The Shipment Summary XLS Report

  • DO / TRANSID

  • WAREHOUSE

  • SO

  • DO

  • CARRIER

  • CLASS OF SERVICE

  • FREIGHT TERMS

  • STATUS

  • SHIP DATE

  • SHIP TO STATE

  • SHIP TO ZIP

  • SHIP TO COUNTRY

  • COST

  • PRICE

  • DECLARED VALUE

  • PROBILL

  • HANDLING UNIT NUMBER

  • HANDLING UNIT TYPE – (DIMENSIONS)

  • ORDER WEIGHT (Actual Shipment Weight from Order)

  • CARRIER WEIGHT (Dimensional Weight as calculated by Pacejet)

  • TRACKING ID

  • HAZARDOUS

  • PACKED – FULL NAME WITH DATE AND TIME

  • SHIPPED – FULL NAME WITH DATE AND TIME