ASN 20 ph3

From UG

Revision as of 18:19, 23 January 2013 by Andrei (Talk | contribs)
Jump to: navigation, search


Contents

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:

File:Sh List on Web Portal.JPG

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 File:ClientUserProfile.gif

SOW 5

Personal tools