ASN 20 ph3

From UG

(Difference between revisions)
Jump to: navigation, search
(Figures)
(SOWs)
Line 55: Line 55:
==== Solution ====
==== Solution ====
 +
Add the following columns to Flexible Shipment List (and use them as ''Output Fields'' of "Download to Excel"):
-
'''1) Add the following columns to Flexible Shipment List''' (and use them as '''Output Fields''' of "Download to Excel"):
+
'''1) ASN 1.x fields''':
* "Shipper"
* "Shipper"
* "P.O. Issued by"
* "P.O. Issued by"
Line 78: Line 79:
* "Last Update by"
* "Last Update by"
* "Mode Of Transport" (CT2 Transport Mode)
* "Mode Of Transport" (CT2 Transport Mode)
 +
 +
'''2) ASN 2.0 common fields''':
* "Pick up Location Country"
* "Pick up Location Country"
* "Ship To Location Country"
* "Ship To Location Country"
* 3PL Name (a.k.a. Transmit To)
* 3PL Name (a.k.a. Transmit To)
-
'''2) Add MOT-specific fields''':
+
'''3) ASN 2.0 MOT-specific fields''':
* "FLT/VESSEL/Load#".
* "FLT/VESSEL/Load#".
:* if AIR, mapped to "Flight Number"
:* if AIR, mapped to "Flight Number"
Line 118: Line 121:
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3927 '''3927''']
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3927 '''3927''']
-
'''spec''': see below
+
==== 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  ===
=== SOW 4 ASN flag: Notification Email & SMS  ===
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3942 '''3942''']
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3942 '''3942''']
-
 
-
'''spec''': see below
 
==== Core Requirements ====
==== Core Requirements ====
Line 133: Line 143:
'''Figure1. Client User Profile'''<br>
'''Figure1. Client User Profile'''<br>
[[File:ClientUserProfile.gif]]
[[File:ClientUserProfile.gif]]
 +
 +
==== Solution ====
 +
[[TBD]]
=== SOW 5 ===
=== SOW 5 ===

Revision as of 01:22, 24 January 2013


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