1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo.addons.stock_landed_costs.tests.common import TestStockLandedCostsCommon
from odoo.tests import tagged
@tagged('post_install', '-at_install')
class TestStockLandedCostsRounding(TestStockLandedCostsCommon):
def test_stock_landed_costs_rounding(self):
# In order to test the rounding in landed costs feature of stock, I create 2 landed cost
# Define undivisible units
product_uom_unit_round_1 = self.env.ref('uom.product_uom_unit')
product_uom_unit_round_1.write({
'name': 'Undivisible Units',
'rounding': 1.0,
})
# I create 2 products with different cost prices and configure them for real_time
# valuation and real price costing method
product_landed_cost_3 = self.env['product.product'].create({
'name': "LC product 3",
'uom_id': product_uom_unit_round_1.id,
})
product_landed_cost_3.product_tmpl_id.categ_id.property_cost_method = 'fifo'
product_landed_cost_3.product_tmpl_id.categ_id.property_stock_account_input_categ_id = self.company_data['default_account_expense']
product_landed_cost_3.product_tmpl_id.categ_id.property_stock_account_output_categ_id = self.company_data['default_account_revenue']
product_landed_cost_4 = self.env['product.product'].create({
'name': "LC product 4",
'uom_id': product_uom_unit_round_1.id,
})
product_landed_cost_4.product_tmpl_id.categ_id.property_cost_method = 'fifo'
product_landed_cost_4.product_tmpl_id.categ_id.property_valuation = 'real_time'
product_landed_cost_4.product_tmpl_id.categ_id.property_stock_account_input_categ_id = self.company_data['default_account_expense']
product_landed_cost_4.product_tmpl_id.categ_id.property_stock_account_output_categ_id = self.company_data['default_account_revenue']
picking_default_vals = self.env['stock.picking'].default_get(list(self.env['stock.picking'].fields_get()))
# I create 2 pickings moving those products
vals = dict(picking_default_vals, **{
'name': 'LC_pick_3',
'picking_type_id': self.warehouse.in_type_id.id,
'move_lines': [(0, 0, {
'product_id': product_landed_cost_3.id,
'product_uom_qty': 13,
'product_uom': product_uom_unit_round_1.id,
'location_id': self.ref('stock.stock_location_customers'),
'location_dest_id': self.warehouse.lot_stock_id.id,
})],
})
picking_landed_cost_3 = self.env['stock.picking'].new(vals)
picking_landed_cost_3.onchange_picking_type()
picking_landed_cost_3.move_lines.onchange_product_id()
picking_landed_cost_3.move_lines.name = 'move 3'
vals = picking_landed_cost_3._convert_to_write(picking_landed_cost_3._cache)
picking_landed_cost_3 = self.env['stock.picking'].create(vals)
vals = dict(picking_default_vals, **{
'name': 'LC_pick_4',
'picking_type_id': self.warehouse.in_type_id.id,
'move_lines': [(0, 0, {
'product_id': product_landed_cost_4.id,
'product_uom_qty': 1,
'product_uom': self.ref('uom.product_uom_dozen'),
'location_id': self.ref('stock.stock_location_customers'),
'location_dest_id': self.warehouse.lot_stock_id.id,
'price_unit': 17.00 / 12.00,
})],
})
picking_landed_cost_4 = self.env['stock.picking'].new(vals)
picking_landed_cost_4.onchange_picking_type()
picking_landed_cost_4.move_lines.onchange_product_id()
picking_landed_cost_4.move_lines.name = 'move 4'
vals = picking_landed_cost_4._convert_to_write(picking_landed_cost_4._cache)
picking_landed_cost_4 = self.env['stock.picking'].create(vals)
# We perform all the tests for LC_pick_3
# I receive picking LC_pick_3, and check how many quants are created
picking_landed_cost_3.move_lines.price_unit = 1.0
picking_landed_cost_3.action_confirm()
picking_landed_cost_3.action_assign()
picking_landed_cost_3._action_done()
virtual_interior_design = self.env['product.product'].create({'name': 'Virtual Interior Design'})
# I create a landed cost for picking 3
default_vals = self.env['stock.landed.cost'].default_get(list(self.env['stock.landed.cost'].fields_get()))
default_vals.update({
'picking_ids': [picking_landed_cost_3.id],
'account_journal_id': self.expenses_journal,
'cost_lines': [(0, 0, {'product_id': virtual_interior_design.id})],
'valuation_adjustment_lines': [],
})
stock_landed_cost_2 = self.env['stock.landed.cost'].new(default_vals)
stock_landed_cost_2.cost_lines.onchange_product_id()
stock_landed_cost_2.cost_lines.name = 'equal split'
stock_landed_cost_2.cost_lines.split_method = 'equal'
stock_landed_cost_2.cost_lines.price_unit = 15
vals = stock_landed_cost_2._convert_to_write(stock_landed_cost_2._cache)
stock_landed_cost_2 = self.env['stock.landed.cost'].create(vals)
# I compute the landed cost using Compute button
stock_landed_cost_2.compute_landed_cost()
# I check the valuation adjustment lines
for valuation in stock_landed_cost_2.valuation_adjustment_lines:
self.assertEqual(valuation.additional_landed_cost, 15)
# I confirm the landed cost
stock_landed_cost_2.button_validate()
# I check that the landed cost is now "Closed" and that it has an accounting entry
self.assertEqual(stock_landed_cost_2.state, 'done')
self.assertTrue(stock_landed_cost_2.account_move_id)
# We perform all the tests for LC_pick_4
# I receive picking LC_pick_4, and check how many quants are created
picking_landed_cost_4.move_lines.price_unit = 17.0/12.0
picking_landed_cost_4.action_confirm()
picking_landed_cost_4.action_assign()
picking_landed_cost_4._action_done()
# I create a landed cost for picking 4
default_vals = self.env['stock.landed.cost'].default_get(list(self.env['stock.landed.cost'].fields_get()))
default_vals.update({
'picking_ids': [picking_landed_cost_4.id],
'account_journal_id': self.expenses_journal,
'cost_lines': [(0, 0, {'product_id': virtual_interior_design.id})],
'valuation_adjustment_lines': [],
})
stock_landed_cost_3 = self.env['stock.landed.cost'].new(default_vals)
stock_landed_cost_3.cost_lines.onchange_product_id()
stock_landed_cost_3.cost_lines.name = 'equal split'
stock_landed_cost_3.cost_lines.split_method = 'equal'
stock_landed_cost_3.cost_lines.price_unit = 11
vals = stock_landed_cost_3._convert_to_write(stock_landed_cost_3._cache)
stock_landed_cost_3 = self.env['stock.landed.cost'].create(vals)
# I compute the landed cost using Compute button
stock_landed_cost_3.compute_landed_cost()
# I check the valuation adjustment lines
for valuation in stock_landed_cost_3.valuation_adjustment_lines:
self.assertEqual(valuation.additional_landed_cost, 11)
# I confirm the landed cost
stock_landed_cost_3.button_validate()
# I check that the landed cost is now "Closed" and that it has an accounting entry
self.assertEqual(stock_landed_cost_3.state, 'done')
self.assertTrue(stock_landed_cost_3.account_move_id)
|
