Task #18861
openTask #19240: Sprint Planning for 06/01/2026 - 16/01/2026
Report : Pending Invoices for HBLs, MBLs, Clearings in Approved or Confirmed
95%
Description
Mr. Yoni Soleil, from EDL has requested the following report after our meeting on 01 October 2025.
Report listing all pending Standard Invoices (HBLs, MBLs, Clearings) to quickly identify shipments where files are confirmed or HBLs are Approved but no Standard Invoice has been issued, and take corrective action.
Acceptance Criteria
- The report must display:
- File Reference
- Level (HBL / MBL / CLEARING)
- HBL Number (if Level = HBL)
- MBL Number (if Level = MBL or inherited by HBL)
- Clearing Reference (if Level = CLEARING)
- Bill To
- Invoice Status (Issued/Not Issued)
- ETA/ETD or ETD in case of Export
- Days Since Approval (calculated)
- Aging Bucket (0–7 days, 8–14 days, >14 days)
- The report should allow filtering by:
- Date range (user chooses ETA or ETD in case of Export)
- File Reference (contains)
- Bill To (contains)
- HBL Number (contains)
- MBL Number (contains)
- Level (multi-select: HBL/MBL/CLEARING)
- Standard Invoice Status (multi-select: Issued/Not Issued)
- Report must be exportable to Excel.
GitLab Sync Log
[{"id": "36905", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2026-01-12T11:59:54.119Z", "log_date": "2026-01-11", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-12T11:59:54.119Z: 6h-(6.0)h spend at: 2026-01-11", "status": "active", "deleted_by": "", "redmine_entry_id": 11942}, {"id": "36993", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2026-01-13T11:56:56.557Z", "log_date": "2026-01-12", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-13T11:56:56.557Z: 6h-(6.0)h spend at: 2026-01-12", "status": "active", "deleted_by": "", "redmine_entry_id": 11951}, {"id": "37054", "author": "Waliyuddin Delba", "hours": 5.0, "created": "2026-01-14T12:03:47.067Z", "log_date": "2026-01-13", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-14T12:03:47.067Z: 5h-(5.0)h spend at: 2026-01-13", "status": "active", "deleted_by": "", "redmine_entry_id": 11960}, {"id": "37101", "author": "Waliyuddin Delba", "hours": 6.0, "created": "2026-01-15T11:53:48.727Z", "log_date": "2026-01-14", "comment": "Imported from GitLab by @Waliyuddin Delba on 2026-01-15T11:53:48.727Z: 6h-(6.0)h spend at: 2026-01-14", "status": "active", "deleted_by": "", "redmine_entry_id": 11969}]
Updated by Redmine Admin about 2 months ago
- Due date changed from 10/02/2025 to 01/16/2026
- Estimated time changed from 0:00 h to 24:00 h
- Parent task set to #19240
- gitlab project trace set to Sprint Planning for 06/01/2026 - 16/01/2026
Updated by Redmine Admin about 2 months ago
- % Done changed from 0 to 25
- GitLab Time Logged changed from 0 to 21600
Updated by Redmine Admin about 2 months ago
- Subject changed from Report : Pending Invoices (HBLs, MBLs, Clearings) to Report : Pending Invoices for HBLs, MBLs, Clearings in Approved or Confirmed
- Description updated (diff)
- % Done changed from 25 to 50
- GitLab Time Logged changed from 21600 to 43200
Updated by Redmine Admin about 2 months ago
- % Done changed from 50 to 70
- GitLab Time Logged changed from 43200 to 61200
Updated by Redmine Admin about 2 months ago
- % Done changed from 70 to 95
- GitLab Time Logged changed from 61200 to 82800
Updated by Redmine Admin about 2 months ago
- Status changed from New to Development Done
Updated by Redmine Admin about 1 month ago
- Status changed from Development Done to QA