Ensuring Data Integrity in Retail Systems: Inventory Reconciliation and Audit-Compliant VOID Transaction Mechanisms on Sales Order Management System

Maintaining precise inventory levels and reliable financial records is a critical challenge in retail management software. Traditional systems often rely on row-level deletion or manual adjustments to correct erroneous entries, introducing risks of fraud and data discrepancies. This paper presents an audit-compliant VOID transaction mechanism and automated inventory reconciliation model implemented within a web-based sales order management system. By replacing irreversible deletes with immutable transaction states and inverse inventory operations, the system guarantees full operational auditability while maintaining exact stock balance consistency.