ASN 20 ph3

From UG

(Difference between revisions)
Jump to: navigation, search
(Solution)
(SOW 2 Support additional ASN 2.0 Fields and Columns on download to xls and flex shipments list)
 
(128 intermediate revisions not shown)
Line 1: Line 1:
[[Category:ASN 20]]
[[Category:ASN 20]]
-
 
-
== Intro ==
 
== SOWs ==
== SOWs ==
Line 8: Line 6:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3926 '''3926''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3926 '''3926'''] (''phase:'' UAT, ''status:'' closed)
'''spec''': see below
'''spec''': see below
Line 25: Line 23:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3968 '''3968''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3968 '''3968'''] (''phase:'' SA, ''status:'' completed)
==== Core Requirements ====
==== Core Requirements ====
* Remove “ARCHIVED” records, enable to select specific TAB (status) for printing
* Remove “ARCHIVED” records, enable to select specific TAB (status) for printing
 +
Additional options to the “pre-print window”:
 +
Include Status: new .. approved .. hold .. rejected .. delivered .. archived
 +
Default:
 +
Include: new / approved / hold
 +
Exclude: rejected / delivered / archived
==== Solution ====
==== Solution ====
-
[[TBD]]
+
* It is suggested to add the "Include/Exclude tabs" section into "Select Output Fields" pop-up window.
 +
* Each ASN tab is presented as item of listbox labelled with the name of appropriated Tab: ''New, Approved, Hold, Rejected, Delivered, Archived''.
 +
* Including/Excluding the tabs into/from Excel should be managed  with using "drag-n-drop" feature between "Include" and "Exclude" lists:
 +
 
 +
[[File:mockup_for_3968.GIF]]
 +
 
 +
==== Post-Implementation Notes ====
 +
* In downloaded Excel, title label ''"Shipment List on Web Portal"'' changed to ''"ASN Portal download"'' ('''ASN 2 only''').
<hr>
<hr>
 +
=== SOW 1B Download to Excel. Display filter's criteria in header of downloaded XLS ===
=== SOW 1B Download to Excel. Display filter's criteria in header of downloaded XLS ===
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3973 '''3973''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3973 '''3973'''] (''phase:'' RFC, ''status:'' statusX)
==== Core Requirements ====
==== Core Requirements ====
Line 56: Line 67:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4031 '''4031''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4031 '''4031'''] (''phase:'' SA, ''status:'' completed)
==== Core Requirements ====
==== Core Requirements ====
Line 69: Line 80:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3925 '''3925''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3925 '''3925'''] (''phase:'' Stg, ''status:'' closed)
==== Core Requirements ====
==== Core Requirements ====
Line 101: Line 112:
==== Solution ====
==== Solution ====
-
Add the following columns to Flexible Shipment List (and use them as ''Output Fields'' of "Download to Excel"):
+
Add the following columns to ASN2.0 Flexible Shipment List (and use them as ''Output Fields'' of "Download to Excel"):
'''1) ASN 1.x fields''':
'''1) ASN 1.x fields''':
Line 134: Line 145:
'''3) ASN 2.0 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" ''(ExtTab. 9a. Flight One)''
:* if OCEAN, mapped to "Vessel Name"
:* if OCEAN, mapped to "Vessel Name"
:* if TRUCK, mapped to "Load Number"
:* if TRUCK, mapped to "Load Number"
Line 172: Line 183:
* This is the preliminary set of fields in "Visible list" part of the "Select Output Fields" window.
* This is the preliminary set of fields in "Visible list" part of the "Select Output Fields" window.
* "Visible list" of Output Fields should be generated dynamically and reflect displayed fields of Shipment List for current tab of Portal.
* "Visible list" of Output Fields should be generated dynamically and reflect displayed fields of Shipment List for current tab of Portal.
 +
 +
 +
<hr>
 +
 +
=== SOW 2A Show Estimated Dates in Shipment List when Actual Dates are empty  ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4321 '''4321'''] (''phase:'' ??, ''status:'' ??)
 +
 +
==== Core Requirements ====
 +
* The label is “arrival date” and “departure date”
 +
* This should show “estimated” until there is an “actual” -> then show actual
 +
 +
* So:
 +
:* No date: Empty field
 +
:* No actual -> Estimated: Show Estimated
 +
:* Actual -> Show actual
 +
 +
==== Solution ====
 +
 +
* This is for "Date of Departure" and "Date of Arrival" columns.
Line 178: Line 210:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3927 '''3927''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3927 '''3927'''] (''phase:'' SIT, ''status:'' closed)
==== Core Requirements ====
==== Core Requirements ====
Line 219: Line 251:
<hr>
<hr>
 +
=== SOW 4 ASN flag: Notification Email & SMS  ===
=== SOW 4 ASN flag: Notification Email & SMS  ===
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3942 '''3942''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3942 '''3942'''] (''phase:'' SA, ''status:'' completed, waiting for Review)
==== Core Requirements ====
==== Core Requirements ====
Line 233: Line 266:
:* We need to use the SAME status changes as those used in CT2, including also changes after Planner's actions - Approve/Hold/Reject.
:* We need to use the SAME status changes as those used in CT2, including also changes after Planner's actions - Approve/Hold/Reject.
:* Use the events logic from [[Shipment Progress condition]].
:* Use the events logic from [[Shipment Progress condition]].
-
:* For TRUCKING departed/collected and arrived/delivered are the same value and these notifications should not be duplicated.
+
:* NOTE: For TRUCKING departed/collected and arrived/delivered are the same value and these notifications should not be duplicated.
 +
 
 +
===== Settings =====
 +
