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 1	Day 2	Explanation
Receive Purchase Receipt#1			Successfully received
Create 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 and time is backdated to Day 1
Reverse Purchase Receipt#1			Ensure the transaction date is backdated to Day 1 with the time and date
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

1. Identify the Date and Time of the Purchase Receipt.
   Identify the Products on the Purchase Receipt that do not have sufficient stock by highlighting the Purchase Receipt and clicking on the Reverse Action Button. The sytem will pop up with a validation message and a list of the products that do not have sufficient stock.
   Note down the products and the quantity received from the purchase receipt . 

    Show Me

   

2. Close out of the validation error and close out of the Date option window

3. Still on the purchase receipt, click on each product that was listed in the validation

4. Click on the 'Related' action button within the detail area and then click on 'Show Product'. Repeat for all products validated

    Show Me

   

   
   
   

5. From within the product, click on theTab = Site; Tab = Movements
6. Populate onto the movements detail view the column of 'Balance'

7. Arrow down to the Purrec in question (ensure you are on the right one with the right date and time) and note down the balance at that point in time

    Show Me

   

8. Now you are ready to do a stock quantity adjustment

9. Still in Product file, click on the drop down arrow on NEW

10. Click on Stock Quantity Adjustment

     Show Me

    

11. Enter the Date and time that you noted the Purchase receipt was updated on.
12. Commence entering the products you wish to adjust in order to get the stock at the level and time it was before the receipt was posted
13. Entering the qty to adjust and the stock qty adjustment gl account and a description referring back to the receipt.
14. Finalise the Stock Qty Adjustment
15. Go back to the product movements and on the date of the PURREC the total balance value should equal the total value of the stock received on that receipt
16. Go back to the purchase receipt that you need to reverse after all stock qty adjustments have been done and Click on Reverse
17. The system will create a Reversal Purrec and a Reversal Purinv if the Invoice exists.
18. Now you need to Receive the Purchase order with the right date, time, prioducts, qty and units etc.
19. Go to the purchase order that will now have a status = open
20. Click on Receive
21. Check the date, time, product, qty, units and costing
22. Click on Save
23. Click on Default Total
24. Click on Finalise if you have not received the Invoice otherwise click on Complete to Invoice as well.
25. If completing, enter the Supplier Invoice Number and the Date
26. Click on OK
27. Now go back to the Stock Qty Adjustment and Copy it
28. Change the date and time to be the same as the original Stock Qty Adjustment and enter the Adjustment Qty to be in Negative.
29. Click on Finalise
30. Check the balance on those products on that date and time.