← Back to team overview

c2c-oerpscenario team mailing list archive

Re: [Bug 610738] Re: [5.0] return products to supplier does not update price average

 

@Fabien
 Hello Again,

I checked my accounting book, they only talks about the
> reception of products.

I have checked mine  and all of them talk about the same.

> I think it's important to find references that
> explicitly explains the rules before doing any development on this;


But this issue can be resolved just doing a little math, as pointed out
above, in previous comment.
I know that weighted average cost method, considers all products at same
price, but just a little review
of an in_invoice and an in_refund (not an purchase allowance) will enlighten
all of us,

when we return products to suppliers, we "don't know" which physical
product we are returning, but in our
records we _do_ know which product we intend to return.

And if you bought the product you are intending to return to a more
expensive price, you will not allow your
supplier send you a refund for less money than that you paid for.



> i
> heard so much different things about average price that I prefer being
> sure before integrating something.
>
> --
> [5.0] return products to supplier does not update price average
> https://bugs.launchpad.net/bugs/610738
> You received this bug notification because you are subscribed to
> OpenObject Addons.
>

-- 
[5.0] return products to supplier does not update price average
https://bugs.launchpad.net/bugs/610738
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: Confirmed

Bug description:

When returning products to a supplier, the average standard price should be updated using the price of the packing list which is returned.

For example :
1- We have 10 products with average price = 100
2- We receive 5 products with price = 80 --> average price is calculated as (10*100+5*80)/(10+5) = 93,33
3- We return 3 products from the last packing list (the one where products cost 80)
The new average price should be 
(93,33*15 - 3*80)/(15-3)=96,67

If the return is made directly from the stock and does not concern any incoming packing list, we do not update the average price.





References