Past Due Report
From UG
(Difference between revisions)
(→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
- Departure Past Due
- 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