ASN 20 ph3

From UG

Revision as of 18:19, 23 January 2013

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

Figures

Figure1. Client User Profile

SOW 5