Sales Invoice - Cancelled
๐ Sales Invoice โ Cancelled Reportโ
The Sales Invoice โ Cancelled Report provides a detailed record of all sales invoices that have been cancelled or voided within the ERP system. This report ensures transparency and accountability by tracking cancellations, reasons, and users involved in the process. It is vital for audit trails, internal controls, and reconciliation of sales data.
โ Purpose of the Reportโ
-
To track all cancelled or voided sales invoices.
-
To monitor the frequency and reasons for cancellations.
-
To maintain accurate sales records and prevent revenue overstatements.
-
To support internal audits and reduce misuse or errors in invoicing.
๐ Key Data Fieldsโ
| Field | Description |
|---|---|
| Cancelled Invoice Number | Unique number of the invoice that was cancelled. |
| Original Invoice Date | Date the original invoice was created. |
| Cancellation Date | Date on which the invoice was cancelled. |
| Customer Name / Code | Customer linked to the cancelled invoice. |
| Cancelled By (User) | ERP user who performed the cancellation. |
| Reason for Cancellation | Stated reason (e.g., duplicate, wrong amount, wrong customer, returned order). |
| Invoice Amount | Total value of the cancelled invoice. |
| Remarks / Notes | Additional comments or supporting info. |
๐ Filter Optionsโ
-
Date Range (Cancellation Date or Invoice Date)
-
Customer Name / ID
-
Cancelled By (User or Role)
-
Reason for Cancellation
-
Branch / Location
๐งพ Sample Entryโ
| Invoice No | Invoice Date | Cancelled Date | Customer | Amount | Cancelled By | Reason |
|---|---|---|---|---|---|---|
| INV-2025-045 | 04-Aug-2025 | 06-Aug-2025 | ABC Traders | โน12,500 | User-01 | Duplicate Entry |
๐ Use Casesโ
-
Audit & Compliance: Ensure proper justification for invoice voiding.
-
Finance Team: Reconcile cancelled invoices with revenue.
-
Sales Admin: Prevent misuse of invoice cancellations.
-
Management: Detect patterns of repeated errors or fraud risks.
๐ Benefitsโ
-
Strengthens internal controls and transparency.
-
Prevents revenue misreporting.
-
Improves data quality and system integrity.
-
Supports GST/tax correction documentation, where applicable.
๐ Access Controlโ
-
Typically restricted to Admin, Accountant, and Management roles.
-
Cancel permissions and reason logging should be enforced to avoid misuse.
๐ค Export Optionsโ
- Can be exported as PDF, Excel, or CSV for audit and reporting purposes.