c2c-oerpscenario team mailing list archive

[Joël Grand-Guillaume @ CampToCamp <joel.grandguillaume@xxxxxxxxxxxxxx>]

Dear all,


I must say I agree with Invitu & Nhomar on this point. Average price should be affected by a return at the cost of those products were purchased.

A simple example to illustrate :

Purchase & receipt 10 product at 20.- => Avg = 20.-
Purchase & receipt 5 product at 15.- => Avg = 18.33.-
Return 2 product of the last packing...

1) If no impact on average price : Avg price is still of 18.33.-
2) If returned at the purchased price: Avg price is now = 18.84.-

When I receive again the 2 missing products at the same price (15.-) the
Avg price is computed...

In case 1) Avg price will be now of 17.94.- ((10*20+5*15+2*15)/17)
In case 2) Avg price will again be at 18.33.- which is the correct answer

So, if we do not change the average price when making a return, then we
will have a wrong Avg price when making again the packing for the
returned product.

According to my understanding, we want to know how much does this
product cost me here... The case 1) doesn't give me the right answer...
My customers agree with that.

I think we should make what Nhomar suggest.


Regards,

Joël

-- 
[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 OpenERP OpenObject.

Status in OpenObject Addons Modules: Won't Fix

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.