Project

General

Profile

Actions

Task #18703

open

Task #19002: Sprint Planning for 03/11/2025 - 14/11/2025

Air_Supplier Portfolio

Added by Redmine Admin 3 months ago. Updated about 2 hours ago.

Status:
QA
Priority:
Normal
Assignee:
-
Start date:
09/03/2025
Due date:
10/10/2025 (about 2 months late)
% Done:

100%

Estimated time:
80:00 h
Spent time:
GitLab ID:
3169
GitLab Milestone:
GitLab Ticket Number:
882
GitLab Time Logged:
327600
Lock Timeline Date:
No
gitlab project trace:
Sprint Planning for 03/11/2025 - 14/11/2025

Description

What is a Supplier Portfolio?

A Supplier Portfolio is a collection of all the information an organization keeps about its supplier may it be an Airline or a Freight Forwarder.

It consists of a record of all contracted Suppliers or Airlines which includes Air Freight by each Suppliers (Airlines) for per Destination.

 Why a Freight Forwarder uses a Supplier Portfolio?

A freight forwarder uses the Supplier portfolio to compare options and select the most suitable carrier for each shipment (e.g., cheapest, fastest, most reliable).

 What are the Pre-conditions?

The Supplier / Airline basic information should be present in the system to proceed with a Supplier portfolio.

 What are the Acceptance criteria?

The user should be able to:

        I.            Create a Supplier Portfolio for each supplier.

      II.            Modify / Edit the Portfolio

    III.            Saving of the Portfolio

   IV.            Cloning of each Portfolio

     V.            Having an activity log indicating every change and by whom

   VI.            Automatic Deactivation when the Portfolio expires

 VII.            Generation a unique identifier for each Portfolio

VIII.            Having different filtering options

 Contents of the 'Supplier Portfolio' Screen:

  1. Display a list of the supplier portfolio. Columns to be displayed are:
Portfolio Ref

Airline/

Supplier

Type Destination Status Action
MK-DXB-MRU090325/300925 MK Import MRU - Mauritius Active / Inactive Edit / Clone
AF-MRU-CDG090325/300925 AF Export CDG – Charles de Gaulle Active / Inactive Edit / Cone

 

Option to filter by:

        I.            Portfolio Reference

      II.            Airline / Supplier

    III.            Date Range: To be picked from effective date ‘From – To’.

   IV.            Destination

     V.            Status

 

2.      Display a ‘Add Portfolio’ button.

3.      Fields to be displayed when clicking on the ‘Add Portfolio’ button are as follows:

Main Header: SUPPLIER PORTFOLIO

a.      Type: (Import / Export) – (Dropdown)

b.     Supplier – Display list of Airlines and Suppliers of type Freight Forwarder from Maintenance – (Dropdown)

c.      Origin – Display list of all Airports – (Dropdown)

d.     Destination – Display list of all Airports – (Dropdown)

e.      Effective from – Display calendar picker (DDMMYYYY)

f.        Effective to - Display calendar picker (DDMMYYYY)

g.      Status – Active / Inactive (Dropdown)

h.      Remarks – (Free Text)

Subheading: FREIGHT (Rate per Kgs by Minimum Weight)

1.      Display an ‘Add’ button

Display below columns:

a.      Minimum Weight (Kgs) – (Numeric Value including 3 decimal places)

b.     Rate Per Kgs – (Numeric Value including 2 decimal places)

c.      Currency – Display list of currency from maintenance (Dropdown)

d.     Edit option

Subheading 1: Charges

1.      Display an ‘Add’ button

Display below columns:

a.      Description - Display list of all charges – (Dropdown)

b.     Currency – Display list of currencies – (Dropdown)

c.      Amount – Numeric value including 2 decimal places.

d.     VAT – Display list of Vat type – (Dropdown)

e.      Unit of Measure – (Dropdown)

                                I.            Per Shipment

                              II.            Per Kgs

                            III.            Per Volume

                           IV.            Per House

                             V.            Per Master

f.        Edit option

Display a ‘SAVE’ and a ‘CANCEL’ button.

Proposed UI Design:

image.png{width="507" height="503"}


GitLab Sync Log