This part of task is under '''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3977 '''3977''']
 +
 
* Settings of notifications should be managed from User Profile in Client Application.
* Settings of notifications should be managed from User Profile in Client Application.
-
:* Since we haven't the User profile section for ASN users, this is to be implemented.
+
:* To get an access to "My Profile" section (as well as Watchlist) an ASN User should have Client User rights.
-
:* These settings works for e-mail and SMS sending:
+
-
::* "My Profile" section for CT2 Client users remains the same as is.
+
-
::* "My Profile" section for ASN users is separate window and contains only settings of "ASN Flagged Shipments Status Notification".
+
-
::* If User plays multiple roles ''(e.g. Client User and Generic Planner)'' system should provide manage settings for each role separately.
+
 +
===== Notifications =====
'''E-mail notifications'''
'''E-mail notifications'''
-
* It is a feature to generate an email to Shipper/Planner when ASN record is completed collected, departed, arrived and delivered.  
+
* It is a feature to generate an email to Shipper/Planner when ASN record:
 +
:* has changed Status after Planner's action to Approved/Hold/New''(from Hold)''/Rejected.
 +
:* is completed collected, departed, arrived and delivered.
* Email gets sending out to each Shipper/Planner for each flagged ASN record by himself.
* Email gets sending out to each Shipper/Planner for each flagged ASN record by himself.
* The ASN record listed in the e-mail message should be a hyper-link to that particular record and opened on appropriate Portal tab (for Shipper or Planner).
* The ASN record listed in the e-mail message should be a hyper-link to that particular record and opened on appropriate Portal tab (for Shipper or Planner).
Line 257: Line 293:
  ASN record number XXXXX has been APPROVED.
  ASN record number XXXXX has been APPROVED.
  ASN record number XXXXX has been placed on HOLD.
  ASN record number XXXXX has been placed on HOLD.
 +
ASN record number XXXXX has been changed to NEW.
  ASN record number XXXXX has been REJECTED.
  ASN record number XXXXX has been REJECTED.
  ASN record number XXXXX has now been authorized for shipment.
  ASN record number XXXXX has now been authorized for shipment.
Line 297: Line 334:
  OR
  OR
  ASN# XXXXX has been placed on HOLD.
  ASN# XXXXX has been placed on HOLD.
 +
OR
 +
ASN# XXXXX has been changed to NEW.
  OR
  OR
  ASN# XXXXX has been REJECTED.
  ASN# XXXXX has been REJECTED.
Line 320: Line 359:
==== Related Functionality ====
==== Related Functionality ====
* Once ASN record is flagged it should be added to [[Client Watch List | Client Watch List]]:
* Once ASN record is flagged it should be added to [[Client Watch List | Client Watch List]]:
-
:* Added ASN Record is to be named as "flagged by User Role (User Name)".
+
:* This part of task implemented under '''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4160 '''4160''']
-
:* Added record is to be visible in Watch List for all Client users which have access to it by Client Visibility rules.
+
-
:* ASN Shipper/Planner users haven't access to Client Watch List.
+
==== Figures ====
==== Figures ====
Line 330: Line 367:
<hr>
<hr>
 +
=== SOW 4A ASN flag: Notification Email & SMS. Client Watchlist  ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4160 '''4160'''] (''phase:'' SA, ''status:'' completed)
 +
 +
==== Core Requirements ====
 +
* Add flagged ASN to "Home Page / ClientWatchList" automatically
 +
 +
==== Solution ====
 +
* To use this feature, User should have rights for both of roles:
 +
:* ASN User (Shipper/Planner) to flag a record.
 +
:* Client User ''with appropriate Client Visibility Rules'' to see it in Watchlist and receive notifications.
 +
 +
* Once ASN record is flagged in ASN Portal:
 +
:* Flagged record is becoming visible in [[Client Watch List | Client Watch List]] of User.
 +
:* User who has flagged that ASN should start to receive status e-mail notifications for ASNs which are in Watchlist.
 +
 +
* '''Watchlist''' details:
 +
:* Nickname should be ''"Supplier / PO # / SKU #"'' (derived from that ASN record):
 +
::* Supplier is mapped to Shipper, show first 8 characters.
 +
::* PO/SKU are from the first line of Commodity Table.
 +
:* "Auth" column should be renamed to "'''Status'''" and display status of ASN record with appropriate mouse-over description (including Hold and Rejected statuses):
 +
::* New - gray word "NEW", aligned to left border of column
 +
::* Hold - yellow bar
 +
::* Rejected - white letter "X" in red circle, also aligned to left
 +
::* Authorized/Collected/Departed/Arrived - blue bar
 +
::* Delivered - orange bar with checkmark
 +
::* Custom - leave as is
 +
::* NOTE: Ocean-FCL case'' (from Coll to Deliv)''. When appropriate dates have been set not for all containers - blue/orange bar with white strips ''(in "zebra"-style)''
 +
:* Mouse-over on bars should display hints with status and appropriate dates.
 +
::* "Status" - New :
 +
