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

[Gabriela Quilarque]

Update module l10n_ve_fiscal_reports.

[lp:~vauxoo/openerp-venezuela-localization/gaby_l10n_ve_fiscal_reports]

494. By Gabriela Quilarque on 2011-12-29

[IMP] Added module l10n_ve_fiscal_reports.
[IMP] Renamed old module l10n_ve_fiscal_reports to l10n_ve_fiscal_reports_V2.

=== added directory 'l10n_ve_fiscal_reports'
=== added file 'l10n_ve_fiscal_reports/__init__.py'
--- l10n_ve_fiscal_reports/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/__init__.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,36 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+#                    Nhomar Hernandéz <[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 invoice
+import l10n_ve_fiscal_reports
+import report
+import wizard
+import adjustment_book

=== added file 'l10n_ve_fiscal_reports/__openerp__.py'
--- l10n_ve_fiscal_reports/__openerp__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/__openerp__.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,66 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+#                    Nhomar Hernandéz <[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" : "Fiscal Report For Venezuela",
+    "version" : "0.3",
+    "depends" : ["account","l10n_ve_withholding_iva",],
+    "author" : "Vauxoo",
+    "description" : """
+    What this module does:
+    Build all Fiscal Reports for Law in Venezuela.
+    -- Purchase Report.
+    -- Sales Report.
+    -- Withholding Report.
+        Sales, Purchase, ISLR and Munic.
+    """,
+    "website" : "http://openerp.com.ve",
+    "category" : "Generic Modules/Accounting",
+    "init_xml" : [
+    ],
+    "demo_xml" : [
+    ],
+    "update_xml" : [
+        "security/ir.model.access.csv",
+        "data/l10n_ve_fiscal_reports.xml",
+        "fiscal_report_purchase_view.xml",
+        "fiscal_report_sale_view.xml",
+        "fiscal_report_whp.xml",
+        "fiscal_report_whs.xml",
+        "fiscal_report_report.xml",
+        "fiscal_report_wizard.xml",
+        "wizard/sales_book_wizard_view.xml",
+        "invoice_view.xml",
+        "adjustment_book.xml",
+    ],
+    "active": False,
+    "installable": True,
+}

