Project

General

Profile

Actions

Task #18805

open

Task #19245: Sprint Planning for 19/01/2026 - 30/01/2026

House AWB Repository _ Cost & Sales

Added by Redmine Admin 5 months ago. Updated about 5 hours ago.

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

0%

Estimated time:
0:00 h
Spent time:
GitLab ID:
3281
GitLab Milestone:
GitLab Ticket Number:
934
GitLab Time Logged:
216000
Lock Timeline Date:
No
gitlab project trace:
Sprint Planning for 19/01/2026 - 30/01/2026

Description

A user should be able to capture additional costs (buying side) and sales (selling side) for each HAWB so that profitability can be tracked and charges are linked correctly to suppliers and customers.

Field rules & validation

  • Charges: Select from charge maintenance list.
  • Type: (COL – Collect, PPD – Prepaid).
  • Currency: Currency Maintenance list.
  • Amount: Decimal > 0.
  • VAT: Dropdown; when selected, VAT Amount auto‑calculated (Amount × rate).
  • Total: Auto‑calculated = Amount + VAT Amount.
  • Exchange Rate: Required if currency ≠ company default currency (MUR); decimal > 0.
  • Supplier: Dropdown from supplier maintenance.
  • Supplier Invoice Ref: Free text.
  • Supplier Invoice Date: Calendar field.
  • Payment Rec.: Boolean checkbox.
  • Lock: Toggle; when locked, entry cannot be edited.
  • Discount (Sales): Decimal ≥ 0; total adjusted accordingly.
  • Disbursement: Checkbox; when true, indicates pass‑through.
  • Bill To: Dropdown from customer/consignee list.

Business rules

  • Exchange rate pulled from maintenance Exchange Rate but user override allowed with audit.

  • Profit auto‑calculated: Sum(Sales totals) – Sum(Cost totals), displayed as snapshot.

  • Locked rows cannot be modified unless unlocked by authorized role.

  • Disbursement flagged charges excluded from profit.

    House AWB Repository 1.xlsx


GitLab Sync Log

