Project

General

Profile

Actions

Task #17556

open

Task #16323: Ocean Sprint Planning for 19/05/2025 - 30/05/2025

Report - Generate Container Manifest Report

Added by Redmine Admin 7 months ago. Updated about 2 hours ago.

Status:
QA
Priority:
High
Assignee:
-
Start date:
03/17/2025
Due date:
05/30/2025 (about 6 months late)
% Done:

54%

Estimated time:
24:00 h
Spent time:
GitLab ID:
2217
GitLab Milestone:
GitLab Ticket Number:
370
GitLab Time Logged:
46800
Lock Timeline Date:
No
gitlab project trace:
Ocean Sprint Planning for 19/05/2025 - 30/05/2025

Description

Acceptance Criteria:

  1. 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
  1. 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)
  2. Freight Charge
    • The report should display freight charges per container and per HBL.
  3. Formatting and readability:
    • Clearly aligned numeric columns for easy readability.
    • Amounts formatted clearly to two decimal points.
  4. Export and Reporting Format
    • The system should allow exporting the report in:
      • PDF Format
      • Excel Format
  5. User Access & Permissions
    • Only authorised users (e.g., Operations Team, Freight Forwarders, and Finance Team) should have access to generate and view the report.
  6. Footer
    • Page numbering (Page X of Y)
    • Printed by <user>
    • Report generation Date & Time
  7. 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.

image.png{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}]

Actions

Also available in: Atom PDF