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. _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
