Hi everyone,
I would like to show the total availability of a certain product, stored in different warehouses, without having to scroll through the different warehouses. Any advice?
Deze vraag is gerapporteerd
2
Antwoorden
864
Weergaven
Hello,
Yes, this is possible in Odoo. You can view the total on-hand quantity across multiple warehouses through the product’s inventory reports or forecasted inventory view without manually checking each warehouse individually.
Depending on your workflow, this can also be optimized with grouped views, filters, or a small customization to display consolidated stock availability more clearly.
Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.
Regards,
Zehntech Technologies Inc.
That is clear to me, but I am looking for a solution to see availability directly on the product catalogue and in the SO creation window. Currently the available numbers are depending on the selection of warehouse in SO delivery setting.
Hi Lakhan,
Thanks for your response. I’m not seeing the aggregate total for the “On Hand” and “Forecasted” smart buttons. The availability icon (red/green) and pop-up availability calculations is depending on the choice of fulfilment warehouse chosen in the sales order (other information -> Delivery…) - which in real life means I have to know in which warehouse the goods are when making an order. When going into the previsions, I can of course select the different warehouses and see the availabilities in these warehouses, but that is not very user friendly.
Any other way to set this up?
Best regards
Lasse Brinck
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
2
apr. 26
|
720 | ||
|
1
okt. 25
|
6018 | ||
|
2
jan. 23
|
5424 | ||
|
1
dec. 20
|
3456 | ||
|
6
mei 19
|
9018 |
Hello
In Odoo, the "On Hand" and "Forecasted" smart buttons on the product form typically show the total stock across all internal locations by default.
If you aren't seeing the aggregate total, let me know here
Thanks
I’ll review if there’s any configuration or better workaround available for your use case and get back to you.
Dear Lasse,
Thank you for the clarification — that's a very specific and valid requirement.
What you're describing goes beyond standard Odoo configuration. In Odoo, the availability shown on the SO line and product catalogue is intentionally tied to the delivery warehouse selected on the order — so consolidated cross-warehouse stock visibility in those views isn't available out of the box.
To achieve what you need, the cleanest approach is a small module customization:
1. A computed field on product.product that aggregates qty_available across all warehouses/stock locations
2. A view extension to surface that field as a column in the product catalogue list view
3. An optional column in the SO line form so the consolidated figure is visible during order creation — alongside (not replacing) the warehouse-specific number
This is a straightforward Odoo module — typically 1–2 days of development (15-18 hours) — and it doesn't interfere with standard fulfillment logic, which still uses the per-warehouse quantity correctly.
If you'd like, we can discuss the exact scope and have a working prototype ready within a few days. Feel free to reach out directly.
Best Regards,
Santosh Sekwadia
santosh.sekwadia@zehntech.com
Maybe this module - https://apps.odoo.com/apps/modules/19.0/product_stock_balance - will be helpful to you