c2c-oerpscenario team mailing list archive

[Nhomar Hernández - http://openerp.netquatro.com <nhomar@xxxxxxxxx>]

@ 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.