Merge lp:~vauxoo/openerp-venezuela-localization/miguel-retencion-iva into lp:~openerp-venezuela/openerp-venezuela-localization/6.0-trunk

[Miguel Delgado (Vauxoo)]

add to the l10n_ve_withholding_iva the property to generate the iva txt

=== modified file 'l10n_ve_withholding_iva/__init__.py'
--- l10n_ve_withholding_iva/__init__.py	2011-10-01 01:22:41 +0000
+++ l10n_ve_withholding_iva/__init__.py	2011-10-03 14:54:19 +0000
@@ -22,6 +22,8 @@
 import account
 import invoice
 import partner
+import generate_txt
+import report
 import res_company
 import installer
 

=== modified file 'l10n_ve_withholding_iva/__openerp__.py'
--- l10n_ve_withholding_iva/__openerp__.py	2011-10-02 05:41:11 +0000
+++ l10n_ve_withholding_iva/__openerp__.py	2011-10-03 14:54:19 +0000
@@ -32,17 +32,25 @@
     'init_xml': [],
     "depends" : ["l10n_ve_withholding"],
     'update_xml': [
+
         'security/wh_iva_security.xml',
         'security/ir.model.access.csv',
-        'res_company_view.xml',    
+        'generate_txt_view.xml',
+        'txt_wh_report.xml',
+        'res_company_view.xml',
         'account_invoice_view.xml',
         'account_view.xml',
-        'partner_view.xml',        
+        'partner_view.xml',
         'wh_iva_view.xml',
         "data/l10n_ve_withholding_data.xml",
         "wh_iva_workflow.xml",
+<<<<<<< TREE
         "account_workflow.xml",        
         "l10n_ve_withholding_iva_installer.xml",
+=======
+        "account_workflow.xml",
+
+>>>>>>> MERGE-SOURCE
     ],
     'demo_xml': ["demo/l10n_ve_withholding_iva_demo.xml"],
     'test': [],

