BoM Variance
Planned vs actual material use on every finished order.
Planned qty · Actual qty · Variance · Over/under band · Per component · Per product
Odoo 19 $24.99 · OPL-1 9 Languages For Manufacturing TeamsHow much material did you over-consume last month?
Odoo tells you what each manufacturing order was supposed to consume and what it actually consumed — but only one order at a time. There is no single report that rolls the difference up across every finished order so you can see which components leak the most material, which products burn the most scrap, or whether last month's process change actually moved the numbers. BoM Variance adds a one-click report under Manufacturing → Reporting → BoM Variance that answers exactly that.
Without this module
Export the raw material moves, drop them into a spreadsheet, line each one up against the bill of materials, subtract the planned quantity by hand, then build a pivot — and do it all again next month. No one is ever quite sure which components leak the most.
With this module
Open BoM Variance, see the four over/under bands, click Heavy Over (15%+), and there are the offending components. The report always reflects your latest finished orders — nothing to schedule, nothing to refresh.
What it does
For each component on each finished order: the quantity the bill of materials planned, the quantity actually consumed, the difference, and that difference as a percentage.
Saved, on-target (within 5%), slight over (5-15%) and heavy over (15%+) — colour-coded badges so waste stands out at a glance everywhere in the report.
Opens on a pivot of component by variance. Switch to a bar graph by band, or a list view to drill down to each individual order behind the numbers.
Over-consumption only, extreme over (50%+), finished in the last 30 days, plus the four band chips — and group by component, finished product or category.
Only orders already marked done are counted, so the numbers stay steady for a postmortem review — work still in progress never muddies the picture.
A pure report — nothing is stored, no scheduled jobs, no changes to your data. Every time you open it, the variance reflects your latest finished orders.
How it works
The report compares the material each finished order actually consumed against the quantity its bill of materials planned — for every component on the order.
Only completed orders are counted. Drafts and in-progress orders are left out, so the variance you see is stable and safe to review after the fact.
Each line shows the variance quantity, the variance percentage and its over/under band. Pivot, graph and list all read the same numbers, always up to date.
See it in action
From the per-component pivot to the colour-coded drill-down list, here is the BoM Variance report on a real Manufacturing dataset.
Pivot: planned, actual and variance quantity totalled per component — the parts that leak the most material rise to the top.
Bar graph of total variance quantity by band — saved, on-target, slight over and heavy over at a glance.
List drill-down per component and order: colour-coded variance quantity, variance percentage, and a badge for the band.
Search filters: the four band chips plus over-consumption only, extreme over (50%+) and finished in the last 30 days.
Available in 9 Languages
Every field label, button and message ships fully translated. Each user sees the module in their own Odoo language setting — no extra setup.
English (en_US)
Français (fr)
Español (es)
Deutsch (de)
Nederlands (nl)
Português (Brasil)
Italiano (it)
中文 (zh_CN)
العربية (ar)
Honest scope
Variance is measured on orders already marked done. In-progress and draft orders are not included, so the report is built for review after production, not live shop-floor tracking.
It compares quantities consumed against the bill of materials — it does not price the variance or account for scrap valuation. Use it to find where material leaks, then cost it in your own currency.
Technical Details
| Odoo Version | 19.0 Community + Enterprise |
| License | OPL-1 |
| Version | 19.0.1.1.1 |
| Requires | Manufacturing |
| Applies To | Completed manufacturing orders |
| Data footprint | Read-only report — nothing stored |
| Runs On | Your own Odoo server — no external service or API |
Installation
1. Download from the Odoo App Store.
2. Extract to your Odoo addons directory.
3. Apps → Update Apps List → Install BoM Variance.
4. Manufacturing → Reporting → BoM Variance.
Found a bug?
Reach out via the Odoo App Store contact form.
BoM Variance — $24.99 USD, Odoo 19
© Naim OUDAYET — oudayet.com — OPL-1 license
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Manufacturing (mrp)
• Inventory (stock) • Discuss (mail) |
| Lines of code | 199 |
| Technical Name |
no_bom_variance |
| License | OPL-1 |
| Website | https://www.oudayet.com |
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