Reversing a receipt when QOH is insufficient

There is a scenario where a purchase receipt reversal is prohibited by the workflow as it would cause a negative product quantity on hand i.e. insufficient QOH. This could have resulted by the intervened sale shipments between the product purchase receipt and the attempted reversal. The problematic scenario and corrective actions are outlined below

Scenario Event Sequence	Day 2	Explanation
Receive Purchase Receipt#1		Successfully received
Post Sale Shipment		Successfully posted
Reverse Purchase Receipt#1		Unsuccessful due to insufficient product QOH
Corrective Action Sequence	Day 2	Note
Create Stock Quantity Adjustment#1		To increase the stock quantity sufficiently to enable successful execution of the pending receipt reversal e.g. if the purchase receipt reversal would cause the QOH to be -5 then the stock adjustment QTY must be 5 (or more) Ensure the transaction date is backdate to Day 1
Reverse Purchase Receipt#1		Ensure the transaction date is backdate to Day 1
Create Purchase Receipt#2		This receipt replaces Purchase Receipt#1 with the correct product details e.g. quantity Ensure the transaction date is backdate to Day 1
Create Stock Quantity Adjustment#2		To decrease the stock quantity to achieve a net zero quantity for the stock quantity adjustments made i.e. Stock Quantity Adjustment#1 QTY + Stock Quantity Adjustment#2 QTY = 0 e.g. if SQA#1 QTY = 5 then SQA#2 QTY must be set to -5 5 + (-5) = 0 Ensure the transaction date is backdate to Day 1