Task #18576
openTask #19100: Sprint Planning for 17/11/2025 - 28/11/2025
Air Import Shipment Cost
100%
Description
What is the Air Shipment cost?
Air shipment cost is the total expense incurred to transport goods by air from the origin (exporter’s location/airport) to the destination (importer’s location/airport). It is not just the airline freight charge, but a combination of:
1. Air Freight Charges
- The main cost paid to the Airline/Freight Forwarder for carrying the goods.
- Calculated on the chargeable weight, whichever highest between purchased / gross weight and Total volumetric weight:
(a) Purchased / Gross weight = actual weight of cargo.
(b) Volumetric weight = space cargo occupies, based on following formula:
(L × W × H) ÷ 6000. To be calculated in cm.
2. Origin Charges
- Handling fees (airline handling, terminal charges).
- Documentation fees (Air Waybill preparation, customs export declaration).
- Pick-up or trucking charges.
3. Local Charges
- Delivery order fee (charged by airline/forwarder).
- Handling and storage fees at the airport terminal.
Why a freight forwarder uses Air shipment cost??
A freight forwarder uses ‘Air shipment cost’ because it is the basis for pricing, planning, and managing the movement of goods by air on behalf of their clients.
For example:
Quoting to Customers
- The forwarder must prepare quotations for shippers (exporters/importers).
- The air shipment cost allows them to calculate the total landed cost (freight + origin charges + local charges).
Profit Margin Calculation
- Forwarders usually add a service fee or margin on top of the base air shipment cost.
- Without knowing the cost structure, they cannot price competitively or profitably.
What are the Pre-conditions?
The Supplier / Airline basic information should be present in the system to proceed with the ‘Air Shipment cost’.
What are the Acceptance criteria?
The user should be able to:
I. Create the Air Shipment cost.
II. Modify / Edit the Air Shipment cost.
III. Saving of the Air Shipment cost.
IV. Having an activity log indicating every change and by whom.
V. Generation of a unique identifier for each Air shipment cost.
VI. Having different filtering option.
VII. Automatic calculation of the Air Freight charges
VIII. Cloning of the Air shipment cost
Contents of the ‘Air Shipment cost’ Screen:
- Display a list of Air Shipment cost. Columns to be displayed are:
| Shipment Ref | Create date | Supplier | MAWB Ref | Shipment Channel | Status |
| MACCS25SCAI090001 | 09/09/2025 11:00 | Air Mauritius | 239-24521070 | Import | Final |
Option to filter by:
I. Shipment Reference
II. Date Range
III. Supplier
IV. MAWB number
V. Shipment channel
VI. Status
2. Display an ‘ADD Air Shipment cost’ button.
3. Fields to be displayed when clicking on the ‘Add Portfolio’ button are as follows:
Main Header: AIR SHIPMENT COST
a. Shipment Reference – Auto generated
b. Shipment channel – Import / Export (Dropdown)
c. Freight Type: Collect / Prepaid (Dropdown) – See related conditions (1)
d. Status – Provisional / Final (Dropdown)
e. Agent – Dropdown of all Suppliers of type Freight forwarders (Dropdown) – See related conditions (2)
f. Airline – Display List of Airlines (Dropdown) – Relates to condition (2)
g. Origin – Display list of Airport (Dropdown)
h. Destination – Display list of Airport (Dropdown)
i. Chargeable weight (Kgs) – Non editable field
j. Purchased weight (Kgs) – Numeric value including 3 decimal places
k. Airway Bill Reference
Dimension (Volumetric Weight) – Display below column
a. Length (cm)
b. Width (cm)
c. Height (cm)
d. Volumetric weight (Kgs) – To be calculated automatically based on the formula: (LxWxH) ÷ 6000
e. Display an ADD button
f. Display an Edit button for each row
g. Display a Total of the Volumetric weight
HEADER 1: Air Freight Charges
Display below columns:
a. Charge type – List of charges (Dropdown)
b. Unit of measure – (Dropdown list – Per MBL, Per HBL etc.)
c. Chargeable weight – (pick the highest value – Between Purchased weight and Volumetric weight) – Read only field
d. Price / kgs – Numeric value including 2 decimal places (Value to be picked from the supplier portfolio.
e. Currency – List of currency from Maintenance (Dropdown)
f. VAT Type – List of Vat from maintenance (Dropdown)
g. VAT Amount – Calculate the VAT amount based on the vat type – Non editable field.
h. Display an ADD button
i. Display an Edit button for each row.
HEADER 2: Origin Charges
Display below columns:
a. Charge type – List of charges (Dropdown)
b. Unit of measure – (Dropdown list– Per MBL, Per HBL etc.)
c. Quantity – (Numeric Value)
d. Price / kgs – Numeric value including 2 decimal places
e. Currency – List of currency from Maintenance (Dropdown)
f. VAT Type – List of Vat from maintenance (Dropdown)
g. VAT Amount – Calculate the VAT amount based on the vat type – Non editable field.
h. Display an ADD button
i. Display an Edit button for each row.
HEADER 3: Local Charges
Display below columns:
a. Charge type – List of charges (Dropdown)
b. Unit of measure – (Dropdown list– Per MBL, Per HBL etc.)
c. Quantity – (Numeric Value)
d. Price / kgs – Numeric value including 2 decimal places
e. Currency – List of currency from Maintenance (Dropdown)
f. VAT Type – List of Vat from maintenance (Dropdown)
g. VAT Amount – Calculate the VAT amount based on the vat type – Non editable field.
h. Display an ADD button
i. Display an Edit button for each row.
HEADER 4: Summary
Display below columns:
a. Category – List of (i) Air Freight charges (ii) Origin charges (iii) Local charges
b. Amount – Numeric Value including 2 decimal places
c. Currency – Display list of currency from maintenance.
Conditions:
1. If ‘Prepaid’ is selected, the Air Freight section needs to be disabled.
2. If an ‘Agent’ is selected, take ‘rate’ from the portfolio for the selected agent NOT for the Airline
Else If no Agent is present, then take the ‘rate’ of the selected Airline from the portfolio.
Proposed Template:
{width=646 height=546}
GitLab Sync Log
[{"id": "30441", "author": "Al-Shad Isaac", "hours": 2.0, "created": "2025-09-12T11:54:20.923Z", "log_date": "2025-09-12", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-09-12T11:54:20.923Z: 2h-(2.0)h spend at: 2025-09-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10331}, {"id": "30488", "author": "Al-Shad Isaac", "hours": 4.0, "created": "2025-09-16T05:33:17.042Z", "log_date": "2025-09-14", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-09-16T05:33:17.042Z: 4h-(4.0)h spend at: 2025-09-14", "status": "active", "deleted_by": "", "redmine_entry_id": 10340}, {"id": "30695", "author": "Fatimah Schaik Hossen", "hours": 5.0, "created": "2025-09-23T05:47:34.121Z", "log_date": "2025-09-21", "comment": "Imported from GitLab by @Fatimah Schaik Hossen on 2025-09-23T05:47:34.121Z: 5h-(5.0)h spend at: 2025-09-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10370}, {"id": "30803", "author": "Fatimah Schaik Hossen", "hours": 5.0, "created": "2025-09-23T10:54:41.494Z", "log_date": "2025-09-23", "comment": "Imported from GitLab by @Fatimah Schaik Hossen on 2025-09-23T10:54:41.494Z: 5h-(5.0)h spend at: 2025-09-23", "status": "active", "deleted_by": "", "redmine_entry_id": 10384}, {"id": "30972", "author": "Fatimah Schaik Hossen", "hours": 6.0, "created": "2025-09-26T05:08:38.751Z", "log_date": "2025-09-24", "comment": "Imported from GitLab by @Fatimah Schaik Hossen on 2025-09-26T05:08:38.751Z: 6h-(6.0)h spend at: 2025-09-24", "status": "active", "deleted_by": "", "redmine_entry_id": 10419}, {"id": "31325", "author": "Fatimah Schaik Hossen", "hours": 4.0, "created": "2025-10-03T06:05:26.182Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Fatimah Schaik Hossen on 2025-10-03T06:05:26.182Z: 4h-(4.0)h spend at: 2025-10-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10576}, {"id": "31352", "author": "Fatimah Schaik Hossen", "hours": 2.0, "created": "2025-10-03T09:20:27.409Z", "log_date": "2025-10-03", "comment": "Imported from GitLab by @Fatimah Schaik Hossen on 2025-10-03T09:20:27.409Z: 2h-(2.0)h spend at: 2025-10-03", "status": "active", "deleted_by": "", "redmine_entry_id": 10590}, {"id": "31772", "author": "Fatimah Schaik Hossen", "hours": 1.0, "created": "2025-10-09T10:57:29.309Z", "log_date": "2025-10-09", "comment": "Imported from GitLab by @Fatimah Schaik Hossen on 2025-10-09T10:57:29.309Z: 1h-(1.0)h spend at: 2025-10-09", "status": "active", "deleted_by": "", "redmine_entry_id": 10704}, {"id": "31836", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-10T11:23:40.748Z", "log_date": "2025-10-10", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-10T11:23:40.748Z: 7h-(7.0)h spend at: 2025-10-10", "status": "active", "deleted_by": "", "redmine_entry_id": 10716}, {"id": "31884", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-14T05:24:34.658Z", "log_date": "2025-10-14", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-14T05:24:34.658Z: 7h-(7.0)h spend at: 2025-10-14", "status": "active", "deleted_by": "", "redmine_entry_id": 10736}, {"id": "31978", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-15T04:37:56.702Z", "log_date": "2025-10-12", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-15T04:37:56.702Z: 7h-(7.0)h spend at: 2025-10-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10792}, {"id": "32046", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-16T05:13:08.026Z", "log_date": "2025-10-14", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-16T05:13:08.026Z: 7h-(7.0)h spend at: 2025-10-14", "status": "active", "deleted_by": "", "redmine_entry_id": 10817}, {"id": "32238", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-17T06:54:03.010Z", "log_date": "2025-10-15", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-17T06:54:03.010Z: 7h-(7.0)h spend at: 2025-10-15", "status": "active", "deleted_by": "", "redmine_entry_id": 10897}, {"id": "32327", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-22T05:39:30.208Z", "log_date": "2025-10-20", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-22T05:39:30.208Z: 7h-(7.0)h spend at: 2025-10-20", "status": "active", "deleted_by": "", "redmine_entry_id": 10927}, {"id": "32490", "author": "Ra-ees Peeroo", "hours": 6.0, "created": "2025-10-23T05:57:01.221Z", "log_date": "2025-10-21", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-23T05:57:01.221Z: 6h-(6.0)h spend at: 2025-10-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10951}, {"id": "32538", "author": "Ra-ees Peeroo", "hours": 5.25, "created": "2025-10-23T11:40:27.599Z", "log_date": "2025-10-23", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-23T11:40:27.599Z: 5h 15m-(5.25)h spend at: 2025-10-23", "status": "active", "deleted_by": "", "redmine_entry_id": 10967}, {"id": "33103", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-29T10:38:42.384Z", "log_date": "2025-10-26", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-29T10:38:42.384Z: 7h-(7.0)h spend at: 2025-10-26", "status": "active", "deleted_by": "", "redmine_entry_id": 11037}, {"id": "33102", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-29T10:38:26.968Z", "log_date": "2025-10-27", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-29T10:38:26.968Z: 7h-(7.0)h spend at: 2025-10-27", "status": "active", "deleted_by": "", "redmine_entry_id": 11038}, {"id": "33223", "author": "Ra-ees Peeroo", "hours": 5.0, "created": "2025-10-31T10:45:16.337Z", "log_date": "2025-10-28", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-31T10:45:16.337Z: 5h-(5.0)h spend at: 2025-10-28", "status": "active", "deleted_by": "", "redmine_entry_id": 11078}, {"id": "33222", "author": "Ra-ees Peeroo", "hours": 3.0, "created": "2025-10-31T10:44:59.155Z", "log_date": "2025-10-31", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-31T10:44:59.155Z: 3h-(3.0)h spend at: 2025-10-31", "status": "active", "deleted_by": "", "redmine_entry_id": 11079}, {"id": "33219", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-31T10:44:01.373Z", "log_date": "2025-10-30", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-31T10:44:01.373Z: 7h-(7.0)h spend at: 2025-10-30", "status": "deleted", "deleted_by": "33221", "redmine_entry_id": 11080}, {"id": "33218", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-31T10:43:51.739Z", "log_date": "2025-10-29", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-31T10:43:51.739Z: 7h-(7.0)h spend at: 2025-10-29", "status": "active", "deleted_by": "", "redmine_entry_id": 11081}, {"id": "33465", "author": "Ra-ees Peeroo", "hours": 5.0, "created": "2025-11-04T05:10:40.278Z", "log_date": "2025-11-02", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-04T05:10:40.278Z: 5h-(5.0)h spend at: 2025-11-02", "status": "active", "deleted_by": "", "redmine_entry_id": 11108}, {"id": "33497", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-05T06:24:34.504Z", "log_date": "2025-11-03", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-05T06:24:34.504Z: 7h-(7.0)h spend at: 2025-11-03", "status": "active", "deleted_by": "", "redmine_entry_id": 11125}, {"id": "33749", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-12T05:32:03.380Z", "log_date": "2025-11-10", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-12T05:32:03.380Z: 7h-(7.0)h spend at: 2025-11-10", "status": "active", "deleted_by": "", "redmine_entry_id": 11194}, {"id": "33820", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-14T04:50:43.653Z", "log_date": "2025-11-12", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-14T04:50:43.653Z: 7h-(7.0)h spend at: 2025-11-12", "status": "active", "deleted_by": "", "redmine_entry_id": 11223}, {"id": "33819", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-11-14T04:50:36.918Z", "log_date": "2025-11-11", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-14T04:50:36.918Z: 4h-(4.0)h spend at: 2025-11-11", "status": "active", "deleted_by": "", "redmine_entry_id": 11224}, {"id": "34066", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-11-17T11:37:55.426Z", "log_date": "2025-11-17", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-17T11:37:55.426Z: 4h-(4.0)h spend at: 2025-11-17", "status": "active", "deleted_by": "", "redmine_entry_id": 11280}, {"id": "34236", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-20T06:54:04.354Z", "log_date": "2025-11-18", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-20T06:54:04.354Z: 7h-(7.0)h spend at: 2025-11-18", "status": "active", "deleted_by": "", "redmine_entry_id": 11321}, {"id": "34387", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-25T11:33:03.712Z", "log_date": "2025-11-19", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-25T11:33:03.712Z: 7h-(7.0)h spend at: 2025-11-19", "status": "active", "deleted_by": "", "redmine_entry_id": 11354}, {"id": "34386", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-25T11:32:22.439Z", "log_date": "2025-11-20", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-25T11:32:22.439Z: 7h-(7.0)h spend at: 2025-11-20", "status": "active", "deleted_by": "", "redmine_entry_id": 11355}, {"id": "34385", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-25T11:32:15.779Z", "log_date": "2025-11-23", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-25T11:32:15.779Z: 7h-(7.0)h spend at: 2025-11-23", "status": "active", "deleted_by": "", "redmine_entry_id": 11356}, {"id": "34384", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-11-25T11:31:51.824Z", "log_date": "2025-11-25", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-25T11:31:51.824Z: 7h-(7.0)h spend at: 2025-11-25", "status": "active", "deleted_by": "", "redmine_entry_id": 11357}, {"id": "34537", "author": "Ra-ees Peeroo", "hours": 3.0, "created": "2025-11-27T06:52:32.130Z", "log_date": "2025-11-25", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-11-27T06:52:32.130Z: 3h-(3.0)h spend at: 2025-11-25", "status": "active", "deleted_by": "", "redmine_entry_id": 11453}, {"id": "34687", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-12-01T05:48:18.377Z", "log_date": "2025-11-26", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-01T05:48:18.377Z: 4h-(4.0)h spend at: 2025-11-26", "status": "active", "deleted_by": "", "redmine_entry_id": 11471}]