# Part of Odoo. See LICENSE file for full copyright and licensing details. from unittest import skip from odoo.addons.stock_account.tests.test_lot_valuation import TestLotValuation from odoo.tests import tagged, Form from odoo import Command @tagged('post_install', '-at_install') @skip('Temporary to fast merge new valuation') class TestStockLandedCostsLots(TestLotValuation): @classmethod def setUpClass(cls): super().setUpClass() cls.productlc1 = cls.env['product.product'].create({ 'name': 'product1', 'type': 'service', 'landed_cost_ok': True, 'categ_id': cls.env.ref('product.product_category_goods').id, }) def test_stock_landed_costs_lots(self): self.product1.product_tmpl_id.categ_id.property_valuation = 'real_time' picking_1 = self.env['stock.picking'].create({ 'picking_type_id': self.env.ref('stock.picking_type_in').id, 'move_ids': [Command.create({ 'product_id': self.product1.id, 'product_uom_qty': 15, 'product_uom': self.ref('uom.product_uom_unit'), 'location_id': self.supplier_location.id, 'location_dest_id': self.env.ref('stock.stock_location_stock').id, 'price_unit': 10, })], }) product2 = self.env['product.product'].create({ 'name': 'product2', 'is_storable': True, 'tracking': 'lot', 'lot_valuated': True, 'categ_id': self.env.ref('product.product_category_goods').id, }) picking_2 = self.env['stock.picking'].create({ 'picking_type_id': self.env.ref('stock.picking_type_in').id, 'move_ids': [Command.create({ 'product_id': product2.id, 'product_uom_qty': 10, 'product_uom': self.ref('uom.product_uom_unit'), 'location_id': self.supplier_location.id, 'location_dest_id': self.env.ref('stock.stock_location_stock').id, 'price_unit': 11, })], }) # Confirm and assign picking (picking_1 | picking_2).action_confirm() picking_1.move_ids.move_line_ids = [Command.clear()] + [Command.create({ 'product_id': self.product1.id, 'lot_name': lot_name, 'quantity': 5, 'location_id': self.supplier_location.id, 'location_dest_id': self.env.ref('stock.stock_location_stock').id, }) for lot_name in ['LClotA1', 'LClotA2', 'LClotA3']] picking_2.move_ids.move_line_ids = [Command.clear()] + [Command.create({ 'product_id': product2.id, 'lot_name': lot_name, 'quantity': 5, 'location_id': self.supplier_location.id, 'location_dest_id': self.env.ref('stock.stock_location_stock').id, }) for lot_name in ['LClotB1', 'LClotB2']] (picking_1 | picking_2).move_ids.picked = True (picking_1 | picking_2).button_validate() og_p1_layers = picking_1.move_ids.stock_valuation_layer_ids og_p2_layers = picking_2.move_ids.stock_valuation_layer_ids lc_form = Form(self.env['stock.landed.cost']) lc_form.picking_ids = (picking_1 | picking_2) with lc_form.cost_lines.new() as cost_line: cost_line.product_id = self.productlc1 cost_line.price_unit = 6 lc = lc_form.save() lc.compute_landed_cost() lc.button_validate() for valuation in lc.valuation_adjustment_lines: if valuation.cost_line_id.name == 'equal split': self.assertEqual(valuation.additional_landed_cost, 5) # I check that the landed cost is now "Closed" and that it has an accounting entry self.assertEqual(lc.state, "done") self.assertTrue(lc.account_move_id) self.assertEqual(len(lc.account_move_id.line_ids), 4) lc_value = sum(lc.account_move_id.line_ids.filtered(lambda aml: aml.account_id.name.startswith('Expenses')).mapped('debit')) product_value = abs(self.productlc1.value_svl) self.assertEqual(lc_value, product_value) lot = self.env['stock.lot'].search([('name', 'ilike', 'LClot')]) lot_product_a = lot.filtered(lambda l: l.product_id == self.product1) lot_product_b = lot - lot_product_a self.assertRecordValues(lc.stock_valuation_layer_ids.sorted(lambda svl: svl.product_id.id), [ {'lot_id': lot_product_a[0].id, 'product_id': self.product1.id, 'stock_valuation_layer_id': og_p1_layers[0].id, 'quantity': 0, 'value': 1}, {'lot_id': lot_product_a[1].id, 'product_id': self.product1.id, 'stock_valuation_layer_id': og_p1_layers[1].id, 'quantity': 0, 'value': 1}, {'lot_id': lot_product_a[2].id, 'product_id': self.product1.id, 'stock_valuation_layer_id': og_p1_layers[2].id, 'quantity': 0, 'value': 1}, {'lot_id': lot_product_b[0].id, 'product_id': product2.id, 'stock_valuation_layer_id': og_p2_layers[0].id, 'quantity': 0, 'value': 1.5}, {'lot_id': lot_product_b[1].id, 'product_id': product2.id, 'stock_valuation_layer_id': og_p2_layers[1].id, 'quantity': 0, 'value': 1.5}, ]) for l, price in zip(lot_product_a, [10.2, 10.2, 10.2]): self.assertEqual(l.standard_price, price) for l, price in zip(lot_product_b, [11.3, 11.3]): self.assertEqual(l.standard_price, price) outs = self._make_out_move(self.product1, 9, lot_ids=[lot_product_a[0], lot_product_a[1], lot_product_a[2]]) self.assertRecordValues(outs.stock_valuation_layer_ids.sorted('id'), [ {'lot_id': lot_product_a[0].id, 'product_id': self.product1.id, 'quantity': -3, 'value': -30.6}, {'lot_id': lot_product_a[1].id, 'product_id': self.product1.id, 'quantity': -3, 'value': -30.6}, {'lot_id': lot_product_a[2].id, 'product_id': self.product1.id, 'quantity': -3, 'value': -30.6}, ]) # out move with 2 units of product 2 in each lot, so 11.3 * 2 = 22.6 outs = self._make_out_move(product2, 4, lot_ids=[lot_product_b[0], lot_product_b[1]]) self.assertRecordValues(outs.stock_valuation_layer_ids.sorted('id'), [ {'lot_id': lot_product_b[0].id, 'product_id': product2.id, 'quantity': -2, 'value': -22.6}, {'lot_id': lot_product_b[1].id, 'product_id': product2.id, 'quantity': -2, 'value': -22.6}, ]) def test_landed_cost_when_partially_sold(self): """ check that the landed costs split correctly between lot/ serial numbers when some lot/serial number are empty (no share of the landed cost for those) or when some have a portion of their quantity already sold (check that it uses the remaining quantity) """ product1 = self.env['product.product'].create({ 'name': 'product2', 'is_storable': True, 'tracking': 'lot', 'lot_valuated': True, 'categ_id': self.env.ref('product.product_category_goods').id, }) product1.categ_id.property_cost_method = 'fifo' # acquire 5 products picking_1 = self.env['stock.picking'].create({ 'picking_type_id': self.env.ref('stock.picking_type_in').id, 'move_ids': [Command.create({ 'product_id': product1.id, 'product_uom_qty': 5, 'product_uom': self.ref('uom.product_uom_unit'), 'location_id': self.supplier_location.id, 'location_dest_id': self.env.ref('stock.stock_location_stock').id, 'price_unit': 10000, })], }) picking_1.action_confirm() # split in lots picking_1.move_ids.move_line_ids = [Command.clear()] + [Command.create({ 'product_id': product1.id, 'lot_name': lot_name, 'quantity': lot_quantity, 'location_id': self.supplier_location.id, 'location_dest_id': self.env.ref('stock.stock_location_stock').id, }) for (lot_name, lot_quantity) in [('L1', 1), ('L2', 2), ('L3', 1), ('L4', 1)]] picking_1.move_ids.picked = True picking_1.button_validate() # deliver 2 products (lot1, lot2, lot3, lot4) = picking_1.move_ids.move_line_ids.mapped('lot_id').sorted('id') self._make_out_move(product1, quantity=2, lot_ids=[lot1, lot2]) # add the landed cost lc_form = Form(self.env['stock.landed.cost']) lc_form.picking_ids = picking_1 with lc_form.cost_lines.new() as cost_line: cost_line.product_id = self.productlc1 cost_line.price_unit = 5000 lc = lc_form.save() lc.compute_landed_cost() lc.button_validate() # check it was correctly split self.assertRecordValues(lc.stock_valuation_layer_ids.sorted('id'), [ {'lot_id': lot2.id, 'value': 1000}, {'lot_id': lot3.id, 'value': 1000}, {'lot_id': lot4.id, 'value': 1000}, ])