Totally agree with Mohamed & Talal. 

Simple scenario Odoo v13. Product with AVCO - Realtime. 

- You purchase have 10U in stock with AVCO 10$ (+100$).

- Next you purchase 10 U at 6$, receive them, result: 20U at 8$. (+160$)

- Then you return this whole purchase, it was made by mistake. 10U at 8$(-80$) so resulting AVCO is 8$ per 10 ud (+80$)

Without any effective purchase, your stock value changes, -20$

This happens to some of our customers frequently, some mistakes with units (ie 100U in place of 10U) and similar situations.

Is there any change planned on this??

Thanks!

We decided to add the function which lets a user to choose the lot/SN or product move that costs should be returned.

For example, a user made a mistake and purchased 100qty per $5.00 instead of $0.5. In that case you may select what exactly lot should be returned. The return cost has to be equal to received cost. https://erpixel.com/

Any luck on this??

We have the same problem. I've checked v10 model stock_quant and can propose "basic dirty fix".

In database returned moves have id in origin_returned_move_id. So if we want limit domain to related quants we can extend domain in 

 def _quants_get_reservation_domain
        ....
        if move.origin_returned_move_id:
            domain += [('id', 'in', move.origin_returned_move_id.quant_ids.ids)]

        return domain

and we should get domain on "action done":

[('qty', '>', 0), ('product_id', '=', 300), ('location_id', '=', 9), ('package_id', '=', False), ('company_id', '=', 1), ('id', 'in', [467722])]

Without limiting to related quants we got FIFO/LIFO for selected product from whole customer zone (what is wrong).

we have the same problem in our company . what is your solution ?

i follow all info and every thing is ok but still get wrong value for return

Returned goods have to follow the regular costing method (whether it's FIFO or Avg), instead of using "Original Cost", otherwise your accounting valuation gets wrong.

Have a look at the following scenario:

• 1 product in stock, accounting value: 100$

• return it to supplier at 90$, it's original cost

• result: 0 product in stock, value in accounting: $10

That would be not correct, as a Gaap point of view. Odoo follows the accounting principle, which is to follow FIFO, or average price, instead of "price of original order before return".