When to write off and when to cancel
Deciding whether to write off or cancel an order can be complicated, depending on the scenario. It is essential that the correct process is followed to make sure any outstanding commitments are correctly removed and that a suitable audit trail is maintained.
We have described some typical purchasing scenarios and provided a choice of solutions based on what course of action you want to take. Once you have identified the required solution, use the cross reference to follow specific instructions.
If there is still an amount remaining on a Value Reducing Purchase Order, to remove the outstanding balance from the commitments, it can be written off the same way as quantity reducing orders.
An order has not yet been placed with the supplier
A requisition (if used) and purchase order have been raised and authorised for an order of 100 books and 100 pencils. The order has not yet be placed with the supplier. Select from the following scenarios:
Scenario 1 - the supplier can only deliver a reduced quantity of one or more items
The supplier can only deliver a reduced quantity (for example, they can deliver 100 books but only 75 pencils).
Solution A: If you are happy to wait for the remaining quantity to be delivered:
Wait for the first delivery then create a GRN from the applicable purchase order. Amend the quantities in the GRN to reflect what has been received (for example, amend the number of pencils to 75).
Once you post the GRN, the remaining item quantity (for example, 25 pencils) stays outstanding for the purchase order and shows as a commitment.
When the outstanding quantity is delivered, create a GRN from the applicable purchase order, which then shows an outstanding quantity (for example, 25 pencils). Enter the quantity received and progress.
Solution B - If you do not want to wait for the remaining quantity to be delivered (for example, not wait for the 25 pencils), or the supplier is unable to deliver the outstanding quantity in the near future, you need to write off the quantity from the applicable purchase order.
This process amends the purchase order to reflect correctly the quantity of items that the supplier can deliver so that the commitment is correct, for example, 75 pencils. You can then progress the GRN, which correctly reflects what has been delivered.
Solution C – If you no longer want the item (for example, you do not want any pencils delivered), you need to cancel the item.
Solution D – If you no longer want to proceed with the entire order, you need to cancel the order.
If the goods are still required, you can create a new requisition or purchase order for a different supplier.
Scenario 2 - the supplier has no stock of one or more items
The supplier has no stock of one or more items (for example, has no pencils in stock).
Solution A – If you want to proceed with the remainder of the order (for example, you still want the 100 books), you need to cancel the item that the supplier is unable to provide (for example, the pencils).
This removes the item from the purchase order. When the remainder of the order arrives, create a GRN from the applicable purchase order, which then shows correctly only the items that the supplier can deliver, for example, 100 books.
Solution B – If you no longer want to proceed with the entire order, you need to cancel the order.
If the goods are still required, you can create a new requisition or purchase order for a different supplier.
Goods have been delivered - a GRN has not yet been completed
A requisition (if used) and purchase order have been raised and authorised for an order of 100 books and 100 pencils. The order has been placed with the supplier and the goods have been received. You have not yet posted a GRN. Select from the following scenarios:
Scenario 1 - a quantity of the items are missing or damaged
A quantity of the items are missing or damaged (for example, only 90 books were delivered and 5 of the pencils were damaged).
The solution depends on what the supplier is able/prepared to do:
Solution A – If the supplier agrees to send the missing items or replace the damaged items, create a GRN for the appropriate purchase order, then enter the actual quantity delivered and quantity of undamaged items (for example, 90 books and 95 pencils).
Once you post the GRN, the missing or damaged item quantities remain outstanding for the purchase order and show as a commitment. In our example, 10 books and 5 pencils remain outstanding.
When the missing/replacement item quantities are delivered, create a GRN from the applicable purchase order, which shows the outstanding quantities (for example, 10 books and 5 pencils). Enter the quantity received and progress the GRN.
Solution B – if the supplier agrees to amend their invoice to reflect what was actually delivered (that is, removes the missing and damaged items from the invoice), you can then:
Write off the missing/damaged item quantities from the applicable purchase order.
The purchase order then correctly shows the item quantities that have actually been delivered (for example, 90 books and 95 pencils).
Do not create the invoice yet. Create a GRN from the applicable purchase order first, which correctly shows 90 books and 95 pencils have been delivered. The GRN can then be progressed to the invoice stage, which should then correctly match the supplier invoice when it arrives.
Solution C – There may be occasions when you decide to return the full quantity of a damaged item rather than only those that are damaged. In this circumstance, you need to cancel the item on the purchase order. The GRN then no longer shows the item and you can progress it to the invoice stage with the quantities you actually received.
Make sure the damaged items are returned so that these are not included on the supplier invoice.
Scenario 2 - an item is no longer available
An item is no longer available and has not been delivered.
Solution A – If an item is no longer in stock, you need to cancel the item on the purchase order. The GRN then no longer shows the item and you can complete it and progress it to the invoice stage.
Goods have been delivered - a GRN has been completed
A requisition (if used) and purchase order have been raised and authorised for an order of 100 books and 100 pencils. The order has been placed with the supplier and the goods have been delivered. You have completed a GRN. Select from the following scenarios:
Scenario 1 - the GRN has been incorrectly completed and does not match the quantities delivered
The GRN is incorrect and does not match the quantities delivered, for example, only 97 books arrived but someone entered 100 in the GRN.
If you take no action, there is either a disparity between the supplier invoice and the GRN, or you pay for more items than you actually received.
The solution depends on what the supplier is able/prepared to do:
Solution A – If the supplier is going to deliver the missing quantities,cancel the GRN to go back to the authorised purchase order stage.
Create a new GRNfor the applicable purchase order and correctly enter the quantities delivered (for example, 97 books). The missing quantities (for example, the 3 books) remain outstanding and you can create a GRN when they arrive.
Solution B – If the supplier agrees to amend the invoice to match what was actually delivered (for example, they invoice for 97 books and 100 pencils), cancel the GRN, then write off the quantities that were not delivered (for example, 3 books) from the authorised purchase order. This then correctly reflects what has been delivered.
Create a new GRN and enter the correct quantities delivered (for example, 97 books and 100 pencils).
Scenario 2 - the GRN has been incorrectly completed and does not match the items delivered
The GRN is incorrect and does not match the items delivered, for example, only 100 books and no pencils arrived but someone entered 100 books and 100 pencils in the GRN.
If you take no action, there is either a disparity between the supplier invoice and the GRN, or you pay for more items than you actually received.
The solution depends on what the supplier is able/prepared to do:
Solution A – If the supplier is going to deliver the missing items, cancel the GRN to go back to the authorised purchase order stage.
Create a new GRN for the applicable purchase order and correctly enter the quantities that were delivered (for example, 100 books and 0 pencils). The missing items (for example, 100 pencils) remain outstanding and you can create a GRN when the missing items arrive.
Solution B – If the supplier agrees to amend the invoice to match what was actually delivered (for example, they invoice for 100 books only), cancel the GRN, then cancel the missing item (for example, the 100 pencils) from the authorised purchase order.
The purchase order then correctly reflects what has been ordered and delivered. Create a new GRN and enter the correct quantities delivered (for example, 100 books).
Goods have been delivered - a GRN and invoice have been completed
A requisition (if used) and purchase order have been raised and authorised for an order of 100 books and 100 pencils. The order has been placed with the supplier and the goods have been received. You have completed a GRN and raised the invoice.
This scenario demonstrates the consequences of not following the correct procedure and includes a solution on how to make the necessary corrections.
Scenario: The GRN has been incorrectly completed and does not match the items delivered (for example, only 97 books were delivered, but the GRN showed 100).
The invoice arrived for the actual quantity delivered (for example, for 97 books). You created an invoice in IRIS Purchasing and amended the quantity of the invoice to reflect the physical supplier invoice.
Because the original purchase order was for 100 books, there is still a commitment of 3 books in the system.
Because you have created the GRN and invoice, you can no longer write off or cancel any part of the order.
Solution — Progress the GRN to the invoice stage to clear the commitment from the system. This creates a POIN document in IRIS Financials.
The invoice does not need to be paid and must therefore be cancelled in IRIS Financials.