=== added file 'l10n_ve_withholding_iva/generate_txt.py'
--- l10n_ve_withholding_iva/generate_txt.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_iva/generate_txt.py	2011-10-03 14:54:19 +0000
@@ -0,0 +1,263 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Humberto Arocha           <[e-mail]>
+#              Maria Gabriela Quilarque  <[e-mail]>
+#              Javier Duran              <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+from osv import osv
+from osv import fields
+from tools.translate import _
+from tools import config
+import time
+import datetime
+from xml.etree.ElementTree import Element, SubElement, ElementTree, tostring
+import sys
+import base64
+
+class txt_iva(osv.osv):
+    _name = "txt.iva"
+
+    #~ def _get_amount_total(self,cr,uid,ids,name,args,context=None):
+        #~ res = {}
+        #~ for txt in self.browse(cr,uid,ids,context):
+            #~ res[txt.id]=0.0
+            #~ for txt_line in txt.txt_ids:
+                #~ res[txt.id] += txt_line.amount_withheld
+                #~ 
+        #~ return res
+
+    #~ def _get_amount_total_base(self,cr,uid,ids,name,args,context=None):
+        #~ res = {}
+        #~ for txt in self.browse(cr,uid,ids,context):
+            #~ res[txt.id]= 0.0
+            #~ for txt_line in txt.txt_ids:
+                #~ print  'result: ',res[txt.id]
+                #~ print 'monto: ', txt_line.untaxed
+                #~ res[txt.id] += txt_line.untaxed
+                #~ 
+        #~ return res
+
+    _columns = {
+        'company_id': fields.many2one('res.company', 'Compañía', required=True, readonly=True,states={'draft':[('readonly',False)]}),
+        'state': fields.selection([
+            ('draft','Draft'),
+            ('confirmed', 'Confirmed'),
+            ('done','Done'),
+            ('cancel','Cancelled')
+            ],'Estado', select=True, readonly=True, help="Estado del Comprobante"),
+        'fiscalyear_id': fields.many2one('account.fiscalyear', 'Año Fiscal', required=True,readonly=True,states={'draft':[('readonly',False)]}),
+        'period_id':fields.many2one('account.period','Periodo',required=True,readonly=True,states={'draft':[('readonly',False)]}, domain="[('fiscalyear_id','=',fiscalyear_id)]"),
+        'type':fields.boolean('Retención Proveedores?',required=True,states={'draft':[('readonly',False)]}, help="Seleccione el tipo de retencion a realizar"),
+        'date_start': fields.date('Fecha Inicio',required=True,states={'draft':[('readonly',False)]}, help="Fecha de Inicio del periodo"),
+        'date_end': fields.date('Fecha Fin', required=True,states={'draft':[('readonly',False)]}, help="Fecha de Fin del periodo"),
+        'type':fields.boolean('Retención Proveedores?',required=True,states={'draft':[('readonly',False)]}, help="Seleccione el tipo de retencion a realizar"),
+        'txt_ids':fields.one2many('txt.iva.line','txt_id',domain="[('txt_id','=',False)]", readonly=True,states={'draft':[('readonly',False)]}, help='Lineas del archivo txt exigido por el SENIAT, para retención del IVA'),
+        #~ 'amount_total_ret':fields.function(_get_amount_total,method=True, digits=(16, 2), readonly=True, string=' Total Monto de Retencion', help="Monto Total Retenido"),
+        #~ 'amount_total_base':fields.function(_get_amount_total_base,method=True, digits=(16, 2), readonly=True, string='Total Base Imponible', help="Total de la Base Imponible"),
+    }
+    _rec_rame = 'company_id'
+    _defaults = {
+        'state': lambda *a: 'draft',
+        'company_id': lambda self, cr, uid, context: \
+                self.pool.get('res.users').browse(cr, uid, uid,
+                    context=context).company_id.id,
+        'type': lambda *a:'True',
+    }
+
+    def action_anular(self, cr, uid, ids, context={}):
+        return self.write(cr, uid, ids, {'state':'draft'})
+
+    def action_confirm(self, cr, uid, ids, context={}):
+        return self.write(cr, uid, ids, {'state':'confirmed'})
+
+    def action_generate_lines_txt(self,cr,uid,ids,context={}):
+        voucher_obj = self.pool.get('account.wh.iva')
+        txt_iva_obj = self.pool.get('txt.iva.line')
+        
+        voucher_ids=''
+        txt_brw= self.browse(cr,uid,ids[0])
+        txt_ids = txt_iva_obj.search(cr,uid,[('txt_id','=',txt_brw.id)])
+        if txt_ids:
+            txt_iva_obj.unlink(cr,uid,txt_ids)
+        
+        if txt_brw.type:
+            voucher_ids = voucher_obj.search(cr,uid,[('date_ret','>=',txt_brw.date_start),('date_ret','<=',txt_brw.date_end),('period_id','=',txt_brw.period_id.id),('state','=','done'),('type','in',['in_invoice','in_refund'])])
+        else:
+            voucher_ids = voucher_obj.search(cr,uid,[('date_ret','>=',txt_brw.date_start),('date_ret','<=',txt_brw.date_end),('period_id','=',txt_brw.period_id.id),('state','=','done'),('type','in',['out_invoice','out_refund'])])
+        
+        for voucher in voucher_obj.browse(cr,uid,voucher_ids):
+            
+            for voucher_lines in voucher.retention_line:
+                
+                if voucher_lines.invoice_id.state in ['open','paid']:
+                    txt_iva_obj.create(cr,uid,
+                    {'partner_id':voucher.partner_id.id,
+                    'voucher_id':voucher.id,
+                    'invoice_id':voucher_lines.invoice_id.id,
+                    'txt_id': txt_brw.id,
+                    'untaxed': voucher_lines.base_ret,
+                    'amount_withheld': voucher_lines.amount_tax_ret,
+                    })
+        return True
+
+    def action_done(self, cr, uid, ids, context={}):
+        root = self.generate_txt(cr,uid,ids)
+        self._write_attachment(cr,uid,ids,root,context)
+        self.write(cr, uid, ids, {'state':'done'})
+        return True
+
+    def get_type_document(self,cr,uid,txt_line):
+        type= '03'
+        if txt_line.invoice_id.type in ['out_invoice','in_invoice']:
+            type= '01'
+        elif txt_line.invoice_id.type in ['out_invoice','in_invoice'] and txt_line.invoice_id.parent_id:
+            type= '02'
+        return type
+
+    def get_document_affected(self,cr,uid,txt_line,context):
+        number='0'
+        if txt_line.invoice_id.type in ['in_invoice','in_refund'] and txt_line.invoice_id.parent_id:
+            number = txt_line.invoice_id.parent_id.reference
+        elif txt_line.invoice_id.parent_id: 
+            number = txt_line.invoice_id.parent_id.number
+        return number
+
+    def get_number(self,cr,uid,number,inv_type,long):
+        if not number:
+            return '0'
+        result= ''
+        for i in number:
+            if inv_type=='vou_number' and i.isdigit():
+                if len(result)<long:
+                    result = i + result
+            elif i.isalnum():
+                if len(result)<long:
+                    result = i + result
+        return result[::-1].strip()
+
+    def get_document_number(self,cr,uid,ids,txt_line,inv_type,context):
+        number=0
+        if txt_line.invoice_id.type in ['in_invoice','in_refund']:
+            if not txt_line.invoice_id.reference:
+                raise osv.except_osv(_('Invalid action !'),_("Imposible realizar archivo txt, debido a que la factura no tiene numero de referencia libre!"))
+            else:
+                number = self.get_number(cr,uid,txt_line.invoice_id.reference.strip(),inv_type,20)
+        elif txt_line.invoice_id.number:
+            number = self.get_number(cr,uid,txt_line.invoice_id.number.strip(),inv_type,20)
+        return number
+
+    def get_amount_exempt_document(self,cr,uid,txt_line):
+        tax = 0
+        amount_doc = 0
+        for tax_line in txt_line.invoice_id.tax_line:
+            if 'SDCF' in tax_line.name:
+                tax = tax_line.base + tax
+            else:
+                amount_doc = tax_line.base + amount_doc
+        return (tax,amount_doc)
+
+    def get_buyer_vendor(self,cr,uid,txt,txt_line):
+        if txt_line.invoice_id.type in ['out_invoice','out_refund']:
+            vendor = txt.company_id.partner_id.vat[2:]
+            buyer  = txt_line.partner_id.vat[2:]
+        else:
+            buyer  = txt.company_id.partner_id.vat[2:]
+            vendor = txt_line.partner_id.vat[2:]
+        return (vendor,buyer)
+
+    def get_alicuota(self,cr,uid,txt_line):
+        list = []
+        for tax_line in txt_line.invoice_id.tax_line:
+            if '12' in tax_line.name:
+                list.append(12)
+            if '8' in tax_line.name:
+                list.append(8)
+            if '22' in tax_line.name:
+                list.append(22)
+            if '0' in tax_line.name:
+                list.append(0)
+        return max(list)
+
+    def generate_txt(self,cr,uid,ids,context=None):
+        txt_string = ''
+        for txt in self.browse(cr,uid,ids,context):
+            vat = txt.company_id.partner_id.vat[2:]
+            for txt_line in txt.txt_ids:
+                
+                vendor,buyer=self.get_buyer_vendor(cr,uid,txt,txt_line)
+                period = txt.period_id.name.split('/')
+                period2 = period[1]+period[0]
+                
+                operation_type = 'V' if txt_line.invoice_id.type in ['out_invoice','out_refund'] else 'C'
+                document_type  = self.get_type_document(cr,uid,txt_line)
+                document_number=self.get_document_number(cr,uid,ids,txt_line,'inv_number',context)
+                control_number = self.get_number(cr,uid,txt_line.invoice_id.nro_ctrl,'inv_ctrl',20)
+                document_affected= self.get_document_affected(cr,uid,txt_line,context)
+                voucher_number = self.get_number(cr,uid,txt_line.voucher_id.number,'vou_number',14)
+                amount_exempt,amount_untaxed = self.get_amount_exempt_document(cr,uid,txt_line)
+                alicuota = self.get_alicuota(cr,uid,txt_line)
+
+                txt_string= txt_string + buyer +'\t'+period2.strip()+'\n'
+                #~ +'\t'\
+                #~ +txt_line.invoice_id.date_invoice+'\t'+operation_type+'\t'+document_type+'\t'+vendor+'\t'\
+                #~ +document_number+'\t'+control_number+'\t'+str(round(txt_line.invoice_id.amount_total,2))+'\t'\
+                #~ +str(round(amount_untaxed,2))+'\t'\
+                #~ +str(round(txt_line.amount_withheld,2))+'\t'+document_affected+'\t'+voucher_number+'\t'\
+                #~ +str(round(amount_exempt,2))+'\t'+str(alicuota)+'\t'+'0'\
+                
+        return txt_string
+        
+    def _write_attachment(self, cr,uid,ids,root,context):
+        '''
+        Codificar el txt, para guardarlo en la bd y poder verlo en el cliente como attachment
+        '''
+        fecha = time.strftime('%Y_%m_%d')
+        name = 'IVA_' + fecha +'.'+ 'txt'
+        self.pool.get('ir.attachment').create(cr, uid, {
+            'name': name,
+            'datas': base64.encodestring(root),
+            'datas_fname': name,
+            'res_model': 'txt.iva',
+            'res_id': ids[0],
+            }, context=context
+        )
+        cr.commit()
+        
+txt_iva()
+
+
+class txt_iva_line(osv.osv):
+    _name = "txt.iva.line"
+    
+    _columns = {
+        'partner_id':fields.many2one('res.partner','Comprador/Vendedor',help="Persona jurídica ó natural que genera la Factura, Nota de Crédito, Nota de Débito o Certificación (vendedor)"),
+        'invoice_id':fields.many2one('account.invoice','Factura/ND/NC',help="Fecha de la factura, Nota de Crédito, Nota de Débito o Certificación, Declaración de Importación"),
+        'voucher_id':fields.many2one('account.wh.iva','Comprobante de Retencion IVA',help="Comprobante de Retencion de Impuesto al Valor Agregado (IVA)"),
+        'amount_withheld':fields.float('Amount Withheld'),
+        'untaxed':fields.float('Untaxed'),
+        'txt_id':fields.many2one('txt.iva','Documento-Generar txt IVA'),
+    }
+    _rec_name = 'partner_id'
+ 
+txt_iva_line()

