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
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo.addons.account.tests.common import AccountTestInvoicingCommon
from odoo.tests import tagged
from odoo import fields
@tagged('-at_install', 'post_install')
class ValuationReconciliationTestCommon(AccountTestInvoicingCommon):
""" Base class for tests checking interim accounts reconciliation works
in anglosaxon accounting. It sets up everything we need in the tests, and is
extended in both sale_stock and purchase modules to run the 'true' tests.
"""
@classmethod
def setUpClass(cls, chart_template_ref=None):
super().setUpClass(chart_template_ref=chart_template_ref)
cls.stock_account_product_categ = cls.env['product.category'].create({
'name': 'Test category',
'property_valuation': 'real_time',
'property_cost_method': 'fifo',
'property_stock_valuation_account_id': cls.company_data['default_account_stock_valuation'].id,
'property_stock_account_input_categ_id': cls.company_data['default_account_stock_in'].id,
'property_stock_account_output_categ_id': cls.company_data['default_account_stock_out'].id,
})
uom_unit = cls.env.ref('uom.product_uom_unit')
cls.test_product_order = cls.env['product.product'].create({
'name': "Test product template invoiced on order",
'standard_price': 42.0,
'type': 'product',
'categ_id': cls.stock_account_product_categ.id,
'uom_id': uom_unit.id,
'uom_po_id': uom_unit.id,
})
cls.test_product_delivery = cls.env['product.product'].create({
'name': 'Test product template invoiced on delivery',
'standard_price': 42.0,
'type': 'product',
'categ_id': cls.stock_account_product_categ.id,
'uom_id': uom_unit.id,
'uom_po_id': uom_unit.id,
})
@classmethod
def setup_company_data(cls, company_name, chart_template=None, **kwargs):
company_data = super().setup_company_data(company_name, chart_template=chart_template, **kwargs)
# Create stock config.
company_data.update({
'default_account_stock_in': cls.env['account.account'].create({
'name': 'default_account_stock_in',
'code': 'STOCKIN',
'reconcile': True,
'user_type_id': cls.env.ref('account.data_account_type_current_assets').id,
'company_id': company_data['company'].id,
}),
'default_account_stock_out': cls.env['account.account'].create({
'name': 'default_account_stock_out',
'code': 'STOCKOUT',
'reconcile': True,
'user_type_id': cls.env.ref('account.data_account_type_current_assets').id,
'company_id': company_data['company'].id,
}),
'default_account_stock_valuation': cls.env['account.account'].create({
'name': 'default_account_stock_valuation',
'code': 'STOCKVAL',
'reconcile': True,
'user_type_id': cls.env.ref('account.data_account_type_current_assets').id,
'company_id': company_data['company'].id,
}),
'default_warehouse': cls.env['stock.warehouse'].search(
[('company_id', '=', company_data['company'].id)],
limit=1,
),
})
return company_data
def check_reconciliation(self, invoice, picking, full_reconcile=True, operation='purchase'):
interim_account_id = self.company_data['default_account_stock_in'].id if operation == 'purchase' else self.company_data['default_account_stock_out'].id
invoice_line = invoice.line_ids.filtered(lambda line: line.account_id.id == interim_account_id)
stock_moves = picking.move_lines
valuation_line = stock_moves.mapped('account_move_ids.line_ids').filtered(lambda x: x.account_id.id == interim_account_id)
if invoice.is_purchase_document() and any(l.is_anglo_saxon_line for l in invoice_line):
self.assertEqual(len(invoice_line), 2, "Only two line2 should have been written by invoice in stock input account")
self.assertTrue(valuation_line.reconciled or invoice_line[0].reconciled or invoice_line[1].reconciled, "The valuation and invoice line should have been reconciled together.")
else:
self.assertEqual(len(invoice_line), 1, "Only one line should have been written by invoice in stock input account")
self.assertTrue(valuation_line.reconciled or invoice_line.reconciled, "The valuation and invoice line should have been reconciled together.")
if invoice.move_type not in ('out_refund', 'in_refund'):
self.assertEqual(len(valuation_line), 1, "Only one line should have been written for stock valuation in stock input account")
if full_reconcile:
self.assertTrue(valuation_line.full_reconcile_id, "The reconciliation should be total at that point.")
else:
self.assertFalse(valuation_line.full_reconcile_id, "The reconciliation should not be total at that point.")
def _process_pickings(self, pickings, date=False, quantity=False):
if not date:
date = fields.Date.today()
pickings.action_confirm()
pickings.action_assign()
for picking in pickings:
for ml in picking.move_line_ids:
ml.qty_done = quantity or ml.product_qty
pickings._action_done()
self._change_pickings_date(pickings, date)
def _change_pickings_date(self, pickings, date):
pickings.mapped('move_lines').write({'date': date})
pickings.mapped('move_lines.account_move_ids').write({'name': '/', 'state': 'draft'})
pickings.mapped('move_lines.account_move_ids').write({'date': date})
pickings.move_lines.account_move_ids.action_post()
|