Task #18752
openTask #18862: Sprint Planning for 06/10/2025 - 17/10/2025
Pre-Defined Cost/Sales Charge Template
88%
Description
Develop a new functionality to create, search, edit, clone, activate/deactivate templates keyed by Cargo Type + Shipping Line + Container Type (incl. “Bulk”) with Effective From/To and Active flag. Each template contains rows with Charge Code, Description, Charge Type (Prepaid/Collect), UOM (per container / per shipment / per BL), Currency, Default Amount, VAT Type.
a) Cost/Sales Charge Template:¶
- Define per Cargo Type + Shipping Line + Container Type (including “Bulk” in the list).
- Each template has:
- Charge Code + Description (e.g., Terminal Handling Charges, Basic Freight, Doc Fee).
- Charge Type (Prepaid/Collect).
- UOM - Unit of measure (per container / per shipment / per BL).
- Currency
- Default Amount.
- VAT Type
- System must prevent overlapping Effective Date ranges for the same Cargo Type + Shipping Line + Container Type combination.
Example (Template Setup):
Cargo Type: [ Import ▼] Shipping Line: [CMA CGM ▼] Container Type: [20DS - 20ft Dry Standard ▼] Effective Date From: Effective Date To: Active: [ Yes ▼]
[ + Add Charge ]
|
Charge |
Type |
Unit of Measure |
Currency |
Amount |
VAT Type |
|
| Basic Freight | Collect | Per Container ▼ | USD | 500 | Exempt | Edit/Deactivate |
| Terminal Handling Charges | Collect | Per Container ▼ | MUR | 150 | 15% | Edit/Deactivate |
| Delivery Order Fee | Collect | Per Shipment ▼ | MUR | 900 | 15% | Edit/Deactivate |
| Documentation Fee | Prepaid | Per BL ▼ | USD | 30 | Exempt | Edit/Deactivate |
[Save Template]
Acceptance Criteria:
- Ability to define Charge Code, Description, Type (Prepaid/Collect), Unit of Measure, Currency, Default Amount, and VAT Type.
- Effective dates and activation status can be set for each template.
- Admin can add, edit, or deactivate charges within a template.
b) Retrieve Screen¶
Filter / Search / Retrieve Screen¶
-
Inputs / Filters
-
Cargo Type (dropdown; e.g., Import/Export)
-
Shipping Line (typeahead/dropdown)
-
Container Type (dropdown incl. Bulk)
-
Status (Active / Inactive / All)
-
Date filter: “Effective On” (single date that returns templates whose effective range includes that date)
-
Results Grid (paginated + sortable)
- Columns: Cargo Type, Shipping Line, Container Type, Effective From, Effective To, Active
- nested grid displaying all charges related to it
- Row actions: View, Edit, Clone, Deactivate/Activate
Below is a proposed design for the results grid
- Columns: Cargo Type, Shipping Line, Container Type, Effective From, Effective To, Active
{width="415" height="206"}
GitLab Sync Log
[{"id": "30825", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-09-24T06:29:38.069Z", "log_date": "2025-09-22", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-09-24T06:29:38.069Z: 4h-(4.0)h spend at: 2025-09-22", "status": "active", "deleted_by": "", "redmine_entry_id": 10387}, {"id": "30879", "author": "Nihaal Ramfoll", "hours": 2.0, "created": "2025-09-25T04:41:41.221Z", "log_date": "2025-09-23", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-09-25T04:41:41.221Z: 2h-(2.0)h spend at: 2025-09-23", "status": "active", "deleted_by": "", "redmine_entry_id": 10391}, {"id": "31166", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-09-30T09:32:28.051Z", "log_date": "2025-09-25", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-09-30T09:32:28.051Z: 4h-(4.0)h spend at: 2025-09-25", "status": "active", "deleted_by": "", "redmine_entry_id": 10460}, {"id": "31206", "author": "Nihaal Ramfoll", "hours": 2.0, "created": "2025-10-01T09:51:52.896Z", "log_date": "2025-09-29", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-01T09:51:52.896Z: 2h-(2.0)h spend at: 2025-09-29", "status": "active", "deleted_by": "", "redmine_entry_id": 10469}, {"id": "31204", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2025-10-01T09:51:25.580Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-01T09:51:25.580Z: 5h-(5.0)h spend at: 2025-10-01", "status": "deleted", "deleted_by": "", "redmine_entry_id": 10470}, {"id": "31203", "author": "Nihaal Ramfoll", "hours": 2.5, "created": "2025-10-01T09:51:14.127Z", "log_date": "2025-09-29", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-01T09:51:14.127Z: 2h 30m-(2.5)h spend at: 2025-09-29", "status": "deleted", "deleted_by": "31205", "redmine_entry_id": 10471}, {"id": "31313", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2025-10-02T12:01:55.075Z", "log_date": "2025-10-02", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-02T12:01:55.075Z: 3h-(3.0)h spend at: 2025-10-02", "status": "deleted", "deleted_by": "", "redmine_entry_id": 10565}, {"id": "31571", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-10-06T12:08:02.930Z", "log_date": "2025-09-30", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-06T12:08:02.930Z: 6h-(6.0)h spend at: 2025-09-30", "status": "active", "deleted_by": "", "redmine_entry_id": 10643}, {"id": "31568", "author": "Nihaal Ramfoll", "hours": 1.0, "created": "2025-10-06T12:07:47.449Z", "log_date": "2025-09-30", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-06T12:07:47.449Z: 1h-(1.0)h spend at: 2025-09-30", "status": "deleted", "deleted_by": "31570", "redmine_entry_id": 10644}, {"id": "31567", "author": "Nihaal Ramfoll", "hours": 5.5, "created": "2025-10-06T12:07:05.146Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-06T12:07:05.146Z: 5h 30m-(5.5)h spend at: 2025-10-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10645}, {"id": "31564", "author": "Nihaal Ramfoll", "hours": 2.0, "created": "2025-10-06T12:05:58.180Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-06T12:05:58.180Z: 2h-(2.0)h spend at: 2025-10-01", "status": "deleted", "deleted_by": "31565", "redmine_entry_id": 10646}, {"id": "31601", "author": "Nihaal Ramfoll", "hours": 1.75, "created": "2025-10-07T06:21:51.536Z", "log_date": "2025-10-07", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-07T06:21:51.536Z: 1h 45m-(1.75)h spend at: 2025-10-07", "status": "active", "deleted_by": "", "redmine_entry_id": 10657}, {"id": "31847", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2025-10-12T15:24:53.947Z", "log_date": "2025-10-07", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-12T15:24:53.947Z: 4h-(4.0)h spend at: 2025-10-07", "status": "active", "deleted_by": "", "redmine_entry_id": 10722}, {"id": "31846", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-10-12T15:21:47.991Z", "log_date": "2025-10-08", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-12T15:21:47.991Z: 6h-(6.0)h spend at: 2025-10-08", "status": "active", "deleted_by": "", "redmine_entry_id": 10723}, {"id": "31845", "author": "Nihaal Ramfoll", "hours": 2.0, "created": "2025-10-12T15:20:28.367Z", "log_date": "2025-10-09", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-12T15:20:28.367Z: 2h-(2.0)h spend at: 2025-10-09", "status": "active", "deleted_by": "", "redmine_entry_id": 10724}, {"id": "31969", "author": "Nihaal Ramfoll", "hours": 6.5, "created": "2025-10-14T09:58:07.526Z", "log_date": "2025-10-12", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-14T09:58:07.526Z: 6h 30m-(6.5)h spend at: 2025-10-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10787}, {"id": "31967", "author": "Nihaal Ramfoll", "hours": 6.5, "created": "2025-10-14T09:57:50.757Z", "log_date": "2025-10-14", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-14T09:57:50.757Z: 6h 30m-(6.5)h spend at: 2025-10-14", "status": "deleted", "deleted_by": "31968", "redmine_entry_id": 10788}, {"id": "31966", "author": "Nihaal Ramfoll", "hours": 6.5, "created": "2025-10-14T09:57:25.398Z", "log_date": "2025-10-14", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-14T09:57:25.398Z: 6h 30m-(6.5)h spend at: 2025-10-14", "status": "active", "deleted_by": "", "redmine_entry_id": 10789}, {"id": "32207", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-10-16T12:04:17.910Z", "log_date": "2025-10-16", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-16T12:04:17.910Z: 6h-(6.0)h spend at: 2025-10-16", "status": "active", "deleted_by": "", "redmine_entry_id": 10886}, {"id": "32206", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2025-10-16T12:04:01.495Z", "log_date": "2025-10-14", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-16T12:04:01.495Z: 6h-(6.0)h spend at: 2025-10-14", "status": "active", "deleted_by": "", "redmine_entry_id": 10887}, {"id": "32300", "author": "Nihaal Ramfoll", "hours": 3.5, "created": "2025-10-21T11:28:30.293Z", "log_date": "2025-10-21", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-21T11:28:30.293Z: 3h 30m-(3.5)h spend at: 2025-10-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10919}, {"id": "32274", "author": "Nihaal Ramfoll", "hours": 2.5, "created": "2025-10-17T11:39:55.907Z", "log_date": "2025-10-17", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-17T11:39:55.907Z: 2h 30m-(2.5)h spend at: 2025-10-17", "status": "active", "deleted_by": "", "redmine_entry_id": 10920}, {"id": "32405", "author": "Nihaal Ramfoll", "hours": 1.0, "created": "2025-10-22T07:51:41.475Z", "log_date": "2025-10-22", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-22T07:51:41.475Z: 1h-(1.0)h spend at: 2025-10-22", "status": "active", "deleted_by": "", "redmine_entry_id": 10934}, {"id": "32539", "author": "Nihaal Ramfoll", "hours": 1.75, "created": "2025-10-23T11:40:34.409Z", "log_date": "2025-10-23", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2025-10-23T11:40:34.409Z: 1h 45m-(1.75)h spend at: 2025-10-23", "status": "active", "deleted_by": "", "redmine_entry_id": 10966}]