=== added file 'l10n_ve_fiscal_reports/adjustment_book.py'
--- l10n_ve_fiscal_reports/adjustment_book.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/adjustment_book.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,146 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Humberto Arocha           <[e-mail]>
+#              María Gabriela Quilarque  <[e-mail]>
+#              Javier Duran              <[e-mail]>             
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+from osv import osv
+from osv import fields
+from tools.translate import _
+from tools import config
+import time
+import datetime
+import decimal_precision as dp
+
+class adjustment_book(osv.osv):
+
+    def _get_amount_total(self,cr,uid,ids,name,args,context=None):
+        res = {}
+        for adj in self.browse(cr,uid,ids,context):
+            res[adj.id] = {
+                'amount_total': 0.0,
+                'amount_untaxed_n_total' : 0.0,
+                'amount_with_vat_n_total': 0.0,
+                'amount_untaxed_i_total' : 0.0,
+                'amount_with_vat_i_total': 0.0,
+                'uncredit_fiscal_total'  : 0.0,
+                'amount_with_vat_total'  : 0.0,
+                'amount_base_total'  : 0.0,
+                'amount_percent_total'  : 0.0,
+            }
+            for line in adj.adjustment_ids:
+                res[adj.id]['amount_total'] += line.amount
+                res[adj.id]['amount_untaxed_n_total'] += line.amount_untaxed_n
+                res[adj.id]['amount_with_vat_n_total'] += line.amount_with_vat_n
+                res[adj.id]['amount_untaxed_i_total'] += line.amount_untaxed_i
+                res[adj.id]['amount_with_vat_i_total'] += line.amount_with_vat_i
+                res[adj.id]['uncredit_fiscal_total'] += line.uncredit_fiscal
+                res[adj.id]['amount_with_vat_total'] += line.amount_with_vat
+            res[adj.id]['amount_base_total'] += adj.vat_general_i+adj.vat_general_add_i+adj.vat_reduced_i+adj.vat_general_n+\
+                                     adj.vat_general_add_n+adj.vat_reduced_n+adj.no_grav+adj.sale_export
+            res[adj.id]['amount_percent_total'] += adj.vat_general_icf+adj.vat_general_add_icf+adj.vat_reduced_icf+adj.vat_general_ncf+\
+                                         adj.vat_general_add_ncf+adj.vat_reduced_ncf+adj.adjustment_cf+adj.sale_export_cf
+            
+        return res
+
+    _name='adjustment.book'
+    _columns={
+        'name':fields.char('Description', size=256,required=True,help="Description of adjustment book"),
+        'period_id':fields.many2one('account.period','Period',required=True,help="Period of adjustment book"),
+        'adjustment_ids': fields.one2many('adjustment.book.line','adjustment_id','Adjustment Book Line'),
+        'note': fields.text('Note',required=True),
+        'type': fields.selection([
+            ('sale','Sale'),
+            ('purchase', 'Purchase'),
+            ],'Type', select=True, required=True, help="Type of adjustment book: Sale or Purchase"),
+        'amount_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Total Withholding VAT',readonly=True,help="Amount Total for adjustment book of invoice"),
+        'amount_untaxed_n_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Untaxed National',readonly=True,help="Amount Total Untaxed for adjustment book of nacional operations"),
+        'amount_with_vat_n_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Withheld National',readonly=True,help="Amount Total Withheld for adjustment book of national operations"),
+        'amount_untaxed_i_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Untaxed International',readonly=True,help="Amount Total Untaxed for adjustment book of internacional operations"),
+        'amount_with_vat_i_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Withheld International',readonly=True,help="Amount Total Withheld for adjustment book of international operations"),
+        'uncredit_fiscal_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Sin derecho a credito fiscal',readonly=True,help="Sin derecho a credito fiscal"),
+        'amount_with_vat_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Withholding VAT Total',readonly=True,help="Amount Total Withholding VAT for adjustment book"),
+        'no_grav': fields.float('Compras/Ventas no Gravadas y/o SDCF', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas no gravadas y/o sin derecho a credito fiscal/ Ventas Internas no grabadas"),
+        'vat_general_i': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'), help="Importaciones gravadas por alicuota general"),
+        'vat_general_add_i': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota general mas alicuota adicional"),
+        'vat_reduced_i': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota reducida"),
+        'vat_general_n': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'),help="Compras gravadas por alicuota general/Ventas internas gravadas por alicuota general"),
+        'vat_general_add_n': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas internas gravadas por alicuota general mas alicuota adicional"),
+        'vat_reduced_n': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas Internas gravadas por alicuota reducida"),
+        'vat_general_icf': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'), help="Importaciones gravadas por alicuota general"),
+        'vat_general_add_icf': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota general mas alicuota adicional"),
+        'vat_reduced_icf': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota reducida"),
+        'vat_general_ncf': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'),help="Compras gravadas por alicuota general/Ventas internas gravadas por alicuota general"),
+        'vat_general_add_ncf': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas internas gravadas por alicuota general mas alicuota adicional"),
+        'vat_reduced_ncf': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas Internas gravadas por alicuota reducida"),
+        'adjustment_cf': fields.float('Ajustes', digits_compute= dp.get_precision('Fiscal Report'),help="Ajustes a los creditos/debitos fiscales de los periodos anteriores"),
+        'amount_base_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Total Base Imponible',readonly=True,help="TOTAL COMPRAS DEL PERIODO/TOTAL VENTAS PARA EFECTOS DE DETERMINACION"),
+        'amount_percent_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Total % Fiscal',readonly=True,help="TOTALCREDITOS FISCALES DEL PERIODO/TOTAL DEBITOS FISCALES PARA EFECTOS DE DETERMINACION"),
+        'sale_export':fields.float('Ventas de Exportacion', digits_compute= dp.get_precision('Fiscal Report'),help="Ventas de Exportacion"),
+        'sale_export_cf':fields.float('Ventas de Exportacion', digits_compute= dp.get_precision('Fiscal Report'),help="Ventas de Exportacion"),
+    }
+
+    _sql_constraints = [
+        ('period_id_type_uniq', 'unique (period_id,type)', 'The period and type combination must be unique!')
+    ]
+    
+    
+adjustment_book()
+
+
+class adjustment_book_line(osv.osv):
+    
+    _name='adjustment.book.line'
+    _columns={
+        'date_accounting': fields.date('Date Accounting', required=True,help="Date accounting for adjustment book"),
+        'date_admin': fields.date('Date Administrative',required=True, help="Date administrative for adjustment book"),
+        'vat':fields.char('Vat', size=10,required=True,help="Vat of partner for adjustment book"),
+        'partner':fields.char('Partner', size=256,required=True,help="Partner for adjustment book"),
+        'invoice_number':fields.char('Invoice Number', size=256,required=True,help="Invoice number for adjustment book"),
+        'control_number':fields.char('Invoice Control', size=256,required=True,help="Invoice control for adjustment book"),        
+        'amount':fields.float('Amount Document at Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount document for adjustment book"),
+        'amount':fields.float('Amount Document at Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount document for adjustment book"),
+        'type_doc': fields.selection([
+            ('F','Invoice'),
+            ('ND', 'Debit Note'),
+            ('NC', 'Credit Note'),
+            ],'Document Type', select=True, required=True, help="Type of Document for adjustment book: -Invoice(F),-Debit Note(dn),-Credit Note(cn)"),
+        'doc_affected':fields.char('Affected Document', size=256,required=True,help="Affected Document for adjustment book"),
+        'uncredit_fiscal':fields.float('Sin derecho a Credito Fiscal',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Sin derechoa credito fiscal"),
+        'amount_untaxed_n': fields.float('Amount Untaxed',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount untaxed for national operations"),
+        'percent_with_vat_n': fields.float('% Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Percent(%) VAT for national operations"),
+        'amount_with_vat_n': fields.float('Amount Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Percent(%) VAT for national operations"),
+        'amount_untaxed_i': fields.float('Amount Untaxed',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount untaxed for international operations"),
+        'percent_with_vat_i': fields.float('% Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Percent(%) VAT for international operations"),
+        'amount_with_vat_i': fields.float('Amount Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount withholding VAT for international operations"),
+        'amount_with_vat': fields.float('Amount Withholding VAT Total',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount withheld VAT total"),
+        'voucher': fields.char('Voucher Withholding VAT', size=256,required=True,help="Voucher Withholding VAT"),
+        'adjustment_id':fields.many2one('adjustment.book','Adjustment Book')
+    }
+    _rec_rame = 'partner'
+    
+adjustment_book_line()
+
+
+

=== added file 'l10n_ve_fiscal_reports/adjustment_book.xml'
--- l10n_ve_fiscal_reports/adjustment_book.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/adjustment_book.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,213 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+    <!-- 
+    =====================================================
+    ADJUSTMENT BOOK
+    =====================================================
+    -->
+
+        <record id="view_adjustment_book_line_line_form" model="ir.ui.view">
+            <field name="name">adjustment.book.line.form</field>
+            <field name="model">adjustment.book.line</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Adjustment Book Line">
+                    <group col="4" colspan="4">
+                        <field name="date_accounting" select="1"/>
+                        <field name="date_admin" select="1"/>
+                        <field name="vat" select="1"/>
+                        <field name="partner" select="1"/>
+                        <field name="invoice_number" select="1"/>
+                        <field name="control_number" select="1"/>
+                        <field name="amount"/>
+                        <field name="type_doc"/>
+                        <field name="doc_affected"/>
+                        <field name="uncredit_fiscal"/>
+                        <field name="amount_with_vat"/>
+                        <field name="voucher"/>
+                    </group>
+                    <newline/>
+                    <separator string="National Operations" colspan="6"/>
+                    <newline/>
+                    <group col="4" colspan="4">
+                        <field name="amount_untaxed_n"/>
+                        <field name="percent_with_vat_n"/>
+                        <field name="amount_with_vat_n"/>
+                    </group>
+                    <newline/>
+                    <separator string="International Operations" colspan="6"/>
+                    <newline/>
+                    <group col="4" colspan="4">
+                        <field name="amount_untaxed_i"/>
+                        <field name="percent_with_vat_i"/>
+                        <field name="amount_with_vat_i"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+
+        <record id="view_adjustment_book_tree" model="ir.ui.view">
+            <field name="name">adjustment.book.tree</field>
+            <field name="model">adjustment.book</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Adjustment Book">
+                    <field name="name"/>
+                    <field name="type"/>
+                    <field name="period_id"/>
+                    <field name="note"/>
+                </tree>
+            </field>
+        </record>
+
+        <record id="view_adjustment_book_line_tree" model="ir.ui.view">
+            <field name="name">adjustment.book.line.tree</field>
+            <field name="model">adjustment.book.line</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Adjustment Book Line">
+                    <field name="date_accounting"/>
+                    <field name="date_admin"/>
+                    <field name="vat"/>
+                    <field name="partner"/>
+                    <field name="invoice_number"/>
+                    <field name="control_number"/>
+                    <field name="amount"/>
+                    <field name="type_doc"/>
+                    <field name="uncredit_fiscal"/>
+                    <field name="doc_affected"/>
+                    <field name="amount_untaxed_n"/>
+                    <field name="percent_with_vat_n"/>
+                    <field name="amount_with_vat_n"/>
+                    <field name="amount_untaxed_i"/>
+                    <field name="percent_with_vat_i"/>
+                    <field name="amount_with_vat_i"/>
+                </tree>
+            </field>
+        </record>
+
+        <record id="view_adjustment_bookr_form" model="ir.ui.view">
+            <field name="name">adjustment.book.form</field>
+            <field name="model">adjustment.book</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Adjustment Book">
+                    <group col="6" colspan="6">
+                        <field name="name" select="1"/>
+                        <field name="type" select="1"/>
+                        <field name="period_id" select="1"/>
+                    </group>
+                    <notebook colspan="8">
+                        <page string="Adjustment Book Lines">
+                            <field name="adjustment_ids" nolabel="1" colspan='4'/>
+                            <group col="8" colspan="8">
+                                <field name="amount_total"/>
+                                <field name="uncredit_fiscal_total"/>
+                                <field name="amount_with_vat_total"/>
+                                <hpaned/>
+                                <hpaned/>
+                            </group>
+                            <group col="8" colspan="8">
+                                <field name="amount_untaxed_n_total"/>
+                                <field name="amount_with_vat_n_total"/>
+                                <field name="amount_untaxed_i_total"/>
+                                <field name="amount_with_vat_i_total"/>
+                            </group>
+                        <group col="4" colspan="4">
+                            <separator string="Explanation about this adjustment"/>
+                            <newline/>
+                            <field name="note" nolabel="1"/>
+                        </group>
+                        </page>
+                        <page string="Totales">
+                            <group colspan="4" col="6">
+                            <field name="no_grav" colspan="4"/>
+                            </group>
+                            <notebook colspan="8">
+                                <page string="Base Imponible" >
+                                    <group colspan="4" col="6">
+                                        <group colspan="4" col="2">
+                                        <separator string="Internacionales" colspan="4"/>
+                                        <field name="vat_general_i" attrs="{'readonly':[('type','=','sale')]}"/>
+                                        <field name="vat_general_add_i" attrs="{'readonly':[('type','=','sale')]}"/>
+                                        <field name="vat_reduced_i" attrs="{'readonly':[('type','=','sale')]}"/>
+                                        <field name="sale_export" attrs="{'readonly':[('type','=','purchase')]}"/>
+                                        </group>
+                                        <group colspan="1" col="2">
+                                        <separator string="Nacionales" colspan="2"/>
+                                        <field name="vat_general_n"/>
+                                        <field name="vat_general_add_n"/>
+                                        <field name="vat_reduced_n"/>
+                                        </group>
+                                        <group colspan="1" col="2">
+                                        <separator string="Total y Ajuste" colspan="2"/>
+                                        <field name="amount_base_total" colspan="4"/>
+                                        </group>
+                                    </group>
+                                </page>
+                            </notebook>
+                            <notebook colspan="8">
+                                <page string="Porcentaje Fiscal" >
+                                    <group colspan="4" col="6">
+                                        <group colspan="4" col="2">
+                                        <separator string="Internacionales" colspan="4"/>
+                                        <field name="vat_general_icf" attrs="{'readonly':[('type','=','sale')]}"/>
+                                        <field name="vat_general_add_icf" attrs="{'readonly':[('type','=','sale')]}"/>
+                                        <field name="vat_reduced_icf" attrs="{'readonly':[('type','=','sale')]}"/>
+                                        <field name="sale_export_cf" attrs="{'readonly':[('type','=','purchase')]}"/>
+                                        </group>
+                                        <group colspan="1" col="2">
+                                        <separator string="Nacionales" colspan="2"/>
+                                        <field name="vat_general_ncf"/>
+                                        <field name="vat_general_add_ncf"/>
+                                        <field name="vat_reduced_ncf"/>
+                                        </group>
+                                        <group colspan="1" col="2">
+                                        <separator string="Total y Ajuste" colspan="2"/>
+                                        <field name="adjustment_cf" colspan="4"/>
+                                        <field name="amount_percent_total" colspan="4"/>
+                                        </group>
+                                    </group>
+                                </page>
+                            </notebook>
+                        </page>
+                    </notebook>
+                </form>
+            </field>
+        </record>
+
+      <record model="ir.actions.act_window" id="action_adjustment_book">
+            <field name="name">Adjustment Book</field>
+            <field name="res_model">adjustment.book</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+        </record>
+        
+        <record model="ir.actions.act_window.view" id="action_adjustment_book_tree">
+            <field name="sequence" eval="10"/>
+            <field name="view_mode">tree</field>
+            <field name="view_id" ref="view_adjustment_book_tree"/> 
+            <field name="act_window_id" ref="action_adjustment_book"/>
+        </record>
+        <record model="ir.actions.act_window.view" id="action_adjustment_book_form">
+            <field name="sequence" eval="20"/>
+            <field name="view_mode">form</field>
+            <field name="view_id" ref="view_adjustment_bookr_form"/>
+            <field name="act_window_id" ref="action_adjustment_book"/>
+        </record>
+        
+        <menuitem name="Adjustment Book" 
+            id="menu_adjustment_book" 
+            parent="l10n_ve_fiscal_reports.menu_fr_main"
+            action="action_adjustment_book"/>
+
+    </data>
+</openerp>
+
+
+
+
+

=== added directory 'l10n_ve_fiscal_reports/data'
=== added file 'l10n_ve_fiscal_reports/data/l10n_ve_fiscal_reports.xml'
--- l10n_ve_fiscal_reports/data/l10n_ve_fiscal_reports.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/data/l10n_ve_fiscal_reports.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,10 @@
+<?xml version="1.0"?>
+<openerp>
+    <data noupdate="1">
+        <!-- Decimal Precision -->
+        <record forcecreate="True" id="decimal_fiscal_report" model="decimal.precision">
+            <field name="name">Fiscal Report</field>
+            <field name="digits">2</field>
+        </record>
+	</data>
+</openerp>

=== added file 'l10n_ve_fiscal_reports/fiscal_report_purchase_view.xml'
--- l10n_ve_fiscal_reports/fiscal_report_purchase_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/fiscal_report_purchase_view.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,56 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+    
+        <record model="ir.ui.view" id="view_fiscal_reports_purchase_form">
+            <field name="name">fiscal.reports.purchase.form</field>
+            <field name="model">fiscal.reports.purchase</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Detail of entry">
+                    <group col="6" colspan="4">
+                        <field name="ai_date_invoice"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ai_nro_ctrl"/>
+                        <field name="ai_reference"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ai_type"/>
+                        <field name="rp_retention"/>
+                        <field name="ai_id"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+        <record model="ir.ui.view" id="view_fiscal_reports_purchase_tree">
+            <field name="name">fiscal.reports.purchase.tree</field>
+            <field name="model">fiscal.reports.purchase</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="List of Purchases." editable="top/bottom">
+                        <field name="ai_date_invoice"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ai_nro_ctrl"/>
+                        <field name="ai_reference"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ai_type"/>
+                        <field name="rp_retention"/>
+                        <field name="ai_id"/>
+                </tree>
+            </field>
+        </record>
+    <record id="action_fiscal_reports_purchase_tree" model="ir.actions.act_window">
+    <field name="name">Profit by Product</field>
+    <field name="res_model">fiscal.reports.purchase</field>
+    <field name="view_type">form</field>
+    <field name="view_mode">tree,form</field>
+    </record>
+    <menuitem id="menu_fr_main" name="Fiscal Reporting for SENIAT" parent="account.menu_finance_reporting" groups="account.group_account_manager"/>
+    <menuitem id="menu_fiscal_reports_purchase_tree" name="Purchase Book" parent="l10n_ve_fiscal_reports.menu_fr_main" action="action_fiscal_reports_purchase_tree" groups="account.group_account_manager"/>
+    </data>
+</openerp>

=== added file 'l10n_ve_fiscal_reports/fiscal_report_report.xml'
--- l10n_ve_fiscal_reports/fiscal_report_report.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/fiscal_report_report.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+<!--Purchases and Sales-->
+        <report             
+            id="report_purchase_seniat" 
+            model="fiscal.reports.purchase" 
+            name="fiscal.reports.purchase.purchase_seniat" 
+            rml="l10n_ve_fiscal_reports/report/book_seniat.rml" 
+            sxw="l10n_ve_fiscal_reports/report/sources/book_seniat.sxw"
+            string="Book Sales and Purchase SENIAT"
+            auto="False" 
+            menu="False"/>
+<!--        <report             
+            id="report_sale_seniat"
+            model="fiscal.reports.sale" 
+            name="fiscal.reports.purchase.sale_seniat" 
+            rml="l10n_ve_fiscal_reports/report/sale_seniat.rml" 
+            sxw="l10n_ve_fiscal_reports/report/sources/sale_seniat.sxw"
+            string="Sale SENIAT"
+            auto="False" /> -->
+
+<!--Withholding purchases and sales [whp and whs]-->
+      <report             
+            id="report_whp_seniat" 
+            model="fiscal.reports.whp" 
+            name="fiscal.reports.whp.whp_seniat" 
+            rml="l10n_ve_fiscal_reports/report/witholding_book.rml" 
+            sxw="l10n_ve_fiscal_reports/report/sources/witholding_book.sxw"
+            string="Witholding Purchase SENIAT"
+            auto="False" 
+            menu="False"/>
+
+<!--        <report             
+            id="report_whs_seniat" 
+            model="fiscal.reports.whs" 
+            name="fiscal.reports.purchase.whs_seniat" 
+            rml="l10n_ve_fiscal_reports/report/whs_seniat.rml" 
+            sxw="l10n_ve_fiscal_reports/report/sources/whs_seniat.sxw"
+            string="Whitholding Purchase SENIAT"
+            auto="False" />
+-->
+    </data>
+</openerp>

=== added file 'l10n_ve_fiscal_reports/fiscal_report_sale_view.xml'
--- l10n_ve_fiscal_reports/fiscal_report_sale_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/fiscal_report_sale_view.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,56 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+        <record model="ir.ui.view" id="view_fiscal_reports_sale_form">
+            <field name="name">fiscal.reports.sale.form</field>
+            <field name="model">fiscal.reports.sale</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Detail of entry">
+                    <group col="6" colspan="4">
+                        <field name="ai_date_document" readonly="1"/>
+                        <field name="ai_date_invoice" readonly="1"/>
+                        <field name="rp_vat" readonly="1"/>
+                        <field name="rp_id" readonly="1"/>
+                        <field name="ai_nro_ctrl" readonly="1"/>
+                        <field name="ai_reference" readonly="1"/>
+                        <field name="ai_amount_total" readonly="1"/>
+                        <field name="ai_amount_untaxed" readonly="1"/>
+                        <field name="ai_amount_tax" readonly="1"/>
+                        <field name="ai_type" readonly="1"/>
+                        <field name="rp_retention" readonly="1"/>
+                        <field name="ai_id" readonly="1"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+        <record model="ir.ui.view" id="view_fiscal_reports_sale_tree">
+            <field name="name">fiscal.reports.sale.tree</field>
+            <field name="model">fiscal.reports.sale</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="List of Purchases.">
+                        <field name="ai_date_document"/>
+                        <field name="ai_date_invoice"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ai_nro_ctrl"/>
+                        <field name="ai_reference"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ai_type"/>
+                        <field name="rp_retention"/>
+                        <field name="ai_id"/>
+                </tree>
+            </field>
+        </record>
+    <record id="action_fiscal_reports_sale_tree" model="ir.actions.act_window">
+        <field name="name">Fiscal Report Sales</field>
+        <field name="res_model">fiscal.reports.sale</field>
+        <field name="view_type">form</field>
+        <field name="view_mode">tree,form</field>
+    </record>
+    <menuitem id="menu_fiscal_reports_sale_tree" name="Sales Book" parent="l10n_ve_fiscal_reports.menu_fr_main" action="action_fiscal_reports_sale_tree" groups="account.group_account_manager"/>
+    </data>
+</openerp>

=== added file 'l10n_ve_fiscal_reports/fiscal_report_whp.xml'
--- l10n_ve_fiscal_reports/fiscal_report_whp.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/fiscal_report_whp.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,62 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+    
+        <record model="ir.ui.view" id="view_fiscal_reports_whp_form">
+            <field name="name">fiscal.reports.whp.form</field>
+            <field name="model">fiscal.reports.whp</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Detail of entry">
+                    <group col="6" colspan="4">
+                        <field name="ar_date_ret"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ar_number"/>
+                        <field name="ai_reference"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ar_line_id"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+        <record model="ir.ui.view" id="view_fiscal_reports_whp_tree">
+            <field name="name">fiscal.reports.whp.tree</field>
+            <field name="model">fiscal.reports.whp</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="List of Purchases." editable="top/bottom">
+                        <field name="ar_date_ret"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ar_number"/>
+                        <field name="ai_reference"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ar_line_id"/>
+                </tree>
+            </field>
+        </record>
+<!--
+    'ar_date_ret': fields.date('Date ret.'),
+    'rp_vat':fields.char('Vat Number', size=64, readonly=True),
+    'rp_id':fields.many2one('res.partner', 'Partner', required=False),
+    'ar_number':fields.char('Retention Number', size=64, required=False, readonly=False),
+    'ai_reference':fields.char('Invoice Number', size=64, required=False, readonly=False),
+    'ai_amount_total': fields.float('Amount Total', digits=(16, int(config['price_accuracy']))),
+    'ai_amount_untaxed': fields.float('Amount Untaxed', digits=(16, int(config['price_accuracy']))),
+    'ai_amount_tax': fields.float('Amount tax', digits=(16, int(config['price_accuracy']))),
+    'ar_line_id':fields.many2one('account.retention.line', 'Account Retention', required=False),
+-->
+    <record id="action_fiscal_reports_whp_tree" model="ir.actions.act_window">
+    <field name="name">Profit by Product</field>
+    <field name="res_model">fiscal.reports.whp</field>
+    <field name="view_type">form</field>
+    <field name="view_mode">tree,form</field>
+    </record>
+    <menuitem id="menu_fiscal_reports_whp_tree" name="Purchase Witholding Book" parent="l10n_ve_fiscal_reports.menu_fr_main" action="action_fiscal_reports_whp_tree" groups="account.group_account_manager"/>
+    </data>
+</openerp>

=== added file 'l10n_ve_fiscal_reports/fiscal_report_whs.xml'
--- l10n_ve_fiscal_reports/fiscal_report_whs.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/fiscal_report_whs.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,53 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+    
+        <record model="ir.ui.view" id="view_fiscal_reports_whs_form">
+            <field name="name">fiscal.reports.whs.form</field>
+            <field name="model">fiscal.reports.whs</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Detail of entry">
+                    <group col="6" colspan="4">
+                        <field name="ar_date_ret"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ar_number"/>
+                        <field name="ai_number"/>
+                        <field name="ai_id"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ar_id"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+        <record model="ir.ui.view" id="view_fiscal_reports_whs_tree">
+            <field name="name">fiscal.reports.whs.tree</field>
+            <field name="model">fiscal.reports.whs</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="List of Purchases." editable="top/bottom">
+                        <field name="ar_date_ret"/>
+                        <field name="rp_vat"/>
+                        <field name="rp_id"/>
+                        <field name="ar_number"/>
+                        <field name="ai_number"/>
+                        <field name="ai_id"/>
+                        <field name="ai_amount_total"/>
+                        <field name="ai_amount_untaxed"/>
+                        <field name="ai_amount_tax"/>
+                        <field name="ar_id"/>
+                </tree>
+            </field>
+        </record>
+    <record id="action_fiscal_reports_whs_tree" model="ir.actions.act_window">
+    <field name="name">whitholding Sales.</field>
+    <field name="res_model">fiscal.reports.whs</field>
+    <field name="view_type">form</field>
+    <field name="view_mode">tree,form</field>
+    </record>
+    <menuitem id="menu_fiscal_reports_whs_tree" name="Sale Witholding Book" parent="l10n_ve_fiscal_reports.menu_fr_main" action="action_fiscal_reports_whs_tree" groups="account.group_account_manager"/>
+    </data>
+</openerp>

=== added file 'l10n_ve_fiscal_reports/fiscal_report_wizard.xml'
--- l10n_ve_fiscal_reports/fiscal_report_wizard.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/fiscal_report_wizard.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+        <wizard
+            id="wizard_wh_book"
+            model="fiscal.reports.whp"
+            name="fiscal.reports.whp.wh_book"
+            string="Witholding Book"/>
+
+		<menuitem
+			name="Print Report Witholding Sales or Purchase"
+			parent="l10n_ve_fiscal_reports.menu_fr_main"
+			action="wizard_wh_book"
+			type="wizard"
+			icon="STOCK_PRINT"
+			id="menu_wizard_wh_book_report"
+            groups="account.group_account_manager"
+            sequence="50"/>
+
+        <wizard
+            id="wizard_recalc_taxes"
+            model="fiscal.reports.whp"
+            name="fiscal.recalc.taxes"
+            string="Recompute Taxes"
+            menu="False"/>
+		<menuitem
+			name="Recompute Taxes."
+			parent="l10n_ve_fiscal_reports.menu_fr_main"
+			action="wizard_recalc_taxes"
+			type="wizard"
+			icon="STOCK_EXECUTE"
+			id="menu_wizard_recompute_report"
+            groups="account.group_account_manager"			
+            sequence="51"/>
+
+
+    </data>
+</openerp>
+

=== added directory 'l10n_ve_fiscal_reports/i18n'
=== added file 'l10n_ve_fiscal_reports/i18n/es_ES.po'
--- l10n_ve_fiscal_reports/i18n/es_ES.po	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/i18n/es_ES.po	2011-12-29 18:55:26 +0000
@@ -0,0 +1,988 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* l10n_ve_fiscal_reports
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 5.0.16\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2011-08-30 00:27:23+0000\n"
+"PO-Revision-Date: 2011-08-30 00:27:23+0000\n"
+"Last-Translator: <>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,date_admin:0
+msgid "Date administrative for adjustment book"
+msgstr "Fecha administrativa para el libro de ajuste"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.wizard,name:l10n_ve_fiscal_reports.wizard_wh_book
+msgid "Witholding Book"
+msgstr "Libro de Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,uncredit_fiscal:0
+msgid "Sin derecho a Credito Fiscal"
+msgstr "SDCF"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Impuesto"
+msgstr "Impuesto"
+
+#. module: l10n_ve_fiscal_reports
+#: constraint:ir.actions.act_window:0
+msgid "Invalid model name in the action definition."
+msgstr "Nombre de modelo no válido en la definición de acción."
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whp,ai_id:0
+msgid "Account Invoice"
+msgstr "Cuenta de la Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: view:adjustment.book:0
+#: field:adjustment.book.line,adjustment_id:0
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_reports.action_adjustment_book
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_adjustment_book
+msgid "Adjustment Book"
+msgstr "Libro de Ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,amount_untaxed_n_total:0
+msgid "Amount Untaxed National"
+msgstr "Total Base Imponible Nacional"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Factura Afectada"
+msgstr "Factura Afectada"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,vat:0
+msgid "Vat"
+msgstr "RIF"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "HIDING"
+msgstr "Ocultar"
+
+#. module: l10n_ve_fiscal_reports
+#: view:fiscal.reports.purchase:0
+#: view:fiscal.reports.sale:0
+#: view:fiscal.reports.whp:0
+#: view:fiscal.reports.whs:0
+msgid "List of Purchases."
+msgstr "Lista de Compras"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:fiscal.reports.purchase.book_seniat_HG,init,model:0
+msgid "Book Sales"
+msgstr "Libro Ventas"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Fecha Fact."
+msgstr "Fecha Fact."
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "0,00"
+msgstr "0,00"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "TOTAL"
+msgstr "TOTAL"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,doc_affected:0
+msgid "Affected Document"
+msgstr "Documento Afectado"
+
+#. module: l10n_ve_fiscal_reports
+#: code:addons/l10n_ve_fiscal_reports/wizard/sales_book_wizard.py:0
+#: selection:adjustment.book,type:0
+#: selection:sales.book.wizard,type:0
+#, python-format
+msgid "Purchase"
+msgstr "Compra"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Base Imponible"
+msgstr "Base Imponible"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,rp_retention:0
+msgid "Whitholding Rate"
+msgstr "Tasa de Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,doc_affected:0
+msgid "Affected Document for adjustment book"
+msgstr "Documento afectado para el libro de ajuste"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Operaciones Internacionales"
+msgstr "Operaciones Internacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: code:addons/l10n_ve_fiscal_reports/wizard/sales_book_wizard.py:0
+#: selection:adjustment.book,type:0
+#: selection:sales.book.wizard,type:0
+#, python-format
+msgid "Sale"
+msgstr "Venta"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:adjustment.book.line,type_doc:0
+msgid "Debit Note"
+msgstr "Nota de Debito"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ai_nro_ctrl:0
+#: field:fiscal.reports.sale,ai_nro_ctrl:0
+msgid "Control No."
+msgstr "Nro. Control"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "T"
+msgstr "T"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_adjustment_book
+msgid "adjustment.book"
+msgstr "Libro de Ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,amount_untaxed_n_total:0
+msgid "Amount Total Untaxed for adjustment book of nacional operations"
+msgstr "Total de la Base Imponible de las operaciones nacionales para el libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Total con IVA"
+msgstr "Total con IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,amount_untaxed_i_total:0
+msgid "Amount Untaxed International"
+msgstr "Total Base Imponible Inter."
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,invoice_number:0
+msgid "Invoice number for adjustment book"
+msgstr "Numero de factura para el libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Razon Social"
+msgstr "Razon Social"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,amount_with_vat_i:0
+msgid "Amount withholding VAT for international operations"
+msgstr "Monto de Retencion de IVA para operaciones internacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,type_doc:0
+msgid "Type of Document for adjustment book: -Invoice(F),-Debit Note(dn),-Credit Note(cn)"
+msgstr "Tipo de documento para el libro de ajustes: -Factura(F),-Nota de Debito(ND),-Nota de Credito(NC)"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "PAGINA:"
+msgstr "PAGINA:"
+
+#. module: l10n_ve_fiscal_reports
+#: field:sales.book.wizard,control_end:0
+msgid "Control End"
+msgstr "Control Final"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,uncredit_fiscal:0
+msgid "Sin derechoa credito fiscal"
+msgstr "Sin derecho a credito fiscal"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "EXENTO"
+msgstr "EXENTO"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Libro:"
+msgstr "Libro:"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_reports.action_fiscal_reports_purchase_tree
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_reports.action_fiscal_reports_whp_tree
+msgid "Profit by Product"
+msgstr "Rentabilidad por Producto"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Monto Retencion"
+msgstr "Monto Retencion"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,partner:0
+#: field:fiscal.reports.whp,rp_id:0
+msgid "Partner"
+msgstr "Empresa"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_wizard_wh_book_report
+msgid "Print Report Witholding Sales or Purchase"
+msgstr "Imprimir Reporte de Retención de Ventas o Compras"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ai_amount_total:0
+#: field:fiscal.reports.sale,ai_amount_total:0
+#: field:fiscal.reports.whp,ai_amount_total:0
+msgid "Amount Total"
+msgstr "Monto Total"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Operaciones Nacionales"
+msgstr "Operaciones Nacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Hasta:"
+msgstr "Hasta:"
+
+#. module: l10n_ve_fiscal_reports
+#: view:adjustment.book.line:0
+msgid "International Operations"
+msgstr "Operaciones Internacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Numero Control"
+msgstr "Numero de Control"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,control_number:0
+msgid "Invoice Control"
+msgstr "Nro. Control-Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Periodo Fiscal"
+msgstr "Periodo Fiscal"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "WITHOLDING BOOK"
+msgstr "LIBRO DE RETENCIONES"
+
+#. module: l10n_ve_fiscal_reports
+#: view:fiscal.reports.purchase:0
+#: view:fiscal.reports.sale:0
+#: view:fiscal.reports.whp:0
+#: view:fiscal.reports.whs:0
+msgid "Detail of entry"
+msgstr "Detalle de entrada "
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,amount_with_vat_i_total:0
+msgid "Amount Total Withheld for adjustment book of international operations"
+msgstr "Monto total retenido de las operaciones internacionales en el libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: field:account.invoice,date_document:0
+msgid "Document Date"
+msgstr "Fecha del Documento"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Desde :"
+msgstr "Desde :"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,type:0
+#: field:fiscal.reports.sale,ai_type:0
+#: field:sales.book.wizard,type:0
+msgid "Type"
+msgstr "Tipo"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:fiscal.reports.purchase.book_seniat_HG,init,model:0
+msgid "Book Purchase"
+msgstr "Libro de Compras"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.sale,ai_amount_untaxed:0
+msgid "Untaxed amount"
+msgstr "Monto exento de impuesto"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,amount_untaxed_n:0
+msgid "Amount untaxed for national operations"
+msgstr "Base Imponible para operaciones nacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whs,ai_date_inv:0
+msgid "Date Invoice"
+msgstr "Fecha Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: code:addons/l10n_ve_fiscal_reports/wizard/sales_book_wizard.py:0
+#, python-format
+msgid "Error !"
+msgstr "Error !"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_fiscal_reports_sale
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_fiscal_reports_whp
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_fiscal_reports_whs
+msgid "Sale by period"
+msgstr "Venta por Periodo"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whs,ar_number:0
+msgid "WH Number"
+msgstr "Número de Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Base Ret. % Iva."
+msgstr "Base Ret. % Iva."
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whp,ar_date_ret:0
+msgid "Date ret."
+msgstr "Fecha Ret."
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Sin der."
+msgstr "Sin der."
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_reports.action_fiscal_reports_sale_tree
+msgid "Fiscal Report Sales"
+msgstr "Reporte Fiscal de Ventas"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_fiscal_reports_purchase
+msgid "Purchase by period"
+msgstr "Compra por periodo"
+
+#. module: l10n_ve_fiscal_reports
+#: constraint:ir.ui.view:0
+msgid "Invalid XML for View Architecture!"
+msgstr "¡XML inválido para la definición de la vista!"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ai_amount_tax:0
+#: field:fiscal.reports.sale,ai_amount_tax:0
+msgid "Tax Amount"
+msgstr "Monto Impuesto"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,amount_untaxed_i:0
+msgid "Amount untaxed for international operations"
+msgstr "Base Imponible para operaciones internacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,amount_total:0
+msgid "Amount Total Withholding VAT"
+msgstr "Total Base Imponible+IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: view:adjustment.book.line:0
+msgid "National Operations"
+msgstr "Operaciones Nacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,amount_with_vat_n_total:0
+msgid "Amount Total Withheld for adjustment book of national operations"
+msgstr "Base Total del impuesto al valor agregado(IVA)"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whs,ai_amount_tax:0
+msgid "Amount Tax"
+msgstr "Impuesto"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Pagina"
+msgstr "Pagina"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Total Ventas"
+msgstr "Total Ventas"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "TOTALES"
+msgstr "TOTALES"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:adjustment.book.line,type_doc:0
+msgid "Credit Note"
+msgstr "Nota de Credito"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,amount_with_vat_n:0
+#: help:adjustment.book.line,percent_with_vat_n:0
+msgid "Percent(%) VAT for national operations"
+msgstr "Porcentaje(%) de I.V.A para operaciones nacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,name:0
+msgid "Description of adjustment book"
+msgstr "Descripcion del libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Retencion Iva"
+msgstr "Retencion Iva"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "IVA"
+msgstr "IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Monto"
+msgstr "Monto"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whp,ai_amount_tax:0
+msgid "Amount tax"
+msgstr "Monto Impuesto"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,voucher:0
+#: help:adjustment.book.line,voucher:0
+msgid "Voucher Withholding VAT"
+msgstr "Comp. Retencion IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "RIF"
+msgstr "RIF"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,amount_untaxed_i_total:0
+msgid "Amount Total Untaxed for adjustment book of internacional operations"
+msgstr "Base Imponible Total de las operaciones internacionales del libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: view:adjustment.book:0
+msgid "Explanation about this adjustment"
+msgstr "Observaciones sobre el presente libro:"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "del Mes:"
+msgstr "del Mes:"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ai_amount_untaxed:0
+msgid "Untaxed Amount"
+msgstr "Monto Excento de Impuesto"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,partner:0
+msgid "Partner for adjustment book"
+msgstr "Empresa asociada para realizar un ajuste"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,rp_id:0
+#: field:fiscal.reports.sale,rp_id:0
+#: field:fiscal.reports.whs,rp_id:0
+msgid "Partner Name"
+msgstr "Empresa"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,date_accounting:0
+msgid "Date accounting for adjustment book"
+msgstr "Fecha contable para el libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Fecha"
+msgstr "Fecha"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Documento Afectado"
+msgstr "Documento Afectado"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,note:0
+msgid "Note"
+msgstr "Nota"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ar_id:0
+#: field:fiscal.reports.purchase,ar_line_id:0
+#: field:fiscal.reports.sale,ar_id:0
+#: field:fiscal.reports.sale,ar_line_id:0
+#: field:fiscal.reports.whp,ar_id:0
+#: field:fiscal.reports.whp,ar_line_id:0
+#: field:fiscal.reports.whs,ar_line_id:0
+msgid "Account Retention"
+msgstr "Cuenta Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_fiscal_reports_sale_tree
+msgid "Sales Book"
+msgstr "Libro de Ventas"
+
+#. module: l10n_ve_fiscal_reports
+#: constraint:ir.model:0
+msgid "The Object name must start with x_ and not contain any special character !"
+msgstr "¡El nombre del objeto debe empezar con x_ y no contener ningún carácter especial!"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.sale,rp_retention:0
+msgid "Withholding"
+msgstr "Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_adjustment_book_line
+msgid "adjustment.book.line"
+msgstr "Lineas del libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Correspodiente al Mes de"
+msgstr "Correspodiente al Mes de"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:fiscal.reports.whp.wh_book_HG,init,model:0
+msgid "Witholding Purchase"
+msgstr "Retención Compra"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.module.module,description:l10n_ve_fiscal_reports.module_meta_information
+msgid "\n"
+"    What this module does:\n"
+"    Build all Fiscal Reports for Law in Venezuela.\n"
+"    -- Purchase Report.\n"
+"    -- Sales Report.\n"
+"    -- Withholding Report.\n"
+"        Sales, Purchase, ISLR and Munic.\n"
+"    "
+msgstr "\n"
+"    Qué hace este módulo:\n"
+"    Construye todos los Informes Fiscales para la Ley en Venezuela .\n"
+"    -- Reporte de Compra.\n"
+"    -- Reporte de Venta.\n"
+"    -- Reporte de Retención.\n"
+"        Ventas, Compras, I.S.L.R. y Munic.\n"
+"    "
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ai_date_document:0
+#: field:fiscal.reports.purchase,ai_date_invoice:0
+#: field:fiscal.reports.sale,ai_date_document:0
+#: field:fiscal.reports.sale,ai_date_invoice:0
+#: field:fiscal.reports.whs,ar_date_ret:0
+msgid "Date"
+msgstr "Fecha"
+
+#. module: l10n_ve_fiscal_reports
+#: code:addons/l10n_ve_fiscal_reports/wizard/sales_book_wizard.py:0
+#, python-format
+msgid "No period defined for this date !\nPlease create a fiscal year."
+msgstr "No period defined for this date !\nPlease create a fiscal year."
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "1.3cm 24.9cm 38.3cm 24.9cm"
+msgstr "1.3cm 24.9cm 38.3cm 24.9cm"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_fiscal_reports_purchase_tree
+msgid "Purchase Book"
+msgstr "Libro de Compra"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_fiscal_reports_whs_tree
+msgid "Sale Witholding Book"
+msgstr "Libro de Retención de Venta"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_fiscal_reports_whp_tree
+msgid "Purchase Witholding Book"
+msgstr "Libro de Retención de Compra"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whs,ai_amount_total:0
+msgid "Invoice Total"
+msgstr "Total Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,uncredit_fiscal_total:0
+#: help:adjustment.book,uncredit_fiscal_total:0
+msgid "Sin derecho a credito fiscal"
+msgstr "SDCF"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,date_accounting:0
+msgid "Date Accounting"
+msgstr "Fecha contable"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,type:0
+msgid "Type of adjustment book: Sale or Purchase"
+msgstr "Tipo de libro de ajustes: Compra o Venta"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,amount_untaxed_i:0
+#: field:adjustment.book.line,amount_untaxed_n:0
+#: field:fiscal.reports.whp,ai_amount_untaxed:0
+#: field:fiscal.reports.whs,ai_amount_untaxed:0
+msgid "Amount Untaxed"
+msgstr "Base Imponible"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,amount_with_vat:0
+msgid "Amount withheld VAT total"
+msgstr "Monto Total Retenido de IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,amount:0
+msgid "Amount Document at Withholding VAT"
+msgstr "Base Imponible+IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.sales_book_wizard_menu
+msgid "Print Sales Fiscal Report"
+msgstr "Imprimir Libro Ventas/Compras"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,rp_vat:0
+#: field:fiscal.reports.sale,rp_vat:0
+msgid "VAT Number"
+msgstr "Número IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.module.module,shortdesc:l10n_ve_fiscal_reports.module_meta_information
+msgid "Fiscal Report For Venezuela"
+msgstr "Reporte Fiscal para Venezuela"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Comprobante"
+msgstr "Comprobante"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,amount_with_vat_n_total:0
+msgid "Amount Withheld National"
+msgstr "Total Monto Retenido Nacional"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,period_id:0
+msgid "Period"
+msgstr "Periodo"
+
+#. module: l10n_ve_fiscal_reports
+#: view:sales.book.wizard:0
+msgid "General"
+msgstr "General"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,percent_with_vat_i:0
+#: field:adjustment.book.line,percent_with_vat_n:0
+msgid "% Withholding VAT"
+msgstr "Porcentaje(%) IVA retenido"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:adjustment.book.line,type_doc:0
+#: field:fiscal.reports.whs,ai_id:0
+msgid "Invoice"
+msgstr "Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: wizard_button:fiscal.reports.purchase.book_seniat_HG,init,end:0
+#: wizard_button:fiscal.reports.whp.wh_book_HG,init,end:0
+#: view:sales.book.wizard:0
+msgid "Cancel"
+msgstr "Cancelar"
+
+#. module: l10n_ve_fiscal_reports
+#: wizard_button:fiscal.reports.purchase.book_seniat_HG,init,print_report:0
+#: wizard_button:fiscal.reports.whp.wh_book_HG,init,print_report:0
+#: view:sales.book.wizard:0
+msgid "Print Report"
+msgstr "Imprimir Reporte"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,percent_with_vat_i:0
+msgid "Percent(%) VAT for international operations"
+msgstr "Porcentaje(%) de IVA para operaciones Internacionales"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,amount_with_vat_i_total:0
+msgid "Amount Withheld International"
+msgstr "Total Monto Retenido Inter."
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,period_id:0
+msgid "Period of adjustment book"
+msgstr "Periodo para el libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.report.xml,name:l10n_ve_fiscal_reports.report_whp_seniat
+msgid "Witholding Purchase SENIAT"
+msgstr "Retención Compra SENIAT"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "Ventas Exentas"
+msgstr "Ventas Exentas"
+
+#. module: l10n_ve_fiscal_reports
+#: help:account.invoice,date_document:0
+msgid "Administrative date"
+msgstr "Fecha administrativa"
+
+#. module: l10n_ve_fiscal_reports
+#: wizard_view:fiscal.reports.purchase.book_seniat_HG,init:0
+#: wizard_view:fiscal.reports.whp.wh_book_HG,init:0
+msgid "Seniat Book"
+msgstr "Libro SENIAT"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,amount_with_vat_total:0
+#: field:adjustment.book.line,amount_with_vat:0
+msgid "Amount Withholding VAT Total"
+msgstr "Total Retencion IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "del año"
+msgstr "del año"
+
+#. module: l10n_ve_fiscal_reports
+#: field:sales.book.wizard,control_start:0
+msgid "Control Start"
+msgstr "Control Start"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whp,rp_vat:0
+#: field:fiscal.reports.whs,rp_vat:0
+msgid "Vat Number"
+msgstr "Número IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: wizard_field:fiscal.reports.purchase.book_seniat_HG,init,model:0
+#: wizard_field:fiscal.reports.whp.wh_book_HG,init,model:0
+msgid "Type of Report"
+msgstr "Tipo de Reporte"
+
+#. module: l10n_ve_fiscal_reports
+#: view:adjustment.book:0
+msgid "Adjustment Book Lines"
+msgstr "Lineas del libro de Ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "%"
+msgstr "%"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,name:0
+msgid "Description"
+msgstr "Descripcion"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whp,ar_number:0
+msgid "Retention Number"
+msgstr "Número de Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_fr_main
+msgid "Fiscal Reporting For SENIAT"
+msgstr "Reporte Fiscal para SENIAT"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "IVA RETENIDO"
+msgstr "IVA Retenido"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.report.xml,name:l10n_ve_fiscal_reports.report_purchase_seniat
+msgid "Book Sales and Purchase SENIAT"
+msgstr "Libro de Ventas y Compras SENIAT"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,control_number:0
+msgid "Invoice control for adjustment book"
+msgstr "Numero de Factura para el libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Según Articulo 76 del Reglamento de la Ley del IVA 5.363 del 12 de Julio de 1999"
+msgstr "Según Articulo 76 del Reglamento de la Ley del IVA 5.363 del 12 de Julio de 1999"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,invoice_number:0
+#: field:fiscal.reports.purchase,ai_reference:0
+#: field:fiscal.reports.sale,ai_reference:0
+#: field:fiscal.reports.whp,ai_reference:0
+#: field:fiscal.reports.whs,ai_number:0
+#: field:fiscal.reports.whs,ai_reference:0
+msgid "Invoice Number"
+msgstr "Numero de Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.wizard,name:l10n_ve_fiscal_reports.wizard_recalc_taxes
+msgid "Recompute Taxes"
+msgstr "Recalcular Impuestos"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.whp.whp_seniat_HG:0
+msgid "% Ret"
+msgstr "% Ret"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,date_admin:0
+msgid "Date Administrative"
+msgstr "Fecha Administrativa"
+
+#. module: l10n_ve_fiscal_reports
+#: wizard_field:fiscal.reports.purchase.book_seniat_HG,init,date_end:0
+#: wizard_field:fiscal.reports.whp.wh_book_HG,init,date_end:0
+#: field:sales.book.wizard,date_end:0
+msgid "End Date"
+msgstr "Fecha Fin"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,amount_with_vat_i:0
+#: field:adjustment.book.line,amount_with_vat_n:0
+msgid "Amount Withholding VAT"
+msgstr "Monto de IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,amount_total:0
+msgid "Amount Total for adjustment book of invoice"
+msgstr "Monto Total"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,amount:0
+msgid "Amount document for adjustment book"
+msgstr "Monto del documento asociado."
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Doc"
+msgstr "Doc"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.purchase,ai_id:0
+#: field:fiscal.reports.sale,ai_id:0
+msgid "Invoice Description"
+msgstr "Descrip.Factura"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book,amount_with_vat_total:0
+msgid "Amount Total Withholding VAT for adjustment book"
+msgstr "Total Base Imponible+IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book,adjustment_ids:0
+#: view:adjustment.book.line:0
+msgid "Adjustment Book Line"
+msgstr "Lineas del libro de ajustes"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_reports.action_fiscal_reports_whs_tree
+msgid "whitholding Sales."
+msgstr "Retención Ventas."
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "Numero Fact. / DOC"
+msgstr "Numero Fact. / DOC"
+
+#. module: l10n_ve_fiscal_reports
+#: wizard_field:fiscal.reports.purchase.book_seniat_HG,init,date_start:0
+#: wizard_field:fiscal.reports.whp.wh_book_HG,init,date_start:0
+#: field:sales.book.wizard,date_start:0
+msgid "Start Date"
+msgstr "Fecha Inicio"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "BASE IMPONIBLE"
+msgstr "BASE IMPONIBLE"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.model,name:l10n_ve_fiscal_reports.model_sales_book_wizard
+msgid "sales.book.wizard"
+msgstr "sales.book.wizard"
+
+#. module: l10n_ve_fiscal_reports
+#: selection:fiscal.reports.whp.wh_book_HG,init,model:0
+msgid "Witholding Sales"
+msgstr "Retención Ventas"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.wizard,name:l10n_ve_fiscal_reports.wizard_sale_purchase_book
+msgid "Book Seniat"
+msgstr "Libro SENIAT"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "FECHA Y HORA DE IMPRESION:"
+msgstr "FECHA Y HORA DE IMPRESION:"
+
+#. module: l10n_ve_fiscal_reports
+#: help:adjustment.book.line,vat:0
+msgid "Vat of partner for adjustment book"
+msgstr "RIF de la empresa"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.actions.act_window,name:l10n_ve_fiscal_reports.sales_book_wizard_act
+#: view:sales.book.wizard:0
+msgid "Sales Book Report"
+msgstr "Libro de Ventas"
+
+#. module: l10n_ve_fiscal_reports
+#: field:fiscal.reports.whs,ar_id:0
+msgid "Retention"
+msgstr "Retención"
+
+#. module: l10n_ve_fiscal_reports
+#: field:adjustment.book.line,type_doc:0
+#: field:fiscal.reports.purchase,ai_type:0
+msgid "Document Type"
+msgstr "Tipo de Documento"
+
+#. module: l10n_ve_fiscal_reports
+#: rml:fiscal.reports.purchase.purchase_seniat_HG:0
+msgid "TOTAL CON IVA"
+msgstr "TOTAL CON IVA"
+
+#. module: l10n_ve_fiscal_reports
+#: model:ir.ui.menu,name:l10n_ve_fiscal_reports.menu_wizard_recompute_report
+msgid "Recompute Taxes."
+msgstr "Recalcule Impuestos."
+

=== added file 'l10n_ve_fiscal_reports/invoice.py'
--- l10n_ve_fiscal_reports/invoice.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/invoice.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,46 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
+#    All Rights Reserved
+###############Credits######################################################
+#    Coded by: Humberto Arocha           <[e-mail]>
+#              María Gabriela Quilarque  <[e-mail]>
+#              Javier Duran              <[e-mail]>
+#              Israel Fermín Montilla  <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+
+from osv import osv
+from osv import fields
+
+class inherited_invoice(osv.osv):
+    _inherit = "account.invoice"
+    _columns = {
+        'date_document': fields.date("Document Date", 
+                                help="Administrative date", 
+                                        select=True),
+        'date_invoice': fields.date('Fecha Contable', 
+                                    states={'open':[('readonly',True)],
+                                    'close':[('readonly',True)],
+                                    'paid':[('readonly',True)]},
+        help="Keep empty to use the current date\n It represent the date when we did account charge, known as Accounting Date too!"),
+        'expedient':fields.boolean('Expediente?', help="Seleccionar solo si la factura de compra es un expediente de importación"),
+        }
+inherited_invoice()

=== added file 'l10n_ve_fiscal_reports/invoice_view.xml'
--- l10n_ve_fiscal_reports/invoice_view.xml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/invoice_view.xml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record model="ir.ui.view" id="inherited_account_invoice_form_fiscal">
+            <field name="name">account.invoice.inherit.fiscal</field>
+            <field name="model">account.invoice</field>
+            <field name="inherit_id" ref="account.invoice_form"/>
+            <field name="arch" type="xml">
+                <data>
+                    <field name="date_invoice" position="after">
+                        <field name="date_document"/>
+                    </field>
+                </data>
+            </field>
+        </record>
+        
+        <record model="ir.ui.view" id="inherited_account_invoice_form_fiscal2">
+            <field name="name">account.invoice.inherit.fiscal2</field>
+            <field name="model">account.invoice</field>
+            <field name="inherit_id" ref="account.invoice_supplier_form"/>
+            <field name="arch" type="xml">
+                <data>
+                    <field name="date_due" position="after">
+                        <field name="expedient" attrs="{'readonly':[('type','in',['out_invoice','out_refund'])]}"/>
+                        <field name="date_document"/>
+                    </field>
+                </data>
+            </field>
+        </record>
+    </data>
+</openerp>
+

=== added file 'l10n_ve_fiscal_reports/l10n_ve_fiscal_reports.py'
--- l10n_ve_fiscal_reports/l10n_ve_fiscal_reports.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/l10n_ve_fiscal_reports.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,348 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) All Rights Reserved.
+#                    Javier Duran <[e-mail]>
+#                    Nhomar Hernandéz <[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.
+#
+##############################################################################
+
+'''
+Fiscal Report For Venezuela
+'''
+
+from osv import osv
+from osv import fields
+from tools.translate import _
+from tools import config
+from tools.sql import drop_view_if_exists
+import decimal_precision as dp
+
+class fiscal_reports_purchase(osv.osv):
+    '''
+    Modifying the object fiscal.reports.purchase
+    '''
+    _name = "fiscal.reports.purchase"
+    _description = "Purchase by period"
+    _auto = False
+    _rec_name = 'ai_nro_ctrl'
+    _order = 'ai_nro_ctrl asc'
+    _columns = {
+        'ai_date_document': fields.date('Date'),
+        'ai_date_invoice': fields.date('Date'),
+        'ar_date_document': fields.date('Date Account Retencion'),
+        'rp_vat':fields.char('VAT Number', size=24, required=False, readonly=True),
+        'rp_id':fields.many2one('res.partner', 'Partner Name', required=True),
+        'ai_nro_ctrl':fields.char('Control No.', size=128, required=False, readonly=True),
+        'ai_reference':fields.char('Invoice Number', size=128, required=False, readonly=True),
+        'ai_amount_total': fields.float('Amount Total', digits_compute= dp.get_precision('Fiscal Report')),
+        'ai_amount_untaxed': fields.float('Untaxed Amount', digits_compute= dp.get_precision('Fiscal Report')),
+        'ai_amount_tax': fields.float('Tax Amount', digits_compute= dp.get_precision('Fiscal Report')),
+        'ai_type':fields.char('Document Type', size=64, required=False, readonly=False),
+        'rp_retention': fields.float('Whitholding Rate', digits_compute= dp.get_precision('Fiscal Report')),
+        'ai_id':fields.many2one('account.invoice', 'Invoice Description', required=False),
+        'ar_line_id':fields.many2one('account.wh.iva.line', 'Account Retention', readonly=True),
+        'ar_id':fields.many2one('account.wh.iva', 'Account Retention', readonly=True),
+    }
+    def init(self, cr):
+        '''
+        Create or replace view fiscal_reports_purchase
+        '''
+        drop_view_if_exists(cr, 'fiscal_reports_purchase')
+        cr.execute("""
+            create or replace view fiscal_reports_purchase as (
+                SELECT
+                     ai."date_document" AS ai_date_document,
+                     ai."date_invoice" AS ai_date_invoice,
+                     rp."vat" AS rp_vat,
+                     rp."id" AS rp_id,
+                     ai."nro_ctrl" AS ai_nro_ctrl,
+                     ai."reference" AS ai_reference,
+                     ar."date_ret" AS ar_date_document,
+                case when ai.type='in_refund'
+                then
+                    ai."amount_total"*(-1)
+                else
+                    ai."amount_total" 
+                end as ai_amount_total,
+                case when ai.type='in_refund'
+                then
+                    ai."amount_untaxed"*(-1)
+                else
+                    ai."amount_untaxed" 
+                end as ai_amount_untaxed,
+                case when ai.type='in_refund'
+                then
+                    ai."amount_tax"*(-1)
+                else
+                    ai."amount_tax" 
+                end as ai_amount_tax,
+                     ai."type" AS ai_type,
+                     rp."wh_iva_rate" AS rp_retention,
+                     ai."id" AS id,
+                     ai."id" AS ai_id,
+                     ar_line."id" AS ar_line_id,
+                     ar_line."retention_id" AS ar_id
+                FROM
+                     "res_partner" rp INNER JOIN "account_invoice" ai ON rp."id" = ai."partner_id"
+                     LEFT JOIN "account_wh_iva_line" ar_line ON ar_line."invoice_id" = ai."id"
+                     LEFT JOIN "account_wh_iva" ar ON ar_line."retention_id" = ar."id"                                                     
+                WHERE
+                     (ai.type = 'in_refund'
+                  OR ai.type = 'in_invoice')
+                 AND (ai.state = 'open'
+                  OR ai.state = 'paid'
+                  OR ai.state = 'done')
+                ORDER BY
+                     ai_date_invoice ASC,
+                     ar."number" ASC
+                 )
+        """)
+fiscal_reports_purchase()  
+
+class fiscal_reports_sale(osv.osv):
+    '''
+    Modifying the object fiscal.reports.sales
+    '''
+    _name = "fiscal.reports.sale"
+    _description = "Sale by period"
+    _auto = False
+    _rec_name = 'ai_nro_ctrl'
+    _columns = {
+    'ai_date_document': fields.date('Date'),
+    'ai_date_invoice': fields.date('Date'),
+    'ar_date_document': fields.date('Date Account Retencion'),
+    'rp_vat':fields.char('VAT Number', size=64, required=False, readonly=False),
+    'rp_id':fields.many2one('res.partner', 'Partner Name', required=True),
+    'ai_reference':fields.char('Invoice Number', size=64, required=False, readonly=False),
+    'ai_nro_ctrl':fields.char('Control No.', size=64, required=False, readonly=False),
+    'ai_amount_total': fields.float('Amount Total', digits_compute= dp.get_precision('Fiscal Report')),
+    'ai_amount_untaxed': fields.float('Untaxed amount', digits_compute= dp.get_precision('Fiscal Report')),
+    'ai_amount_tax': fields.float('Tax Amount', digits_compute= dp.get_precision('Fiscal Report')),
+    'ai_type':fields.char('Type', size=64, required=False, readonly=False),
+    'rp_retention': fields.float('Withholding', digits_compute= dp.get_precision('Fiscal Report')),
+    'ai_id':fields.many2one('account.invoice', 'Invoice Description', required=False),
+    'ar_line_id':fields.many2one('account.wh.iva.line', 'Account Retention', readonly=True),
+    'ar_id':fields.many2one('account.wh.iva', 'Account Retention', readonly=True),
+    }
+    def init(self, cr):
+        '''
+        Create or replace view fiscal_reports_sale
+        '''   
+        drop_view_if_exists(cr, 'fiscal_reports_sale') 
+        cr.execute("""
+            create or replace view fiscal_reports_sale as (
+                SELECT
+                ai."date_document" AS ai_date_document,
+                ai."date_invoice" AS ai_date_invoice,
+                rp."vat" AS rp_vat,
+                rp."id" AS rp_id,
+                ai."number" AS ai_reference,
+                ai."nro_ctrl" AS ai_nro_ctrl,
+                ar."date_ret" AS ar_date_document,
+                case when ai.type='out_refund'
+                then
+                    ai."amount_total"*(-1)
+                else
+                    ai."amount_total" 
+                end as ai_amount_total,
+                case when ai.type='out_refund'
+                then
+                    ai."amount_untaxed"*(-1)
+                else
+                    ai."amount_untaxed" 
+                end as ai_amount_untaxed,
+                case when ai.type='out_refund'
+                then
+                    ai."amount_tax"*(-1)
+                else
+                    ai."amount_tax" 
+                end as ai_amount_tax,
+                ai."type" AS ai_type,
+                rp."wh_iva_rate" AS rp_retention,
+                ai."id" AS id,
+                ai."id" AS ai_id,
+                ar_line."id" AS ar_line_id,
+                ar_line."retention_id" AS ar_id
+                FROM
+                 "res_partner" rp INNER JOIN "account_invoice" ai ON rp."id" = ai."partner_id"
+                 LEFT JOIN "account_wh_iva_line" ar_line ON ar_line."invoice_id" = ai."id"
+                 LEFT JOIN "account_wh_iva" ar ON ar_line."retention_id" = ar."id"
+                WHERE
+                (ai.type = 'out_refund'
+                OR ai.type = 'out_invoice')
+                AND (ai.state = 'open'
+                OR ai.state = 'paid'
+                OR ai.state = 'done')
+                ORDER BY
+                ai_date_invoice ASC,
+                ai."nro_ctrl" ASC
+                )
+        """)
+fiscal_reports_sale()
+class fiscal_reports_whp(osv.osv):
+    '''
+    Modifying the object fiscal.reports.whp
+    '''
+    _name = "fiscal.reports.whp"
+    _description = "Purchase by period"
+    _auto = False
+    _rec_name = 'ai_nro_ctrl'
+    _columns = {
+    'ar_date_ret': fields.date('Date ret.', readonly=True),
+    'ai_date_inv': fields.date('Date Invoice'),
+    'ar_date_document': fields.date('Date Account Retencion'),
+    'rp_vat':fields.char('Vat Number', size=64, readonly=True),
+    'rp_id':fields.many2one('res.partner', 'Partner', readonly=True),
+    'ar_number':fields.char('Retention Number', size=64, required=False, readonly=True),
+    'ai_reference':fields.char('Invoice Number', size=64, required=False, readonly=True),
+    'ai_amount_total': fields.float('Amount Total', digits_compute= dp.get_precision('Fiscal Report')),
+    'ai_amount_untaxed': fields.float('Amount Untaxed', digits_compute= dp.get_precision('Fiscal Report'), readonly=True),
+    'ai_amount_tax': fields.float('Amount tax', digits_compute= dp.get_precision('Fiscal Report'), readonly=True),
+    'ar_line_id':fields.many2one('account.wh.iva.line', 'Account Retention', readonly=True),
+    'ai_id':fields.many2one('account.invoice', 'Account Invoice', readonly=True),
+    'ar_id':fields.many2one('account.wh.iva', 'Account Retention', readonly=True),
+    }
+    def init(self, cr):
+        '''
+        Create or replace view fiscal_reports_whp
+        '''    
+        drop_view_if_exists(cr, 'fiscal_reports_whp')
+        cr.execute("""
+            create or replace view fiscal_reports_whp as (
+                SELECT
+                     ar."date_ret" AS ar_date_ret,
+                     rp."vat" AS rp_vat,
+                     ar."number" AS ar_number,
+                     ai."reference" AS ai_reference,
+                     ai."date_invoice" AS ai_date_inv,
+                     ar."date" AS ar_date_document,
+                    case when ai.type='in_refund'
+                    then
+                        ai."amount_total"*(-1)
+                    else
+                        ai."amount_total" 
+                    end as ai_amount_total,
+                    case when ai.type='in_refund'
+                    then
+                        ai."amount_tax"*(-1)
+                    else
+                        ai."amount_tax" 
+                    end as ai_amount_tax,
+                    case when ai.type='in_refund'
+                    then
+                        ai."amount_untaxed"*(-1)
+                    else
+                        ai."amount_untaxed" 
+                    end as ai_amount_untaxed,
+                     ar_line."id" AS id,
+                     ar_line."id" AS ar_line_id,
+                     ar."id" AS ar_id,
+                     rp."id" AS rp_id,
+                     ai."id" AS ai_id
+                FROM
+                     "account_wh_iva_line" ar_line INNER JOIN "account_wh_iva" ar ON ar_line."retention_id" = ar."id"
+                     INNER JOIN "res_partner" rp ON ar."partner_id" = rp."id"
+                     INNER JOIN "account_invoice" ai ON ar_line."invoice_id" = ai."id"
+                WHERE
+                    ar."state" = 'done'
+                AND
+                    (ai."type" = 'in_invoice' OR ai."type" = 'in_refund')
+                    )
+        """)
+fiscal_reports_whp()
+
+class fiscal_reports_whs(osv.osv):
+    '''
+    Modifying the object fiscal.reports.whs
+    '''
+    _name = "fiscal.reports.whs"
+    _description = "Sale by period"
+    _auto = False
+    _rec_name = 'ai_nro_ctrl'
+    _columns = {
+    'ar_date_ret': fields.date('Date'),
+    'ai_date_inv': fields.date('Date Invoice'),
+    'ar_date_document': fields.date('Date Account Retencion'),
+    'rp_vat':fields.char('Vat Number', size=64, readonly=True),
+    'rp_id':fields.many2one('res.partner', 'Partner Name', readonly=True),
+    'ar_number':fields.char('WH Number', size=64, readonly=True),
+    'ai_number':fields.char('Invoice Number', size=64, readonly=True),
+    'ai_id':fields.many2one('account.invoice', 'Invoice', required=False, readonly=True),
+    'ai_amount_total': fields.float('Invoice Total', digits_compute= dp.get_precision('Fiscal Report'), readonly=True),
+    'ai_amount_untaxed': fields.float('Amount Untaxed', digits_compute= dp.get_precision('Fiscal Report'), readonly=True),
+    'ar_line_id':fields.many2one('account.wh.iva.line', 'Account Retention', readonly=True),
+    'ai_amount_tax': fields.float('Amount Tax', digits_compute= dp.get_precision('Fiscal Report'), readonly=True),
+    'ar_id':fields.many2one('account.wh.iva', 'Retention', required=False, readonly=True),
+    'ai_reference':fields.char('Invoice Number', size=64, required=False, readonly=True),
+    }
+    def init(self, cr):
+        '''
+        Create or replace view fiscal_reports_whs
+        '''    
+        drop_view_if_exists(cr, 'fiscal_reports_whs')
+        cr.execute("""
+            create or replace view fiscal_reports_whs as (
+                SELECT
+                     ar."date_ret" AS ar_date_ret,
+                     rp."vat" AS rp_vat,
+                     ar."number" AS ar_number,
+                     ai."number" AS ai_reference,
+                     ai."number" AS ai_number,
+                     ai."date_invoice" AS ai_date_inv,
+                     ar."date" AS ar_date_document,
+                    case when ai.type='out_refund'
+                    then
+                        ai."amount_total"*(-1)
+                    else
+                        ai."amount_total" 
+                    end as ai_amount_total,
+                    case when ai.type='out_refund'
+                    then
+                        ai."amount_tax"*(-1)
+                    else
+                        ai."amount_tax" 
+                    end as ai_amount_tax,
+                    case when ai.type='out_refund'
+                    then
+                        ai."amount_untaxed"*(-1)
+                    else
+                        ai."amount_untaxed" 
+                    end as ai_amount_untaxed,
+                     ar_line."id" AS id,
+                     ar_line."id" AS ar_line_id,
+                     ar."id" AS ar_id,
+                     rp."id" AS rp_id,
+                     ai."id" AS ai_id
+                FROM
+                     "account_wh_iva_line" ar_line INNER JOIN "account_wh_iva" ar ON ar_line."retention_id" = ar."id"
+                     INNER JOIN "res_partner" rp ON ar."partner_id" = rp."id"
+                     INNER JOIN "account_invoice" ai ON ar_line."invoice_id" = ai."id"
+                WHERE
+                    ar."state" = 'done'
+                AND
+                    (ai."type" = 'out_invoice' OR ai."type" = 'out_refund')
+                ORDER BY ar_date_ret
+                )
+        """)
+fiscal_reports_whs()

=== added directory 'l10n_ve_fiscal_reports/report'
=== added file 'l10n_ve_fiscal_reports/report/__init__.py'
--- l10n_ve_fiscal_reports/report/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/__init__.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,31 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) 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 book
+import wh_book

=== added file 'l10n_ve_fiscal_reports/report/book.py'
--- l10n_ve_fiscal_reports/report/book.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/book.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,418 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+# Copyright (c) 2010 Vauxoo C.A. (http://openerp.com.ve/) 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.
+#
+##############################################################################
+
+'''
+Fiscal Report For Venezuela
+'''
+
+import time
+from report import report_sxw
+from osv import osv
+import pooler
+
+class pur_sal_book(report_sxw.rml_parse):
+    '''
+    Book generates purchase and sale
+    '''
+
+    def __init__(self, cr, uid, name, context):
+        '''
+        Reference to the current instance
+        '''
+        super(pur_sal_book, self).__init__(cr, uid, name, context)    
+        self.localcontext.update({
+            'time': time,
+            'get_data':self._get_data,
+            'get_partner_addr': self._get_partner_addr,
+            'get_p_country': self._get_p_country,
+            'get_rif': self._get_rif,
+            'get_month':self._get_month,
+            'get_doc':self._get_doc,
+            'get_ret':self._get_ret,
+            'get_data_adjustment': self._get_data_adjustment,
+            'validation': self._validation,
+            'get_data_wh': self._get_data_wh,
+            'get_amount_withheld': self._get_amount_withheld,
+            'get_date_wh': self._get_date_wh,
+            'get_v_sdcf': self._get_v_sdcf,
+            'get_tax_line': self._get_tax_line,
+            'get_total_wh': self._get_total_wh,
+            'get_total_iva': self._get_total_iva,
+            'get_amount_untaxed_tax': self._get_amount_untaxed_tax,
+            'get_taxes': self._get_taxes,
+            'get_wh_actual': self._get_wh_actual,
+            'get_id': self._get_id,
+            'get_papel_anulado': self._get_papel_anulado,
+        })
+
+    def _get_id(self,form,idh,type=None):
+        x=1
+        ids =None
+        
+        if form['type']=='sale':
+            ids = self._get_data_wh(form)
+        if form['type']=='sale' and type:
+            x+=len(ids)
+        if type=='book':
+            ids = self._get_data(form)
+
+        for a in ids:
+            if a.id != idh:
+                x+=1
+            else:
+                return x
+
+    def _get_book_type(self,form):
+        book_type=None
+        book_type='fiscal.reports.sale'
+        if form['type']=='purchase':
+            book_type='fiscal.reports.purchase'
+        
+        return book_type
+
+    def _get_book_type_wh(self,form):
+        book_type=None
+        book_type='fiscal.reports.whs'
+        if form['type']=='purchase':
+            book_type='fiscal.reports.whp'
+        return book_type
+
+    def _validation(self,form):
+        type_doc = 'sale'
+        if form['type']=='purchase':
+            type_doc = 'purchase'
+        period_obj=self.pool.get('account.period')
+        adjust_obj = self.pool.get('adjustment.book')
+        period_ids = period_obj.search(self.cr,self.uid,[('date_start','<=',form['date_start']),('date_stop','>=',form['date_end'])])
+        if len(period_ids)<=0:
+            return False
+        fr_ids = adjust_obj.search(self.cr,self.uid,[('period_id','in',period_ids),('type','=',type_doc)])
+        if len(fr_ids)<=0:
+            return False
+        return True
+        
+    def _get_data_adjustment(self,form):
+
+        type_doc = 'sale'
+        if form['type']=='purchase':
+            type_doc = 'purchase'
+        adjust_obj = self.pool.get('adjustment.book')
+        adjust_line_obj = self.pool.get('adjustment.book.line')
+        period_obj=self.pool.get('account.period')
+        data=[]
+        data_line=[]
+        period_ids = period_obj.search(self.cr,self.uid,[('date_start','<=',form['date_start']),('date_stop','>=',form['date_end'])])
+        
+        if len(period_ids)>0:
+            fr_ids = adjust_obj.search(self.cr,self.uid,[('period_id', 'in',period_ids),('type','=',type_doc)])
+            if len(fr_ids)>0:
+                adj_ids = adjust_line_obj.search(self.cr,self.uid,[('adjustment_id','=',fr_ids[0])],order='date_admin')
+                data = adjust_obj.browse(self.cr,self.uid, fr_ids)
+                data_line = adjust_line_obj.browse(self.cr,self.uid, adj_ids)
+        return (data,data_line)
+
+    def _get_date_wh(self,form, l):
+        if l.ar_date_document> form['date_end']:
+            return False
+        return True
+
+    def _get_papel_anulado(self,data,l,tipo=None):
+        
+        if l.ai_id.name:
+            if l.ai_id.name.find('PAPELANULADO')>=0: 
+                return tipo
+            else: 
+                return data
+        else:
+            return data
+        return tipo
+
+    def _get_v_sdcf(self,l):
+        amount = 0.0
+        if not l:
+            return 0.0
+        for tax in l.ai_id.tax_line:
+            name=tax.name
+            if name.find('SDCF')>=0:
+                amount = tax.base+amount
+                if l.ai_id.type in ['in_refund', 'out_refund']:
+                    amount = amount * (-1)
+        return (amount)
+
+    def _get_tax_line(self,s):
+        name = s.name
+        cont = 0
+        if name.find('SDCF')>=0:
+            if cont==0:
+                return 0
+        else:
+            cont = cont + 1
+        return s.base_amount
+    
+    def _get_data(self,form):
+        data=[]
+        orden='ai_nro_ctrl'
+        
+        book_type = self._get_book_type(form)
+        fr_obj = self.pool.get(book_type)
+        
+        if book_type=='fiscal.reports.purchase':
+            orden='ai_date_document'
+        fr_ids = fr_obj.search(self.cr,self.uid,[('ai_date_invoice', '<=', form['date_end']), ('ai_date_invoice', '>=', form['date_start'])], order=orden)
+        
+        if len(fr_ids)<=0:
+            return False
+        data = fr_obj.browse(self.cr,self.uid, fr_ids)
+        return data
+
+    def _get_data_wh(self,form):
+        data=[]
+        d1=form['date_start']
+        d2=form['date_end']
+        fr_obj = self.pool.get('fiscal.reports.whs')
+        fr_ids = fr_obj.search(self.cr,self.uid,[('ar_date_ret', '<=', d2), ('ar_date_ret', '>=',d1),('ar_date_document','<=',d1)], order='ar_date_ret')
+        data = fr_obj.browse(self.cr,self.uid, fr_ids)
+        return data
+
+    def _get_total_wh(self,form,actual=None):
+        total=0
+        data=[]
+        book_type= self._get_book_type_wh(form)
+        fr_obj = self.pool.get(book_type)
+        
+        fr_ids = fr_obj.search(self.cr,self.uid,[('ar_date_ret', '<=', form['date_end']), ('ar_date_ret', '>=', form['date_start'])])
+        
+        data = fr_obj.browse(self.cr,self.uid, fr_ids)
+        for wh in data:
+            if wh.ai_id.type in ['in_refund', 'out_refund']:
+                total+= wh.ar_line_id.amount_tax_ret * (-1)
+            else:
+                total+= wh.ar_line_id.amount_tax_ret
+        return total
+
+
+    def _get_wh_actual(self,form):
+        total=0
+        data=[]
+        book_type= self._get_book_type_wh(form)
+        fr_obj = self.pool.get(book_type)
+        
+        fr_ids = fr_obj.search(self.cr,self.uid,[('ar_date_ret', '<=', form['date_end']),('ar_date_ret', '>=', form['date_start']),('ai_date_inv','>=',form['date_start']),('ai_date_inv','<=',form['date_end'])])
+        data = fr_obj.browse(self.cr,self.uid, fr_ids)
+        for wh in data:
+            if wh.ai_id.type in ['in_refund', 'out_refund']:
+                total+= wh.ar_line_id.amount_tax_ret * (-1)
+            else:
+                total+= wh.ar_line_id.amount_tax_ret
+        return total
+
+
+
+    def _get_ret(self,form,ret_id=None):
+        '''
+            Ensure that Withholding date is inside period specified on form.
+        '''
+        d1=form['date_start']
+        d2=form['date_end']
+        if form['type']=='purchase':
+            if ret_id:
+                ret_obj = self.pool.get('account.retention')
+                rets = ret_obj.browse(self.cr,self.uid,[ret_id])
+                return rets[0].number
+        if ret_id:
+            ret_obj = self.pool.get('account.retention')
+            rets = ret_obj.browse(self.cr,self.uid,[ret_id])
+            if rets:
+                if time.strptime(rets[0].date, '%Y-%m-%d') >= time.strptime(d1, '%Y-%m-%d') \
+                and time.strptime(rets[0].date, '%Y-%m-%d') <=  time.strptime(d2, '%Y-%m-%d'):
+                    return rets[0].number
+                else:
+                    return False
+            else:
+                return False
+        else:
+            return False
+
+    def _get_amount_withheld(self,wh_line_id):
+        wh_obj = self.pool.get('account.retention.line')
+        data = wh_obj.browse(self.cr,self.uid, [wh_line_id])[0]
+        return data.amount_tax_ret
+
+    def _get_partner_addr(self, idp=None):
+        '''
+        Obtains the address of partner
+        '''
+        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_p_country(self, idp=None):
+        '''
+        Obtains the address of partner
+        '''
+        if not idp:
+            return []
+
+        addr_obj = self.pool.get('res.partner.address')
+        a_id = 1000
+        a_ids = addr_obj.search(self.cr,self.uid,[('partner_id','=',idp), ('type','=','invoice')])
+        if a_ids:
+            a = addr_obj.browse(self.cr,self.uid, a_ids[0])
+            a_id = a.country_id.id
+        return a_id 
+
+    def _get_doc(self, inv_id=None):
+        '''
+        Get String Document Type
+        '''
+        inv_obj = self.pool.get('account.invoice')
+        inv_ids = inv_obj.search(self.cr,self.uid,[('id', '=', inv_id)])
+        inv = inv_obj.browse(self.cr,self.uid, inv_ids)[0]        
+        doc_type = ''
+        if (inv.type=="in_invoice" or inv.type=="out_invoice") and inv.parent_id:
+            doc_type = "ND"
+        elif (inv.type=="in_invoice" or inv.type=="in_refund") and inv.expedient:
+            doc_type="E"
+        elif inv.type=='in_refund' or inv.type=='out_refund':
+            doc_type = "NC"
+        elif inv.type=="in_invoice" or inv.type=="out_invoice":
+            doc_type = "F"
+        return doc_type
+
+    def _get_rif(self, vat=''):
+        '''
+        Get R.I.F.
+        '''
+        if not vat:
+            return []
+        return vat[2:].replace(' ', '')
+
+    def _get_month(self, form):
+        '''
+        return year and month
+        '''
+        months=["Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
+        res = ['',0]
+        res[0] = months[time.strptime(form['date_start'],"%Y-%m-%d")[1]-1]
+        res[1] = time.strptime(form['date_start'],"%Y-%m-%d")[0]
+        return res
+
+    def _get_total_iva(self,form):
+        '''
+        Return Amount Total of each invoice at Withholding Vat
+        '''
+        book_type= self._get_book_type(form)
+        
+        sql =   ''' select sum(ai_amount_total) as total 
+                    from %s 
+                    where ai_date_invoice>= '%s' and ai_date_invoice<='%s' 
+                ''' % (book_type.replace('.','_'),form['date_start'],form['date_end'])
+        self.cr.execute(sql)
+        
+        res = self.cr.dictfetchone()
+        return res['total']
+
+    def _get_amount_untaxed_tax(self,form,percent,nationality=''):
+        '''
+        Return Amount Untaxed and Amount Tax, accorded percent of withholding vat
+        '''
+        amount_untaxed=0.0
+        amount_tax=0.0
+
+        book_type=self._get_book_type(form)
+    
+        fr_obj = self.pool.get(book_type)
+        user_obj = self.pool.get('res.users')
+        
+        user_ids = user_obj.search(self.cr,self.uid,[('id', '=', self.uid)])
+        fr_ids = fr_obj.search(self.cr,self.uid,[('ai_date_invoice', '<=', form['date_end']), ('ai_date_invoice', '>=', form['date_start'])])
+
+        user=user_obj.browse(self.cr,self.uid, [self.uid])
+        
+        for d in fr_obj.browse(self.cr,self.uid, fr_ids):
+            for tax in d.ai_id.tax_line:
+                
+                if percent in tax.name:
+                    if nationality=='nacional':
+                        if self._get_p_country(user[0].company_id.partner_id.id)==self._get_p_country(d.ai_id.partner_id.id):
+                            amount_untaxed+= self._get_amount_untaxed_tax2(d.ai_id.type,tax)[0]
+                            amount_tax+= self._get_amount_untaxed_tax2(d.ai_id.type,tax)[1]
+                    else:
+                        if self._get_p_country(user[0].company_id.partner_id.id)!=self._get_p_country(d.ai_id.partner_id.id):
+                            amount_untaxed+= self._get_amount_untaxed_tax2(d.ai_id.type,tax)[0]
+                            amount_tax+= self._get_amount_untaxed_tax2(d.ai_id.type,tax)[1]
+
+        return (amount_untaxed,amount_tax)
+
+
+    def _get_amount_untaxed_tax2(self,type,tax):
+        amount_untaxed=0.0
+        amount_tax=0.0
+        if type in ['in_refund', 'out_refund']:
+            amount_untaxed= tax.base * (-1)
+            amount_tax= tax.amount * (-1)
+        else:
+            amount_untaxed= tax.base
+            amount_tax= tax.amount
+        return [amount_untaxed,amount_tax]
+
+    def _get_taxes(self,l):
+        
+        tax_obj = self.pool.get('account.invoice.tax')
+        tax_ids = tax_obj.search(self.cr,self.uid,[('invoice_id', '=', l.ai_id.id)])
+        
+        tam = len(tax_ids)
+        data = tax_obj.browse(self.cr,self.uid, tax_ids)
+        
+        for tax in data:
+            if 'SDCF' in tax.name and tam>=2:
+                tax_ids.remove(tax.id)
+        
+        data = tax_obj.browse(self.cr,self.uid, tax_ids)
+        
+        if len(data)<=0:
+            return False
+        return data
+
+
+report_sxw.report_sxw(
+    'report.fiscal.reports.purchase.purchase_seniat',
+    'fiscal.reports.purchase',
+    'addons/l10n_ve_fiscal_reports/report/book_seniat.rml',
+    parser=pur_sal_book,
+    header=False
+)      

=== added file 'l10n_ve_fiscal_reports/report/book_seniat.rml'
--- l10n_ve_fiscal_reports/report/book_seniat.rml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/book_seniat.rml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,673 @@
+<?xml version="1.0"?>
+<document filename="test.pdf" invariant="1">
+  <template pageSize="(825.0,612.0)" title="Test" author="Martin Simon" allowSplitting="20" showBoundary="0">
+    <pageTemplate id="first">
+        
+        <pageGraphics>
+            <setFont name="Helvetica" size="9"/>
+            <drawString x="1.3cm" y="0.5cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString>
+            <drawString x="25cm" y="0.5cm">Pagina <pageNumber/></drawString>
+            <lineMode width="0.7"/>
+            <lines>1.3cm 24.9cm 38.3cm 24.9cm</lines>
+            <setFont name="Helvetica" size="8"/>
+        </pageGraphics>
+    <frame id="first" x1="5.0" y1="15.0" width="815" height="580"/>
+    </pageTemplate>
+    
+    
+  </template>
+  <stylesheet>
+    <blockTableStyle id="HEADERTABLE">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" thickness="1" start="0,0" stop="14,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="HEADERTABLE_AD">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" thickness="1" start="0,3" stop="14,3"/>
+    </blockTableStyle>
+    <blockTableStyle id="INTERNALTABLE">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="MIDDLE"/>
+    </blockTableStyle>
+    <blockTableStyle id="CONTENIDOTABLE">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="1,1" stop="-1,-1"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="-5,0" stop="-4,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="ENCANBEZADO">
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="10,0" stop="11,0"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="0,1" stop="-1,-1"/>
+        <blockBackground colorName="#e5e2e5" start="0,1" stop="-1,1"/>
+    </blockTableStyle>
+    <blockTableStyle id="ENCANBEZADO_SINCOLUM">
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="10,0" stop="11,0"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="1,1" stop="-1,-1"/>
+        <blockBackground colorName="#e5e2e5" start="1,1" stop="-1,1"/>
+    </blockTableStyle>
+    <blockTableStyle id="TOTALS_TABLE">
+      <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="0,0" stop="-1,-1"/>
+        <blockBackground colorName="#e5e2e5" start="0,0" stop="-1,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="CONTENIDOTABLE_PUR">
+      <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="0,1" stop="-1,-1"/>
+        <lineStyle kind="GRID" colorName="black" thickness="1" start="-4,0" stop="-3,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="CONTENIDOTABLE_TITULOS">
+        <blockAlignment value="LEFT"/>
+        <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" start="1,0" stop="-1,-1" thickness="0.5"/>
+        <blockBackground colorName="#e5e2e5" start="1,0" stop="-1,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="CONTENIDOTABLE_TITULOS_PUR">
+        <blockAlignment value="LEFT"/>
+        <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" start="0,0" stop="-1,-1" thickness="0.5"/>
+        <blockBackground colorName="#e5e2e5" start="0,0" stop="-1,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="CONTENIDOTABLE_LINES">
+        <blockAlignment value="LEFT"/>
+        <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" start="1,0" stop="-1,-1" thickness="0.5"/>
+    </blockTableStyle>
+    <blockTableStyle id="CONTENIDOTABLE_LINES_PUR">
+        <blockAlignment value="LEFT"/>
+        <blockValign value="MIDDLE"/>
+        <lineStyle kind="GRID" colorName="black" start="0,0" stop="-1,-1" thickness="0.5"/>
+    </blockTableStyle>
+    
+    <initialize>
+      <alias id="style.normal" value="style.Normal"/>
+    </initialize>
+    <paraStyle name="P1" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER"/>
+    <paraStyle name="P2" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER"/>
+    <paraStyle name="P3" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER"/>
+    <paraStyle name="P4" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER" textColor="#ffffff"/>
+    <paraStyle name="P5" fontName="Helvetica" fontSize="6.0" leading="8"/>
+    <paraStyle name="CONTENIDO" fontName="Helvetica" fontSize="6.0" leading="6" alignment="CENTER"/>
+    <paraStyle name="TITULO_AJUSTE" fontName="Helvetica" fontSize="10.0" alignment="CENTER"/>
+    <paraStyle name="CONTENIDOINT" fontName="Helvetica" fontSize="6.0" leading="1" alignment="CENTER"/>
+    <paraStyle name="CONTENIDOLEFT" fontName="Helvetica" fontSize="6.0" leading="6" alignment="LEFT"/>
+    <paraStyle name="OBSERVACIONES" fontName="Helvetica" fontSize="9.0"  alignment="LEFT"/>
+    <paraStyle name="HEADERDOC" fontName="Helvetica-bold" fontSize="8.0" leading="8" alignment="JUSTIFY"/>
+    <paraStyle name="HEADER" fontName="Helvetica-bold" fontSize="6.0" leading="6" alignment="CENTER"/>
+    <paraStyle name="CONTENIDOLEFT_BOLD" fontName="Helvetica-bold" fontSize="6.0" leading="6" alignment="LEFT"/>
+    <paraStyle name="P7" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER"/>
+    <paraStyle name="P8" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER" textColor="#ffffff"/>
+    <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="Table Contents" fontName="Times-Roman"/>
+    <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
+  </stylesheet>
+  <images/>
+
+  <story>
+    <blockTable colWidths="350.0,190.0,220.0" style="HEADERTABLE">
+      <tr>
+        [[ setLang(l.ai_id.company_id.partner_id.lang) ]]
+        <td>
+          <para style="HEADERDOC">[[ company.partner_id.name ]] [[ company.partner_id.vat[2:] ]]</para>
+          <para style="HEADERDOC">[[ get_partner_addr( company.partner_id.id ) ]]</para>
+        </td>
+        <td>
+          <para style="HEADERDOC">Libro: [[ (data['form']['type'] == 'purchase') and "Compras"or "Ventas" ]] </para>
+          <para style="HEADERDOC">Correspodiente al Mes de [[ get_month( data['form'] )[0] ]] del año [[ get_month( data['form'] )[1] ]]</para>
+          <para style="HEADERDOC">[[data['form'] and ('Desde: %s'%formatLang( data['form']['date_start'], date=True)) or '']]</para>
+          <para style="HEADERDOC">[[data['form'] and ('Hasta: %s'%formatLang( data['form']['date_end'], date=True)) or '']]</para>
+        </td>
+        <td>
+          <para style="HEADERDOC" fontName="Helvetica">Según Articulo 76 del Reglamento de la Ley del IVA No. 5.363 del 12 de Julio de 1999</para>
+        </td>
+      </tr>
+    </blockTable>
+    <spacer length="2mm"/>
+          <!-- ****************************************-->
+          <!-- ********* SALE, PURCHASE, BOOK *********-->
+          <!-- ****************************************-->
+    <section>
+        <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0" style="ENCANBEZADO_SINCOLUM" repeatRows="2">
+        [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0",'style':'ENCANBEZADO', 'repeatRows':'2'}) or '']]
+        <tr>
+            <td></td><td></td><td></td><td></td>
+            <td></td><td></td><td></td><td></td>
+            <td></td><td></td>
+            <td>
+                <blockTable colWidths="110.0" style="INTERNALTABLE">
+                    <tr><td vAlign="MIDDLE"><para style="HEADER">Operaciones Nacionales</para></td></tr>
+                </blockTable>
+            </td>
+            <td>
+                <blockTable colWidths="110.0" style="INTERNALTABLE">
+                    <tr><td vAlign="MIDDLE"><para style="HEADER">Operaciones Internacionales</para></td></tr>
+                </blockTable>
+            </td>
+            <td></td><td></td><td></td>
+        </tr>
+        <tr>
+            <td><para style="HEADER">[[ (data['form']['type'] == 'purchase') and 'Fecha Adm.' or '' ]]</para></td>
+            <td><para style="HEADER">Fecha Cont.</para></td>
+            <td><para style="HEADER">RIF</para></td>
+            <td><para style="HEADER">Razon Social</para></td>
+            <td><para style="HEADER">Numero Doc.</para></td>
+            <td><para style="HEADER">Numero Control</para></td>
+            <td><para style="HEADER">Total con IVA</para></td>
+            <td><para style="HEADER">T. Doc.</para></td>
+            <td><para style="HEADER">Documento Afectado</para></td>
+            <td><para style="HEADER">Sin derecho a Credito Fiscal</para></td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="HEADER">Base Imponible</para></td>
+                        <td><para style="HEADER">%</para><para style="HEADER">IVA</para></td>
+                        <td><para style="HEADER">Monto</para><para style="HEADER">Impuesto</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="HEADER">Base Imponible</para></td>
+                        <td><para style="HEADER">%</para><para style="HEADER">IVA</para></td>
+                        <td><para style="HEADER">Monto</para><para style="HEADER">Impuesto</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td><para style="HEADER">Retencion Iva</para></td>
+            <td><para style="HEADER">Comprobante</para></td>
+            <td><para style="HEADER">Linea</para></td>
+        </tr>
+        </blockTable>
+    </section>
+
+    <!-- ************ WITHHOLDING VAT BOOK LINES************-->
+    <section>
+        <para>[[repeatIn( get_data_wh(data['form']),'wh')]]</para>
+        <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0" style="CONTENIDOTABLE_LINES" repeatRows="2">
+        [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0",'style':'CONTENIDOTABLE_LINES_PUR', 'repeatRows':'2'}) or '']]
+        <tr>
+            <para>[[ (data['form']['type'] == 'sale') and '.' or removeParentNode('blockTable') ]]</para>
+            [[ setLang(company.partner_id.lang) ]]
+            <td><para style="CONTENIDO">[[ (data['form']['type'] == 'purchase') and wh.ai_id.date_document or '' ]]</para></td>
+            <td><para style="CONTENIDO">[[ time.strftime('%d/%m/%Y', time.strptime(wh.ar_date_ret, '%Y-%m-%d'))]]</para></td>
+            <td><para style="CONTENIDO">[[ get_rif(wh.rp_vat) ]]</para></td>
+            <td><para style="CONTENIDOLEFT">[[ wh.rp_id.name ]]</para></td>
+            <td><para style="CONTENIDO">-----</para></td>
+            <td><para style="CONTENIDO">-----</para></td>
+            <td><para style="CONTENIDO">0.00</para></td>
+            <td><para style="CONTENIDO">-</para></td>
+            <td><para style="CONTENIDO">-----</para></td>
+            <td><para style="CONTENIDO">0.00</para></td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="CONTENIDO">0.00</para></td>
+                        <td><para style="CONTENIDO">0.00</para></td>
+                        <td><para style="CONTENIDO">0.00</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="CONTENIDO">0.00</para></td>
+                        <td><para style="CONTENIDO">0.00</para></td>
+                        <td><para style="CONTENIDO">0.00</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td><para style="CONTENIDO">[[ formatLang(get_amount_withheld(wh.ar_line_id.id)) or '' ]]</para></td>
+            <td><para style="CONTENIDO">[[ wh.ar_id.number ]]</para></td>
+            <td><para style="CONTENIDO">[[ get_id(data['form'],wh.id) ]]</para></td>
+        </tr>
+        </blockTable>
+    </section>
+
+   <!-- ************ PURCHASE, SALE, BOOK LINES************-->
+    <section>
+        <para>[[repeatIn( get_data( data['form'] ),'l')]]</para>
+        <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0" style="CONTENIDOTABLE_LINES" repeatRows="2">
+        [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0",'style':'CONTENIDOTABLE_LINES_PUR', 'repeatRows':'2'}) or '']]
+        <tr>
+            [[ setLang(l.ai_id.company_id.partner_id.lang) ]]
+            <td><para style="CONTENIDO">[[ data['form']['type'] == 'purchase' and ( l.ai_id.date_document and formatLang(l.ai_id.date_document, date=True) or '') or '' ]]</para></td>
+            <td><para style="CONTENIDO">[[ time.strftime('%d/%m/%Y', time.strptime(l.ai_date_invoice, '%Y-%m-%d')) ]]</para></td>
+            <td><para style="CONTENIDO">[[ get_papel_anulado(l.rp_id.vat[2:],l,'-----')]]</para></td>
+            <td><para style="CONTENIDOLEFT">[[ get_papel_anulado(l.rp_id.name,l,'ANULADO')]]</para></td>
+            <td><para style="CONTENIDO">[[ get_papel_anulado(l.ai_reference,l,'-----')]]</para></td>
+            <td><para style="CONTENIDO">[[ l.ai_id.nro_ctrl ]]</para></td>
+            <td><para style="CONTENIDO">[[ formatLang((l.ai_id.type in ['in_refund', 'out_refund']) and l.ai_amount_total*(-1) or l.ai_amount_total) ]]</para></td>
+            <td><para style="CONTENIDO">[[ get_doc(l.ai_id.id) ]]</para></td>
+            <td><para style="HEADER">[[ (data['form']['type'] == 'purchase') and l.ai_id.parent_id.reference or l.ai_id.parent_id.number ]]</para></td>
+            <td><para style="CONTENIDO">[[ formatLang(get_v_sdcf(l)) ]]</para></td>
+            <td>  
+                <section>
+                    <para>[[ repeatIn(get_taxes(l) and get_taxes(l) or [0.0],'s')]]</para> 
+                    <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                        <tr>
+                            <td><para style="CONTENIDOINT">[[ formatLang((get_p_country(company.partner_id.id) == get_p_country(s.invoice_id.partner_id.id)) and get_tax_line(s) or 0.0) ]]</para></td>
+                            <td><para style="CONTENIDOINT">[[ formatLang((get_p_country(company.partner_id.id) == get_p_country(s.invoice_id.partner_id.id)) and round(s.tax_amount/(s.base_amount and s.base_amount or 1)*100.0) or 0.0) ]]</para></td>
+                            <td><para style="CONTENIDOINT">[[ formatLang((get_p_country(company.partner_id.id) == get_p_country(s.invoice_id.partner_id.id)) and s.tax_amount or 0.0) ]]</para></td>
+                        </tr>
+                    </blockTable>
+                </section>
+            </td>
+            <td>
+            <section>
+            <para>[[ repeatIn(get_taxes(l) and get_taxes(l) or [0.0],'t')]]</para> 
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="CONTENIDOINT">[[ formatLang((get_p_country(company.partner_id.id) != get_p_country(t.invoice_id.partner_id.id)) and get_tax_line(t) or 0.0) ]]</para></td>
+                        <td><para style="CONTENIDOINT">[[ formatLang((get_p_country(company.partner_id.id) != get_p_country(t.invoice_id.partner_id.id)) and t.tax_amount/(t.base_amount and t.base_amount or 1)*100.0 or 0.0) ]]</para></td>
+                        <td><para style="CONTENIDOINT">[[ formatLang((get_p_country(company.partner_id.id) != get_p_country(t.invoice_id.partner_id.id)) and t.tax_amount or 0.0) ]]</para></td>
+                    </tr>
+                </blockTable>
+            </section>
+            </td>
+            <td><para style="CONTENIDO">[[ get_date_wh(data['form'],l) and (get_ret(data['form'], l.ar_id and l.ar_id.id) and (formatLang(((l.ai_id.type in ['in_refund', 'out_refund']) and (get_amount_withheld(l.ar_line_id.id)*(-1)) or get_amount_withheld(l.ar_line_id.id)))) or '') or '']]</para></td>
+            <td><para style="CONTENIDO">[[ get_date_wh(data['form'],l) and (get_ret(data['form'],l.ar_id and l.ar_id.id) and l.ar_id.number or '') or '' ]]</para></td>
+            <td><para style="CONTENIDO">[[ get_id(data['form'],l.id,'book') ]]</para></td>
+        </tr>
+        </blockTable>
+    </section>
+
+
+        <!-- ************ TOTALS PURCHASE,SALE PARCIALES************-->
+    <section>
+        <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0" style="CONTENIDOTABLE_LINES" repeatRows="2">
+        [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0,18.0",'style':'CONTENIDOTABLE_LINES_PUR', 'repeatRows':'2'}) or '']]
+        <tr>
+            [[ setLang(l.ai_id.company_id.partner_id.lang) ]]
+            <td></td><td></td>
+            <td></td><td></td>
+            <td></td><td></td>
+            <td><para style="CONTENIDO">[[ formatLang(get_total_iva(data['form'])) ]]</para></td>
+            <td></td><td></td>
+            <td><para style="CONTENIDO">[[ formatLang(get_amount_untaxed_tax(data['form'],'SDCF','nacional')[0])]]</para></td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="HEADER">[[ formatLang(get_amount_untaxed_tax(data['form'],'12','nacional')[0]+get_amount_untaxed_tax(data['form'],'8','nacional')[0]+get_amount_untaxed_tax(data['form'],'EXONERADO','nacional')[0]) ]]</para></td>
+                        <td></td>
+                        <td><para style="HEADER">[[ formatLang(get_amount_untaxed_tax(data['form'],'12','nacional')[1] +get_amount_untaxed_tax(data['form'],'8','nacional')[1]+get_amount_untaxed_tax(data['form'],'EXONERADO','nacional')[1]) ]]</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="HEADER">[[ formatLang(get_amount_untaxed_tax(data['form'],'12')[0]+get_amount_untaxed_tax(data['form'],'8')[0]+get_amount_untaxed_tax(data['form'],'EXONERADO')[0]) ]]</para></td>
+                        <td></td>
+                        <td><para style="HEADER">[[ formatLang(get_amount_untaxed_tax(data['form'],'12')[1] +get_amount_untaxed_tax(data['form'],'8')[1]+get_amount_untaxed_tax(data['form'],'EXONERADO')[1]) ]]</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td><para style="CONTENIDO">[[ formatLang(get_total_wh(data['form'])) ]]</para></td>
+            <td></td>
+            <td></td>
+        </tr>
+        </blockTable>
+    </section>
+
+    <!-- ************ LEYENDA************-->
+    <section>
+        <blockTable colWidths="794.0">
+            <tr>
+                <td><para style="CONTENIDOLEFT">LEYENDA. F:Factura, ND:Nota de Débito, NC:Nota de Crédito, E:Expediente</para></td>
+            </tr>
+        </blockTable>
+    </section>
+
+    <spacer length='5mm'/>
+
+    <!-- ************ TOTALS WHITHHOLDING***********-->
+    
+    <section>
+        [[data['form']['type'] == 'sale' and '.' or removeParentNode('section')]]
+        <blockTable colWidths="70mm,40mm" style="TOTALS_TABLE" repeatRows="2">
+            <tr>
+                <td><para style="HEADER">[[data['form']['type'] == 'sale' and 'RESUMEN RETENCIONES' or removeParentNode('tr')]]</para></td>
+                <td><para style="HEADER">RET. DEBITO FISCAL</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'sale' and 'RETENCIONES PERIODOS ANTERIORES' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[ formatLang(get_total_wh(data['form'])-get_wh_actual(data['form'])) ]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'sale' and 'RETENCIONES DEL PERIODO' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[ formatLang(get_wh_actual(data['form'])) ]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT_BOLD">[[data['form']['type'] == 'sale' and 'TOTAL RETENCIONES' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[ formatLang(get_total_wh(data['form'])) ]]</para></td>
+            </tr>
+        </blockTable>
+    </section>
+    <spacer length='5mm'/>
+
+    <!-- ************ TOTALS SALE/PURCHASE BOOK************-->
+   
+    <section>
+        [[ setLang(l.ai_id.company_id.partner_id.lang) ]]
+        <blockTable colWidths="280.0,80.0,80.0" style="TOTALS_TABLE" repeatRows="2">
+            <tr>
+                <td><para style="HEADER">[[data['form']['type'] == 'purchase' and 'CREDITOS FISCALES' or 'DEBITOS FISCALES']]</para></td>
+                <td><para style="HEADER">BASE IMPONIBLE</para></td>
+                <td><para style="HEADER">[[data['form']['type'] == 'purchase' and 'CREDITO FISCAL' or 'DEBITO FISCAL']]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS NO GRAVADAS Y/O SIN DERECHO A CREDITO FISCAL' or 'DEBITOS FISCALES']]</para></td>
+                <td><para style="CONTENIDO">[[ formatLang(get_amount_untaxed_tax(data['form'],'SDCF','nacional')[0]+get_amount_untaxed_tax(data['form'],'EXONERADO','nacional')[0]+get_amount_untaxed_tax(data['form'],'SDCF')[0]+get_amount_untaxed_tax(data['form'],'EXONERADO')[0]) ]]</para></td>
+                <td><para style="CONTENIDO">0.0</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'IMPORTACION GRAVADAS POR ALICUOTA GENERAL' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'12')[0])]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'12')[1])]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'IMPORTACIONES GRAVADAS POR ALICUOTA GENERAL MAS ALICUOTA ADICIONAL' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'22')[0])]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'22')[1])]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'IMPORTACIONES GRAVADAS POR ALICUOTA REDUCIDA' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'8')[0])]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'8')[1])]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'sale' and 'VENTAS DE EXPORTACION' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">0.0</para></td>
+                <td><para style="CONTENIDO">0.0</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS GRAVADAS POR ALICUOTA GENERAL' or 'VENTAS INTERNAS GRAVADAS POR ALICUOTA GENERAL']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'12','nacional')[0])]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'12','nacional')[1])]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS INTERNAS GRAVADAS POR ALICUOTA GENERAL MAS ALICUOTA ADICIONAL' or 'VENTAS INTERNAS GRAVADAS POR ALICUOTA GENERAL MAS ALICUOTA ADICIONAL']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'22','nacional')[0])]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'22','nacional')[1])]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS INTERNAS GRAVADAS POR ALICUOTA REDUCIDA' or 'VENTAS INTERNAS GRAVADAS POR ALICUOTA REDUCIDA']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'8','nacional')[0])]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(get_amount_untaxed_tax(data['form'],'8','nacional')[1])]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT_BOLD">[[data['form']['type'] == 'purchase' and 'TOTAL COMPRAS Y CREDITOS FISCALES DEL PERIODO' or 'TOTAL VENTAS Y DEBITOS FISCAL PARA EFECTOS DE DETERMINACION']]</para></td>
+                <td><para style="CONTENIDO">
+[[ formatLang(get_amount_untaxed_tax(data['form'],'SDCF','nacional')[0]+
+get_amount_untaxed_tax(data['form'],'EXONERADO','nacional')[0]+
+get_amount_untaxed_tax(data['form'],'SDCF')[0]+
+get_amount_untaxed_tax(data['form'],'EXONERADO')[0]+
+get_amount_untaxed_tax(data['form'],'12')[0]+
+get_amount_untaxed_tax(data['form'],'22')[0]+
+get_amount_untaxed_tax(data['form'],'8')[0]+
+get_amount_untaxed_tax(data['form'],'12','nacional')[0]+
+get_amount_untaxed_tax(data['form'],'22','nacional')[0]+
+get_amount_untaxed_tax(data['form'],'8','nacional')[0])]]
+                </para></td>
+                <td><para style="CONTENIDO">
+[[formatLang(
+get_amount_untaxed_tax(data['form'],'12')[1]+
+get_amount_untaxed_tax(data['form'],'22')[1]+
+get_amount_untaxed_tax(data['form'],'8')[1]+
+get_amount_untaxed_tax(data['form'],'12','nacional')[1]+
+get_amount_untaxed_tax(data['form'],'22','nacional')[1]+
+get_amount_untaxed_tax(data['form'],'8','nacional')[1]
+)]]
+                </para></td>
+            </tr>
+        </blockTable>
+    </section>
+<nextPage/>
+
+    <spacer length='5mm'/>
+          <!-- ****************************************-->
+          <!-- ************ AJUSTMENT BOOK ************-->
+          <!-- ****************************************-->
+    <section>
+    <blockTable colWidths="795.0" style="HEADERTABLE_AD">
+        <tr><td><para></para></td></tr>
+        <tr><td><para></para></td></tr>
+        <tr> 
+            <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+            <td><para style="TITULO_AJUSTE">LIBRO DE AJUSTES</para></td></tr>
+        <tr><td><para></para></td></tr>
+    </blockTable>
+    </section>
+
+    
+     <section>
+        <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+        <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0" style="ENCANBEZADO_SINCOLUM" repeatRows="2">        
+        [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0",'style':'ENCANBEZADO', 'repeatRows':'2'}) or '']]
+        <tr>
+            <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+            <td></td><td></td><td></td>
+            <td></td><td></td><td></td>
+            <td></td><td></td><td></td>
+            <td></td>
+            <td>
+                <blockTable colWidths="110.0" style="INTERNALTABLE">
+                    <tr><td vAlign="MIDDLE"><para style="HEADER">Operaciones Nacionales</para></td></tr>
+                </blockTable>
+            </td>
+            <td>
+                <blockTable colWidths="110.0" style="INTERNALTABLE">
+                    <tr><td vAlign="MIDDLE"><para style="HEADER">Operaciones Internacionales</para></td></tr>
+                </blockTable>
+            </td>
+            <td></td><td></td>
+        </tr>
+        <tr>
+            <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+            <td><para style="HEADER">[[ (data['form']['type'] == 'purchase') and 'Fecha Adm.' or '' ]]</para></td>
+            <td><para style="HEADER">Fecha Cont.</para></td>
+            <td><para style="HEADER">RIF</para></td>
+            <td><para style="HEADER">Razon Social</para></td>
+            <td><para style="HEADER">Numero Doc.</para></td>
+            <td><para style="HEADER">Numero Control</para></td>
+            <td><para style="HEADER">Total con IVA</para></td>
+            <td><para style="HEADER">Tipo Doc.</para></td>
+            <td><para style="HEADER">Documento Afectado</para></td>
+            <td><para style="HEADER">Sin derecho a Credito Fiscal</para></td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="HEADER">Base Imponible</para></td>
+                        <td><para style="HEADER">%</para><para style="HEADER">IVA</para></td>
+                        <td><para style="HEADER">Monto</para><para style="HEADER">Impuesto</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td>
+                <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                    <tr>
+                        <td><para style="HEADER">Base Imponible</para></td>
+                        <td><para style="HEADER">%</para><para style="HEADER">IVA</para></td>
+                        <td><para style="HEADER">Monto</para><para style="HEADER">Impuesto</para></td>
+                    </tr>
+                </blockTable>
+            </td>
+            <td><para style="HEADER">Retencion IVA</para></td>
+            <td><para style="HEADER">Comprobante</para></td>
+        </tr>
+        </blockTable>
+    </section>
+
+    <section>
+    <para>[[ repeatIn(validation(data['form']) and get_data_adjustment(data['form'])[1] or [],'a')]]</para>  
+    <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0" style="CONTENIDOTABLE_LINES" repeatRows="2">        
+    [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0",'style':'CONTENIDOTABLE_LINES_PUR', 'repeatRows':'2'}) or '']]
+    <tr>
+        <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+        [[ setLang(l.ai_id.company_id.partner_id.lang) ]]
+        <td><para style="CONTENIDO">[[ data['form']['type'] == 'purchase' and ( a.date_admin and formatLang(a.date_admin, date=True) or '') or '' ]]</para></td>
+        <td><para style="CONTENIDO">[[ time.strftime('%d/%m/%Y', time.strptime(a.date_accounting, '%Y-%m-%d'))]]</para></td>
+        <td><para style="CONTENIDO">[[ a.vat ]]</para></td>
+        <td><para style="CONTENIDOLEFT">[[ a.partner ]]</para></td>
+        <td><para style="CONTENIDO">[[ a.invoice_number ]]</para></td>
+        <td><para style="CONTENIDO">[[ a.control_number ]]</para></td>
+        <td><para style="CONTENIDO">[[ formatLang(a.amount) ]]</para></td>
+        <td><para style="CONTENIDO">[[ a.type_doc ]]</para></td>
+        <td><para style="CONTENIDO">[[ a.doc_affected ]]</para></td>
+        <td><para style="CONTENIDO">[[ a.uncredit_fiscal ]]</para></td>
+        <td>
+            <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                <tr>
+                    <td><para style="CONTENIDOINT">[[ formatLang(a.amount_untaxed_n) ]]</para></td>
+                    <td><para style="CONTENIDOINT">[[ formatLang(a.percent_with_vat_n) ]]</para></td>
+                    <td><para style="CONTENIDOINT">[[ formatLang(a.amount_with_vat_n) ]]</para></td>
+                </tr>
+            </blockTable>
+        </td>
+        <td>
+            <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                <tr>
+                    <td><para style="CONTENIDOINT">[[ formatLang(a.amount_untaxed_i) ]]</para></td>
+                    <td><para style="CONTENIDOINT">[[ formatLang(a.percent_with_vat_i) ]]</para></td>
+                    <td><para style="CONTENIDOINT">[[ formatLang(a.amount_with_vat_i) ]]</para></td>
+                </tr>
+            </blockTable>
+        </td>
+        <td><para style="CONTENIDO">[[ formatLang(a.amount_with_vat) ]]</para></td>
+        <td><para style="CONTENIDO">[[ a.voucher ]]</para></td>
+    </tr>
+    </blockTable>
+    </section>
+
+    <section>
+        <para>[[repeatIn( get_data_adjustment( data['form'] )[0],'al')]]</para> 
+        <blockTable colWidths="1.0,33.0,37.0,177.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0" style="CONTENIDOTABLE_LINES" repeatRows="2">
+        [[(data['form']['type'] == 'purchase') and setTag('blockTable','blockTable',{'colWidths':"33.0,33.0,37.0,145.0,47.0,38.0,38.0,15.0,38.0,34.0,114.0,114.0,44.0,50.0",'style':'CONTENIDOTABLE_LINES_PUR', 'repeatRows':'2'}) or '']]
+            <tr>
+                <para>
+                [[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+                [[ setLang(company.partner_id.lang) ]]
+                <td></td><td></td><td></td>
+                <td></td><td></td><td></td>
+                <td><para style="CONTENIDOINT">[[ formatLang(al.amount_total) ]]</para></td>
+                <td></td><td></td>
+                <td><para style="CONTENIDOINT">[[ formatLang(al.uncredit_fiscal_total) ]]</para></td>
+                <td>
+                    <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                        <tr>
+                            <td><para style="CONTENIDOINT">[[ formatLang(al.amount_untaxed_n_total) ]]</para></td>
+                            <td></td>
+                            <td><para style="CONTENIDOINT">[[ formatLang(al.amount_with_vat_n_total) ]]</para></td>
+                        </tr>
+                    </blockTable>
+                </td>
+                <td>
+                    <blockTable colWidths="40.0,30.0,40.0" style="INTERNALTABLE">
+                        <tr>
+                            <td><para style="CONTENIDOINT">[[ formatLang(al.amount_untaxed_i_total) ]]</para></td>
+                            <td></td>
+                            <td><para style="CONTENIDOINT">[[ formatLang(al.amount_with_vat_i_total) ]]</para></td>
+                        </tr>
+                    </blockTable>
+                </td>
+                <td><para style="CONTENIDO">[[ formatLang(al.amount_with_vat_total) ]]</para></td>
+                <td></td>
+            </tr>
+        </blockTable>
+    </section>
+
+
+    <spacer length='5mm'/>
+    <!-- ************ TOTALES ADJUSTMENT BOOK************-->
+    <section>
+        <para>[[ repeatIn(validation(data['form']) and get_data_adjustment(data['form'])[0] or [],'to')]]</para>
+        <blockTable colWidths="280.0,80.0,80.0" style="TOTALS_TABLE" repeatRows="2">
+            <tr>
+                <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable')]]</para>
+                <td><para style="HEADER">CREDITOS FISCALES</para></td>
+                <td><para style="HEADER">BASE IMPONIBLE</para></td>
+                <td><para style="HEADER">CREDITO FISCAL</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[ data['form']['type'] == 'purchase' and 'COMPRAS NO GRAVADAS Y/O SIN DERECHO A CREDITO FISCAL' or 'VENTAS INTERNAS NO GRAVADAS']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.no_grav)]]</para></td>
+                <td><para style="CONTENIDO">0.00</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'IMPORTACION GRAVADAS POR ALICUOTA GENERAL' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_i)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_icf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'IMPORTACIONES GRAVADAS POR ALICUOTA GENERAL MAS ALICUOTA ADICIONAL' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_add_i)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_add_icf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'IMPORTACIONES GRAVADAS POR ALICUOTA REDUCIDA' or removeParentNode('tr')]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_reduced_i)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_reduced_icf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS GRAVADAS POR ALICUOTA GENERAL' or 'VENTAS INTERNAS GRAVADAS POR ALICUOTA GENERAL']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_n)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_ncf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS INTERNAS GRAVADAS POR ALICUOTA GENERAL MAS ALICUOTA ADICIONAL' or 'VENTAS INTERNAS GRAVADAS POR ALICUOTA GENERAL MAS ALICUOTA ADICIONAL']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_add_n)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_general_add_ncf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'COMPRAS INTERNAS GRAVADAS POR ALICUOTA REDUCIDA' or 'VENTAS INTERNAS GRAVADAS POR ALICUOTA REDUCIDA']]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_reduced_n)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.vat_reduced_ncf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT">[[data['form']['type'] == 'purchase' and 'AJUSTES A LOS CREDITOS FISCALES DE LOS PERIODOS ANTERIORES' or 'AJUSTES A LOS DEBITOS FISCALES DE LOS PERIODOS ANTERIORES']]</para></td>
+                <td><para style="CONTENIDO">0.0</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.adjustment_cf)]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="CONTENIDOLEFT_BOLD">TOTAL COMPRAS Y CREDITOS FISCALES DEL PERIODO</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.amount_base_total)]]</para></td>
+                <td><para style="CONTENIDO">[[formatLang(to.amount_percent_total)]]</para></td>
+            </tr>
+        </blockTable>
+    </section>
+
+     <spacer length='5mm'/>
+    <!-- ************ OBSERVACIONES ADJUSTMENT BOOK************-->
+    <section>
+        <para>[[ repeatIn(validation(data['form']) and get_data_adjustment(data['form'])[0] or [],'ob')]]</para>  
+        <blockTable colWidths="794.0" style="CONTENIDOTABLE_LINES_PUR">
+            <tr>
+                <td><para style="OBSERVACIONES">[[ob.note and 'OBSERVACIONES:' or removeParentNode('para')]]</para></td>
+            </tr>
+            <tr>
+                <td><para style="OBSERVACIONES">[[ ob.note and ob.note or removeParentNode('para') ]]</para></td>
+            </tr>
+        </blockTable>
+    </section>
+    
+
+  </story>
+</document>
+
+
+
+
+
+
+
+
+
+
+

