Skip to Content
Menú
This question has been flagged
3 Respostes
2400 Vistes

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?

Avatar
Descartar
Best Answer

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.

Avatar
Descartar

@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.

Best Answer

y ou can set-up post 

Avatar
Descartar
Best Answer

you can set-up post as a component with qty 0.125, and the unit rounding precision as 1.0

Avatar
Descartar