=== added file 'l10n_ve_withholding_iva/generate_txt_view.xml'
--- l10n_ve_withholding_iva/generate_txt_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_iva/generate_txt_view.xml	2011-10-03 14:54:19 +0000
@@ -0,0 +1,108 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+    <!-- 
+    =====================================================
+    XML GENERATE
+    =====================================================
+    -->
+
+         <record id="view_generate_txt_iva_tree" model="ir.ui.view">
+            <field name="name">generate.txt.iva.tree</field>
+            <field name="model">txt.iva</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Archivo TXT">
+                    <field name="company_id"/>
+                    <field name="fiscalyear_id"/>
+                    <field name="period_id"/>
+                    <field name="type"/>
+                </tree>
+            </field>
+        </record>
+
+        <record id="view_generate_txt_iva_form" model="ir.ui.view">
+            <field name="name">generate.txt.iva.form</field>
+            <field name="model">txt.iva</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Lineas de Retencion para TXT">
+                    <group col="4" colspan="4">
+                        <field name="company_id"/>
+                        <field name="type"/>
+                    </group>
+                    <newline/>
+                    <group col="4" colspan="4">
+                        <field name="fiscalyear_id"  />
+                        <field name="period_id" />
+                    </group>
+                    <newline/>
+                    <group col="4" colspan="4">
+                        <field name="date_start"/>
+                        <field name="date_end"/>
+                    </group>
+                    <notebook colspan="4">
+                        <page string="Lineas de Retencion">
+                            <field name="txt_ids" nolabel="1"  colspan='4' widget="one2many_list">
+                                <tree string="Lineas del archivo TXT">
+                                    <field name="partner_id"/>
+                                    <field name="invoice_id"/>
+                                    <field name="voucher_id"/>
+                                    <field name="untaxed"/>
+                                    <field name="amount_withheld"/>
+                                </tree>
+                            </field>
+                            <group col="4" colspan="2">
+                                <field name="state" select="2" colspan="4"/>
+                                <button name="action_generate_lines_txt" string="Generar Lineas TXT" states="draft" type="object" icon="gtk-go-forward" colspan="4"/>
+                                <button name="action_confirm" string="Confirmar" states="draft" type="object" icon="gtk-go-forward" colspan="4"/>
+                                <button name="action_done" string="Realizar TXT" states="confirmed" type="object"  icon="gtk-ok"/>
+                                <button name="action_anular" string="Anular" states="confirmed,done" type="object"  icon="gtk-cancel"/>
+                            </group>
+<!--
+                            <group col="2" colspan="2">
+                                <field name="amount_total_ret"/>
+                                <field name="amount_total_base"/>
+                             </group>
+-->
+                        </page>
+                    </notebook>
+                </form>
+            </field>
+        </record>
+
+        <record model="ir.actions.act_window" id="action_generate_text_iva">
+            <field name="name">Generate TXT</field>
+            <field name="res_model">txt.iva</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+        </record>
+
+        <record model="ir.actions.act_window.view" id="action_generate_txt_iva_tree">
+            <field name="sequence" eval="10"/>
+            <field name="view_mode">tree</field>
+            <field name="view_id" ref="view_generate_txt_iva_tree"/> 
+            <field name="act_window_id" ref="action_generate_text_iva"/>
+        </record>
+
+        <record model="ir.actions.act_window.view" id="action_generate_txt_iva_form">
+            <field name="sequence" eval="20"/>
+            <field name="view_mode">form</field>
+            <field name="view_id" ref="view_generate_txt_iva_form"/>
+            <field name="act_window_id" ref="action_generate_text_iva"/>
+        </record>
+
+        <menuitem name="Generar TXT" 
+            id="menu_action_generate_txt_iva" 
+            parent="l10n_ve_withholding.menu_wh_suppiler"
+            action="action_generate_text_iva"/>
+
+    </data>
+</openerp>
+
+
+
+
+

