← Back to team overview

c2c-oerpscenario team mailing list archive

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

 

@Fabien

Thanks for you interest in this bug and for the time you spend to reply.

Please read the article again : it speaks about FIFO, LIFO, average price and stock accounting in general.
The remark I underlined at the end of the article is located outside the FIFO / LIFO / average parts. It concerns the returns to suppliers in general case, whatever the method of stock accounting.

The second line of the article explains the global rule : "En principe, tout élément stocké sort des magasins au prix auquel il était entré." => The return to supplier goes out with the price it had when it got into the stock, no doubt about it.
Then, if average method is used, the cost price should be recalculated.

In general, average method is used by companies who want to have very
detailed control for their margins and do not accept approximations.

BTW, FIFO and LIFO do not interfere with returns to suppliers : when you
return products to suppliers, whatever you use FIFO, LIFO, average or
other method, you always return an identified product because "you have
it in your hands" (it's not the same with returns from customers because
when the products are at the customer's place, you lose the traceability
for them).

Please believe this article, moreover, it is good sense and logical.
Trust me, we will have more complicated discussions when we will talk
about return to suppliers for products that have been imported (with
landed costs that could be not refunded when you re-export the product
back... :-))

About #9, I finally do not agree with the two propositions of setup you
proposed : The aim of this bug starts at the time when the product is
already in the stock, whatever the workflow that has been used to get it
in. As long as the average method is proposed in the core, I strongly
think that this bug should be fixed in the core because OpenERP should
not make errors by default and actually, it does ! (I repeat several
times the same arguments, am I too old or am I misunderstood ?)

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