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
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo.exceptions import ValidationError
from odoo import models, fields, api, _
from odoo.tools.misc import formatLang
from odoo.tools.float_utils import float_repr, float_round
SII_VAT = '60805000-0'
class AccountMove(models.Model):
_inherit = "account.move"
partner_id_vat = fields.Char(related='partner_id.vat', string='VAT No')
l10n_latam_internal_type = fields.Selection(
related='l10n_latam_document_type_id.internal_type', string='L10n Latam Internal Type')
def _get_l10n_latam_documents_domain(self):
self.ensure_one()
if self.journal_id.company_id.account_fiscal_country_id != self.env.ref('base.cl') or not \
self.journal_id.l10n_latam_use_documents:
return super()._get_l10n_latam_documents_domain()
if self.journal_id.type == 'sale':
domain = [('country_id.code', '=', 'CL')]
if self.move_type in ['in_invoice', 'out_invoice']:
domain += [('internal_type', 'in', ['invoice', 'debit_note', 'invoice_in'])]
elif self.move_type in ['in_refund', 'out_refund']:
domain += [('internal_type', '=', 'credit_note')]
if self.company_id.partner_id.l10n_cl_sii_taxpayer_type == '1':
domain += [('code', '!=', '71')] # Companies with VAT Affected doesn't have "Boleta de honorarios Electrónica"
return domain
if self.move_type == 'in_refund':
internal_types_domain = ('internal_type', '=', 'credit_note')
else:
internal_types_domain = ('internal_type', 'in', ['invoice', 'debit_note', 'invoice_in'])
domain = [
('country_id.code', '=', 'CL'),
internal_types_domain,
]
if self.partner_id.l10n_cl_sii_taxpayer_type == '1' and self.partner_id_vat != '60805000-0':
domain += [('code', 'not in', ['39', '70', '71', '914', '911'])]
elif self.partner_id.l10n_cl_sii_taxpayer_type == '1' and self.partner_id_vat == '60805000-0':
domain += [('code', 'not in', ['39', '70', '71'])]
elif self.partner_id.l10n_cl_sii_taxpayer_type == '2':
domain += [('code', 'in', ['70', '71', '56', '61'])]
elif self.partner_id.l10n_cl_sii_taxpayer_type == '3':
domain += [('code', 'in', ['35', '38', '39', '41', '56', '61'])]
elif self.partner_id.country_id.code != 'CL' or self.partner_id.l10n_cl_sii_taxpayer_type == '4':
domain += [('code', '=', '46')]
else:
domain += [('code', 'in', [])]
return domain
def _check_document_types_post(self):
for rec in self.filtered(
lambda r: r.company_id.account_fiscal_country_id.code == "CL" and
r.journal_id.type in ['sale', 'purchase']):
tax_payer_type = rec.partner_id.l10n_cl_sii_taxpayer_type
vat = rec.partner_id.vat
country_id = rec.partner_id.country_id
latam_document_type_code = rec.l10n_latam_document_type_id.code
if (rec.journal_id.type == 'purchase' and tax_payer_type == '4' and country_id.code != 'CL' and
latam_document_type_code == '61' and
'46' in rec.l10n_cl_reference_ids.mapped('l10n_cl_reference_doc_type_selection')):
continue
if (not tax_payer_type or not vat) and (country_id.code == "CL" and latam_document_type_code
and latam_document_type_code not in ['35', '38', '39', '41']):
raise ValidationError(_('Tax payer type and vat number are mandatory for this type of '
'document. Please set the current tax payer type of this customer'))
if rec.journal_id.type == 'sale' and rec.journal_id.l10n_latam_use_documents:
if country_id.code != "CL":
if not ((tax_payer_type == '4' and latam_document_type_code in ['110', '111', '112']) or (
tax_payer_type == '3' and latam_document_type_code in ['39', '41', '61', '56'])):
raise ValidationError(_(
'Document types for foreign customers must be export type (codes 110, 111 or 112) or you should define the customer as an end consumer and use receipts (codes 39 or 41)'))
if rec.journal_id.type == 'purchase' and rec.journal_id.l10n_latam_use_documents:
if vat != SII_VAT and latam_document_type_code == '914':
raise ValidationError(_('The DIN document is intended to be used only with RUT 60805000-0'
' (Tesorería General de La República)'))
if not tax_payer_type or not vat:
if country_id.code == "CL" and latam_document_type_code not in [
'35', '38', '39', '41']:
raise ValidationError(_('Tax payer type and vat number are mandatory for this type of '
'document. Please set the current tax payer type of this supplier'))
if tax_payer_type == '2' and latam_document_type_code not in ['70', '71', '56', '61']:
raise ValidationError(_('The tax payer type of this supplier is incorrect for the selected type'
' of document.'))
if tax_payer_type in ['1', '3']:
if latam_document_type_code in ['70', '71']:
raise ValidationError(_('The tax payer type of this supplier is not entitled to deliver '
'fees documents'))
if latam_document_type_code in ['110', '111', '112']:
raise ValidationError(_('The tax payer type of this supplier is not entitled to deliver '
'imports documents'))
if (tax_payer_type == '4' or country_id.code != "CL") and latam_document_type_code != '46':
raise ValidationError(_('You need a journal without the use of documents for foreign '
'suppliers'))
@api.onchange('journal_id')
def _l10n_cl_onchange_journal(self):
if self.company_id.country_id.code == 'CL':
self.l10n_latam_document_type_id = False
def _post(self, soft=True):
self._check_document_types_post()
return super()._post(soft)
def _l10n_cl_get_formatted_sequence(self, number=0):
return '%s %06d' % (self.l10n_latam_document_type_id.doc_code_prefix, number)
def _get_starting_sequence(self):
""" If use documents then will create a new starting sequence using the document type code prefix and the
journal document number with a 6 padding number """
if self.journal_id.l10n_latam_use_documents and self.company_id.account_fiscal_country_id.code == "CL":
if self.l10n_latam_document_type_id:
return self._l10n_cl_get_formatted_sequence()
return super()._get_starting_sequence()
def _get_last_sequence_domain(self, relaxed=False):
where_string, param = super(AccountMove, self)._get_last_sequence_domain(relaxed)
if self.company_id.account_fiscal_country_id.code == "CL" and self.l10n_latam_use_documents:
where_string = where_string.replace('journal_id = %(journal_id)s AND', '')
where_string += ' AND l10n_latam_document_type_id = %(l10n_latam_document_type_id)s AND ' \
'company_id = %(company_id)s AND move_type IN %(move_type)s'
param['company_id'] = self.company_id.id or False
param['l10n_latam_document_type_id'] = self.l10n_latam_document_type_id.id or 0
param['move_type'] = (('in_invoice', 'in_refund') if
self.l10n_latam_document_type_id._is_doc_type_vendor() else ('out_invoice', 'out_refund'))
return where_string, param
def _get_name_invoice_report(self):
self.ensure_one()
if self.l10n_latam_use_documents and self.company_id.account_fiscal_country_id.code == 'CL':
return 'l10n_cl.report_invoice_document'
return super()._get_name_invoice_report()
def _format_lang_totals(self, value, currency):
return formatLang(self.env, value, currency_obj=currency)
def _l10n_cl_get_invoice_totals_for_report(self):
self.ensure_one()
include_sii = self._l10n_cl_include_sii()
tax_totals = self.tax_totals
if not include_sii:
return tax_totals
tax_group_ids = {
tax_group['id']
for subtotal in tax_totals['subtotals']
for tax_group in subtotal['tax_groups']
}
tax_group_ids_to_exclude = self.env['account.tax.group'].browse(tax_group_ids).filtered(lambda x: x.l10n_cl_sii_code == 14).ids
if tax_group_ids_to_exclude:
return self.env['account.tax']._exclude_tax_groups_from_tax_totals_summary(tax_totals, tax_group_ids_to_exclude)
return tax_totals
def _l10n_cl_include_sii(self):
self.ensure_one()
return self.l10n_latam_document_type_id.code in ['39', '41', '110', '111', '112', '34']
def _is_manual_document_number(self):
if self.journal_id.company_id.country_id.code == 'CL':
return self.journal_id.type == 'purchase' and not self.l10n_latam_document_type_id._is_doc_type_vendor()
return super()._is_manual_document_number()
def _l10n_cl_get_amounts(self):
"""
This method is used to calculate the amount and taxes required in the Chilean localization electronic documents.
"""
self.ensure_one()
global_discounts = self.invoice_line_ids.filtered(lambda x: x.price_subtotal < 0)
export = self.l10n_latam_document_type_id._is_doc_type_export()
main_currency = self.company_id.currency_id if not export else self.currency_id
key_main_currency = 'amount_currency' if export else 'balance'
sign_main_currency = -1 if self.move_type == 'out_invoice' else 1
currency_round_main_currency = self.currency_id if export else self.company_id.currency_id
currency_round_other_currency = self.company_id.currency_id if export else self.currency_id
total_amount_main_currency = currency_round_main_currency.round(self.amount_total) if export \
else (currency_round_main_currency.round(abs(self.amount_total_signed)))
other_currency = self.currency_id != self.company_id.currency_id
values = {
'main_currency': main_currency,
'vat_amount': 0,
'subtotal_amount_taxable': 0,
'subtotal_amount_exempt': 0, 'total_amount': total_amount_main_currency,
'main_currency_round': currency_round_main_currency.decimal_places,
'main_currency_name': self._l10n_cl_normalize_currency_name(
currency_round_main_currency.name) if export else False
}
vat_percent = 0
if other_currency:
key_other_currency = 'balance' if export else 'amount_currency'
values['second_currency'] = {
'subtotal_amount_taxable': 0,
'subtotal_amount_exempt': 0,
'vat_amount': 0,
'total_amount': currency_round_other_currency.round(abs(self.amount_total_signed))
if export else currency_round_other_currency.round(self.amount_total),
'round_currency': currency_round_other_currency.decimal_places,
'name': self._l10n_cl_normalize_currency_name(currency_round_other_currency.name),
'rate': round(abs(self.amount_total_signed) / self.amount_total, 4),
}
for line in self.line_ids:
if line.tax_line_id and line.tax_line_id.l10n_cl_sii_code == 14:
values['vat_amount'] += line[key_main_currency] * sign_main_currency
if other_currency:
values['second_currency']['vat_amount'] += line[key_other_currency] * sign_main_currency
vat_percent = max(vat_percent, line.tax_line_id.amount)
if line.display_type == 'product':
if line.tax_ids.filtered(lambda x: x.l10n_cl_sii_code == 14):
values['subtotal_amount_taxable'] += line[key_main_currency] * sign_main_currency
if other_currency:
values['second_currency']['subtotal_amount_taxable'] += line[key_other_currency] * sign_main_currency
elif not line.tax_ids:
values['subtotal_amount_exempt'] += line[key_main_currency] * sign_main_currency
if other_currency:
values['second_currency']['subtotal_amount_exempt'] += line[key_other_currency] * sign_main_currency
values['global_discounts'] = []
for gd in global_discounts:
main_value = currency_round_main_currency.round(abs(gd.price_subtotal)) if \
(not other_currency and not export) or (other_currency and export) else \
currency_round_main_currency.round(abs(gd.balance))
second_value = currency_round_other_currency.round(abs(gd.balance)) if other_currency and export else \
currency_round_other_currency.round(abs(gd.price_subtotal))
values['global_discounts'].append(
{
'name': gd.name,
'global_discount_main_value': main_value,
'global_discount_second_value': second_value if second_value != main_value else False,
'tax_ids': gd.tax_ids,
}
)
values['vat_percent'] = '%.2f' % vat_percent if vat_percent > 0 else False
return values
def _l10n_cl_get_withholdings(self):
"""
This method calculates the section of withholding taxes, or 'other' taxes for the Chilean electronic invoices.
These taxes are not VAT taxes in general; they are special taxes (for example, alcohol or sugar-added beverages,
withholdings for meat processing, fuel, etc.
The taxes codes used are included here:
[15, 17, 18, 19, 24, 25, 26, 27, 271]
http://www.sii.cl/declaraciones_juradas/ddjj_3327_3328/cod_otros_imp_retenc.pdf
The need of the tax is not just the amount, but the code of the tax, the percentage amount and the amount
:return:
"""
self.ensure_one()
tax = [{'tax_code': line.tax_line_id.l10n_cl_sii_code,
'tax_name': line.tax_line_id.name,
'tax_base': abs(sum(self.invoice_line_ids.filtered(
lambda x: line.tax_line_id.l10n_cl_sii_code in x.tax_ids.mapped('l10n_cl_sii_code')).mapped(
'balance'))),
'tax_percent': abs(line.tax_line_id.amount),
'tax_amount_currency': self.currency_id.round(abs(line.amount_currency)),
'tax_amount': self.currency_id.round(abs(line.balance))} for line in self.line_ids.filtered(
lambda x: x.tax_group_id.id in [self.env['account.chart.template'].with_company(self.company_id).ref('tax_group_ila').id,
self.env['account.chart.template'].with_company(self.company_id).ref('tax_group_retenciones').id])]
return tax
def _float_repr_float_round(self, value, decimal_places):
return float_repr(float_round(value, decimal_places), decimal_places)
def _compute_tax_totals(self):
# OVERRIDE 'account'
super()._compute_tax_totals()
for move in self:
if move.tax_totals and move._get_name_invoice_report() == 'l10n_cl.report_invoice_document':
# Disable the recap of tax totals in company currency at the bottom right of the invoice,
# since this info is already present in our custom tax totals grid.
move.tax_totals['display_in_company_currency'] = False
|
