# -*- coding: utf-8 -*- # Part of Odoo. See LICENSE file for full copyright and licensing details. import re from itertools import product from odoo import Command, _, api, models from .eu_account_map import EU_ACCOUNT_MAP from .eu_tag_map import EU_TAG_MAP from .eu_tax_map import EU_TAX_MAP class Company(models.Model): _inherit = 'res.company' @api.model def _map_all_eu_companies_taxes(self): ''' Identifies EU companies and calls the _map_eu_taxes function ''' eu_countries = self.env.ref('base.europe').country_ids companies = self.search([('account_fiscal_country_id', 'in', eu_countries.ids)]) companies._map_eu_taxes() def _map_eu_taxes(self): '''Creates or updates Fiscal Positions for each EU country excluding the company's account_fiscal_country_id ''' eu_countries = self.env.ref('base.europe').country_ids oss_tax_groups = self.env['ir.model.data'].search([ ('name', 'ilike', 'oss_tax_group'), ('module', '=', 'account'), ('model', '=', 'account.tax.group')]) for company in self: # instantiate OSS taxes on the first branch with a TAX ID, default on root company company = company.parent_ids.filtered(lambda c: c.vat)[-1:] or company.root_id invoice_repartition_lines, refund_repartition_lines = company._get_repartition_lines_oss() taxes = self.env['account.tax'].search([ *self.env['account.tax']._check_company_domain(company), ('type_tax_use', '=', 'sale'), ('amount_type', '=', 'percent'), ('tax_group_id', 'not in', oss_tax_groups.mapped('res_id')) ]) multi_tax_reports_countries_fpos = self.env['account.fiscal.position'].search([ ('foreign_vat', '!=', False), ]) oss_countries = eu_countries - company.account_fiscal_country_id - multi_tax_reports_countries_fpos.country_id for destination_country in oss_countries: mapping = [] fpos = self.env['account.fiscal.position'].search([ ('company_id', '=', company.id), ('country_id', '=', destination_country.id), ('auto_apply', '=', True), ('vat_required', '=', False), ('foreign_vat', '=', False)], limit=1) if not fpos: fpos = self.env['account.fiscal.position'].create({ 'name': f'OSS B2C {destination_country.name}', 'country_id': destination_country.id, 'company_id': company.id, 'auto_apply': True, }) foreign_taxes = {tax.amount: tax for tax in fpos.tax_ids.tax_dest_id if tax.amount_type == 'percent'} for domestic_tax in taxes: tax_amount = EU_TAX_MAP.get((domestic_tax.country_id.code, domestic_tax.amount, destination_country.code), False) if tax_amount and domestic_tax not in fpos.tax_ids.tax_src_id: if not foreign_taxes.get(tax_amount, False): oss_tax_group_local_xml_id = f"{company.id}_oss_tax_group_{str(tax_amount).replace('.', '_')}_{company.account_fiscal_country_id.code}" if not self.env.ref(f"account.{oss_tax_group_local_xml_id}", raise_if_not_found=False): tg = self.env['account.tax.group'].search([ *self.env['account.tax.group']._check_company_domain(company), ('tax_payable_account_id', '!=', False)], limit=1) self.env['ir.model.data'].create({ 'name': oss_tax_group_local_xml_id, 'module': 'account', 'model': 'account.tax.group', 'res_id': self.env['account.tax.group'].create({ 'name': f'OSS {tax_amount}%', 'country_id': company.account_fiscal_country_id.id, 'company_id': company.id, 'tax_payable_account_id': tg.tax_payable_account_id.id, 'tax_receivable_account_id': tg.tax_receivable_account_id.id, }).id, 'noupdate': True, }) foreign_tax_name = f'{tax_amount}% {destination_country.code} {destination_country.vat_label}' existing_foreign_tax = self.env['account.tax'].search([ ('company_id', 'child_of', company.root_id.id), ('name', 'like', foreign_tax_name), ('type_tax_use', '=', 'sale'), ('country_id', '=', company.account_fiscal_country_id.id), ], order='sequence,id desc', limit=1) foreign_tax_copy_name = existing_foreign_tax and _('%(tax_name)s (Copy)', tax_name=existing_foreign_tax.name) foreign_taxes[tax_amount] = self.env['account.tax'].create({ 'name': foreign_tax_copy_name or foreign_tax_name, 'amount': tax_amount, 'invoice_repartition_line_ids': invoice_repartition_lines, 'refund_repartition_line_ids': refund_repartition_lines, 'type_tax_use': 'sale', 'description': f"{tax_amount}%", 'tax_group_id': self.env.ref(f'account.{oss_tax_group_local_xml_id}').id, 'country_id': company.account_fiscal_country_id.id, 'sequence': 1000, 'company_id': company.id, }) mapping.append((0, 0, {'tax_src_id': domestic_tax.id, 'tax_dest_id': foreign_taxes[tax_amount].id})) if mapping: fpos.write({ 'tax_ids': mapping }) def _get_repartition_lines_oss(self): self.ensure_one() oss_account, oss_tags = self._get_oss_account(), self._get_oss_tags() repartition_line_ids = {} for doc_type, rep_type in product(('invoice', 'refund'), ('base', 'tax')): vals = {'document_type': doc_type, 'repartition_type': rep_type, 'tag_ids': [Command.link(tag.id) for tag in oss_tags[f'{doc_type}_{rep_type}_tag']]} if oss_account: vals['account_id'] = oss_account.id repartition_line_ids.setdefault(doc_type, []).append(Command.create(vals)) return repartition_line_ids['invoice'], repartition_line_ids['refund'] def _get_oss_account(self): self.ensure_one() if not (oss_account := self.env.ref(f'l10n_eu_oss.oss_tax_account_company_{self.id}', raise_if_not_found=False)): oss_account = self._create_oss_account() return oss_account def _create_oss_account(self): if ( self.chart_template in EU_ACCOUNT_MAP and (oss_account_if_exists := self.env['account.account'].with_company(self).search([ ('company_ids', '=', self.id), ('code', '=', EU_ACCOUNT_MAP[self.chart_template]) ]) ) ): oss_account = oss_account_if_exists else: sales_tax_accounts = self.env['account.tax'].search([ *self.env['account.tax']._check_company_domain(self), ('type_tax_use', '=', 'sale'), ]).invoice_repartition_line_ids.mapped('account_id') if not sales_tax_accounts: return False new_code = self.env['account.account'].with_company(self)._search_new_account_code(sales_tax_accounts[0].with_company(self).code) oss_account = self.env['account.account'].create({ 'name': f'{sales_tax_accounts[0].name} OSS', 'code': new_code, 'account_type': sales_tax_accounts[0].account_type, 'company_ids': [Command.link(self.id)], 'tag_ids': [(4, tag.id, 0) for tag in sales_tax_accounts[0].tag_ids], }) self.env['ir.model.data'].create({ 'name': f'oss_tax_account_company_{self.id}', 'module': 'l10n_eu_oss', 'model': 'account.account', 'res_id': oss_account.id, 'noupdate': True, }) return oss_account def _get_oss_tags(self): oss_tag = self.env.ref('l10n_eu_oss.tag_oss') country = None # Try to use the VAT country if vat is set and easily guessable if self.vat: country_prefix = re.match('^[a-zA-Z]{2}|^', self.vat).group() if country_prefix: country = self.env['res.country'].search([('code', '=', country_prefix)], limit=1) # otherwise fallback on the fiscal country if not country: country = self.account_fiscal_country_id chart_template = self.env['account.chart.template']._guess_chart_template(country) # If that l10n module isn't installed, it means the company doesn't use any tax report for that country # and thus hasn't nor need those tax report tag is_coa_module_installed = self.env['account.chart.template']._get_chart_template_mapping()[chart_template]['installed'] if not is_coa_module_installed: chart_template = None tag_for_country = EU_TAG_MAP.get(chart_template, { 'invoice_base_tag': None, 'invoice_tax_tag': None, 'refund_base_tag': None, 'refund_tax_tag': None, }) mapping = {} for repartition_line_key, tag_xml_id in tag_for_country.items(): tag = self.env.ref(tag_xml_id) if tag_xml_id else self.env['account.account.tag'] if tag and tag._name == "account.report.expression": tag = tag._get_matching_tags("+") mapping[repartition_line_key] = tag + oss_tag return mapping