Merge lp:~vauxoo/openerp-venezuela-localization/l10n_ve_withholding_muni into lp:~openerp-venezuela/openerp-venezuela-localization/6.0-trunk

[Javier Duran]

[MERGE] Agregando modulo de retención de impuesto municipales

Se agrega el proceso de retención de impuesto municipales

[Javier Duran (javieredm)]

ya se realizó la mezcla

review: Approve

=== modified file 'l10n_ve_withholding/__init__.py'
--- l10n_ve_withholding/__init__.py	2011-05-11 16:44:18 +0000
+++ l10n_ve_withholding/__init__.py	2011-09-22 17:22:23 +0000
@@ -22,5 +22,6 @@
 import account
 import l10n_ve_withholding
 import account_move_line
+import invoice
 
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'l10n_ve_withholding/invoice.py'
--- l10n_ve_withholding/invoice.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding/invoice.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,173 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    
+#    
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero 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 Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import time
+from osv import fields, osv
+import decimal_precision as dp
+
+
+
+class account_invoice(osv.osv):
+    _inherit = 'account.invoice'
+
+    def ret_and_reconcile(self, cr, uid, ids, pay_amount, pay_account_id, period_id, pay_journal_id, writeoff_acc_id, writeoff_period_id, writeoff_journal_id, date, name, context=None):
+        if context is None:
+            context = {}
+        #TODO check if we can use different period for payment and the writeoff line
+        assert len(ids)==1, "Can only pay one invoice at a time"
+        invoice = self.browse(cr, uid, ids[0])
+        src_account_id = invoice.account_id.id
+        # Take the seq as name for move
+        types = {'out_invoice': -1, 'in_invoice': 1, 'out_refund': 1, 'in_refund': -1}
+        direction = types[invoice.type]
+        l1 = {
+            'debit': direction * pay_amount>0 and direction * pay_amount,
+            'credit': direction * pay_amount<0 and - direction * pay_amount,
+            'account_id': src_account_id,
+            'partner_id': invoice.partner_id.id,
+            'ref':invoice.number,
+            'date': date,
+            'currency_id': False,
+        }
+        l2 = {
+            'debit': direction * pay_amount<0 and - direction * pay_amount,
+            'credit': direction * pay_amount>0 and direction * pay_amount,
+            'account_id': pay_account_id,
+            'partner_id': invoice.partner_id.id,
+            'ref':invoice.number,
+            'date': date,
+            'currency_id': False,
+        }
+
+        l1['name'] = name
+        l2['name'] = name
+
+        lines = [(0, 0, l1), (0, 0, l2)]
+        move = {'ref': invoice.number, 'line_id': lines, 'journal_id': pay_journal_id, 'period_id': period_id, 'date': date}
+        move_id = self.pool.get('account.move').create(cr, uid, move, context=context)
+
+        self.pool.get('account.move').post(cr, uid, [move_id])
+
+        line_ids = []
+        total = 0.0
+        line = self.pool.get('account.move.line')
+        cr.execute('select id from account_move_line where move_id in ('+str(move_id)+','+str(invoice.move_id.id)+')')
+        lines = line.browse(cr, uid, map(lambda x: x[0], cr.fetchall()) )
+        for l in lines+invoice.payment_ids:
+            if l.account_id.id==src_account_id:
+                line_ids.append(l.id)
+                total += (l.debit or 0.0) - (l.credit or 0.0)
+        if (not round(total,self.pool.get('decimal.precision').precision_get(cr, uid, 'Withhold'))) or writeoff_acc_id:
+            self.pool.get('account.move.line').reconcile(cr, uid, line_ids, 'manual', writeoff_acc_id, writeoff_period_id, writeoff_journal_id, context)
+        else:
+            self.pool.get('account.move.line').reconcile_partial(cr, uid, line_ids, 'manual', context)
+
+        # Update the stored value (fields.function), so we write to trigger recompute
+        self.pool.get('account.invoice').write(cr, uid, ids, {}, context=context)
+        return {'move_id': move_id}
+
+
+    def check_tax_lines(self, cr, uid, inv, compute_taxes, ait_obj):
+        if not inv.tax_line:
+            for tax in compute_taxes.values():
+                ait_obj.create(cr, uid, tax)
+        else:
+            tax_key = []
+            for tax in inv.tax_line:
+                if tax.manual:
+                    continue
+#                key = (tax.tax_code_id.id, tax.base_code_id.id, tax.account_id.id)
+                #### group by tax id  ####
+                key = (tax.tax_id.id)
+                tax_key.append(key)
+                if not key in compute_taxes:
+                    raise osv.except_osv(_('Warning !'), _('Global taxes defined, but are not in invoice lines !'))
+                base = compute_taxes[key]['base']
+                if abs(base - tax.base) > inv.company_id.currency_id.rounding:
+                    raise osv.except_osv(_('Warning !'), _('Tax base different !\nClick on compute to update tax base'))
+            for key in compute_taxes:
+                if not key in tax_key:
+                    raise osv.except_osv(_('Warning !'), _('Taxes missing !'))
+
+account_invoice()
+
+
+
+
+class account_invoice_tax(osv.osv):
+    _inherit = 'account.invoice.tax'
+    _columns = {
+        'tax_id': fields.many2one('account.tax', 'Tax', required=True, ondelete='set null', help="Tax"),
+    }
+
+    def compute(self, cr, uid, invoice_id, context=None):
+        tax_grouped = {}
+        tax_obj = self.pool.get('account.tax')
+        cur_obj = self.pool.get('res.currency')
+        inv = self.pool.get('account.invoice').browse(cr, uid, invoice_id, context=context)
+        cur = inv.currency_id
+        company_currency = inv.company_id.currency_id.id
+
+        for line in inv.invoice_line:
+            for tax in tax_obj.compute_all(cr, uid, line.invoice_line_tax_id, (line.price_unit* (1-(line.discount or 0.0)/100.0)), line.quantity, inv.address_invoice_id.id, line.product_id, inv.partner_id)['taxes']:
+                val={}
+                val['invoice_id'] = inv.id
+                val['name'] = tax['name']
+                val['amount'] = tax['amount']
+                val['manual'] = False
+                val['sequence'] = tax['sequence']
+                val['base'] = tax['price_unit'] * line['quantity']
+                ####  add tax id  ####
+                val['tax_id'] = tax['id']
+
+                if inv.type in ('out_invoice','in_invoice'):
+                    val['base_code_id'] = tax['base_code_id']
+                    val['tax_code_id'] = tax['tax_code_id']
+                    val['base_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['base'] * tax['base_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
+                    val['tax_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['amount'] * tax['tax_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
+                    val['account_id'] = tax['account_collected_id'] or line.account_id.id
+                else:
+                    val['base_code_id'] = tax['ref_base_code_id']
+                    val['tax_code_id'] = tax['ref_tax_code_id']
+                    val['base_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['base'] * tax['ref_base_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
+                    val['tax_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['amount'] * tax['ref_tax_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
+                    val['account_id'] = tax['account_paid_id'] or line.account_id.id
+
+#                key = (val['tax_code_id'], val['base_code_id'], val['account_id'])
+                #### group by tax id  ####
+                key = (val['tax_id'])
+                if not key in tax_grouped:
+                    tax_grouped[key] = val
+                else:
+                    tax_grouped[key]['amount'] += val['amount']
+                    tax_grouped[key]['base'] += val['base']
+                    tax_grouped[key]['base_amount'] += val['base_amount']
+                    tax_grouped[key]['tax_amount'] += val['tax_amount']
+
+        for t in tax_grouped.values():
+            t['base'] = cur_obj.round(cr, uid, cur, t['base'])
+            t['amount'] = cur_obj.round(cr, uid, cur, t['amount'])
+            t['base_amount'] = cur_obj.round(cr, uid, cur, t['base_amount'])
+            t['tax_amount'] = cur_obj.round(cr, uid, cur, t['tax_amount'])
+        return tax_grouped
+
+
+account_invoice_tax()

=== modified file 'l10n_ve_withholding_iva/invoice.py'
--- l10n_ve_withholding_iva/invoice.py	2011-06-14 17:06:20 +0000
+++ l10n_ve_withholding_iva/invoice.py	2011-09-22 17:22:23 +0000
@@ -131,16 +131,14 @@
 
         return lines
 
-
     def wh_iva_line_create(self, cr, uid, inv):
         return (0, False, {
             'name': inv.name or inv.number,
             'invoice_id': inv.id,
         })
-    
 
     def action_wh_iva_create(self, cr, uid, ids, *args):
-        wh_iva_obj = self.pool.get('account.wh.iva')        
+        wh_iva_obj = self.pool.get('account.wh.iva')
         for inv in self.browse(cr, uid, ids):
             if inv.wh_iva_id:
                 raise osv.except_osv('Invalid Action !', 'Withhold Invoice !')
@@ -163,8 +161,7 @@
             ret_id = wh_iva_obj.create(cr, uid, ret_iva)
             self.write(cr, uid, [inv.id], {'wh_iva_id':ret_id})
         return True
-    
-            
+
     def button_reset_taxes_ret(self, cr, uid, ids, context=None):
         if not context:
             context = {}
@@ -178,156 +175,22 @@
 
         return True
 
-
-
-    def ret_and_reconcile(self, cr, uid, ids, pay_amount, pay_account_id, period_id, pay_journal_id, writeoff_acc_id, writeoff_period_id, writeoff_journal_id, date, name, context=None):
-        if context is None:
-            context = {}
-        #TODO check if we can use different period for payment and the writeoff line
-        assert len(ids)==1, "Can only pay one invoice at a time"
-        invoice = self.browse(cr, uid, ids[0])
-        src_account_id = invoice.account_id.id
-        # Take the seq as name for move
-        types = {'out_invoice': -1, 'in_invoice': 1, 'out_refund': 1, 'in_refund': -1}
-        direction = types[invoice.type]
-        l1 = {
-            'debit': direction * pay_amount>0 and direction * pay_amount,
-            'credit': direction * pay_amount<0 and - direction * pay_amount,
-            'account_id': src_account_id,
-            'partner_id': invoice.partner_id.id,
-            'ref':invoice.number,
-            'date': date,
-            'currency_id': False,
-        }
-        l2 = {
-            'debit': direction * pay_amount<0 and - direction * pay_amount,
-            'credit': direction * pay_amount>0 and direction * pay_amount,
-            'account_id': pay_account_id,
-            'partner_id': invoice.partner_id.id,
-            'ref':invoice.number,
-            'date': date,
-            'currency_id': False,
-        }
-
-        l1['name'] = name
-        l2['name'] = name
-
-        lines = [(0, 0, l1), (0, 0, l2)]
-        move = {'ref': invoice.number, 'line_id': lines, 'journal_id': pay_journal_id, 'period_id': period_id, 'date': date}
-        move_id = self.pool.get('account.move').create(cr, uid, move, context=context)
-
-        self.pool.get('account.move').post(cr, uid, [move_id])
-
-        line_ids = []
-        total = 0.0
-        line = self.pool.get('account.move.line')
-        cr.execute('select id from account_move_line where move_id in ('+str(move_id)+','+str(invoice.move_id.id)+')')
-        lines = line.browse(cr, uid, map(lambda x: x[0], cr.fetchall()) )
-        for l in lines+invoice.payment_ids:
-            if l.account_id.id==src_account_id:
-                line_ids.append(l.id)
-                total += (l.debit or 0.0) - (l.credit or 0.0)
-        if (not round(total,self.pool.get('decimal.precision').precision_get(cr, uid, 'Withhold'))) or writeoff_acc_id:
-            self.pool.get('account.move.line').reconcile(cr, uid, line_ids, 'manual', writeoff_acc_id, writeoff_period_id, writeoff_journal_id, context)
-        else:
-            self.pool.get('account.move.line').reconcile_partial(cr, uid, line_ids, 'manual', context)
-
-        # Update the stored value (fields.function), so we write to trigger recompute
-        self.pool.get('account.invoice').write(cr, uid, ids, {}, context=context)
-        return {'move_id': move_id}
-    
-
     def button_reset_taxes(self, cr, uid, ids, context=None):
         super(account_invoice, self).button_reset_taxes(cr, uid, ids, context)
         self.button_reset_taxes_ret(cr, uid, ids, context)
         
         return True
 
-
-    def check_tax_lines(self, cr, uid, inv, compute_taxes, ait_obj):
-        if not inv.tax_line:
-            for tax in compute_taxes.values():
-                ait_obj.create(cr, uid, tax)
-        else:
-            tax_key = []
-            for tax in inv.tax_line:
-                if tax.manual:
-                    continue
-#                key = (tax.tax_code_id.id, tax.base_code_id.id, tax.account_id.id)
-                #### group by tax id  ####
-                key = (tax.tax_id.id)
-                tax_key.append(key)
-                if not key in compute_taxes:
-                    raise osv.except_osv(_('Warning !'), _('Global taxes defined, but are not in invoice lines !'))
-                base = compute_taxes[key]['base']
-                if abs(base - tax.base) > inv.company_id.currency_id.rounding:
-                    raise osv.except_osv(_('Warning !'), _('Tax base different !\nClick on compute to update tax base'))
-            for key in compute_taxes:
-                if not key in tax_key:
-                    raise osv.except_osv(_('Warning !'), _('Taxes missing !'))    
 account_invoice()
 
 
 
-
 class account_invoice_tax(osv.osv):
     _inherit = 'account.invoice.tax'
     _columns = {
         'amount_ret': fields.float('Withholding amount', digits_compute= dp.get_precision('Withhold'), help="Withholding vat amount"),
-        'base_ret': fields.float('Amount', digits_compute= dp.get_precision('Withhold'), help="Amount without tax"),    
-        'tax_id': fields.many2one('account.tax', 'Tax', required=True, ondelete='set null', help="Tax"),        
+        'base_ret': fields.float('Amount', digits_compute= dp.get_precision('Withhold'), help="Amount without tax"),
     }
-    
-    def compute(self, cr, uid, invoice_id, context=None):
-        tax_grouped = {}
-        tax_obj = self.pool.get('account.tax')
-        cur_obj = self.pool.get('res.currency')
-        inv = self.pool.get('account.invoice').browse(cr, uid, invoice_id, context=context)
-        cur = inv.currency_id
-        company_currency = inv.company_id.currency_id.id
-
-        for line in inv.invoice_line:
-            for tax in tax_obj.compute_all(cr, uid, line.invoice_line_tax_id, (line.price_unit* (1-(line.discount or 0.0)/100.0)), line.quantity, inv.address_invoice_id.id, line.product_id, inv.partner_id)['taxes']:
-                val={}
-                val['invoice_id'] = inv.id
-                val['name'] = tax['name']
-                val['amount'] = tax['amount']
-                val['manual'] = False
-                val['sequence'] = tax['sequence']
-                val['base'] = tax['price_unit'] * line['quantity']
-                ####  add tax id  ####
-                val['tax_id'] = tax['id']                
-
-                if inv.type in ('out_invoice','in_invoice'):
-                    val['base_code_id'] = tax['base_code_id']
-                    val['tax_code_id'] = tax['tax_code_id']
-                    val['base_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['base'] * tax['base_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
-                    val['tax_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['amount'] * tax['tax_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
-                    val['account_id'] = tax['account_collected_id'] or line.account_id.id
-                else:
-                    val['base_code_id'] = tax['ref_base_code_id']
-                    val['tax_code_id'] = tax['ref_tax_code_id']
-                    val['base_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['base'] * tax['ref_base_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
-                    val['tax_amount'] = cur_obj.compute(cr, uid, inv.currency_id.id, company_currency, val['amount'] * tax['ref_tax_sign'], context={'date': inv.date_invoice or time.strftime('%Y-%m-%d')}, round=False)
-                    val['account_id'] = tax['account_paid_id'] or line.account_id.id
-
-#                key = (val['tax_code_id'], val['base_code_id'], val['account_id'])
-                #### group by tax id  ####
-                key = (val['tax_id'])                
-                if not key in tax_grouped:
-                    tax_grouped[key] = val
-                else:
-                    tax_grouped[key]['amount'] += val['amount']
-                    tax_grouped[key]['base'] += val['base']
-                    tax_grouped[key]['base_amount'] += val['base_amount']
-                    tax_grouped[key]['tax_amount'] += val['tax_amount']
-
-        for t in tax_grouped.values():
-            t['base'] = cur_obj.round(cr, uid, cur, t['base'])
-            t['amount'] = cur_obj.round(cr, uid, cur, t['amount'])
-            t['base_amount'] = cur_obj.round(cr, uid, cur, t['base_amount'])
-            t['tax_amount'] = cur_obj.round(cr, uid, cur, t['tax_amount'])
-        return tax_grouped
 
 
     def compute_amount_ret(self, cr, uid, invoice_id, context={}):

=== modified file 'l10n_ve_withholding_iva/partner_view.xml'
--- l10n_ve_withholding_iva/partner_view.xml	2011-05-11 16:46:27 +0000
+++ l10n_ve_withholding_iva/partner_view.xml	2011-09-22 17:22:23 +0000
@@ -18,7 +18,7 @@
             <field name="arch" type="xml">
                 <page string="Withholdings" position="inside">
                     <notebook>
-                        <page string="Withholdings Vat">                
+                        <page string="Withholdings Vat">
                             <group col="4" colspan="2">
                                 <field name="wh_iva_agent"/>
                                 <field name="wh_iva_rate"/>
@@ -26,7 +26,7 @@
                                 <field name="property_wh_iva_receivable"/>
                             </group>
                         </page>
-                    </notebook>                        
+                    </notebook>
                 </page>
             </field>
         </record>

=== modified file 'l10n_ve_withholding_iva/wh_iva.py'
--- l10n_ve_withholding_iva/wh_iva.py	2011-05-19 20:32:34 +0000
+++ l10n_ve_withholding_iva/wh_iva.py	2011-09-22 17:22:23 +0000
@@ -67,18 +67,18 @@
     _name = "account.wh.iva"
     _description = "Withholding Vat"
     _columns = {
-        'name': fields.char('Description', size=64, select=True,readonly=True, states={'draft':[('readonly',False)]}, required=True, help="Description of withholding"),
+        'name': fields.char('Description', size=64, readonly=True, states={'draft':[('readonly',False)]}, required=True, help="Description of withholding"),
         'code': fields.char('Code', size=32, readonly=True, states={'draft':[('readonly',False)]}, help="Withholding reference"),
         'number': fields.char('Number', size=32, readonly=True, states={'draft':[('readonly',False)]}, help="Withholding number"),
         'type': fields.selection([
             ('out_invoice','Customer Invoice'),
             ('in_invoice','Supplier Invoice'),
-            ],'Type', readonly=True, select=True, help="Withholding type"),
+            ],'Type', readonly=True, help="Withholding type"),
         'state': fields.selection([
             ('draft','Draft'),
             ('done','Done'),
             ('cancel','Cancelled')
-            ],'State', select=True, readonly=True, help="Withholding State"),
+            ],'State', readonly=True, help="Withholding State"),
         'date_ret': fields.date('Withholding date', readonly=True, states={'draft':[('readonly',False)]}, help="Keep empty to use the current date"),
         'date': fields.date('Date', readonly=True, states={'draft':[('readonly',False)]}, help="Date"),
         'period_id': fields.many2one('account.period', 'Force Period', domain=[('state','<>','done')], readonly=True, states={'draft':[('readonly',False)]}, help="Keep empty to use the period of the validation(Withholding date) date."),
@@ -88,7 +88,7 @@
         'journal_id': fields.many2one('account.journal', 'Journal', required=True,readonly=True, states={'draft':[('readonly',False)]}, help="Journal entry"),
         'company_id': fields.many2one('res.company', 'Company', required=True, help="Company"),
         'retention_line': fields.one2many('account.wh.iva.line', 'retention_id', 'Withholding vat lines', readonly=True, states={'draft':[('readonly',False)]}, help="Withholding vat lines"),
-        'tot_amount_base_wh': fields.float('Amount', required=False, digits_compute= dp.get_precision('Withhold'), help="Amount without tax"),        
+        'tot_amount_base_wh': fields.float('Amount', required=False, digits_compute= dp.get_precision('Withhold'), help="Amount without tax"),
         'tot_amount_tax_wh': fields.float('Amount wh. tax vat', required=False, digits_compute= dp.get_precision('Withhold'), help="Amount withholding tax vat"),
         'amount_base_ret': fields.function(_amount_ret_all, method=True, digits_compute= dp.get_precision('Withhold'), string='Compute amount', multi='all', help="Compute amount without tax"),
         'total_tax_ret': fields.function(_amount_ret_all, method=True, digits_compute= dp.get_precision('Withhold'), string='Compute amount wh. tax vat', multi='all', help="compute amount withholding tax vat"),
@@ -175,7 +175,7 @@
                     period_id = period_ids[0]
 
             if ret.retention_line:
-                for line in ret.retention_line:                    
+                for line in ret.retention_line:
                     writeoff_account_id = False
                     writeoff_journal_id = False
                     amount = line.amount_tax_wh
@@ -224,7 +224,7 @@
                     inv_str+= '%s'% '\n'+line.invoice_id.name
 
             if inv_str:
-                raise osv.except_osv('Factura(s) No Perteneciente(s) !',"La(s) siguientes factura(s) no pertenecen al partner del comprobante: %s " % (inv_str,))
+                raise osv.except_osv('Incorrect Invoices !',"The following invoices are not the selected partner: %s " % (inv_str,))
 
         return True
 
@@ -245,7 +245,7 @@
                     inv_str+= '%s'% '\n'+inv.name        
 
             if inv_str:
-                raise osv.except_osv('Factura(s) No Perteneciente(s) !',"La(s) siguientes factura(s) no pertenecen al partner del comprobante: %s " % (inv_str,))
+                raise osv.except_osv('Incorrect Invoices !',"The following invoices are not the selected partner: %s " % (inv_str,))
 
         return True
 
@@ -331,8 +331,8 @@
     _description = "Withholding vat line"
     _columns = {
         'name': fields.char('Description', size=64, required=True, help="Withholding line Description"),
-        'retention_id': fields.many2one('account.wh.iva', 'Withholding vat', ondelete='cascade', select=True, help="Withholding vat"),
-        'invoice_id': fields.many2one('account.invoice', 'Invoice', required=True, ondelete='set null', select=True, help="Withholding invoice"),
+        'retention_id': fields.many2one('account.wh.iva', 'Withholding vat', ondelete='cascade', help="Withholding vat"),
+        'invoice_id': fields.many2one('account.invoice', 'Invoice', required=True, ondelete='set null', help="Withholding invoice"),
         'tax_line': fields.function(_compute_tax_lines, method=True, relation='account.invoice.tax', type="one2many", string='Taxes', help="Invoice taxes"),
         'amount_tax_ret': fields.function(_amount_all, method=True, digits=(16,4), string='Wh. tax amount', multi='all', help="Withholding tax amount"),
         'base_ret': fields.function(_amount_all, method=True, digits=(16,4), string='Wh. amount', multi='all', help="Withholding without tax amount"),

=== modified file 'l10n_ve_withholding_iva/wh_iva_view.xml'
--- l10n_ve_withholding_iva/wh_iva_view.xml	2011-08-21 22:33:37 +0000
+++ l10n_ve_withholding_iva/wh_iva_view.xml	2011-09-22 17:22:23 +0000
@@ -18,9 +18,9 @@
                     <field name="invoice_id" on_change="invoice_id_change(invoice_id)" domain="[('state', '=', 'open'), ('wh_iva', '=', False), ('partner_id','=',parent.partner_id)]"/>
 <!--                    <field name="retention_rate" />-->
                     <field name="base_ret"/>
-                    <field name="amount_tax_ret"/>                    
+                    <field name="amount_tax_ret"/>
                     <field name="amount_base_wh"/>
-                    <field name="amount_tax_wh"/>                    
+                    <field name="amount_tax_wh"/>
                     <field name="move_id"/>
                 </tree>
             </field>
@@ -55,7 +55,7 @@
                                 <field name="amount_tax_ret"/>
                                 <field name="base_ret"/>
                                 <field name="amount_base_wh"/>
-                                <field name="amount_tax_wh"/>                                
+                                <field name="amount_tax_wh"/>
                             </group>
                         </page>
                     </notebook>
@@ -64,11 +64,11 @@
         </record>
 
 
-    <!-- 
+    <!--
     =====================================================
     Withholding vat
     =====================================================
-    -->  
+    -->
 
 
         <record id="view_wh_iva_filter" model="ir.ui.view">
@@ -99,8 +99,8 @@
                </search>
             </field>
         </record>
-        
-        
+
+
         <record id="view_wh_iva_tree" model="ir.ui.view">
             <field name="name">account.wh.iva.tree</field>
             <field name="model">account.wh.iva</field>
@@ -132,27 +132,27 @@
                 <form string="Withholding Vat">
                     <group colspan="4" col="6">
                         <field name="journal_id" select="2" domain="[('type','=','iva_purchase')]"/>
-                        <field name="type" select="2"/>
-                        <field name="code" select="1"/>
-                        <field name="partner_id" on_change="onchange_partner_id(type,partner_id)" select="1" domain="[('supplier','=',True)]"/>
-                        <field name="currency_id" />
-                        <field name="date_ret" />
+                        <field name="type"/>
+                        <field name="code"/>
+                        <field name="partner_id" on_change="onchange_partner_id(type,partner_id)" domain="[('supplier','=',True)]"/>
+                        <field name="currency_id"/>
+                        <field name="date_ret"/>
                         <field domain="[('type','&lt;&gt;','view'), ('company_id', '=', company_id)]" name="account_id"/>
-                        <field name="name" select="2"/>
+                        <field name="name"/>
                         <field name="period_id"/>
-                        <field name="number" select="1" attrs="{'readonly':[('type','=','in_invoice')],'required':[('type','in',['out_invoice','out_refund'])]}"/>
+                        <field name="number" attrs="{'readonly':[('type','=','in_invoice')],'required':[('type','in',['out_invoice','out_refund'])]}"/>
                         <field name="date" />
                     </group>
                     <notebook colspan="4">
                         <page string="Withholding">
                             <field colspan="4" name="retention_line" nolabel="1" widget="one2many_list"/>
                             <group col="4" colspan="2">
-                                <field name="state" select="2"/>
-                                <button name="wh_iva_done" states="draft" string="Realizar" icon="gtk-execute"/>
+                                <field name="state"/>
+                                <button name="wh_iva_done" states="draft" string="Done" icon="gtk-execute"/>
                             </group>
                             <group col="2" colspan="2">
-                                <button colspan="2" name="compute_amount_wh" states="draft" string="Compute Withholding Vat" type="object" icon="terp-stock_format-scientific"/>                                
-                                <field name="amount_base_ret"/>                                
+                                <button colspan="2" name="compute_amount_wh" states="draft" string="Compute Withholding Vat" type="object" icon="terp-stock_format-scientific"/>
+                                <field name="amount_base_ret"/>
                                 <field name="total_tax_ret"/>
                                 <field name="tot_amount_base_wh"/>
                                 <field name="tot_amount_tax_wh"/>
@@ -219,7 +219,7 @@
             <field name="domain">[('type','=','out_invoice')]</field>
             <field name="context">{'type':'out_invoice'}</field>
             <field name="search_view_id" ref="view_wh_iva_filter"/>
-            <field name="help">With Customer Withholding Vat you can create and manage document withholding issued to your customers. OpenERP can also generate document withholding automatically from invoices. For retention must add the invoices, process them and then validate the document.</field>            
+            <field name="help">With Customer Withholding Vat you can create and manage document withholding issued to your customers. OpenERP can also generate document withholding automatically from invoices. For retention must add the invoices, process them and then validate the document.</field>
         </record>
         <record model="ir.actions.act_window.view" id="act_wv_account_wh_iva_customer_tree">
             <field name="sequence" eval="10"/>
@@ -236,7 +236,7 @@
 
         <menuitem
             id="menu_action_account_wh_iva_customer"
-            name="Withholding vat customer"       
+            name="Withholding vat customer"
             parent="l10n_ve_withholding.menu_wh_customer"
             action="action_account_wh_iva_customer"/>
 

=== added directory 'l10n_ve_withholding_muni'
=== added file 'l10n_ve_withholding_muni/__init__.py'
--- l10n_ve_withholding_muni/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/__init__.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,37 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+
+import wh_muni
+import invoice
+import partner
+import report
+#import wizard
+

=== added file 'l10n_ve_withholding_muni/__openerp__.py'
--- l10n_ve_withholding_muni/__openerp__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/__openerp__.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,51 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution    
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
+#    This module was developen by Vauxoo Team:
+#    Coded by: [e-mail]
+#
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero 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 Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+{
+    "name" : "Local Withholding Venezuelan laws",
+    "version" : "0.5",
+    "author" : "Vauxoo",
+    "website" : "http://vauxoo.com",
+    "category": 'Generic Modules/Accounting',
+    "description": """Management  local withholding for Venezuelan tax laws
+    """,
+    'init_xml': [],
+    "depends" : ["l10n_ve_withholding"],
+    'update_xml': [
+        'security/wh_muni_security.xml',
+        'security/ir.model.access.csv',
+        'account_invoice_view.xml',
+        'partner_view.xml',
+        'wh_muni_view.xml',
+        "wh_muni_sequence.xml",
+        "wh_muni_report.xml",
+#        "account_workflow.xml",
+    ],
+    'demo_xml': [],
+    'test': [],
+    'installable': True,
+    'active': False,
+}
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'l10n_ve_withholding_muni/__terp__.py'
--- l10n_ve_withholding_muni/__terp__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/__terp__.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,59 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+{
+	"name" : "Retenciones Municipales",
+	"version" : "0.1",
+	"author" : "Netquatro",
+	"category" : "Generic Modules",
+	"website": "http://wiki.openerp.org.ve/",
+	"description": '''
+Administración de las retenciones aplicadas a tributos municipales.
+''',
+	"depends" : ["base","account","retencion_iva"],
+	"init_xml" : [],
+	"demo_xml" : [
+
+    ], 
+	"update_xml" : [
+            "security/ir.model.access.csv",
+#            "retention_workflow.xml",
+            "retencion_munici_view.xml",
+            "retencion_munici_sequence.xml",
+            "account_invoice_view.xml",
+#            "account_view.xml", 
+            "partner_view.xml",
+#            "stock_view.xml", 
+            "retencion_munici_report.xml",
+            "retencion_munici_wizard.xml",
+    ],
+	"active": False,
+	"installable": True
+}

=== added file 'l10n_ve_withholding_muni/account_invoice_view.xml'
--- l10n_ve_withholding_muni/account_invoice_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/account_invoice_view.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,65 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+
+
+    <!--
+    =====================================================
+    Invoices Extension
+    =====================================================
+    -->
+
+        <record id="account_invoice_wh_muni_customer" model="ir.ui.view">
+            <field name="name">account.invoice.wh.local.customer</field>
+            <field name="model">account.invoice</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="l10n_ve_withholding.wh_inv_customer"/>
+            <field name="arch" type="xml">
+                <page string="Withholdings" position="inside">
+                    <notebook>
+                        <page string="Withholdings Local">
+                            <group col="6" colspan="4">
+                                <field name="wh_local"/>
+                            </group>
+                        </page>
+                    </notebook>
+                </page>
+            </field>
+        </record>
+
+
+        <record id="account_invoice_wh_muni_supplier" model="ir.ui.view">
+            <field name="name">account.invoice.wh.local.supplier</field>
+            <field name="model">account.invoice</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="l10n_ve_withholding.wh_inv_supplier"/>
+            <field name="arch" type="xml">
+                <page string="Withholdings" position="inside">
+                    <notebook>
+                        <page string="Withholdings Vat">
+                            <group col="6" colspan="4">
+                                <field name="wh_local"/>
+                            </group>
+                        </page>
+                    </notebook>
+                </page>
+            </field>
+        </record>
+
+
+        <record id="account_invoice_wh_muni_tree" model="ir.ui.view">
+            <field name="name">account.invoice.wh.local.tree</field>
+            <field name="model">account.invoice</field>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="account.invoice_tree"/>
+            <field name="arch" type="xml">
+                <xpath expr="/tree/field[@name='origin']" position="after">
+                    <field name="wh_local"/>
+                </xpath>
+            </field>
+        </record>
+
+
+    </data>
+</openerp>

=== added file 'l10n_ve_withholding_muni/invoice.py'
--- l10n_ve_withholding_muni/invoice.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/invoice.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,93 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Latinux Inc (http://www.latinux.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import time
+from osv import fields, osv
+
+
+
+class account_invoice(osv.osv):
+    _inherit = 'account.invoice'
+
+
+    def _retenida_munici(self, cr, uid, ids, name, args, context):
+        res = {}
+        for id in ids:
+            res[id] = self.test_retenida(cr, uid, [id], 'retmun')
+        return res
+
+
+    def _get_inv_munici_from_line(self, cr, uid, ids, context={}):
+        move = {}
+        for line in self.pool.get('account.move.line').browse(cr, uid, ids):
+            if line.reconcile_partial_id:
+                for line2 in line.reconcile_partial_id.line_partial_ids:
+                    move[line2.move_id.id] = True
+            if line.reconcile_id:
+                for line2 in line.reconcile_id.line_id:
+                    move[line2.move_id.id] = True
+        invoice_ids = []
+        if move:
+            invoice_ids = self.pool.get('account.invoice').search(cr, uid, [('move_id','in',move.keys())], context=context)
+        return invoice_ids
+
+    def _get_inv_munici_from_reconcile(self, cr, uid, ids, context={}):
+        move = {}
+        for r in self.pool.get('account.move.reconcile').browse(cr, uid, ids):
+            for line in r.line_partial_ids:
+                move[line.move_id.id] = True
+            for line in r.line_id:
+                move[line.move_id.id] = True
+        
+        invoice_ids = []
+        if move:
+            invoice_ids = self.pool.get('account.invoice').search(cr, uid, [('move_id','in',move.keys())], context=context)
+        return invoice_ids
+
+
+    _columns = {
+        'wh_local': fields.function(_retenida_munici, method=True, string='Local Withholding', type='boolean',
+            store={
+                'account.invoice': (lambda self, cr, uid, ids, c={}: ids, None, 50),
+                'account.move.line': (_get_inv_munici_from_line, None, 50),
+                'account.move.reconcile': (_get_inv_munici_from_reconcile, None, 50),
+            }, help="The account moves of the invoice have been withheld with account moves of the payment(s)."),
+
+    }
+    
+
+
+
+
+account_invoice()
+
+
+
+

=== added file 'l10n_ve_withholding_muni/partner.py'
--- l10n_ve_withholding_muni/partner.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/partner.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,59 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Latinux Inc (http://www.latinux.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from osv import fields, osv
+
+
+class res_partner(osv.osv):
+    _inherit = 'res.partner'
+    _columns = {
+        'property_wh_munici_payable': fields.property(
+            'account.account',
+            type='many2one',
+            relation='account.account',
+            string="Purchase local withholding account",
+            method=True,
+            view_load=True,
+            domain="[('type', '=', 'other')]",
+            help="This account will be used debit local withholding amount"),
+        'property_wh_munici_receivable': fields.property(
+            'account.account',
+            type='many2one',
+            relation='account.account',
+            string="Sale local withholding account",
+            method=True,
+            view_load=True,
+            domain="[('type', '=', 'other')]",
+            help="This account will be used credit local withholding amount"),
+
+   }
+
+
+res_partner()

=== added file 'l10n_ve_withholding_muni/partner_view.xml'
--- l10n_ve_withholding_muni/partner_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/partner_view.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+
+
+    <!--
+    =====================================================
+    Partners Extension
+    =====================================================
+    -->
+
+        <record id="partner_ext_munici_view_form_loc_ve" model="ir.ui.view">
+            <field name="name">partner_extended_munici.partner.form.view.loc_ve</field>
+            <field name="model">res.partner</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="l10n_ve_withholding.wh_partner"/>
+            <field name="arch" type="xml">
+                <page string="Withholdings" position="inside">
+                    <notebook>
+                        <page string="Local Withholdings">
+                            <group col="4" colspan="2">
+                                    <field name="property_wh_munici_payable"/>
+                                    <field name="property_wh_munici_receivable"/>
+                            </group>
+                        </page>
+                    </notebook>
+                </page>
+            </field>
+        </record>
+
+    </data>
+</openerp>

=== added directory 'l10n_ve_withholding_muni/report'
=== added file 'l10n_ve_withholding_muni/report/__init__.py'
--- l10n_ve_withholding_muni/report/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/report/__init__.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,32 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import wh_muni_report
+

=== added directory 'l10n_ve_withholding_muni/report/tiny_sxw2rml'
=== added file 'l10n_ve_withholding_muni/report/tiny_sxw2rml/__init__.py'
--- l10n_ve_withholding_muni/report/tiny_sxw2rml/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/report/tiny_sxw2rml/__init__.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,29 @@
+##############################################################################
+#
+# Copyright (c) 2004 TINY SPRL. (http://tiny.be) All Rights Reserved.
+#                    Fabien Pinckaers <[e-mail]>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from tiny_sxw2rml import sxw2rml

=== added file 'l10n_ve_withholding_muni/report/tiny_sxw2rml/normalized_oo2rml.xsl'
--- l10n_ve_withholding_muni/report/tiny_sxw2rml/normalized_oo2rml.xsl	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/report/tiny_sxw2rml/normalized_oo2rml.xsl	2011-09-22 17:22:23 +0000
@@ -0,0 +1,681 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xsl:stylesheet
+  version="1.0"
+  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
+  xmlns:fo="http://www.w3.org/1999/XSL/Format"
+  xmlns:office="http://openoffice.org/2000/office"
+  xmlns:style="http://openoffice.org/2000/style"
+  xmlns:text="http://openoffice.org/2000/text"
+  xmlns:table="http://openoffice.org/2000/table"
+  xmlns:draw="http://openoffice.org/2000/drawing"
+  xmlns:xlink="http://www.w3.org/1999/xlink"
+  xmlns:number="http://openoffice.org/2000/datastyle"
+  xmlns:svg="http://www.w3.org/2000/svg"
+  xmlns:chart="http://openoffice.org/2000/chart"
+  xmlns:dr3d="http://openoffice.org/2000/dr3d"
+  xmlns:math="http://www.w3.org/1998/Math/MathML"
+  xmlns:form="http://openoffice.org/2000/form"
+  xmlns:script="http://openoffice.org/2000/script"
+  office:class="text" office:version="1.0"
+  exclude-result-prefixes = "xsl fo office style text table draw xlink number svg chart dr3d math form script">
+
+  <!--TODO's: indent, picture cache (trml2pdf) -->
+
+<xsl:output method="xml" indent="yes" />
+<xsl:strip-space elements="*"/>
+
+<xsl:key name="text_style" match="style:style[@style:family='text']" use="@style:name" />
+<xsl:key name="page_break_before" match="style:style[@style:family='paragraph' and ./style:properties/@fo:break-before='page']" use="@style:name" />
+<xsl:key name="page_break_after" match="style:style[@style:family='paragraph' and ./style:properties/@fo:break-after='page']" use="@style:name" />
+<xsl:key name="table_column_style" match="style:style[@style:family='table-column']" use="@style:name" />
+<xsl:key name="table_cell_style" match="style:style[@style:family='table-cell']" use="@style:name" />
+<xsl:key name="paragraph_style" match="style:style[@style:family='paragraph']" use="@style:name" />
+
+<xsl:template match="office:document-content">
+  <document filename="test.pdf">
+    <xsl:apply-templates select="office:automatic-styles" />
+    <xsl:apply-templates select="office:body" />
+  </document>
+</xsl:template>
+
+<xsl:template name="page_size">
+  <xsl:attribute name="pageSize">
+    <xsl:text>(</xsl:text>
+    <xsl:value-of select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
+    <xsl:text>,</xsl:text>
+    <xsl:value-of select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height" />
+    <xsl:text>)</xsl:text>
+  </xsl:attribute>
+</xsl:template>
+
+<xsl:template name="fixed_frame">
+	<xsl:for-each select="//draw:text-box">
+		<frame>
+			<xsl:attribute name="id"><xsl:value-of select="./@draw:name" /></xsl:attribute>
+			<xsl:attribute name="x1"><xsl:value-of select="./@svg:x" /></xsl:attribute>
+			<xsl:attribute name="y1">
+				<xsl:value-of
+					select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height - ./@svg:y - ./@fo:min-height" />
+			</xsl:attribute>
+			<xsl:attribute name="width">
+				<xsl:value-of select="./@svg:width" />
+			</xsl:attribute>
+			<xsl:attribute name="height">
+				<xsl:value-of select="./@fo:min-height" />
+			</xsl:attribute>
+		</frame>
+	</xsl:for-each>
+</xsl:template>
+
+<xsl:template name="margin_sizes">
+  <xsl:variable name="margin_left" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-left" />
+  <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-right" />
+  <xsl:variable name="margin_top" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-top" />
+  <xsl:variable name="margin_bottom" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-bottom" />
+  <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
+  <xsl:variable name="page_height" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height" />
+  <xsl:attribute name="x1"><xsl:value-of select="$margin_left" /></xsl:attribute>
+  <xsl:attribute name="y1"><xsl:value-of select="$margin_bottom" /></xsl:attribute>
+  <xsl:attribute name="width"><xsl:value-of select="$page_width - $margin_left - $margin_right"/></xsl:attribute>
+  <xsl:attribute name="height"><xsl:value-of select="$page_height - $margin_bottom - $margin_top"/></xsl:attribute>
+</xsl:template>
+
+<xsl:template name="text_width">
+  <!-- You need this for the workaround to make primitive outlines-->
+  <xsl:variable name="margin_left" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-left" />
+  <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-right" />
+  <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
+  <xsl:value-of select="$page_width - $margin_left - $margin_right - 18"/>
+</xsl:template>
+
+
+
+<xsl:template match="office:automatic-styles">
+  <!--<template pageSize="(21cm, 29.7cm)" leftMargin="1.0cm" rightMargin="2.0cm" topMargin="1.0cm" bottomMargin="1.0cm" title="Test" author="Martin Simon" allowSplitting="20">-->
+  <template pageSize="(21cm, 29.7cm)" title="Test" author="Martin Simon" allowSplitting="20">
+    <xsl:call-template name="page_size" />
+    <pageTemplate id="first">
+	  <xsl:call-template name="fixed_frame" />
+      <frame id="first" x1="2cm" y1="2cm" width="17cm" height="26cm">
+        <xsl:call-template name="margin_sizes" />
+      </frame>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <!--A table style to simulate primitive outlines -till the <addOutline> tag is implemented in trml2pdf -->
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <!--use two standard table grid styles like PyOpenOffice "Old Way": with and without a grid-->
+    <!--TODO insert table cell colors here, not within the <td> tag - otherwise
+         it will not work with flowables as cell content-->
+    <xsl:call-template name="make_blocktablestyle" />
+    <initialize>
+      <paraStyle name="all" alignment="justify" />
+    </initialize>
+    <xsl:apply-templates select="style:style" />
+  </stylesheet>
+</xsl:template>
+
+<xsl:template name="make_blocktablestyle">
+  <xsl:for-each select="//table:table">
+    <xsl:variable name="test">
+      <xsl:value-of select="./@table:name" />
+    </xsl:variable>
+    <xsl:if test="not(boolean(count(preceding-sibling::table:table[@table:name=$test])))">
+      <!--Test if this is the first table with this style, nested tables not counted-->
+      <blockTableStyle id="{@table:name}">
+	    <xsl:if test=".//draw:image">
+	      <blockTopPadding value="0"/>
+	      <blockBottomPadding value="0"/>
+	    </xsl:if>
+        <blockAlignment value="LEFT" />
+        <blockValign value="TOP" />
+        <xsl:call-template name="make_linestyle" />
+        <xsl:call-template name="make_tablebackground" />
+      </blockTableStyle>
+    </xsl:if>
+  </xsl:for-each>
+</xsl:template>
+
+<xsl:template name="make_linestyle">
+	<xsl:for-each select=".//table:table-row">
+		<xsl:variable name="row" select="position() - 1"/>
+		<xsl:for-each select=".//table:table-cell">
+			<xsl:variable name="col" select="position() - 1"/>
+			<xsl:variable name="linebefore">
+				<xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-left"/>
+			</xsl:variable>
+			<xsl:if test="not($linebefore='') and not($linebefore='none')">
+				<xsl:variable name="colorname">
+					<xsl:value-of select="substring-after($linebefore,'#')"/>
+				</xsl:variable>
+				<lineStyle kind="LINEBEFORE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
+			</xsl:if>
+			<xsl:variable name="lineafter">
+				<xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-right"/>
+			</xsl:variable>
+			<xsl:if test="not($lineafter='') and not($lineafter='none')">
+				<xsl:variable name="colorname">
+					<xsl:value-of select="substring-after($lineafter,'#')"/>
+				</xsl:variable>
+				<lineStyle kind="LINEAFTER" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
+			</xsl:if>
+			<xsl:variable name="lineabove">
+				<xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-top"/>
+			</xsl:variable>
+			<xsl:if test="not($lineabove='') and not($lineabove='none')">
+				<xsl:variable name="colorname">
+					<xsl:value-of select="substring-after($lineabove,'#')"/>
+				</xsl:variable>
+				<lineStyle kind="LINEABOVE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},{$row}"/>
+			</xsl:if>
+			<xsl:variable name="linebelow">
+				<xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-bottom"/>
+			</xsl:variable>
+			<xsl:if test="not($linebelow='') and not($linebelow='none')">
+				<xsl:variable name="colorname">
+					<xsl:value-of select="substring-after($linebelow,'#')"/>
+				</xsl:variable>
+				<lineStyle kind="LINEBELOW" colorName="#{$colorname}" start="{$col},{-1}" stop="{$col},{-1}"/>
+			</xsl:if>
+			<xsl:variable name="grid">
+				<xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border"/>
+			</xsl:variable>
+			<xsl:if test="not($grid='') and not($grid='none')">
+				<xsl:variable name="colorname">
+					<xsl:value-of select="substring-after($grid,'#')"/>
+				</xsl:variable>
+				<!-- Don't use grid because we don't need a line between each rows -->
+				<lineStyle kind="LINEBEFORE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
+				<lineStyle kind="LINEAFTER" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
+				<lineStyle kind="LINEABOVE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},{$row}"/>
+				<lineStyle kind="LINEBELOW" colorName="#{$colorname}" start="{$col},{-1}" stop="{$col},{-1}"/>
+			</xsl:if>
+		</xsl:for-each>
+	</xsl:for-each>
+</xsl:template>
+
+<!-- Was needed to simulate bulleted lists:
+<xsl:template match="text:ordered-list|text:unordered-list">
+  <xsl:variable name = "text_width">
+    <xsl:call-template name="text_width" />
+  </xsl:variable>
+  <blockTable style="Standard_Outline" colWidths="18,{$text_width}">
+  <xsl:apply-templates match="text:list-item" />
+</blockTable>
+</xsl:template>
+
+<xsl:template match="text:list-item">
+  <tr>
+    <td><para><font face="Helvetica-Bold" size="10">*</font></para></td>
+    <td>
+      <xsl:apply-templates />
+    </td>
+  </tr>
+</xsl:template>
+
+-->
+
+
+<xsl:template match="office:body">
+  <story>
+    <xsl:apply-templates />
+	<xsl:for-each select="//draw:text-box">
+		<currentFrame>
+			<xsl:attribute name="name">
+				<xsl:value-of select="./@draw:name" />
+			</xsl:attribute>
+		</currentFrame>
+		<xsl:apply-templates>
+			<xsl:with-param name="skip_draw" select="0" />
+		</xsl:apply-templates>
+		<frameEnd />
+	</xsl:for-each>
+  </story>
+</xsl:template>
+
+<xsl:template match="table:table">
+  <blockTable>
+    <xsl:attribute name="colWidths">
+      <xsl:call-template name="make_columns" />
+    </xsl:attribute>
+    <xsl:call-template name="make_tableheaders" />
+    <xsl:attribute name="style">
+      <xsl:value-of select="@table:name" />
+    </xsl:attribute>
+    <xsl:apply-templates />
+  </blockTable>
+</xsl:template>
+
+<xsl:template name="make_tableheaders">
+  <xsl:if test="boolean(count(table:table-header-rows))">
+    <xsl:attribute name="repeatRows">1</xsl:attribute>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_tablebackground">
+  <xsl:for-each select=".//table:table-row">
+    <!--Be careful when there are table:table-header-rows as
+         parent node of table:table-row -->
+    <xsl:variable name="row" select="position() - 1" />
+    <xsl:for-each select="./table:table-cell">
+      <xsl:variable name="col" select="position() - 1" />
+      <xsl:variable name="background">
+        <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:background-color" />
+      </xsl:variable>
+      <xsl:if test="not($background='') and boolean(key('table_cell_style',@table:style-name)/style:properties/@fo:background-color) and starts-with($background,'#')">
+        <!--only RGB hexcolors are accepted -->
+		<blockBackground colorName="{$background}" start="{$col},{$row}" stop="{$col},-1" />
+      </xsl:if>
+     </xsl:for-each>
+   </xsl:for-each>
+</xsl:template>
+
+<xsl:template name="make_columns">
+  <xsl:variable name="columns" >
+    <xsl:for-each select="table:table-column">
+      <xsl:value-of select="key('table_column_style',@table:style-name)/style:properties/@style:column-width" />
+      <xsl:text>,</xsl:text>
+    </xsl:for-each>
+  </xsl:variable>
+  <xsl:value-of select="substring($columns,1,string-length($columns) - 1)" />
+  <!--strip the last comma-->
+</xsl:template>
+
+<xsl:template match="table:table-row">
+  <tr>
+    <xsl:apply-templates />
+  </tr>
+</xsl:template>
+
+<xsl:template match="table:table-cell">
+  <td>
+    <xsl:apply-templates />
+  </td>
+</xsl:template>
+
+<xsl:template match="text:section">
+  <section>
+    <xsl:apply-templates />
+  </section>
+</xsl:template>
+
+
+<xsl:template match="text:span">
+  <font>
+    <xsl:call-template name="make_fontnames_span" />
+    <xsl:call-template name="make_fontsize_span" />
+    <xsl:apply-templates />
+  </font>
+</xsl:template>
+
+<xsl:template name="make_fontsize_span">
+  <xsl:variable name ="fontsize">
+    <xsl:value-of select="key('text_style',@text:style-name)/style:properties/@fo:font-size" />
+  </xsl:variable>
+  <xsl:if test="not($fontsize='') and boolean(key('text_style',@text:style-name)/style:properties/@fo:font-size)" >
+    <xsl:attribute name="size">
+      <xsl:value-of select="$fontsize" />
+    </xsl:attribute>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_fontnames_span">
+  <xsl:attribute name="face">
+    <xsl:call-template name="make_fontnames">
+      <xsl:with-param name="fontName" select="key('text_style',@text:style-name)/style:properties/@style:font-name"  />
+      <xsl:with-param name="fontWeight" select="key('text_style',@text:style-name)/style:properties/@fo:font-weight"  />
+      <xsl:with-param name="fontStyle" select="key('text_style',@text:style-name)/style:properties/@fo:font-style" />
+    </xsl:call-template>
+  </xsl:attribute>
+</xsl:template>
+
+<xsl:template name="make_image">
+  <illustration height="{.//draw:image/@svg:height}" width="{.//draw:image/@svg:width}">
+    <image x="0" y="0" file="{substring-after(.//draw:image/@xlink:href,'#Pictures/')}" height="{.//draw:image/@svg:height}" width="{.//draw:image/@svg:width}" />
+  </illustration>
+</xsl:template>
+
+<xsl:template name="empty_paragraph">
+  <xsl:if test="not(boolean(count(descendant::node())))">
+    <xsl:call-template name="distance_point">
+      <xsl:with-param name="background" select="key('paragraph_style',@text:style-name)/style:properties/@fo:background-color" />
+    </xsl:call-template>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="distance_point">
+  <xsl:param name="background" />
+  <xsl:param name="tab_stop"></xsl:param>
+  <xsl:variable name="local_back">
+    <xsl:choose>
+      <xsl:when test="not(boolean($background)) or not(contains($background,'#'))">
+        <!-- Do not accept OO colors like "transparent", only hex-colors -->
+        <xsl:text>white</xsl:text>
+      </xsl:when>
+      <xsl:otherwise>
+        <xsl:value-of select="$background" />
+      </xsl:otherwise>
+    </xsl:choose>
+  </xsl:variable>
+  <font color="{$local_back}">
+    <xsl:text> </xsl:text>
+    <xsl:if test="boolean($tab_stop)">
+      <!-- simulate a tabstop with white/background-color points -->
+      <xsl:text>.........</xsl:text>
+    </xsl:if>
+  </font>
+</xsl:template>
+
+<xsl:template match="text:ordered-list">
+  <xsl:apply-templates />
+  <para><seqreset id="ordered_list" /></para>
+  <!-- Reset the counter. seqreset is not a trml2pdf tag, but a Platypus Intra Paragraph Markup,
+       so it needs a dummy paragraph to enclose it -->
+</xsl:template>
+
+<xsl:template name="make_listitem">
+  <xsl:if test="(name(..)='text:list-item')">
+    <xsl:attribute name="leftIndent">15</xsl:attribute>
+    <xsl:attribute name="bulletIndent">0</xsl:attribute>
+    <xsl:choose>
+      <xsl:when test="(name(../..)='text:unordered-list')">
+        <xsl:variable name="fontsize">
+          <xsl:value-of select="number(key('paragraph_style',@text:style-name)/style:properties/@fo:font-size)" />
+        </xsl:variable>
+        <xsl:choose>
+          <xsl:when test="$fontsize='NaN'">
+            <!-- you should exclude non-numerical values for bulletFontSize. <== Sometimes the preprocessing went wrong.-->
+            <!--use a default bullet font size-->
+            <xsl:attribute name="bulletFontSize">6</xsl:attribute>
+          </xsl:when>
+          <xsl:otherwise>
+            <xsl:attribute name="bulletFontSize"><xsl:value-of select="floor(($fontsize div 2) + 1)" /></xsl:attribute>
+          </xsl:otherwise>
+        </xsl:choose>
+        <xsl:attribute name="bulletFontName">ZapfDingbats</xsl:attribute>
+        <xsl:attribute name="bulletText">l</xsl:attribute>        
+      </xsl:when>
+      <xsl:otherwise>
+        <!-- Generate the numbers for an ordered list -->
+        <xsl:variable name="size">
+          <xsl:value-of select="key('paragraph_style',@text:style-name)/style:properties/@fo:font-size" />
+        </xsl:variable>
+        <!-- For ordered lists we use the bullet tag from Platypus Intra Paragraph Markup -->
+        <bullet>
+          <xsl:if test="not($size='') and boolean(key('paragraph_style',@text:style-name)/style:properties/@fo:font-size)">
+            <xsl:attribute name="size">
+              <!-- adapt the fontsize to the fontsize of the current paragraph -->
+              <xsl:value-of select="$size" />
+            </xsl:attribute>
+          </xsl:if>
+          <seq id="ordered_list" />.</bullet>
+      </xsl:otherwise>
+    </xsl:choose>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template match="text:drop-down">
+    <xsl:value-of select="text:label[2]/@text:value" />
+</xsl:template>
+
+
+<xsl:template match="text:p|text:h">
+	<xsl:param name="skip_draw" select="1" />
+  <xsl:if test="boolean(key('page_break_before',@text:style-name))" >
+    <pageBreak />
+  </xsl:if>
+  <xsl:choose>
+    <xsl:when test="boolean(.//draw:image)">
+      <xsl:call-template name="make_image" />
+    </xsl:when>
+	<xsl:when test="boolean(name(..) = 'draw:text-box') and boolean($skip_draw)">
+	</xsl:when>
+    <xsl:otherwise>
+      <para>
+        <xsl:attribute name="style">
+          <xsl:value-of select="@text:style-name" />
+        </xsl:attribute>
+        <xsl:call-template name="make_listitem" />
+        <xsl:apply-templates />
+        <xsl:call-template name="empty_paragraph" />
+      </para>
+    </xsl:otherwise>
+  </xsl:choose>
+  <xsl:if test="boolean(key('page_break_after',@text:style-name))" >
+    <pageBreak />
+  </xsl:if>
+</xsl:template>
+
+<xsl:template match="text:p/text:tab-stop">
+  <!-- simulate a tabstop -->
+  <xsl:call-template name="distance_point">
+    <xsl:with-param name="background" select="key('paragraph_style',@text:style-name)/style:properties/@fo:background-color" />
+    <xsl:with-param name="tab_stop">yes</xsl:with-param>
+  </xsl:call-template>
+</xsl:template>
+
+<!-- experimental - switched off
+<xsl:template match="text:h">
+  <para>
+    <xsl:attribute name="style">
+      <xsl:value-of select="@text:style-name" />
+    </xsl:attribute>
+    <xsl:call-template name="make_number" />
+    <xsl:apply-templates />
+    <xsl:call-template name="empty_paragraph" />
+  </para>
+</xsl:template>
+
+<xsl:template name="make_number">
+  <xsl:choose>
+    <xsl:when test="@text:level='1'">
+      <xsl:number format="1. " />
+    </xsl:when>
+    <xsl:when test="@text:level='2'">
+      <xsl:number count="text:h[@text:level='1']|text:h[text:level='2']" level="any" format="1.1." />
+    </xsl:when>
+  </xsl:choose>
+</xsl:template>
+
+-->
+            
+<xsl:template match="style:style[@style:family='paragraph']">
+  <paraStyle>
+    <xsl:attribute name="name">
+      <xsl:value-of select="@style:name" />
+    </xsl:attribute>
+    <xsl:call-template name="make_indent_paragraph" />
+    <xsl:call-template name="make_fontnames_paragraph" />
+    <xsl:call-template name="make_fontsize" />
+    <!--<xsl:call-template name="make_parent" /> not necessary -
+         parent styles processed by PyOpenOffice -->
+    <xsl:call-template name="make_alignment" />
+    <xsl:call-template name="make_background" />
+    <xsl:call-template name="make_space_beforeafter" />
+  </paraStyle>
+</xsl:template>
+
+<xsl:template name="make_indent_paragraph">
+  <xsl:variable name="right_indent"><xsl:value-of select="style:properties/@fo:margin-right" /></xsl:variable>
+  <xsl:variable name="left_indent"><xsl:value-of select="style:properties/@fo:margin-left" /></xsl:variable>
+  <xsl:if test="not($right_indent='') and boolean(style:properties/@fo:margin-right)">
+    <xsl:attribute name="rightIndent">
+      <xsl:value-of select="$right_indent" />
+    </xsl:attribute>      
+  </xsl:if>
+  <xsl:if test="not($left_indent='') and boolean(style:properties/@fo:margin-left)">
+    <xsl:attribute name="leftIndent">
+      <xsl:value-of select="$left_indent" />
+    </xsl:attribute>      
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_background">
+  <xsl:variable name="background">
+    <xsl:value-of select="style:properties/@fo:background-color" />
+  </xsl:variable>
+  <xsl:if test="not($background='') and boolean(style:properties/@fo:background-color) and starts-with($background,'#')" >
+    <xsl:attribute name="backColor">
+      <xsl:value-of select="$background" />
+    </xsl:attribute>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_space_beforeafter">
+  <xsl:variable name="before">
+    <xsl:value-of select="style:properties/@fo:margin-top" />
+  </xsl:variable>
+  <xsl:variable name="after">
+    <xsl:value-of select="style:properties/@fo:margin-bottom" />
+  </xsl:variable>
+  <xsl:if test="not($before='') and boolean(style:properties/@fo:margin-top)" >
+    <xsl:attribute name="spaceBefore">
+      <xsl:value-of select="$before" />
+    </xsl:attribute>
+  </xsl:if>
+  <xsl:if test="not($after='') and boolean(style:properties/@fo:margin-bottom)" >
+    <xsl:attribute name="spaceAfter">
+      <xsl:value-of select="$after" />
+    </xsl:attribute>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_fontsize">
+  <xsl:variable name="fontSize">       
+    <xsl:value-of select="style:properties/@fo:font-size" />
+  </xsl:variable>
+  <xsl:if test="not($fontSize='') and boolean(style:properties/@fo:font-size)">
+    <xsl:attribute name="fontSize">
+      <xsl:value-of select="$fontSize" />
+    </xsl:attribute>
+    <xsl:attribute name="leading">
+      <xsl:value-of select="$fontSize + floor($fontSize div 5) + 1" />
+      <!--use a standard leading related to the font size -->
+    </xsl:attribute>
+  </xsl:if>
+</xsl:template>
+
+<!--this template is not needed anymore for "normalized" sxw files -->
+<xsl:template name="make_parent">
+  <xsl:variable name="parent">       
+    <xsl:value-of select="@style:parent-style-name" />
+  </xsl:variable>
+  <xsl:if test="not($parent='') and boolean(@style:parent-style-name)">    
+    <xsl:attribute name="parent">
+      <xsl:value-of select="$parent" />
+    </xsl:attribute>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_alignment">
+  <xsl:variable name="alignment">
+    <xsl:value-of select="style:properties/@fo:text-align" />
+  </xsl:variable>
+  <xsl:if test="not($alignment='') and boolean(style:properties/@fo:text-align)">
+    <xsl:choose>
+      <xsl:when test="$alignment='start'">
+        <xsl:attribute name="alignment">LEFT</xsl:attribute>
+      </xsl:when>
+      <xsl:when test="$alignment='center'">
+        <xsl:attribute name="alignment">CENTER</xsl:attribute>
+      </xsl:when>
+      <xsl:when test="$alignment='end'">
+        <xsl:attribute name="alignment">RIGHT</xsl:attribute>
+      </xsl:when>
+      <xsl:when test="$alignment='justify'">
+        <xsl:attribute name="alignment">JUSTIFY</xsl:attribute>
+      </xsl:when>
+    </xsl:choose>
+  </xsl:if>
+</xsl:template>
+
+<xsl:template name="make_fontnames_paragraph">
+  <xsl:attribute name="fontName">
+    <xsl:call-template name="make_fontnames">
+      <xsl:with-param name="fontName" select="style:properties/@style:font-name" />
+      <xsl:with-param name="fontWeight" select="style:properties/@fo:font-weight" />
+      <xsl:with-param name="fontStyle" select="style:properties/@fo:font-style" />
+    </xsl:call-template>
+  </xsl:attribute>
+</xsl:template>
+
+<xsl:template name="make_fontnames">
+  <!--much too verbose, needs improvement-->
+<xsl:param name="fontName" />
+<xsl:param name="fontWeight" />
+<xsl:param name="fontStyle" />
+<xsl:choose>
+<xsl:when test="not($fontName='') and boolean($fontName)">
+  <xsl:choose>
+    <xsl:when test="contains($fontName,'Courier')">
+      <xsl:choose>
+        <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
+          <xsl:text>Courier-BoldOblique</xsl:text>
+        </xsl:when>
+        <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
+          <xsl:text>Courier-Bold</xsl:text>
+        </xsl:when>
+        <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
+          <xsl:text>Courier-Oblique</xsl:text>
+        </xsl:when>
+        <xsl:otherwise>
+          <xsl:text>Courier</xsl:text>
+        </xsl:otherwise>
+      </xsl:choose>
+    </xsl:when>
+    <xsl:when test="contains($fontName,'Helvetica') or contains($fontName,'Arial') or contains($fontName,'Sans')">
+      <xsl:choose>
+        <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
+          <xsl:text>Helvetica-BoldOblique</xsl:text>
+        </xsl:when>
+        <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
+          <xsl:text>Helvetica-Bold</xsl:text>
+        </xsl:when>
+        <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
+          <xsl:text>Helvetica-Oblique</xsl:text>
+        </xsl:when>
+        <xsl:otherwise>
+          <xsl:text>Helvetica</xsl:text>
+        </xsl:otherwise>        
+      </xsl:choose>
+    </xsl:when>
+    <xsl:otherwise>
+      <xsl:choose>
+        <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
+          <xsl:text>Times-BoldItalic</xsl:text>
+        </xsl:when>
+        <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
+          <xsl:text>Times-Bold</xsl:text>
+        </xsl:when>
+        <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
+          <xsl:text>Times-Italic</xsl:text>
+        </xsl:when>
+        <xsl:otherwise>
+          <xsl:text>Times-Roman</xsl:text>
+        </xsl:otherwise>        
+      </xsl:choose>
+    </xsl:otherwise>
+  </xsl:choose>
+</xsl:when>
+<xsl:otherwise>
+  <!--Use this as default -->
+  <xsl:text>Times-Roman</xsl:text>   
+</xsl:otherwise>
+</xsl:choose>
+</xsl:template>
+
+<!--
+This stylesheet is part of:
+PyOpenOffice Version 0.4
+Copyright (C) 2005: Martin Simon
+Homepage: www.bezirksreiter.de
+
+GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999
+-->
+
+</xsl:stylesheet>
+
+

=== added file 'l10n_ve_withholding_muni/report/tiny_sxw2rml/office.dtd'
=== added file 'l10n_ve_withholding_muni/report/tiny_sxw2rml/tiny_sxw2rml.py'
--- l10n_ve_withholding_muni/report/tiny_sxw2rml/tiny_sxw2rml.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/report/tiny_sxw2rml/tiny_sxw2rml.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,365 @@
+#!/usr/bin/python
+#coding: utf-8
+
+##############################################################################
+#
+# Copyright (c):
+#
+#     2005 pyopenoffice.py Martin Simon (http://www.bezirksreiter.de)
+#     2005 Fabien Pinckaers, TINY SPRL. (http://tiny.be)
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contact a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+"""
+Tiny SXW2RML - The Tiny ERP's report engine
+
+Tiny SXW2RMLis part of the Tiny report project.
+Tiny Report is a module that allows you to render high quality PDF document
+from an OpenOffice template (.sxw) and any relationnal database.
+
+The whole source code is distributed under the terms of the
+GNU Public Licence.
+
+(c) 2005 pyopenoffice.py Martin Simon (http://www.bezirksreiter.de)
+(c) 2005-TODAY, Fabien Pinckaers - Tiny sprl
+"""
+__version__ = '0.9'
+
+
+import re
+import string
+import os
+import zipfile
+import xml.dom.minidom
+from reportlab.lib.units import toLength
+import base64
+
+class DomApiGeneral:
+	"""General DOM API utilities."""
+	def __init__(self,content_string="",file=""):
+		self.content_string = content_string
+		self.re_digits = re.compile(r"(.*?\d)(pt|cm|mm|inch|in)")
+
+	def _unitTuple(self,string):
+		"""Split values and units to a tuple."""
+		temp = self.re_digits.findall(string)
+		if not temp:
+			return (string,"")
+		else:
+			return (temp[0])
+
+	def stringPercentToFloat(self,string):
+		temp = string.replace("""%""","")
+		return float(temp)/100
+
+	def findChildrenByName(self,parent,name,attr_dict={}):
+		"""Helper functions. Does not work recursively.
+		Optional: also test for certain attribute/value pairs."""
+		children = []
+		for c in parent.childNodes:
+			if c.nodeType == c.ELEMENT_NODE and c.nodeName == name:
+				children.append(c)
+		if attr_dict == {}:
+			return children
+		else:
+			return self._selectForAttributes(nodelist=children,attr_dict=attr_dict)
+
+	def _selectForAttributes(self,nodelist,attr_dict):
+		"Helper function."""
+		selected_nodes = []
+		for n in nodelist:
+			check = 1
+			for a in attr_dict.keys():
+				if n.getAttribute(a) != attr_dict[a]:
+					# at least one incorrect attribute value?
+					check = 0
+			if check:
+				selected_nodes.append(n)
+		return selected_nodes
+
+	def _stringToTuple(self,s):
+		"""Helper function."""
+		try:
+			temp = string.split(s,",")
+			return int(temp[0]),int(temp[1])
+		except:
+			return None
+
+	def _tupleToString(self,t):
+		try:
+			return self.openOfficeStringUtf8("%s,%s" % (t[0],t[1]))
+		except:
+			return None
+
+	def _lengthToFloat(self,value):
+		v = value
+		if not self.re_digits.search(v):
+			return v
+		try:
+			if v[-4:] == "inch":
+				# OO files use "inch" instead of "in" in Reportlab units
+				v = v[:-2]
+		except:
+			pass
+		try:
+			c = round(toLength(v))
+			return c
+		except:
+			return v
+
+	def openOfficeStringUtf8(self,string):
+		if type(string) == unicode:
+			return string.encode("utf-8")
+		tempstring = unicode(string,"cp1252").encode("utf-8")
+		return tempstring
+
+class DomApi(DomApiGeneral):
+	"""This class provides a DOM-API for XML-Files from an SXW-Archive."""
+	def __init__(self,xml_content,xml_styles):
+		DomApiGeneral.__init__(self)
+		self.content_dom = xml.dom.minidom.parseString(xml_content)
+		self.styles_dom = xml.dom.minidom.parseString(xml_styles)
+		body = self.content_dom.getElementsByTagName("office:body")
+		self.body = body and body[0]
+
+		# TODO:
+		self.style_dict = {}
+		self.style_properties_dict = {}
+
+		# ******** always use the following order:
+		self.buildStyleDict()
+		self.buildStylePropertiesDict()
+		if self.styles_dom.getElementsByTagName("style:page-master").__len__()<>0:
+			self.page_master = self.styles_dom.getElementsByTagName("style:page-master")[0]
+		self.document = self.content_dom.getElementsByTagName("office:document-content")[0]
+
+	def buildStylePropertiesDict(self):
+		for s in self.style_dict.keys():
+			self.style_properties_dict[s] = self.getStylePropertiesDict(s)
+
+	def updateWithPercents(self,dict,updatedict):
+		"""Sometimes you find values like "115%" in the style hierarchy."""
+		if not updatedict:
+			# no style hierarchies for this style? =>
+			return
+		new_updatedict = copy.copy(updatedict)
+		for u in new_updatedict.keys():
+			try:
+				if new_updatedict[u].find("""%""") != -1 and dict.has_key(u):
+					number = float(self.re_digits.search(dict[u]).group(1))
+					unit = self.re_digits.search(dict[u]).group(2)
+					new_number = self.stringPercentToFloat(new_updatedict[u]) * number
+					if unit == "pt":
+						new_number = int(new_number)
+						# no floats allowed for "pt"
+						# OOo just takes the int, does not round (try it out!)
+					new_updatedict[u] = "%s%s" % (new_number,unit)
+				else:
+					dict[u] = new_updatedict[u]
+			except:
+				dict[u] = new_updatedict[u]
+		dict.update(new_updatedict)
+
+	def normalizeStyleProperties(self):
+		"""Transfer all style:style-properties attributes from the
+		self.style_properties_hierarchical dict to the automatic-styles
+		from content.xml. Use this function to preprocess content.xml for
+		XSLT transformations etc.Do not try to implement this function
+		with XSlT - believe me, it's a terrible task..."""
+		styles_styles = self.styles_dom.getElementsByTagName("style:style")
+		automatic_styles = self.content_dom.getElementsByTagName("office:automatic-styles")[0]
+		for s in styles_styles:
+			automatic_styles.appendChild(s.cloneNode(deep=1))
+		content_styles = self.content_dom.getElementsByTagName("style:style")
+		# these are the content_styles with styles_styles added!!!
+		for s in content_styles:
+			c = self.findChildrenByName(s,"style:properties")
+			if c == []:
+				# some derived automatic styles do not have "style:properties":
+				temp = self.content_dom.createElement("style:properties")
+				s.appendChild(temp)
+				c = self.findChildrenByName(s,"style:properties")
+			c = c[0]
+			dict = self.style_properties_dict[(s.getAttribute("style:name")).encode("latin-1")] or {}
+			for attribute in dict.keys():
+				c.setAttribute(self.openOfficeStringUtf8(attribute),self.openOfficeStringUtf8(dict[attribute]))
+
+	def transferStylesXml(self):
+		"""Transfer certain sub-trees from styles.xml to the normalized content.xml
+		(see above). It is not necessary to do this - for example - with paragraph styles.
+		the "normalized" style properties contain all information needed for
+		further processing."""
+		# TODO: What about table styles etc.?
+		outline_styles = self.styles_dom.getElementsByTagName("text:outline-style")
+		t = self.content_dom.createElement("transferredfromstylesxml")
+		self.document.insertBefore(t,self.body)
+		t_new = self.body.previousSibling
+		try:
+			page_master = self.page_master
+			t_new.appendChild(page_master.cloneNode(deep=1))
+			t_new.appendChild(outline_styles[0].cloneNode(deep=1))
+		except:
+			pass
+
+	def normalizeLength(self):
+		"""Normalize all lengthes to floats (i.e: 1 inch = 72).
+		Always use this after "normalizeContent" and "transferStyles"!"""
+		# TODO: The complex attributes of table cell styles are not transferred yet.
+		#all_styles = self.content_dom.getElementsByTagName("style:properties")
+		#all_styles += self.content_dom.getElementsByTagName("draw:image")
+		all_styles = self.content_dom.getElementsByTagName("*")
+		for s in all_styles:
+			for x in s._attrs.keys():
+				v = s.getAttribute(x)
+				s.setAttribute(x,"%s" % self._lengthToFloat(v))
+				# convert float to string first!
+
+	def normalizeTableColumns(self):
+		"""Handle this strange table:number-columns-repeated attribute."""
+		columns = self.content_dom.getElementsByTagName("table:table-column")
+		for c in columns:
+			if c.hasAttribute("table:number-columns-repeated"):
+				number = int(c.getAttribute("table:number-columns-repeated"))
+				c.removeAttribute("table:number-columns-repeated")
+				for i in range(number-1):
+					(c.parentNode).insertBefore(c.cloneNode(deep=1),c)
+
+	def buildStyleDict(self):
+		"""Store all style:style-nodes from content.xml and styles.xml in self.style_dict.
+		Caution: in this dict the nodes from two dom apis are merged!"""
+		for st in (self.styles_dom,self.content_dom):
+			for s in st.getElementsByTagName("style:style"):
+				name = s.getAttribute("style:name").encode("latin-1")
+				self.style_dict[name] = s
+		return True
+
+	def toxml(self):
+		return self.content_dom.toxml(encoding="utf-8")
+
+	def getStylePropertiesDict(self,style_name):
+		res = {}
+
+		if self.style_dict[style_name].hasAttribute("style:parent-style-name"):
+			parent = self.style_dict[style_name].getAttribute("style:parent-style-name").encode("latin-1")
+			res = self.getStylePropertiesDict(parent)
+
+		childs = self.style_dict[style_name].childNodes
+		for c in childs:
+			if c.nodeType == c.ELEMENT_NODE and c.nodeName == "style:properties":
+				for attr in c._attrs.keys():
+					res[attr] = c.getAttribute(attr).encode("latin-1")
+		return res
+
+class PyOpenOffice(object):
+	"""This is the main class which provides all functionality."""
+	def __init__(self, path='.', save_pict=False):
+		self.path = path
+		self.save_pict = save_pict
+		self.images = {}
+
+	def oo_read(self,fname):
+		z = zipfile.ZipFile(fname,"r")
+		content = z.read('content.xml')
+		style = z.read('styles.xml')
+		all = z.namelist()
+		for a in all:
+			if a[:9]=='Pictures/' and len(a)>10:
+				pic_content = z.read(a)
+				self.images[a[9:]] = pic_content
+				if self.save_pict:
+					f=open(os.path.join(self.path, os.path.basename(a)),"wb")
+					f.write(pic_content)
+					f.close()
+		z.close()
+		return content,style
+
+	def oo_replace(self,content):
+		regex = [
+			(r"<para[^>]*/>", ""),
+			#(r"<text:ordered-list.*?>(.*?)</text:ordered-list>", "$1"),
+			#(r"<text:unordered-list.*?>(.*?)</text:unordered-list>", "$1"),
+			(r"<para(.*)>(.*?)<text:line-break[^>]*/>", "<para$1>$2</para><para$1>"),
+		]
+		for key,val in regex:
+			content = re.sub(key, val, content)
+		return content
+
+	def unpackNormalize(self,sourcefile):
+		c,s = self.oo_read(sourcefile)
+		c = self.oo_replace(c)
+		dom = DomApi(c,s)
+		dom.normalizeStyleProperties()
+		dom.transferStylesXml()
+		dom.normalizeLength()
+		dom.normalizeTableColumns()
+		new_c = dom.toxml()
+		return new_c
+
+def sxw2rml(sxw_file, xsl, output='.', save_pict=False):
+	import libxslt
+	import libxml2
+	tool = PyOpenOffice(output, save_pict = save_pict)
+	res = tool.unpackNormalize(sxw_file)
+	styledoc = libxml2.parseDoc(xsl)
+	style = libxslt.parseStylesheetDoc(styledoc)
+	doc = libxml2.parseMemory(res,len(res))
+	result = style.applyStylesheet(doc, None)
+
+	root = result.xpathEval("/document/stylesheet")
+	if root:
+		root=root[0]
+		images = libxml2.newNode("images")
+		for img in tool.images:
+			node = libxml2.newNode('image')
+			node.setProp('name', img)
+			node.setContent( base64.encodestring(tool.images[img]))
+			images.addChild(node)
+		root.addNextSibling(images)
+	try:
+		xml = style.saveResultToString(result)
+		return xml
+	except:
+		return result
+
+if __name__ == "__main__":
+	import optparse
+	parser = optparse.OptionParser(
+		version="Tiny Report v%s" % __version__,
+		usage = 'tiny_sxw2rml.py [options] file.sxw')
+	parser.add_option("-v", "--verbose", default=False, dest="verbose", help="enable basic debugging")
+	parser.add_option("-o", "--output", dest="output", default='.', help="directory of image output")
+	(opt, args) = parser.parse_args()
+	if len(args) != 1:
+		parser.error("incorrect number of arguments")
+
+	import sys
+	import StringIO
+
+	fname = sys.argv[1]
+	f = StringIO.StringIO(file(fname).read())
+
+	xsl = file(os.path.join(os.getcwd(), os.path.dirname(sys.argv[0]), 'normalized_oo2rml.xsl')).read()
+	result = sxw2rml(f, xsl, output=opt.output, save_pict=False)
+
+	print result

=== added file 'l10n_ve_withholding_muni/report/wh_muni_report.py'
--- l10n_ve_withholding_muni/report/wh_muni_report.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/report/wh_muni_report.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,71 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import time
+from report import report_sxw
+from osv import osv
+import pooler
+
+class rep_wh_muni(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(rep_wh_muni, self).__init__(cr, uid, name, context)
+        self.localcontext.update({
+            'time': time,
+            'get_partner_addr': self._get_partner_addr,
+            'get_rif': self._get_rif
+        })
+
+    def _get_partner_addr(self, idp=None):
+        if not idp:
+            return []
+
+        addr_obj = self.pool.get('res.partner.address')
+        addr_inv = 'NO HAY DIRECCION FISCAL DEFINIDA'
+        addr_ids = addr_obj.search(self.cr,self.uid,[('partner_id','=',idp), ('type','=','invoice')])
+        if addr_ids:                
+            addr = addr_obj.browse(self.cr,self.uid, addr_ids[0])
+            addr_inv = (addr.street or '')+' '+(addr.street2 or '')+' '+(addr.zip or '')+ ' '+(addr.city or '')+ ' '+ (addr.country_id and addr.country_id.name or '')+ ', TELF.:'+(addr.phone or '')
+        return addr_inv 
+
+
+    def _get_rif(self, vat=''):
+        if not vat:
+            return []
+        return vat[2:].replace(' ', '')
+
+    
+      
+report_sxw.report_sxw(
+    'report.wh.muni_rep',
+    'account.wh.munici',
+    'addons/l10n_ve_withholding_muni/report/wh_muni_report.rml',
+    parser=rep_wh_muni,
+    header=False
+)      

=== added file 'l10n_ve_withholding_muni/report/wh_muni_report.rml'
--- l10n_ve_withholding_muni/report/wh_muni_report.rml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/report/wh_muni_report.rml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,261 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+  <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
+    <pageTemplate id="first">
+      <frame id="first" x1="42.0" y1="42.0" width="528" height="708"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla5">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla6">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="1,1" stop="1,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,2" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="1,2" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla3">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla8">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla2">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="P1" fontName="Helvetica"/>
+    <paraStyle name="P2" fontName="Helvetica-Bold"/>
+    <paraStyle name="P3" fontName="Helvetica" fontSize="2.0" leading="3"/>
+    <paraStyle name="P4" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
+    <paraStyle name="P5" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT"/>
+    <paraStyle name="P6" fontName="Helvetica-Bold" fontSize="16.0" leading="20" alignment="CENTER"/>
+    <paraStyle name="P7" fontName="Helvetica"/>
+    <paraStyle name="P8" fontName="Helvetica-Bold" fontSize="11.0" leading="14"/>
+    <paraStyle name="P9" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P10" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P11" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT"/>
+    <paraStyle name="P13" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
+    <paraStyle name="P14" fontName="Helvetica" fontSize="12.0" leading="15" alignment="RIGHT"/>
+    <paraStyle name="P15" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT"/>
+    <paraStyle name="P16" fontName="Helvetica" fontSize="2.0" leading="3" alignment="CENTER"/>
+    <paraStyle name="P17" fontName="Helvetica" fontSize="11.0" leading="14" alignment="RIGHT"/>
+    <paraStyle name="P18" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
+    <paraStyle name="P19" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="RIGHT"/>
+    <paraStyle name="P20" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
+    <paraStyle name="P21" fontName="Helvetica" fontSize="10.0" leading="13" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P22" fontName="Helvetica" fontSize="11.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P23" fontName="Helvetica-Bold" fontSize="11.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P24" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="11.0" leading="14" alignment="LEFT"/>
+    <paraStyle name="Standard" fontName="Times-Roman"/>
+    <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="Index" fontName="Times-Roman"/>
+    <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="Table Contents" fontName="Times-Roman" fontSize="8.0" leading="10"/>
+    <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="Table Heading" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="CENTER"/>
+    <paraStyle name="Table" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
+  </stylesheet>
+  <images/>
+  <story>
+    <para style="P9">[[repeatIn(objects,'o')]]</para>
+    <para style="P6">COMPROBANTE RETENCION IMPUESTOS MUNICIPALES</para>
+    <blockTable colWidths="321.0,206.0" style="Tabla1">
+      <tr>
+        <td>
+          <para style="P12"><font face="Times-Roman" size="14.0">[[ company.partner_id.name ]]</font>[[ get_rif(company.partner_id.vat) or '' ]]</para>
+          <para style="P4">[[ get_partner_addr( company.partner_id.id ) ]]</para>
+        </td>
+        <td>
+          <para style="P23">NRO. COMPROBANTE: [[ o.number]]</para>
+          <para style="P22">Fecha: <font face="Times-Roman">[[ time.strftime('%d/%m/%Y', time.strptime(o.date_ret, '%Y-%m-%d')) ]]</font></para>
+          <para style="P22">PERIODO FISCAL:<font face="Times-Roman"/></para>
+          <blockTable colWidths="100.0,100.0" style="Tabla5">
+            <tr>
+              <td>
+                <para style="P23">AÑO</para>
+              </td>
+              <td>
+                <para style="P23">MES </para>
+              </td>
+            </tr>
+            <tr>
+              <td>
+                <para style="P23">[[ o.period_id.fiscalyear_id.name]] </para>
+              </td>
+              <td>
+                <para style="P23">[[ o.period_id.name]] </para>
+              </td>
+            </tr>
+          </blockTable>
+          <para style="P23">
+            <font color="white"> </font>
+          </para>
+        </td>
+      </tr>
+    </blockTable>
+    <para style="P7">SUJETO RETENIDO:</para>
+    <blockTable colWidths="80.0,447.0" style="Tabla6">
+      <tr>
+        <td>
+          <para style="P1">
+            <font face="Times-Roman" size="11.0">Razón Social</font>
+            <font face="Times-Roman"/>
+            <font face="Times-Roman"/>
+          </para>
+        </td>
+        <td>
+          <para style="P2">[[ o.partner_id.name ]]</para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P8">Dirección Fiscal</para>
+        </td>
+        <td>
+          <para style="P2">[[ get_partner_addr( o.partner_id.id ) ]]</para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P1">
+            <font face="Times-Roman" size="11.0">Nro. R.I.F.</font>
+          </para>
+        </td>
+        <td>
+          <para style="P2">[[ get_rif(o.partner_id.vat) or '' ]]</para>
+        </td>
+      </tr>
+    </blockTable>
+    <para style="P3">
+      <font color="white"> </font>
+    </para>
+    <section>
+      <para style="P10">[[repeatIn(o.munici_line_ids,'l')]]</para>
+      <para style="P11">Retención por concepto de impuestos municipales:</para>
+      <blockTable colWidths="527.0" style="Tabla3">
+        <tr>
+          <td>
+            <para style="P20">COMPROBANTE DE RETENCION DE IMPUESTOS MUNICIPALES DE FACTURA: <font face="Helvetica" size="9.0">[[ l.invoice_id.reference ]]</font></para>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="P11">
+        <font color="white"> </font>
+      </para>
+      <blockTable colWidths="100.0,93.0,334.0" style="Tabla8">
+        <tr>
+          <td>
+            <para style="P20">Base imponible</para>
+          </td>
+          <td>
+            <para style="P15">[[ l.invoice_id.amount_untaxed ]]</para>
+          </td>
+        </tr>
+        <tr>
+          <td>
+            <para style="P20">Exento</para>
+          </td>
+          <td>
+            <para style="P18">
+              <font color="white"> </font>
+            </para>
+          </td>
+        </tr>
+        <tr>
+          <td>
+            <para style="P20">Retención</para>
+          </td>
+          <td>
+            <para style="P15">[[ o.amount ]]</para>
+          </td>
+          <td>
+            <para style="P15"><font face="Helvetica" size="8.0">% Retención: </font>[[ l.retencion_munici ]]%</para>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="P10">
+        <font color="white"> </font>
+      </para>
+    </section>
+    <blockTable colWidths="327.0,200.0" style="Tabla2">
+      <tr>
+        <td>
+          <para style="P12">
+            <font color="white"> </font>
+          </para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P16">
+            <font color="white"> </font>
+          </para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P24">----------------------------------------------------</para>
+          <para style="P13">Por la Empresa</para>
+        </td>
+        <td>
+          <para style="P24">----------------------------------------------------</para>
+          <para style="P13">POR<font color="white"> .........</font>[[ o.partner_id.name ]]<font color="white"> .........</font></para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P21">
+            <font color="white"> </font>
+          </para>
+        </td>
+        <td>
+          <para style="P14">
+            <font color="white"> </font>
+          </para>
+        </td>
+      </tr>
+    </blockTable>
+    <para style="P17">
+      <font color="white"> </font>
+    </para>
+    <para style="P19">
+      <font color="white"> </font>
+    </para>
+  </story>
+</document>
+

=== added file 'l10n_ve_withholding_muni/report/wh_muni_report.sxw'
Binary files l10n_ve_withholding_muni/report/wh_muni_report.sxw	1970-01-01 00:00:00 +0000 and l10n_ve_withholding_muni/report/wh_muni_report.sxw	2011-09-22 17:22:23 +0000 differ
=== added file 'l10n_ve_withholding_muni/retencion_munici_wizard.xml'
--- l10n_ve_withholding_muni/retencion_munici_wizard.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/retencion_munici_wizard.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+	<data>
+
+
+		<wizard 
+			string="Reporte Seniat" 
+			model="account.retencion.munici"
+			name="account.ret.munici.xml.seniat"
+			id="wizard_ret_munici_xml_seniat" />
+
+
+
+
+	</data>
+</openerp>

=== added directory 'l10n_ve_withholding_muni/security'
=== added file 'l10n_ve_withholding_muni/security/ir.model.access.csv'
--- l10n_ve_withholding_muni/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/security/ir.model.access.csv	2011-09-22 17:22:23 +0000
@@ -0,0 +1,5 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_account_wh_muni_user","account.wh.muni.user","model_account_wh_munici","l10n_ve_withholding_muni.group_account_wh_muni_user",1,0,0,0
+"access_account_wh_muni_line_user","account.wh.muni.line.user","model_account_wh_munici_line","l10n_ve_withholding_muni.group_account_wh_muni_user",1,0,0,0
+"access_account_wh_muni_manager","account.wh.muni.manager","model_account_wh_munici","l10n_ve_withholding_muni.group_account_wh_muni_manager",1,1,1,1
+"access_account_wh_muni_line_manager","account.wh.muni.line.manager","model_account_wh_munici_line","l10n_ve_withholding_muni.group_account_wh_muni_manager",1,1,1,1

=== added file 'l10n_ve_withholding_muni/security/wh_muni_security.xml'
--- l10n_ve_withholding_muni/security/wh_muni_security.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/security/wh_muni_security.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data noupdate="0">
+
+    <record id="group_account_wh_muni_user" model="res.groups">
+        <field name="name">Withhold Local / User</field>
+    </record>
+    <record id="group_account_wh_muni_manager" model="res.groups">
+        <field name="name">Withhold Local / Manager</field>
+    </record>
+
+</data>
+</openerp>

=== added file 'l10n_ve_withholding_muni/wh_muni.py'
--- l10n_ve_withholding_muni/wh_muni.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wh_muni.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,323 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+from osv import osv, fields
+import time
+from tools import config
+from tools.translate import _
+import decimal_precision as dp
+
+
+class account_wh_munici(osv.osv):
+
+    def _get_type(self, cr, uid, context=None):
+        if context is None:
+            context = {}
+        type = context.get('type', 'in_invoice')
+        return type
+
+    def _get_journal(self, cr, uid, context):
+        if context is None:
+            context = {}
+        type_inv = context.get('type', 'in_invoice')
+        type2journal = {'out_invoice': 'mun_sale', 'in_invoice': 'mun_purchase'}
+        journal_obj = self.pool.get('account.journal')
+        res = journal_obj.search(cr, uid, [('type', '=', type2journal.get(type_inv, 'mun_purchase'))], limit=1)
+        if res:
+            return res[0]
+        else:
+            return False
+
+    def _get_currency(self, cr, uid, context):
+        user = self.pool.get('res.users').browse(cr, uid, [uid])[0]
+        if user.company_id:
+            return user.company_id.currency_id.id
+        else:
+            return self.pool.get('res.currency').search(cr, uid, [('rate','=',1.0)])[0]
+
+    _name = "account.wh.munici"
+    _description = "Local Withholding"
+    _columns = {
+        'name': fields.char('Description', size=64, readonly=True, states={'draft':[('readonly',False)]}, required=True, help="Description of withholding"),
+        'code': fields.char('Code', size=32, readonly=True, states={'draft':[('readonly',False)]}, help="Withholding reference"),
+        'number': fields.char('Number', size=32, readonly=True, states={'draft':[('readonly',False)]}, help="Withholding number"),
+        'type': fields.selection([
+            ('out_invoice','Customer Invoice'),
+            ('in_invoice','Supplier Invoice'),
+            ],'Type', readonly=True, help="Withholding type"),
+        'state': fields.selection([
+            ('draft','Draft'),
+            ('confirmed', 'Confirmed'),
+            ('done','Done'),
+            ('cancel','Cancelled')
+            ],'Estado', readonly=True, help="Estado del Comprobante"),
+        'date_ret': fields.date('Withholding date', readonly=True, states={'draft':[('readonly',False)]}, help="Keep empty to use the current date"),
+        'date': fields.date('Date', readonly=True, states={'draft':[('readonly',False)]}, help="Date"),
+        'period_id': fields.many2one('account.period', 'Force Period', domain=[('state','<>','done')], readonly=True, states={'draft':[('readonly',False)]}, help="Keep empty to use the period of the validation(Withholding date) date."),
+        'account_id': fields.many2one('account.account', 'Account', required=True, readonly=True, states={'draft':[('readonly',False)]}, help="The pay account used for this withholding."),
+        'partner_id': fields.many2one('res.partner', 'Partner', readonly=True, required=True, states={'draft':[('readonly',False)]}, help="Withholding customer/supplier"),
+        'currency_id': fields.many2one('res.currency', 'Currency', required=True, readonly=True, states={'draft':[('readonly',False)]}, help="Currency"),
+        'journal_id': fields.many2one('account.journal', 'Journal', required=True,readonly=True, states={'draft':[('readonly',False)]}, help="Journal entry"),
+        'company_id': fields.many2one('res.company', 'Company', required=True, help="Company"),
+        'munici_line_ids': fields.one2many('account.wh.munici.line', 'retention_id', 'Local withholding lines', readonly=True, states={'draft':[('readonly',False)]}, help="Facturas a la cual se realizarán las retenciones"),
+        'amount': fields.float('Amount', required=False, digits_compute= dp.get_precision('Withhold'), help="Amount withheld"),
+        'move_id':fields.many2one('account.move', 'Account Entry'),
+
+
+    } 
+    _defaults = {
+        'type': _get_type,
+        'state': lambda *a: 'draft',
+        'journal_id': _get_journal,
+        'currency_id': _get_currency,
+        'company_id': lambda self, cr, uid, context: \
+                self.pool.get('res.users').browse(cr, uid, uid,
+                    context=context).company_id.id,
+
+    }
+
+    _sql_constraints = [
+      ('ret_num_uniq', 'unique (number)', 'number must be unique !')
+    ] 
+
+
+
+    def action_confirm(self, cr, uid, ids, context={}):
+        obj=self.pool.get('account.wh.munici').browse(cr,uid,ids)
+        total=0
+        for i in obj[0].munici_line_ids:
+            if i.amount >= i.invoice_id.check_total*0.15:
+                raise osv.except_osv(_('Invalid action !'), _("The line containing the document '%s' looks as if the amount withheld was wrong please check.!") % (i.invoice_id.reference))
+            total+=i.amount
+        self.write(cr,uid,ids,{'amount':total})
+        self.write(cr, uid, ids, {'state':'confirmed'})
+        return True
+
+
+    def action_number(self, cr, uid, ids, *args):
+        obj_ret = self.browse(cr, uid, ids)[0]
+        if obj_ret.type == 'in_invoice':
+            cr.execute('SELECT id, number ' \
+                    'FROM account_wh_munici ' \
+                    'WHERE id IN ('+','.join(map(str,ids))+')')
+
+            for (id, number) in cr.fetchall():
+                if not number:
+                    number = self.pool.get('ir.sequence').get(cr, uid, 'account.wh.muni.%s' % obj_ret.type)
+                cr.execute('UPDATE account_wh_munici SET number=%s ' \
+                        'WHERE id=%s', (number, id))
+
+
+        return True
+
+
+    def action_done(self, cr, uid, ids, context={}):
+        self.action_number(cr, uid, ids)
+        self.action_move_create(cr, uid, ids)
+        self.write(cr, uid, ids, {'state':'done'})
+        return True
+
+
+    def action_move_create(self, cr, uid, ids, *args):
+        inv_obj = self.pool.get('account.invoice')
+        context = {}
+
+        for ret in self.browse(cr, uid, ids):
+            for line in ret.munici_line_ids:
+                if line.move_id or line.invoice_id.wh_local:
+                    raise osv.except_osv(_('Invoice already withhold !'),_("You must omit the follow invoice '%s' !") % (line.invoice_id.name,))
+                    return False
+
+            acc_id = ret.account_id.id
+            if not ret.date_ret:
+                self.write(cr, uid, [ret.id], {'date_ret':time.strftime('%Y-%m-%d')})
+
+            period_id = ret.period_id and ret.period_id.id or False
+            journal_id = ret.journal_id.id
+            if not period_id:
+                period_ids = self.pool.get('account.period').search(cr,uid,[('date_start','<=',ret.date_ret or time.strftime('%Y-%m-%d')),('date_stop','>=',ret.date_ret or time.strftime('%Y-%m-%d'))])
+                if len(period_ids):
+                    period_id = period_ids[0]
+                else:
+                    raise osv.except_osv(_('Warning !'), _("No se encontro un periodo fiscal para esta fecha: '%s' por favor verificar.!") % (ret.date_ret or time.strftime('%Y-%m-%d')))
+
+            if ret.munici_line_ids:
+                for line in ret.munici_line_ids:
+                    writeoff_account_id = False
+                    writeoff_journal_id = False
+                    amount = line.amount
+                    name = 'COMP. RET. MUN ' + ret.number
+                    ret_move = inv_obj.ret_and_reconcile(cr, uid, [line.invoice_id.id],
+                            amount, acc_id, period_id, journal_id, writeoff_account_id,
+                            period_id, writeoff_journal_id, ret.date_ret, name, context)
+
+                    # make the retencion line point to that move
+                    rl = {
+                        'move_id': ret_move['move_id'],
+                    }
+                    lines = [(1, line.id, rl)]
+                    self.write(cr, uid, [ret.id], {'munici_line_ids':lines, 'period_id':period_id})
+
+        return True
+
+
+    def onchange_partner_id(self, cr, uid, ids, type, partner_id):
+        acc_id = False
+        if partner_id:
+            p = self.pool.get('res.partner').browse(cr, uid, partner_id)
+            if type in ('out_invoice', 'out_refund'):
+                acc_id = p.property_wh_munici_receivable.id
+            else:
+                acc_id = p.property_wh_munici_payable.id
+
+        self._update_check(cr, uid, ids, partner_id)
+        result = {'value': {
+            'account_id': acc_id}
+        }
+
+        return result
+
+
+    def _update_check(self, cr, uid, ids, partner_id, context={}):
+        if ids:
+            ret = self.browse(cr, uid, ids[0])
+            inv_str = ''
+            for line in ret.munici_line_ids:
+                if line.invoice_id.partner_id.id != partner_id:
+                    inv_str+= '%s'% '\n'+line.invoice_id.name
+
+            if inv_str:
+                raise osv.except_osv('Incorrect Invoices !',"The following invoices are not the selected partner: %s " % (inv_str,))
+
+        return True
+
+    def _new_check(self, cr, uid, values, context={}):
+        lst_inv = []
+
+        if 'munici_line_ids' in values and values['munici_line_ids']:
+            if 'partner_id' in values and values['partner_id']:
+                for l in values['munici_line_ids']:
+                    if 'invoice_id' in l[2] and l[2]['invoice_id']:
+                        lst_inv.append(l[2]['invoice_id'])
+
+        if lst_inv:
+            invoices = self.pool.get('account.invoice').browse(cr, uid, lst_inv)
+            inv_str = ''
+            for inv in invoices:
+                if inv.partner_id.id != values['partner_id']:
+                    inv_str+= '%s'% '\n'+inv.name
+
+            if inv_str:
+                raise osv.except_osv('Incorrect Invoices !',"The following invoices are not the selected partner: %s " % (inv_str,))
+
+        return True
+
+
+
+    def write(self, cr, uid, ids, vals, context=None, check=True, update_check=True):
+        if not context:
+            context={}
+        ret = self.browse(cr, uid, ids[0])
+        if update_check:
+            if 'partner_id' in vals and vals['partner_id']:
+                self._update_check(cr, uid, ids, vals['partner_id'], context)
+            else:
+                self._update_check(cr, uid, ids, ret.partner_id.id, context)
+
+        return super(account_wh_munici, self).write(cr, uid, ids, vals, context=context)
+
+
+    def create(self, cr, uid, vals, context=None, check=True):
+        if not context:
+            context={}
+        if check:
+            self._new_check(cr, uid, vals, context)
+
+        return super(account_wh_munici, self).create(cr, uid, vals, context)
+
+account_wh_munici()
+
+
+
+class account_wh_munici_line(osv.osv):
+
+    def default_get(self, cr, uid, fields, context={}):
+        data = super(account_wh_munici_line, self).default_get(cr, uid, fields, context)
+        self.munici_context = context
+        return data
+#TODO
+#necesito crear el campo y tener la forma de calcular el monto del impuesto
+#munici retenido en la factura
+
+
+    _name = "account.wh.munici.line"
+    _description = "Local Withholding Line"
+    _columns = {
+        'name': fields.char('Description', size=64, required=True, help="Local Withholding line Description"),
+        'retention_id': fields.many2one('account.wh.munici', 'Local withholding', ondelete='cascade', help="Local withholding"),
+        'invoice_id': fields.many2one('account.invoice', 'Invoice', required=True, ondelete='set null', help="Withholding invoice"),
+        'amount':fields.float('Amount', digits_compute= dp.get_precision('Withhold')),
+        'move_id': fields.many2one('account.move', 'Account Entry', readonly=True, help="Account Entry"),
+        'wh_loc_rate':fields.float('Rate', help="Local withholding rate"),
+        'concepto_id': fields.integer('Concept', size=3, help="Local withholding concept"),
+
+
+    }
+    _defaults = {
+        'concepto_id': lambda *a: 1,
+        
+    }
+    _sql_constraints = [
+        ('munici_fact_uniq', 'unique (invoice_id)', 'The invoice has already assigned in local withholding, you cannot assigned it twice!')
+    ] 
+
+
+    def onchange_invoice_id(self, cr, uid, ids, invoice_id, context={}):
+        lines = []
+
+        if  hasattr(self, 'munici_context') and ('lines' in self.munici_context):
+            lines = [x[2] for x in self.munici_context['lines']]
+        if not invoice_id:
+            return {'value':{'amount':0.0}}
+        else:
+            ok = True
+            res = self.pool.get('account.invoice').browse(cr, uid, invoice_id, context)
+            cr.execute('select retention_id from account_wh_munici_line where invoice_id=%s', (invoice_id,))
+            ret_ids = cr.fetchone()
+            ok = ok and bool(ret_ids)
+            if ok:
+                ret = self.pool.get('account.wh.munici').browse(cr, uid, ret_ids[0], context)
+                raise osv.except_osv('Assigned Invoice !',"The invoice has already assigned in local withholding code: '%s' !" % (ret.code,))
+            
+            total = res.amount_total
+            return {'value' : {'amount':total}} 
+
+
+account_wh_munici_line()

=== added file 'l10n_ve_withholding_muni/wh_muni_report.xml'
--- l10n_ve_withholding_muni/wh_muni_report.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wh_muni_report.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <report
+            id="report_wh_muni" 
+            model="account.wh.munici" 
+            name="wh.muni_rep" 
+            rml="l10n_ve_withholding_muni/report/wh_muni_report.rml"
+            string="Comprobante Retencion Municipal"
+            header="False"
+            auto="False" />
+
+
+    </data>
+</openerp>

=== added file 'l10n_ve_withholding_muni/wh_muni_sequence.xml'
--- l10n_ve_withholding_muni/wh_muni_sequence.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wh_muni_sequence.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data noupdate="1">
+
+        <!-- Sequences type for account.wh.munici --> 
+
+
+        <record id="seq_type_account_wh_muni_purchase" model="ir.sequence.type">
+            <field name="name">Withholding local.purchase</field>
+            <field name="code">account.wh.muni.in_invoice</field>
+        </record>
+
+        <!-- Sequences for account.wh.munici --> 
+
+
+        <record id="seq_account_retencion_munici_compras" model="ir.sequence">
+            <field name="name">Withholding local purchase</field>
+            <field name="code">account.wh.muni.in_invoice</field>
+            <field name="prefix">RET-MUNI</field>
+            <field name="padding">8</field>
+            <field name="number_increment">1</field>
+        </record>
+
+
+    </data>
+</openerp>

=== added file 'l10n_ve_withholding_muni/wh_muni_view.xml'
--- l10n_ve_withholding_muni/wh_muni_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wh_muni_view.xml	2011-09-22 17:22:23 +0000
@@ -0,0 +1,207 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+    <!--
+    =====================================================
+    Withholding Line
+    =====================================================
+    -->
+
+        <record id="view_wh_muni_line_tree" model="ir.ui.view">
+            <field name="name">account.wh.munici.line.tree</field>
+            <field name="model">account.wh.munici.line</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Local Withholding line " editable="bottom">
+                    <field name="name"/>
+                    <field name="invoice_id" on_change="onchange_invoice_id(invoice_id)" domain="[('state', '=', 'open'), ('partner_id','=',parent.partner_id), ('ret_munici', '=', False)]"/>
+                    <field name="wh_loc_rate"/>
+                    <field name="amount"/>
+                    <field name="move_id"/>
+                </tree>
+            </field>
+        </record>
+
+        <record id="view_wh_muni_line_form" model="ir.ui.view">
+            <field name="name">account.wh.munici.line.form</field>
+            <field name="model">account.wh.munici.line</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Local Withholding line ">
+                    <notebook>
+                        <page string="Linea">
+                            <field name="invoice_id" on_change="onchange_invoice_id(invoice_id)" domain="[('state', '=', 'open'), ('partner_id','=',parent.partner_id), ('ret_munici', '=', False)]"/>
+                            <field colspan="4" name="name" select="1"/>
+                            <field name="wh_loc_rate"/>
+                            <field name="amount"/>
+                            <field name="move_id"/>  
+                        </page>
+                    </notebook>
+                </form>
+            </field>
+        </record>
+
+
+    <!--
+    =====================================================
+    Local Withholding
+    =====================================================
+    -->
+
+
+        <record id="view_wh_muni_filter" model="ir.ui.view">
+            <field name="name">account.wh.munici.search</field>
+            <field name="model">account.wh.munici</field>
+            <field name="type">search</field>
+            <field name="arch" type="xml">
+                <search string="Search Withholding Local">
+                   <group col="10" colspan="4">
+                        <filter name="draft" icon="terp-gtk-media-pause" string="Draft" domain="[('state','=','draft')]" help="Draft Withholding Local"/>
+                        <filter name="confirmed" icon="terp-gtk-media-pause" string="Confirmed" domain="[('state','=','confirmed')]" help="Draft Withholding Local"/>
+                        <filter name="done" icon="terp-check" string="Done" domain="[('state','=','done')]" help="Done Withholding Local"/>
+                        <filter name="cancel" icon="terp-dialog-close" string="Cancel" domain="[('state','=','cancel')]" help="Cancel Withholding Local"/>
+                        <separator orientation="vertical"/>
+                        <field name="code"/>
+                        <field name="number"/>
+                        <field name="partner_id"/>
+                        <field name="journal_id"  widget="selection" string="Journal"/>
+                        <field name="date_ret"/>
+                    </group>
+                    <newline/>
+                    <group expand="1" string="Group By...">
+                        <filter string="Partner" icon="terp-partner" domain="[]" context="{'group_by':'partner_id'}"/>
+                        <separator orientation="vertical"/>
+                        <filter string="State" icon="terp-stock_effects-object-colorize" domain="[]"  context="{'group_by':'state'}"/>
+                        <separator orientation="vertical"/>
+                        <filter string="Accounting Date of Withhold" icon="terp-go-month" domain="[]"  context="{'group_by':'date_ret'}"/>
+                    </group>
+               </search>
+            </field>
+        </record>
+
+
+        <record id="view_wh_muni_tree" model="ir.ui.view">
+            <field name="name">account.wh.munici.tree</field>
+            <field name="model">account.wh.munici</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree colors="blue:state=='draft'" string="Local Withholding">
+                    <field name="name"/>
+                    <field name="type"/>
+                    <field name="code"/>
+                    <field name="number"/>
+                    <field name="partner_id"/>
+                    <field name="date_ret"/>
+                    <field name="currency_id"/>
+                    <field name="period_id"/>
+                    <field name="state"/>
+                    <field name="amount"/>
+
+                </tree>
+            </field>
+        </record>
+
+
+        <record id="view_wh_muni_form" model="ir.ui.view">
+            <field name="name">account.wh.munici.form</field>
+            <field name="model">account.wh.munici</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Local Withholding">
+                    <group colspan="4" col="6">
+                        <field name="journal_id" select="2" domain="[('type','=','mun_purchase')]"/>
+                        <field name="type"/>
+                        <field name="code"/>
+                        <field name="partner_id" on_change="onchange_partner_id(type,partner_id)"/>
+                        <field name="currency_id"/>
+                        <field name="date_ret"/>
+                        <field domain="[('type','&lt;&gt;','view'), ('company_id', '=', company_id)]" name="account_id"/>
+                        <field name="name"/>
+                        <field name="period_id"/>
+                        <field name="number" attrs="{'readonly':[('type','=','in_invoice')],'required':[('type','in',['out_invoice','out_refund'])]}"/>
+                        <field name="date" />
+                        <field name="amount" />
+                    </group>
+                    <notebook colspan="4">
+                        <page string="Withholding">
+                            <field name="munici_line_ids" default_get="{'lines': munici_line_ids }" colspan="4" nolabel="1" height="275"/>
+                            <group col="4" colspan="2">
+                                <field name="state"/>
+                                <button name="action_confirm" string="Confirmed" states="draft" type="object" icon="gtk-open"/>
+                                <button name="action_done" string="Done" states="confirmed" type="object"  icon="gtk-go-forward"/>
+                            </group>
+                        </page>
+                        <page string="Other Information">
+                            <field name="company_id"/>
+                        </page>
+                    </notebook>
+                </form>
+            </field>
+        </record>
+
+
+        <record model="ir.actions.act_window" id="action_account_wh_muni_customer">
+            <field name="name">Local Withholding Customer</field>
+            <field name="res_model">account.wh.munici</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+            <field name="domain">[('type','=','out_invoice')]</field>
+            <field name="context">{'type':'out_invoice'}</field>
+            <field name="search_view_id" ref="view_wh_muni_filter"/>
+            <field name="help">With Local Withholding Customer you can create and manage document withholding issued to your customers. OpenERP can also generate document withholding automatically from invoices. For retention must add the invoices, process them and then validate the document.</field>
+        </record>
+        <record model="ir.actions.act_window.view" id="act_wv_account_wh_muni_customer_tree">
+            <field name="sequence" eval="10"/>
+            <field name="view_mode">tree</field>
+            <field name="view_id" ref="view_wh_muni_tree"/> 
+            <field name="act_window_id" ref="action_account_wh_muni_customer"/>
+        </record>
+        <record model="ir.actions.act_window.view" id="act_wv_account_wh_muni_customer_form">
+            <field name="sequence" eval="20"/>
+            <field name="view_mode">form</field>
+            <field name="view_id" ref="view_wh_muni_form"/>
+            <field name="act_window_id" ref="action_account_wh_muni_customer"/>
+        </record>
+
+        <menuitem
+            id="menu_action_account_wh_muni_customer"
+            name="Local Withholding Customer"
+            parent="l10n_ve_withholding.menu_wh_customer"
+            action="action_account_wh_muni_customer"/>
+
+
+
+        <record model="ir.actions.act_window" id="action_account_wh_muni_supplier">
+            <field name="name">Local Withholding Supplier</field>
+            <field name="res_model">account.wh.munici</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+            <field name="domain">[('type','=','in_invoice')]</field>
+            <field name="context">{'type':'in_invoice'}</field>
+            <field name="search_view_id" ref="view_wh_muni_filter"/>
+            <field name="help">With Local Withholding Supplier you can create and manage document withholding issued to your customers. OpenERP can also generate document withholding automatically from invoices. For retention must add the invoices, process them and then validate the document.</field>
+        </record>
+        <record model="ir.actions.act_window.view" id="act_wv_account_wh_muni_supplier_tree">
+            <field name="sequence" eval="10"/>
+            <field name="view_mode">tree</field>
+            <field name="view_id" ref="view_wh_muni_tree"/> 
+            <field name="act_window_id" ref="action_account_wh_muni_supplier"/>
+        </record>
+        <record model="ir.actions.act_window.view" id="act_wv_account_wh_muni_supplier_form">
+            <field name="sequence" eval="20"/>
+            <field name="view_mode">form</field>
+            <field name="view_id" ref="view_wh_muni_form"/>
+            <field name="act_window_id" ref="action_account_wh_muni_supplier"/>
+        </record>
+
+        <menuitem
+            id="menu_action_account_wh_muni_supplier"
+            name="Local Withholding Supplier"
+            parent="l10n_ve_withholding.menu_wh_suppiler"
+            action="action_account_wh_muni_supplier"/>
+
+    </data>
+</openerp>

=== added directory 'l10n_ve_withholding_muni/wizard'
=== added file 'l10n_ve_withholding_muni/wizard/__init__.py'
--- l10n_ve_withholding_muni/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wizard/__init__.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,37 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import wizard_ret_munici_xml
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'l10n_ve_withholding_muni/wizard/out.txt'
--- l10n_ve_withholding_muni/wizard/out.txt	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wizard/out.txt	2011-09-22 17:22:23 +0000
@@ -0,0 +1,1 @@
+False,2009/003,01245898,1,500.0,20.0

=== added file 'l10n_ve_withholding_muni/wizard/prueba1.py'
--- l10n_ve_withholding_muni/wizard/prueba1.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wizard/prueba1.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,9 @@
+import sys
+
+
+
+print 'Nombre Archivo:',sys.argv[0]
+print 'Periodo:',sys.argv[1]
+
+
+

=== added file 'l10n_ve_withholding_muni/wizard/wizard_ret_munici_xml.py'
--- l10n_ve_withholding_muni/wizard/wizard_ret_munici_xml.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_withholding_muni/wizard/wizard_ret_munici_xml.py	2011-09-22 17:22:23 +0000
@@ -0,0 +1,132 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2009 Netquatro C.A. (http://openerp.netquatro.com/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+# 
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# 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 2
+# 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, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import wizard
+import osv
+import pooler
+from tools.translate import _
+import os
+
+_transaction_form = '''<?xml version="1.0"?>
+<form string=" Seleccione el periodo de declaracion">
+     <field name="period_id"/>
+
+</form>'''
+
+_transaction_fields = {
+    'period_id': {
+        'string': 'Periodo',
+        'type': 'many2one',
+        'relation': 'account.period',
+        'required': True
+    },
+   
+}
+
+
+
+def _data_save(self, cr, uid, data, context):
+    pool = pooler.get_pool(cr.dbname)
+    period_obj = pool.get('account.period')
+    comp_obj = pool.get('account.retencion.munici')
+    form = data['form']
+
+    res = {}
+    lst = []
+    period = period_obj.browse(cr, uid, form['period_id'])
+    comp_ids = comp_obj.search(cr, uid, [('date_ret','>=',period.date_start),('date_ret','<=',period.date_stop)])
+    print 'comprobantes: ',comp_ids
+    for comprobante in comp_obj.browse(cr, uid, comp_ids):
+        res['rif_r'] = comprobante.partner_id.vat
+        for line in comprobante.munici_line_ids:            
+            res['nro'] = line.invoice_id.number
+            res['ctrl'] = line.invoice_id.nro_ctrl
+            res['conce'] = line.concepto_id
+            res['monto'] = line.amount
+            res['ptaje'] = line.retencion_munici
+
+        lst.append(res)
+
+    print 'resultadoxxx: ',res
+
+
+        
+    
+#    os.system("python /home/javier/openerp/stable/5.0/base/loc_ve_29122009/retencion_munici/wizard/prueba1.py "+period.name)
+
+
+    return self._csv_write(cr, uid, lst, context)
+
+class wiz_ret_munici_xml(wizard.interface):
+
+    def _csv_write(self, cr, uid, data, context):
+        orden = [
+            'rif_r',
+            'nro',
+            'ctrl',
+            'conce',
+            'monto',
+            'ptaje'
+
+        ]
+        print 'data: ',data
+        lt = []
+        arch = []        
+        for d in data:
+            print 'd: ',d
+            for col in orden:
+                print 'col: ',col
+                lt.append(d[col])
+
+        print 'lt: ',lt
+        arch.append(tuple(lt))
+        print 'archxxx: ',arch
+
+        import csv
+        cw = csv.writer(open("/home/javier/openerp/stable/5.0/base/loc_ve_29122009/retencion_munici/wizard/out.csv", "wb"))
+        cw.writerows(arch)
+        return {}
+
+
+    states = {
+        'init': {
+            'actions': [],
+            'result': {'type': 'form', 'arch':_transaction_form, 'fields':_transaction_fields, 'state':[('end','Cancel'),('change','Realizar')]}
+        },
+        'change': {
+            'actions': [_data_save],
+            'result': {'type': 'state', 'state':'end'}
+        }
+    }
+wiz_ret_munici_xml('account.ret.munici.xml.seniat')
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+