Task #18805
openTask #19122: Sprint Planning for 01/12/2025 - 12/12/2025
House AWB Repository _ Cost & Sales
0%
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.
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}]