[{"id": "30203", "author": "Al-Shad Isaac", "hours": 2.0, "created": "2025-09-05T07:25:22.221Z", "log_date": "2025-09-05", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-09-05T07:25:22.221Z: 2h-(2.0)h spend at: 2025-09-05", "status": "active", "deleted_by": "", "redmine_entry_id": 10288}, {"id": "30442", "author": "Al-Shad Isaac", "hours": 2.0, "created": "2025-09-12T11:54:37.245Z", "log_date": "2025-09-12", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-09-12T11:54:37.245Z: 2h-(2.0)h spend at: 2025-09-12", "status": "active", "deleted_by": "", "redmine_entry_id": 10330}, {"id": "30810", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-23T11:07:59.510Z", "log_date": "2025-09-15", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-23T11:07:59.510Z: 1d-(8.0)h spend at: 2025-09-15", "status": "active", "deleted_by": "", "redmine_entry_id": 10382}, {"id": "30809", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-23T11:07:53.283Z", "log_date": "2025-09-21", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-23T11:07:53.283Z: 1d-(8.0)h spend at: 2025-09-21", "status": "active", "deleted_by": "", "redmine_entry_id": 10383}, {"id": "30823", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-24T06:12:12.227Z", "log_date": "2025-09-22", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-24T06:12:12.227Z: 1d-(8.0)h spend at: 2025-09-22", "status": "active", "deleted_by": "", "redmine_entry_id": 10390}, {"id": "31174", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-09-30T09:58:16.873Z", "log_date": "2025-09-30", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-09-30T09:58:16.873Z: 1d-(8.0)h spend at: 2025-09-30", "status": "active", "deleted_by": "", "redmine_entry_id": 10461}, {"id": "31343", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-10-03T07:41:53.568Z", "log_date": "2025-10-03", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-03T07:41:53.568Z: 1d-(8.0)h spend at: 2025-10-03", "status": "active", "deleted_by": "", "redmine_entry_id": 10579}, {"id": "31398", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-10-06T05:47:42.995Z", "log_date": "2025-10-01", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-06T05:47:42.995Z: 1d-(8.0)h spend at: 2025-10-01", "status": "active", "deleted_by": "", "redmine_entry_id": 10593}, {"id": "31396", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2025-10-06T05:47:16.232Z", "log_date": "2025-09-30", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-06T05:47:16.232Z: 1d-(8.0)h spend at: 2025-09-30", "status": "active", "deleted_by": "", "redmine_entry_id": 10594}, {"id": "31476", "author": "Ra-ees Peeroo", "hours": 2.0, "created": "2025-10-06T06:44:29.588Z", "log_date": "2025-10-05", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-06T06:44:29.588Z: 2h-(2.0)h spend at: 2025-10-05", "status": "active", "deleted_by": "", "redmine_entry_id": 10614}, {"id": "31556", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-10-06T11:52:39.724Z", "log_date": "2025-10-06", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-06T11:52:39.724Z: 4h-(4.0)h spend at: 2025-10-06", "status": "active", "deleted_by": "", "redmine_entry_id": 10647}, {"id": "31717", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-09T05:24:43.544Z", "log_date": "2025-10-07", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-09T05:24:43.544Z: 7h-(7.0)h spend at: 2025-10-07", "status": "active", "deleted_by": "", "redmine_entry_id": 10684}, {"id": "31716", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-09T05:24:35.367Z", "log_date": "2025-10-06", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-09T05:24:35.367Z: 7h-(7.0)h spend at: 2025-10-06", "status": "active", "deleted_by": "", "redmine_entry_id": 10685}, {"id": "31785", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-10-10T05:44:57.629Z", "log_date": "2025-10-08", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-10T05:44:57.629Z: 7h-(7.0)h spend at: 2025-10-08", "status": "active", "deleted_by": "", "redmine_entry_id": 10706}, {"id": "33220", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-10-31T10:44:41.216Z", "log_date": "2025-10-30", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-10-31T10:44:41.216Z: 4h-(4.0)h spend at: 2025-10-30", "status": "active", "deleted_by": "", "redmine_entry_id": 11077}]

Actions #1

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 3 months ago

  • Description updated (diff)
  • Due date changed from 09/03/2025 to 09/19/2025
  • % Done changed from 0 to 5
  • Estimated time changed from 0:00 h to 40:00 h
  • Parent task set to #18713
  • GitLab Time Logged changed from 0 to 7200
  • gitlab project trace set to Sprint Planning for 08/09/2025 - 19/09/2025
Actions #3

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #4

Updated by Redmine Admin 3 months ago

  • % Done changed from 5 to 10
  • GitLab Time Logged changed from 7200 to 14400
Actions #5

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #6

Updated by Redmine Admin 3 months ago

  • Parent task changed from #18713 to #18731
  • gitlab project trace changed from Sprint Planning for 08/09/2025 - 19/09/2025 to Sprint Planning for 22/09/2025 - 03/10/2025
Actions #7

Updated by Redmine Admin 3 months ago

  • % Done changed from 10 to 50
  • GitLab Time Logged changed from 14400 to 72000
Actions #8

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #9

Updated by Redmine Admin 3 months ago

  • % Done changed from 50 to 70
  • GitLab Time Logged changed from 72000 to 100800
Actions #10

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #11

Updated by Redmine Admin 2 months ago

  • % Done changed from 70 to 90
  • GitLab Time Logged changed from 100800 to 129600
Actions #12

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #13

Updated by Redmine Admin 2 months ago

  • % Done changed from 90 to 100
  • GitLab Time Logged changed from 129600 to 158400
Actions #14

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #15

Updated by Redmine Admin 2 months ago

  • gitlab project trace changed from Sprint Planning for 22/09/2025 - 03/10/2025 to Sprint Planning for 06/10/2025 - 17/10/2025
  • Due date changed from 09/19/2025 to 10/10/2025
  • Parent task changed from #18731 to #18862
  • GitLab Time Logged changed from 158400 to 216000
Actions #16

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #17

Updated by Redmine Admin 2 months ago

  • GitLab Time Logged changed from 216000 to 223200
Actions #18

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #19

Updated by Redmine Admin 2 months ago

  • % Done changed from 100 to 82
  • Estimated time changed from 40:00 h to 80:00 h
  • GitLab Time Logged changed from 223200 to 237600
Actions #20

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #21

Updated by Redmine Admin 2 months ago

  • % Done changed from 82 to 100
  • GitLab Time Logged changed from 237600 to 288000
Actions #22

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #23

Updated by Redmine Admin 2 months ago

  • Status changed from New to Development Done
  • GitLab Time Logged changed from 288000 to 313200
Actions #24

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #25

Updated by Redmine Admin about 2 months ago

  • Status changed from Development Done to New
Actions #26

Updated by Redmine Admin about 1 month ago

  • Status changed from New to QA
Actions #27

Updated by Redmine Admin about 1 month ago

  • GitLab Time Logged changed from 313200 to 327600
Actions #28

Updated by Redmine Admin about 1 month ago

  • GitLab Sync Log updated (diff)
Actions #29

Updated by Redmine Admin about 1 month ago

  • Parent task changed from #18862 to #19002
  • gitlab project trace changed from Sprint Planning for 06/10/2025 - 17/10/2025 to Sprint Planning for 03/11/2025 - 14/11/2025
Actions

Also available in: Atom PDF