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

Accounting mailing list archives

accounting@odoo-community.org

Browse archives

Certified Magento Developer for your Magento Site!!

Re: Funding for the Accounting PSC

Avatar

Re: Inventory revaluation, Quants and product price

by
ForgeFlow, S.L., Jordi Ballester Alomar
- 10/02/2016 20:38:21
Dear colleagues,

The Inventory Revaluation is now implemented, and proposed PR to OCA. Runbot is green. Still is missing automated tests and greenify travis for pep8 issues.



* It supports revaluation under standard, moving average and real cost methods.
* It allows you to revaluate the inventory by specifying a new unit cost, or by specifying the change in the overall inventory value (which will adjust the corresponding unit cost)
* In moving average costing method, the new average cost is computed and updated in the product.

As Eric suggested, for Real costing method user can select the quants to be revaluated, based on a date range, and then can change the cost. 

If the product is managed under real-time valuation the corresponding journal entries will be created:

When product value is increased:
Dr. Inventory 
Cr. Inventory Valuation Increase Account

When product value is decreased:
Cr. Inventory
Dr. Inventory Valuation Decrease Account

Regards,
Jordi.

On Wed, Feb 10, 2016 at 9:08 AM, Eric Caudal <eric.caudal@elico-corp.com> wrote:

+1.
IMO  a date "as of" (or range) should be provided for the change of price or the possibility to pick the involved quants.
Standard price in product should be recalculate a posteriori

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore) Odoo Gold Partner, best Odoo Partner 2014 for APAC
On 02/10/2016 03:07 AM, Jordi Ballester Alomar wrote:
<blockquote cite="mid:CALVkZEdcQf=GLKSTfwn=EpuAGQPbc_1HUqy=pbKw4MfAT=xCLw@mail.gmail.com" type="cite">
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




--

Reference