Supply vs Demand (Month-wise) - Purchases vs Deliveries
by SNM https://snmdigitechconsulting.com$ 49.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Purchase (purchase) • Sales (sale_management) • Invoicing (account) |
| Lines of code | 794 |
| Technical Name |
snm_supply_demand_report |
| License | OPL-1 |
| Website | https://snmdigitechconsulting.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Purchase (purchase) • Sales (sale_management) • Invoicing (account) |
| Lines of code | 794 |
| Technical Name |
snm_supply_demand_report |
| License | OPL-1 |
| Website | https://snmdigitechconsulting.com |
Supply vs Demand Report
Plan procurement and deliveries on one 18-month grid — incoming purchases vs outgoing sales, per product, with editable projections.
by SNM Digitech Consulting · snmdigitechconsulting.com
One product, eighteen months, at a glance
Every product gets On Hand opening stock, each Purchase Order and Sales Order on its own row, automatic Supply / Demand totals, and a running Accumulated balance — red when you are about to run short.
| Item | M1 | M2 | M3 | M4 | Total |
|---|---|---|---|---|---|
| [E-COM12] Desk Combination | |||||
| On Hand (Opening) | 120.00 | - | - | - | 120.00 |
| Azure Interior: P00042 | 80.00 | 0.00 | 60.00 | 0.00 | 140.00 |
| Total Supply | 80.00 | 0.00 | 60.00 | 0.00 | 140.00 |
| Deco Addict: S00031 | 40.00 | 90.00 | 75.00 | 50.00 | 255.00 |
| Total Demand | 40.00 | 90.00 | 75.00 | 50.00 | 255.00 |
| Accumulated | 160.00 | 70.00 | 55.00 | 5.00 | - |
Live editable grid — green Accumulated means healthy stock, red warns of an upcoming shortage. (Illustration uses standard Odoo demo data.)
Stop guessing your stock position
Spreadsheets go stale the moment you save them. Supply vs Demand Report reads your real purchase receipts and delivery orders straight from Odoo and lays them out month by month for the next 18 months. See exactly when incoming supply covers outgoing demand, layer in your own Suggested Purchases and Projected Sales, annotate any row with a remark, then hand it to your team as a polished Excel or PDF.
Key features
18-month rolling matrix
M1–M12 cover the current year and M13–M18 the first half of next year, so you always see two planning horizons at once.
Real Odoo data, per order
Each Purchase Order and Sales Order appears on its own row, grouped by product, using scheduled receipt and delivery dates — no manual entry.
Editable projections
Editors can add Suggested Purchase and Projected Sales quantities and remarks that survive every regenerate — your assumptions are never lost.
Automatic balances
On Hand opening stock, Total Supply, Total Demand, Remaining and a running Accumulated balance are all computed for you and colour-coded.
One click from the product list
A PO/SO button on the stock product list opens (or builds) the plan for that product instantly.
Excel & PDF export
Download a fully formatted Excel workbook or a landscape PDF, ready to share with management or suppliers.
Role-based access
Two security groups: User (read-only) and Editor (regenerate, edit projections, add remarks).
Multi-company aware
Reports are scoped to a company, so figures always reflect the right warehouse and order book.
How to use it - 3 easy steps
- Generate a report. Go to Purchase > Supply vs Demand > Generate Report, pick one or more products, and confirm.
- Review the grid. Read the 18-month matrix of supply vs demand, add Suggested Purchase / Projected Sales figures, and jot remarks where useful. Hit Regenerate any time to refresh from live orders — your projections and notes are preserved.
- Share it. Click Export Excel or Export PDF, or open it straight from a product via the PO/SO button in the stock product list.
Installation
- Copy the
snm_supply_demand_reportfolder into your Odoo add-ons path. - Open Apps and click Update Apps List.
- Search for Supply vs Demand and click Install.
Depends on the standard Inventory,
Purchase and Sales apps. Excel export uses the
xlsxwriter library bundled with Odoo.
Compatibility
Odoo 19.0 — Community & Enterprise.
SNM Digitech Consulting
We build practical, beautifully finished Odoo apps and deliver end-to-end Odoo implementation, customization, migration and support. From a single tweak to a full ERP roll-out, our team turns your process into clean, reliable software.
Visit snmdigitechconsulting.com
Questions, custom features or a demo? Email hello@snmdigitechconsulting.com — we reply fast and we love a challenge.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module