Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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#1 receipt and the attempted reversal.

To circumvent this you would need to

...

Create a first stock quantity adjustment to increase the product QOH.

  1. Ensure that the stock adjustment is backdated to the receipt date of purchase receipt#1  

Reverse the purchase receipt#1.

Again ensure that the reversal is backdated to the intended reversal date

Info

The above steps are necessary to rectify the insufficient QOH so the impending reversal can be successful

...

The problematic scenario and corrective actions are outlined below

 

Action SequenceDay 1Day 2Day 3 Note
Receive Purchase Receipt#1(tick)   BAU
Post Sale Shipment (tick)  BAU
Reverse Purchase Receipt#1   (error) Not successful due to insufficient product QOH
Corrective Action SequenceDay 1 Day 2 Day 3 Note
Create Stock Quantity Adjustment#1   

 (tick)

  • Increase the stock quantity sufficiently to enable successful execution of the impending receipt reversal
  • Backdate the transaction to Day 1
Reverse Purchase Receipt#1  

 (tick)

  • Backdate the transaction to the intended reversal date e.g. Day 3 

 

Create Purchase Receipt#2    (tick)
  • This receipt replaces Purchase Receipt#1 with the correct product details e.g. quantity

...

Create a second stock quantity adjustment to decrease the product QOH by the same quantity specified in the first stock quantity adjustment above

...

  1. Use the Copy button in the ribbon to create purchase receipt#2 from #1 then update fields as necessary 

  • Backdate the transaction to Day 1
Create Stock Quantity Adjustment#2   (tick)
  • Decrease the stock quantity sufficiently to achieve a net zero for the stock quantity adjustments

...

  • made
    i.e. Stock Quantity Adjustment#1 + Stock Quantity Adjustment#2 = 0 
  • Backdate the transaction to Day 1

 

...