Past Due Report
From UG
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:
- Transport Modes:
- Client Mode (GenTab 13)
- Export pick up trucker (GenTab 8)
- Delivery Trucker:(v3)(ImpTab 4)
- Customer broker(ImpTab 9)
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
