OdooWiki OCA HUB

Stock Account Valuation Report

stock_account_valuation_report folder_open OCA/stock-logistics-reporting open_in_new
Warehouse Management License: AGPL-3

When you trigger a report of inventory valuation, and you use perpetual inventory, you should be able to reconcile the valuation from an inventory perspective with the valuation from an accounting perspective.

This module changes the report in Inventory / Reporting / Dual Inventory Valuation to display separately the Quantity and Value of each product for the Inventory and the Accounting systems .

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Compare the stock value and quantity from inventory records with the value and quantity recorded in accounting, product by product, and spot differences. A new report under Inventory / Reporting / Dual Inventory Valuation shows both sides side by side.

This module adds a report that puts the inventory view and the accounting view of your stock side by side, so you can see whether they agree.

  • Open it from Inventory / Reporting / Dual Inventory Valuation. The list shows, for each storable product, the inventory quantity and inventory value, and (for products using automated/perpetual valuation) the accounting quantity and accounting value.
  • Two extra columns show the differences: quantity discrepancy and valuation discrepancy. Products with a difference can be found quickly with the search filters "Qty Discrepancy", "Valuation Discrepancy" or "Valuation Or Qty Discrepancy".
  • From each line you can open the underlying journal items (button "View Journal Items") or the stock valuation layers (button "View Valuation Layers") to understand where the figures come from.
  • A date wizard lets you run the same comparison as of a chosen date instead of today; it is available from the report and can also be opened for a single product or product template.
  • Only products with automated valuation get accounting figures and discrepancies; products with manual valuation show zero accounting values and zero discrepancies.

The module touches product.product, account.move.line and adds the stock.valuation.history wizard.

Depends on

stock_account

Required by other modules

stock_account_valuation_discrepancy_adjust

Menus it adds

Dual Inventory Valuation
Models and fields (3)
  • product.product · extends an existing modelqty_at_date (Inventory Quantity), stock_value (Inventory Value), account_value (Accounting Value), qty_discrepancy, account_qty_at_date (Accounting Quantity), valuation_layer_ids, valuation_discrepancy, stock_fifo_real_time_aml_ids
  • account.move.line · extends an existing modelproduct_id
  • stock.valuation.history · new modelinventory_datetime (Dual Valuation at Date)

Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 6 confirmed, 3 with no information of 9 versions.

Sources · Odoo 18.0

Confirmed on 2026-11-03 in branch 18.0 of OCA/stock-logistics-reporting.

terminal Installation and usage

No verified information

Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.