ASN 20 ph3
From UG
Intro
SOWs
SOW 1 Download to Excel Ability to select fields/columns and specify sequence/order (for ASN 2.0)
mantis: 3926
spec: see below
ASN 20 should function as ASN 1X.
"Download to Excel" link from CT list should lead to pop-up where user can manage what fields to include and in what order - see below.
Example of excel:
SOW 2 Support additional ASN 2.0 Fields and Columns on download to xls and flex shipments list
mantis: 3925
Core Requirements
Add support for additional ASN 2.0 Fields/Columns in shipment lists.
These fields need to be implemented in both:
- 1) Download to Excel
- 2) Flexible shipments list
Solution
1) Use ASN 2.0 fields:
- CT #
- Status
- Pick Up Location
- Ship To Location
- Cargo Due date
- P.O.
- SKU
- Quantity
- Transport Mode
- Submode
- Piece Price
- Total Value
- Item Description
- Created On Date
- Approved On Date
- Approved For Pickup On Date
- Rejected On Date
- Planners Name
2) Add ASN 1.x fields:
- "CT #" (2.0)
- "Shipper"
- "Pick Up Location" (2.0)
- "Ship To Location" (2.0)
- "P.O. Issued by"
- "Pick Up Instructions"
- "Commodity Description"
- "Cargo Available Date"
- "Cargo Due date" (2.0)
- "P.O." (2.0)
- "SKU" (2.0)
- "Quantity" (2.0)
- "Number of Pallets"
- "Packages on Pallets"
- "Loose Packages"
- "Total Gross Weight (lb)"
- "Piece Price" (2.0)
- "Total Value" (2.0)
- "Item Description" (2.0)
- "Hazardous"
- "Stackable"
- "Pick up Trucker"
- "Estimated Pick Up date"
- "Actual Pick Up date"
- "Delivery Trucker"
- "Estimated Delivery Date"
- "Actual Delivery Date"
- "Created by"
- "Authorization Status" (2.0)
- "Last Update Date and Time"
- "Last Update by"
- "Mode Of Transport"
- "Created On Date" (2.0)
- "Approved On Date" (2.0)
- "Approved For Pickup On Date" (2.0)
- "Rejected On Date" (2.0)
3) Add additionally selected fields from:
- TRUCK
- Load Number
- PT Number
- DT Number
- AIR
- MAWB
- Flight Number
- Origin Airport
- Date of Departure
- Destination Airport
- Date of Arrival
- OCEAN
- Vessel Name
- Voyage Number
- Origin Terminal
- Date of Departure
- Destination Terminal
- Commodity fields -
- Container # (OCEAN)
- CT2 Transport Mode (1)
- 3PL Name
Related Functionality
Rename Output Fields in both ASN 1.x and ASN 2.0:
- "Pick up Trucker Name" to "Pick up Trucker"
- "Delivery Trucker Name" to "Delivery Trucker"
SOW 3 Default units of measurement & currency types
mantis: 3927
spec: see below
SOW 4 ASN flag: Notification Email & SMS
mantis: 3942
spec: see below
Core Requirements
- Similar functionality to Client watch list shipment email notification and SMS (see Figure 1 below) but for portal shipper/planner.
- Allow Shipper/Planner to flag shipment with functionality for email/sms notification