OdooWiki OCA HUB

Stock Report Quantity By Location

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

This module adds an additional reporting on Inventory side where warehouse location quantities are shown by all stockable products.

auto_awesome What this module does

AI-generated from the code · Odoo 16.0

Adds an Inventory report that shows, for each product and each selected warehouse location, the quantity on hand, the quantity reserved and the quantity unreserved. Users pick the locations in a small wizard and then view the results in a list or pivot table.

This module adds a new report under Inventory > Reporting > Inventory by Location (visible to inventory managers).

When you open it, a small window asks you to choose one or more locations and whether to show only products that have quantity on hand. Pressing "Retrieve the Inventory Quantities" builds the report.

For every storable product and every selected location (including sub-locations), the report shows: - Qty On Hand: the quantity currently in that location. - Qty Reserved: the quantity already promised to outgoing operations. - Qty Unreserved: on hand minus reserved, i.e. what is still free to use.

Results appear in a list and in a pivot table where products are rows and locations are columns, so you can compare stock across warehouses at a glance. You can search by product, internal reference, location or product category, filter on "Quantity On Hand > 0", and group by location.

The report is built from stock quantities and is read-only; it does not change any stock. It relies on the standard product and stock modules.

Depends on

productstock

Menus it adds

Inventory by Location
Models and fields (2)
  • stock.report.quantity.by.location · new modeluom_id (Product UoM), wiz_id, product_id, location_id, default_code (Internal Reference), quantity_on_hand (Qty On Hand), quantity_reserved (Qty Reserved), product_category_id (Product Category), quantity_unreserved (Qty Unreserved)
  • stock.report.quantity.by.location.prepare · new modelavailability, location_ids (Locations), with_quantity (Quantity > 0)

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

Sources · Odoo 16.0

Confirmed on 2026-11-03 in branch 16.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.