Project

General

Profile

Actions

Task #18805

open

Task #19122: Sprint Planning for 01/12/2025 - 12/12/2025

House AWB Repository _ Cost & Sales

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

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

0%

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

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}]

Actions #1

Updated by Redmine Admin 2 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 2 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 about 2 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 about 2 months ago

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

Updated by Redmine Admin about 2 months ago

  • GitLab Sync Log updated (diff)
Actions #6

Updated by Redmine Admin about 1 month 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 23 days 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 9 days 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 7 days ago

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

Updated by Redmine Admin 7 days ago

  • GitLab Sync Log updated (diff)
Actions #11

Updated by Redmine Admin 1 day ago

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

Updated by Redmine Admin 1 day ago

  • GitLab Sync Log updated (diff)
Actions #13

Updated by Redmine Admin about 19 hours ago

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

Updated by Redmine Admin about 19 hours ago

  • GitLab Sync Log updated (diff)
Actions

Also available in: Atom PDF