Task #19630
openTask #19655: Sprint Planning for 09/04/2026 to 23/04/2026
Quotation - Charges order is not preserved after save/retrieve/update in quotation
100%
Description
Tenant: MACCS
Environment: Qualif v 1.1.7_20260331075625
Issue: UI/UX Improvement
{width="778" height="194"}
{width="767" height="167"}
{width="768" height="163"}
Description
The order in which charges are entered in the Charges grid is not preserved. Each time the quotation is retrieved or updated, the system reorders the charges unpredictably.
The users using the ocean module have reported this in the ocean module. The order in which the charges are entered should be displayed in the same order everywhere in any screen or document. e.g., They always put freight as the 1st charge, and the clients also are familiar with this.
This creates inconsistency between:
- User-entered charge sequence
- Displayed sequence in UI
- Expected sequence in generated documents (Quotation/Invoice PDFs)
Preconditions
- User creates a quotation
- Adds multiple charges in a specific order or select from portfolio or Refresh Charges(any of these steps)
Steps to Reproduce
- Go to Charges section
- Add charges in a defined order (e.g.):
- Freight
- Documentation Fee
- Handling Fee
- Save / Update the quotation
- Retrieve the quotation OR click Update again
- Observe order of charges
Actual Result
- Charges order changes after save/retrieve/update
- The order is inconsistent across different loads as per given screenshots above
- No predictable sorting logic
Expected Result
- Charges should be displayed in the exact order they were entered by the user
- The same order should be maintained:
- In UI grid
- In generated documents (Quotation, Invoice, Reports, etc.)
Business Requirement
- Freight forwarders follow standard charge sequencing, e.g.:
- Freight (always first)
- Origin charges
- Destination charges
- This sequence is important for:
- Customer readability
- Industry standards
- Internal validation
Suggested Fix
- Introduce a Sequence / Sort Order field (stored in DB)
- Maintain insertion order
Additional Enhancements:
- Ensure the same order is used in:
- PDF generation
- Reports
- Invoice, etc.
- Ensure that everywhere we have the "Charges" grid, the ordering is applied.
GitLab Sync Log
[{"id": "42053", "author": "Gilles Mahomudally", "hours": 4.0, "created": "2026-04-13T05:44:31.545Z", "log_date": "2026-04-12", "comment": "Imported from GitLab by @Gilles Mahomudally on 2026-04-13T05:44:31.545Z: 4h-(4.0)h spend at: 2026-04-12", "status": "active", "deleted_by": "", "redmine_entry_id": 13048}, {"id": "42904", "author": "Gilles Mahomudally", "hours": 3.0, "created": "2026-04-23T07:40:09.417Z", "log_date": "2026-04-19", "comment": "Imported from GitLab by @Gilles Mahomudally on 2026-04-23T07:40:09.417Z: 3h-(3.0)h spend at: 2026-04-19", "status": "active", "deleted_by": "", "redmine_entry_id": 13267}]
Updated by Redmine Admin 5 months ago
- Estimated time changed from 0:00 h to 4:00 h
- Parent task set to #19655
- gitlab project trace set to Sprint Planning for 09/04/2026 to 23/04/2026
Updated by Redmine Admin 5 months ago
- % Done changed from 0 to 100
- GitLab Time Logged changed from 0 to 14400
Updated by Redmine Admin 4 months ago
- Status changed from New to Development Done
- GitLab Time Logged changed from 14400 to 25200
Updated by Redmine Admin 4 months ago
- Status changed from Development Done to New