Currently, when a purchase order (PO) is cancelled, all line quantities automatically revert to 0. This design makes it difficult to track the original intent of the order. It also creates confusion in reporting and auditing, since cancelled orders no longer reflect what was originally requested.

Problem

• Cancelling a PO wipes out line quantities.
• This complicates reconciliation, auditing, and performance analysis.
• It can also cause downstream issues in reporting, where cancelled POs appear as if they never had any quantities.

Proposed Improvement

• Preserve original line quantities when a PO is cancelled.
• Instead of resetting to 0, mark the PO and its lines with a status flag (e.g., Cancelled) while retaining the original quantities.
• Ensure reporting/ forecasting tools can filter by status so 'cancelled' orders and transactions are excluded from active demand but still visible for historical tracking.