Versions Compared

Key

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

...

Scenario Event SequenceDay 1   Day 2    Explanation
Receive Purchase Receipt#1    (tick)  Successfully received
Create Sale Shipment    (tick)    Successfully posted
Reverse Purchase Receipt#1     (error) Unsuccessful due to insufficient product QOH
Corrective Action Sequence  Day 2 Note
Create Stock Quantity Adjustment#1      (tick)
  • 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 backdate to backdated to Day 1
Reverse Purchase Receipt#1     (tick)
  • Ensure the transaction date is backdate to backdated to Day 1 with the time and date

 

Create Purchase Receipt#2      (tick)
  • 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     (tick)
  • 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 . 

    Expand
    titleShow Me

    Image Added

  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

    Expand
    titleShow Me

    Image Added



  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

    Expand
    titleShow Me

    Image Added

  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

    Expand
    titleShow Me

    Image Added

  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.