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. To do so, follow these three steps:
- Create a Billing Credit Memo for the unpaid balance of the Billing - The process to create a Billing Credit Memo is almost the same as creating a manual Billing. The main difference is that when the Billing Lines are entered, they are entered with negative values. This will automatically change the type from invoice to credit memo. The transactions created when posting a credit memo are:
DR Revenue GL account set on the Billing Line
CR AR Control GL Account set in Accounting Settings
Tip - To reference the original billing on the credit memo place "Credit Memo for Billing number xxxxxxxxxx" in the Proprietary Billing Number field.
- Apply the credit memo to the Billing by clicking on the Apply Credit Memo button from the Credit Memo record.
- Create a new Inbound Inventory Movement for the product, warehouse, and location you are returning the inventory goods to.
- 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.
- After selecting the record you wish to return the goods to, create a new Inbound Inventory Movement from the Inventory Quantity Available related list.
- Enter the quantity you are returning to stock and the unit cost for the product. The unit cost should be obtained from the original Sales Order’s Sales Order Inventory Movement record.
- Select “Accounting” as the Type from the drop-down menu.
- 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.
- Change the movement date to the same date as the credit memo you issued (step 1 above).
- Save this record.
This will do the following:
- Increase the quantity available for that product;
- Add it back to your inventory GL balance at the correct weighted-average cost;
- Reverse the revenue recorded on the original Billing; and
- Reverse the Cost of Goods Sold recorded on the original Sales Order Inventory Movement.
- The Inventory Balance object has been renamed to Inventory Quantity Available
- When returning inventory to stock users must:
- Set the Inbound Inventory Movement Type to “Accounting”, and
- Enter the weighted-average cost from the original Sales Order Inventory Movement record as the Unit Cost on the new Inbound Inventory Movement