Task #18738: Air_Invoicing - FFA - Redmine

Actions

Copy link

Task #18738

open

Task #19374: Sprint Planning for 02/02/2026 - 16/02/2026

Air_Invoicing

Added by Redmine Admin 6 months ago. Updated about 1 hour ago.

Status:

New

Priority:

Normal

Assignee:

Start date:

09/16/2025

Due date:

09/16/2025 (about 6 months late)

% Done:

70%

Estimated time:

120:00 h

Spent time:

84:30 h

GitLab ID:

3205

GitLab Milestone:

GitLab Ticket Number:

901

GitLab Time Logged:

304200

Lock Timeline Date:

gitlab project trace:

Sprint Planning for 02/02/2026 - 16/02/2026

Description

Invoice Air User Story

Pre-Requisite:

File Reference should already be created and HAWB should at least be in progress.

Acceptance Criteria:

1. When accessing the invoice module, the system should display all the generated invoices and create invoice button. The user should be able to filter the list and retrieve all air invoices.

2. When clicking on the create invoice button, Freight forwarder should be able to select between different shipment channels: Sea, Air, Land. After selecting “Air”, list of HAWB, MAWB and Clearing file should pop up with all the files whose invoices are pending. The list should consist of the below columns:

a. File Reference

b. House Reference

c. Final Destination

d. carrier name

e. Date the file has been created

3. After selecting from the list, the Freight Forwarder should be directed the create invoice page where the following sections and information are displayed:

a. Air Waybill information:

All the below information pertaining to the AWB should be displayed within this section:

ATP
Airline Name
Flight Number
File Reference
MAWB reference
HAWB reference
Number of packages
Volume
Weight
Type of packages
Shipper/Consignee name
Port of loading
Final destination
Port of Discharge
Description

b. invoice charges

In this section the below information should be retrieved from the file reference and displayed:

o Charge Code

o Description

o Currency

o Prepaid/Collect

o Amount excluding VAT

o VAT

o Discount Value

o Exchange Rate

o Total Amount per charge

o Bill to

o Total amount of all charges

The Freight forwarder should be able to process invoice by clicking on the “Process Invoice” button.
When clicking on the button, a “save invoice” pop up should display containing the following:

Choose Currency Dropdown (From maintenance)
Bank Dropdown (From maintenance)
Exchange rate (By default, the exchange rate should display the exchange rate added in file reference charges, but user should still be able to change it if needed.)
Save Button dropdown with options: Draft, Proforma, Standard

c. List of generate invoices for that specific file.

All the invoices saved in Invoice charges section should be displayed in a list. The list should consist of:

o Invoice Reference

o Client name

o Vat Type

o BL type

o Type (Draft/Proforma/standard)

o Due Date

o Status (Active/Cancelled)

o Invoice Currency

o Total Amount in FCY

o Total amount in MUR

o Disbursement

o Action:

Choose button
Download invoice
Send invoice
Preview
Cancel Invoice (Only for Standard Invoice)

When a standard invoice is cancelled, a credit note should be issued, and status should change from active to cancelled.

d. Activity Log

This section should contain the below information:

Activity Date and Time (when the activity was done)
Activity by (Who did the activity)
Activity (What activity has been done)

GitLab Sync Log