=== modified file 'l10n_ve_withholding_iva/partner.py'
--- l10n_ve_withholding_iva/partner.py	2011-09-28 03:57:04 +0000
+++ l10n_ve_withholding_iva/partner.py	2011-10-03 14:54:19 +0000
@@ -55,6 +55,7 @@
     }
 
     def _load_url(self,retries,url):
+        print 'load'
         str_error= '404 Not Found'
         while retries > 0:
             try:
@@ -69,12 +70,11 @@
         return str_error
 
     def _buscar_porcentaje(self,rif,url):
-        '''
-        Search percent of withholding connecting to SENIAT
-        '''
         context={}
+        print"esta pasando por aqui"
         html_data = self._load_url(3,url %rif)
         html_data = unicode(html_data, 'ISO-8859-1').encode('utf-8')
+        print "html_data",html_data
         self._eval_seniat_data(html_data,context)
         search_str='La condición de este contribuyente requiere la retención del '
         pos = html_data.find(search_str)
@@ -86,13 +86,13 @@
             return 0.0
 
     def _parse_dom(self,dom,rif,url_seniat):
-        '''
-        Parsing data from SENIAT
-        '''
+        print 'entrando dom'
         name = dom.childNodes[0].childNodes[0].firstChild.data 
         wh_agent = dom.childNodes[0].childNodes[1].firstChild.data.upper()=='SI' and True or False
         vat_apply = dom.childNodes[0].childNodes[2].firstChild.data.upper()=='SI' and True or False
         wh_rate = self._buscar_porcentaje(rif,url_seniat)
