Phase 2 · Module M5

Sales: Returns, Credit Notes & Reporting

Odoo 20.0 Training Program · Sage Business Vision migration

60 minutes Salesmen / Owners Bookkeeper Prerequisites: M4

The exception path that still has to be clean

Most orders go out and get paid. Some come back. A return is not a failure of the process; it is part of the process. Odoo handles it with a reverse delivery and a credit note, so the stock and the accounting stay correct.

This module also introduces sales reporting. Once the transactions are clean, the reports tell you what is selling, who is buying, and where the margin is. Reports are only as good as the data behind them, which is why the return process matters.

Two documents, one event: a customer return usually creates a reverse stock transfer and a credit note. The reverse transfer puts the goods back in stock. The credit note reduces what the customer owes.

Learning objectives

By the end of this module, you should be able to:

  • Process a customer return from a delivered sales order.
  • Validate the reverse delivery and confirm that stock is back in the warehouse.
  • Create a credit note and explain how it affects the customer balance.
  • Run a sales analysis report and filter it by customer, product, or period.
  • Explain the effect of a return on stock, revenue, and tax.
Audience: salesmen, owners, bookkeeper Format: demo + hands-on Sandbox: required

Core concepts

Returns and reverse deliveries

A return starts from a delivered order. Odoo creates a reverse transfer that moves the goods from the customer back to the warehouse. When you validate the reverse transfer, the stock quantity increases. The original delivery remains in the history, and the return is linked to it.

Credit notes

A credit note is the accounting document that reduces the amount the customer owes. It can be created from the invoice or from the sales order. A credit note has its own status and must be posted. If the customer already paid, the credit note can be refunded or applied to a future invoice.

Document What it affects Why it matters
Reverse delivery Stock quantity Puts the returned goods back into inventory so they can be sold again or inspected.
Credit note Customer balance, revenue, tax Reduces what the customer owes and reverses the revenue and tax from the original invoice.
Refund Cash or bank Returns money to the customer when the original invoice was already paid.

Sales reporting

The Sales Analysis report shows sales by customer, product, salesperson, and period. You can view it as a list, a pivot table, or a graph. Use filters to narrow the period and the team. Use group-by to compare products or customers. The report uses confirmed sales orders, so draft quotations are not included.

Do not delete a delivery to handle a return. Deleting documents erases history. Use the return action so the original delivery, the reverse transfer, and the credit note remain linked and auditable.

Walkthrough

Follow along in the sandbox. Use a delivered and invoiced sales order from Module 4.

  1. Open the delivered sales order

    Open the Sales app and find the order you delivered in Module 4. Confirm that the delivery is done and that the invoice is posted. The return starts from this history.

  2. Create the return

    Open the delivery order and use the return action. Select the quantity to return. Choose a reason if the sandbox provides a reason field. Odoo creates a reverse transfer. Review the source and destination locations: the goods should move from the customer back to the warehouse.

  3. Validate the reverse delivery

    Validate the reverse transfer. The stock quantity increases. Return to the product and confirm that the on-hand quantity reflects the return. If the product is tracked by lot or serial number, confirm that the returned lot or serial is recorded.

  4. Create the credit note

    Open the original invoice and use the credit note action. Select the lines and quantities to credit. Confirm that the tax is reversed correctly. Post the credit note. The customer balance is reduced by the credited amount.

  5. Handle the refund if needed

    If the invoice was already paid, the credit note creates a customer credit. You can refund the customer or apply the credit to a future invoice. For this exercise, note the available action but do not process a real refund unless the facilitator asks you to.

  6. Run a sales analysis report

    Open Sales > Reporting > Sales Analysis. Set the period to include your order. Filter by Practice Customer 01 or by the product you sold. Switch between list, pivot, and graph views. Notice how the return affects the reported quantities and revenue.

  7. Compare before and after

    Note the sales figures before and after the return. The net revenue should reflect the credit note, and the stock should reflect the reverse delivery. This is the link between the operational documents and the reports.

Exercise

Return, credit, and report

Complete these steps on your own in the sandbox.

  • Open a delivered and invoiced sales order.
  • Create a return for one delivered line and validate the reverse delivery.
  • Confirm that the stock quantity increased.
  • Create a credit note for the returned line and post it.
  • Confirm that the customer balance or the invoice status reflects the credit.
  • Run a sales analysis report filtered to the customer and the period, and note the net sales figure.

Expected result: the return is linked to the original delivery, the stock is back in the warehouse, the credit note is posted, and the sales report shows the net effect. No documents were deleted.

Check your understanding

Answer these questions before moving to the next module. Open each answer to check yourself.

1. What does a reverse delivery do?

It moves goods from the customer back to the warehouse. When validated, it increases the stock quantity and keeps the return linked to the original delivery.

2. What does a credit note do?

It reduces the amount the customer owes and reverses the revenue and tax from the original invoice. It is an accounting document and must be posted.

3. Why should you not delete a delivery to handle a return?

Deleting erases the audit trail. The return action keeps the original delivery, the reverse transfer, and the credit note linked so the history is clear.

4. What does the Sales Analysis report include?

It analyzes confirmed sales orders. You can view it by customer, product, salesperson, and period, and switch between list, pivot, and graph views.

5. What happens if the customer already paid and then returns the goods?

The credit note creates a customer credit. You can refund the customer or apply the credit to a future invoice. The bookkeeper should decide which treatment is appropriate.

Facilitator notes

Suggested timing: 10 minutes concepts, 20 minutes guided walkthrough, 25 minutes exercise, 5 minutes questions and close. Keep the reporting section short but show the net effect of the return.

  • Before the session, confirm that at least one sales order is delivered and invoiced so learners have a record to return.
  • Have the bookkeeper explain the credit note and the customer balance. This is a good cross-training moment.
  • Watch for learners who try to delete or cancel the original delivery. Redirect them to the return action.
  • If the sandbox has lot or serial tracking, use it in the return so learners see how the tracked quantity is handled.
  • Show one pivot view and one graph view. Do not tour every report in the Sales app.

Next steps

You can now handle the sales exception path and read a basic sales report. The next phase moves to purchasing, starting with vendors and purchase orders.