1. Mailing Lists
  2. Accounting
  3. Re: Inventory revaluation, Quants and product price

Accounting mailing list archives

accounting@odoo-community.org

Browse archives

Re: Inventory revaluation, Quants and product price

Avatar

Re: Inventory revaluation, Quants and product price

by
ForgeFlow, S.L., Jordi Ballester Alomar
- 10/02/2016 11:40:51
Jay,

For returns and impact on average cost, we already solved the problem. Find attached the module. Did not find the time to propose it to OCA, but will be happy if you review and propose it.

I discussed this topic personally with Quentin during the OdooMRP Workshop and he questioned this solution. This the working document he offered me to review about this topic.

And I must say that I agree with him... I also double checked SAP, and handles it the same as Quentin's approach.

It only makes sense to me to use the actual cost of the product in a return as the same of the incoming shipment under a 'Real price' schema, where the cost of the actual quant is considered each time.


On Wed, Feb 10, 2016 at 10:23 AM, Jay Vora (SerpentCS) <vora.jay@serpentcs.com> wrote:
Additionally, the return orders affect badly on average costs.

We are right now working on effect of return orders on avg costs.

Not sure the quants play the right role.

Thanks,
Regards,
Jay Vora.
Serpent Consulting Services Pvt Ltd.
M : 091-9879354457


-------- Original Message --------
From:Wim Audenaert <Wim.Audenaert@ucamco.com>
Sent:Wed, 10 Feb 2016 14:07:51 +0530
To:Accounting <accounting@odoo-community.org>
Subject:RE: Inventory revaluation, Quants and product price

Hello Jordi,

 

I agree with the fact that the standard cost price field is irrelevant in case of “Real Price” and “Average Price” costing methods, but it is not for “Standard Price” costing method.

 

Maybe we need a 2nd cost price field, one (stored) for “Standard Price” costing method that can be defined by the user, and one (not stored) for “Real Price” and “Average Price” costing method.


Depending on the costing methods, the used cost price can be visible for the user.

 

Regards,


Wim

 

From: Jordi Ballester Alomar [mailto:jordi.ballester@eficent.com]
Sent: Tuesday, February 9, 2016 8:08 PM
To: Accounting <accounting@odoo-community.org>
Subject: Inventory revaluation, Quants and product price

 

Dear accounting experts,

 

We're addressing the topic of inventory revaluation. That is, you don't like the value of a product (e.g. obsolescence, solve issues in valuation, wrong PO price, etc..), and you need to change it.

 

In Odoo you are offered the option to change the standard price of the product, and under real time valuation this produces a corresponding inventory posting entries.

 

But since Odoo manages Quants, and each Quant keeps it's purchase cost (and hopefully manufacture cost in we can add support for that soon), the standard price field in the product is irrelevant as a stored field, because should really be the result of the cost of the quants. 

 

Under the FIFO costing, the price of the product to be shown would be the cost of the first quant for that product. In reality Odoo is using FIFO costing method because it considers the cost of the quant to generate the accounting entries in stock moves...

 

If you are to undergo an inventory revaluation, wouldn't you need then to revaluate the quants, and not the product standard prices? Revaluating a quant would as a consequence generate the corresponding accounting entries for inventory revaluation.

 

 

Regards,

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe




--

Reference