OdooWiki OCA HUB

Stock Demand Estimate Matrix

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

This module allows to create demand estimates for a given product and location, on configurable time periods.

The module does not provide in itself any specific usage of the estimates.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Lets users fill in stock demand estimates for many products and periods at once in a grid, instead of creating each estimate line by hand. Estimates can be tied to predefined date ranges, and a new Date Ranges menu is added under Inventory settings.

This module speeds up entering demand estimates in Odoo Inventory. A new menu entry "Create Stock Demand Estimates" opens a short wizard where you pick a period (from/to dates), a date range type, a location and one or more products. Pressing "Prepare" opens an estimate sheet: a grid with periods as columns and products as rows, where you type the expected quantity for each combination.

  • Existing estimates for the same product, period and location are pre-filled in the grid, so you can review and adjust them rather than starting from zero.
  • Pressing "Validate" creates new estimates or updates the quantities of existing ones, then shows the resulting list of stock demand estimates.
  • The wizard refuses to continue if the start date is after the end date, if no products are selected, or if no date ranges exist for the chosen type and period.

On the standard demand estimate screen, a new "Estimating Period" field links an estimate to a date range; the start date, end date and duration are then taken automatically from that range, and the record name shows the period, product and location. The list becomes editable directly in the grid, the pivot view can group by estimating period, and the search view can filter on it.

Date ranges now also show a computed "Days between dates" value, and a "Date Ranges" menu is added under Inventory configuration.

Depends on

stock_demand_estimateweb_widget_x2many_2d_matrixdate_range

Menus it adds

Date Rangesstock_demand_estimate_wizard_menu
Models and fields (5)
  • date.range · extends an existing modeldays (Days between dates)
  • stock.demand.estimate · extends an existing modeldate_range_id (Estimating Period)
  • stock.demand.estimate.sheet · new modeldate_end (Date to), line_ids (Estimates), company_id (Company), date_start (Date From), location_id (Location), product_ids (Products), date_range_type_id (Date Range Type)
  • stock.demand.estimate.wizard · new modeldate_end (Date To), company_id (Company), date_start (Date From), location_id (Location), product_ids (Products), date_range_type_id (Date Range Type)
  • stock.demand.estimate.sheet.line · new modelvalue_x (Period Name), value_y (Product Name), product_id (Product), estimate_id, location_id (Stock Location), product_uom (Unit of measure), date_range_id (Period), product_uom_qty (Quantity)

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 12.0

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

terminal Installation and usage

OCA documentation · Odoo 19.0

Installation

Source · Odoo 19.0

This module relies on:

  • The OCA module '2D matrix for x2many fields', and can be downloaded from Github:
  • The OCA module 'Date Range', and can be downloaded from Github:

Usage

Source · Odoo 19.0

Go to Inventory \> Configuration \> Date Ranges and define your estimating periods.

Go to Inventory \> Demand Planning \> Create Stock Demand Estimates to create or update your demand estimates.

Go to Inventory \> Demand Planning \> Stock Demand Estimates to review the estimates created.

No verified information in OCA: Configuration.

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.