=== added directory 'l10n_ve_fiscal_reports/report/sources'
=== added file 'l10n_ve_fiscal_reports/report/sources/book_seniat.sxw'
Binary files l10n_ve_fiscal_reports/report/sources/book_seniat.sxw	1970-01-01 00:00:00 +0000 and l10n_ve_fiscal_reports/report/sources/book_seniat.sxw	2011-12-29 18:55:26 +0000 differ
=== added file 'l10n_ve_fiscal_reports/report/sources/book_seniatN.sxw'
Binary files l10n_ve_fiscal_reports/report/sources/book_seniatN.sxw	1970-01-01 00:00:00 +0000 and l10n_ve_fiscal_reports/report/sources/book_seniatN.sxw	2011-12-29 18:55:26 +0000 differ
=== added file 'l10n_ve_fiscal_reports/report/sources/witholding_book.rml'
--- l10n_ve_fiscal_reports/report/sources/witholding_book.rml	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/sources/witholding_book.rml	2011-12-29 18:55:26 +0000
@@ -0,0 +1,246 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+  <template pageSize="(792.0,612.0)" title="Test" author="Martin Simon" allowSplitting="20">
+    <pageTemplate id="first">
+      <frame id="first" x1="31.0" y1="31.0" width="730" height="553"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla3">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="8,0" stop="8,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="8,-1" stop="8,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="9,0" stop="9,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="9,-1" stop="9,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="10,0" stop="10,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="10,-1" stop="10,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="11,0" stop="11,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="11,-1" stop="11,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="12,0" stop="12,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="12,-1" stop="12,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla4">
+      <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="LINEBEFORE" 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"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,0" stop="6,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,0" stop="7,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="8,0" stop="8,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="8,0" stop="8,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="8,-1" stop="8,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="9,0" stop="9,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="9,0" stop="9,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="9,-1" stop="9,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="10,0" stop="10,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="10,0" stop="10,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="10,-1" stop="10,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="11,0" stop="11,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="11,0" stop="11,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="11,0" stop="11,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="11,-1" stop="11,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla2">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="P1" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P2" fontName="Helvetica" fontSize="8.0" leading="10"/>
+    <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10"/>
+    <paraStyle name="P4" fontName="Helvetica" fontSize="6.0" leading="8" alignment="CENTER"/>
+    <paraStyle name="P5" fontName="Helvetica" fontSize="2.0" leading="3"/>
+    <paraStyle name="P6" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT"/>
+    <paraStyle name="P7" fontName="Helvetica" fontSize="8.0" leading="10"/>
+    <paraStyle name="P8" fontName="Helvetica" fontSize="8.0" leading="10"/>
+    <paraStyle name="P9" fontName="Times-Roman" fontSize="8.0" leading="10" alignment="RIGHT"/>
+    <paraStyle name="P10" fontName="Helvetica" fontSize="2.0" leading="3" alignment="CENTER"/>
+    <paraStyle name="P11" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT"/>
+    <paraStyle name="P12" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT"/>
+    <paraStyle name="P13" fontName="Helvetica" fontSize="14.0" leading="17" 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"/>
+  </stylesheet>
+  <images/>
+  <story>
+    <section>
+      <para style="P13">WITHOLDING BOOK</para>
+      <blockTable colWidths="365.0,365.0" style="Tabla1">
+        <tr>
+          <td>
+            <para style="P6">[[ company.partner_id.name ]] [[ get_rif( company.partner_id.vat ) ]]</para>
+            <para style="P11">[[ get_partner_addr( company.partner_id.id ) ]]</para>
+          </td>
+          <td>
+            <para style="P12">Month: [[ get_month( data['form'] ) ]]</para>
+            <para style="P11">From : [[ time.strftime('%d/%m/%Y', time.strptime(get_dates( data['form'] )[0], '%Y-%m-%d')) ]]</para>
+            <para style="P11">To: [[ time.strftime('%d/%m/%Y', time.strptime(get_dates( data['form'] )[1], '%Y-%m-%d')) ]]</para>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="P10">
+        <font color="white"> </font>
+      </para>
+    </section>
+    <blockTable colWidths="49.0,54.0,168.0,75.0,36.0,48.0,49.0,49.0,42.0,42.0,34.0,41.0,41.0" style="Tabla3">
+      <tr>
+        <td>
+          <para style="P4">Date</para>
+        </td>
+        <td>
+          <para style="P4">R.I.F.</para>
+        </td>
+        <td>
+          <para style="P4">Company Name</para>
+        </td>
+        <td>
+          <para style="P4">Voucher</para>
+        </td>
+        <td>
+          <para style="P4">Fiscal Period</para>
+        </td>
+        <td>
+          <para style="P4">Affected Invoice</para>
+        </td>
+        <td>
+          <para style="P4">Total Sales</para>
+        </td>
+        <td>
+          <para style="P4">Exempt Sales</para>
+        </td>
+        <td>
+          <para style="P4">Tax</para>
+        </td>
+        <td>
+          <para style="P4">Retention Amount</para>
+        </td>
+        <td>
+          <para style="P4">% Ret</para>
+        </td>
+        <td>
+          <para style="P4">Base Ret.</para>
+        </td>
+        <td>
+          <para style="P4">% VAT.</para>
+        </td>
+      </tr>
+    </blockTable>
+    <section>
+      <para style="P1">[[repeatIn( get_data( data['form'] ),'l')]]</para>
+      <para style="P1">[[ setLang(l.ai_id.company_id.partner_id.lang) ]]</para>
+      <blockTable colWidths="49.0,54.0,168.0,75.0,37.0,48.0,49.0,49.0,42.0,42.0,34.0,81.0" style="Tabla4">
+        <tr>
+          <td>
+            <para style="P2">[[ time.strftime('%d/%m/%Y', time.strptime(l.ar_date_ret, '%Y-%m-%d')) ]]</para>
+          </td>
+          <td>
+            <para style="P2">[[ get_rif( l.rp_vat) ]]</para>
+          </td>
+          <td>
+            <para style="P2">[[ l.rp_id.name ]]</para>
+          </td>
+          <td>
+            <para style="P2">[[ l.ar_number ]]</para>
+          </td>
+          <td>
+            <para style="P2">[[ l.ar_number.replace("-","")[0:6] ]]</para>
+          </td>
+          <td>
+            <para style="P2">[[ l.ai_reference ]]</para>
+          </td>
+          <td>
+            <para style="P3">[[ formatLang(l.ai_amount_total) ]]</para>
+          </td>
+          <td>
+            <para style="P3">[[ get_exc(l.ar_line_id) ]]</para>
+          </td>
+          <td>
+            <para style="P7">[[ formatLang(l.ar_line_id.base_ret) ]]</para>
+          </td>
+          <td>
+            <para style="P7">[[ formatLang(l.ar_id.total_tax_ret) ]]</para>
+          </td>
+          <td>
+            <para style="P7">[[ formatLang(l.ar_line_id.retention_rate) ]]</para>
+          </td>
+          <td>
+            <para style="P5">[[ repeatIn( l.ar_line_id.tax_line,'t' ) ]]</para>
+            <blockTable colWidths="40.0,41.0" style="Tabla2">
+              <tr>
+                <td>
+                  <para style="P8">[[ formatLang(t.base_ret) ]]</para>
+                </td>
+                <td>
+                  <para style="P8">[[ formatLang(t.tax_amount) ]]</para>
+                </td>
+              </tr>
+            </blockTable>
+            <para style="P5">
+              <font color="white"> </font>
+            </para>
+          </td>
+        </tr>
+      </blockTable>
+    </section>
+    <para style="P9">
+      <font color="white"> </font>
+    </para>
+  </story>
+</document>
+

