Task #17556
openTask #16323: Ocean Sprint Planning for 19/05/2025 - 30/05/2025
Report - Generate Container Manifest Report
54%
Description
Acceptance Criteria:¶
-
Report Structure and Fields
The system should generate a Container Manifest Report displaying shipment details.
-
Header Section:
- Company Name and Logo
- Full Company Address & Contact Information
- VAT Reg. Number
- Report Title: Container Manifest
- The report should include the following fields and other fields as listed in the sample report provided.
- Master B/L Number
- Voyage Number
- Consignment Type (LCL/FCL)
- Loading Port & Unloading Port
- Packages, Weight, and Volume
- Container Number
- Shipper, Consignee, and Notify Party
- Job Number, Date, and File Reference
- Marks & Numbers
- Freight Charge per HBL and per Container
-
Filtering and Selection Criteria
- The system should allow users to filter the report based on:
- Date Range (From Date - To Date)
- Voyage Number
- Container Number
- Shipper or Consignee
- Port of Loading / Unloading
- Master or House Bill of Lading (MBL/HBL)
- The system should allow users to filter the report based on:
-
Freight Charge
- The report should display freight charges per container and per HBL.
-
Formatting and readability:
- Clearly aligned numeric columns for easy readability.
- Amounts formatted clearly to two decimal points.
-
Export and Reporting Format
- The system should allow exporting the report in:
- PDF Format
- Excel Format
- The system should allow exporting the report in:
-
User Access & Permissions
- Only authorised users (e.g., Operations Team, Freight Forwarders, and Finance Team) should have access to generate and view the report.
-
Footer
- Page numbering (Page X of Y)
- Printed by <user>
- Report generation Date & Time
-
Error Handling & Notifications
-
If no data is available for the selected date range, display a message:
"No data found for the selected period."
-
If the report fails to generate, log an error and notify the user.
-
{width="656" height="362"}
GitLab Sync Log
[{"id": "24187", "author": "Waliyuddin Delba", "hours": 1.0, "created": "2025-05-30T11:53:26.545Z", "log_date": "2025-05-29", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-05-30T11:53:26.545Z: 1h-(1.0)h spend at: 2025-05-29", "status": "active", "deleted_by": "", "redmine_entry_id": 9359}, {"id": "24235", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-06-02T07:40:22.395Z", "log_date": "2025-06-01", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-06-02T07:40:22.395Z: 3h-(3.0)h spend at: 2025-06-01", "status": "active", "deleted_by": "", "redmine_entry_id": 9380}, {"id": "24265", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-06-02T11:59:10.441Z", "log_date": "2025-06-01", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-06-02T11:59:10.441Z: 3h-(3.0)h spend at: 2025-06-01", "status": "active", "deleted_by": "", "redmine_entry_id": 9390}, {"id": "24305", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-06-03T09:20:39.110Z", "log_date": "2025-06-02", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-06-03T09:20:39.110Z: 3h-(3.0)h spend at: 2025-06-02", "status": "active", "deleted_by": "", "redmine_entry_id": 9400}, {"id": "24334", "author": "Waliyuddin Delba", "hours": 3.0, "created": "2025-06-03T11:47:15.057Z", "log_date": "2025-06-02", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-06-03T11:47:15.057Z: 3h-(3.0)h spend at: 2025-06-02", "status": "active", "deleted_by": "", "redmine_entry_id": 9411}]
Updated by Redmine Admin 6 months ago
- % Done changed from 0 to 4
- GitLab Time Logged changed from 0 to 3600
Updated by Redmine Admin 6 months ago
- % Done changed from 4 to 16
- GitLab Time Logged changed from 3600 to 14400
Updated by Redmine Admin 6 months ago
- % Done changed from 16 to 29
- GitLab Time Logged changed from 14400 to 25200
Updated by Redmine Admin 6 months ago
- % Done changed from 29 to 41
- GitLab Time Logged changed from 25200 to 36000
Updated by Redmine Admin 6 months ago
- % Done changed from 41 to 54
- GitLab Time Logged changed from 36000 to 46800