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}]