+        print "wh_rate",wh_rate
+        print 'nombre: ',name
         return {'name':name, 'wh_iva_agent':wh_agent,'vat_subjected':vat_apply,'wh_iva_rate':wh_rate}
 
     def _print_error(self, error, msg):
@@ -113,11 +113,13 @@
                 self._print_error(_('No Connection !'),_("Could not connect! Check the URL "))
     
     def update_rif(self, cr, uid, ids, context={}):
+        print 'entando update'
         for partner in self.browse(cr,uid,ids):
             url1=partner.company_id.url_seniat1_company+'%s'
             url2=partner.company_id.url_seniat2_company+'%s'
             xml_data = self._load_url(3,url1 %partner.vat[2:])
             self._eval_seniat_data(xml_data,context)
+            print 'xml_data',xml_data
             dom = parseString(xml_data)
             self.write(cr,uid,partner.id,self._parse_dom(dom,partner.vat[2:],url2))
         return True

=== added directory 'l10n_ve_withholding_iva/report'
=== added file 'l10n_ve_withholding_iva/report/__init__.py'
--- l10n_ve_withholding_iva/report/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_iva/report/__init__.py	2011-10-03 14:54:19 +0000
@@ -0,0 +1,30 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Humberto Arocha           <[e-mail]>
+#              Maria Gabriela Quilarque  <[e-mail]>
+#              Javier Duran              <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+
+import list_wh_iva
+

