Impending Arrivals Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:OpsReps == Business Needs and Requirements == This report is used for identifying suspected overdue shipments arrivals and estimated Impending arrival today, tomorr…')
(→Intro)
Line 9: Line 9:
* This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied scheduled filters
* This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied scheduled filters
** Date Criteria:  
** Date Criteria:  
-
1) All Past Due "Estimated arrival in the past/actual arrival date is empty"
+
*** All Past Due "Estimated arrival in the past/actual arrival date is empty"
-
 
+
*** Estimated arrival date is today, tomorrow, until XX days from today to 15 days maximum
-
2) Estimated arrival date is today, tomorrow, until XX days from today to 15 days maximum
+
** Mode: Air and Ocean
-
 
+
-
** Mode:
+
-
*** '''Ocean''' (shipments into (destination country) by ocean have an actual arrival date, not all containers have been confirmed as delivered or no delivery comment has been given)
+
-
*** '''Air''' (shipments into (destination country) by Air have an actual arrival date, but no final delivery date or comment has been added or have gone past their requested delivery date)
+
-
 
+
* These can be scheduled, daily, every other day, weekly etc.
* These can be scheduled, daily, every other day, weekly etc.
-
* Report is a "re-occurring" report (shipments that are arrival completed will occur on the report everyday until Actual Delivery Dates are set!
+
* Report is a "re-occurring" report (Over due Arrivals shipment will occur on the every report until Actual Arrival Dates are set!, and impending shipments that are estimated to arrive today, tomorrow, until XX days from today to 15 days maximum
-
* Report show Report info, date time stamp and how many records are found (number) on the excel spreadsheet
+
* Report show Report info by sections on the excel spreadsheet: (these can be separated by tab)
-
 
+
** Suspected overdue shipment arrivals
-
For Example:  
+
** Impending shipment arrivals today
-
 
+
** Impending shipment in one days
-
Incomplete Date Report
+
** Impending shipment in two days
-
 
+
** etc...until fifteen days
-
Time Date Stamp
+
-
 
+
-
(number) shipment into (destination country) by Ocean have an actual arrival date, not all containers have been confirmed as delivered or no delivery comment has been given --> this is for Ocean shipments
+
-
 
+
-
(number) shipments into (destination country) by Air have an actual arrival date, but no final delivery date or comment has been added or have gone past their requested delivery date --> this is for Air shipments
+
== Filters ==
== Filters ==

Revision as of 17:51, 6 October 2009


Contents

Business Needs and Requirements

This report is used for identifying suspected overdue shipments arrivals and estimated Impending arrival today, tomorrow, until xx days from today to 15 days maximum for Air and Ocean. This report will help user to know what shipments are past due and also estimated arrival today and future after today for 15 days.

Intro

  • Generic meaning: There are list of Shipments that "Arrival past Due", and list of "Arrival impending shipments" today, tomorrow, the next day until 15 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 arrival in the past/actual arrival date is empty"
      • Estimated arrival date is today, tomorrow, until XX days from today to 15 days maximum
    • Mode: Air and Ocean
  • These can be scheduled, daily, every other day, weekly etc.
  • Report is a "re-occurring" report (Over due Arrivals shipment will occur on the every report until Actual Arrival Dates are set!, and impending shipments that are estimated to arrive today, tomorrow, until XX days from today to 15 days maximum
  • Report show Report info by sections on the excel spreadsheet: (these can be separated by tab)
    • Suspected overdue shipment arrivals
    • Impending shipment arrivals today
    • Impending shipment in one days
    • Impending shipment in two days
    • etc...until fifteen 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
    • Actual Departure Date
    • Estimate Arrival Date
    • Actual Arrival Date ->defaulted on the combo box
    • 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.)
    • Last Comment entry (ComTab>most recent comment)
Retrieved from "https://wiki.jaguarfreight.com/Impending_Arrivals_Report"
Personal tools