Skip to Content

Python formula in MO operation

Add a method to calculate Work Center hourly costs using Python.
257.73 € 257.73 € (Tax excluded)
US$ 300.00 (Tax excluded)

  • Versions
Terms and Conditions
30-day money-back guarantee
Shipping: 2-3 Business Days


ODOO'S FUNCTION

Default hourly cost in the work centers is fixed, so costing does not reflect variations in real operations.


CLUEDOO'S FUNCTION

CLuedoo provides Python code to calculate dynamic hourly cost in work center, allowing more flexible and accurate manufacturing order costing (e.g. based on shifts, overtime, or machine efficiency).


1. Go to Settings > Manufacturing > Tick: Work Orders, Shop Floor, Timer, Quality


2. Manufacturing > Work Centers > Create new or choose an existing one > Cost Field Type: Python Code > Fill in the formula that you would like to use

e.g., Python code Workcenter: result=66, Python Code Employee: result=44


3. Create new MO > Confirm > Click the Green button to start the work order

Note: Make sure you have set up the Work Center(s) in the product's BoM
4. Open the Work Order > Open Shop Floor > Check all conditions appear > Mark as Done > Close Production 
5. Go back to the MO > Actions button > Print > Cost Analysis
6. In the Cost Analysis Report, you will see that the Cost of Operations is calculated by the Python code that you set in the Work Center
7. Go to List view of MO, you can see that MRP's Components Cost, MRP's Operation Cost, and MRP's Unit Cost show the same result as in the Cost Analysis Report 

Note: to have those columns, install 3 dependent modules - fal_mrp_manufacturing_cost, fal_mrp_manufacturing_cost_formula &  fal_mrp_manufacturing_cost_subcontract