I am trying to create a bom for a fence installation. The product is priced per linear foot. But for every 8 ft of fence, there's the additional cost of a post. When the bom is per foot, how do I include a post for every 8 ft?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilitat
- Inventari
- PoS
- Project
- MRP
This question has been flagged
You can use this module: https://github.com/BADEP/addons/tree/14.0/mrp_bom_variable_quantity. which will allow you to enter complex formulas with conditions in your BoM.
@Khalid .. This is awesome, will be interesting in learning about the module. Could you please guide on how to install on Enterprise db? Sorry am not a techie.. if required you could message me directly jaideepj@hotmail.com
Thanks
@Jaideep, the module is straightforward in its installation, you just need to copy it in your addons folder.
The module is pretty much inspired of OCA's contract_variable_quantity which allows you to enter a python formula to calculate the final component quantity depending on the production, the quantity and other variables.
In this particular case, assuming that he will always need a post at the start of the fence, the formula can be:
result = (quantity // 8) + 1
Thanks Khalid I get the below error while I try to import the module using studio
Error while importing module 'mrp_bom_variable_quantity'.
Module loading mrp_bom_variable_quantity failed: file /tmp/tmpsxn1vhd7/mrp_bom_variable_quantity/security/ir.model.access.csv could not be processed:
No matching record found for external id 'model_mrp_bom_line_formula' in field 'Model'
No matching record found for external id 'model_mrp_bom_line_formula' in field 'Model'
Missing required value for the field 'Model' (model_id)
Missing required value for the field 'Model' (model_id)
Make sure those modules are installed and try again.
y ou can set-up post
you can set-up post as a component with qty 0.125, and the unit rounding precision as 1.0
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se