Past Due Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Intro)
(Intro)
Line 6: Line 6:
== Intro ==
== 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).  
+
* 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
* This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied scheduled filters
-
** Departure Past Due
+
** '''Departure Past Due'''
-
*** Ocean
+
*** Date Criteria: Estimated Departure Date is "yesterday or older" and Actual Arrival Date is empty
-
*** Air
+
*** Mode:
-
*** Truck
+
**** Ocean
-
** Arrival Past Due
+
**** Air
-
*** Ocean
+
**** Truck
-
*** Air
+
** '''Arrival Past Due'''
-
*** Truck
+
*** 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 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)
+
* Report show Report info, date time stamp and how many records are found (number) on the excel spreadsheet
For Example:  
For Example:  

Revision as of 13:52, 6 October 2009


Contents

Business Needs and Requirements

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.

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 Arrival 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

Filters

  • Client Companies (E0 Client)
  • Shippers:
  • Consignees:
  • Origin Countries:
  • Destination Countries:
  • Origin Regions:
  • Destination Regions:

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
Personal tools