Skip to content

GitLab

Something went wrong on our end
Merged
Opened by Agustín Cruz@agb80Owner

feat(account.voucher): implement CFDI complemento de pagos

Viewing commit efef4921
12 files
+ 365
- 74
Show latest version
l10n_mx_‎facturae‎
da‎ta‎
ir_attachment_fa‎cturae_config.xml‎ +9 -0
mod‎els‎
__ini‎t__.py‎ +1 -0
account_i‎nvoice.py‎ +6 -9
account_v‎oucher.py‎ +84 -0
rep‎ort‎
account_i‎nvoice.xml‎ +63 -63
account_inv‎oice_33.odt‎ +0 -0
account_v‎oucher.odt‎ +0 -0
account_v‎oucher.xml‎ +47 -0
temp‎lates‎
account_inv‎oice_33.txt‎ +2 -2
account_vou‎cher_33.txt‎ +94 -0
vi‎ews‎
account_v‎oucher.xml‎ +57 -0
__opene‎rp__.py‎ +2 -0
l10n_mx_facturae/data/ir_attachment_facturae_config.xml
+ 9
- 0
Show all unchanged lines Show 20 lines
<field name="template_pdf_cancel">invoice.report.aaero</field>
<field name="email_template_id" ref="email_template_template_facturae_mx"/>
</record>
<record id="ir_attachment_facturae_mx_config_account_voucher_33" model="ir.attachment.facturae.mx.config">
<field name="model">account.voucher</field>
<field name="version">3.3</field>
<field name="template_xml_sign">account.voucher.cfdi.xml.33</field>
<field name="template_xml_cancel">Aun.no.hay.uno</field>
<field name="template_pdf_sign">account.voucher.cfdi.pdf</field>
<field name="template_pdf_cancel">account.voucher.cfdi.pdf</field>
<field name="email_template_id" ref="email_template_template_facturae_mx"/>
</record>
</data>
</openerp>
l10n_mx_facturae/models/__init__.py
+ 1
- 0
# -*- coding: utf-8 -*-
from . import account_invoice
from . import account_voucher
from . import email_template
from . import res_partner
l10n_mx_facturae/models/account_invoice.py
+ 6
- 9
Show all unchanged lines Show 20 lines
import logging
from datetime import datetime
from pytz import timezone, UTC
from openerp import api, fields, models
Show 20 lines Show all unchanged lines Show 20 lines
if self.state == 'draft':
return ''
fname = '_'.join([
self.company_id.partner_id.vat_split or
self.company_id.partner_id.vat, self.number or
self.internal_number,
self.company_id.partner_id.vat_split,
self.number or self.internal_number,
])
return fname
Show 20 lines Show all unchanged lines Show 20 lines
"""
self.ensure_one()
try:
code = self.payment_type[0].code
code = self.payment_type_ids[0].code
except IndexError:
code = '99'
return code
Show 20 lines Show all unchanged lines Show 20 lines
def total(self):
self.ensure_one()
return (
self.subtotal
- self.descuento
+ self.impuestos['total_traslados']
- self.impuestos['total_retenciones']
self.subtotal - self.descuento +
self.impuestos['total_traslados'] -
self.impuestos['total_retenciones']
)
@property
Show 20 lines Show all unchanged lines
l10n_mx_facturae/models/account_voucher.py
+ 84
- 0
# -*- coding: utf-8 -*-
from openerp import api, models
class AccountVoucher(models.Model):
_name = 'account.voucher'
_inherit = [
'account.voucher',
'base.cfdi',
]
@api.multi
def sign_voucher(self):
"""Create CFDI for selected vouchers"""
# Only vouchers to sign are the receipts
receipts = self.filtered(lambda r: r.type == 'receipt')
# Get only receipts that doesn't have a CFDI yet and create it
receipts.filtered(lambda r: not r.cfdi_id.exists()).create_cfdi()
@property
def doctos_relacionados(self):
"""Return a list with all related invoices to this payment"""
self.ensure_one()
# Get all records from account.move.line related to this voucher but
# affecting an account different than the selected for this voucher
move_lines = self.move_ids.filtered(
lambda x: x.account_id != self.account_id,
)
# Get all lines form partial and full reconciliations
temp_lines = move_lines.mapped('reconcile_partial_id.line_partial_ids')
temp_lines |= move_lines.mapped('reconcile_id.line_id')
# Get invoices related to this voucher
invoices = (temp_lines - move_lines).mapped('invoice')
return invoices
@api.multi
def numparcialidad(self, invoice):
"""Computes payment number based on all payments done to invoice"""
return len(invoice.mapped('payment_ids')) - 1
@api.multi
def impsaldoant(self, invoice):
"""Computes amount_residual for invoice before current voucher"""
self.ensure_one()
# Original residual amount for given invoice
amount_residual = invoice.amount_total
# Get payments done to given invoice in vouchers older than current
payments = invoice.mapped('payment_ids') - self.move_ids
payments = payments.filtered(lambda r: r.date < self.date)
for payment in payments:
amount_currency = abs(payment.amount_currency) or 0.0
# If amount_currency exists it means we are dealing with a multi
# currency payment, and thus we need to sum amount_currency to
# amount_paid instead of normal debit - credit
if amount_currency:
amount_residual -= amount_currency
else:
amount_residual -= abs(payment.debit - payment.credit)
return self.currency_id.cfdi_round(amount_residual)
@api.multi
def imppagado(self, invoice):
"""Computes total amount payment on this voucher for given invoice"""
self.ensure_one()
amount_paid = 0.0
# Get payments done in this voucher for given invoice
payments = invoice.mapped('payment_ids') & self.move_ids
for payment in payments:
amount_currency = abs(payment.amount_currency) or 0.0
# If amount_currency exists it means we are dealing with a multi
# currency payment, and thus we need to sum amount_currency to
# amount_paid instead of normal debit - credit
if amount_currency:
amount_paid += amount_currency
else:
amount_paid += abs(payment.debit - payment.credit)
return self.currency_id.cfdi_round(amount_paid)
l10n_mx_facturae/report/account_invoice.xml
+ 63
- 63
l10n_mx_facturae/report/account_invoice_33.odt
+ 0
- 0
No preview for this file type
l10n_mx_facturae/report/account_print_invoice.odt → l10n_mx_facturae/report/account_voucher.odt
+ 0
- 0
l10n_mx_facturae/report/account_voucher.xml
+ 47
- 0
<?xml version="1.0" encoding="utf-8"?>
<openerp>
<data>
<!-- XML invoice report definition -->
<record id="report_templates_aeroo_account_voucher_cfdi_33" model="report.templates.aeroo">
<field name="name">Account Invoice XML CFDI 3.3</field>
<field name="model">account.voucher</field>
<field name="report_name">account.voucher.cfdi.33</field>
<field name="report_rml">l10n_mx_facturae/templates/account_voucher_33.txt</field>
<field name="tml_source">file</field>
</record>
<record id="ir_actions_report_xml_account_voucher_cfdi_33" model="ir.actions.report.xml">
<field name="name">Account Voucher XML CFDI 3.3</field>
<field name="type">ir.actions.report.xml</field>
<field name="model">account.voucher</field>
<field name="report_name">account.voucher.cfdi.xml.33</field>
<field name="report_type">aeroo</field>
<field name="in_format">genshi-raw</field>
<field name="out_format" ref="report_aeroo.report_mimetypes_raw" />
<field name="aeroo_templates_ids"
eval="[(6, 0, [report_templates_aeroo_account_voucher_cfdi_33])]" />
<field name="parser_state">default</field>
</record>
</data>
<data noupdate="1">
<!-- PDF invoice report definition -->
<record id="report_templates_aeroo_account_voucher_cfdi_33" model="report.templates.aeroo">
<field name="name">Defaut Voucher PDF</field>
<field name="model">account.voucher</field>
<field name="report_name">account.voucher.cfdi.33.pdf</field>
<field name="report_rml">l10n_mx_facturae/report/account_voucher.odt</field>
<field name="tml_source">file</field>
</record>
<record id="ir_actions_report_xml_account_voucher_cfdi_33" model="ir.actions.report.xml">
<field name="name">Account Voucher CFDI PDF</field>
<field name="type">ir.actions.report.xml</field>
<field name="model">account.voucher</field>
<field name="report_name">account.voucher.cfdi.pdf</field>
<field name="report_type">aeroo</field>
<field name="in_format">oo-odt</field>
<field name="out_format" ref="report_aeroo.report_mimetypes_pdf_odt" />
<field name="aeroo_templates_ids" eval="[(6, 0, [report_templates_aeroo_account_voucher_cfdi_33])]" />
<field name="tml_source">file</field>
</record>
</data>
</openerp>
l10n_mx_facturae/templates/account_invoice_33.txt
+ 2
- 2
Show all unchanged lines Show 20 lines
{% when '' %}${ validationerror(_('Missing VAT number for company')) }{% end %}
{% otherwise %}Rfc="${ html_escape(o.company_id.partner_id.vat_split) }"{% end %}
{% end %}
Nombre="${ o.company_id.name }"
Nombre="${ html_escape(o.company_id.name) }"
RegimenFiscal="$o.company_id.account_position_id.code"/>
<cfdi:Receptor
{% choose o.partner_id.vat_split %}
Show 20 lines Show all unchanged lines Show 20 lines
{% if taxes %}
<cfdi:Impuestos
TotalImpuestosTrasladados="${ '{0:.2f}'.format(taxes.total_traslados) }"
{% if taxes.retenciones %}
{% if taxes.total_retenciones %}
TotalImpuestosRetenidos="${ '{0:.2f}'.format(abs(taxes.total_retenciones)) }"
{% end %}>
{% if taxes.traslados %}
Show 20 lines Show all unchanged lines
l10n_mx_facturae/templates/account_voucher_33.txt
+ 94
- 0
<?xml version="1.0" encoding="UTF-8"?>
{% python setLang(o.create_uid.lang or 'en_US') %}
<cfdi:Comprobante
xsi:schemaLocation="http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv33.xsd http://www.sat.gob.mx/Pagos http://www.sat.gob.mx/sitio_internet/cfd/Pagos/Pagos10.xsd"
xmlns:cfdi="http://www.sat.gob.mx/cfd/3"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:pago10="http://www.sat.gob.mx/Pagos"
Version="3.3"
{% if o.journal_id.sequence_id.prefix %}
Serie="$o.serie"
{% end %}
Folio="$o.folio"
Fecha="${ format_datetime(o.cfdi_datetime, '%Y-%m-%dT%H:%M:%S') }"
Sello="@"
NoCertificado="@"
Certificado="@"
SubTotal="0"
Moneda="XXX"
Total="0"
TipoDeComprobante="P"
LugarExpedicion="${ o.company_id.zip }" >
<cfdi:Emisor
{% choose o.company_id.partner_id.vat_split %}
{% when False %}${ validationerror(_('Missing VAT number for company')) }{% end %}
{% otherwise %}Rfc="${ html_escape(o.company_id.partner_id.vat_split) }"{% end %}
{% end %}
Nombre="${ html_escape(o.company_id.name) }"
RegimenFiscal="$o.company_id.account_position_id.code"/>
<cfdi:Receptor
{% choose o.partner_id.vat_split %}
{% when False %}${ validationerror(_('Missing VAT number for receiver')) }{% end %}
{% otherwise %}Rfc="${ html_escape(o.partner_id.vat_split) }"{% end %}
{% end %}
{% if o.partner_id.vat_split not in ('XAXX010101000', 'XEXX010101000') %}
Nombre="${ html_escape(o.partner_id.name) }"
{% end %}
{% if o.partner_id.country_id and o.partner_id.country_id.code != 'MX' %}
ResidenciaFiscal="$o.partner_id.country_id.code3"
NumRegIdTrib="${ html_escape(o.partner_id.vat) }"
{% end %}
UsoCFDI="P01" />
<cfdi:Conceptos>
<cfdi:Concepto
ClaveProdServ="84111506"
Cantidad="1"
ClaveUnidad="ACT"
Descripcion="Pago"
ValorUnitario="0"
Importe="0" />
</cfdi:Conceptos>
<cfdi:Complemento>
<pago10:Pagos Version="1.0">
<pago10:Pago
FechaPago="${ format_date(o.date, '%Y-%m-%dT%H:%M:%S') }"
{% choose o.payment_type_id.code %}
{% when False %}${ validationerror(_('Missing payment method for voucher')) }{% end %}
{% when '99' %}${ validationerror(_('Payment method must be different than 99.')) }{% end %}
{% otherwise %}FormaDePagoP="${ o.payment_type_id.code }"{% end %}
{% end %}
MonedaP="${ o.currency_id.name }"
{% if o.currency_id.name != 'MXN' %}
TipoCambio="${ o.currency_rate }"
{% end %}
Monto="${ o.currency_id.cfdi_round(o.amount) }"
NumOperacion="${ o.number }" >
{% for invoice in o.doctos_relacionados %}
<pago10:DoctoRelacionado
IdDocumento="${ invoice.cfdi_folio_fiscal }"
MonedaDR="${ invoice.currency_id.name }"
{% if invoice.currency_id != o.currency_id %}
{% choose invoice.currency_id.name %}
{% when 'MXN' %}TipoCambioDR="1"{% end %}
{% otherwise %}TipoCambioDR="${ invoice.currency_rate }"{% end %}
{% end %}
{% end %}
{% choose invoice.payment_term.payment_method_id.code %}
{% when False %}MetodoDePagoDR="PUE"{% end %}
{% otherwise %}
MetodoDePagoDR="$invoice.payment_term.payment_method_id.code"
{% if invoice.payment_term.payment_method_id.code == 'PPD' %}
NumParcialidad="${ o.numparcialidad(invoice) }"
ImpSaldoAnt="${ o.impsaldoant(invoice) }"
ImpSaldoInsoluto="${ o.impsaldoant(invoice) - o.imppagado(invoice) }"
{% end %}
{% end %}
{% end %}
{% if invoice.payment_term.payment_method_id.code == 'PPD' or len(o.DoctosRelacionados) > 1 %}
ImpPagado="${ o.imppagado(invoice) }"
{% end %} />
{% end %}
</pago10:Pago>
</pago10:Pagos>
</cfdi:Complemento>
</cfdi:Comprobante>
l10n_mx_facturae/views/account_voucher.xml
+ 57
- 0
<?xml version="1.0"?>
<openerp>
<data>
<record id="account_voucher_action_sign" model="ir.actions.server">
<field name="name">Sign Vouchers</field>
<field name="type">ir.actions.server</field>
<field name="model_id" ref="model_account_voucher"/>
<field name="state">code</field>
<field name="code">self.sign_voucher(cr, uid, context.get('active_ids', []), context=context)</field>
</record>
<record id="ir_values_action_sign" model="ir.values">
<field name="name">Sign Vouchers</field>
<field name="action_id" ref="account_voucher_action_sign"/>
<field name="value" eval="'ir.actions.server,' + str(ref('account_voucher_action_sign'))"/>
<field name="key">action</field>
<field name="model_id" ref="model_account_voucher"/>
<field name="model">account.voucher</field>
<field name="key2">client_action_multi</field>
</record>
<record id="account_voucher_view_form" model="ir.ui.view">
<field name="name">account.voucher.view.form</field>
<field name="model">account.voucher</field>
<field name="inherit_id" ref="account_voucher.view_vendor_receipt_form"/>
<field name="arch" type="xml">
<button name="proforma_voucher" position="after">
<button name="sign_voucher" type="object" string="Sign" class="oe_highlight" attrs="{'invisible':['|',('state','!=','posted'),('cfdi_state','in',['signed', 'done'])]}"/>
</button>
<xpath expr="//sheet/h1" position="after">
<h4 attrs="{'invisible': [('number','=',False)]}" collspan="2">
<field string="Fiscal Number" name="cfdi_id" readonly="1"/>
<field name="cfdi_state" invisible="1"/>
</h4>
</xpath>
</field>
</record>
<record id="account_voucher_view_search" model="ir.ui.view">
<field name="name">account.voucher.view.search</field>
<field name="model">account.voucher</field>
<field name="inherit_id" ref="account_voucher.view_voucher_filter_customer_pay"/>
<field name="arch" type="xml">
<field name="partner_id" position="after">
<field name="cfdi_id" string="UUID" />
</field>
<filter string="Posted" position="after">
<separator/>
<filter string="Unsigned" domain="[('cfdi_id','=',False)]" help="Not Signed Vouchers"/>
<filter string="Signed" domain="[('cfdi_id','!=',False)]" help="Signed Vouchers"/>
</filter>
</field>
</record>
</data>
</openerp>
l10n_mx_facturae/__openerp__.py
+ 2
- 0
Show all unchanged lines Show 20 lines
],
'data': [
'views/account_invoice.xml',
'views/account_voucher.xml',
'views/res_partner.xml',
'report/account_invoice.xml',
'report/account_voucher.xml',
'data/email_template.xml',
'data/ir_attachment_facturae_config.xml',
],
Show 20 lines Show all unchanged lines