ASN 20 ph3
From UG
(Difference between revisions)
(→Business Requirements) |
(→SOW 2 Support additional ASN 2.0 Fields and Columns on download to xls and flex shipments list) |
||
| Line 25: | Line 25: | ||
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3925 '''3925'''] | '''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3925 '''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 | ||
| + | * Planner Name | ||
| + | |||
| + | 2) Add ASN 1.x fields: | ||
| + | * <span style="color:grey">"CT #" (2.0)</span> | ||
| + | * "Shipper" | ||
| + | * <span style="color:grey">"Pick Up Location" (2.0)</span> | ||
| + | * <span style="color:grey">"Ship To Location" (2.0)</span> | ||
| + | * "P.O. Issued by" | ||
| + | * "Pick Up Instructions" | ||
| + | * "Commodity Description" | ||
| + | * "Cargo Available Date" | ||
| + | * <span style="color:grey">"Cargo Due date" (2.0)</span> | ||
| + | * <span style="color:grey">"P.O." (2.0)</span> | ||
| + | * <span style="color:grey">"SKU" (2.0)</span> | ||
| + | * <span style="color:grey">"Quantity" (2.0)</span> | ||
| + | * "Number of Pallets" | ||
| + | * "Packages on Pallets" | ||
| + | * "Loose Packages" | ||
| + | * "Total Gross Weight (lb)" | ||
| + | * <span style="color:grey">"Piece Price" (2.0)</span> | ||
| + | * <span style="color:grey">"Total Value" (2.0)</span> | ||
| + | * <span style="color:grey">"Item Description" (2.0)</span> | ||
| + | * "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" | ||
| + | * "Last Update Date and Time" | ||
| + | * "Last Update by" | ||
| + | * "Mode Of Transport" | ||
| + | * <span style="color:grey">"Created On Date" (2.0)</span> | ||
| + | * <span style="color:grey">"Approved On Date" (2.0)</span> | ||
| + | * <span style="color:grey">"Approved For Pickup On Date" (2.0)</span> | ||
| + | * <span style="color:grey">"Rejected On Date" (2.0)</span> | ||
| + | |||
| + | 3) Add additionally selected fields: | ||
| + | [[TBD]] | ||
| + | |||
| + | ==== 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 === | === SOW 3 Default units of measurement & currency types === | ||
Revision as of 15:29, 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
- Planner 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"
- "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: TBD
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
