Task #17557
openTask #18451: Ocean Sprint Planning for 16/06/2025 - 30/06/2025
Report - Job File Weight/Volume by Origin Report
100%
Description
Acceptance Criteria:¶
-
Report Header:
- Company Name, Logo, Address, Contact Info, VAT Registration Number
- Report Title: "Job File Weight/Volume by Origin Report"
- Reporting Period (clearly stated From - To dates)
-
Report Structure and Fields
- The system should generate a structured report displaying shipment weight/volume by origin for a selected period.
- The report should include the following details and other fields as listed in the sample report.
- Year
- Origin (Port of Loading)
- Total Shipment Weight (Tons)
- Total Shipment Volume (CBM)
- Monthly Breakdown (January - December)
- Annual Total
- The system should allow sorting by year and origin.
-
Filtering and Selection Criteria
- The system should allow users to filter data by:
- Date Range (From Date - To Date)
- Origin (Port of Loading)
- Shipment Type (LCL, FCL)
- Company / Business Unit
- Freight Terms (Prepaid, Collect)
- Users should have an option to filter by year or monthly breakdown.
- The system should allow users to filter data by:
-
Export and Reporting Format
- The system should allow exporting the report in:
- PDF Format
- Excel Format
- Users should be able to schedule automatic report generation and email notifications (e.g., monthly, quarterly, yearly).
- The system should allow exporting the report in:
-
Data Visualization
- Can also provide an interactive dashboard view with (if possible):
- Bar charts and trend graphs comparing shipment weight/volume by origin.
- Drill-down capability to view individual shipment details by month or specific origin.
- Can also provide an interactive dashboard view with (if possible):
-
User Access & Permissions
- Only authorised users (e.g., Operations Managers, Freight Forwarders, and Logistics Analysts) should have access to generate and view the report.
{width="609" height="860"}
GitLab Sync Log
[{"id": "24705", "author": "Gilles Mahomudally", "hours": 2.0, "created": "2025-06-10T10:48:05.944Z", "log_date": "2025-06-09", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-10T10:48:05.944Z: 2h-(2.0)h spend at: 2025-06-09", "status": "active", "deleted_by": "", "redmine_entry_id": 9564}, {"id": "24744", "author": "Gilles Mahomudally", "hours": 6.0, "created": "2025-06-11T11:11:26.853Z", "log_date": "2025-06-10", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-11T11:11:26.853Z: 6h-(6.0)h spend at: 2025-06-10", "status": "active", "deleted_by": "", "redmine_entry_id": 9571}, {"id": "24869", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-06-13T05:31:52.760Z", "log_date": "2025-06-12", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-13T05:31:52.760Z: 1d-(8.0)h spend at: 2025-06-12", "status": "active", "deleted_by": "", "redmine_entry_id": 9618}, {"id": "24868", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-06-13T05:31:41.225Z", "log_date": "2025-06-11", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-13T05:31:41.225Z: 1d-(8.0)h spend at: 2025-06-11", "status": "active", "deleted_by": "", "redmine_entry_id": 9619}, {"id": "25116", "author": "Gilles Mahomudally", "hours": 8.0, "created": "2025-06-16T11:50:28.954Z", "log_date": "2025-06-15", "comment": "Imported from GitLab by @Gilles Mahomudally on 2025-06-16T11:50:28.954Z: 1d-(8.0)h spend at: 2025-06-15", "status": "active", "deleted_by": "", "redmine_entry_id": 9652}]
Updated by Redmine Admin 6 months ago
- Parent task changed from #16323 to #18123
- gitlab project trace changed from Ocean Sprint Planning for 19/05/2025 - 30/05/2025 to Ocean Sprint Planning for 04/06/2025 - 13/06/2025
Updated by Redmine Admin 6 months ago
- Due date changed from 05/30/2025 to 06/13/2025
Updated by Redmine Admin 6 months ago
- % Done changed from 0 to 8
- GitLab Time Logged changed from 0 to 7200
Updated by Redmine Admin 6 months ago
- % Done changed from 8 to 33
- GitLab Time Logged changed from 7200 to 28800
Updated by Redmine Admin 6 months ago
- % Done changed from 33 to 100
- GitLab Time Logged changed from 28800 to 86400
Updated by Redmine Admin 6 months ago
- Parent task changed from #18123 to #18351
- gitlab project trace changed from Ocean Sprint Planning for 04/06/2025 - 13/06/2025 to Ocean Sprint Planning for 16/06/2025 - 27/06/2025
Updated by Redmine Admin 6 months ago
- Due date changed from 06/13/2025 to 06/27/2025
- GitLab Time Logged changed from 86400 to 115200
Updated by Redmine Admin 5 months ago
- Parent task changed from #18351 to #18451
- gitlab project trace changed from Ocean Sprint Planning for 16/06/2025 - 27/06/2025 to Ocean Sprint Planning for 16/06/2025 - 30/06/2025