Cancel an Unpaid Inventoried Sale

Overview

If a customer has not paid for the items sold, then no cash settlement has occurred.  In those circumstances, you should reverse out the related accrued revenue and record the return of the physical product to your inventory.   

Cancel an Unpaid Inventoried Sale

1. Follow the steps in the Cancel an Unpaid Non-Inventory Sale (Apply a Credit Memo) article to cancel the sale. 
2. If this is a serialized product, we recommend that you delete the individual Sales Order Inventory Movements (SIMS) from each of the Sales Order Lines. 
   1. Access the Sales Order and each of the Sales Order Lines.
   2. On each Sales Order Line, click the SO Inventory Movement tab.
   3. On the far right of each line, select the drop-down list and click Delete to delete each SIM. 
      Note: This approach can also be used for non-serialized products.
      
3. For non-serialized products, create a new Inbound Inventory Movement for the product, warehouse, and location you are returning the inventory goods to. 
   
   1. From the Inventory Quantity Available list view, select the Inventory Quantity Available record for the item(s) you are returning to stock.  If there is not an Inventory Quantity Available record for the product, warehouse, and location combination, you need to create a new record.
   2. After selecting the record you wish to return the goods to, create a new Inbound Inventory Movement from the Inventory Quantity Available related list.  
   3. Enter the quantity you are returning to stock and the unit cost for the product.  The unit cost must be the same as unit cost used on the original Sales Order’s Sales Order Inventory Movement record.  
   4. Select “Accounting” as the Type from the drop-down menu. 
   5. Set the Debit GL account to your Inventory GL account and set the Credit GL account to the same account used to record Cost of Goods Sold on the original allocation of the Sales Order. 
   6. Change the movement date to the same date as the credit memo you issued (step 1 above).
   7. Save this record.

Step 2 and 3 will do the following:

• Increase the quantity available for that product; 
• Add it back to your inventory GL balance at the correct unit cost; and
• Reverses the Cost of Goods Sold recorded on the original Sales Order Inventory Movement.