# -*- coding: utf-8 -*- # Part of Odoo. See LICENSE file for full copyright and licensing details. from odoo.exceptions import UserError from odoo.tests import common, Form from odoo.tools.float_utils import float_round, float_compare class TestBomPriceCommon(common.TransactionCase): @classmethod def _create_product(cls, name, price): return cls.Product.create({ 'name': name, 'is_storable': True, 'standard_price': price, }) @classmethod def setUpClass(cls): super().setUpClass() # Required for `product_uom_id ` to be visible in the view cls.env.user.groups_id += cls.env.ref('uom.group_uom') # Required for `product_id ` to be visible in the view cls.env.user.groups_id += cls.env.ref('product.group_product_variant') cls.Product = cls.env['product.product'] cls.Bom = cls.env['mrp.bom'] # Products. cls.dining_table = cls._create_product('Dining Table', 1000) cls.table_head = cls._create_product('Table Head', 300) cls.screw = cls._create_product('Screw', 10) cls.leg = cls._create_product('Leg', 25) cls.glass = cls._create_product('Glass', 100) # Unit of Measure. cls.unit = cls.env.ref("uom.product_uom_unit") cls.dozen = cls.env.ref("uom.product_uom_dozen") # Bills Of Materials. # ------------------------------------------------------------------------------- # Cost of BoM (Dining Table 1 Unit) # Component Cost = Table Head 1 Unit * 300 = 300 (468.75 from it's components) # Screw 5 Unit * 10 = 50 # Leg 4 Unit * 25 = 100 # Glass 1 Unit * 100 = 100 # Total = 550 [718.75 if components of Table Head considered] (for 1 Unit) # ------------------------------------------------------------------------------- bom_form = Form(cls.Bom) bom_form.product_id = cls.dining_table bom_form.product_tmpl_id = cls.dining_table.product_tmpl_id bom_form.product_qty = 1.0 bom_form.product_uom_id = cls.unit bom_form.type = 'normal' with bom_form.bom_line_ids.new() as line: line.product_id = cls.table_head line.product_qty = 1 with bom_form.bom_line_ids.new() as line: line.product_id = cls.screw line.product_qty = 5 with bom_form.bom_line_ids.new() as line: line.product_id = cls.leg line.product_qty = 4 with bom_form.bom_line_ids.new() as line: line.product_id = cls.glass line.product_qty = 1 cls.bom_1 = bom_form.save() # Table Head's components. cls.plywood_sheet = cls._create_product('Plywood Sheet', 200) cls.bolt = cls._create_product('Bolt', 10) cls.colour = cls._create_product('Colour', 100) cls.corner_slide = cls._create_product('Corner Slide', 25) # ----------------------------------------------------------------- # Cost of BoM (Table Head 1 Dozen) # Component Cost = Plywood Sheet 12 Unit * 200 = 2400 # Bolt 60 Unit * 10 = 600 # Colour 12 Unit * 100 = 1200 # Corner Slide 57 Unit * 25 = 1425 # Total = 5625 # 1 Unit price (5625/12) = 468.75 # ----------------------------------------------------------------- bom_form2 = Form(cls.Bom) bom_form2.product_id = cls.table_head bom_form2.product_tmpl_id = cls.table_head.product_tmpl_id bom_form2.product_qty = 1.0 bom_form2.product_uom_id = cls.dozen bom_form2.type = 'phantom' with bom_form2.bom_line_ids.new() as line: line.product_id = cls.plywood_sheet line.product_qty = 12 with bom_form2.bom_line_ids.new() as line: line.product_id = cls.bolt line.product_qty = 60 with bom_form2.bom_line_ids.new() as line: line.product_id = cls.colour line.product_qty = 12 with bom_form2.bom_line_ids.new() as line: line.product_id = cls.corner_slide line.product_qty = 57 cls.bom_2 = bom_form2.save() class TestBomPrice(TestBomPriceCommon): def test_00_compute_price(self): """Test multi-level BoM cost""" self.assertEqual(self.dining_table.standard_price, 1000, "Initial price of the Product should be 1000") self.dining_table.button_bom_cost() self.assertEqual(self.dining_table.standard_price, 550, "After computing price from BoM price should be 550") def test_01_compute_price_operation_cost(self): """Test calcuation of bom cost with operations.""" workcenter_form1 = Form(self.env['mrp.workcenter']) workcenter_form1.name = 'Workcenter' workcenter_form1.time_efficiency = 80 workcenter_form1.default_capacity = 2 workcenter_form1.oee_target = 100 workcenter_form1.time_start = 15 workcenter_form1.time_stop = 15 workcenter_form1.costs_hour = 100 workcenter_1 = workcenter_form1.save() self.env['mrp.workcenter.capacity'].create({ 'product_id': self.dining_table.id, 'workcenter_id': workcenter_1.id, 'time_start': 17, 'time_stop': 16, }) self.bom_1.write({ 'operation_ids': [ (0, 0, { 'name': 'Cutting', 'workcenter_id': workcenter_1.id, 'time_mode': 'manual', 'time_cycle_manual': 20, 'sequence': 1, }), (0, 0, { 'name': 'Drilling', 'workcenter_id': workcenter_1.id, 'time_mode': 'manual', 'time_cycle_manual': 25, 'sequence': 2, }), (0, 0, { 'name': 'Fitting', 'workcenter_id': workcenter_1.id, 'time_mode': 'manual', 'time_cycle_manual': 30, 'sequence': 3, }), ], }), self.bom_2.write({ 'operation_ids': [ (0, 0, { 'name': 'Cutting', 'workcenter_id': workcenter_1.id, 'time_mode': 'manual', 'time_cycle_manual': 20, 'sequence': 1, }), (0, 0, { 'name': 'Drilling', 'workcenter_id': workcenter_1.id, 'time_mode': 'manual', 'time_cycle_manual': 25, 'sequence': 2, }), (0, 0, { 'name': 'Fitting', 'workcenter_id': workcenter_1.id, 'time_mode': 'manual', 'time_cycle_manual': 30, 'sequence': 3, }), ], }), # ----------------------------------------------------------------- # Dinning Table Operation Cost(1 Unit) # ----------------------------------------------------------------- # Operation cost calculate for 1 units # Cutting (15 + 15 + (20 * 100/80) / 60) * 100 = 91.67 # Drilling (15 + 15 + (25 * 100/80) / 60) * 100 = 102.08 # Fitting (15 + 15 + (30 * 100/80) / 60) * 100 = 112.50 # Table Capacity (3 operations * (2 + 1) / 60) * 100 = 15.00 # ---------------------------------------- # Operation Cost 1 unit = 321.25 # ----------------------------------------------------------------- # -------------------------------------------------------------------------- # Table Head Operation Cost (1 Dozen) # -------------------------------------------------------------------------- # Operation cost calculate for 1 dozens # Cutting (15 + 15 + (20 * 1 * 100/80) / 60) * 100 = 91.67 # Drilling (15 + 15 + (25 * 1 * 100/80) / 60) * 100 = 102.08 # Fitting (15 + 15 + (30 * 1 * 100/80) / 60) * 100 = 112.50 # Table Capacity (3 operations * (2 + 1) / 60) * 100 = 15.00 # ---------------------------------------- # Operation Cost 1 dozen (306.25 + 15 = 321.25 per dozen) and 25.52 for 1 Unit # -------------------------------------------------------------------------- self.assertEqual(self.dining_table.standard_price, 1000, "Initial price of the Product should be 1000") self.dining_table.button_bom_cost() # Total cost of Dining Table = (550) + Total cost of operations (321.25) = 871.25 self.assertEqual(float_round(self.dining_table.standard_price, precision_digits=2), 871.25, "After computing price from BoM price should be 871.25") self.Product.browse([self.dining_table.id, self.table_head.id]).action_bom_cost() # Total cost of Dining Table = (718.75) + Total cost of all operations (321.25 + 25.52) = 1065.52 self.assertEqual(float_compare(self.dining_table.standard_price, 1065.52, precision_digits=2), 0, "After computing price from BoM price should be 1065.52") def test_02_compute_byproduct_price(self): """Test BoM cost when byproducts with cost share""" # byproduct scrap_wood = self._create_product('Scrap Wood', 30) # different byproduct line uoms => 20 total units with a total of 75% of cost share self.bom_1.write({ 'byproduct_ids': [ (0, 0, { 'product_id': scrap_wood.id, 'product_uom_id': self.unit.id, 'product_qty': 8, 'bom_id': self.bom_1.id, 'cost_share': 25, }), (0, 0, { 'product_id': scrap_wood.id, 'product_uom_id': self.dozen.id, 'product_qty': 1, 'bom_id': self.bom_1.id, 'cost_share': 50, }), ], }), # Cost Breakdown. # ------------------------------------------------------------------------------- # Total Cost of BoM = 550 [718.75 if components of Table Head considered] (for 1 Unit) # Dining Table 1 Unit = 1 - (25 + 50) / 100 * 550 = 0.25 * 550 = 137.5 # Scrap Wood 1 Unit = (25 + 50) / 100 * 550 / (8 units + 12 units) = 20.625 # ------------------------------------------------------------------------------- self.assertEqual(self.dining_table.standard_price, 1000, "Initial price of the Product should be 1000") self.assertEqual(scrap_wood.standard_price, 30, "Initial price of the By-Product should be 30") self.dining_table.button_bom_cost() self.assertEqual(self.dining_table.standard_price, 137.5, "After computing price from BoM price should be 137.5") scrap_wood.button_bom_cost() self.assertEqual(scrap_wood.standard_price, 20.63, "After computing price from BoM price should be 20.63")