[{"id": "32545", "author": "Al-Shad Isaac", "hours": 1.0, "created": "2025-10-23T11:45:37.515Z", "log_date": "2025-10-23", "comment": "Imported from GitLab by @Al-Shad Isaac on 2025-10-23T11:45:37.515Z: 1h-(1.0)h spend at: 2025-10-23", "status": "active", "deleted_by": "", "redmine_entry_id": 10965}, {"id": "34894", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-12-03T11:35:01.517Z", "log_date": "2025-11-30", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-03T11:35:01.517Z: 4h-(4.0)h spend at: 2025-11-30", "status": "active", "deleted_by": "", "redmine_entry_id": 11542}, {"id": "34892", "author": "Ra-ees Peeroo", "hours": 3.0, "created": "2025-12-03T11:33:54.251Z", "log_date": "2025-12-03", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-03T11:33:54.251Z: 3h-(3.0)h spend at: 2025-12-03", "status": "active", "deleted_by": "", "redmine_entry_id": 11543}, {"id": "35079", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2025-12-08T09:43:24.464Z", "log_date": "2025-12-03", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-08T09:43:24.464Z: 4h-(4.0)h spend at: 2025-12-03", "status": "active", "deleted_by": "", "redmine_entry_id": 11590}, {"id": "35077", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-12-08T09:41:23.215Z", "log_date": "2025-12-04", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-08T09:41:23.215Z: 7h-(7.0)h spend at: 2025-12-04", "status": "active", "deleted_by": "", "redmine_entry_id": 11591}, {"id": "35180", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-12-09T06:54:13.452Z", "log_date": "2025-12-07", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-09T06:54:13.452Z: 7h-(7.0)h spend at: 2025-12-07", "status": "active", "deleted_by": "", "redmine_entry_id": 11610}, {"id": "35286", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2025-12-10T05:55:26.196Z", "log_date": "2025-12-08", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2025-12-10T05:55:26.196Z: 7h-(7.0)h spend at: 2025-12-08", "status": "active", "deleted_by": "", "redmine_entry_id": 11637}, {"id": "37402", "author": "Ra-ees Peeroo", "hours": 4.0, "created": "2026-01-20T07:55:28.957Z", "log_date": "2026-01-20", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-01-20T07:55:28.957Z: 4h-(4.0)h spend at: 2026-01-20", "status": "active", "deleted_by": "", "redmine_entry_id": 11997}, {"id": "37562", "author": "Ra-ees Peeroo", "hours": 8.0, "created": "2026-01-23T04:51:27.433Z", "log_date": "2026-01-21", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-01-23T04:51:27.433Z: 1d-(8.0)h spend at: 2026-01-21", "status": "active", "deleted_by": "", "redmine_entry_id": 12038}, {"id": "38577", "author": "Ra-ees Peeroo", "hours": 3.0, "created": "2026-02-11T05:31:14.574Z", "log_date": "2026-02-09", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-02-11T05:31:14.574Z: 3h-(3.0)h spend at: 2026-02-09", "status": "active", "deleted_by": "", "redmine_entry_id": 12243}, {"id": "38697", "author": "Ra-ees Peeroo", "hours": 5.0, "created": "2026-02-12T10:16:57.145Z", "log_date": "2026-02-03", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-02-12T10:16:57.145Z: 5h-(5.0)h spend at: 2026-02-03", "status": "active", "deleted_by": "", "redmine_entry_id": 12284}, {"id": "38696", "author": "Ra-ees Peeroo", "hours": 7.0, "created": "2026-02-12T10:16:46.020Z", "log_date": "2026-02-02", "comment": "Imported from GitLab by @Ra-ees Peeroo on 2026-02-12T10:16:46.020Z: 7h-(7.0)h spend at: 2026-02-02", "status": "active", "deleted_by": "", "redmine_entry_id": 12285}]

Actions #1

Updated by Redmine Admin 5 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 5 months ago

  • Parent task set to #18862
  • gitlab project trace set to Sprint Planning for 06/10/2025 - 17/10/2025
Actions #3

Updated by Redmine Admin 4 months ago

  • Parent task changed from #18862 to #18880
  • gitlab project trace changed from Sprint Planning for 06/10/2025 - 17/10/2025 to Sprint Planning for 20/10/2025 - 31/10/2025
Actions #4

Updated by Redmine Admin 4 months ago

  • GitLab Time Logged changed from 0 to 3600
Actions #5

Updated by Redmine Admin 4 months ago

  • GitLab Sync Log updated (diff)
Actions #6

Updated by Redmine Admin 4 months ago

  • Parent task changed from #18880 to #19002
  • gitlab project trace changed from Sprint Planning for 20/10/2025 - 31/10/2025 to Sprint Planning for 03/11/2025 - 14/11/2025
Actions #7

Updated by Redmine Admin 4 months ago

  • Parent task changed from #19002 to #19100
  • gitlab project trace changed from Sprint Planning for 03/11/2025 - 14/11/2025 to Sprint Planning for 17/11/2025 - 28/11/2025
Actions #8

Updated by Redmine Admin 3 months ago

  • Parent task changed from #19100 to #19122
  • gitlab project trace changed from Sprint Planning for 17/11/2025 - 28/11/2025 to Sprint Planning for 01/12/2025 - 12/12/2025
Actions #9

Updated by Redmine Admin 3 months ago

  • GitLab Time Logged changed from 3600 to 28800
Actions #10

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #11

Updated by Redmine Admin 3 months ago

  • GitLab Time Logged changed from 28800 to 68400
Actions #12

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #13

Updated by Redmine Admin 3 months ago

  • GitLab Time Logged changed from 68400 to 93600
Actions #14

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #15

Updated by Redmine Admin 3 months ago

  • GitLab Time Logged changed from 93600 to 118800
Actions #16

Updated by Redmine Admin 3 months ago

  • GitLab Sync Log updated (diff)
Actions #17

Updated by Redmine Admin about 1 month ago

  • Parent task changed from #19122 to #19245
  • gitlab project trace changed from Sprint Planning for 01/12/2025 - 12/12/2025 to Sprint Planning for 19/01/2026 - 30/01/2026
Actions #18

Updated by Redmine Admin about 1 month ago

  • GitLab Time Logged changed from 118800 to 133200
Actions #19

Updated by Redmine Admin about 1 month ago

  • GitLab Sync Log updated (diff)
Actions #20

Updated by Redmine Admin about 1 month ago

  • GitLab Time Logged changed from 133200 to 162000
Actions #21

Updated by Redmine Admin about 1 month ago

  • GitLab Sync Log updated (diff)
Actions #22

Updated by Redmine Admin 20 days ago

  • GitLab Time Logged changed from 162000 to 172800
Actions #23

Updated by Redmine Admin 20 days ago

  • GitLab Sync Log updated (diff)
Actions #24

Updated by Redmine Admin 19 days ago

  • Status changed from New to Development Done
  • GitLab Time Logged changed from 172800 to 216000
Actions #25

Updated by Redmine Admin 19 days ago

  • GitLab Sync Log updated (diff)
Actions #26

Updated by Redmine Admin 15 days ago

  • Status changed from Development Done to QA
Actions

Also available in: Atom PDF