371 lines
22 KiB
Python
371 lines
22 KiB
Python
# Part of Odoo. See LICENSE file for full copyright and licensing details.
|
||
from odoo import models, fields, api, _
|
||
from odoo.osv import expression
|
||
from odoo.exceptions import UserError, RedirectWarning, ValidationError
|
||
from dateutil.relativedelta import relativedelta
|
||
import logging
|
||
_logger = logging.getLogger(__name__)
|
||
|
||
|
||
class AccountMove(models.Model):
|
||
|
||
_inherit = 'account.move'
|
||
|
||
@api.model
|
||
def _l10n_ar_get_document_number_parts(self, document_number, document_type_code):
|
||
# import shipments
|
||
if document_type_code in ['66', '67']:
|
||
pos = invoice_number = '0'
|
||
else:
|
||
pos, invoice_number = document_number.split('-')
|
||
return {'invoice_number': int(invoice_number), 'point_of_sale': int(pos)}
|
||
|
||
l10n_ar_afip_responsibility_type_id = fields.Many2one(
|
||
'l10n_ar.afip.responsibility.type', string='AFIP Responsibility Type', help='Defined by AFIP to'
|
||
' identify the type of responsibilities that a person or a legal entity could have and that impacts in the'
|
||
' type of operations and requirements they need.')
|
||
|
||
# Mostly used on reports
|
||
l10n_ar_afip_concept = fields.Selection(
|
||
compute='_compute_l10n_ar_afip_concept', selection='_get_afip_invoice_concepts', string="AFIP Concept",
|
||
help="A concept is suggested regarding the type of the products on the invoice.")
|
||
l10n_ar_afip_service_start = fields.Date(string='AFIP Service Start Date')
|
||
l10n_ar_afip_service_end = fields.Date(string='AFIP Service End Date')
|
||
|
||
def _is_manual_document_number(self):
|
||
""" Document number should be manual input by user when the journal use documents and
|
||
|
||
* if sales journal and not a AFIP pos (liquido producto case)
|
||
* if purchase journal and not a AFIP pos (regular case of vendor bills)
|
||
|
||
All the other cases the number should be automatic set, wiht only one exception, for pre-printed/online AFIP
|
||
POS type, the first numeber will be always set manually by the user and then will be computed automatically
|
||
from there """
|
||
if self.country_code != 'AR':
|
||
return super()._is_manual_document_number()
|
||
|
||
# NOTE: There is a corner case where 2 sales documents can have the same number for the same DOC from a
|
||
# different vendor, in that case, the user can create a new Sales Liquido Producto Journal
|
||
return self.l10n_latam_use_documents and self.journal_id.type in ['purchase', 'sale'] and \
|
||
not self.journal_id.l10n_ar_is_pos
|
||
|
||
@api.constrains('move_type', 'journal_id')
|
||
def _check_moves_use_documents(self):
|
||
""" Do not let to create not invoices entries in journals that use documents """
|
||
not_invoices = self.filtered(lambda x: x.company_id.account_fiscal_country_id.code == "AR" and x.journal_id.type in ['sale', 'purchase'] and x.l10n_latam_use_documents and not x.is_invoice())
|
||
if not_invoices:
|
||
raise ValidationError(_("The selected Journal can't be used in this transaction, please select one that doesn't use documents as these are just for Invoices."))
|
||
|
||
@api.constrains('move_type', 'l10n_latam_document_type_id')
|
||
def _check_invoice_type_document_type(self):
|
||
""" LATAM module define that we are not able to use debit_note or invoice document types in an invoice refunds,
|
||
However for Argentinian Document Type's 99 (internal type = invoice) we are able to used in a refund invoices.
|
||
|
||
In this method we exclude the argentinian documents that can be used as invoice and refund from the generic
|
||
constraint """
|
||
docs_used_for_inv_and_ref = self.filtered(
|
||
lambda x: x.country_code == 'AR' and
|
||
x.l10n_latam_document_type_id.code in self._get_l10n_ar_codes_used_for_inv_and_ref() and
|
||
x.move_type in ['out_refund', 'in_refund'])
|
||
|
||
super(AccountMove, self - docs_used_for_inv_and_ref)._check_invoice_type_document_type()
|
||
|
||
def _get_afip_invoice_concepts(self):
|
||
""" Return the list of values of the selection field. """
|
||
return [('1', 'Products / Definitive export of goods'), ('2', 'Services'), ('3', 'Products and Services'),
|
||
('4', '4-Other (export)')]
|
||
|
||
@api.depends('invoice_line_ids', 'invoice_line_ids.product_id', 'invoice_line_ids.product_id.type', 'journal_id')
|
||
def _compute_l10n_ar_afip_concept(self):
|
||
recs_afip = self.filtered(lambda x: x.company_id.account_fiscal_country_id.code == "AR" and x.l10n_latam_use_documents)
|
||
for rec in recs_afip:
|
||
rec.l10n_ar_afip_concept = rec._get_concept()
|
||
remaining = self - recs_afip
|
||
remaining.l10n_ar_afip_concept = ''
|
||
|
||
def _get_concept(self):
|
||
""" Method to get the concept of the invoice considering the type of the products on the invoice """
|
||
self.ensure_one()
|
||
invoice_lines = self.invoice_line_ids.filtered(lambda x: x.display_type not in ('line_note', 'line_section'))
|
||
product_types = set([x.product_id.type for x in invoice_lines if x.product_id])
|
||
consumable = {'consu'}
|
||
service = set(['service'])
|
||
# on expo invoice you can mix services and products
|
||
expo_invoice = self.l10n_latam_document_type_id.code in ['19', '20', '21']
|
||
|
||
# WSFEX 1668 - If Expo invoice and we have a "IVA Liberado – Ley Nº 19.640" (Zona Franca) partner
|
||
# then AFIP concept to use should be type "Others (4)"
|
||
is_zona_franca = self.partner_id.l10n_ar_afip_responsibility_type_id == self.env.ref("l10n_ar.res_IVA_LIB")
|
||
# Default value "product"
|
||
afip_concept = '1'
|
||
if expo_invoice and is_zona_franca:
|
||
afip_concept = '4'
|
||
elif product_types == service:
|
||
afip_concept = '2'
|
||
elif product_types - consumable and product_types - service and not expo_invoice:
|
||
afip_concept = '3'
|
||
return afip_concept
|
||
|
||
@api.model
|
||
def _get_l10n_ar_codes_used_for_inv_and_ref(self):
|
||
""" List of document types that can be used as an invoice and refund. This list can be increased once needed
|
||
and demonstrated. As far as we've checked document types of wsfev1 don't allow negative amounts so, for example
|
||
document 61 could not be used as refunds. """
|
||
return ['99', '186', '188', '189', '60']
|
||
|
||
def _get_l10n_latam_documents_domain(self):
|
||
self.ensure_one()
|
||
domain = super()._get_l10n_latam_documents_domain()
|
||
if self.journal_id.company_id.account_fiscal_country_id.code == "AR":
|
||
letters = self.journal_id._get_journal_letter(counterpart_partner=self.partner_id.commercial_partner_id)
|
||
domain += ['|', ('l10n_ar_letter', '=', False), ('l10n_ar_letter', 'in', letters)]
|
||
domain = expression.AND([
|
||
domain or [],
|
||
self.journal_id._get_journal_codes_domain(),
|
||
])
|
||
if self.move_type in ['out_refund', 'in_refund']:
|
||
domain = ['|', ('code', 'in', self._get_l10n_ar_codes_used_for_inv_and_ref())] + domain
|
||
return domain
|
||
|
||
def _check_argentinean_invoice_taxes(self):
|
||
|
||
# check vat on companies thats has it (Responsable inscripto)
|
||
for inv in self.filtered(lambda x: x.company_id.l10n_ar_company_requires_vat):
|
||
purchase_aliquots = 'not_zero'
|
||
# we require a single vat on each invoice line except from some purchase documents
|
||
if inv.move_type in ['in_invoice', 'in_refund'] and inv.l10n_latam_document_type_id.purchase_aliquots == 'zero':
|
||
purchase_aliquots = 'zero'
|
||
for line in inv.mapped('invoice_line_ids').filtered(lambda x: x.display_type not in ('line_section', 'line_note')):
|
||
vat_taxes = line.tax_ids.filtered(lambda x: x.tax_group_id.l10n_ar_vat_afip_code)
|
||
if len(vat_taxes) != 1:
|
||
raise UserError(_("There should be a single tax from the “VAT“ tax group per line, but this is not the case for line “%s”. Please add a tax to this line or check the tax configuration's advanced options for the corresponding field “Tax Group”.", line.name))
|
||
|
||
elif purchase_aliquots == 'zero' and vat_taxes.tax_group_id.l10n_ar_vat_afip_code != '0':
|
||
raise UserError(_('On invoice id “%s” you must use VAT Not Applicable on every line.', inv.id))
|
||
elif purchase_aliquots == 'not_zero' and vat_taxes.tax_group_id.l10n_ar_vat_afip_code == '0':
|
||
raise UserError(_('On invoice id “%s” you must use a VAT tax that is not VAT Not Applicable', inv.id))
|
||
|
||
def _set_afip_service_dates(self):
|
||
for rec in self.filtered(lambda m: m.invoice_date and m.l10n_ar_afip_concept in ['2', '3', '4']):
|
||
if not rec.l10n_ar_afip_service_start:
|
||
rec.l10n_ar_afip_service_start = rec.invoice_date + relativedelta(day=1)
|
||
if not rec.l10n_ar_afip_service_end:
|
||
rec.l10n_ar_afip_service_end = rec.invoice_date + relativedelta(day=1, days=-1, months=+1)
|
||
|
||
def _set_afip_responsibility(self):
|
||
""" We save the information about the receptor responsability at the time we validate the invoice, this is
|
||
necessary because the user can change the responsability after that any time """
|
||
for rec in self:
|
||
rec.l10n_ar_afip_responsibility_type_id = rec.commercial_partner_id.l10n_ar_afip_responsibility_type_id.id
|
||
|
||
@api.onchange('partner_id')
|
||
def _onchange_afip_responsibility(self):
|
||
if self.company_id.account_fiscal_country_id.code == 'AR' and self.l10n_latam_use_documents and self.partner_id \
|
||
and not self.partner_id.l10n_ar_afip_responsibility_type_id:
|
||
return {'warning': {
|
||
'title': _('Missing Partner Configuration'),
|
||
'message': _('Please configure the AFIP Responsibility for "%s" in order to continue',
|
||
self.partner_id.name)}}
|
||
|
||
@api.onchange('partner_id')
|
||
def _onchange_partner_journal(self):
|
||
""" This method is used when the invoice is created from the sale or subscription """
|
||
expo_journals = ['FEERCEL', 'FEEWS', 'FEERCELP']
|
||
for rec in self.filtered(lambda x: x.company_id.account_fiscal_country_id.code == "AR" and x.journal_id.type == 'sale'
|
||
and x.l10n_latam_use_documents and x.partner_id.l10n_ar_afip_responsibility_type_id):
|
||
res_code = rec.partner_id.l10n_ar_afip_responsibility_type_id.code
|
||
domain = [
|
||
*self.env['account.journal']._check_company_domain(rec.company_id),
|
||
('l10n_latam_use_documents', '=', True),
|
||
('type', '=', 'sale'),
|
||
]
|
||
journal = self.env['account.journal']
|
||
msg = False
|
||
if res_code in ['9', '10'] and rec.journal_id.l10n_ar_afip_pos_system not in expo_journals:
|
||
# if partner is foregin and journal is not of expo, we try to change to expo journal
|
||
journal = journal.search(domain + [('l10n_ar_afip_pos_system', 'in', expo_journals)], limit=1)
|
||
msg = _('You are trying to create an invoice for foreign partner but you don\'t have an exportation journal')
|
||
elif res_code not in ['9', '10'] and rec.journal_id.l10n_ar_afip_pos_system in expo_journals:
|
||
# if partner is NOT foregin and journal is for expo, we try to change to local journal
|
||
journal = journal.search(domain + [('l10n_ar_afip_pos_system', 'not in', expo_journals)], limit=1)
|
||
msg = _('You are trying to create an invoice for domestic partner but you don\'t have a domestic market journal')
|
||
if journal:
|
||
rec.journal_id = journal.id
|
||
elif msg:
|
||
# Throw an error to user in order to proper configure the journal for the type of operation
|
||
action = self.env.ref('account.action_account_journal_form')
|
||
raise RedirectWarning(msg, action.id, _('Go to Journals'))
|
||
|
||
def _post(self, soft=True):
|
||
ar_invoices = self.filtered(lambda x: x.company_id.account_fiscal_country_id.code == "AR" and x.l10n_latam_use_documents)
|
||
# We make validations here and not with a constraint because we want validation before sending electronic
|
||
# data on l10n_ar_edi
|
||
ar_invoices._check_argentinean_invoice_taxes()
|
||
posted = super()._post(soft=soft)
|
||
|
||
posted_ar_invoices = posted & ar_invoices
|
||
posted_ar_invoices._set_afip_responsibility()
|
||
posted_ar_invoices._set_afip_service_dates()
|
||
return posted
|
||
|
||
def _reverse_moves(self, default_values_list=None, cancel=False):
|
||
if not default_values_list:
|
||
default_values_list = [{} for move in self]
|
||
for move, default_values in zip(self, default_values_list):
|
||
default_values.update({
|
||
'l10n_ar_afip_service_start': move.l10n_ar_afip_service_start,
|
||
'l10n_ar_afip_service_end': move.l10n_ar_afip_service_end,
|
||
})
|
||
return super()._reverse_moves(default_values_list=default_values_list, cancel=cancel)
|
||
|
||
@api.onchange('l10n_latam_document_type_id', 'l10n_latam_document_number')
|
||
def _inverse_l10n_latam_document_number(self):
|
||
super()._inverse_l10n_latam_document_number()
|
||
|
||
to_review = self.filtered(lambda x: (
|
||
x.journal_id.l10n_ar_is_pos
|
||
and x.l10n_latam_document_type_id
|
||
and x.l10n_latam_document_number
|
||
and (x.l10n_latam_manual_document_number or not x.highest_name)
|
||
and x.l10n_latam_document_type_id.country_id.code == 'AR'
|
||
))
|
||
for rec in to_review:
|
||
number = rec.l10n_latam_document_type_id._format_document_number(rec.l10n_latam_document_number)
|
||
current_pos = int(number.split("-")[0])
|
||
if current_pos != rec.journal_id.l10n_ar_afip_pos_number:
|
||
invoices = self.search([('journal_id', '=', rec.journal_id.id), ('posted_before', '=', True)], limit=1)
|
||
# If there is no posted before invoices the user can change the POS number (x.l10n_latam_document_number)
|
||
if (not invoices):
|
||
rec.journal_id.l10n_ar_afip_pos_number = current_pos
|
||
rec.journal_id._onchange_set_short_name()
|
||
# If not, avoid that the user change the POS number
|
||
else:
|
||
raise UserError(_('The document number can not be changed for this journal, you can only modify'
|
||
' the POS number if there is not posted (or posted before) invoices'))
|
||
|
||
def _get_formatted_sequence(self, number=0):
|
||
return "%s %05d-%08d" % (self.l10n_latam_document_type_id.doc_code_prefix,
|
||
self.journal_id.l10n_ar_afip_pos_number, 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 8 padding number """
|
||
if self.journal_id.l10n_latam_use_documents and self.company_id.account_fiscal_country_id.code == "AR":
|
||
if self.l10n_latam_document_type_id:
|
||
return self._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 == "AR" and self.l10n_latam_use_documents:
|
||
where_string += " AND l10n_latam_document_type_id = %(l10n_latam_document_type_id)s"
|
||
param['l10n_latam_document_type_id'] = self.l10n_latam_document_type_id.id or 0
|
||
return where_string, param
|
||
|
||
def _l10n_ar_get_amounts(self, company_currency=False):
|
||
""" Method used to prepare data to present amounts and taxes related amounts when creating an
|
||
electronic invoice for argentinean and the txt files for digital VAT books. Only take into account the argentinean taxes """
|
||
self.ensure_one()
|
||
amount_field = company_currency and 'balance' or 'amount_currency'
|
||
# if we use balance we need to correct sign (on price_subtotal is positive for refunds and invoices)
|
||
sign = -1 if self.is_inbound() else 1
|
||
|
||
# if we are on a document that works invoice and refund and it's a refund, we need to export it as negative
|
||
sign = -sign if self.move_type in ('out_refund', 'in_refund') and\
|
||
self.l10n_latam_document_type_id.code in self._get_l10n_ar_codes_used_for_inv_and_ref() else sign
|
||
|
||
tax_lines = self.line_ids.filtered('tax_line_id')
|
||
vat_taxes = tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_vat_afip_code)
|
||
|
||
vat_taxable = self.env['account.move.line']
|
||
for line in self.invoice_line_ids:
|
||
if any(tax.tax_group_id.l10n_ar_vat_afip_code and tax.tax_group_id.l10n_ar_vat_afip_code not in ['0', '1', '2'] for tax in line.tax_ids):
|
||
vat_taxable |= line
|
||
|
||
profits_tax_group = self.env['account.chart.template'].with_company(self.company_id).ref(
|
||
'tax_group_percepcion_ganancias',
|
||
raise_if_not_found=False,
|
||
)
|
||
if not profits_tax_group:
|
||
raise RedirectWarning(
|
||
message=_(
|
||
"A required tax group could not be found (XML ID: %s).\n"
|
||
"Please reload your chart template in order to reinstall the required tax group.\n\n"
|
||
"Note: You might have to relink your existing taxes to this new tax group.",
|
||
'tax_group_percepcion_ganancias',
|
||
),
|
||
action=self.env.ref('account.action_account_config').id,
|
||
button_text=_("Accounting Settings"),
|
||
)
|
||
|
||
return {'vat_amount': sign * sum(vat_taxes.mapped(amount_field)),
|
||
# For invoices of letter C should not pass VAT
|
||
'vat_taxable_amount': sign * sum(vat_taxable.mapped(amount_field)) if self.l10n_latam_document_type_id.l10n_ar_letter != 'C' else self.amount_untaxed,
|
||
'vat_exempt_base_amount': sign * sum(self.invoice_line_ids.filtered(lambda x: x.tax_ids.filtered(lambda y: y.tax_group_id.l10n_ar_vat_afip_code == '2')).mapped(amount_field)),
|
||
'vat_untaxed_base_amount': sign * sum(self.invoice_line_ids.filtered(lambda x: x.tax_ids.filtered(lambda y: y.tax_group_id.l10n_ar_vat_afip_code == '1')).mapped(amount_field)),
|
||
# used on FE
|
||
'not_vat_taxes_amount': sign * sum((tax_lines - vat_taxes).mapped(amount_field)),
|
||
# used on BFE + TXT
|
||
'iibb_perc_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_tribute_afip_code == '07').mapped(amount_field)),
|
||
'mun_perc_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_tribute_afip_code == '08').mapped(amount_field)),
|
||
'intern_tax_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_tribute_afip_code == '04').mapped(amount_field)),
|
||
'other_taxes_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_tribute_afip_code == '99').mapped(amount_field)),
|
||
'profits_perc_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id == profits_tax_group).mapped(amount_field)),
|
||
'vat_perc_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_tribute_afip_code == '06').mapped(amount_field)),
|
||
'other_perc_amount': sign * sum(tax_lines.filtered(lambda r: r.tax_line_id.tax_group_id.l10n_ar_tribute_afip_code == '09' and r.tax_line_id.tax_group_id != profits_tax_group).mapped(amount_field)),
|
||
}
|
||
|
||
def _get_vat(self):
|
||
""" Applies on wsfe web service and in the VAT digital books """
|
||
# if we are on a document that works invoice and refund and it's a refund, we need to export it as negative
|
||
sign = -1 if self.move_type in ('out_refund', 'in_refund') and\
|
||
self.l10n_latam_document_type_id.code in self._get_l10n_ar_codes_used_for_inv_and_ref() else 1
|
||
|
||
res = []
|
||
vat_taxable = self.env['account.move.line']
|
||
# get all invoice lines that are vat taxable
|
||
for line in self.line_ids:
|
||
if any(tax.tax_group_id.l10n_ar_vat_afip_code and tax.tax_group_id.l10n_ar_vat_afip_code not in ['0', '1', '2'] for tax in line.tax_line_id) and line['amount_currency']:
|
||
vat_taxable |= line
|
||
for tax_group in vat_taxable.mapped('tax_group_id'):
|
||
base_imp = sum(self.invoice_line_ids.filtered(lambda x: x.tax_ids.filtered(lambda y: y.tax_group_id.l10n_ar_vat_afip_code == tax_group.l10n_ar_vat_afip_code)).mapped('price_subtotal'))
|
||
imp = abs(sum(vat_taxable.filtered(lambda x: x.tax_group_id.l10n_ar_vat_afip_code == tax_group.l10n_ar_vat_afip_code).mapped('amount_currency')))
|
||
res += [{'Id': tax_group.l10n_ar_vat_afip_code,
|
||
'BaseImp': sign * base_imp,
|
||
'Importe': sign * imp}]
|
||
|
||
# Report vat 0%
|
||
vat_base_0 = sum(self.invoice_line_ids.filtered(lambda x: x.tax_ids.filtered(lambda y: y.tax_group_id.l10n_ar_vat_afip_code == '3')).mapped('price_subtotal'))
|
||
if vat_base_0:
|
||
res += [{'Id': '3', 'BaseImp': sign * vat_base_0, 'Importe': 0.0}]
|
||
|
||
return res if res else []
|
||
|
||
def _get_name_invoice_report(self):
|
||
self.ensure_one()
|
||
if self.l10n_latam_use_documents and self.company_id.account_fiscal_country_id.code == 'AR':
|
||
return 'l10n_ar.report_invoice_document'
|
||
return super()._get_name_invoice_report()
|
||
|
||
def _l10n_ar_get_invoice_totals_for_report(self):
|
||
"""If the invoice document type indicates that vat should not be detailed in the printed report (result of _l10n_ar_include_vat()) then we overwrite tax_totals field so that includes taxes in the total amount, otherwise it would be showing amount_untaxed in the amount_total"""
|
||
self.ensure_one()
|
||
tax_totals = self.tax_totals
|
||
include_vat = self._l10n_ar_include_vat()
|
||
if not include_vat:
|
||
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('l10n_ar_vat_afip_code').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_ar_include_vat(self):
|
||
self.ensure_one()
|
||
return self.l10n_latam_document_type_id.l10n_ar_letter in ['B', 'C', 'X', 'R']
|