Past Due Report

From UG

(Difference between revisions)
Jump to: navigation, search
(SOW 1)
(Solution)
 
(5 intermediate revisions not shown)
Line 176: Line 176:
=== Glossary ===
=== Glossary ===
-
* '''ETD''' = Estimated Time of Departure ''(a.k.a Estimated Departure Date)''
+
* '''Terminal''' = Origin Terminal (''for Departure Past Due'') OR Destination Terminal (''for Arrival Past Due'')
-
* '''ATD''' = Actual Time of Departure ''(a.k.a Actual Departure Date)''
+
* '''Port''' = Port Of Loading (''for Departure Past Due'') OR Port Of Discharge (''for Arrival Past Due'')
-
* '''ETA''' = Estimated Time of Arrival ''(a.k.a Estimated Arrival Date)''
+
-
* '''ATA''' = Actual Time of Arrival ''(a.k.a Actual Arrival Date)''
+
=== Solution ===
=== Solution ===
-
The solution suggested by Marc is to show two different groups of shipments that follow each other in report:
+
The solution suggested by Marc is to show ''on one tab'' two different groups of shipments that follow each other in report:
-
*1) CTs which have the '''same''' "Terminal" and "Port" dates AND their ''Terminal Dates'' are comply to specified Date Criteria:
+
'''Departure Past Due'''
-
:* ''Departure Past Due'': Origin Terminal ETD is “yesterday, or earlier than yesterday” and Origin Terminal ATD is empty  
+
*1) CTs which have the '''same''' "Origin Terminal" and "Port Of Loading" and their ''Terminal Dates'' are comply to specified Date Criteria:
-
:* ''Arrival Past Due'': Destination Terminal ETA is “yesterday, or earlier than yesterday” and Destination Terminal ATA is empty
+
:* Origin Terminal ETD is “yesterday, or earlier than yesterday” AND Origin Terminal ATD is empty  
 +
*2) CTs which have '''different''' "Origin Terminal" and "Port Of Loading" and their ''Port Dates'' are comply to specified Date Criteria
 +
:* Port Of Loading ETD is “yesterday, or earlier than yesterday” AND Port Of Loading ATD is empty  
-
*2) CTs which have '''different''' "Terminal" and "Port" dates AND their ''Port Dates'' are comply to specified Date Criteria
+
'''Arrival Past Due'''
-
:* ''Departure Past Due'': Port Of Loading ETD is “yesterday, or earlier than yesterday” and Port Of Loading ATD is empty  
+
*1) CTs which have the '''same''' "Destination Terminal" and "Port Of Discharge" and their ''Terminal Dates'' are comply to specified Date Criteria:
-
:* ''Arrival Past Due'': Port Of Discharge ETA is “yesterday, or earlier than yesterday” and Port Of Discharge ATA is empty
+
:* Destination Terminal ETA is “yesterday, or earlier than yesterday” AND Destination Terminal ATA is empty
 +
*2) CTs which have '''different''' "Destination Terminal" and "Port Of Discharge" and their ''Port Dates'' are comply to specified Date Criteria
 +
:* Port Of Discharge ETA is “yesterday, or earlier than yesterday” AND Port Of Discharge ATA is empty
 +
 
 +
NOTE for mapping: Dates in output should be mapped to Terminal/Port dates from used Criteria.
== User Guide ==
== User Guide ==

Current revision as of 23:10, 1 March 2012


Contents

[edit] Mantis

1590

[edit] Glossary

  • ETD = Estimated Time of Departure (a.k.a Estimated Departure Date)
  • ATD = Actual Time of Departure (a.k.a Actual Departure Date)
  • ETA = Estimated Time of Arrival (a.k.a Estimated Arrival Date)
  • ATA = Actual Time of Arrival (a.k.a Actual Arrival Date)

[edit] Business Needs and Requirements

File:Past_Due_Arrival_Report.JPG

This report is used for identifying shipments for incomplete arrival/departure date report. This report will help user to know what shipments are not completed arrived/departed, so that user can update it.

