Past Due Report

From UG

Contents 1 Business Needs and Requirements 2 Intro 3 Filters 4 Output

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