=== added file 'l10n_ve_withholding_iva/report/list_wh_iva.py'
--- l10n_ve_withholding_iva/report/list_wh_iva.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_iva/report/list_wh_iva.py	2011-10-03 14:54:19 +0000
@@ -0,0 +1,54 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Humberto Arocha           <[e-mail]>
+#              Maria Gabriela Quilarque  <[e-mail]>
+#              Javier Duran              <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+
+import time
+import pooler
+from report import report_sxw
+from tools.translate import _
+
+class list_wh_iva(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(list_wh_iva, self).__init__(cr, uid, name, context=context)
+        self.localcontext.update({
+            'get_type_doc': self._get_type_document,
+        })
+
+    def _get_type_document(self,line):
+        return self.pool.get('txt.iva').get_type_document(self.cr,self.uid,line)
+
+    #~ def get_type_document(self,cr,uid,txt_line):
+
+
+
+report_sxw.report_sxw(
+    'report.list_report_wh_vat2',
+    'txt.iva',
+    'addons/l10n_ve_withholding_iva/report/list_wh_iva_report.rml',
+    parser=list_wh_iva, 
+    header=False
+)

=== added file 'l10n_ve_withholding_iva/report/list_wh_iva_report.rml'
--- l10n_ve_withholding_iva/report/list_wh_iva_report.rml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_iva/report/list_wh_iva_report.rml	2011-10-03 14:54:19 +0000
@@ -0,0 +1,157 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+  <template pageSize="(280.0mm,210.0mm)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
+    <pageTemplate id="first">
+        <pageGraphics>
+            <image x="7.0mm" y="175.0mm" height="25mm" width="96mm">[[company.logo and company.logo or removeParentNode('image')]]</image>
+            <drawString x="7.0mm" y="175.0mm">[[company.logo and removeParentNode('para') or company.name]]</drawString> 
+            <place x="7.0mm"  y="100.0mm" width="280.0mm"  height="100.0mm">
+                <!--TABLA DE TITULOS-->
+                <blockTable colWidths="96mm,170mm" style="TITLE">
+                    <tr>
+                        <td><para style="TITLE"></para>
+                        </td>
+                        <td>
+                            <para style="TITLE"><b>DECLARACION INFORMATIVA DE RETENCIONES IVA</b></para>
+                        </td>
+                    </tr>
+                </blockTable>
+                <blockTable colWidths="96mm,170.0mm" style="TITLEGRISCLAROARRIBA">
+                    <tr>
+                        <td><para style="ITEMSCENTER"> </para>
+                        </td>
+                        <td>
+                            <para style="ITEMSCENTER"><b>PERIODO FISCAL</b></para>
+                        </td>
+                    </tr>
+                </blockTable>
+                <blockTable colWidths="96mm,170.0mm" style="TITLEGRISWHITE">
+                    <tr>
+                        <td><para style="ITEMSCENTER"> </para>
+                        </td>
+                        <td>
+                            <para style="ITEMSCENTER"><b>[[ o.period_id.name]]</b></para>
+                        </td>
+                    </tr>
+                </blockTable>
+            </place>
+                <setFont name="Helvetica-BoldOblique" size="8.0"/>
+            <drawRightString x="270mm" y="5mm">RETENCIONES DE IVA / PAGINA: <pageNumber/> DE <pageCount/> </drawRightString> 
+            
+        </pageGraphics>
+        <frame id="first" x1="20.0" y1="20.0" width="753" height="480"/>
+    </pageTemplate>
+  </template>
+  
+  <stylesheet>
+    <blockTableStyle id="TITLE">
+        <lineStyle kind="GRID" colorName="black" start="1,0" stop="-1,-1" thickness="0.5"/>
+        <blockValign value="TOP"/>
+    </blockTableStyle>
+        <blockTableStyle id="TOTAL">
+            <blockValign value="TOP"/>
+            <lineStyle kind="GRID" colorName="black" start="1,0" stop="-1,-1" thickness="0.5" />
+        </blockTableStyle>  
+    <blockTableStyle id="TITLEGRISCLAROARRIBA">
+        <blockBackground colorName="#e5e2e5" start="1,0" stop="-1,-1"/>
+        <lineStyle kind="GRID" colorName="black" start="1,0" stop="-1,-1" thickness="0.5"/>
+        <blockValign value="MIDDLE"/>
+    </blockTableStyle>
+    <blockTableStyle id="TITLEGRISWHITE">
+        <lineStyle kind="GRID" colorName="black" start="1,0" stop="-1,-1" thickness="0.5"/>
+        <blockValign value="MIDDLE"/>
+    </blockTableStyle> 
+    <blockTableStyle id="Tabla3">
+    <blockBackground colorName="#e5e2e5" start="0,0" stop="-1,0"/>
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="GRID" colorName="black" start="0,0" stop="-1,-1" thickness="0.5"/>
+      <blockValign value="MIDDLE"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tablatotalgeneral">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="GRID" colorName="black" start="9,0" stop="-1,-1" thickness="0.5"/>
+      <blockValign value="MIDDLE"/>
+    </blockTableStyle>  
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="TITLE" alignment="CENTER" fontName="Helvetica" fontSize="12.0" leading="20" spaceBefore="-3.0" textColor="black"/>
+    <paraStyle name="ITEMSCENTER" alignment="CENTER" fontName="Helvetica-Bold" fontSize="10.0" leading="9" spaceBefore="3.0" textColor="black"/>  
+    <paraStyle name="ITEMSRIF" alignment="CENTER" fontName="Helvetica-Bold" fontSize="12.0" leading="11" spaceBefore="3.0" textColor="black"/>
+    <paraStyle name="P15" fontName="Helvetica-Bold" fontSize="10.0" leading="10" spaceBefore="3.0" alignment="CENTER"/>
+    <paraStyle name="P12" fontName="Helvetica" fontSize="10.0" leading="11" alignment="CENTER"/>
+    <paraStyle name="P13" fontName="Helvetica" fontSize="10.0" leading="11" alignment="RIGHT"/>
+    <paraStyle name="P16" fontName="Helvetica-Bold" fontSize="10.0" leading="11" alignment="RIGHT"/>
+    <paraStyle name="P14" fontName="Helvetica" fontSize="10.0" leading="11" alignment="LEFT"/>
+    <paraStyle name="P22" fontName="Helvetica" fontSize="9.0" leading="11" spaceBefore="0.0" spaceAfter="6.0" alignment="RIGHT"/>
+  </stylesheet>
+  <images/>
+ 
+  <story>
+    <para>[[repeatIn(objects,'o')]]</para>
+    <para>[[ setLang(company.partner_id.lang) ]]</para> 
+    <blockTable colWidths="410.0,198.0,50.0,50.0,45.0" repeatRows='1' style="Tabla3">
+<!--
+    <blockTable colWidths="75.0,335.0,68.0,50.0,80.0,60.0,85.0" repeatRows='1' style="Tabla3">
+-->
+      <tr>
+        <td><para style="P15">RIF Contribuyente</para></td>
+        <td><para style="P15">Periodo</para></td>
+        <td><para style="P15">Fecha Doc.</para></td>
+        <td><para style="P15">Tipo Ope.</para></td>
+        <td><para style="P15">Tipo Doc.</para></td>
+<!--
+        <td><para style="P15">RIF C/V</para></td>
+        <td><para style="P15">Num Doc.</para></td>
+        <td><para style="P15">Num Control</para></td>
+        <td><para style="P15">Monto Doc.</para></td>
+        <td><para style="P15">Base Impo.</para></td>
+        <td><para style="P15">Monto IVA</para></td>
+        <td><para style="P15">Num.Doc.Afec.</para></td>
+        <td><para style="P15">Num.Compro.</para></td>
+        <td><para style="P15">Monto Exc. IVA</para></td>
+        <td><para style="P15">Alicuota</para></td>
+        <td><para style="P15">Expediente</para></td>
+-->
+      </tr>
+        <tr>[[repeatIn(o.txt_ids,'line')]]
+          <td><para style="P12">[[ '98798' ]]</para></td>
+          <td><para style="P14">[[ o.period_id.name ]]</para></td>
+          <td><para style="P12">[[ line.invoice_id.date_invoice ]]</para></td>
+          <td><para style="P12">[[ (line.invoice_id.type in ['out_invoice','out_refund']) and 'V' or 'C' ]]</para></td>
+          <td><para style="P13">[[ get_type_doc(line) ]]</para></td>
+
+<!--
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+          <td><para style="P13">[[  ]]</para></td>
+-->
+        </tr>
+    </blockTable>
+    <blockTable colWidths="410.0,198.0,145.0" style="TOTAL">
+        <tr>
+            <td><para style="P22"><font color="white"></font></para></td>
+            <td><para style="P16">TOTAL BASE IMPONIBLE</para></td>
+            <td><para style="P16">[[ formatLang(o.amount_total_base) ]]</para></td>
+        </tr>
+        <tr>
+            <td><para style="P22"><font color="white"></font></para></td>
+            <td><para style="P16">TOTAL MONTO DE RETENCION</para></td>
+            <td><para style="P16">[[ formatLang(o.amount_total_ret) ]]</para></td>
+        </tr>
+    </blockTable>
+
+  </story>
+
+</document>
+

=== added file 'l10n_ve_withholding_iva/txt_wh_report.xml'
--- l10n_ve_withholding_iva/txt_wh_report.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_iva/txt_wh_report.xml	2011-10-03 14:54:19 +0000
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <report
+            id="list_report_wh_vat" 
+            menu="True"
+            model="txt.iva" 
+            name="list_report_wh_vat2" 
+            rml="l10n_ve_withholding_iva/report/list_wh_iva_report.rml" 
+            string="Retenciones IVA"
+            auto = "True"
+            header="False"/>
+    </data>
+</openerp>
+