Impending Departures Report
From UG
(Difference between revisions)
(→SOW 1) |
(→Implementation actions (for each tab OCEAN)) |
||
| Line 153: | Line 153: | ||
'''Today Tab''' | '''Today Tab''' | ||
| - | * ExpTab. Origin Terminal ETD is “today” | + | * ExpTab. Origin Terminal ETD is “today” AND ExpTab. Origin Terminal ATD is empty |
* OR | * OR | ||
| - | * ExpTab. Port Of Loading ETD is “today” | + | * ExpTab. Port Of Loading ETD is “today” AND ExpTab. Port Of Loading ATD is empty |
'''Tomorrow (1 day) Tab''' | '''Tomorrow (1 day) Tab''' | ||
| - | * ExpTab. Origin Terminal ETD is “tomorrow (today + 1 day)” | + | * ExpTab. Origin Terminal ETD is “tomorrow (today + 1 day)” AND ExpTab. Origin Terminal ATD is empty |
* OR | * OR | ||
| - | * ExpTab. Port Of Loading ETD is “tomorrow (today + 1 day)” | + | * ExpTab. Port Of Loading ETD is “tomorrow (today + 1 day)” AND ExpTab. Port Of Loading ATD is empty |
'''X days Tab''' | '''X days Tab''' | ||
| - | * ExpTab. Origin Terminal ETD is “today + X days” | + | * ExpTab. Origin Terminal ETD is “today + X days” AND ExpTab. Origin Terminal ATD is empty |
* OR | * OR | ||
| - | * ExpTab. Port Of Loading ETD is “today + X days” | + | * ExpTab. Port Of Loading ETD is “today + X days” AND ExpTab. Port Of Loading ATD is empty |
Revision as of 21:16, 23 February 2012
Contents |
Parent Mantis
Business Needs and Requirements
This report is used for identifying suspected overdue departed shipments and estimated Impending departure today, tomorrow, until X days from today to 7 days maximum for Air and Ocean. This report will help user to know what shipments are past due to depart and also estimated departure today and future after today up to 7 days.
Intro
- Generic meaning: There are list of Shipments that "Departure past Due", and list of "Departure impending shipments" today, tomorrow, the next day up to 7 days maximum
- This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied scheduled filters
- Date Criteria:
- All Past Due "Estimated depart in the past/actual depart date is empty"
- Estimated depart date is today, tomorrow, until X days from today to 7 days maximum
- Mode: Air and Ocean
- Date Criteria:
- These can be scheduled, daily, every other day, weekly etc.
- Report is a "re-occurring" report (Over due depart shipment will occur on the every report until Actual Departure Dates are set!, and impending shipments that are estimated to depart today, tomorrow, until X days from today up to 7 days maximum
- Report show Report info by sections on the excel spreadsheet: (these can be separated tabs)
- Suspected overdue shipment departures
- Impending shipment departure today
- Impending shipment in one days
- Impending shipment in two days
- etc...until seven days
Detailed spec for each tab AIR
Added: --Alex 17:01, 30 November 2009 (UTC)
Suspected Overdue Tab
- ExpTab. Airport Of Departure ETA is “yesterday, or earlier than yesterday”
- AND
- ExpTab. Airport Of Departure ATA is empty
Today Tab
- ExpTab. Airport Of Departure ETA is “today”
Tomorrow (1 day) Tab
- ExpTab. Airport Of Departure ETA is “tomorrow (today + 1 day)”
X days Tab
- ExpTab. Airport Of Departure ETA is “today + X days”
Detailed spec for each tab OCEAN
Added: --Alex 17:01, 30 November 2009 (UTC)
Suspected Overdue Tab
- ExpTab. Origin Terminal ETA is “yesterday, or earlier than yesterday”
- AND
- ExpTab. Origin Terminal ATA is empty
Today Tab
- ExpTab. Origin Terminal ETA is “today”
Tomorrow (1 day) Tab
- ExpTab. Origin Terminal ETA is “tomorrow (today + 1 day)”
X days Tab
- ExpTab. Origin Terminal ETA is “today + X days”
Filters
- Client Companies (E0 Client)
- Shippers:
- Consignees:
- Origin Countries:
- Destination Countries:
- Origin Regions:
- Destination Regions:
- Transport Modes: (Air and Ocean)
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
- Actual Picked Up Date
- Estimated Departure Date ->defaulted on the combo box
- Actual Departure Date
- Estimate Arrival Date
- Exp Tab, Destination Terminal ETA
- Actual Arrival Date
- Exp Tab, Destination Terminal ATA
- Estimated Delivery Date
- 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.)
- Invoice Generated [Y/N]->defaulted on the combo box
Note: for example, If region "North America" and Invoice is issued by Jaguar NY, then this field shows YES. (origin region billing)
SOW 1
Mantis: 3272: (Past Due) include “port dates” in the current “past due arrival / past due departure” reports
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.
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)
Solution
Preliminary note
We cannot use the dates independently each of other due specific sequence of validating dates.
Example: Port of Loading Estimated (or Arrival) date cannot be confirmed until Origin Terminal Estimated (or Arrival) date has been confirmed.
Main idea
In the same way as for Past Due report we need add validation of Port dates - Port of Loading ETD and Port of Loading ATD in addition to Origin Terminal ETD and Origin Terminal ATD.
If at least one pair of dates ETD-ATD in CT will comply with condition of Date Criteria then shipment should be added to report.
Implementation actions (for each tab OCEAN)
Suspected Overdue Tab
- ExpTab. Origin Terminal ETD is “yesterday, or earlier than yesterday” AND ExpTab. Origin Terminal ATD is empty
- OR
- ExpTab. Port Of Loading ETD is “yesterday, or earlier than yesterday” AND ExpTab. Port Of Loading ATD is empty
Today Tab
- ExpTab. Origin Terminal ETD is “today” AND ExpTab. Origin Terminal ATD is empty
- OR
- ExpTab. Port Of Loading ETD is “today” AND ExpTab. Port Of Loading ATD is empty
Tomorrow (1 day) Tab
- ExpTab. Origin Terminal ETD is “tomorrow (today + 1 day)” AND ExpTab. Origin Terminal ATD is empty
- OR
- ExpTab. Port Of Loading ETD is “tomorrow (today + 1 day)” AND ExpTab. Port Of Loading ATD is empty
X days Tab
- ExpTab. Origin Terminal ETD is “today + X days” AND ExpTab. Origin Terminal ATD is empty
- OR
- ExpTab. Port Of Loading ETD is “today + X days” AND ExpTab. Port Of Loading ATD is empty
