1. Mailing Lists
  2. Accounting
  3. Real time (perpetual) inventory valuation - matching between the inventory and accounting valuations

Accounting mailing list archives

accounting@odoo-community.org

Browse archives

Re: Real time (perpetual) inventory valuation - matching between the inventory and accounting valuations

Re: Module Idea: invoice-template-designer

Avatar

Real time (perpetual) inventory valuation - matching between the inventory and accounting valuations

by
ForgeFlow, S.L., Jordi Ballester Alomar
- 14/12/2016 18:05:19
Dear accounting experts,

FYI, we're working on the topic of real time (perpetual) inventory valuation, and have just built a module "product_inventory_account_reconcile" (https://github.com/OCA/stock-logistics-warehouse/pull/228) that allows a user to review the discrepancies between the inventory valuation from stock and accounting perspectives, and to reconcile the two worlds.

For example, according to my stock levels and unit cost, I have worth 10.000€ of iMacs, but when I look at my inventory account and look at the accounting balance for product "iMac" I get 12.000€ (for one reason or another - there are various). In that case I can list in the product list view that there's a discrepancy of 2.000€ and create a journal entry that reconciles the discrepancies.

This allows to better build the concept of "Material Ledger". This concept means that your inventory account is properly tracked on a product level. 

The module "stock_inventory_revaluation" also helps to better manage stock accounting under the real time inventory valuation.

If this topic is of your interest, please do not hesitate to review the PR.

Not sure if the name "product_inventory_account_reconcile" is clear enough. What do you think?

Best regards,
--
Jordi Ballester Alomar
CEO & Founder | Eficent

Follow-Ups