=== added file 'l10n_ve_fiscal_reports/report/sources/witholding_book.sxw'
Binary files l10n_ve_fiscal_reports/report/sources/witholding_book.sxw	1970-01-01 00:00:00 +0000 and l10n_ve_fiscal_reports/report/sources/witholding_book.sxw	2011-12-29 18:55:26 +0000 differ
=== added file 'l10n_ve_fiscal_reports/report/sources/witholding_book_bad.sxw'
Binary files l10n_ve_fiscal_reports/report/sources/witholding_book_bad.sxw	1970-01-01 00:00:00 +0000 and l10n_ve_fiscal_reports/report/sources/witholding_book_bad.sxw	2011-12-29 18:55:26 +0000 differ
=== added file 'l10n_ve_fiscal_reports/report/sources/witholding_book_cas.sxw'
Binary files l10n_ve_fiscal_reports/report/sources/witholding_book_cas.sxw	1970-01-01 00:00:00 +0000 and l10n_ve_fiscal_reports/report/sources/witholding_book_cas.sxw	2011-12-29 18:55:26 +0000 differ
=== added directory 'l10n_ve_fiscal_reports/report/tiny_sxw2rml'
=== added file 'l10n_ve_fiscal_reports/report/tiny_sxw2rml/__init__.py'
--- l10n_ve_fiscal_reports/report/tiny_sxw2rml/__init__.py	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/tiny_sxw2rml/__init__.py	2011-12-29 18:55:26 +0000
@@ -0,0 +1,25 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution	
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
+#    $Id$
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from tiny_sxw2rml import sxw2rml
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'l10n_ve_fiscal_reports/report/tiny_sxw2rml/normalized_odt2rml.xsl'
--- l10n_ve_fiscal_reports/report/tiny_sxw2rml/normalized_odt2rml.xsl	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/tiny_sxw2rml/normalized_odt2rml.xsl	2011-12-29 18:55:26 +0000
@@ -0,0 +1,696 @@
+<?xml version="1.0" encoding="utf-8"?>
+<xsl:stylesheet
+  version="1.0"
+  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
+  xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
+  xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
+  xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
+  xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
+  xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
+  xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0"
+  xmlns:xlink="http://www.w3.org/1999/xlink"
+  xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
+  xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0"
+  xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0"
+  xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0"
+  xmlns:math="http://www.w3.org/1998/Math/MathML"
+  xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0"
+  xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0"
+  office:class="text" office:version="1.1"
+  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-layout[1]/style:page-layout-properties/@fo:page-width" />
+    <xsl:text>,</xsl:text>
+    <xsl:value-of select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-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-layout[1]/style:page-layout-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-layout[1]/style:page-layout-properties/@fo:margin-left" />
+  <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-properties/@fo:margin-right" />
+  <xsl:variable name="margin_top" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-properties/@fo:margin-top" />
+  <xsl:variable name="margin_bottom" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-properties/@fo:margin-bottom" />
+  <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-properties/@fo:page-width" />
+  <xsl:variable name="page_height" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-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-layout[1]/style:page-layout-properties/@fo:margin-left" />
+  <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-properties/@fo:margin-right" />
+  <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-layout[1]/style:page-layout-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>
+	<xsl:for-each select="//text:ordered-list">
+		<para><seqReset id="{./@text:style-name}"/></para>
+	</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:frame/@svg:height}" width="{.//draw:frame/@svg:width}">
+    <image x="0" y="0" file="{substring-after(.//draw:image/@xlink:href,'Pictures/')}" height="{.//draw:frame/@svg:height}" width="{.//draw:frame/@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 />
+
+  <!-- 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="{../../@text:style-name}"/>.</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" />
+    <xsl:call-template name="make_fontcolor" />
+  </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>
+
+<xsl:template name="make_fontcolor">
+  <xsl:variable name="textColor">
+    <xsl:value-of select="style:properties/@fo:color"/>
+  </xsl:variable>
+  <xsl:if test="not($textColor='') and boolean(style:properties/@fo:color)">
+  <xsl:attribute name="textColor">
+      <xsl:value-of select="$textColor" />
+   </xsl:attribute>
+  </xsl:if>
+</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_fiscal_reports/report/tiny_sxw2rml/normalized_oo2rml.xsl'
--- l10n_ve_fiscal_reports/report/tiny_sxw2rml/normalized_oo2rml.xsl	1970-01-01 00:00:00 +0000
+++ l10n_ve_fiscal_reports/report/tiny_sxw2rml/normalized_oo2rml.xsl	2011-12-29 18:55:26 +0000
@@ -0,0 +1,696 @@
+<?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>
+	<xsl:for-each select="//text:ordered-list">
+		<para><seqReset id="{./@text:style-name}"/></para>
+	</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 />
+
+  <!-- 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="{../../@text:style-name}"/>.</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" />
+    <xsl:call-template name="make_fontcolor" />
+  </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'">