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 and the attempted reversal. The problematic scenario and corrective actions are outlined below

 

 
Action Scenario Event SequenceDay 1   Day 2   Day 3   Note Explanation
Receive Purchase Receipt#1    (tick)   Successful Successfully received
Post Sale Shipment         (tick)     Successful Successfully posted
Reverse Purchase Receipt#1      (error) Not successful  Unsuccessful due to insufficient product QOH
Corrective Action SequenceDay 1  Day 2 Day 3   Note
Create Stock Quantity Adjustment#1           (tick)
  • Increase To increase the stock quantity sufficiently to enable successful execution of the impending 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)
  • Backdate the transaction to Day 1
Reverse Purchase Receipt#1          (tick)
  • Backdate the transaction to Day 1 

 

Create Purchase Receipt#2           (tick)
  • This receipt replaces Purchase Receipt#1 with the correct product details e.g. quantity
  • 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 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
  • Backdate the transaction to Day 1

...