# -*- coding: utf-8 -*- # Part of Odoo. See LICENSE file for full copyright and licensing details. import unittest from odoo.addons.stock_landed_costs.tests.common import TestStockLandedCostsCommon from odoo.addons.stock_landed_costs.tests.test_stockvaluationlayer import TestStockValuationLCCommon from odoo.addons.stock_account.tests.test_stockvaluation import _create_accounting_data from odoo import fields from odoo.fields import Command, Date from odoo.tests import tagged, Form @tagged('post_install', '-at_install') class TestLandedCosts(TestStockLandedCostsCommon): @classmethod def setUpClass(cls): super().setUpClass() # Create picking incoming shipment cls.picking_in = cls.Picking.create({ 'partner_id': cls.supplier_id, 'picking_type_id': cls.warehouse.in_type_id.id, 'location_id': cls.supplier_location_id, 'state': 'draft', 'location_dest_id': cls.warehouse.lot_stock_id.id}) cls.Move.create({ 'name': cls.product_refrigerator.name, 'product_id': cls.product_refrigerator.id, 'product_uom_qty': 5, 'product_uom': cls.product_refrigerator.uom_id.id, 'picking_id': cls.picking_in.id, 'location_id': cls.supplier_location_id, 'location_dest_id': cls.warehouse.lot_stock_id.id}) cls.Move.create({ 'name': cls.product_oven.name, 'product_id': cls.product_oven.id, 'product_uom_qty': 10, 'product_uom': cls.product_oven.uom_id.id, 'picking_id': cls.picking_in.id, 'location_id': cls.supplier_location_id, 'location_dest_id': cls.warehouse.lot_stock_id.id}) # Create picking outgoing shipment cls.picking_out = cls.Picking.create({ 'partner_id': cls.customer_id, 'picking_type_id': cls.warehouse.out_type_id.id, 'location_id': cls.warehouse.lot_stock_id.id, 'state': 'draft', 'location_dest_id': cls.customer_location_id}) cls.Move.create({ 'name': cls.product_refrigerator.name, 'product_id': cls.product_refrigerator.id, 'product_uom_qty': 2, 'product_uom': cls.product_refrigerator.uom_id.id, 'picking_id': cls.picking_out.id, 'location_id': cls.warehouse.lot_stock_id.id, 'location_dest_id': cls.customer_location_id}) def test_00_landed_costs_on_incoming_shipment(self): """ Test landed cost on incoming shipment """ # # (A) Purchase product # Services Quantity Weight Volume # ----------------------------------------------------- # 1. Refrigerator 5 10 1 # 2. Oven 10 20 1.5 # (B) Add some costs on purchase # Services Amount Split Method # ------------------------------------------- # 1.labour 10 By Equal # 2.brokerage 150 By Quantity # 3.transportation 250 By Weight # 4.packaging 20 By Volume self.landed_cost.categ_id.property_valuation = 'real_time' # Process incoming shipment income_ship = self._process_incoming_shipment() # Create landed costs stock_landed_cost = self._create_landed_costs({ 'equal_price_unit': 10, 'quantity_price_unit': 150, 'weight_price_unit': 250, 'volume_price_unit': 20}, income_ship) # Compute landed costs stock_landed_cost.compute_landed_cost() valid_vals = { 'equal': 5.0, 'by_quantity_refrigerator': 50.0, 'by_quantity_oven': 100.0, 'by_weight_refrigerator': 50.0, 'by_weight_oven': 200, 'by_volume_refrigerator': 5.0, 'by_volume_oven': 15.0} # Check valuation adjustment line recognized or not self._validate_additional_landed_cost_lines(stock_landed_cost, valid_vals) # Validate the landed cost. stock_landed_cost.button_validate() self.assertRecordValues(stock_landed_cost.account_move_id.line_ids, [ {'name': 'equal split - Refrigerator', 'balance': 5}, {'name': 'equal split - Refrigerator', 'balance': -5}, {'name': 'split by quantity - Refrigerator', 'balance': 50}, {'name': 'split by quantity - Refrigerator', 'balance': -50}, {'name': 'split by weight - Refrigerator', 'balance': 50}, {'name': 'split by weight - Refrigerator', 'balance': -50}, {'name': 'split by volume - Refrigerator', 'balance': 5}, {'name': 'split by volume - Refrigerator', 'balance': -5}, {'name': 'equal split - Microwave Oven', 'balance': 5}, {'name': 'equal split - Microwave Oven', 'balance': -5}, {'name': 'split by quantity - Microwave Oven', 'balance': 100}, {'name': 'split by quantity - Microwave Oven', 'balance': -100}, {'name': 'split by weight - Microwave Oven', 'balance': 200}, {'name': 'split by weight - Microwave Oven', 'balance': -200}, {'name': 'split by volume - Microwave Oven', 'balance': 15}, {'name': 'split by volume - Microwave Oven', 'balance': -15}, ]) def test_00_landed_costs_on_incoming_shipment_without_real_time(self): if self.env.company.chart_template != 'generic_coa': raise unittest.SkipTest('Skip this test as it works only with `generic_coa`') # Test landed cost on incoming shipment # # (A) Purchase product # Services Quantity Weight Volume # ----------------------------------------------------- # 1. Refrigerator 5 10 1 # 2. Oven 10 20 1.5 # (B) Add some costs on purchase # Services Amount Split Method # ------------------------------------------- # 1.labour 10 By Equal # 2.brokerage 150 By Quantity # 3.transportation 250 By Weight # 4.packaging 20 By Volume self.product_refrigerator.write({"categ_id": self.categ_manual_periodic.id}) self.product_oven.write({"categ_id": self.categ_manual_periodic.id}) # Process incoming shipment income_ship = self._process_incoming_shipment() # Create landed costs stock_landed_cost = self._create_landed_costs({ 'equal_price_unit': 10, 'quantity_price_unit': 150, 'weight_price_unit': 250, 'volume_price_unit': 20}, income_ship) # Compute landed costs stock_landed_cost.compute_landed_cost() valid_vals = { 'equal': 5.0, 'by_quantity_refrigerator': 50.0, 'by_quantity_oven': 100.0, 'by_weight_refrigerator': 50.0, 'by_weight_oven': 200, 'by_volume_refrigerator': 5.0, 'by_volume_oven': 15.0} # Check valuation adjustment line recognized or not self._validate_additional_landed_cost_lines(stock_landed_cost, valid_vals) # Validate the landed cost. stock_landed_cost.button_validate() self.assertFalse(stock_landed_cost.account_move_id) def test_01_negative_landed_costs_on_incoming_shipment(self): """ Test negative landed cost on incoming shipment """ # # (A) Purchase Product # Services Quantity Weight Volume # ----------------------------------------------------- # 1. Refrigerator 5 10 1 # 2. Oven 10 20 1.5 # (B) Sale refrigerator's part of the quantity # (C) Add some costs on purchase # Services Amount Split Method # ------------------------------------------- # 1.labour 10 By Equal # 2.brokerage 150 By Quantity # 3.transportation 250 By Weight # 4.packaging 20 By Volume # (D) Decrease cost that already added on purchase # (apply negative entry) # Services Amount Split Method # ------------------------------------------- # 1.labour -5 By Equal # 2.brokerage -50 By Quantity # 3.transportation -50 By Weight # 4.packaging -5 By Volume self.landed_cost.categ_id.property_valuation = 'real_time' # Process incoming shipment income_ship = self._process_incoming_shipment() # Refrigerator outgoing shipment. self._process_outgoing_shipment() # Apply landed cost for incoming shipment. stock_landed_cost = self._create_landed_costs({ 'equal_price_unit': 10, 'quantity_price_unit': 150, 'weight_price_unit': 250, 'volume_price_unit': 20}, income_ship) # Compute landed costs stock_landed_cost.compute_landed_cost() valid_vals = { 'equal': 5.0, 'by_quantity_refrigerator': 50.0, 'by_quantity_oven': 100.0, 'by_weight_refrigerator': 50.0, 'by_weight_oven': 200.0, 'by_volume_refrigerator': 5.0, 'by_volume_oven': 15.0} # Check valuation adjustment line recognized or not self._validate_additional_landed_cost_lines(stock_landed_cost, valid_vals) # Validate the landed cost. stock_landed_cost.button_validate() self.assertTrue(stock_landed_cost.account_move_id, 'Landed costs should be available account move lines') # Create negative landed cost for previously incoming shipment. stock_negative_landed_cost = self._create_landed_costs({ 'equal_price_unit': -5, 'quantity_price_unit': -50, 'weight_price_unit': -50, 'volume_price_unit': -5}, income_ship) # Compute negative landed costs stock_negative_landed_cost.compute_landed_cost() valid_vals = { 'equal': -2.5, 'by_quantity_refrigerator': -16.67, 'by_quantity_oven': -33.33, 'by_weight_refrigerator': -10.00, 'by_weight_oven': -40.00, 'by_volume_refrigerator': -1.25, 'by_volume_oven': -3.75} # Check valuation adjustment line recognized or not self._validate_additional_landed_cost_lines(stock_negative_landed_cost, valid_vals) # Validate the landed cost. stock_negative_landed_cost.button_validate() self.assertEqual(stock_negative_landed_cost.state, 'done', 'Negative landed costs should be in done state') self.assertTrue(stock_negative_landed_cost.account_move_id, 'Landed costs should be available account move lines') [balance] = self.env['account.move.line']._read_group( [('move_id', '=', stock_negative_landed_cost.account_move_id.id)], aggregates=['balance:sum'])[0] self.assertEqual(balance, 0, 'Move is not balanced') move_lines = [ {'name': 'split by volume - Microwave Oven', 'debit': 3.75, 'credit': 0.0}, {'name': 'split by volume - Microwave Oven', 'debit': 0.0, 'credit': 3.75}, {'name': 'split by weight - Microwave Oven', 'debit': 40.0, 'credit': 0.0}, {'name': 'split by weight - Microwave Oven', 'debit': 0.0, 'credit': 40.0}, {'name': 'split by quantity - Microwave Oven', 'debit': 33.33, 'credit': 0.0}, {'name': 'split by quantity - Microwave Oven', 'debit': 0.0, 'credit': 33.33}, {'name': 'equal split - Microwave Oven', 'debit': 2.5, 'credit': 0.0}, {'name': 'equal split - Microwave Oven', 'debit': 0.0, 'credit': 2.5}, {'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.5, 'credit': 0.0}, {'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 0.5}, {'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 4.0, 'credit': 0.0}, {'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 4.0}, {'name': 'split by weight - Refrigerator', 'debit': 0.0, 'credit': 10.0}, {'name': 'split by weight - Refrigerator', 'debit': 10.0, 'credit': 0.0}, {'name': 'split by volume - Refrigerator', 'debit': 0.0, 'credit': 1.25}, {'name': 'split by volume - Refrigerator', 'debit': 1.25, 'credit': 0.0}, {'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 6.67, 'credit': 0.0}, {'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 6.67}, {'name': 'split by quantity - Refrigerator', 'debit': 16.67, 'credit': 0.0}, {'name': 'split by quantity - Refrigerator', 'debit': 0.0, 'credit': 16.67}, {'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 1.0, 'credit': 0.0}, {'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 1.0}, {'name': 'equal split - Refrigerator', 'debit': 2.5, 'credit': 0.0}, {'name': 'equal split - Refrigerator', 'debit': 0.0, 'credit': 2.5} ] if stock_negative_landed_cost.account_move_id.company_id.anglo_saxon_accounting: move_lines += [ {'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.5, 'credit': 0.0}, {'name': 'split by volume - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 0.5}, {'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 4.0, 'credit': 0.0}, {'name': 'split by weight - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 4.0}, {'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 6.67, 'credit': 0.0}, {'name': 'split by quantity - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 6.67}, {'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 1.0, 'credit': 0.0}, {'name': 'equal split - Refrigerator: 2.0 already out', 'debit': 0.0, 'credit': 1.0}, ] self.assertRecordValues( stock_negative_landed_cost.account_move_id.line_ids.sorted(lambda d: (d['name'], d['debit'])), sorted(move_lines, key=lambda d: (d['name'], d['debit'])), ) def _process_incoming_shipment(self): """ Two product incoming shipment. """ # Confirm incoming shipment. self.picking_in.action_confirm() # Transfer incoming shipment self.picking_in.button_validate() return self.picking_in def _process_outgoing_shipment(self): """ One product Outgoing shipment. """ # Confirm outgoing shipment. self.picking_out.action_confirm() # Product assign to outgoing shipments self.picking_out.action_assign() # Transfer picking. self.picking_out.button_validate() def _create_landed_costs(self, value, picking_in): return self.LandedCost.create(dict( picking_ids=[(6, 0, [picking_in.id])], account_journal_id=self.expenses_journal.id, cost_lines=[ (0, 0, { 'name': 'equal split', 'split_method': 'equal', 'price_unit': value['equal_price_unit'], 'product_id': self.landed_cost.id}), (0, 0, { 'name': 'split by quantity', 'split_method': 'by_quantity', 'price_unit': value['quantity_price_unit'], 'product_id': self.brokerage_quantity.id}), (0, 0, { 'name': 'split by weight', 'split_method': 'by_weight', 'price_unit': value['weight_price_unit'], 'product_id': self.transportation_weight.id}), (0, 0, { 'name': 'split by volume', 'split_method': 'by_volume', 'price_unit': value['volume_price_unit'], 'product_id': self.packaging_volume.id}) ], )) def _validate_additional_landed_cost_lines(self, stock_landed_cost, valid_vals): for valuation in stock_landed_cost.valuation_adjustment_lines: add_cost = valuation.additional_landed_cost split_method = valuation.cost_line_id.split_method product = valuation.move_id.product_id if split_method == 'equal': self.assertEqual(add_cost, valid_vals['equal'], self._error_message(valid_vals['equal'], add_cost)) elif split_method == 'by_quantity' and product == self.product_refrigerator: self.assertEqual(add_cost, valid_vals['by_quantity_refrigerator'], self._error_message(valid_vals['by_quantity_refrigerator'], add_cost)) elif split_method == 'by_quantity' and product == self.product_oven: self.assertEqual(add_cost, valid_vals['by_quantity_oven'], self._error_message(valid_vals['by_quantity_oven'], add_cost)) elif split_method == 'by_weight' and product == self.product_refrigerator: self.assertEqual(add_cost, valid_vals['by_weight_refrigerator'], self._error_message(valid_vals['by_weight_refrigerator'], add_cost)) elif split_method == 'by_weight' and product == self.product_oven: self.assertEqual(add_cost, valid_vals['by_weight_oven'], self._error_message(valid_vals['by_weight_oven'], add_cost)) elif split_method == 'by_volume' and product == self.product_refrigerator: self.assertEqual(add_cost, valid_vals['by_volume_refrigerator'], self._error_message(valid_vals['by_volume_refrigerator'], add_cost)) elif split_method == 'by_volume' and product == self.product_oven: self.assertEqual(add_cost, valid_vals['by_volume_oven'], self._error_message(valid_vals['by_volume_oven'], add_cost)) def _error_message(self, actucal_cost, computed_cost): return 'Additional Landed Cost should be %s instead of %s' % (actucal_cost, computed_cost) @tagged('post_install', '-at_install') class TestLandedCostsWithPurchaseAndInv(TestStockValuationLCCommon): def test_invoice_after_lc(self): self.env.company.anglo_saxon_accounting = True self.product1.product_tmpl_id.categ_id.property_cost_method = 'fifo' self.product1.product_tmpl_id.categ_id.property_valuation = 'real_time' stock_valuation_account = self.company_data['default_account_stock_valuation'] # Create PO po_form = Form(self.env['purchase.order']) po_form.partner_id = self.env['res.partner'].create({'name': 'vendor'}) with po_form.order_line.new() as po_line: po_line.product_id = self.product1 po_line.product_qty = 1 po_line.price_unit = 455.0 order = po_form.save() order.button_confirm() # Receive the goods receipt = order.picking_ids[0] receipt.move_ids.quantity = 1 receipt.button_validate() # Check SVL and AML svl = self.env['stock.valuation.layer'].search([('stock_move_id', '=', receipt.move_ids.id)]) self.assertAlmostEqual(svl.value, 455) aml = self.env['account.move.line'].search([('account_id', '=', stock_valuation_account.id)]) self.assertAlmostEqual(aml.debit, 455) # Create and validate LC lc = self.env['stock.landed.cost'].create(dict( picking_ids=[(6, 0, [receipt.id])], account_journal_id=self.stock_journal.id, cost_lines=[ (0, 0, { 'name': 'equal split', 'split_method': 'equal', 'price_unit': 99, 'product_id': self.productlc1.id, }), ], )) lc.compute_landed_cost() lc.button_validate() # Check LC, SVL and AML self.assertAlmostEqual(lc.valuation_adjustment_lines.final_cost, 554) svl = self.env['stock.valuation.layer'].search([('stock_move_id', '=', receipt.move_ids.id)], order='id desc', limit=1) self.assertAlmostEqual(svl.value, 99) aml = self.env['account.move.line'].search([('account_id', '=', stock_valuation_account.id)], order='id desc', limit=1) self.assertAlmostEqual(aml.debit, 99) # Create an invoice with the same price move_form = Form(self.env['account.move'].with_context(default_move_type='in_invoice')) move_form.invoice_date = move_form.date move_form.partner_id = order.partner_id move_form.purchase_vendor_bill_id = self.env['purchase.bill.union'].browse(-order.id) move = move_form.save() move.action_post() # Check nothing was posted in the stock valuation account. price_diff_aml = self.env['account.move.line'].search([('account_id', '=', stock_valuation_account.id), ('move_id', '=', move.id)]) self.assertEqual(len(price_diff_aml), 0, "No line should have been generated in the stock valuation account about the price difference.") def test_lc_with_avco_ordered_qty_backorder(self): """ Make sure the landed cost added in invoices are taken into account to compute product cost even in 'Ordered Quantity' invoice policy. """ self.env.company.anglo_saxon_accounting = True self.landed_cost.split_method_landed_cost = 'by_quantity' product2 = self.env['product.product'].create({ 'name': 'product2', 'is_storable': True, 'categ_id': self.stock_account_product_categ.id, }) products = self.product1 | product2 products.purchase_method = 'purchase' products.categ_id.write({ 'property_stock_account_input_categ_id': self.company_data['default_account_stock_in'].id, 'property_stock_account_output_categ_id': self.company_data['default_account_stock_out'].id, 'property_stock_valuation_account_id': self.company_data['default_account_stock_valuation'].id, 'property_valuation': 'real_time', 'property_cost_method': 'average', }) self.landed_cost.categ_id = products.categ_id.id purchase_order = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [Command.create({ 'product_id': self.product1.id, 'product_qty': 100000, 'price_unit': 1, }), Command.create({ 'product_id': product2.id, 'product_qty': 50000, 'price_unit': 3, })], }) purchase_order.button_confirm() purchase_order.action_create_invoice() bill = purchase_order.invoice_ids[0] receipt = purchase_order.picking_ids[0] receipt.picking_type_id.create_backorder = 'always' receipt.move_ids[0].quantity = 50000 receipt.move_ids[1].quantity = 25000 receipt.move_ids.picked = True receipt.button_validate() self.assertEqual(self.product1.standard_price, 1) self.assertEqual(product2.standard_price, 3) bill.invoice_date = fields.Date.today() with Form(bill) as bill_form: with bill_form.invoice_line_ids.new() as inv_line: inv_line.product_id = self.landed_cost inv_line.price_unit = 75000 inv_line.is_landed_costs_line = True bill.action_post() action = bill.button_create_landed_costs() lc_form = Form(self.env[action['res_model']].browse(action['res_id'])) lc_form.picking_ids.add(receipt) lc = lc_form.save() lc.button_validate() self.assertEqual(self.product1.standard_price, 2) self.assertEqual(product2.standard_price, 4) receipt2 = purchase_order.picking_ids.filtered(lambda p: p.state == 'assigned') for move in receipt2.move_ids: move.quantity = move.product_qty move.picked = True receipt2.button_validate() self.assertEqual(self.product1.standard_price, 1.5) self.assertEqual(product2.standard_price, 3.5) def test_invoice_after_lc_amls(self): self.env.company.anglo_saxon_accounting = True self.landed_cost.landed_cost_ok = True self.landed_cost.categ_id.property_cost_method = 'fifo' self.landed_cost.categ_id.property_valuation = 'real_time' # Create PO po = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'currency_id': self.company_data['currency'].id, 'order_line': [ (0, 0, { 'name': self.product_a.name, 'product_id': self.product_a.id, 'product_qty': 1.0, 'product_uom': self.product_a.uom_po_id.id, 'price_unit': 100.0, 'taxes_id': False, }), (0, 0, { 'name': self.landed_cost.name, 'product_id': self.landed_cost.id, 'product_qty': 1.0, 'price_unit': 100.0, }), ], }) po.button_confirm() receipt = po.picking_ids receipt.move_ids.quantity = 1 receipt.button_validate() po.order_line[1].qty_received = 1 po.action_create_invoice() bill = po.invoice_ids # Create and validate LC lc = self.env['stock.landed.cost'].create(dict( picking_ids=[(6, 0, [receipt.id])], account_journal_id=self.stock_journal.id, cost_lines=[ (0, 0, { 'name': 'equal split', 'split_method': 'equal', 'price_unit': 100, 'product_id': self.landed_cost.id, }), ], )) lc.compute_landed_cost() lc.button_validate() user = self.env['res.users'].create({ 'name': 'User h', 'login': 'usher', 'email': 'usher@yourcompany.com', 'groups_id': [(6, 0, [self.env.ref('account.group_account_invoice').id])] }) # Post the bill bill.landed_costs_ids = [(6, 0, lc.id)] bill.invoice_date = Date.today() bill.with_user(user)._post() landed_cost_aml = bill.invoice_line_ids.filtered(lambda l: l.product_id == self.landed_cost) self.assertTrue(landed_cost_aml.reconciled) def test_lc_with_avco_ordered_qty_invoice_receipt_order(self): """ When using an invoicing policy that permits invoicing prior to reception, stock moves for products using dynamic cost methods should account for LCs associated with the order from which the move was derived. """ self.env.company.anglo_saxon_accounting = True self.product1.purchase_method = 'purchase' self.product1.categ_id.write({ 'property_stock_account_input_categ_id': self.company_data['default_account_stock_in'].id, 'property_stock_account_output_categ_id': self.company_data['default_account_stock_out'].id, 'property_stock_valuation_account_id': self.company_data['default_account_stock_valuation'].id, 'property_valuation': 'real_time', 'property_cost_method': 'average', }) self.landed_cost.categ_id = self.product1.categ_id.id product = self.product1 product.uom_id = self.env.ref("uom.product_uom_kgm") purchase_order = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [Command.create({ 'product_id': product.id, 'product_qty': 100000, 'price_unit': 1.35, })], }) purchase_order.button_confirm() purchase_order.action_create_invoice() bill = purchase_order.invoice_ids[0] bill.invoice_line_ids[0].quantity = 23000 receipt = purchase_order.picking_ids[0] receipt.picking_type_id.create_backorder = 'always' receipt.move_ids.quantity = 23000 receipt.button_validate() self.assertEqual(product.standard_price, 1.35) bill.invoice_date = '2000-05-05' with Form(bill) as bill_form: with bill_form.invoice_line_ids.new() as inv_line: inv_line.product_id = self.landed_cost inv_line.price_unit = 23000 inv_line.is_landed_costs_line = True bill.action_post() action = bill.button_create_landed_costs() lc_form = Form(self.env[action['res_model']].browse(action['res_id'])) lc_form.picking_ids.add(receipt) lc = lc_form.save() lc.button_validate() self.assertEqual(product.standard_price, 2.35) purchase_order.action_create_invoice() bill2 = purchase_order.invoice_ids.filtered(lambda b: b.state == 'draft') bill2.invoice_line_ids[0].quantity = 27000 bill2.invoice_date = Date.today() bill2._post() receipt2 = purchase_order.picking_ids.filtered(lambda p: p.state == 'assigned') receipt2.move_ids[0].quantity = 27000 receipt2.button_validate() self.assertEqual(product.standard_price, 1.81) def test_landed_costs_avco_invoice_before_receipt(self): """ Test the application of landed costs on a product with average cost (AVCO) method when the bill is created and validated before the receipt and the landed costs are not yet created on the bill. """ self.env.company.anglo_saxon_accounting = True self.product1.purchase_method = 'purchase' self.product1.categ_id.write({ 'property_stock_account_input_categ_id': self.company_data['default_account_stock_in'].id, 'property_stock_account_output_categ_id': self.company_data['default_account_stock_out'].id, 'property_stock_valuation_account_id': self.company_data['default_account_stock_valuation'].id, 'property_valuation': 'real_time', 'property_cost_method': 'average', }) self.landed_cost.categ_id = self.product1.categ_id.id product = self.product1 purchase_order = self.env['purchase.order'].create({ 'partner_id': self.partner_a.id, 'order_line': [Command.create({ 'product_id': product.id, 'product_qty': 1, 'price_unit': 10, })], }) purchase_order.button_confirm() purchase_order.action_create_invoice() bill = purchase_order.invoice_ids[0] bill.invoice_line_ids[0].quantity = 1 bill.invoice_date = '2000-05-05' with Form(bill) as bill_form: with bill_form.invoice_line_ids.new() as inv_line: inv_line.product_id = self.landed_cost inv_line.price_unit = 25 inv_line.is_landed_costs_line = True bill.action_post() receipt = purchase_order.picking_ids[0] receipt.move_ids.quantity = 1 receipt.button_validate() # Ensure that the product cost has not been updated yet assert receipt.move_ids[0].stock_valuation_layer_ids[0].unit_cost == 10 action = bill.button_create_landed_costs() lc_form = Form(self.env[action['res_model']].browse(action['res_id'])) lc_form.picking_ids.add(receipt) lc = lc_form.save() lc.button_validate() # 35 = Product price (10) + landed cost price (25) self.assertEqual(product.standard_price, 35)