[edit] Intro

  • Generic meaning: System tells a client that the shipment SHOULD have arrived/departed yesterday or earlier, but there is no "Actual arrival/Departure Date" in the system(empty). Update is needed.
  • This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied scheduled filters
    • Departure Past Due
      • Date Criteria: Estimated Departure Date is "yesterday or older" and Actual Departure Date is empty
      • Mode:
        • Ocean
        • Air
        • Truck
    • Arrival Past Due
      • Date Criteria: Estimated Arrival Date is "yesterday or older" and Actual Arrival Date is empty
      • Mode:
        • Ocean
        • Air
        • Truck
  • These can be scheduled, daily, every other day, weekly etc.
  • Report is a "re-occurring" report (shipments that are past due will occur on the report everyday until Actual arrival/Departure Dates are set!
  • Report show Report info, date time stamp and how many records are found (number) on the excel spreadsheet

For Example:

Incomplete Date Report

Time Date Stamp

(number) (Arrivals/Departure) into (destination country) by (mode) have gone past their estimated (arrival/departure) date without having an actual (arrival/departure) date


[edit] Past Due Departure (Detailed Spec)

--Alex 01:00, 1 December 2009 (UTC)

Important Note! Be aware of confusing terminology for truck modes here!

  • Word "departure" on the report name is connected to CT fields that are named "pick-up". This is because for truck modes this is "the point of origin" and both words "departure" and "pick-up" are associated with "origin".
  • Word "arrival" on the report name is connected to CT fields that are named "delivery". This is because for truck modes this is "the point of destination" and both words "arrival" and "delivery" are associated with "destination".

[edit] Air

  • ExpTab. Airport Of Departure ETA is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Airport Of Departure ATA is empty

[edit] Ocean

  • ExpTab. Origin Terminal ETA is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Origin Terminal ATA is empty

[edit] Truck-Air

  • GenTab. Estimated (Export) Pick-up Date is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Actual (Export) Pick-up Date is empty

[edit] Truck-Dom

  • GenTab. Estimated (Export) Pick-up Date is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Actual (Export) Pick-up Date is empty

[edit] Truck-Ocean

For at least one container X on ContTab the following is true:

  • container X. Estimated collection is “yesterday, or earlier than yesterday”
  • AND
  • container X. Actual collection is empty

[edit] Past Due Arrival (Detailed Spec)

--Alex 01:01, 1 December 2009 (UTC)

[edit] Air

  • ExpTab. Airport Of Destination ETA is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Airport Of Destination ATA is empty

[edit] Ocean

  • ExpTab. Destination Terminal ETA is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Destination Terminal ATA is empty

[edit] Truck-Air

  • GenTab. Estimated Deliv Date is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Actual Deliv Date is empty

[edit] Truck-Dom

  • GenTab. Estimated Deliv Date is “yesterday, or earlier than yesterday”
  • AND
  • ExpTab. Actual Deliv Date is empty

[edit] Truck-Ocean

For at least one container X on ContTab the following is true:

  • container X. Requested Delivery is “yesterday, or earlier than yesterday”
  • AND
  • container X. Actual Delivery is empty

[edit] Filters

  • Client Companies (E0 Client)
  • Shippers:
  • Consignees:
  • Origin Countries:
  • Destination Countries:
  • Origin Regions:
  • Destination Regions:
  • Transport Modes:
  • Client Mode (GenTab 13)
  • Export pick up trucker (GenTab 8)
  • Delivery Trucker:(v3)(ImpTab 4)
  • Customer broker(ImpTab 9)

[edit] Output

  • Create output tab with list of output headings
  • Some headings should be defaulted on the combo box and the rest of headings are in the dropdown filter output list
  • List of headings:
    • CT# with link ->defaulted on the combo box
    • Customer References# (GenTab C.Customer Ref)
    • Transport Modes (GenTab F. Mode of Transport:)
    • Shippers (GenTab 2.Shipper) ->defaulted on the combo box
    • Consignees (GenTab 3.Consignee) ->defaulted on the combo box
    • Origin Countries (GenTab 11. Origin country) ->defaulted on the combo box
    • Destination Countries (GenTab 12. Destination country) ->defaulted on the combo box
    • Estimated Picked Up Date ->defaulted on the combo box/ Depart for Truck
    • Actual Picked Up Date
    • Estimated Departure Date ->defaulted on the combo box/ Depart for Ocean and Air
    • Actual Departure Date
    • Estimate Arrival Date ->defaulted on the combo box/ Arrival for Ocean and Air
      • Exp Tab, Destination Terminal ETA
    • Actual Arrival Date
      • Exp Tab, Destination Terminal ATA
    • Estimated Delivery Date ->defaulted on the combo box/ Arrival for Truck
    • Actual Delivery Date
    • P.O (ContTab Table A.)
    • SKU (ContTab Table A.)
    • Quantity (ContTab Table A.)
    • Item Description (ContTab Table A.)
    • Ttl # of plts (ContTab Table A.)
    • Ttl pkgs on pkgs (ContTab Table A.)
    • Loose pkgs (ContTab Table A.)
    • Ttl G kg (ContTab Table A.)
    • Custom fields (if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well)
    • Total CBM (ContTab Table B.)
    • Last Comment entry (ComTab>most recent comment)

[edit] Sort by

By CT#?

[edit] SOW 1

Mantis: 3272: (Past Due) include “port dates” in the current “past due arrival / past due departure” reports

[edit] Problem

  • MOT = any OCEAN, the system only looks at the “terminals” but ignores the “ports”.
  • If/when there is a different “origin terminal” and “port of loading” - there is no validation (past due departure) for the “port of loading” date.
  • If/when there is a different “destination terminal” and “port of discharge” – there is no validation (past due arrival) for the “port of discharge” date.

Core requirements:

  • We need to use “port dates” and “terminal dates” – independently and separately UNLESS they have the same value.

[edit] Glossary

  • Terminal = Origin Terminal (for Departure Past Due) OR Destination Terminal (for Arrival Past Due)
  • Port = Port Of Loading (for Departure Past Due) OR Port Of Discharge (for Arrival Past Due)

[edit] Solution

The solution suggested by Marc is to show on one tab two different groups of shipments that follow each other in report:

Departure Past Due

  • 1) CTs which have the same "Origin Terminal" and "Port Of Loading" and their Terminal Dates are comply to specified Date Criteria:
  • Origin Terminal ETD is “yesterday, or earlier than yesterday” AND Origin Terminal ATD is empty
  • 2) CTs which have different "Origin Terminal" and "Port Of Loading" and their Port Dates are comply to specified Date Criteria
  • Port Of Loading ETD is “yesterday, or earlier than yesterday” AND Port Of Loading ATD is empty

Arrival Past Due

  • 1) CTs which have the same "Destination Terminal" and "Port Of Discharge" and their Terminal Dates are comply to specified Date Criteria:
  • Destination Terminal ETA is “yesterday, or earlier than yesterday” AND Destination Terminal ATA is empty
  • 2) CTs which have different "Destination Terminal" and "Port Of Discharge" and their Port Dates are comply to specified Date Criteria
  • Port Of Discharge ETA is “yesterday, or earlier than yesterday” AND Port Of Discharge ATA is empty

NOTE for mapping: Dates in output should be mapped to Terminal/Port dates from used Criteria.

[edit] User Guide

[edit] Example of current reports: NYC - Export - Past Due Departures

!!! No E0 field on output for some reason!

File:NYC - Export - Past Due Departures.JPG

File:NYC - Export - Past Due Departures 2.JPG

File:NYC - Export - Past Due Departures 3.JPG

[edit] Example of current reports: NYC - Import - Past Due Arrivals

File:NYC - Import - Past Due Arrivals.JPG

[edit] All Past Due reps in the System

File:All past dues in the system.JPG

[edit] History

Personal tools