:::* "Created on " + [http://wiki.jaguarfreight.com/wiki/CT_bo#Created_On_Date Created On Date]
 +
:::* "Changed to New on" + Date when ASN record status was set to New from Hold.
 +
::* "Status" - Approved : "Authorized on " + [http://wiki.jaguarfreight.com/wiki/CT_bo#Authorized_On Authorized On Date]
 +
::* "Status" - Hold : "On hold since " + Date when ASN record was placed [http://wiki.jaguarfreight.com/wiki/ASN_1.X#Hold_Without_Approved_For_Pick_Up_On_Date_Status on hold]
 +
::* "Status" - Hold with approved for: "On hold until " + [http://wiki.jaguarfreight.com/wiki/Cybertrax_2.1_Client_%28data_dictionary%29#Approved_For_Date Approved For Date]
 +
::* "Status" - Rejected : "Rejected on " + Date when ASN record was [http://wiki.jaguarfreight.com/wiki/ASN_1.X#Reject_Status rejected]
 +
::* "Coll/Dept/Arriv/Deliv" : don't display status, just dates
 +
::* NOTE: no hint for column with no status bar
 +
* Delivered shipment should be kept in "Watch List" for 1 week and then removed to "Archived" tab.
 +
* Rejected shipment should be automatically removed from "Watch List" in 1 month after rejecting.
 +
* When ASN record is unflagged, it should be removed from Watchlist, and vice versa.
 +
 +
 +
<hr>
 +
 +
=== SOW 4B ASN flag: Notification Email & SMS. Estimated Dates in Client Watchlist  ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4181 '''4181'''] (''phase:'' BA, ''status:'' completed), [http://mantis.jaguarfreight.com/mantis/view.php?id=4391 '''4391'''] (''phase:'' Stg, ''status:'' completed)
 +
 +
==== Core Requirements ====
 +
* show Estimated Dates in Client Watchlist.
 +
 +
==== Solution ====
 +
* This should be implemented for columns: Coll/Dept/Arriv/Deliv:
 +
:* in case when Actual Date is empty but appropriate Estimated Date isn't.
 +
* Use a frame of status bar (no color).
 +
:* NOTE: Ocean-FCL case'' (from Coll to Deliv)''. When appropriate dates have been set not for all containers - show bar with strips ''(in "zebra"-style)''
 +
* Mouse-over hint should display the appropriate Estimated Date (no status text):
 +
:* "Coll" : [http://wiki.jaguarfreight.com/wiki/CT#Estimated_Export_Pick_Up_Date Estimated Export Pick Up Date].
 +
:* "Dept" : Estimated Departure Date ''(same mapping as [http://wiki.jaguarfreight.com/wiki/Main_Report#Date_Filters here])''.
 +
:* "Arriv" : Estimated Arrival Date.
 +
:* "Deliv" : [http://wiki.jaguarfreight.com/wiki/CT#Estimated_Delivery_Date Estimated Delivery Date].
 +
:* NOTE 1: Ocean-FCL case: use dates from [http://wiki.jaguarfreight.com/wiki/Container Containers Table] and display hint with "X of Y containers estimated to Coll/Dept/Arriv/Deliv".
 +
:* NOTE 2: Show "Estimated" in the label, before the date.
 +
::* Requested by Marc at Dec 02 2013, should be implemented under mantis [http://mantis.jaguarfreight.com/mantis/view.php?id=4391 '''4391'''].
 +
::* Example: ''Estimated 30-Nov-2013''.
 +
=== SOW 5 Add CBM/CFT to all the “View ASN” windows ===
=== SOW 5 Add CBM/CFT to all the “View ASN” windows ===
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3963 '''3963''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3963 '''3963'''] (''phase:'' UAT, ''status:'' closed)
==== Core Requirements ====
==== Core Requirements ====
Line 339: Line 445:
==== Solution ====
==== Solution ====
-
*Add Volume column to Commodity Table in "View ASN" window
+
*Add Volume column to Commodity Table in "View ASN" window ''(including Planner's "Confirm" window to hold/reject/approve ASN)''
:* Show Volume in units which were used by Shipper when ASN entered.
:* Show Volume in units which were used by Shipper when ASN entered.
:* Use headers to see which units are used: CBM (cubic meters) or CFT (cubic feet).
:* Use headers to see which units are used: CBM (cubic meters) or CFT (cubic feet).
Line 345: Line 451:
<hr>
<hr>
 +
=== SOW 6 Dynamic filtering of list when the planner first access the portal ===
=== SOW 6 Dynamic filtering of list when the planner first access the portal ===
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3969 '''3969''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3969 '''3969'''] (''phase:'' SA, ''status:'' completed)
==== Core Requirements ====
==== Core Requirements ====
Line 357: Line 464:
==== Solution ====
==== Solution ====
-
System should recognize a planner and prepare "Planner's name:" dropdown list with the following:
+
* When a Planner opens a Portal first time for current session, System should to set the value of "Planner's name:" dropdown list in accordance with the name of logged Planner.
-
* ALL
+
:* Shipment List should be filtered for current Planner's name.
-
* NO MATCH FOUND
+
-
* name of the logged Planned - show it by default and filter list of records.
+
<hr>
<hr>
 +
=== SOW 7 Correct visibility of "PO Issued By" and "Planner's name" ===
=== SOW 7 Correct visibility of "PO Issued By" and "Planner's name" ===
<hr>
<hr>
Line 382: Line 488:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3975 '''3975''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3975 '''3975'''] (''phase:'' SA, ''status:'' completed)
==== Core Requirements ====
==== Core Requirements ====
-
* Shipper shouldn't see "Planner's name" filter
+
* Shipper shouldn't see [http://wiki.jaguarfreight.com/wiki/ASN_1.X#Planner_filter "Planner's name" filter]
==== Solution ====
==== Solution ====
Line 392: Line 498:
<hr>
<hr>
 +
=== SOW 9 Add validation for Cargo Due Date and Cargo Available Date ===
=== SOW 9 Add validation for Cargo Due Date and Cargo Available Date ===
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4006 '''4006''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4006 '''4006'''] (''phase:'' UAT, ''status:'' completed)
==== Core Requirements ====
==== Core Requirements ====
Line 431: Line 538:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4014 '''4014''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4014 '''4014'''] (''phase:'' UAT, ''status:'' new)
==== Intro ====
==== Intro ====
Line 464: Line 571:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4067 '''4067''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4067 '''4067'''] (''phase:'' SA, ''status:'' statusX)
==== Core Requirements ====
==== Core Requirements ====
Line 484: Line 591:
<hr>
<hr>
-
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4070 '''4070''']
+
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4070 '''4070'''] (''phase:'' Review, ''status:'' completed)
==== Core Requirements ====
==== Core Requirements ====
-
* 1. Add a “Piece Price” column to [http://wiki.jaguarfreight.com/wiki/ASN_1.X#SKU_to_Planner_map SKU to Planner map]
+
* 1. Add a “Piece Price” column to [http://wiki.jaguarfreight.com/wiki/ASN_1.X#SKU_to_Planner_map SKU to Planner map] (SKU map)
* 2. Add to ASN editor a functionality of calculating the value automatically ''(Qty x Item value = Total value)
* 2. Add to ASN editor a functionality of calculating the value automatically ''(Qty x Item value = Total value)
''
''
==== Solution ====
==== Solution ====
* Upload SKU map with "Standard Cost" column.
* Upload SKU map with "Standard Cost" column.
-
* Use it as "Piece Price" in CyberTrax
+
* Use "Standard Cost" from SKU map as "Piece Price" in CyberTrax
:* Display Piece Price column in "SKU to ASN Planner map" window (ASN Portal Admin)
:* Display Piece Price column in "SKU to ASN Planner map" window (ASN Portal Admin)
-
:* Set Piece Price for selected SKU in ASN editor
+
:* Set Piece Price for selected SKU in ASN editor - ''once SKU is selected the Piece Price is populated with appropriate value''
:* Calculate Total Volume as Qty * Piece Price
:* Calculate Total Volume as Qty * Piece Price
'''ASN1 case'''
'''ASN1 case'''
-
* It is suggested to implemented this as separate task
+
* It is suggested to implement this as separate task
<hr>
<hr>
 +
 +
=== SOW 13 SKU map update (PO#) ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=3967 '''3967''']
 +
 +
==== Core Requirements ====
 +
* 1. Add a “PO” column
 +
* 2. Add a functionality to calculate the value automatically (see example in mantis notes)
 +
''
 +
==== Solution ====
 +
* [[TBD]]
 +
 +
'''ASN1 case'''
 +
* [[TBD]]
 +
 +
 +
<hr>
 +
=== SOW 14 Remove "archive" from "live" Portal to make it avail via separate "link" to improve refresh speed in "live Portal" ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4087 '''4087'''] (''phase:'' SA, ''status:'' completed)
 +
 +
==== Core Requirements ====
 +
* Remove "archive" from "live" Portal --> make it available via separate "link" to improve refresh speed in "live Portal"
 +
 +
==== Solution ====
 +
* Shipment List form contains link to separate window (similarly to KPI link) that shows only archived records.
 +
: 1 - [[File:RemoveArchived-01.png]]<br/> 2 - [[File:RemoveArchived-02.png]]
 +
* '''Notes''':
 +
:* Rejected should be "archived" but under a separate TAB (archived deliveries / archived rejections).
 +
::* Archive rejected ASN in 30 days after it was rejected.
 +
::* Leave the rule for archiving of delivered ASN to [http://wiki.jaguarfreight.com/wiki/Client_Shipment_List#Archived_Tab Archived Tab] the same ''(180 days after actual delivery date)''.
 +
:* No need to implement this for ASN1.
 +
 +
 +
<hr>
 +
 +
=== SOW 15 migrate ASN1 to ASN 2 ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4159 '''4159'''] (''phase:'' BA, ''status:'' started)
 +
 +
==== Core Requirements ====
 +
* Migrate ASN1 to ASN 2 and close (stop using) ASN1.
 +
:* All ASN1 shipments should be visible in one ASN2 Portal.
 +
:* User rights and settings of all EA Shippers/Planners should be transferred to appropriate ASN2 Users.
 +
:* Closing of ASN1 can be done only after achieving the complete identity of ASN1 and ''"EA DOM Portal"''.
 +
 +
==== Solution ====
 +
* Create new ASN2 Portal as container for ASN1 shipments for further using by EA DOM team:
 +
:* Portal name is ''"EA DOM Portal"''.
 +
:* set Client Companies to EA DOM PORTAL.
 +
:* create appropriate Transport Modes with settings:
 +
::* Mode = "ASN Mode".
 +
::* CT2 Transport Mode = Trucking-Domestic.
 +
:* add PO Issued By Companies to the Portal:
 +
::* copy PO Issued By Companies from Admin - Transportation.
 +
::* keep the settings of Approval Process and Cargo Due feature.
 +
::* turn SKU Map feature on and upload it for each POI.
 +
* Create ASN2 Users copies of existing ASN1 Users:
 +
:* Add ''"EA DOM Portal"'' for each User.
 +
:* Copy to each Profile the settings that User has for ASN1.
 +
* Link the ASN1 shipments to "EA DOM Portal" (to show them in Shipment Lists):
 +
:* for Shipper Users by Client Company and Shipper (Supplier).
 +
:* for Planner Users by PO Issued By Companies.
 +
 +
 +
<hr>
 +
=== SOW 16 3PL output field ===
 +
<hr>
 +
 +
'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4173 '''4173'''] (''phase:'' BA, ''status:'' started)
 +
 +
==== Core Requirements ====
 +
* add 3PL output field into ASN2.
 +
 +
==== Solution ====
 +
* 3PL (''a third-party logistics provider'') is a field of ASN record:
 +
:* It is mapped to [http://wiki.jaguarfreight.com/wiki/ASN_20_Solution#ASN_transmit ASN Transmit Option] and should be filled when ASN transmitted to 3PL.
 +
:* After transmitting an ASN, 3PL cannot be available to any edit.
 +
* Changing a name (or e-mail) of 3PL in Admin section should be reflected in all related ASNs (transmitted to this 3PL).
 +
* NOTE: Showing in Shipment List, Output to downloaded XLS already implemented in mantis #3925 ([http://wiki.jaguarfreight.com/wiki/ASN_20_ph3#SOW_2_Support_additional_ASN_2.0_Fields_and_Columns_on_download_to_xls_and_flex_shipments_list SOW 2]).
 +
<!-- * Changing a 3PL for Client is managed in Portal Admin section with adding/editing ASN Portal Transmit To Rule. -->
 +
 +
 +
<hr>
 +
=== SOW 17 ===
 +
<hr>
 +
 +
==== Expedited Shipment Approval Feature ====
 +
 +
'''mantis''': 0004079
 +
 +
'''spec:'''
 +
 +
'''Business Need:''' To enable certain planners to tag shipments as "expedited" (urgent).
 +
 +
Reason code explaining why they are urgent would be attached.
 +
 +
Reason codes are to be managed in Admin.
 +
 +
Notifications would be sent.
 +
 +
===== Expedited for ASN 1x =====
 +
 +
For now this feature to be implemented for ASN 1x only.
 +
 +
===== Expedited Planner =====
 +
 +
To enable planner to expedite shipment:
 +
 +
* go to Internal > Admin > User Profile > EA Planner
 +
* check "Expedited Planner" checkbox
 +
 +
===== Reason code management =====
 +
 +
To manage reason codes:
 +
* go to Internal > Admin > Transportation > Reason Codes
 +
* user can Add, Edit, Remove codes (Archive is not needed)
 +
 +
===== How to expedite shipment =====
 +
 +
* Log in into Client
 +
* Click on Planner link
 +
* Go to Approved Tab
 +
* Select one or more shipments
 +
* Select "Expedited" button
 +
* System will produce pop-up where it will explain
 +
** what records are already expedited
 +
** what can not be expedited
 +
** what will be expedited
 +
* example of what is on pop-up:
 +
 +
The following records are in transit: 431275
 +
The following records are Picked Up and can't be expedited: 430357
 +
The following records will be Expedited: 430136
 +
Please select Reason Code
 +
Reason Code: [dropdown with codes]
 +
 +
===== Expedited Confirmation email =====
 +
 +
Email will be send to Shipper, cc Planner when shipment(s) are expedited. See example below:
 +
 +
Dear <Shipper's name>,
 +
The following shipment has been EXPEDITED by <Planner's name>.
 +
Reason Code: <code>.
 +
Cargo Due Date: <date>.
 +
To view this online in CyberTrax 2.0, please follow this link: CT#<number with hyperlink>
 +
.
 +
Jaguar Freight does not provide cargo marine insurance unless specifically requested and confirmed in writing.
 +
Please ensure you have appropriate cover for all your domestic and international shipments.
 +
.
 +
Please note that all business is transacted subject to our general business terms and conditions, as indicated on our
 +
freight invoices and HB/L, a copy of which is also available upon request.
 +
 +
===== Additional expedited columns on Shipments list =====
 +
 +
* expedited status (Yes / No)
 +
* expedited code
 +
 +
===== Misc expedited logic =====
 +
 +
* only fully approved shipments can be expedited
 +
* picked up records can not be expedited
 +
* this operation can not be undone (can not un-expedite expedited shipments)
 +
* there will be a record in the History that record is expedited
 +
 +
 +
<hr>
 +
 +
 +
Continued in [[ASN 20 ph3 (part2)]]

Current revision as of 13:51, 18 December 2013


Contents

[edit] SOWs

[edit] SOW 1 Download to Excel. Ability to select fields/columns and specify sequence/order (for ASN 2.0)


mantis: 3926 (phase: UAT, status: closed)

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

[edit] SOW 1A Download to Excel. Enable to select specific TAB (status) for output


mantis: 3968 (phase: SA, status: completed)

[edit] Core Requirements

  • Remove “ARCHIVED” records, enable to select specific TAB (status) for printing
Additional options to the “pre-print window”:
Include Status: new .. approved .. hold .. rejected .. delivered .. archived
Default:
Include: new / approved / hold
Exclude: rejected / delivered / archived

[edit] Solution

  • It is suggested to add the "Include/Exclude tabs" section into "Select Output Fields" pop-up window.
  • Each ASN tab is presented as item of listbox labelled with the name of appropriated Tab: New, Approved, Hold, Rejected, Delivered, Archived.
  • Including/Excluding the tabs into/from Excel should be managed with using "drag-n-drop" feature between "Include" and "Exclude" lists:

File:mockup_for_3968.GIF

[edit] Post-Implementation Notes

  • In downloaded Excel, title label "Shipment List on Web Portal" changed to "ASN Portal download" (ASN 2 only).



[edit] SOW 1B Download to Excel. Display filter's criteria in header of downloaded XLS


mantis: 3973 (phase: RFC, status: statusX)

[edit] Core Requirements

  • Since the downloaded XLS contains a filtered list of records, it would be good to show the filters' criteria in the header of XLS.

[edit] Solution

  • Display criteria for filters:
  • PO Issued By
  • Planner's name
  • Mode/Sub-Mode
  • Search
  • Display criteria for included TABs (related task 3968)



[edit] SOW 1C Download to Excel. Remove the Jaguar picture / logo to reduce file size


mantis: 4031 (phase: SA, status: completed)

[edit] Core Requirements

  • Remove the Jaguar picture / logo to reduce file size.

[edit] Solution

  • Remove the Jaguar picture / logo from downloaded spreadsheet to reduce file size.



[edit] SOW 2 Support additional ASN 2.0 Fields and Columns on download to xls and flex shipments list


mantis: 3925 (phase: Stg, status: closed)

[edit] 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

[edit] Solution

Add the following columns to ASN2.0 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)
  • "Cubic M/Ft" (CBM/CFT)

3) ASN 2.0 MOT-specific fields:

  • "FLT/VESSEL/Load#".
  • if AIR, mapped to "Flight Number" (ExtTab. 9a. Flight One)
  • 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 none. Please show "n/a" rather than empty.
  • "Date of Departure"
  • if AIR/OCEAN, mapped to "Date of Departure"
  • if TRUCK, just copy "Actual Pick up Date"
  • "Destination Point"
  • if AIR, mapped to "Destination Airport"
  • if OCEAN, mapped to "Destination Terminal"
  • if TRUCK, mapped to none. Please show "n/a" rather than empty.
  • "Date of Arrival"
  • if AIR/OCEAN, mapped to "Date of Arrival"
  • if TRUCK, just copy "Actual Delivery Date"

NOTE: There are fields for which user can select measurement units: "Total Gross Weight", "Total Value", "Cubic M/Ft" (CBM/CFT).

  • All mentioned values should be shown so as they were entered in ASN
  • It is suggested to add a column next to dims to show what it is, same for currency etc.
  • For example: weight | KG/LB | Amount | currency | volume | Vol Unit | Dims | Dims Unit

[edit] 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"

3) Default pre-set of Output Fields.

  • This is the preliminary set of fields in "Visible list" part of the "Select Output Fields" window.
  • "Visible list" of Output Fields should be generated dynamically and reflect displayed fields of Shipment List for current tab of Portal.



[edit] SOW 2A Show Estimated Dates in Shipment List when Actual Dates are empty


mantis: 4321 (phase: ??, status: ??)

[edit] Core Requirements

  • The label is “arrival date” and “departure date”
  • This should show “estimated” until there is an “actual” -> then show actual
  • So:
  • No date: Empty field
  • No actual -> Estimated: Show Estimated
  • Actual -> Show actual

[edit] Solution

  • This is for "Date of Departure" and "Date of Arrival" columns.



[edit] SOW 3 Default units of measurement & currency types


mantis: 3927 (phase: SIT, status: closed)

[edit] 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) Weight: Pound (LB) ot Kilogram (KG).
3) Dims: centimenters (cms) or inches (in).

NOTE: Volume (Cubic Meters (CBM) or Cubic Feet (CFT)) and Dims are used in one measurement system.

[edit] Solution

[edit] Admin settings
  • Internal Application
  • Access to these “settings” is for JFS internal users (with access to ASN menu) only.
  • This is to be implemented in Admin -> ASN Portal -> PO ISSUED BY.
  • For each "PO issued by" of ASN Portal could be select ONE default currency and ONE default measurement unit from list above.
  • Default currency (and other default unit) is linked to and could be edited for Generic Shipper.
  • This EDIT is in Admin->User->Shipper->PO ISSUED BY.
  • Every user can only have 1 option for each setting - 1 currency, 1 weight unit, 1 dims unit for each PO Issued By.
  • Shipper could use inherited defaults from Portal's "PO issued by" or his own values for each unit.
  • To manage this please use checkbox widget with label "Use Default Portal settings" (or sth like this).
  • This might be similar to "Use Default Gross Margin Split Rule" checkbox in "Edit Client Company" window.
  • if checkbox checked, fields of currency type and measurement units should be set to Portal's value and become read-only.
  • if checkbox unchecked, fields of currency type and measurement units should be editable.
  • If Shipper uses Portal defaults then all changes in Portal should be transferred to User Profile settings automatically.
[edit] Objects of using
  • ASN Portal
  • Add/Edit/View of ASN Record
  • All values should be entered in units selected for Shipper.
  • Headers of Commodity should reflect unit of measurement or name of currency

NOTE: Planner has "view-only" role in regards to defaults of ASN.

[edit] Questions

  • We already have "Shipments Weight in:" settings for Shipper. Should we replace this or re-use ? - Re-use if it is possible.



[edit] SOW 4 ASN flag: Notification Email & SMS


mantis: 3942 (phase: SA, status: completed, waiting for Review)

[edit] 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 ASN record with functionality for email/sms notification.
  • Flagged ASN record should become visible in Client Watch list (subject to Client visibility rules).

[edit] Solution

  • Feature for Shipper/Planner users in both ASN1 and ASN2 to provide the sending of notifications about changes in flagged ASN records:
  • We need to use the SAME status changes as those used in CT2, including also changes after Planner's actions - Approve/Hold/Reject.
  • Use the events logic from Shipment Progress condition.
  • NOTE: For TRUCKING departed/collected and arrived/delivered are the same value and these notifications should not be duplicated.
[edit] Settings

This part of task is under mantis: 3977

  • Settings of notifications should be managed from User Profile in Client Application.
  • To get an access to "My Profile" section (as well as Watchlist) an ASN User should have Client User rights.
[edit] Notifications

E-mail notifications

  • It is a feature to generate an email to Shipper/Planner when ASN record:
  • has changed Status after Planner's action to Approved/Hold/New(from Hold)/Rejected.
  • is completed collected, departed, arrived and delivered.
  • Email gets sending out to each Shipper/Planner for each flagged ASN record by himself.
  • The ASN record listed in the e-mail message should be a hyper-link to that particular record and opened on appropriate Portal tab (for Shipper or Planner).
  • The Subject title of the message should be as follows: ASN record XXXXXX Important Status Update
  • Body of e-mail message should use the following parts:
Dear First Name Last Name (from User Profile of General Shipper/Planner),

Please be advised that the following change(s) have been recorded in a ASN record you were flagged:

then should be added the one from the following clauses:

ASN record number XXXXX has been APPROVED.
ASN record number XXXXX has been placed on HOLD.
ASN record number XXXXX has been changed to NEW.
ASN record number XXXXX has been REJECTED.
ASN record number XXXXX has now been authorized for shipment.
ASN record number XXXXX has now been collected.
ASN record number XXXXX has now departed.
ASN record number XXXXX has now arrived.
ASN record number XXXXX has now been delivered.
ASN record number XXXXX is now "released" by Customs.
ASN record number XXXXX is now under "exam" by Customs.
ASN record number XXXXX shows as "may proceed" by Customs.
ASN record number XXXXX has been "submitted" to Customs.

then add the following text as bottom of message:

Thank you for using the Freight Architects at Jaguar Freight Services!

Best regards,
Jaguar Freight Services

P.S.
You are receiving this notification because the ASN in subject was flagged. 
To discontinue automated notifications for this specific record please unflag this ASN. 
To discontinue all ASN notifications please adjust your user profile settings. 

Jaguar Freight does not provide cargo marine insurance unless specifically requested and confirmed in writing.
Please ensure you have appropriate cover for all your domestic and international shipments.

Please note that all business is transacted subject to our general business terms and conditions,
as indicated on our freight invoices and HB/L, a copy of which is also available upon request. 

 Please consider the environment before printing this e-mail

SMS notifications

It is a feature to send SMS text message to ASN Sipper/Planner when shipment is completed collected, departed, arrived and delivered.

SMS text message is sent out to Shipper/Planner(s) for each ASN record number (ASN record number/SMS text message).

ASN# XXXXX has been APPROVED.
OR
ASN# XXXXX has been placed on HOLD.
OR
ASN# XXXXX has been changed to NEW.
OR
ASN# XXXXX has been REJECTED.
OR
ASN# XXXXX has now been authorized for shipment.
OR
ASN# XXXXX has now been collected.
OR
ASN# XXXXX has now departed.
OR
ASN# XXXXX has now arrived.
OR
ASN# XXXXX has now been delivered.
OR
ASN# XXXXX is now "released" by Customs.
OR
ASN# XXXXX is now under "exam" by Customs.
OR
ASN# XXXXX shows as "may proceed" by Customs.
OR
ASN# XXXXX has been "submitted" to Customs.

[edit] Related Functionality

  • This part of task implemented under mantis: 4160

[edit] Figures

Figure1. Client User Profile
File:ClientUserProfile.gif



[edit] SOW 4A ASN flag: Notification Email & SMS. Client Watchlist


mantis: 4160 (phase: SA, status: completed)

[edit] Core Requirements

  • Add flagged ASN to "Home Page / ClientWatchList" automatically

[edit] Solution

  • To use this feature, User should have rights for both of roles:
  • ASN User (Shipper/Planner) to flag a record.
  • Client User with appropriate Client Visibility Rules to see it in Watchlist and receive notifications.
  • Once ASN record is flagged in ASN Portal:
  • Flagged record is becoming visible in Client Watch List of User.
  • User who has flagged that ASN should start to receive status e-mail notifications for ASNs which are in Watchlist.
  • Watchlist details:
  • Nickname should be "Supplier / PO # / SKU #" (derived from that ASN record):
  • Supplier is mapped to Shipper, show first 8 characters.
  • PO/SKU are from the first line of Commodity Table.
  • "Auth" column should be renamed to "Status" and display status of ASN record with appropriate mouse-over description (including Hold and Rejected statuses):
  • New - gray word "NEW", aligned to left border of column
  • Hold - yellow bar
  • Rejected - white letter "X" in red circle, also aligned to left
  • Authorized/Collected/Departed/Arrived - blue bar
  • Delivered - orange bar with checkmark
  • Custom - leave as is
  • NOTE: Ocean-FCL case (from Coll to Deliv). When appropriate dates have been set not for all containers - blue/orange bar with white strips (in "zebra"-style)
  • Mouse-over on bars should display hints with status and appropriate dates.
  • "Status" - New :
  • "Created on " + Created On Date
  • "Changed to New on" + Date when ASN record status was set to New from Hold.
  • "Status" - Approved : "Authorized on " + Authorized On Date
  • "Status" - Hold : "On hold since " + Date when ASN record was placed on hold
  • "Status" - Hold with approved for: "On hold until " + Approved For Date
  • "Status" - Rejected : "Rejected on " + Date when ASN record was rejected
  • "Coll/Dept/Arriv/Deliv" : don't display status, just dates
  • NOTE: no hint for column with no status bar
  • Delivered shipment should be kept in "Watch List" for 1 week and then removed to "Archived" tab.
  • Rejected shipment should be automatically removed from "Watch List" in 1 month after rejecting.
  • When ASN record is unflagged, it should be removed from Watchlist, and vice versa.



[edit] SOW 4B ASN flag: Notification Email & SMS. Estimated Dates in Client Watchlist


mantis: 4181 (phase: BA, status: completed), 4391 (phase: Stg, status: completed)

[edit] Core Requirements

  • show Estimated Dates in Client Watchlist.

[edit] Solution

  • This should be implemented for columns: Coll/Dept/Arriv/Deliv:
  • in case when Actual Date is empty but appropriate Estimated Date isn't.
  • Use a frame of status bar (no color).
  • NOTE: Ocean-FCL case (from Coll to Deliv). When appropriate dates have been set not for all containers - show bar with strips (in "zebra"-style)
  • Mouse-over hint should display the appropriate Estimated Date (no status text):
  • "Coll" : Estimated Export Pick Up Date.
  • "Dept" : Estimated Departure Date (same mapping as here).
  • "Arriv" : Estimated Arrival Date.
  • "Deliv" : Estimated Delivery Date.
  • NOTE 1: Ocean-FCL case: use dates from Containers Table and display hint with "X of Y containers estimated to Coll/Dept/Arriv/Deliv".
  • NOTE 2: Show "Estimated" in the label, before the date.
  • Requested by Marc at Dec 02 2013, should be implemented under mantis 4391.
  • Example: Estimated 30-Nov-2013.

[edit] SOW 5 Add CBM/CFT to all the “View ASN” windows


mantis: 3963 (phase: UAT, status: closed)

[edit] Core Requirements

  • We need show CBM/CFT (as they were entered) in all "View ASN" windows.

[edit] Solution

  • Add Volume column to Commodity Table in "View ASN" window (including Planner's "Confirm" window to hold/reject/approve ASN)
  • Show Volume in units which were used by Shipper when ASN entered.
  • Use headers to see which units are used: CBM (cubic meters) or CFT (cubic feet).



[edit] SOW 6 Dynamic filtering of list when the planner first access the portal


mantis: 3969 (phase: SA, status: completed)

[edit] Core Requirements

Dynamic filtering of list when the planner first access the portal … show only “planner sku” matches instead of “all”
So default view for “Dale Boyer” is “D. BOYER” from Planner drop down, option is to show “all” or “no match found” etc
On Feb 5, 2013, at 5:17 PM, Marc Selter

[edit] Solution

  • When a Planner opens a Portal first time for current session, System should to set the value of "Planner's name:" dropdown list in accordance with the name of logged Planner.
  • Shipment List should be filtered for current Planner's name.



[edit] SOW 7 Correct visibility of "PO Issued By" and "Planner's name"


mantis: 3970

[edit] Core Requirements

  • ASN ... little 'glitch' that needs to be corrected / users should only be able to filter by "PO Issued By to which they have access to" (hide all others from the dropdown)
  • Same for PLANNER drop down … the user Jackel Planner has only access to JACKEL PO’s … Mary & John are listed on a LF Beauty PO/SKU map … in this case Jackel Planner should only see Jackel (PO Issued By) info, if a planner has access to more than 1 PO Issued BY then that planner should see a combination of the dropdowns.

[edit] Solution

TBD



[edit] SOW 8 Shipper shouldn't see "Planner's name" filter


mantis: 3975 (phase: SA, status: completed)

[edit] Core Requirements

[edit] Solution

  • "Planner's name" filter should be hidden/removed for Shipper.



[edit] SOW 9 Add validation for Cargo Due Date and Cargo Available Date


mantis: 4006 (phase: UAT, status: completed)

[edit] Core Requirements

  • The due date should be after the ready date, please implement this validation asap.

[edit] Solution

Validation of Cargo Due Date and Cargo Available Date should be provided:

  • in Client Application when Cargo Due Date is set:
  • when creating ASN record (MOT=Trucking-Domestic in ASN2)
  • during approval CT process:
  • change CT status from any status to Approve status
  • change CT status from any status to Hold with Approved for Pick Up On Date status
  • in Internal Application
  • on CT GenTab

Condition

System should only allow the cargo due date to be = or > than the CT_bo#Cargo_available & CT_bo#Approved_For_Delivery_By_Date & CT_bo#Approved_On
  • If Cargo Due Date doesn't correspond the condition above system should:
  • display warning message "Cargo Due Date can't be before Cargo Available Date",
  • not allow to complete the performed action (save or approval).

ASN1 case

  • ASN1 allows to proceed an approval for multiple shipments.
  • If "Cargo Due Date" is lower than "Cargo Available Date" for some selected shipments, system should display list of these shipments and suggest two options:
  • "Approve allowed" - let user to approve shipments with Cargo Available Date < or = Cargo Due Date. Probably display confirm window with list of shipments to approve.
  • "Cancel Approval" - just close warning window.



[edit] SOW 10 Change mapping for "Ship To Location" in Air/Ocean records


mantis: 4014 (phase: UAT, status: new)

[edit] Intro

  • Currently in ASN2, Ship to Location address is selecting from AddressBook/Transportation flagged with "T5: Export Delivery Location" OR "T7: Import Delivery Location".
  • Selected "Ship To" is mapped to Internal Application as Consignee (T2) (Gen Tab. 3) AND Export Delivery To (T5) (Gen Tab. 6) for ALL MOT.

[edit] Core Requirements

  • air / ocean – Consignee SHOULD BE CONSIGNEE and/or Import Tab “delivery location” … not the “export pick up deliver to address” (Marc)

[edit] Solution

We need provide the following mapping for Ship To Location in ASN2 to specific Delivery Addresses in Internal Application depending on MOT of ASN record:

  • if MOT = AIR / OCEAN, Ship to Location should be mapped to:
  • Consignee (T2) (Gen Tab. 3) AND
  • Delivery Address (Import Delivery Location):(T7) (on Imp Tab)
  • NOTE: Export Delivery To (T5) (Gen Tab. 6) remains BLANK / EMPTY in this case
  • if MOT = Trucking (all types), Ship to Location should be mapped to:
  • Consignee (T2) (Gen Tab. 3) AND
  • Export Delivery Location (T5) (Gen Tab. 6)
  • NOTE: This is how the system works now.

Additional functionality:

  • if "Transportation Address Type" (T5/T7 in AddressBook/Transportation) of selected "Ship To" doesn't match to MOT of ASN record, we need update it accordingly.
  • Example 1: MOT = Trucking, "Ship To" flagged in AddressBook as T7 only. When this address selected it should be flagged as T5 also.
  • Example 2: MOT = Air/Ocean, "Ship To" flagged in AddressBook as T5 only. When this address selected it should be flagged as T7 also.



[edit] SOW 11 Only Air Planner can Approve/Hold for AIR


mantis: 4067 (phase: SA, status: statusX)

[edit] Core Requirements

  • Only Air planner can Approve / Hold for AIR.
  • Air Approval is only for Air CT of course.

[edit] Solution

  • When Basic Planner or Super Planner tries to Approve or Hold for AIR, System should:
  • display error message: “Air approval requires additional credentials, please contact your line manager”.
  • prevent the action (Approve or Hold).
  • Basic Planner or Super Planner CAN REJECT the AIR record.
  • “Air Approval” settings in Admin section are applicable only for AIR CTs.
  • For non-AIR records Air Planner works as Single(Basic) Planner only.



[edit] SOW 12 SKU map update (Piece Price)


mantis: 4070 (phase: Review, status: completed)

[edit] Core Requirements

  • 1. Add a “Piece Price” column to SKU to Planner map (SKU map)
  • 2. Add to ASN editor a functionality of calculating the value automatically (Qty x Item value = Total value)

[edit] Solution

  • Upload SKU map with "Standard Cost" column.
  • Use "Standard Cost" from SKU map as "Piece Price" in CyberTrax
  • Display Piece Price column in "SKU to ASN Planner map" window (ASN Portal Admin)
  • Set Piece Price for selected SKU in ASN editor - once SKU is selected the Piece Price is populated with appropriate value
  • Calculate Total Volume as Qty * Piece Price

ASN1 case

  • It is suggested to implement this as separate task



[edit] SOW 13 SKU map update (PO#)


mantis: 3967

[edit] Core Requirements

  • 1. Add a “PO” column
  • 2. Add a functionality to calculate the value automatically (see example in mantis notes)

[edit] Solution

ASN1 case



[edit] SOW 14 Remove "archive" from "live" Portal to make it avail via separate "link" to improve refresh speed in "live Portal"


mantis: 4087 (phase: SA, status: completed)

[edit] Core Requirements

  • Remove "archive" from "live" Portal --> make it available via separate "link" to improve refresh speed in "live Portal"

[edit] Solution

  • Shipment List form contains link to separate window (similarly to KPI link) that shows only archived records.
1 - File:RemoveArchived-01.png
2 - File:RemoveArchived-02.png
  • Notes:
  • Rejected should be "archived" but under a separate TAB (archived deliveries / archived rejections).
  • Archive rejected ASN in 30 days after it was rejected.
  • Leave the rule for archiving of delivered ASN to Archived Tab the same (180 days after actual delivery date).
  • No need to implement this for ASN1.



[edit] SOW 15 migrate ASN1 to ASN 2


mantis: 4159 (phase: BA, status: started)

[edit] Core Requirements

  • Migrate ASN1 to ASN 2 and close (stop using) ASN1.
  • All ASN1 shipments should be visible in one ASN2 Portal.
  • User rights and settings of all EA Shippers/Planners should be transferred to appropriate ASN2 Users.
  • Closing of ASN1 can be done only after achieving the complete identity of ASN1 and "EA DOM Portal".

[edit] Solution

  • Create new ASN2 Portal as container for ASN1 shipments for further using by EA DOM team:
  • Portal name is "EA DOM Portal".
  • set Client Companies to EA DOM PORTAL.
  • create appropriate Transport Modes with settings:
  • Mode = "ASN Mode".
  • CT2 Transport Mode = Trucking-Domestic.
  • add PO Issued By Companies to the Portal:
  • copy PO Issued By Companies from Admin - Transportation.
  • keep the settings of Approval Process and Cargo Due feature.
  • turn SKU Map feature on and upload it for each POI.
  • Create ASN2 Users copies of existing ASN1 Users:
  • Add "EA DOM Portal" for each User.
  • Copy to each Profile the settings that User has for ASN1.
  • Link the ASN1 shipments to "EA DOM Portal" (to show them in Shipment Lists):
  • for Shipper Users by Client Company and Shipper (Supplier).
  • for Planner Users by PO Issued By Companies.



[edit] SOW 16 3PL output field


mantis: 4173 (phase: BA, status: started)

[edit] Core Requirements

  • add 3PL output field into ASN2.

[edit] Solution

  • 3PL (a third-party logistics provider) is a field of ASN record:
  • It is mapped to ASN Transmit Option and should be filled when ASN transmitted to 3PL.
  • After transmitting an ASN, 3PL cannot be available to any edit.
  • Changing a name (or e-mail) of 3PL in Admin section should be reflected in all related ASNs (transmitted to this 3PL).
  • NOTE: Showing in Shipment List, Output to downloaded XLS already implemented in mantis #3925 (SOW 2).



[edit] SOW 17


[edit] Expedited Shipment Approval Feature

mantis: 0004079

spec:

Business Need: To enable certain planners to tag shipments as "expedited" (urgent).

Reason code explaining why they are urgent would be attached.

Reason codes are to be managed in Admin.

Notifications would be sent.

[edit] Expedited for ASN 1x

For now this feature to be implemented for ASN 1x only.

[edit] Expedited Planner

To enable planner to expedite shipment:

  • go to Internal > Admin > User Profile > EA Planner
  • check "Expedited Planner" checkbox
[edit] Reason code management

To manage reason codes:

  • go to Internal > Admin > Transportation > Reason Codes
  • user can Add, Edit, Remove codes (Archive is not needed)
[edit] How to expedite shipment
  • Log in into Client
  • Click on Planner link
  • Go to Approved Tab
  • Select one or more shipments
  • Select "Expedited" button
  • System will produce pop-up where it will explain
    • what records are already expedited
    • what can not be expedited
    • what will be expedited
  • example of what is on pop-up:
The following records are in transit: 431275
The following records are Picked Up and can't be expedited: 430357
The following records will be Expedited: 430136
Please select Reason Code
Reason Code: [dropdown with codes]
[edit] Expedited Confirmation email

Email will be send to Shipper, cc Planner when shipment(s) are expedited. See example below:

Dear <Shipper's name>,
The following shipment has been EXPEDITED by <Planner's name>.
Reason Code: .
Cargo Due Date: <date>.
To view this online in CyberTrax 2.0, please follow this link: CT#<number with hyperlink>
.
Jaguar Freight does not provide cargo marine insurance unless specifically requested and confirmed in writing. 
Please ensure you have appropriate cover for all your domestic and international shipments.

.

Please note that all business is transacted subject to our general business terms and conditions, as indicated on our 
freight invoices and HB/L, a copy of which is also available upon request.
[edit] Additional expedited columns on Shipments list
  • expedited status (Yes / No)
  • expedited code
[edit] Misc expedited logic
  • only fully approved shipments can be expedited
  • picked up records can not be expedited
  • this operation can not be undone (can not un-expedite expedited shipments)
  • there will be a record in the History that record is expedited




Continued in ASN 20 ph3 (part2)

Personal tools