Odoo Help


Quote from BOM and routing estimates

Michael Watchorn
on 11/3/13, 11:20 PM 3,723 views

Is there a way to generate a Sales Quotation from a BOM, by summing up the material cost + ((estimated time) x (workcenter cost))?
We often receive drawings of the product from the potential customer, and we must quote on manufacturing this product (there is no pricelist, and no fixed cost for us to markup). These products are typically one-offs (prototypes), so we haven't built it before and don't know how much it will cost.
A customer asks me to quote on a product for him (a chair), he provides me with a set of drawings, for me to manufacture and assemble. He will buy the finished chair from me. He includes drawings for: a chair leg, a seat, a chair back, and a finished chair assembly.
I create 4 products, each with their own BOM and Routings:
(1) I create a product including BOM and Routing for a leg.
(2) I create a product including BOM and Routing for a seat.
(3) I create a product including BOM and Routing for a back.
(4) I create a product including BOM (consisting of 4 legs, 1 seat, and 1 back), and Routing directing my staff how to assemble the chair.
I do not wish to manufacture the product yet. I just want a cost buildup.
I want to run a report (preferably include the finished chair as a line in the quotation) which produces the estimated cost based on the products I have defined and the work I expect it would take. It would need to be recursive because it would need to dig into each subproduct and examine if it contains any other manufactured parts and dig in to those if need be. Ideally it would also calculate the lead times for any material I need to purchase.
I have read through the Streamline your Manufacturing Process with OpenERP book, and could not find anything that explained how to get this estimated cost buildup.


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 11/4/13, 12:09 AM

Have you seen https://www.openerp.com/apps/trunk/product_cost_incl_bom/

Compute product cost price by recursively summing parts cost prices according to product BOM. It takes into account the BoM costing (cost per cycle and so...).

Providing you do everything you have written above correctly, this will produce a BoM Cost amount on the product, so when you create a quote for it you can use it as the basis for a sales price.

Michael Watchorn
On 11/4/13, 12:23 AM

Thanks Ray's post above and klass vortex's earlier question(and self-answer) : "I did find the thing I was looking for, it was not where I expect it to be ;-) It is in Warehouse-product. Select Complex Product (which has a Bom) Now use [PRINT][PRODUCT COST STRUCTURE] and there it is !"

I've installed product_cost_incl_bom, and the products all show their costs on the products tree view, except the parent top level chair product. However the report still shows $0.00 for the subproducts, but shows the $ value for top level parent chair (no change there). Any idea what could be causing a product to not get it's cost_price updated? (And why the subproducts aren't getting updated in the report?)

Michael Watchorn
on 11/4/13, 1:18 AM

I had missed the change to line 68 in price.py, now that works for the material. For anyone else who wants the BOM cost see klass vortex's question #14109 search for mrp-cost-price-calculation-on-bom.

Any suggestions on why the workcenter costs are not showing up in the cost_price field? The workcenter costs do show up in the PRODUCT COST STRUCTURE pdf report, but not in the product's cost_price(incl BOM) field.

Michael Watchorn
on 11/4/13, 12:17 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/3/13, 11:20 PM
Seen: 3723 times
Last updated: 3/16/15, 8:10 AM