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 #1

Updated by Redmine Admin 4 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 3 months ago

  • Description updated (diff)
  • Due date changed from 08/06/2025 to 09/05/2025
  • Status changed from New to Development Done
  • % Done changed from 0 to 100
  • Estimated time changed from 0:00 h to 32:00 h
  • Parent task set to #18634
  • GitLab Time Logged changed from 0 to 115200
  • gitlab project trace set to Sprint Planning for 25/08/2025 - 05/09/2025
Actions #3

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #4

Updated by Redmine Admin 3 months ago

  • Status changed from Development Done to QA
Actions

Also available in: Atom PDF