ASN 20 ph3

From UG

Revision as of 01:22, 24 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

NOTE: 1) For now in ASN 2.0 already implemented the following fields:

  • "CT #"
  • Status (a.k.a. "Authorization 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

Solution

Add the following columns to Flexible Shipment List (and use them as Output Fields of "Download to Excel"):

1) ASN 1.x fields:

  • "Shipper"
  • "P.O. Issued by"
  • "Pick Up Instructions"
  • "Commodity Description"
  • "Cargo Available Date"
  • "Number of Pallets"
  • "Packages on Pallets"
  • "Loose Packages"
  • "Total Gross Weight (lb)"
  • "Hazardous"
  • "Stackable"
  • "Pick up Trucker"
  • "Estimated Pick Up date"
  • "Actual Pick Up date"
  • "Delivery Trucker"
  • "Estimated Delivery Date"
  • "Actual Delivery Date"
  • "Created by"
  • "Last Update Date and Time"
  • "Last Update by"
  • "Mode Of Transport" (CT2 Transport Mode)

2) ASN 2.0 common fields:

  • "Pick up Location Country"
  • "Ship To Location Country"
  • 3PL Name (a.k.a. Transmit To)

3) ASN 2.0 MOT-specific fields:

  • "FLT/VESSEL/Load#".
  • if AIR, mapped to "Flight Number"
  • if OCEAN, mapped to "Vessel Name"
  • if TRUCK, mapped to "Load Number"
  • "MAWB/CNTR#/Trailer#".
  • if AIR, mapped to "MAWB"
  • if OCEAN, mapped to "Container #"
  • if TRUCK, mapped to "Delivery Trailer" only (no need to show Pick up Trailer #)
  • "Origin Point"
  • if AIR, mapped to "Origin Airport"
  • if OCEAN, mapped to "Origin Terminal"
  • if TRUCK, mapped to TBD
  • "Date of Departure"
  • if AIR/OCEAN, mapped to "Date of Arrival"
  • if TRUCK, just copy "Actual Delivery Date"
  • "Destination Point"
  • if AIR, mapped to "Destination Airport"
  • if OCEAN, mapped to "Destination Terminal"
  • if TRUCK, mapped to TBD
  • "Date of Arrival"
  • if AIR/OCEAN, mapped to "Date of Arrival"
  • if TRUCK, just copy "Actual Delivery Date"

Related Functionality

1) Make "Planners Name" available ONLY when there is a SKU/Planner map.

2) 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

Core Requirements

For ASN 2.0, we need the ability to set the default units of measurement & currency types when entering ASNs.

Units of Measurement:

1) Currency Type (USD, GBP, etc..)
2) Volume (cubic meters or cubic inches)
3) Weight (pound or kilogram)

Solution

TBD

SOW 4 ASN flag: Notification Email & SMS

mantis: 3942

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

Solution

TBD

SOW 5

Personal tools