Sales On-hand Quantity on Sale Order Lines & Catalog
Two columns on every quotation line, On Hand (warehouse) and On Hand (all), and the same information on the product catalog cards. The salesperson sees what the branch can deliver before promising it.
Odoo 19 app by Mina Adel, software engineer and Odoo developer
The problem
Salespeople confirm quantities the local warehouse does not have, then chase transfers or apologise to the customer.
The solution
The order lines and the catalog show the stock of the order's warehouse and the company total, computed live from stock quants.
What you get
-
Warehouse quantity
On hand in the warehouse chosen on the order, per line.
-
Company total
On hand across all warehouses, per line, to decide on inter-warehouse transfers.
-
Catalog cards
The product catalog opened from a quotation shows the order warehouse's stock on every card.
-
Live and accurate
Standard Odoo quantities, recomputed as the product or the warehouse changes.
-
Optional columns
Both columns are optional in the list; hide them for users who do not need them.
-
No data, no settings
Computed fields only; uninstall leaves nothing behind.
How to use it
- Create a quotation and pick the warehouse (Other Info tab; the user's default is used otherwise).
- Add products: the two On Hand columns fill in for storable products.
- Open Catalog to see the same quantities while browsing.
Screenshots
Questions
Which quantity is it?
Odoo's on-hand quantity (qty_available) restricted to the warehouse's locations, or to the whole company for the total column.
Does it work with multiple warehouses per company?
Yes, that is the point: the warehouse column follows the order's warehouse.
Community or Enterprise?
Both, Odoo 19.0, with Sales and Inventory installed.
Support
Questions before buying, a bug, or an idea for the next version? Email me — bug fixes for Odoo 19.0 are included.
More Odoo apps
All apps
$15 Sales / Point of Sale
Minimum Selling Price: Sales & POS Guard
Minimum selling price per product; Sales blocks lower lines and the POS numpad refuses a lower price
Odoo 19.0 · Community & Enterprise View on Odoo Apps Store
$15 Sales / Purchase
Discount Amount on Sale & Purchase Lines
Discount as an amount on sale and purchase lines, plus a wizard to spread a total discount over all lines
Odoo 19.0 · Community & Enterprise View on Odoo Apps Store
$1 Accounting
General Ledger: Opening, Period Total & Closing per Account
Initial balance, period movements, period total and closing balance under every account
Odoo 19.0 · Enterprise View on Odoo Apps Store