Project

General

Profile

Actions

Task #18596

open

Task #18634: Sprint Planning for 25/08/2025 - 05/09/2025

Generate Delivery Consignee Sheet After Delivery Order Release

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

Status:
QA
Priority:
Normal
Assignee:
-
Start date:
08/06/2025
Due date:
09/05/2025 (about 3 months late)
% Done:

100%

Estimated time:
32:00 h
Spent time:
GitLab ID:
3061
GitLab Milestone:
GitLab Ticket Number:
814
GitLab Time Logged:
115200
Lock Timeline Date:
No
gitlab project trace:
Sprint Planning for 25/08/2025 - 05/09/2025

Description

The users should be able to generate and download a "Delivery Consignee Sheet" report per File Reference, once a valid Manual or Transmission Delivery Order (DO) has been issued and approved via the "Delivery Order" module.

Workflow Summary

  1. Whether a DO has been issued or not in the "Delivery Order" module, the HBL records should still be displayed in the "Delivery Consignee Sheet" report.

  2. Users can download the "Delivery Consignee Sheet" from the File Reference screen, in the File Reference row under the "Download PDF" button group.

  3. A new option must be added to the button group: "Download Delivery Consignee Sheet"

    image.png{width="959" height="104"}

  4. The generated report includes all HBLs under the selected File Reference and is:

    • grouped per Container Ref
    • Paginated so that each container with its corresponding HBLs appears on a separate page
  • An example of the report is attached. DELIVERY CONSIGNEE SHEET.pdf
  • Please note that the Remarks field includes information about the "Release Type" derived from the HBL details found in the File Reference screen.
  • Add a title to the report: "Delivery Consignee Sheet"

DO Release Logic

  • When a Manual or Transmission DO has been issued and approved, the corresponding HBL(s) will contain the DO Date, DO Reference and Customs Broker info.
  • If only a Temporary DO has been issued:
    • These HBL records will still appear in the Delivery Consignee Sheet, with blank information for the DO Date, DO Reference, and Customs Broker.

Permissions

  • Only users with the required authority should see and be able to use the "Download Delivery Consignee Sheet" option.

Note that in the case of FCL, remove the container Ref from the header and add a new column beside the House Bill Number as shown below.

image.png{width=647 height=141}


GitLab Sync Log

[{"id": "28759", "author": "Vishesh Jodhoa", "hours": 8.0, "created": "2025-08-26T07:27:14.127Z", "log_date": "2025-08-26", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2025-08-26T07:27:14.127Z: 1d-(8.0)h spend at: 2025-08-26", "status": "active", "deleted_by": "", "redmine_entry_id": 10190}, {"id": "28432", "author": "Vishesh Jodhoa", "hours": 8.0, "created": "2025-08-18T11:43:06.136Z", "log_date": "2025-08-18", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2025-08-18T11:43:06.136Z: 1d-(8.0)h spend at: 2025-08-18", "status": "active", "deleted_by": "", "redmine_entry_id": 10191}, {"id": "28286", "author": "Vishesh Jodhoa", "hours": 8.0, "created": "2025-08-14T12:06:11.240Z", "log_date": "2025-08-12", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2025-08-14T12:06:11.240Z: 1d-(8.0)h spend at: 2025-08-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10192}, {"id": "28285", "author": "Vishesh Jodhoa", "hours": 8.0, "created": "2025-08-14T12:06:01.083Z", "log_date": "2025-08-11", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2025-08-14T12:06:01.083Z: 1d-(8.0)h spend at: 2025-08-11", "status": "active", "deleted_by": "", "redmine_entry_id": 10193}]

Actions

Also available in: Atom PDF