Contributors mailing list archives

contributors@odoo-community.org

Refund Returned Pickings from Purchase Orders

by
Eficent Business and IT Consulting Services, S.L., Jordi Ballester Alomar
- 20/03/2017 10:27:40
Dear OCA contributors,

We are about to merge to OCA a new module "purchase_stock_picking_return_invoicing" that significantly improves the process of handing returns from PO's.

The module is now ready to merge and we are looking for more functional and technical reviewers.


For anyone interested I am going to do a webinar today at 17PM CET to explain the module. Please drop me a mail if you want to attend.

Find below the description of the module:


Refund Returned Pickings from Purchase Orders

This module extends the functionality of purchase orders to better manage
supplier returns and refunds.

In the purchase order you are able to display, for each line:

  • Quantity to Bill, and Quantity to Refund as separate fields. You have the
    option to create a vendor bill or a refund. In the bill or refund the
    correct quantity will be proposed, based on those fields.

  • Billed Quantity and Refunded Quantity, as separate fields.

  • Received Quantity and Returned Quantity, as separate fields.

Usage

Case 1: When you return to a supplier some products, and you have not yet
received the bill from the supplier

#. Go to Purchases > Purchase > Purchase Orders > Create.
#. Choose a supplier and add a product whose Invoicing Policy is On Received
quantities
, and input some quantity to purchase.
#. Confirm the purchase order.
#. Go to Shipment > Validate > Apply so as to receive the quantities ordered.
#. Press the button Reverse.
#. In the wizard Reverse Quantity Set Quantity to the quantity to be
returned. Press Return to complete the wizard.
#. On the return picking press Validate > Apply.
#. Go back to the purchase order. You will notice that the field Returned
Qty
 is now the quantity that was returned. The field Quantity to
Bill
 will show the quantity received less the quantity returned.
#. Press the button Invoices to create the vendor bill.
#. The proposed vendor bill will be proposed for the difference between the
received and the returned quantity.

Case 2: When you return to a supplier some products, and you have already
received a bill from the supplier.

#. Go to Purchases > Purchase > Purchase Orders > Create.
#. Choose a supplier and add a product whose Invoicing Policy is On Received
quantities
, and input some quantity to purchase.
#. Confirm the purchase order.
#. Go to Shipment > Validate > Apply so as to receive the quantities ordered.
#. Press the button Invoices to create the vendor bill.
#. The proposed vendor bill will be proposed for the quantity received. The
Invoice Status is now 'Invoiced'
#. Go to the original incoming shipment
#. Press the button Reverse.
#. In the wizard Reverse Quantity Set Quantity to the quantity to be
returned. Press Return to complete the wizard.
#. On the return picking press Validate > Apply.
#. Go back to the purchase order. It will have Invoice Status as 'Waiting
Invoces'. You will notice that the field Returned Qty is now the quantity
that was returned. The field Quantity to Refund is now the showing the
quantity returned that was previously billed.
#. Press the button Refunds to create the vendor refund bill (since the
field Quantity to Invoice is negative).
#. The proposed vendor refund bill will be proposed for the quantity that is
to be refunded.
#. If you back to the purchase order, you will notice that Invoice Status
is now 'Invoiced', even when the quantity ordered does not match with the
quantity invoiced, because you did return some products.

Remark: As part of the 3-way match proces, if you accept that you will not
claim for a refund for the quantity returned to the supplier, just set the
purchase status as 'Done' at the end of the process, and the quantity to
invoice for the items will be set to 0 (because you have accepted the
discrepancies).


--
Jordi Ballester Alomar
CEO & Founder | Eficent