[{"id": "30960", "author": "Al-Shad Isaac", "hours": 1.0, "created": "2025-09-25T12:18:15.393Z", "log_date": "2025-09-25", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-09-25T12:18:15.393Z: 1h-(1.0)h spend at: 2025-09-25", "status": "active", "deleted_by": "", "redmine_entry_id": 10411}, {"id": "37405", "author": "Nihaal Ramfoll", "hours": 1.0, "created": "2026-01-20T09:34:10.856Z", "log_date": "2026-01-20", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-01-20T09:34:10.856Z: 1h-(1.0)h spend at: 2026-01-20", "status": "active", "deleted_by": "", "redmine_entry_id": 12003}, {"id": "37672", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2026-01-27T06:10:22.242Z", "log_date": "2026-01-25", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-01-27T06:10:22.242Z: 6h-(6.0)h spend at: 2026-01-25", "status": "active", "deleted_by": "", "redmine_entry_id": 12059}, {"id": "37899", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2026-01-30T05:30:59.716Z", "log_date": "2026-01-28", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-01-30T05:30:59.716Z: 3h-(3.0)h spend at: 2026-01-28", "status": "active", "deleted_by": "", "redmine_entry_id": 12093}, {"id": "37896", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2026-01-30T05:30:21.056Z", "log_date": "2026-01-27", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-01-30T05:30:21.056Z: 6h-(6.0)h spend at: 2026-01-27", "status": "active", "deleted_by": "", "redmine_entry_id": 12094}, {"id": "37895", "author": "Nihaal Ramfoll", "hours": 6.0, "created": "2026-01-30T05:30:12.164Z", "log_date": "2026-01-26", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-01-30T05:30:12.164Z: 6h-(6.0)h spend at: 2026-01-26", "status": "active", "deleted_by": "", "redmine_entry_id": 12095}, {"id": "38072", "author": "Nihaal Ramfoll", "hours": 5.5, "created": "2026-02-03T09:25:56.983Z", "log_date": "2026-02-01", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-03T09:25:56.983Z: 5h 30m-(5.5)h spend at: 2026-02-01", "status": "active", "deleted_by": "", "redmine_entry_id": 12143}, {"id": "38127", "author": "Nihaal Ramfoll", "hours": 120.0, "created": "2026-02-04T06:16:08.573Z", "log_date": "2026-02-04", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-04T06:16:08.573Z: 3w-(120.0)h spend at: 2026-02-04", "status": "deleted", "deleted_by": "38128", "redmine_entry_id": 12149}, {"id": "38240", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-06T05:20:08.604Z", "log_date": "2026-02-03", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-06T05:20:08.604Z: 5h-(5.0)h spend at: 2026-02-03", "status": "active", "deleted_by": "", "redmine_entry_id": 12175}, {"id": "38239", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-06T05:19:58.528Z", "log_date": "2026-02-02", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-06T05:19:58.528Z: 5h-(5.0)h spend at: 2026-02-02", "status": "active", "deleted_by": "", "redmine_entry_id": 12176}, {"id": "38297", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-06T07:16:51.284Z", "log_date": "2026-02-04", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-06T07:16:51.284Z: 5h-(5.0)h spend at: 2026-02-04", "status": "active", "deleted_by": "", "redmine_entry_id": 12189}, {"id": "38370", "author": "Nihaal Ramfoll", "hours": 3.75, "created": "2026-02-06T12:08:47.191Z", "log_date": "2026-02-06", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-06T12:08:47.191Z: 3h 45m-(3.75)h spend at: 2026-02-06", "status": "active", "deleted_by": "", "redmine_entry_id": 12201}, {"id": "38368", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2026-02-06T12:08:05.913Z", "log_date": "2026-02-06", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-06T12:08:05.913Z: 4h-(4.0)h spend at: 2026-02-06", "status": "deleted", "deleted_by": "38369", "redmine_entry_id": 12202}, {"id": "38644", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-11T11:52:15.229Z", "log_date": "2026-02-10", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-11T11:52:15.229Z: 5h-(5.0)h spend at: 2026-02-10", "status": "active", "deleted_by": "", "redmine_entry_id": 12257}, {"id": "38643", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-11T11:52:06.891Z", "log_date": "2026-02-09", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-11T11:52:06.891Z: 5h-(5.0)h spend at: 2026-02-09", "status": "active", "deleted_by": "", "redmine_entry_id": 12258}, {"id": "38642", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-11T11:51:58.578Z", "log_date": "2026-02-08", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-11T11:51:58.578Z: 5h-(5.0)h spend at: 2026-02-08", "status": "deleted", "deleted_by": "", "redmine_entry_id": 12259}, {"id": "38839", "author": "Nihaal Ramfoll", "hours": 4.75, "created": "2026-02-18T05:18:45.035Z", "log_date": "2026-02-08", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-18T05:18:45.035Z: 4h 45m-(4.75)h spend at: 2026-02-08", "status": "active", "deleted_by": "", "redmine_entry_id": 12314}, {"id": "38837", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2026-02-18T05:17:41.454Z", "log_date": "2026-02-12", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-18T05:17:41.454Z: 4h-(4.0)h spend at: 2026-02-12", "status": "active", "deleted_by": "", "redmine_entry_id": 12315}, {"id": "38835", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2026-02-18T05:16:57.715Z", "log_date": "2026-02-18", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-18T05:16:57.715Z: 4h-(4.0)h spend at: 2026-02-18", "status": "deleted", "deleted_by": "38836", "redmine_entry_id": 12316}, {"id": "38833", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-02-18T05:15:44.345Z", "log_date": "2026-02-12", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-18T05:15:44.345Z: 5h-(5.0)h spend at: 2026-02-12", "status": "deleted", "deleted_by": "38834", "redmine_entry_id": 12317}, {"id": "38832", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2026-02-18T05:15:33.615Z", "log_date": "2026-02-11", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-18T05:15:33.615Z: 4h-(4.0)h spend at: 2026-02-11", "status": "active", "deleted_by": "", "redmine_entry_id": 12318}, {"id": "39007", "author": "Nihaal Ramfoll", "hours": 4.5, "created": "2026-02-20T05:22:44.992Z", "log_date": "2026-02-17", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-20T05:22:44.992Z: 4h 30m-(4.5)h spend at: 2026-02-17", "status": "deleted", "deleted_by": "39008", "redmine_entry_id": 12355}, {"id": "39034", "author": "Nihaal Ramfoll", "hours": 3.0, "created": "2026-02-20T07:29:07.566Z", "log_date": "2026-02-18", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-20T07:29:07.566Z: 3h-(3.0)h spend at: 2026-02-18", "status": "active", "deleted_by": "", "redmine_entry_id": 12362}, {"id": "39039", "author": "Nihaal Ramfoll", "hours": 0.75, "created": "2026-02-20T10:05:07.406Z", "log_date": "2026-02-20", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-20T10:05:07.406Z: 45m-(0.75)h spend at: 2026-02-20", "status": "active", "deleted_by": "", "redmine_entry_id": 12368}, {"id": "39126", "author": "Nihaal Ramfoll", "hours": 4.0, "created": "2026-02-23T11:30:38.375Z", "log_date": "2026-02-17", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-23T11:30:38.375Z: 4h-(4.0)h spend at: 2026-02-17", "status": "active", "deleted_by": "", "redmine_entry_id": 12384}, {"id": "39453", "author": "Nihaal Ramfoll", "hours": 1.75, "created": "2026-02-27T09:32:24.254Z", "log_date": "2026-02-27", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-02-27T09:32:24.254Z: 1h 45m-(1.75)h spend at: 2026-02-27", "status": "active", "deleted_by": "", "redmine_entry_id": 12451}, {"id": "39569", "author": "Nihaal Ramfoll", "hours": 5.0, "created": "2026-03-02T11:11:01.408Z", "log_date": "2026-03-02", "comment": "Imported from GitLab by @Nihaal Ramfoll on 2026-03-02T11:11:01.408Z: 5h-(5.0)h spend at: 2026-03-02", "status": "active", "deleted_by": "", "redmine_entry_id": 12466}]