Community mailing list archives

community@mail.odoo.com

Re: Return products and average cost

by
ADINS sprl, Christophe HANON
- 01/09/2015 12:18:20
Well,

the issue is that typically the items have NOT entered in stock. In this case, having the value changed has no sense, nor is legal. 

Either the items are effectively returned or simply they did not entered into stock. 

The typicall issue being that in a single click an encoding error can be created (not saying the system is wrong but sometimes people do mistakes) and the average price is definitively broken. 

Another issue is that it happens  you don't know the price until the invoice is received.

Other issues are also related to this, for example the current system works by processing deliveries sequentially, but sometimes due to a wrong encoding order, the price is again false.

Actually I got it 'right' only one way, by having a recompute routine so corrections can be applied safely.

In summary the current average computation is too simple to be always correct and tracable. 

One extra thing. average_cost is the only case for which we keep history. It is a shame, we should always keep track of price change (or at least it should be possible). The reason being that sometime you want to value the stock at a given date.

Kind regards,



Christophe

C Hanon - ADINS


On Fri, Jan 9, 2015 at 5:33 PM, Fabien Pinckaers <fp@openerp.com> wrote:

In my opinion, only the first scenario is correct. It's the definition of average price in every accounting books (product leaving the stock do not impact the average price) and I never saw a legal exception to this definition.

More over, if we accept the second scenario, this would lead to serious inconsistencies. Here is a scenario:

- product configured in average price and real time
- buy 1 piece at 10€ (average price = 10€) - buy 1 piece at 20€ (average price = 15€)
- deliver first piece to your customer (avg price = 15€)
- return the last purchase to the supplier (avg price = -5€, inventory valuation is negative) --> serious inconsistency!

Please do not implement the suggested change (second scenario) unless someone has a legal document explaining we should do it that away and not the other way.

Our position is NOT that both are acceptable, only the first one is. (The one currently implemented in Odoo)

Thanks,

On Jan 9, 2015 8:03 AM, "Martin Trigaux" <mat@odoo.com> wrote:
Hello,

We would like to statue on an (old) bug and would appreciate advices
from people with experience in stock accounting.

The bug lp:610738[1] "return products to supplier does not update price
average" concerns the following scenario:
- product configured in average price and real time
- buy 1 piece at 10€ (average price = 10€)
- buy 1 piece at 20€ (average price = 15€)
- return the last purchase to the supplier

Current situation:
- the average price is unchanged
- the stock input account and stock valuation is decreased of 15€

Suggested change:
- the average price is changed to 10€
- the stock input account and stock valuation is decreased of 20€

Should the return be made at the purchased price or at the current
average price.

Our position has been that both behaviour are acceptable and dependant
of the management of the company.
One of the last comment[2] suggested that it is indeed the case (with
preference for the suggestion behaviour) while most of the previous
suggested the current behaviour is incorrect.

Some time has passed, modules have evolved but the bug is still opened.
To close this debate once and for all, what is the opinion of experts on
this?
Accounting references would of course be of great help here.

Thank you in advance,

Martin

[1] https://bugs.launchpad.net/bugs/610738
[2] https://bugs.launchpad.net/openobject-addons/+bug/610738/comments/48

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--

Christophe Hanon - ADINS

Tel +32 (0) 10 81 47 32

Fax + 32 (0) 10 81 91 84

Mobile +32 (0) 475 63 79 65

www.adins.com & www.adins.be

 


ADINS est signataire -numéro d'enregistrement 435 - de la charte de déontologie

« eTic » consultable à  l'adresse www.charte-etic.be.