OdooWiki OCA HUB

Stock Inventory Discrepancy

stock_inventory_discrepancy folder_open OCA/stock-logistics-warehouse open_in_new
Warehouse License: AGPL-3

Adds the capability to show the discrepancy of every line in an inventory and to block the inventory validation (setting it as 'Pending to Approve') when the discrepancy is greater than an user defined threshold.

Only new group "Validate All inventory Adjustments" will be able to force the validation of those blocked inventories. By default, Stock manager will belong to this group. In addition, Stock Users can validate inventories under the threshold now.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Shows the discrepancy percentage of each inventory count line and blocks validation when it exceeds a threshold you set per warehouse or location. Only authorised users can force the adjustment through.

This module adds a discrepancy check to inventory adjustments. On each inventory count line you now see the discrepancy percentage (the difference between counted and theoretical quantity, relative to the theoretical quantity), the applicable threshold, and the line is highlighted in red when it goes over that threshold.

Thresholds are configured in percent: on the warehouse form and on the location form (visible to stock managers). A location threshold takes priority over the warehouse threshold, and a location can propagate its threshold to all child locations.

A company-level setting, "Inventory Discrepancy Control", turns the whole check on or off. When it is on and a line exceeds its threshold, pressing Apply on the inventory adjustment does not validate it; instead a "Confirm discrepancy" wizard opens listing the offending products. Only users in the group "Validate Inventory Adjustments excceded threshold" can confirm and proceed; other users are told they lack the rights. Stock managers belong to that group by default.

A new "Validate Inventory Adjustments" group controls who may apply inventory adjustments at all, and the Apply and inventory-name buttons are restricted to it. A search filter "Over Discrepancy" lets you find lines above their threshold.

Depends on

stock
Models and fields (6)
  • res.company · extends an existing modelinventory_discrepancy_enable (Inventory Discrepancy Control)
  • stock.quant · extends an existing modeldiscrepancy_percent (Discrepancy percent (%)), has_over_discrepancy, discrepancy_threshold (Threshold (%))
  • stock.location · extends an existing modeldiscrepancy_threshold (Maximum Discrepancy Rate Threshold), propagate_discrepancy_threshold (Propagate discrepancy threshold)
  • stock.warehouse · extends an existing modeldiscrepancy_threshold (Maximum Discrepancy Rate Threshold)
  • res.config.settings · extends an existing modelinventory_discrepancy_enable (Inventory Discrepancy Control)
  • confirm.discrepancy.wiz · new modeldiscrepancy_quant_ids

Text generated by AI (DeepSeek) from reading the Odoo 19.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: 8 confirmed, 1 with no information of 9 versions.

Sources · Odoo 13.0

Confirmed on 2026-11-03 in branch 13.0 of OCA/stock-logistics-warehouse.

terminal Installation and usage

OCA documentation · Odoo 19.0
  • Go to "Inventory \> Warehouse Management" \> Warehouses" or to "Inventory \> Warehouse Management" \> Locations".
  • Modify the "Maximum Discrepancy Rate Threshold" either in a Warehouse or in a location. If set to 0.0 in both the threshold is disabled.

If you configured a "Maximum Discrepancy Rate Threshold".

  • When validating an Inventory Adjustment if some line exceed the Discrepancy Threshold the system will set the inventory's state to 'Pending to Approve' and show the quantity of lines that exceed the threshold.
  • If both WH and location thresholds are configured, the location one has preference.
  • The user with "Validate All inventory Adjustments" rights can force the validation of an inventory pending to approve.

No verified information in OCA: Installation.

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.