Project

General

Profile

Actions

Task #18751

open

Task #19100: Sprint Planning for 17/11/2025 - 28/11/2025

Shipment Cost Improvements as per Pre-defined charges template

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

Status:
QA
Priority:
High
Assignee:
-
Start date:
09/19/2025
Due date:
11/28/2025 (12 days late)
% Done:

100%

Estimated time:
64:00 h
Spent time:
GitLab ID:
3221
GitLab Milestone:
GitLab Ticket Number:
912
GitLab Time Logged:
232200
Lock Timeline Date:
No
gitlab project trace:
Sprint Planning for 17/11/2025 - 28/11/2025

Description

When creating shipment costs, the system must auto-populate charges from Pre-Defined Cost/Sales Charge Templates based on the shipment’s context, including Shipment Type (FCL/LCL), with an option to refresh to the latest template.

a) New field:

  1. Field

    Type Description
    Shipment Type Dropdown (single select) Options: FCL, LCL. Mandatory only if Shipment Cost is enabled in Configuration
  2. Location: After MBL Reference

b) Shipment Cost Creation:

  1. User selects Vessel Schedule → System fetches Shipping Line.

  2. User selects Shipment Type (FCL/LCL) in the header.

  3. User adds Containers (with container type).

  4. System looks up Template Charges that is active & effective for that Cargo Type + Shipping Line + Container Types + Shipment Type + Date within template’s Effective From/To.

  5. System auto-populates Shipment Cost Charges grid with matching pre-defined charges.

    • User can still override amounts if needed.
  6. Refresh Template Charges re-applies steps 4–5 using the any of the following changes: Cargo Type + Shipping Line + Container Types + Shipment Type.

  7. If no Template Charges is found then give a warning to the user informing him that no template cost will be applied. e.g. No active cost/sales charge template found for the selected criteria.

                                                                                                                                             \[ + Add Charges \] \[ Refresh Template Charges \]
    

Charge

Type

Container

Currency

Amount

VAT Type

VAT Amount

Total

Exchange Rate

Basic Freight Collect TJIE5492567 USD 500 Exempt 0 500 47.02  
Terminal Handling Charges Collect TJIE5492567 MUR 150 15% 45 345 1  
Basic Freight Collect MSCU5492567 USD 900 Exempt 0 900 47.02  
Seal Fee Prepaid MSCU5492567 MUR 30 Exempt 0 30 1  
DO Fee Prepaid MSCU5492567 MUR 30 15% 4.5 34.5 1  
MACCS Fee Collect   MUR 325 15% 48.75 373.75 1  

 

Acceptance Criteria:

  • System automatically fetches applicable template charges when containers are added to a shipment.
  • Users can override amounts if needed, but Container cannot be altered.
  • Option to “Refresh Template Charges” so that user can refresh or take latest charges from templates.

GitLab Sync Log

