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
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
|
# -*- coding: utf-8 -*-
##############################################################################
#
# Copyright (C) 2011 Associazione OpenERP Italia
# (<http://www.openerp-italia.org>).
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published
# by the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
##############################################################################
import time
from report import report_sxw
from tools.translate import _
from decimal import *
import netsvc
class Parser(report_sxw.rml_parse):
logger = netsvc.Logger()
def _get_partner_type(self, move_line):
partner_type = ''
for line in move_line.move_id.line_id:
if line.account_id.type == 'payable' or line.account_id.type == 'receivable':
if not partner_type:
partner_type = line.account_id.type
elif partner_type != line.account_id.type:
raise Exception(
_('The move %s has different partner account type') % move_line.move_id.name)
return partner_type
def _move_total(self, move_line):
partner_type = self._get_partner_type(move_line)
total = 0.0
for line in move_line.move_id.line_id:
if line.account_id.type == partner_type:
total += (line.debit or line.credit)
return total
# Metto al tax code il segno dell'importo dell'imposta.
# Il tax code ha l'importo in valuta base, ma ha segno negativo per l'IVA a credito (da stampare positiva)
# e per le note di credito (da stampare negative)
def _get_amount_with_sign(self, tax_code_amount, amount):
return abs(tax_code_amount) * cmp(amount, 0)
def _is_refund(self, move_line):
if self._get_partner_type(move_line) == 'receivable' and move_line.debit > move_line.credit:
return True
if self._get_partner_type(move_line) == 'payable' and move_line.debit < move_line.credit:
return True
def _get_line_amount_with_sign(self, move_line):
if self._get_partner_type(move_line) == 'receivable':
return self._get_amount_with_sign(move_line.tax_amount, move_line.credit - move_line.debit)
if self._get_partner_type(move_line) == 'payable':
return self._get_amount_with_sign(move_line.tax_amount, move_line.debit - move_line.credit)
# in valuta base
def _get_invoice_amount_total(self, invoice):
total = 0.0
for inv_tax in invoice.tax_line:
total += self._get_amount_with_sign(inv_tax.base_amount, inv_tax.base) \
+ self._get_amount_with_sign(inv_tax.tax_amount, inv_tax.amount)
return total
# in valuta base
def _get_invoice_amount_untaxed(self, invoice):
total = 0.0
for inv_tax in invoice.tax_line:
total += self._get_amount_with_sign(inv_tax.base_amount, inv_tax.base)
return total
def _get_tax_lines(self, move):
res=[]
tax_obj = self.pool.get('account.tax')
cur_pool = self.pool.get('res.currency')
inv_pool = self.pool.get('account.invoice')
# index è usato per non ripetere la stampa dei dati fattura quando ci sono più codici IVA
index=0
totale_iva = 0.0
totale_iva_inded = 0.0
invoice_amount_total = 0.0
invoice_amount_untaxed = 0.0
related_invoices = []
''' riusciamo a essere sempre indipendenti dalle fatture?
# se c'è l'oggetto fattura, utilizzo il calcolo su fattura
for move_line in move.line_id:
if move_line.invoice and move_line.invoice.id not in related_invoices:
related_invoices.append(move_line.invoice.id)
'''
if related_invoices:
for invoice_id in related_invoices:
return self._get_tax_lines_by_invoice(inv_pool.browse(self.cr, self.uid, invoice_id))
for move_line in move.line_id:
tax_item = {}
if move_line.tax_code_id and move_line.tax_code_id.tax_ids:
# Nel wizard ho già controllato che le eventuali diverse
# imposte abbiamo la stessa aliquota.
# Le diverse imposte devono comunque usare gli stessi tax code
main_tax = tax_obj.get_main_tax(move_line.tax_code_id.tax_ids[0])
if main_tax.exclude_from_registries:
self.logger.notifyChannel("l10n_it_vat_registries", netsvc.LOG_INFO,
_('The tax %s is excluded from registries') % main_tax.name)
continue
# sommo gli imponibili relativi all'imposta corrente
base_amount = 0.0
for line in move_line.move_id.line_id:
if line.tax_code_id.id == main_tax.base_code_id.id:
base_amount += self._get_line_amount_with_sign(line)
if base_amount and main_tax.amount:
actual_tax_amount = base_amount * main_tax.amount
else:
actual_tax_amount = move_line.tax_amount
actual_tax_amount = cur_pool.round(
self.cr, self.uid, move.company_id.currency_id,
actual_tax_amount)
# calcolo % indetraibile
non_deductible = 0.0
if abs(actual_tax_amount) != abs(move_line.tax_amount):
non_deductible = 100
if move_line.tax_amount:
non_deductible = 100 - abs((
move_line.tax_amount * 100.0) / actual_tax_amount)
non_deductible = cur_pool.round(
self.cr, self.uid, move.company_id.currency_id,
non_deductible)
# calcolo il totale dell'operazione
invoice_amount_total = self._move_total(move_line)
if self._is_refund(move_line):
invoice_amount_total = - invoice_amount_total
str_non_deductible = str(non_deductible).split('.')[0]
tax_item = {
'tax_percentage': main_tax.amount and str(
main_tax.amount * 100).split('.')[0] or
move_line.tax_code_id.name,
'tax_code_name': move_line.tax_code_id.name,
'base': base_amount,
'amount': actual_tax_amount,
'non_deductible': str_non_deductible != '0' and
str_non_deductible or '',
'index': index,
'amount_total': invoice_amount_total,
}
res.append(tax_item)
iva = cur_pool.round(
self.cr, self.uid, move.company_id.currency_id,
(actual_tax_amount * (100 - non_deductible) * 0.01))
iva_inded = cur_pool.round(
self.cr, self.uid, move.company_id.currency_id,
(actual_tax_amount * non_deductible * 0.01))
tax_difference= (iva + iva_inded) - actual_tax_amount
# se risulta un'eccedenza, la tolgo dalla parte detraibile
if tax_difference > 0:
iva = iva - tax_difference
# se risulta una mancanza, la aggiungo alla parte indetraibile
elif tax_difference < 0:
iva_inded = iva_inded + tax_difference
totale_iva += iva
invoice_amount_untaxed += base_amount
totale_iva_inded += iva_inded
index += 1
if tax_item:
if tax_item['tax_code_name'] not in self.localcontext[
'tax_codes']:
self.localcontext['tax_codes'][tax_item[
'tax_code_name']] = {
'base': tax_item['base'],
'amount': tax_item['amount'],
}
else:
self.localcontext['tax_codes'][tax_item[
'tax_code_name']]['base'] += tax_item['base']
self.localcontext['tax_codes'][tax_item[
'tax_code_name']]['amount'] += tax_item['amount']
self.localcontext['totali'][
'totale_operazioni'] += invoice_amount_total
self.localcontext['totali'][
'totale_imponibili'] += invoice_amount_untaxed
self.localcontext['totali']['totale_iva'] += totale_iva
self.localcontext['totali']['totale_iva_inded'] += totale_iva_inded
return res
def _get_tax_lines_by_invoice(self, invoice):
res=[]
tax_obj = self.pool.get('account.tax')
# index è usato per non ripetere la stampa dei dati fattura quando ci sono più codici IVA
index = 0
totale_iva = 0.0
totale_iva_inded = 0.0
invoice_amount_total = 0.0
invoice_amount_untaxed = 0.0
for inv_tax in invoice.tax_line:
tax_item = {}
if inv_tax.base_code_id and inv_tax.tax_code_id:
account_tax = tax_obj.get_account_tax(inv_tax)
if account_tax.exclude_from_registries:
self.logger.notifyChannel("l10n_it_vat_registries",
netsvc.LOG_INFO, _(
'The tax %s is excluded from registries')
% account_tax.name)
continue
account_tax_amount = account_tax.amount
invoice_amount_total = self._get_invoice_amount_total(invoice)
invoice_amount_untaxed = self._get_invoice_amount_untaxed(
invoice)
amount = self._get_amount_with_sign(inv_tax.tax_amount,
inv_tax.amount)
base = self._get_amount_with_sign(inv_tax.base_amount,
inv_tax.base)
# calcolo le note di credito con segno invertito
if invoice.type in ('in_refund', 'out_refund'):
amount = -amount
base = -base
invoice_amount_untaxed = -invoice_amount_untaxed
invoice_amount_total = -invoice_amount_total
tax_item = {
'tax_percentage': account_tax_amount and str(
account_tax_amount * 100).split('.')[0] or
inv_tax.tax_code_id.name,
'base': base,
'amount': amount, # in valuta base
'non_deductible': 0.0,
'index': index,
'amount_total': invoice_amount_total,
}
res.append(tax_item)
totale_iva += amount
index += 1
# Se non c'è il tax code imponibile, cerco la tassa relativa alla parte non deducibile
elif inv_tax.tax_code_id:
tax = tax_obj.get_main_tax(tax_obj.get_account_tax(inv_tax))
if tax.exclude_from_registries:
self.logger.notifyChannel("l10n_it_vat_registries",
netsvc.LOG_INFO,
_('The tax %s is excluded from registries') % tax.name)
continue
for inv_tax_2 in invoice.tax_line:
if inv_tax_2.base_code_id and not inv_tax_2.tax_code_id:
base_tax = tax_obj.get_main_tax(
tax_obj.get_account_tax(inv_tax_2))
# Se hanno la stessa tassa
if base_tax.id == tax.id:
# Uso il valore assoluto perchè riferendosi
# alla stessa imposta non ci possono essere
# segni differenti
non_deductible = (abs(inv_tax_2.base_amount) /
(abs(inv_tax.base_amount) + abs(
inv_tax_2.base_amount)) * 100)
invoice_amount_total = \
self._get_invoice_amount_total(invoice)
invoice_amount_untaxed = \
self._get_invoice_amount_untaxed(invoice)
amount = self._get_amount_with_sign(
inv_tax.tax_amount, inv_tax.amount)
base = self._get_amount_with_sign(
inv_tax.base_amount, inv_tax.base)
amount2 = self._get_amount_with_sign(
inv_tax_2.tax_amount, inv_tax_2.amount)
base2 = self._get_amount_with_sign(
inv_tax_2.base_amount, inv_tax_2.base)
# calcolo le note di credito con segno invertito
if invoice.type in ('in_refund', 'out_refund'):
amount = -amount
base = -base
amount2 = -amount2
base2 = -base2
invoice_amount_untaxed = \
-invoice_amount_untaxed
invoice_amount_total = -invoice_amount_total
tax_item = {
'tax_percentage': base_tax.amount and str(
base_tax.amount * 100).split('.')[0] or
inv_tax.tax_code_id.name,
'base': base + base2,
'amount': amount + amount2,
'non_deductible': non_deductible and str(
non_deductible).split('.')[0] or '',
'index': index,
'amount_total': invoice_amount_total,
}
res.append(tax_item)
totale_iva += amount
totale_iva_inded += amount2
index += 1
break
elif not inv_tax.tax_code_id and not inv_tax.base_code_id:
self.logger.notifyChannel("l10n_it_vat_registries",
netsvc.LOG_INFO,
_('The tax %s has no tax codes') % inv_tax.name)
continue
if tax_item:
if tax_item['tax_percentage'] not in self.localcontext[
'tax_codes']:
self.localcontext['tax_codes'][tax_item[
'tax_percentage']] = {
'base': tax_item['base'],
'amount': tax_item['amount'],
}
else:
self.localcontext['tax_codes'][tax_item[
'tax_percentage']]['base'] += tax_item['base']
self.localcontext['tax_codes'][tax_item[
'tax_percentage']]['amount'] += tax_item['amount']
self.localcontext['totali'][
'totale_operazioni'] += invoice_amount_total
self.localcontext['totali'][
'totale_imponibili'] += invoice_amount_untaxed
# da analizzare self.totale_variazioni += invoice.amount_total
self.localcontext['totali']['totale_iva'] += totale_iva
self.localcontext['totali']['totale_iva_inded'] += totale_iva_inded
return res
def __init__(self, cr, uid, name, context):
super(Parser, self).__init__(cr, uid, name, context)
self.localcontext.update({
'time': time,
'tax_lines': self._get_tax_lines,
'totali': {
'totale_operazioni': 0.0,
'totale_imponibili': 0.0,
'totale_variazioni': 0.0,
'totale_iva': 0.0,
'totale_iva_inded': 0.0,
},
'tax_codes': {},
})
report_sxw.report_sxw('report.registro_iva_vendite',
'registro_iva_vendite',
'addons/l10n_it_vat_registries/templates/registro_iva_vendite.mako',
parser=Parser)
report_sxw.report_sxw('report.registro_iva_acquisti',
'registro_iva_acquisti',
'addons/l10n_it_vat_registries/templates/registro_iva_acquisti.mako',
parser=Parser)
report_sxw.report_sxw('report.registro_iva_corrispettivi',
'registro_iva_corrispettivi',
'addons/l10n_it_vat_registries/templates/registro_iva_corrispettivi.mako',
parser=Parser)
|