Task #18863: Report - Pending House Delivery Order - FFA - Redmine

Actions

Copy link

Task #18863

closed

Task #19240: Sprint Planning for 06/01/2026 - 16/01/2026

Report - Pending House Delivery Order

Added by Redmine Admin 11 months ago. Updated 3 months ago.

Status:

Closed

Priority:

Normal

Assignee:

Start date:

10/02/2025

Due date:

01/16/2026

% Done:

100%

Estimated time:

30:00 h

Spent time:

30:00 h

GitLab ID:

3317

GitLab Milestone:

GitLab Ticket Number:

953

GitLab Time Logged:

108000

Lock Timeline Date:

gitlab project trace:

Sprint Planning for 06/01/2026 - 16/01/2026

Description

Mr. Yoni Soleil, from EDL has requested the following report after our meeting on 01 October 2025.

Report listing all pending House Delivery Orders (HDOs) to quickly identify shipments where no Manual DO or CCS transmission has been done and take corrective action.

Acceptance Criteria¶

The report must display:
- File Reference
- HBL Number
- MBL Number
- Consignee
- DO Type (Temporary / Manual DO / CCS Transmission)
- Status (Approved/Not Approved)
- Transmission Status (Not Sent / Success / Failed)
- DO Created Date
Pending logic
- Pending – RED: A Temporary DO exists AND (no Manual DO OR no CCS Transmission).
- Pending – ORANGE: No DO at all (no Temporary, no Manual, no Transmission).
- Exclude from report: A Manual DO exists OR a CCS Transmission (Success) exists.
The report should allow filtering by:
- Date range (ETA or DO created date)
- File Reference (contains)
- Customer (contains)
- HBL Number (contains)
- MBL Number (contains)
- KPI tiles: add small KPIs above the table:
  - “Pending (RED) count”, “No DO (ORANGE) count”
Report must be exportable to Excel.

GitLab Sync Log

[{"id": "36630", "author": "Waliyuddin Delba", "hours": 2.0, "created": "2026-01-08T11:54:12.242Z", "log_date": "2026-01-07", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-08T11:54:12.242Z: 2h-(2.0)h spend at: 2026-01-07", "status": "active", "deleted_by": "", "redmine_entry_id": 11912}, {"id": "37140", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2026-01-16T11:33:58.342Z", "log_date": "2026-01-15", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-16T11:33:58.342Z: 6h-(6.0)h spend at: 2026-01-15", "status": "active", "deleted_by": "", "redmine_entry_id": 11981}, {"id": "37341", "author": "Waliyuddin Delba", "hours": 5.0, "created": "2026-01-19T10:49:11.216Z", "log_date": "2026-01-18", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-19T10:49:11.216Z: 5h-(5.0)h spend at: 2026-01-18", "status": "active", "deleted_by": "", "redmine_entry_id": 11992}, {"id": "42397", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2026-04-17T10:20:51.733Z", "log_date": "2026-04-15", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-17T10:20:51.733Z: 6h-(6.0)h spend at: 2026-04-15", "status": "active", "deleted_by": "", "redmine_entry_id": 13136}, {"id": "42388", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2026-04-17T10:18:05.666Z", "log_date": "2026-04-17", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-17T10:18:05.666Z: 6h-(6.0)h spend at: 2026-04-17", "status": "deleted", "deleted_by": "42395", "redmine_entry_id": 13137}, {"id": "42535", "author": "Ra-ees Peeroo", "hours": 3.0, "created": "2026-04-21T05:34:30.645Z", "log_date": "2026-04-16", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-21T05:34:30.645Z: 3h-(3.0)h spend at: 2026-04-16", "status": "active", "deleted_by": "", "redmine_entry_id": 13170}, {"id": "42895", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2026-04-23T07:18:51.959Z", "log_date": "2026-04-19", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-23T07:18:51.959Z: 7h-(7.0)h spend at: 2026-04-19", "status": "active", "deleted_by": "", "redmine_entry_id": 13281}, {"id": "43165", "author": "Ra-ees Peeroo", "hours": 1.0, "created": "2026-04-27T09:34:46.374Z", "log_date": "2026-04-20", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-04-27T09:34:46.374Z: 1h-(1.0)h spend at: 2026-04-20", "status": "active", "deleted_by": "", "redmine_entry_id": 13341}]