l10n_it_fatturapa_in/tests/test_import_fatturapa_xml.py
# -*- coding: utf-8 -*-
from openerp.exceptions import Warning as UserError
from .fatturapa_common import FatturapaCommon
class TestFatturaPAXMLValidation(FatturapaCommon):
def setUp(self):
super(TestFatturaPAXMLValidation, self).setUp()
self.wt = self.create_wt_4q()
self.wtq = self.create_wt_27_20q()
self.wt4q = self.create_wt_26_40q()
self.wt2q = self.create_wt_26_20q()
self.invoice_model = self.env['account.invoice']
def test_00_xml_import(self):
self.env.user.company_id.cassa_previdenziale_product_id = (
self.service.id)
res = self.run_wizard('test0', 'IT05979361218_001.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.partner_id.register_code, 'TO1258B')
self.assertEqual(
invoice.partner_id.register_fiscalpos.code, 'RF02')
self.assertEqual(invoice.reference, 'FT/2015/0006')
self.assertEqual(invoice.supplier_invoice_number, 'FT/2015/0006')
self.assertEqual(invoice.amount_total, 57.00)
self.assertEqual(invoice.gross_weight, 0.00)
self.assertEqual(invoice.net_weight, 0.00)
self.assertEqual(invoice.welfare_fund_ids[0].kind_id.code, 'N4')
self.assertFalse(invoice.art73)
welfare_found = False
for line in invoice.invoice_line:
if line.product_id.id == self.service.id:
self.assertEqual(line.price_unit, 3)
welfare_found = True
self.assertTrue(welfare_found)
self.assertTrue(len(invoice.e_invoice_line_ids) == 1)
self.assertEqual(
invoice.e_invoice_line_ids[0].name, 'Prodotto di test al giorno')
self.assertEqual(
invoice.e_invoice_line_ids[0].qty, 15)
self.assertEqual(
invoice.e_invoice_line_ids[0].uom, 'Giorno(i)')
self.assertEqual(
invoice.e_invoice_line_ids[0].unit_price, 3.6)
self.assertEqual(
invoice.e_invoice_line_ids[0].total_price, 54)
self.assertEqual(
invoice.e_invoice_line_ids[0].tax_amount, 0)
self.assertEqual(
invoice.e_invoice_line_ids[0].tax_kind, 'N4')
self.assertTrue(len(invoice.e_invoice_line_ids[0].other_data_ids) == 2)
self.assertEqual(
invoice.e_invoice_line_ids[0].other_data_ids[0].text_ref,
'Riferimento')
def test_01_xml_import(self):
res = self.run_wizard('test1', 'IT02780790107_11004.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, '123')
self.assertEqual(invoice.amount_untaxed, 34.00)
self.assertEqual(invoice.amount_tax, 7.48)
self.assertEqual(
len(invoice.invoice_line[0].invoice_line_tax_id), 1)
self.assertEqual(
invoice.invoice_line[0].invoice_line_tax_id[0].name,
'22% e-bill')
self.assertEqual(
invoice.fatturapa_summary_ids[0].amount_untaxed, 34.00)
self.assertEqual(
invoice.fatturapa_summary_ids[0].amount_tax, 7.48)
self.assertEqual(
invoice.fatturapa_summary_ids[0].payability, 'D')
self.assertEqual(invoice.partner_id.name, "SOCIETA' ALPHA SRL")
self.assertEqual(invoice.partner_id.street, "VIALE ROMA 543")
self.assertEqual(invoice.partner_id.state_id.code, "SS")
self.assertEqual(invoice.partner_id.country_id.code, "IT")
self.assertEqual(
invoice.tax_representative_id.name, "Rappresentante fiscale")
self.assertEqual(invoice.welfare_fund_ids[0].welfare_rate_tax, 0.04)
order_related_doc = invoice.related_documents.filtered(
lambda rd: rd.type == 'order'
)
self.assertTrue(order_related_doc)
self.assertEqual(order_related_doc.cig, '456def')
self.assertEqual(order_related_doc.cup, '123abc')
self.assertEqual(
invoice.welfare_fund_ids[0].welfare_amount_tax, 9)
self.assertFalse(invoice.welfare_fund_ids[0].welfare_taxable)
self.assertEqual(invoice.unit_weight, 'KGM')
self.assertEqual(invoice.ftpa_incoterms, 'DAP')
self.assertEqual(invoice.fiscal_document_type_id.code, 'TD01')
self.assertTrue(invoice.art73)
def test_02_xml_import(self):
res = self.run_wizard('test02', 'IT05979361218_011.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.intermediary.vat, 'IT03339130126')
def test_04_xml_import(self):
res = self.run_wizard('test4', 'IT02780790107_11005.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, '124')
self.assertEqual(invoice.partner_id.name, 'SOCIETA\' ALPHA SRL')
self.assertEqual(
invoice.invoice_line[0].invoice_line_tax_id[0].name,
'22% e-bill')
self.assertEqual(
invoice.invoice_line[1].invoice_line_tax_id[0].name,
'22% e-bill')
self.assertEqual(
invoice.invoice_line[0].invoice_line_tax_id[0].amount, 0.22)
self.assertEqual(
invoice.invoice_line[1].invoice_line_tax_id[0].amount, 0.22)
self.assertEqual(
invoice.invoice_line[1].price_unit, 2)
self.assertTrue(len(invoice.e_invoice_line_ids) == 2)
for e_line in invoice.e_invoice_line_ids:
self.assertTrue(e_line.line_number in (1, 2))
if e_line.line_number == 1:
self.assertEqual(
e_line.cod_article_ids[0].name, 'EAN')
self.assertEqual(
e_line.cod_article_ids[0].code_val, '12345')
self.assertEqual(
invoice.inconsistencies,
u"Company Name field contains 'Societa\' "
u"Alpha SRL'. Your System contains 'SOCIETA\' ALPHA SRL'\n\n")
def test_05_xml_import(self):
res = self.run_wizard('test5', 'IT05979361218_003.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, 'FT/2015/0008')
self.assertEqual(invoice.sender, 'TZ')
self.assertEqual(invoice.intermediary.name, 'ROSSI MARIO')
self.assertEqual(invoice.intermediary.firstname, 'MARIO')
self.assertEqual(invoice.intermediary.lastname, 'ROSSI')
self.assertEqual(
invoice.e_invoice_line_ids[0].discount_rise_price_ids[0].name,
'SC')
self.assertEqual(
invoice.e_invoice_line_ids[0].discount_rise_price_ids[0].
percentage, 10
)
self.assertEqual(invoice.amount_untaxed, 9)
self.assertEqual(invoice.amount_tax, 0)
self.assertEqual(invoice.amount_total, 9)
def test_06_import_except(self):
# File not exist Exception
self.assertRaises(
Exception, self.run_wizard, 'test6_Exception', '')
# fake Signed file is passed , generate orm_exception
self.assertRaises(
UserError, self.run_wizard, 'test6_orm_exception',
'IT05979361218_fake.xml.p7m'
)
def test_07_xml_import(self):
# 2 lines with quantity != 1 and discounts
res = self.run_wizard('test7', 'IT05979361218_004.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, 'FT/2015/0009')
self.assertAlmostEqual(invoice.amount_untaxed, 1173.60)
self.assertEqual(invoice.amount_tax, 258.19)
self.assertEqual(invoice.amount_total, 1431.79)
self.assertAlmostEqual(
invoice.e_invoice_amount_untaxed, invoice.amount_untaxed)
self.assertAlmostEqual(
invoice.e_invoice_amount_tax, invoice.amount_tax)
self.assertEqual(invoice.e_invoice_validation_error, False)
self.assertEqual(invoice.invoice_line[0].admin_ref, 'D122353')
def test_08_xml_import(self):
# using ImportoTotaleDocumento
res = self.run_wizard('test8', 'IT05979361218_005.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, 'FT/2015/0010')
self.assertAlmostEqual(invoice.amount_total, 1288.61)
self.assertFalse(invoice.inconsistencies)
def test_09_xml_import(self):
# using DatiGeneraliDocumento.ScontoMaggiorazione without
# ImportoTotaleDocumento
# add test file name case sensitive
res = self.run_wizard('test9', 'IT05979361218_006.XML')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, 'FT/2015/0011')
self.assertAlmostEqual(invoice.amount_total, 1288.61)
self.assertEqual(
invoice.inconsistencies,
'Computed amount untaxed 1056.24 is different from'
' summary data 1173.6')
# FIXME untaxed value 1030.42 in v. 12.0
def test_10_xml_import(self):
# Fix Date format
res = self.run_wizard('test6', 'IT05979361218_007.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, 'FT/2015/0009')
self.assertEqual(
invoice.date_invoice, '2015-03-16')
self.assertEqual(
invoice.fatturapa_payments[0].payment_methods[0].payment_due_date,
'2015-06-03'
)
self.assertEqual(
invoice.fatturapa_payments[0].payment_methods[0].
fatturapa_pm_id.code,
'MP18'
)
def test_11_xml_import(self):
# DatiOrdineAcquisto with RiferimentoNumeroLinea referring to
# not existing invoice line
res = self.run_wizard('test11', 'IT02780790107_11006.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(
len(invoice.invoice_line[0].related_documents), 0)
self.assertEqual(
invoice.invoice_line[0].sequence, 1)
self.assertEqual(
invoice.related_documents[0].type, "order")
self.assertEqual(
invoice.related_documents[0].lineRef, 60)
def test_12_xml_import(self):
res = self.run_wizard('test12', 'IT05979361218_008.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, 'FT/2015/0012')
self.assertEqual(invoice.sender, 'TZ')
self.assertEqual(invoice.intermediary.name, 'ROSSI MARIO')
self.assertEqual(invoice.intermediary.firstname, 'MARIO')
self.assertEqual(invoice.intermediary.lastname, 'ROSSI')
def test_13_xml_import(self):
# inconsistencies must not be duplicated
res = self.run_wizard_multi([
'IT02780790107_11005.xml',
'IT02780790107_11005.xml',
])
invoice1_id = res.get('domain')[0][2][0]
invoice2_id = res.get('domain')[0][2][1]
invoice1 = self.invoice_model.browse(invoice1_id)
invoice2 = self.invoice_model.browse(invoice2_id)
self.assertEqual(
invoice1.inconsistencies,
u"Company Name field contains 'Societa\' "
u"Alpha SRL'. Your System contains 'SOCIETA\' ALPHA SRL'\n\n")
self.assertEqual(
invoice2.inconsistencies,
u"Company Name field contains 'Societa\' "
u"Alpha SRL'. Your System contains 'SOCIETA\' ALPHA SRL'\n\n")
def test_14_xml_import(self):
# check: no tax code found , write inconsisteance and anyway
# create draft
res = self.run_wizard('test14', 'IT02780790107_11007.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.reference, '136')
self.assertEqual(invoice.partner_id.name, 'SOCIETA\' ALPHA SRL')
self.assertEqual(invoice.amount_untaxed, 25.00)
self.assertEqual(invoice.amount_tax, 0.0)
self.assertEqual(
invoice.inconsistencies,
u"Company Name field contains 'Societa\' "
"Alpha SRL'. Your System contains 'SOCIETA\' ALPHA SRL'\n\n"
u"XML contains tax with percentage '15.55'"
" but it does not exist in your system\n"
"XML contains tax with percentage '15.55'"
" but it does not exist in your system")
def test_15_xml_import(self):
self.wt = self.create_wt()
res = self.run_wizard('test15', 'IT05979361218_009.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
invoice._onchange_invoice_line_wt_ids()
self.assertAlmostEquals(invoice.withholding_tax_amount, 1)
self.assertAlmostEquals(invoice.amount_total, 6.1)
self.assertAlmostEquals(invoice.amount_net_pay, 5.1)
def test_16_xml_import(self):
# file B2B downloaded from
# http://www.fatturapa.gov.it/export/fatturazione/it/a-3.htm
res = self.run_wizard('test16a', 'IT01234567890_FPR03.xml')
invoice_ids = res.get('domain')[0][2]
invoices = self.invoice_model.browse(invoice_ids)
self.assertEqual(len(invoices), 2)
for invoice in invoices:
self.assertEqual(invoice.inconsistencies, '')
self.assertEqual(invoice.partner_id.name, "SOCIETA' ALPHA SRL")
self.assertTrue(invoice.reference in ('456', '123'))
if invoice.reference == '123':
self.assertTrue(len(invoice.invoice_line) == 2)
for line in invoice.invoice_line:
self.assertFalse(line.product_id)
if invoice.reference == '456':
self.assertTrue(len(invoice.invoice_line) == 1)
for line in invoice.invoice_line:
self.assertFalse(line.product_id)
partner = invoice.partner_id
partner.e_invoice_default_product_id = (
self.imac.product_variant_ids[0].id)
# I create a supplier code to be matched in XML
self.env['product.supplierinfo'].create({
'name': partner.id,
'product_tmpl_id': self.headphones.id,
'product_code': 'ART123',
})
res = self.run_wizard('test16b', 'IT01234567890_FPR03.xml')
invoice_ids = res.get('domain')[0][2]
invoices = self.invoice_model.browse(invoice_ids)
for invoice in invoices:
self.assertTrue(invoice.reference in ('456', '123'))
if invoice.reference == '123':
self.assertEqual(
invoice.invoice_line[0].product_id.id,
self.headphones.product_variant_ids[0].id
)
else:
for line in invoice.invoice_line:
self.assertEqual(
line.product_id.id,
self.imac.product_variant_ids[0].id
)
# change Livello di dettaglio Fatture elettroniche to Minimo
partner.e_invoice_detail_level = '0'
res = self.run_wizard('test16c', 'IT01234567890_FPR03.xml')
invoice_ids = res.get('domain')[0][2]
invoices = self.invoice_model.browse(invoice_ids)
self.assertTrue(len(invoices) == 2)
for invoice in invoices:
self.assertTrue(len(invoice.invoice_line) == 0)
def test_19_xml_import(self):
# Testing CAdES signature, base64 encoded
res = self.run_wizard('test19', 'IT01234567890_FPR03.base64.xml.p7m')
invoice_ids = res.get('domain')[0][2]
invoices = self.invoice_model.browse(invoice_ids)
self.assertEqual(len(invoices), 2)
for invoice in invoices:
self.assertEqual(invoice.partner_id.name, "SOCIETA' ALPHA SRL")
self.assertEqual(invoice.partner_id.e_invoice_detail_level, '0')
self.assertTrue(invoice.reference in ('456', '123'))
if invoice.reference == '123':
self.assertEqual(
invoice.inconsistencies,
'Computed amount untaxed 0.0 is different from '
'summary data 25.0')
if invoice.reference == '456':
self.assertEqual(
invoice.inconsistencies,
'Computed amount untaxed 0.0 is different from '
'summary data 2000.0')
def test_20_xml_import(self):
# Testing xml without xml declaration (sent by Amazon)
res = self.run_wizard('test20', 'IT05979361218_no_decl.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.partner_id.name, "SOCIETA' ALPHA SRL")
def test_21_xml_import(self):
supplier = self.env['res.partner'].search(
[('vat', '=', 'IT02780790107')])[0]
# in order to make the system create the invoice lines
supplier.e_invoice_detail_level = '2'
res = self.run_wizard('test21', 'IT01234567890_FPR04.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.inconsistencies, '')
self.assertEqual(invoice.invoice_line[2].price_unit, 0.0)
self.assertEqual(invoice.invoice_line[2].discount, 0.0)
def test_22_xml_import(self):
res = self.run_wizard('test22', 'IT02780790107_11004_xml_doctor.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.partner_id.name, "SOCIETA' ALPHA SRL")
self.assertIn('removed timezone information', invoice.inconsistencies)
# DatiGeneraliDocumento/Causale
self.assertIn(' ', invoice.comment)
# DatiGeneraliDocumento/Data
self.assertEqual(invoice.date_invoice, '2014-12-18')
# DatiTrasporto/IndirizzoResa/NumeroCivico
self.assertEqual(invoice.delivery_address,
'strada dei test, \n12042 - Bra\nCN IT')
# DatiTrasporto/DataOraConsegna
self.assertFalse(invoice.delivery_datetime)
# DatiBeniServizi/DettaglioLinee/Descrizione
self.assertEqual(invoice.invoice_line[0].name, ' ')
# DatiPagamento/DettaglioPagamento/DataDecorrenzaPenale
payment_data = self.env['fatturapa.payment.data'].search(
[('invoice_id', '=', invoice.id)])
self.assertEqual(payment_data[0].payment_methods[0].penalty_date,
'2015-05-01')
def test_23_xml_import(self):
# Testing CAdES signature, base64 encoded with newlines
res = self.run_wizard(
'test23', 'IT01234567890_FPR04.base64.xml.p7m')
invoice_ids = res.get('domain')[0][2]
invoices = self.invoice_model.browse(invoice_ids)
self.assertEqual(len(invoices), 2)
def test_24_xml_import(self):
res = self.run_wizard('test24', 'IT05979361218_012.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(
invoice.inconsistencies,
'Computed amount untaxed 34.32 is different from'
' summary data 34.67')
def test_25_xml_import(self):
self.create_fiscal_years()
res = self.run_wizard('test25', 'IT05979361218_013.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertAlmostEqual(invoice.e_invoice_amount_untaxed, 34.67)
self.assertEqual(invoice.e_invoice_amount_tax, 0.0)
self.assertEqual(invoice.e_invoice_amount_total, 34.32)
self.assertEqual(invoice.efatt_rounding, -0.35)
invoice.signal_workflow('invoice_open')
move_line = False
for line in invoice.move_id.line_id:
if line.account_id.id == self.env.user.\
company_id.arrotondamenti_attivi_account_id.id:
move_line = True
self.assertTrue(move_line)
def test_26_xml_import(self):
res = self.run_wizard('test26', 'IT05979361218_015.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertAlmostEqual(invoice.e_invoice_amount_untaxed, 34.32)
self.assertEqual(invoice.e_invoice_amount_tax, 0.0)
self.assertEqual(invoice.e_invoice_amount_total, 34.32)
def test_30_xml_import(self):
self.env.user.company_id.cassa_previdenziale_product_id = (
self.service.id)
res = self.run_wizard('test30', 'IT05979361218_001.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
partner_id = invoice.partner_id
partner_id.write({
'street': 'Viale Repubblica, 34',
'electronic_invoice_no_contact_update': True,
})
res = self.run_wizard('test30', 'IT05979361218_002.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.partner_id.id, partner_id.id)
self.assertEqual(invoice.partner_id.street, 'Viale Repubblica, 34')
def test_31_xml_import(self):
res = self.run_wizard('test31', 'IT01234567890_FPR05.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.invoice_line[1].discount, 100)
self.assertEqual(invoice.invoice_line[1].price_subtotal, 0)
self.assertEqual(invoice.amount_total, 12.2)
def test_32_xml_import(self):
# Refund with positive total
res = self.run_wizard('test32', 'IT01234567890_FPR06.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.type, 'in_refund')
self.assertEqual(invoice.amount_total, 18.3)
self.assertEqual(invoice.invoice_line[0].price_unit, 2.0)
self.assertEqual(invoice.invoice_line[0].quantity, 10.0)
self.assertEqual(invoice.invoice_line[0].price_subtotal, 20.0)
self.assertEqual(invoice.invoice_line[1].price_unit, -1.0)
self.assertEqual(invoice.invoice_line[1].quantity, 5.0)
self.assertEqual(invoice.invoice_line[1].price_subtotal, -5.0)
def test_33_xml_import(self):
# Refund with negative total
res = self.run_wizard('test33', 'IT01234567890_FPR07.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.type, 'in_refund')
self.assertEqual(invoice.amount_total, 24.4)
self.assertEqual(invoice.invoice_line[0].price_unit, 2.0)
self.assertEqual(invoice.invoice_line[0].quantity, 10.0)
self.assertEqual(invoice.invoice_line[0].price_subtotal, 20.0)
self.assertEqual(invoice.e_invoice_amount_untaxed, -20.0)
self.assertEqual(invoice.e_invoice_amount_tax, -4.4)
def test_34_xml_import(self):
# No Ritenuta lines set
self.wt = self.create_wt()
res = self.run_wizard('test34', 'IT01234567890_FPR08.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertTrue(invoice.e_invoice_validation_error)
self.assertEqual(
invoice.e_invoice_validation_message,
"E-bill contains DatiRitenuta but no lines subjected to Ritenuta was "
"found. Please manually check Withholding tax Amount\nE-bill contains "
"ImportoRitenuta 360.0 but created invoice has got 0.0\n."
)
def test_35_xml_import(self):
# creating 2350 before 2320, so odoo will use 2350 but e-invoices
# contains 2320: error message must appear
self.create_wt_23_50()
self.create_wt_23_20()
res = self.run_wizard('test35', 'IT01234567890_FPR09.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
invoice._onchange_invoice_line_wt_ids()
self.assertTrue(invoice.e_invoice_validation_error)
self.assertEqual(
invoice.e_invoice_validation_message,
"E-bill contains ImportoRitenuta 30.16 but created invoice has got "
"75.41\n."
)
def test_36_xml_import(self):
# creating a res.bank and importing an XML without "IstitutoFinanziario"
self.create_res_bank()
res = self.run_wizard('test36', 'IT01234567890_FPR10.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(
invoice.fatturapa_payments[0].payment_methods[0].payment_bank.bank.bic,
'BCITITMM')
self.assertEqual(
invoice.fatturapa_payments[0].payment_methods[0].payment_bank.bank.name,
'Banca generica')
def test_40_xml_import_withholding(self):
res = self.run_wizard('test40', 'IT01234567890_FPR11.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
invoice._onchange_invoice_line_wt_ids()
self.assertTrue(invoice.e_invoice_validation_error)
self.assertEqual(
invoice.e_invoice_validation_message,
"E-bill contains ImportoRitenuta 92.0 but created invoice has got "
"144.0\n."
)
def test_41_xml_import_withholding(self):
res = self.run_wizard('test41', 'IT01234567890_FPR12.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
invoice._onchange_invoice_line_wt_ids()
self.assertTrue(len(invoice.ftpa_withholding_ids), 2)
self.assertAlmostEquals(invoice.amount_total, 1220.0)
self.assertAlmostEquals(invoice.withholding_tax_amount, 94.0)
self.assertAlmostEquals(invoice.amount_net_pay, 1126.0)
def test_42_xml_import_withholding(self):
# cassa previdenziale sulla quale รจ applicata la ritenuta
res = self.run_wizard('test42', 'IT01234567890_FPR13.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.amount_total, 19032.0)
self.assertEqual(invoice.withholding_tax_amount, 3120.0)
self.assertEqual(invoice.amount_net_pay, 15912.0)
self.assertTrue(len(invoice.ftpa_withholding_ids), 1)
self.assertTrue(len(invoice.invoice_line) == 2)
def test_43_xml_import_withholding(self):
# Avvocato Mario Bianchi di Ferrara.
# Imponibile di 100+15% spese
res = self.run_wizard('test43', 'ITBNCMRA80A01D548T_20001.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.withholding_tax_amount, 23.0)
self.assertTrue(len(invoice.ftpa_withholding_ids), 1)
self.assertTrue(len(invoice.invoice_line) == 3)
def test_44_xml_import(self):
res = self.run_wizard('test44', 'ITBNCMRA80A01D548T_20005.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertTrue(len(invoice.invoice_line) == 3)
def test_01_xml_link(self):
"""
E-invoice lines are created.
Vendor Reference and Invoice Date are kept.
"""
supplier = self.env['res.partner'].search(
[('vat', '=', 'IT07973780013')], limit=1)
invoice_values = {
'partner_id': supplier.id,
'type': 'in_invoice',
'reference': 'original_ref',
'account_id': self.env.ref('account.a_pay').id,
'journal_id': self.env.ref('account.expenses_journal').id,
'date_invoice': '2020-01-01',
}
orig_invoice = self.invoice_model.create(invoice_values)
wiz_values = {
'line_ids': [(0, 0, {
'invoice_id': orig_invoice.id
})],
}
self.run_wizard('test_link_01', 'IT01234567890_FPR04.xml',
mode='link', wiz_values=wiz_values)
self.assertTrue(orig_invoice.e_invoice_line_ids)
self.assertFalse(orig_invoice.invoice_line)
self.assertTrue(orig_invoice.e_invoice_validation_error)
self.assertEqual(
invoice_values['reference'],
orig_invoice.reference,
)
self.assertEqual(
invoice_values['date_invoice'],
orig_invoice.date_invoice,
)
def test_02_xml_link(self):
"""
E-invoice lines are created.
Vendor Reference and Invoice Date are fetched from the XML.
"""
supplier = self.env['res.partner'].search(
[('vat', '=', 'IT07973780013')], limit=1)
invoice_values = {
'partner_id': supplier.id,
'type': 'in_invoice',
'account_id': self.env.ref('account.a_pay').id,
'journal_id': self.env.ref('account.expenses_journal').id,
}
orig_invoice = self.invoice_model.create(invoice_values)
wiz_values = {
'line_ids': [(0, 0, {
'invoice_id': orig_invoice.id
})],
}
self.run_wizard('test_link_02', 'IT02780790107_11004.xml',
mode='link', wiz_values=wiz_values)
self.assertTrue(orig_invoice.e_invoice_line_ids)
self.assertFalse(orig_invoice.invoice_line)
self.assertTrue(orig_invoice.e_invoice_validation_error)
self.assertTrue(orig_invoice.reference)
self.assertTrue(orig_invoice.date_invoice)
def test_42_xml_import(self):
res = self.run_wizard('test42', 'IT01234567890_FPR05.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.invoice_line[1].discount, 100)
self.assertEqual(invoice.invoice_line[1].price_subtotal, 0)
self.assertEqual(invoice.amount_total, 12.2)
class TestFatturaPAEnasarco(FatturapaCommon):
def setUp(self):
super(TestFatturaPAEnasarco, self).setUp()
self.invoice_model = self.env['account.invoice']
def test_01_xml_import_enasarco(self):
account_payable = self.env['account.account'].create({
'name': 'Test WH tax',
'code': 'whtaxpay2',
'user_type': self.env.ref(
'account.data_account_type_payable').id,
'reconcile': True})
account_receivable = self.env['account.account'].create({
'name': 'Test WH tax',
'code': 'whtaxrec2',
'user_type': self.env.ref(
'account.data_account_type_receivable').id,
'reconcile': True})
misc_journal = self.env['account.journal']. \
search([('type', '=', 'general')], limit=1)
self.env['withholding.tax'].create({
'name': 'Enasarco',
'code': 'TC07',
'account_receivable_id': account_receivable.id,
'account_payable_id': account_payable.id,
'journal_id': misc_journal.id,
'payment_term': self.env.ref(
'account.account_payment_term_advance').id,
'wt_types': 'enasarco',
'causale_pagamento_id': self.env.ref(
'l10n_it_causali_pagamento.r').id,
'rate_ids': [(0, 0, {
'tax': 1.57,
'base': 1.0,
})]
})
self.env['withholding.tax'].create({
'name': 'Enasarco 8,50',
'code': 'TC07',
'account_receivable_id': account_receivable.id,
'account_payable_id': account_payable.id,
'journal_id': misc_journal.id,
'payment_term': self.env.ref(
'account.account_payment_term_advance').id,
'wt_types': 'enasarco',
'causale_pagamento_id': self.env.ref(
'l10n_it_causali_pagamento.r').id,
'rate_ids': [(0, 0, {
'tax': 8.5,
'base': 1.0,
})]
})
self.env['withholding.tax'].create({
'name': '1040/3',
'code': '1040',
'account_receivable_id': account_receivable.id,
'account_payable_id': account_payable.id,
'journal_id': misc_journal.id,
'payment_term': self.env.ref(
'account.account_payment_term_advance').id,
'wt_types': 'ritenuta',
'causale_pagamento_id': self.env.ref(
'l10n_it_causali_pagamento.a').id,
'rate_ids': [(0, 0, {
'tax': 11.50,
'base': 1.0,
})]
})
self.env['withholding.tax'].create({
'name': '1040 R',
'code': '1040R',
'account_receivable_id': account_receivable.id,
'account_payable_id': account_payable.id,
'journal_id': misc_journal.id,
'payment_term': self.env.ref(
'account.account_payment_term_advance').id,
'wt_types': 'ritenuta',
'causale_pagamento_id': self.env.ref(
'l10n_it_causali_pagamento.r').id,
'rate_ids': [(0, 0, {
'tax': 11.50,
'base': 1.0,
})]
})
# case with ENASARCO only in DatiCassaPrevidenziale and not in DatiRitenuta.
# This should not happen, but it is valid for SDI
res = self.run_wizard('test01', 'IT05979361218_014.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.partner_id.name, "SOCIETA' ALPHA SRL")
self.assertEqual(invoice.amount_untaxed, 2470.00)
self.assertEqual(invoice.amount_tax, 543.40)
self.assertEqual(invoice.amount_total, 3013.40)
self.assertEqual(invoice.amount_net_pay, 2729.35)
self.assertEqual(invoice.withholding_tax_amount, 284.05)
self.assertEqual(invoice.welfare_fund_ids[0].kind_id.code, 'N2')
self.assertTrue(len(invoice.e_invoice_line_ids) == 1)
self.assertEqual(
invoice.e_invoice_line_ids[0].name, 'ACCONTO PROVVIGIONI')
self.assertEqual(
invoice.e_invoice_line_ids[0].qty, 1.0)
self.assertEqual(
invoice.e_invoice_line_ids[0].unit_price, 2470.0)
self.assertEqual(
invoice.e_invoice_line_ids[0].total_price, 2470.0)
def test_02_xml_import_enasarco(self):
# Giacomo Neri, agente di commercio di Firenze.
# Imponibile 10
res = self.run_wizard('test02', 'ITNREGCM80H30D612D_20003.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertEqual(invoice.amount_untaxed, 10.0)
self.assertEqual(invoice.amount_tax, 2.2)
self.assertAlmostEqual(invoice.amount_total, 12.2)
self.assertAlmostEqual(invoice.amount_net_pay, 10.2)
self.assertTrue(len(invoice.invoice_line) == 1)
def test_03_xml_import_enasarco(self):
# Come sopra, ma senza "<Ritenuta>SI</Ritenuta>" in riga fattura
res = self.run_wizard('test03', 'ITNREGCM80H30D612D_20004.xml')
invoice_id = res.get('domain')[0][2][0]
invoice = self.invoice_model.browse(invoice_id)
self.assertTrue(
'E-bill contains DatiRitenuta but no lines subjected to Ritenuta was found'
in invoice.e_invoice_validation_message)
self.assertAlmostEqual(invoice.amount_total, 12.2)
self.assertAlmostEqual(invoice.amount_net_pay, 12.2)