import base64
from lxml import etree
from odoo import Command
from odoo.addons.l10n_account_edi_ubl_cii_tests.tests.common import TestUBLCommon
from odoo.addons.account.tests.test_account_move_send import TestAccountMoveSendCommon
from odoo.tests import tagged
@tagged('post_install_l10n', 'post_install', '-at_install')
class TestUBLBE(TestUBLCommon, TestAccountMoveSendCommon):
@classmethod
@TestUBLCommon.setup_country("be")
def setUpClass(cls):
super().setUpClass()
cls.company.vat = "BE0246697724"
# seller
cls.partner_1 = cls.env['res.partner'].create({
'name': "partner_1",
'street': "Chaussée de Namur 40",
'zip': "1367",
'city': "Ramillies",
'vat': 'BE0202239951',
'country_id': cls.env.ref('base.be').id,
'bank_ids': [(0, 0, {'acc_number': 'BE15001559627230', 'allow_out_payment': True})],
'ref': 'ref_partner_1',
'invoice_edi_format': 'ubl_bis3',
})
# buyer
cls.partner_2 = cls.env['res.partner'].create({
'name': "partner_2",
'street': "Rue des Bourlottes 9",
'zip': "1367",
'city': "Ramillies",
'vat': 'BE0477472701',
'country_id': cls.env.ref('base.be').id,
'bank_ids': [(0, 0, {'acc_number': 'BE90735788866632', 'allow_out_payment': True})],
'ref': 'ref_partner_2',
'invoice_edi_format': 'ubl_bis3',
})
cls.tax_25 = cls.env['account.tax'].create({
'name': 'tax_25',
'amount_type': 'percent',
'amount': 25,
'type_tax_use': 'purchase',
'country_id': cls.env.ref('base.be').id,
})
cls.tax_21 = cls.env['account.tax'].create({
'name': 'tax_21',
'amount_type': 'percent',
'amount': 21,
'type_tax_use': 'sale',
'country_id': cls.env.ref('base.be').id,
'sequence': 10,
})
cls.tax_15 = cls.env['account.tax'].create({
'name': 'tax_15',
'amount_type': 'percent',
'amount': 15,
'type_tax_use': 'sale',
'country_id': cls.env.ref('base.be').id,
})
cls.tax_12 = cls.env['account.tax'].create({
'name': 'tax_12',
'amount_type': 'percent',
'amount': 12,
'type_tax_use': 'sale',
'country_id': cls.env.ref('base.be').id,
})
cls.tax_6 = cls.env['account.tax'].create({
'name': 'tax_6',
'amount_type': 'percent',
'amount': 6,
'type_tax_use': 'sale',
'country_id': cls.env.ref('base.be').id,
})
cls.tax_0 = cls.env['account.tax'].create({
'name': 'tax_0',
'amount_type': 'percent',
'amount': 0,
'type_tax_use': 'sale',
'country_id': cls.env.ref('base.be').id,
})
cls.env['res.partner.bank'].sudo().create({
'acc_number': 'BE15001559627230',
'partner_id': cls.company_data['company'].partner_id.id,
})
cls.pay_term = cls.env['account.payment.term'].create({
'name': "2/7 Net 30",
'note': "Payment terms: 30 Days, 2% Early Payment Discount under 7 days",
'early_discount': True,
'discount_percentage': 2,
'discount_days': 7,
'line_ids': [
Command.create({'value': 'percent', 'value_amount': 100.0, 'nb_days': 30})],
})
####################################################
# Test export - import
####################################################
def test_export_import_invoice(self):
invoice = self._generate_move(
self.partner_1,
self.partner_2,
move_type='out_invoice',
delivery_date='2017-01-15',
invoice_line_ids=[
{
'product_id': self.product_a.id,
'quantity': 2.0,
'product_uom_id': self.env.ref('uom.product_uom_dozen').id,
'price_unit': 990.0,
'discount': 10.0,
'tax_ids': [(6, 0, self.tax_21.ids)],
},
{
'product_id': self.product_b.id,
'quantity': 10.0,
'product_uom_id': self.env.ref('uom.product_uom_unit').id,
'price_unit': 100.0,
'tax_ids': [(6, 0, self.tax_12.ids)],
},
{
'product_id': self.product_b.id,
'quantity': -1.0,
'product_uom_id': self.env.ref('uom.product_uom_unit').id,
'price_unit': 100.0,
'tax_ids': [(6, 0, self.tax_12.ids)],
},
],
)
attachment = self._assert_invoice_attachment(
invoice.ubl_cii_xml_id,
xpaths=f'''
___ignore___
___ignore___
___ignore___
___ignore___
___ignore___
application/pdf
{invoice.invoice_pdf_report_id.name}
''',
expected_file_path='from_odoo/bis3_out_invoice.xml',
)
self.assertEqual(attachment.name[-12:], "ubl_bis3.xml")
self._assert_imported_invoice_from_etree(invoice, attachment)
def test_export_import_refund(self):
refund = self._generate_move(
self.partner_1,
self.partner_2,
move_type='out_refund',
invoice_line_ids=[
{
'product_id': self.product_a.id,
'quantity': 2.0,
'product_uom_id': self.env.ref('uom.product_uom_dozen').id,
'price_unit': 990.0,
'discount': 10.0,
'tax_ids': [(6, 0, self.tax_21.ids)],
},
{
'product_id': self.product_b.id,
'quantity': 10.0,
'product_uom_id': self.env.ref('uom.product_uom_unit').id,
'price_unit': 100.0,
'tax_ids': [(6, 0, self.tax_12.ids)],
},
{
'product_id': self.product_b.id,
'quantity': -1.0,
'product_uom_id': self.env.ref('uom.product_uom_unit').id,
'price_unit': 100.0,
'tax_ids': [(6, 0, self.tax_12.ids)],
},
],
)
attachment = self._assert_invoice_attachment(
refund.ubl_cii_xml_id,
xpaths=f'''
___ignore___
___ignore___
___ignore___
___ignore___
___ignore___
application/pdf
{refund.invoice_pdf_report_id.name}
''',
expected_file_path='from_odoo/bis3_out_refund.xml',
)
self.assertEqual(attachment.name[-12:], "ubl_bis3.xml")
self._assert_imported_invoice_from_etree(refund, attachment)
def test_encoding_in_attachment_ubl(self):
invoice = self._generate_move(
seller=self.partner_1,
buyer=self.partner_2,
move_type='out_invoice',
invoice_line_ids=[{'product_id': self.product_a.id}],
)
self._test_encoding_in_attachment(invoice.ubl_cii_xml_id, 'ubl_bis3.xml')
####################################################
# Test import
####################################################
def test_import_partner_ubl(self):
invoice = self._generate_move(
seller=self.partner_1,
buyer=self.partner_2,
move_type='out_invoice',
invoice_line_ids=[{'product_id': self.product_a.id}],
)
self._test_import_partner(invoice.ubl_cii_xml_id, self.partner_1, self.partner_2)
def test_import_in_journal_ubl(self):
invoice = self._generate_move(
seller=self.partner_1,
buyer=self.partner_2,
move_type='out_invoice',
invoice_line_ids=[{'product_id': self.product_a.id}],
)
self._test_import_in_journal(invoice.ubl_cii_xml_id)
def test_import_and_create_partner_ubl(self):
""" Tests whether the partner is created at import if no match is found when decoding the EDI attachment
"""
partner_vals = {
'name': "Buyer",
'email': "buyer@yahoo.com",
'phone': "1111",
'vat': "BE980737405",
}
# assert there is no matching partner
partner_match = self.env['res.partner']._retrieve_partner(**partner_vals)
self.assertFalse(partner_match)
# Import attachment as an invoice
invoice = self.env['account.move'].create({
'move_type': 'out_invoice',
'journal_id': self.company_data['default_journal_sale'].id,
})
self._update_invoice_from_file(
module_name='l10n_account_edi_ubl_cii_tests',
subfolder='tests/test_files/from_odoo',
filename='ubl_test_import_partner.xml',
invoice=invoice)
# assert a new partner has been created
self.assertRecordValues(invoice.partner_id, [partner_vals])
def test_import_export_invoice_xml(self):
"""
Test whether the elements only specific to ubl_be are correctly exported
and imported in the xml file
"""
acc_bank = self.env['res.partner.bank'].create({
'acc_number': 'BE15001559627231',
'partner_id': self.company_data['company'].partner_id.id,
'allow_out_payment': True,
})
invoice = self._generate_move(
self.partner_1,
self.partner_2,
move_type='out_invoice',
partner_id=self.partner_1.id,
partner_bank_id=acc_bank.id,
invoice_date='2017-01-01',
date='2017-01-01',
invoice_line_ids=[{
'product_id': self.product_a.id,
'product_uom_id': self.env.ref('uom.product_uom_dozen').id,
'price_unit': 275.0,
'quantity': 5,
'discount': 20.0,
'tax_ids': [(6, 0, self.tax_21.ids)],
}],
)
attachment = invoice.ubl_cii_xml_id
self.assertTrue(attachment)
xml_content = base64.b64decode(attachment.with_context(bin_size=False).datas)
xml_etree = self.get_xml_tree_from_string(xml_content)
self.assertEqual(
xml_etree.find('{*}ProfileID').text,
'urn:fdc:peppol.eu:2017:poacc:billing:01:1.0'
)
self.assertEqual(
xml_etree.find('{*}CustomizationID').text,
'urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu:2017:poacc:billing:3.0'
)
# Export: in bis3, under Country, the Name element should not appear, but IdentificationCode still should
self.assertIsNotNone(xml_etree.find('.//{*}Country/{*}IdentificationCode'))
self.assertIsNone(xml_etree.find('.//{*}Country/{*}Name'))
# Import:
created_bill = self.env['account.move'].create({'move_type': 'in_invoice'})
self.env['res.partner'].search([('vat', '=', 'BE0246697724'), ('id', '!=', self.company_data['company'].id)]).vat = False # clean demo company to avoid picking it as a partner
created_bill.message_post(attachment_ids=[attachment.id])
self.assertTrue(created_bill)
def test_import_invoice_xml(self):
kwargs = {
'subfolder': 'tests/test_files/from_odoo',
'invoice_vals': {
'currency_id': self.other_currency.id,
'amount_total': 3164.22,
'amount_tax': 482.22,
'invoice_lines': [{
'price_subtotal': subtotal,
'price_unit': price_unit,
'discount': discount,
} for (subtotal, price_unit, discount) in [(1782, 990, 10), (1000, 100, 0), (-100, 100, 0)]]
},
}
self._assert_imported_invoice_from_file(filename='bis3_out_invoice.xml', **kwargs)
# same as the file above, but the are missing in the invoice lines
self._assert_imported_invoice_from_file(filename='bis3_out_invoice_no_prices.xml', **kwargs)
def test_import_invoice_xml_open_peppol_examples(self):
self.env['res.partner.bank'].sudo().create({
'acc_number': 'IBAN32423940',
'partner_id': self.company_data['company'].partner_id.id,
})
# Source: https://github.com/OpenPEPPOL/peppol-bis-invoice-3/tree/master/rules/examples
subfolder = 'tests/test_files/from_peppol-bis-invoice-3_doc'
# source: Allowance-example.xml
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_allowance.xml',
invoice_vals={
'amount_total': 7125,
'amount_tax': 1225,
'invoice_lines': [{'price_subtotal': x} for x in (200, -200, 4000, 1000, 900)],
},
)
# source: base-creditnote-correction.xml
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_credit_note.xml',
move_type='in_refund',
invoice_vals={
'amount_total': 1656.25,
'amount_tax': 331.25,
'invoice_lines': [{'price_subtotal': x} for x in (25, 2800, -1500)],
},
)
# source: base-negative-inv-correction.xml
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_invoice_negative_amounts.xml',
move_type='in_refund',
invoice_vals={
'amount_total': 1656.25,
'amount_tax': 331.25,
'invoice_lines': [{'price_subtotal': x} for x in (25, 2800, -1500)],
},
)
# source: base-creditnote-correction.xml with ignored LineExtensionAmount
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_invoice_ignore_lineextensionamount.xml',
invoice_vals={
'amount_total': 1000,
'amount_tax': 0,
'invoice_lines': [{'price_subtotal': 1000}],
}
)
# source: vat-category-E.xml
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_tax_exempt_gbp.xml',
invoice_vals={
'currency_id': self.env.ref('base.GBP').id,
'amount_total': 1200,
'amount_tax': 0,
'invoice_lines': [{'price_subtotal': 1200}],
},
)
def test_import_existing_invoice_flip_move_type(self):
""" Tests whether the move_type of an existing invoice can be flipped when importing an attachment
For instance: with an email alias to create account_move, first the move is created (using alias_defaults,
which contains move_type = 'out_invoice') then the attachment is decoded, if it represents a credit note,
the move type needs to be changed to 'out_refund'
"""
invoice = self.env['account.move'].create({'move_type': 'out_invoice'})
self._update_invoice_from_file(
'l10n_account_edi_ubl_cii_tests',
'tests/test_files/from_odoo',
'bis3_out_refund.xml',
invoice,
)
self.assertRecordValues(invoice, [{'move_type': 'out_refund', 'amount_total': 3164.22}])
def test_import_fixed_taxes(self):
""" Tests whether we correctly decode the xml attachments created using fixed taxes.
See the tests above to create these xml attachments ('test_export_with_fixed_taxes_case_[X]').
NB: use move_type = 'out_invoice' s.t. we can retrieve the taxes used to create the invoices.
"""
subfolder = "tests/test_files/from_odoo"
# The tax 21% from l10n_be is retrieved since it's a duplicate of self.tax_21
tax_21 = self.env.ref(f'account.{self.env.company.id}_attn_VAT-OUT-21-L')
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_ecotaxes_case1.xml',
move_type='out_invoice',
invoice_vals={
'currency_id': self.other_currency.id,
'amount_total': 121,
'amount_tax': 22,
'invoice_lines': [{
'price_unit': 99,
'discount': 0,
'price_subtotal': 99,
'tax_ids': (tax_21 + self.recupel).ids,
}]
}
)
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_ecotaxes_case2.xml',
move_type='out_invoice',
invoice_vals={
'currency_id': self.other_currency.id,
'amount_total': 121,
'amount_tax': 23,
'invoice_lines': [{
'price_unit': 98,
'discount': 0,
'price_subtotal': 98,
'tax_ids': (tax_21 + self.recupel + self.auvibel).ids,
}]
},
)
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_ecotaxes_case3.xml',
move_type='out_invoice',
invoice_vals={
'currency_id': self.other_currency.id,
'amount_total': 121,
'amount_tax': 22,
'invoice_lines': [{
'price_unit': 99,
'discount': 0,
'price_subtotal': 99,
'tax_ids': (tax_21 + self.recupel).ids,
}]
},
)
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_ecotaxes_case4.xml',
move_type='out_invoice',
invoice_vals={
'currency_id': self.other_currency.id,
'amount_total': 218.04,
'amount_tax': 39.84,
'invoice_lines': [{
'price_unit': 99,
'quantity': 2,
'discount': 10,
'price_subtotal': 178.2,
'tax_ids': (tax_21 + self.recupel).ids,
}]
},
)
def test_import_payment_terms(self):
# The tax 21% from l10n_be is retrieved since it's a duplicate of self.tax_21
tax_21 = self.env.ref(f'account.{self.env.company.id}_attn_VAT-OUT-21-L')
self._assert_imported_invoice_from_file(
subfolder='tests/test_files/from_odoo',
filename='bis3_pay_term.xml',
move_type='out_invoice',
invoice_vals={
'currency_id': self.other_currency.id,
'amount_total': 3105.68,
'amount_tax': 505.68,
'invoice_lines': [
{
'price_unit': price_unit,
'price_subtotal': price_unit,
'discount': 0,
'tax_ids': tax.ids,
} for (price_unit, tax) in [
(-4, self.tax_6),
(-48, tax_21),
(52, self.tax_0),
(200, self.tax_6),
(2400, tax_21),
]
]
},
)
####################################################
# Test Send & print
####################################################
def test_send_and_print(self):
invoice = self._generate_move(
self.partner_1,
self.partner_2,
send=False,
move_type='out_invoice',
invoice_line_ids=[
{
'product_id': self.product_a.id,
'tax_ids': [Command.set(self.tax_21.ids)],
},
],
)
self.assertEqual(self.partner_2.invoice_edi_format, 'ubl_bis3')
wizard = self.create_send_and_print(invoice, sending_methods=['manual'])
self.assertRecordValues(wizard, [{
'sending_methods': ['manual'],
'invoice_edi_format': 'ubl_bis3',
'extra_edi_checkboxes': False,
}])
self._assert_mail_attachments_widget(wizard, [
{
'mimetype': 'application/pdf',
'name': 'INV_2017_00001.pdf',
'placeholder': True,
},
{
'mimetype': 'application/xml',
'name': 'INV_2017_00001_ubl_bis3.xml',
'placeholder': True,
},
])
self.assertFalse(invoice.invoice_pdf_report_id)
self.assertFalse(invoice.ubl_cii_xml_id)
# Send.
wizard.action_send_and_print()
self.assertTrue(invoice.invoice_pdf_report_id)
self.assertTrue(invoice.ubl_cii_xml_id)
invoice_attachments = self.env['ir.attachment'].search([
('res_model', '=', invoice._name),
('res_id', '=', invoice.id),
('res_field', 'in', ('invoice_pdf_report_file', 'ubl_cii_xml_file')),
])
self.assertEqual(len(invoice_attachments), 2)
# Send again.
wizard = self.create_send_and_print(invoice, sending_methods=['manual'])
self.assertRecordValues(wizard, [{
'sending_methods': ['manual'],
'invoice_edi_format': 'ubl_bis3',
}])
self._assert_mail_attachments_widget(wizard, [
{
'id': invoice.invoice_pdf_report_id.id,
'mimetype': 'application/pdf',
'name': 'INV_2019_00001.pdf',
},
{
'id': invoice.ubl_cii_xml_id.id,
'mimetype': 'application/xml',
'name': 'INV_2019_00001_ubl_bis3.xml',
},
])
wizard.action_send_and_print()
self.assertTrue(invoice.invoice_pdf_report_id)
self.assertTrue(invoice.ubl_cii_xml_id)
invoice_attachments = self.env['ir.attachment'].search([
('res_model', '=', invoice._name),
('res_id', '=', invoice.id),
('res_field', 'in', ('invoice_pdf_report_file', 'ubl_cii_xml_file')),
])
self.assertEqual(len(invoice_attachments), 2)
def test_import_quantity_and_or_unit_price_zero(self):
""" Tests some special handling cases in which the quantity or unit_price are missing.
"""
subfolder = "tests/test_files/from_odoo"
# The tax 21% from l10n_be is retrieved since it's a duplicate of self.tax_21
tax_21 = self.env.ref(f'account.{self.env.company.id}_attn_VAT-OUT-21-L')
self._assert_imported_invoice_from_file(
subfolder=subfolder,
filename='bis3_out_invoice_quantity_and_or_unit_price_zero.xml',
move_type='out_invoice',
invoice_vals={
'amount_total': 3630,
'amount_tax': 630,
'currency_id': self.other_currency.id,
'invoice_lines': [
{
'price_unit': price_unit,
'quantity': quantity,
'discount': 0,
'tax_ids': tax_21.ids,
'price_subtotal': 1000,
} for price_unit, quantity in [(1000, 1), (100, 10), (10, 100)]
]
}
)