@ Fabien. The equation:
(Qty Rcvd * PO Price + Existing Qty * Current Cost) / (Qty Rcvd + Existing Qty). Is correct with Purchase goods procedure. In return sale equation is: (Qty Rcvd * transaction Cost Used + Existing Qty * Current Cost) / (Qty Rcvd + Existing Qty). In return purchase equation is: (Existing Qty * Current Cost - Qty deliv * PO Price) / (Existing Qty - Qty deliv ). i'm surprissed you didn't find support for this if when somebody studies average cost calculation this is a basic exampĺe in how to do that. Te problem is the "Cost proposed" only this, we can develop somthing extra to be able to correct the "Purchase return" pocess because it can be more dificult but the anoher one is very plain to solve. I hope it can help. -- [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
