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
- 会計
- 在庫
- PoS
- プロジェクト
- MRP
この質問にフラグが付けられました
3
返信
2519
ビュー
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