[{"id": "33295", "author": "Nihaal Ramfoll", "hours": 1.0, "created": "2025-11-03T06:20:42.289Z", "log_date": "2025-10-30", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-03T06:20:42.289Z: 1h-(1.0)h spend at: 2025-10-30", "status": "active", "deleted_by": "", "redmine_entry_id": 11100}, {"id": "33292", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-03T06:20:01.220Z", "log_date": "2025-10-29", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-03T06:20:01.220Z: 3h-(3.0)h spend at: 2025-10-29", "status": "active", "deleted_by": "", "redmine_entry_id": 11101}, {"id": "33486", "author": "Nihaal Ramfoll", "hours": 4.5, "created": "2025-11-04T11:04:14.713Z", "log_date": "2025-11-02", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-04T11:04:14.713Z: 4h 30m-(4.5)h spend at: 2025-11-02", "status": "active", "deleted_by": "", "redmine_entry_id": 11121}, {"id": "33692", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-11-10T11:06:14.319Z", "log_date": "2025-11-03", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-10T11:06:14.319Z: 6h-(6.0)h spend at: 2025-11-03", "status": "active", "deleted_by": "", "redmine_entry_id": 11173}, {"id": "33687", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-11-10T10:48:22.984Z", "log_date": "2025-11-02", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-10T10:48:22.984Z: 4h-(4.0)h spend at: 2025-11-02", "status": "active", "deleted_by": "", "redmine_entry_id": 11174}, {"id": "33686", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-11-10T10:46:40.654Z", "log_date": "2025-11-04", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-10T10:46:40.654Z: 6h-(6.0)h spend at: 2025-11-04", "status": "deleted", "deleted_by": "33691", "redmine_entry_id": 11175}, {"id": "33685", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-10T10:46:24.152Z", "log_date": "2025-11-05", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-10T10:46:24.152Z: 3h-(3.0)h spend at: 2025-11-05", "status": "active", "deleted_by": "", "redmine_entry_id": 11176}, {"id": "33679", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2025-11-10T10:34:35.101Z", "log_date": "2025-11-05", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-10T10:34:35.101Z: 5h-(5.0)h spend at: 2025-11-05", "status": "deleted", "deleted_by": "33684", "redmine_entry_id": 11177}, {"id": "33678", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-11-10T10:34:17.297Z", "log_date": "2025-11-06", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-10T10:34:17.297Z: 6h-(6.0)h spend at: 2025-11-06", "status": "active", "deleted_by": "", "redmine_entry_id": 11178}, {"id": "33759", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-12T09:19:32.383Z", "log_date": "2025-11-10", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-12T09:19:32.383Z: 3h-(3.0)h spend at: 2025-11-10", "status": "active", "deleted_by": "", "redmine_entry_id": 11196}, {"id": "33945", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-11-17T05:19:54.524Z", "log_date": "2025-11-11", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-17T05:19:54.524Z: 4h-(4.0)h spend at: 2025-11-11", "status": "active", "deleted_by": "", "redmine_entry_id": 11244}, {"id": "33935", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-11-17T05:12:27.241Z", "log_date": "2025-11-12", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-17T05:12:27.241Z: 6h-(6.0)h spend at: 2025-11-12", "status": "active", "deleted_by": "", "redmine_entry_id": 11245}, {"id": "34122", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-18T10:50:31.019Z", "log_date": "2025-11-16", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-18T10:50:31.019Z: 3h-(3.0)h spend at: 2025-11-16", "status": "active", "deleted_by": "", "redmine_entry_id": 11305}, {"id": "34235", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-20T06:51:21.517Z", "log_date": "2025-11-18", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-20T06:51:21.517Z: 3h-(3.0)h spend at: 2025-11-18", "status": "active", "deleted_by": "", "redmine_entry_id": 11319}, {"id": "34234", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-20T06:51:10.922Z", "log_date": "2025-11-17", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-20T06:51:10.922Z: 3h-(3.0)h spend at: 2025-11-17", "status": "active", "deleted_by": "", "redmine_entry_id": 11320}, {"id": "34373", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-11-25T06:56:07.073Z", "log_date": "2025-11-20", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-25T06:56:07.073Z: 4h-(4.0)h spend at: 2025-11-20", "status": "active", "deleted_by": "", "redmine_entry_id": 11347}, {"id": "34372", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-11-25T06:55:55.510Z", "log_date": "2025-11-19", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-25T06:55:55.510Z: 4h-(4.0)h spend at: 2025-11-19", "status": "active", "deleted_by": "", "redmine_entry_id": 11348}, {"id": "34371", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-11-25T06:55:41.167Z", "log_date": "2025-11-19", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-25T06:55:41.167Z: 3h-(3.0)h spend at: 2025-11-19", "status": "active", "deleted_by": "", "redmine_entry_id": 11349}, {"id": "34662", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-11-28T06:20:36.228Z", "log_date": "2025-11-24", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-11-28T06:20:36.228Z: 4h-(4.0)h spend at: 2025-11-24", "status": "active", "deleted_by": "", "redmine_entry_id": 11458}]

Actions #1

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 3 months ago

  • Description updated (diff)
Actions #3

Updated by Redmine Admin 3 months ago

  • Due date changed from 09/19/2025 to 10/03/2025
