How to fix stuck / incorrect invoice statuses

Club Admin · Bahasa Melayu below

Rare data drift can leave invoices with the wrong status — e.g. Pending when it's fully paid, or Overdue when it's been waived. AAU Club Manager has a utility to sweep and fix these.

When to use

• Batch of invoices imported from another system and statuses look wrong
• After a bug fix, historical invoices need re-evaluation
• Auto-cron missed a run and overdue status didn't flip

Steps

1. Sidebar → Billing → Utilities → Fix Statuses (/billing/fix-statuses/)
2. Optional filter — narrow to a date range or category
3. Click Preview — AAU Club Manager lists invoices whose current status doesn't match their computed status (based on total, paid, due date)
4. Review the list — verify the changes look right
5. Click Apply Fixes — AAU Club Manager updates each invoice to its correct status

What AAU Club Manager re-computes

• Pending → Paid (if fully paid)
• Pending → Partial (if partially paid)
• Pending → Overdue (if past due date)
• Overdue → Pending (if due date extended)
• Pending → Cancelled (if attached to a soft-deleted trainee)

Doesn't touch

• Manually set Waived / Cancelled invoices
• Draft invoices (never sent)
• Refund records

Backfill receipts

Similar utility for missing receipt numbers: - Billing → Utilities → Backfill Receipts — for paid invoices missing a receipt number, generates receipts retroactively - Use after: importing historical data, or if a receipt-generation bug was fixed

Audit

Every automated status change is logged with the old status → new status and the reason AAU Club Manager applied.

Cara betulkan status invois yang salah

Data drift jarang berlaku tapi kadang invois status tak padan realiti.

Bila guna

• Import invois dari sistem lain
• Selepas fix bug, invois lama perlu re-evaluate
• Auto-cron terlepas run

Langkah

1. Menu sisi → Billing → Utilities → Fix Statuses
2. Filter (optional)
3. Preview — AAU Club Manager senaraikan invois yang status salah
4. Review → Apply Fixes

Yang di-recompute

• Pending → Paid / Partial / Overdue / Cancelled
• Overdue → Pending (jika due date lanjut)

Tak sentuh

Waived / Cancelled / Draft manual.

Backfill resit

Utilities → Backfill Receipts — invois berbayar tanpa no. resit dapat resit backdated.

Audit

Setiap perubahan dilog: status lama → status baru + sebab.