Skip to main content

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โ€‹

FieldDescription
Cancelled Invoice NumberUnique number of the invoice that was cancelled.
Original Invoice DateDate the original invoice was created.
Cancellation DateDate on which the invoice was cancelled.
Customer Name / CodeCustomer linked to the cancelled invoice.
Cancelled By (User)ERP user who performed the cancellation.
Reason for CancellationStated reason (e.g., duplicate, wrong amount, wrong customer, returned order).
Invoice AmountTotal value of the cancelled invoice.
Remarks / NotesAdditional 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 NoInvoice DateCancelled DateCustomerAmountCancelled ByReason
INV-2025-04504-Aug-202506-Aug-2025ABC Tradersโ‚น12,500User-01Duplicate 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.