Merge lp:~vauxoo/openerp-mexico-localization/7.0_oml_test_yaml_diot_dev_jorge into lp:openerp-mexico-localization/7.0

[Jorge Angel Naranjo Rogel - http://www.vauxoo.com]

Se agrega Test yaml para validar la información del reporte de diot. Se configuran los impuestos que se crearon en account_voucer_tax para su funcionamiento del Diot.

[lp:~vauxoo/openerp-mexico-localization/7.0_oml_test_yaml_diot_dev_jorge]

324. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com on 2013-10-29

[IMP][l10n_mx_diot_report] Changed not is to is not

[Nhomar - Vauxoo (nhomar)]

Esta rojo en el runbot.

http://testrunbot.vauxoo.com/Chuck_Norris-erp-vauxoo-com--mp-192985-1233/logs/test-all.txt

Saludos.

review: Needs Fixing

[lp:~vauxoo/openerp-mexico-localization/7.0_oml_test_yaml_diot_dev_jorge]

325. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com on 2013-11-05

[FIX][l10n_mx_diot_report] Changed eval to search by name

[Jorge Angel Naranjo Rogel - http://www.vauxoo.com (jorge-nr)]

Se cambia el eval por un search para que traiga el id que le corresponde

review: Needs Resubmitting

[lp:~vauxoo/openerp-mexico-localization/7.0_oml_test_yaml_diot_dev_jorge]

326. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com on 2013-11-05

[MERGE] Merge from lp:openerp-mexico-localization/7.0

[Moisés López - http://www.vauxoo.com (moylop260)]

review: Approve

=== modified file 'l10n_mx_diot_report/__openerp__.py'
--- l10n_mx_diot_report/__openerp__.py	2013-07-22 20:43:26 +0000
+++ l10n_mx_diot_report/__openerp__.py	2013-11-05 17:58:57 +0000
@@ -52,8 +52,12 @@
         "l10n_mx_account_tax_category",
         "l10n_mx_base_vat_split",
         "account_voucher_tax",
+        "account_voucher",
+        "l10n_mx_partner_address",
         ],
-    "demo" : [],
+    "demo" : ["demo/account_voucher_tax_demo.xml",
+              "demo/res_partner_demo.xml",
+              "demo/account_invoice_demo.xml",],
     "data" : [
         "partner_view.xml",
         "wizard/wizard_diot_report_view.xml",
@@ -61,7 +65,7 @@
     'js': [],
     'qweb' : [],
     'css':[],
-    'test': [],
+    'test': ["test/validate_diot.yml",],
     "installable" : True,
     "active" : False,
 }

=== added directory 'l10n_mx_diot_report/demo'
=== added file 'l10n_mx_diot_report/demo/account_invoice_demo.xml'
--- l10n_mx_diot_report/demo/account_invoice_demo.xml	1970-01-01 00:00:00 +0000
+++ l10n_mx_diot_report/demo/account_invoice_demo.xml	2013-11-05 17:58:57 +0000
@@ -0,0 +1,84 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data noupdate="1">
+        
+<!--
+         Invoices 
+-->
+        <record id="account_invoice_diot_0" model="account.invoice">
+            <field name="date_due" eval="time.strftime('%Y-%m-%d')"/>
+            <field name="currency_id" ref="base.EUR"/>
+            <field name="reference_type">none</field>
+            <field name="account_id" ref="account.a_pay"/>
+            <field name="payment_term" ref="account.account_payment_term"/>
+            <field name="reference_type">none</field>
+            <field name="journal_id" ref="account.expenses_journal"/>
+            <field name="state">draft</field>
+            <field name="type">in_invoice</field>
+            <field name="date_invoice" eval="time.strftime('%Y-%m-%d')"/>
+            <field name="partner_id" ref="l10n_mx_partner_address.res_partner_address_vauxoo_1"/>
+        </record>
+        
+        <record id="account_invoice_diot_0_line1" model="account.invoice.line">
+            <field name="invoice_id" ref="account_invoice_diot_0"/>
+            <field name="account_id" ref="account.a_expense"/>
+            <field name="uos_id" ref="product.product_uom_unit"/>
+            <field name="price_unit" eval="100.0" />
+            <field name="company_id" ref="base.main_company"/>
+            <field name="invoice_line_tax_id" eval="[(6,0,[ref('account_voucher_tax.account_voucher_tax_purchase_iva16')])]"/>
+            <field name="product_id" ref="product.product_product_3"/>
+            <field name="quantity" eval="1.0" />
+            <field name="partner_id" ref="l10n_mx_partner_address.res_partner_address_vauxoo_1"/>
+            <field name="name">PC Assemble SC234</field>
+        </record>
+        <record id="account_invoice_diot_0_line2" model="account.invoice.line">
+            <field name="invoice_id" ref="account_invoice_diot_0"/>
+            <field name="account_id" ref="account.a_expense"/>
+            <field name="uos_id" ref="product.product_uom_unit"/>
+            <field name="price_unit" eval="100.0" />
+            <field name="company_id" ref="base.main_company"/>
+            <field name="invoice_line_tax_id" eval="[(6,0,[ref('account_voucher_tax.account_voucher_tax_purchase_iva11')])]"/>
+            <field name="product_id" ref="product.product_product_5"/>
+            <field name="quantity" eval="1.0" />
+            <field name="partner_id" ref="l10n_mx_partner_address.res_partner_address_vauxoo_1"/>
+            <field name="name">PC Assemble + Custom (PC on Demand)</field>
+        </record>
+        <record id="account_invoice_diot_0_line3" model="account.invoice.line">
+            <field name="invoice_id" ref="account_invoice_diot_0"/>
+            <field name="account_id" ref="account.a_expense"/>
+            <field name="uos_id" ref="product.product_uom_unit"/>
+            <field name="price_unit" eval="100.0" />
+            <field name="company_id" ref="base.main_company"/>
+            <field name="invoice_line_tax_id" eval="[(6,0,[ref('account_voucher_tax.account_voucher_tax_purchase_iva1067_retencion_iva')])]"/>
+            <field name="product_id" ref="product.product_product_22"/>
+            <field name="quantity" eval="1.0" />
+            <field name="partner_id" ref="l10n_mx_partner_address.res_partner_address_vauxoo_1"/>
+            <field name="name">Processor Core i5 2.70 Ghz</field>
+        </record>
+        <record id="account_invoice_diot_0_line4" model="account.invoice.line">
+            <field name="invoice_id" ref="account_invoice_diot_0"/>
+            <field name="account_id" ref="account.a_expense"/>
+            <field name="uos_id" ref="product.product_uom_unit"/>
+            <field name="price_unit" eval="100.0" />
+            <field name="company_id" ref="base.main_company"/>
+            <field name="invoice_line_tax_id" eval="[(6,0,[ref('account_voucher_tax.account_voucher_tax_purchase_iva_excento_iva')])]"/>
+            <field name="product_id" ref="product.product_product_20"/>
+            <field name="quantity" eval="1.0" />
+            <field name="partner_id" ref="l10n_mx_partner_address.res_partner_address_vauxoo_1"/>
+            <field name="name">Motherboard I9P57</field>
+        </record>
+        <record id="account_invoice_diot_0_line5" model="account.invoice.line">
+            <field name="invoice_id" ref="account_invoice_diot_0"/>
+            <field name="account_id" ref="account.a_expense"/>
+            <field name="uos_id" ref="product.product_uom_unit"/>
+            <field name="price_unit" eval="100.0" />
+            <field name="company_id" ref="base.main_company"/>
+            <field name="invoice_line_tax_id" eval="[(6,0,[ref('account_voucher_tax.account_voucher_tax_purchase_0iva')])]"/>
+            <field name="product_id" ref="product.product_product_25"/>
+            <field name="quantity" eval="1.0" />
+            <field name="partner_id" ref="l10n_mx_partner_address.res_partner_address_vauxoo_1"/>
+            <field name="name">Laptop E5023</field>
+        </record>
+
+    </data>
+</openerp>

=== added file 'l10n_mx_diot_report/demo/account_voucher_tax_demo.xml'
--- l10n_mx_diot_report/demo/account_voucher_tax_demo.xml	1970-01-01 00:00:00 +0000
+++ l10n_mx_diot_report/demo/account_voucher_tax_demo.xml	2013-11-05 17:58:57 +0000
@@ -0,0 +1,47 @@
+<?xml version="1.0" ?>
+<openerp>
+    <data noupdate="0">
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva16" model="account.tax">
+            <field name="name">IVA 16% with purchase voucher accounts - Test</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva11" model="account.tax">
+            <field name="name">IVA 11% with purchase voucher accounts - Test</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva533" model="account.tax">
+            <field name="name">IVA 5.33% X ACREDITAR - Test</field>
+            <field name="tax_diot">tax_16</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva1067_xacre_retenido" model="account.tax">
+            <field name="name">IVA 10.67% X ACREDITAR RETENIDO- Test</field>
+            <field name="tax_diot">tax_ret</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA-RET')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva10_rete_isr" model="account.tax">
+            <field name="name">IVA 10% RETENIDO ISR - Test</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','ISR-RET')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva1067_retencion_iva" model="account.tax">
+            <field name="name">RETENCION IVA 10.67% - Test</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA-RET')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_0iva" model="account.tax">
+            <field name="name">IVA 0% purchase - Test</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA')]"/>
+        </record>
+        
+        <record id="account_voucher_tax.account_voucher_tax_purchase_iva_excento_iva" model="account.tax">
+            <field name="name">IVA EXENTO - Test</field>
+            <field model="account.tax.category" name="tax_category_id" search="[('name','like','IVA-EXCENTO')]"/>
+        </record>
+    </data>
+</openerp>

=== added file 'l10n_mx_diot_report/demo/res_partner_demo.xml'
--- l10n_mx_diot_report/demo/res_partner_demo.xml	1970-01-01 00:00:00 +0000
+++ l10n_mx_diot_report/demo/res_partner_demo.xml	2013-11-05 17:58:57 +0000
@@ -0,0 +1,12 @@
+<?xml version="1.0" ?>
+<openerp>
+    <data noupdate="1">
+        
+        <record id="l10n_mx_partner_address.res_partner_address_vauxoo_0" model="res.partner">
+                <field eval="1" name="supplier"/>
+                <field name="type_of_third">04</field>
+                <field name="type_of_operation">85</field>
+        </record>
+
+     </data>
+</openerp>

=== added file 'l10n_mx_diot_report/test/validate_diot.yml'
--- l10n_mx_diot_report/test/validate_diot.yml	1970-01-01 00:00:00 +0000
+++ l10n_mx_diot_report/test/validate_diot.yml	2013-11-05 17:58:57 +0000
@@ -0,0 +1,129 @@
+-
+    Test DIOT
+-
+   I press the update button on the invoice
+-
+  !python {model: account.invoice}: |
+    self.button_reset_taxes(cr, uid, [ref('l10n_mx_diot_report.account_invoice_diot_0')], context=context)
+-
+    I getting the amount total of the invoice and write this amount in Verification Total
+-
+  !python {model: account.invoice}: |
+    amount_total = self.read(cr,uid,[ref('l10n_mx_diot_report.account_invoice_diot_0')], ['amount_total'])[0].get('amount_total')
+    self.write(cr,uid,[ref('l10n_mx_diot_report.account_invoice_diot_0')], {'check_total': amount_total})
+-
+  I change the state of invoice to open by clicking Validate button
+-
+  !workflow {model: account.invoice, action: invoice_open, ref: l10n_mx_diot_report.account_invoice_diot_0}
+-
+  I check that the invoice state is now "Open"
+-
+  !assert {model: account.invoice, id: l10n_mx_diot_report.account_invoice_diot_0}:
+    - state == 'open'
+-
+  I set the context that will be used for the encoding of all the vouchers of this file
+-
+  !context
+    'type': 'payment'
+-
+   I create the voucher of payment
+-
+  !record {model: account.voucher, id: account_voucher_voucherfordiot0, view:  account_voucher.view_vendor_payment_form }:
+    account_id: account.cash
+    company_id: base.main_company
+    journal_id: account.expenses_journal
+    amount: 516.33
+    name: 'Voucher for Diot'
+    partner_id: l10n_mx_partner_address.res_partner_address_vauxoo_0
+    date: !eval time.strftime('%Y-%m-%d')
+    payment_option: 'with_writeoff'
+    writeoff_acc_id: account.a_expense
+    comment: 'Write Off'
+    payment_rate_currency_id: base.EUR
+-
+    I check the amount of invoice for release the payment
+-
+  !python {model: account.invoice}: |
+    account_voucher_obj = self.pool.get('account.voucher')
+    amount_total = self.read(cr,uid,[ref('l10n_mx_diot_report.account_invoice_diot_0')], ['amount_total'])[0].get('amount_total')
+    account_voucher_obj.write(cr,uid,[ref('account_voucher_voucherfordiot0')], {'amount': amount_total})
+-
+  I check that Initially customer voucher is in the "Draft" state
+-
+  !assert {model: account.voucher, id: account_voucher_voucherfordiot0}:
+    - state == 'draft'
+-
+  I compute the voucher to calculate the taxes by clicking Compute button
+-
+  !workflow {model: account.voucher, action: proforma_voucher, ref: account_voucher_voucherfordiot0}
+
+-
+  I create voucher by clicking on Create button
+-
+  !workflow {model: account.voucher, action: proforma_voucher, ref: account_voucher_voucherfordiot0}
+-
+  I clicked on Validate Button
+-
+  !assert {model: account.voucher, id: account_voucher_voucherfordiot0}:
+    - state == 'posted'
+-
+  I check that Moves get created for this voucher
+-
+  !python {model: account.voucher}: |
+    acc_id=self.browse(cr, uid, ref('account_voucher_voucherfordiot0'))
+    assert(acc_id.move_id)
+-
+  I create a record to wizard diot.
+-
+  !record {model: account.diot.report, id: wizard_diot_test_0 , view: l10n_mx_diot_report.view_account_diot_report}:
+    company_id: base.main_company
+    entries_to_print: all
+-
+  I create file of DIOT and Check Data of Diot
+-
+  !python {model: account.diot.report}: |
+    import base64
+    import time
+    
+    account_period_obj = self.pool.get('account.period')
+    period_id = account_period_obj.search(cr, uid,[('name','like','%'+time.strftime('%m/%Y')+'%')])
+    data_of_diot = {}
+    if period_id:
+        self.write(cr, uid, [ref('wizard_diot_test_0')], {'period_id' : period_id[0]}) 
+        create_id = self.create_diot(cr, uid, [ref('wizard_diot_test_0')], context=context)
+        data = self.read(cr, uid,[create_id.get('res_id')],['file_csv'])
+        if data:
+            data_split = base64.decodestring(self.read(cr, uid,[create_id.get('res_id')],['file'])[0].get('file')).split('|')
+            titles = ['type_of_third', 'type_of_operation',
+            'vat', 'number_id_fiscal', 'foreign_name',
+            'country_of_residence', 'nationality',
+            'value_of_acts_or_activities_paid_at_the_rate_of_16%',
+            'value_of_acts_or_activities_paid_at_the_rate_of_15%',
+            'amount_of_non-creditable_VAT_paid_at_the_rate_of_16%',
+            'value_of_acts_or_activities_paid_at_the_rate_of_11%_VAT',
+            'value_of_acts_or_activities_paid_at_the_rate_of_10%_VAT',
+            'amount_of_non-creditable_VAT_paid_at_the_rate_of_11%',
+            'value_of_acts_or_activities_paid_on_import_of_goods_and_'
+            'services_at_the_rate_of_16%_VAT',
+            'amount_of_non-creditable_VAT_paid_by_imports_at_the_rate_of_16%',
+            'value_of_acts_or_activities_paid_on_import_of_goods_and_'
+            'services_at_the_rate_of_11%_VAT',
+            'amount_of_non-creditable_VAT_paid_by_imports_at_the_rate_of_11%',
+            'value_of_acts_or_activities_paid_on_import_of_goods_and_'
+            'services_for_which_VAT_is_not_pay_(exempt)',
+            'value_of_the_other_acts_or_activities_paid_at_the_rate_of_0%_VAT',
+            'value_of_acts_or_activities_paid_by_those_who_do_not_pay_the_'
+            'VAT_(Exempt)',
+            'tax Withheld by the taxpayer',
+            'VAT for returns, discounts and rebates on purchases',
+            'show_pipe', ]
+            i = 0
+            for title in titles:
+                data_of_diot.update({title : data_split[i]})
+                i+=1
+            
+            assert int(data_of_diot.get('value_of_acts_or_activities_paid_at_the_rate_of_16%')) == 100 , 'Wrong, Valor de los actos o actividades pagados a la tasa del 15% ó 16% de IVA is not 100'
+            assert int(data_of_diot.get('value_of_acts_or_activities_paid_at_the_rate_of_11%_VAT')) == 100 , 'Wrong, Valor de los actos o actividades pagados a la tasa del 10% u 11% de IVA is not 100'
+            assert int(data_of_diot.get('value_of_the_other_acts_or_activities_paid_at_the_rate_of_0%_VAT')) == 100 , 'Wrong, Valor de los demás actos o actividades pagados a la tasa del 0% de IVA is not 100'
+            assert int(data_of_diot.get('value_of_acts_or_activities_paid_by_those_who_do_not_pay_the_VAT_(Exempt)')) == 100 , 'Wrong, Valor de los actos o actividades pagados por los que no se pagará el IVA (Exentos) is not100'
+            assert int(data_of_diot.get('tax Withheld by the taxpayer')) == 11 , 'Wrong, IVA Retenido por el contribuyente is not 11'