Task #17544
closedTask #16330: Ocean Sprint Planning for 07/04/2025 - 18/04/2025
User Story: Shipment Cost Ocean Import
Description
The freight forwarder should be able to create, update, delete all the costs which has been incurred in the system.
The costs include, Freight Purchase, CFS fee, Transportation cost and others.
Acceptance Criteria:
1. The system should be able to create, update and delete all costs related to a shipment.
2. Availability of different search criteria.
3. Pagination.
4. A master file reference number should be auto generated.
Pre-Requisite:
Vessel schedule should be already created.
Description:
1. When accessing this functionality, the below list of ‘Shipment cost’ should be displayed.
| Master File | Cargo Type | status | Vessel | Voyage number | Container Type | Number of containers | Volume (MC) | Commodity Type | |
| MASTER 001 | Import / Export | Purchased / Provisional | MSC IRIS | 15R | 20ft Dry Standard | 2 | 60 | General Cargo | Update/ Delete button |
Filtering:
System should allow filtering by:
- Master File Reference
- Cargo Type
- Status
- Vessel
- Date Created
2. Display ‘Shipment Cost’ button.
(a) When clicking on the ‘Shipment Cost’ button, a new page should be displayed containing below fields.
· Vessel (To be retrieved from vessel schedule).
· ATP number
· Arrival date
· Voyage Number (Arrival)
· Transaction type (Import or Export)
· Mode of Shipment (Sea, Air or Inland)
· Container Type (From List)
· Number of Container/s
· Volume (MC)
· Weight (Kgs)
· Master File Ref (to be picked from vessel schedule)
· Status (Purchased / Provisional)
System should have a cost section (Per Container type) while creating shipment cost where user will input the below info and data:
Costs:
| Charges | Supplier | Currency | Amount | VAT | VAT Amount | Amount (Inc VAT) | Exchange Rate | Invoice Ref | Inv date | Payment Request |
| Basic Freight | CMA CGM | USD | 1000 | Taxable 0% | 0 | 1000 | 47 | Inv001 | Checkbox | |
| CFS Fee | Logidis | MUR | 2000 | Standard Tax rate | 300 | 2300 | Inv002 | Checkbox | ||
| Terminal Handing Charge | CHCL | USD | 2000 | Taxable 0% | 0 | 2000 | Inv003 | Checkbox | ||
| Transport Fee | ACSL | MUR | 1500 | Standard Tax rate | 225 | 1725 | Inv004 | Checkbox |
(Each row should have an Update and Delete button)
3. Generate Payment Request
After saving, all the selected costs should be displayed in the Payment Request module where the user will generate and send payment request to accounting department.
User access Payment Request Module and select Supplier. All invoice ref related to this supplier for which payment has not been sent should be displayed in a list.
NB: Payment Request should be generated per supplier and per invoice ref.
Upon selecting an invoice ref from the list, the below table should appear.
NB: when clicking on "send payment request" button, If no invoice is present, the system should display a message to inform the user that no invoice has been upload.
For e.g.
|
Invoice Ref: Inv15616 |
Invoice Date: 21/03/2025 |
Upload Invoice PDF etc... |
Send Payment Request Button |
|---|
| Supplier | Charges | Currency | Exchange Rate | Amount | VAT | VAT Amount | Total Amount |
|---|---|---|---|---|---|---|---|
| CMA | Freight | USD | 47 | 1500 | 0 | Taxable 0% | 1500 |
| CMA | Handling | MUR | 1 | 2000 | 300 | Standard 15% | 2300 |
Refer to ticket https://gitlab.maccs.mu/rnd/ffa/documentation/-/issues/381
4. Add a container list – This will be later used on the file reference.
(This functionality has already been implemented on file reference Export where release order is automatically attached to all container with same reference and on same vessel schedule)
Test Scenario:
GitLab Sync Log
[{"id": "32015", "author": "Yashvee Seetul", "hours": 1.0, "created": "2025-10-15T07:24:44.565Z", "log_date": "2025-10-13", "comment": "Imported from GitLab by @Yashvee Seetul on 2025-10-15T07:24:44.565Z: 1h-(1.0)h spend at: 2025-10-13", "status": "active", "deleted_by": "", "redmine_entry_id": 10801}]