Actions #4

Updated by Redmine Admin 3 months ago

  • Estimated time changed from 0:00 h to 64:00 h
Actions #5

Updated by Redmine Admin 2 months ago

  • Due date changed from 10/03/2025 to 10/17/2025
Actions #6

Updated by Redmine Admin about 2 months ago

  • Description updated (diff)
Actions #7

Updated by Redmine Admin about 2 months ago

  • Description updated (diff)
Actions #8

Updated by Redmine Admin about 2 months ago

  • Parent task changed from #18731 to #18880
  • gitlab project trace changed from Sprint Planning for 22/09/2025 - 03/10/2025 to Sprint Planning for 20/10/2025 - 31/10/2025
Actions #9

Updated by Redmine Admin about 2 months ago

  • Description updated (diff)
  • Due date changed from 10/17/2025 to 10/31/2025
Actions #10

Updated by Redmine Admin about 1 month ago

  • Due date changed from 10/31/2025 to 11/14/2025
  • % Done changed from 0 to 6
  • Parent task changed from #18880 to #19002
  • GitLab Time Logged changed from 0 to 14400
  • gitlab project trace changed from Sprint Planning for 20/10/2025 - 31/10/2025 to Sprint Planning for 03/11/2025 - 14/11/2025
Actions #11

Updated by Redmine Admin about 1 month ago

  • GitLab Sync Log updated (diff)
Actions #12

Updated by Redmine Admin about 1 month ago

  • % Done changed from 6 to 13
  • GitLab Time Logged changed from 14400 to 30600
Actions #13

Updated by Redmine Admin about 1 month ago

  • GitLab Sync Log updated (diff)
Actions #14

Updated by Redmine Admin 30 days ago

  • % Done changed from 13 to 42
  • GitLab Time Logged changed from 30600 to 99000
Actions #15

Updated by Redmine Admin 30 days ago

  • GitLab Sync Log updated (diff)
Actions #16

Updated by Redmine Admin 28 days ago

  • GitLab Sync Log updated (diff)
Actions #17

Updated by Redmine Admin 28 days ago

  • % Done changed from 42 to 47
  • GitLab Time Logged changed from 99000 to 109800
Actions #18

Updated by Redmine Admin 23 days ago

  • % Done changed from 47 to 63
  • GitLab Time Logged changed from 109800 to 145800
Actions #19

Updated by Redmine Admin 23 days ago

  • GitLab Sync Log updated (diff)
Actions #20

Updated by Redmine Admin 23 days ago

  • Due date changed from 11/14/2025 to 11/28/2025
  • Parent task changed from #19002 to #19100
  • gitlab project trace changed from Sprint Planning for 03/11/2025 - 14/11/2025 to Sprint Planning for 17/11/2025 - 28/11/2025
Actions #21

Updated by Redmine Admin 22 days ago

  • % Done changed from 63 to 67
  • GitLab Time Logged changed from 145800 to 156600
Actions #22

Updated by Redmine Admin 22 days ago

  • GitLab Sync Log updated (diff)
Actions #23

Updated by Redmine Admin 20 days ago

  • % Done changed from 67 to 77
  • GitLab Time Logged changed from 156600 to 178200
Actions #24

Updated by Redmine Admin 20 days ago

  • GitLab Sync Log updated (diff)
Actions #25

Updated by Redmine Admin 15 days ago

  • Status changed from New to Development Done
  • % Done changed from 77 to 94
  • GitLab Time Logged changed from 178200 to 217800
Actions #26

Updated by Redmine Admin 15 days ago

  • GitLab Sync Log updated (diff)
Actions #27

Updated by Redmine Admin 12 days ago

  • % Done changed from 94 to 100
  • GitLab Time Logged changed from 217800 to 232200
Actions #28

Updated by Redmine Admin 12 days ago

  • GitLab Sync Log updated (diff)
Actions #29

Updated by Redmine Admin 9 days ago

  • Status changed from Development Done to New
Actions #30

Updated by Redmine Admin 7 days ago

  • Status changed from New to QA
Actions

Also available in: Atom PDF