Merge lp:~vxkikevx/addons-vauxoo/late_payments_report into lp:addons-vauxoo

[Luis Escobar V. (Vauxoo)]

[ADD] Module Late Payment Reports

=== added directory 'late_payments_report'
=== added file 'late_payments_report/__init__.py'
--- late_payments_report/__init__.py	1970-01-01 00:00:00 +0000
+++ late_payments_report/__init__.py	2012-02-29 22:52:22 +0000
@@ -0,0 +1,26 @@
+# -*- 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: Luis Escobar <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+
+import report

=== added file 'late_payments_report/__openerp__.py'
--- late_payments_report/__openerp__.py	1970-01-01 00:00:00 +0000
+++ late_payments_report/__openerp__.py	2012-02-29 22:52:22 +0000
@@ -0,0 +1,45 @@
+# -*- 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: Luis Escobar <[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/>.
+##############################################################################
+
+{
+	"name" : "Venezuelan Late Payments customisation",
+	"version" : "0.1",
+	"author" : "Vauxoo",
+	"category" : "Generic Modules/Others",
+	"website": "http://wiki.openerp.org.ve/",
+    "description": """
+    
+    Modulo que realiza la personalizacion del reporte de pagos atrasados 
+    
+    """,
+	"depends" : ["base", "account"],
+	"init_xml" : [],
+	"update_xml" : [
+		"late_payments_report.xml",
+
+	],
+	"active": False,
+	"installable": True
+}

=== added directory 'late_payments_report/i18n'
=== added file 'late_payments_report/i18n/es.po'
--- late_payments_report/i18n/es.po	1970-01-01 00:00:00 +0000
+++ late_payments_report/i18n/es.po	2012-02-29 22:52:22 +0000
@@ -0,0 +1,77 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* l10n_ve_late_payments_report
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.0.3\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2012-02-29 19:11+0000\n"
+"PO-Revision-Date: 2012-02-29 19:11+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_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Total amount due:"
+msgstr "Monto total adeudado:"
+
+#. module: l10n_ve_late_payments_report
+#: model:ir.actions.report.xml,name:l10n_ve_late_payments_report.late_payments_l10n_ve
+msgid "Late Payments"
+msgstr "Pagos Atrasados"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Description"
+msgstr "Descripcion"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Due"
+msgstr "Debe"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Paid"
+msgstr "Pagado"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Balance :"
+msgstr "Balance :"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Maturity"
+msgstr "Vencido"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Maturity date"
+msgstr "Maturity date"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Sub-Total :"
+msgstr "Sub-Total :"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Date"
+msgstr "Fecha"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "."
+msgstr "."
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Ref"
+msgstr "Ref"
+

=== added file 'late_payments_report/i18n/es_VE.po'
--- late_payments_report/i18n/es_VE.po	1970-01-01 00:00:00 +0000
+++ late_payments_report/i18n/es_VE.po	2012-02-29 22:52:22 +0000
@@ -0,0 +1,77 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* l10n_ve_late_payments_report
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.0.3\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2012-02-29 19:11+0000\n"
+"PO-Revision-Date: 2012-02-29 19:11+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_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Total amount due:"
+msgstr "Monto total adeudado:"
+
+#. module: l10n_ve_late_payments_report
+#: model:ir.actions.report.xml,name:l10n_ve_late_payments_report.late_payments_l10n_ve
+msgid "Late Payments"
+msgstr "Pagos Atrasados"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Description"
+msgstr "Descripcion"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Due"
+msgstr "Debe"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Paid"
+msgstr "Pagado"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Balance :"
+msgstr "Balance :"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Maturity"
+msgstr "Vencido"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Maturity date"
+msgstr "Fecha de Vencimiento"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Sub-Total :"
+msgstr "Sub-Total :"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Date"
+msgstr "Fecha"
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "."
+msgstr "."
+
+#. module: l10n_ve_late_payments_report
+#: report:account.late.payments.l10n.ve:0
+msgid "Ref"
+msgstr "Ref"
+

=== added file 'late_payments_report/late_payments_report.xml'
--- late_payments_report/late_payments_report.xml	1970-01-01 00:00:00 +0000
+++ late_payments_report/late_payments_report.xml	2012-02-29 22:52:22 +0000
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <report             
+            id="late_payments_report" 
+            model="res.partner" 
+            name="account.late.payments.l10n.ve" 
+            rml="late_payments_report/report/late_payments.rml" 
+            string="Late Payments"
+            auto="False"
+            header="False" />
+
+
+    </data>
+</openerp>

=== added directory 'late_payments_report/report'
=== added file 'late_payments_report/report/__init__.py'
--- late_payments_report/report/__init__.py	1970-01-01 00:00:00 +0000
+++ late_payments_report/report/__init__.py	2012-02-29 22:52:22 +0000
@@ -0,0 +1,27 @@
+# -*- 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: Luis Escobar <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+
+
+import late_payments

=== added file 'late_payments_report/report/late_payments.py'
--- late_payments_report/report/late_payments.py	1970-01-01 00:00:00 +0000
+++ late_payments_report/report/late_payments.py	2012-02-29 22:52:22 +0000
@@ -0,0 +1,98 @@
+# -*- 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: Luis Escobar <[e-mail]>
+#    Planified by: Nhomar Hernandez
+#    Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
+#    Audited by: Humberto Arocha [e-mail]
+#############################################################################
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+##############################################################################
+
+import time
+
+import ir
+from osv import osv
+from report import report_sxw
+import pooler
+
+class Late_payments(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(Late_payments, self).__init__(cr, uid, name, context=context)
+        self.localcontext.update( {
+            'time' : time,
+            'adr_get' : self._adr_get,
+            'getLines' : self._lines_get,
+            'tel_get' : self._tel_get,
+            'message' : self._message,
+        })
+        self.context = context
+    def _adr_get(self, partner, type):
+        res = []
+        res_partner = pooler.get_pool(self.cr.dbname).get('res.partner')
+        res_partner_address = pooler.get_pool(self.cr.dbname).get('res.partner.address')
+        addresses = res_partner.address_get(self.cr, self.uid, [partner.id], [type])
+        adr_id = addresses and addresses[type] or False
+        result = {
+                  'name': False,
+                  'street': False,
+                  'city' : False,
+                  'zip' : False,
+                  'country_id' : False,
+                 }
+        if adr_id:
+            result = res_partner_address.read(self.cr, self.uid, [adr_id],context=self.context.copy())
+            result[0]['country_id'] = result[0]['country_id'] and result[0]['country_id'][1] or False
+            return result   
+         
+        res.append(result)
+        return res
+
+    def _tel_get(self,partner):
+        if not partner:
+            return False
+        res_partner_address = pooler.get_pool(self.cr.dbname).get('res.partner.address')
+        res_partner = pooler.get_pool(self.cr.dbname).get('res.partner')
+        addresses = res_partner.address_get(self.cr, self.uid, [partner.id], ['invoice'])
+        adr_id = addresses and addresses['invoice'] or False
+        if adr_id:
+            adr=res_partner_address.read(self.cr, self.uid, [adr_id])[0]
+            return adr['phone']
+        else:
+            return partner.address and partner.address[0].phone or False
+        return False
+
+    def _lines_get(self, partner):
+        moveline_obj = pooler.get_pool(self.cr.dbname).get('account.move.line')
+        movelines = moveline_obj.search(self.cr, self.uid,
+                [('partner_id', '=', partner.id),
+                    ('account_id.type', 'in', ['receivable', 'payable']),
+                    ('state', '<>', 'draft'), ('reconcile_id', '=', False)])
+        movelines = moveline_obj.browse(self.cr, self.uid, movelines)
+        return movelines
+        
+    def _message(self, obj, company):
+        company_pool = pooler.get_pool(self.cr.dbname).get('res.company')
+        message = company_pool.browse(self.cr, self.uid, company.id, {'lang':obj.lang}).overdue_msg 
+        return message
+        
+report_sxw.report_sxw('report.account.late.payments.l10n.ve', 'res.partner',
+        'addons/late_payments_report/report/late_payments.rml', parser=Late_payments)
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'late_payments_report/report/late_payments.rml'
--- late_payments_report/report/late_payments.rml	1970-01-01 00:00:00 +0000
+++ late_payments_report/report/late_payments.rml	2012-02-29 22:52:22 +0000
@@ -0,0 +1,201 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+  <template pageSize="(595.0,842.0)" title="Test" author="Martin Simon" allowSplitting="20">
+    <pageTemplate id="first">
+      <frame id="first" x1="42.0" y1="28.0" width="511" height="786"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla2">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="5,-1" stop="5,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="6,-1" stop="6,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="7,-1" stop="7,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla4">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,1" stop="1,1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,1" stop="2,1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="3,1" stop="3,1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="4,1" stop="4,1"/>
+    </blockTableStyle>
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="Standard" fontName="Times-Roman"/>
+    <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="Table Contents" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Caption" fontName="Times-Roman" fontSize="10.0" leading="13" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="Index" fontName="Times-Roman"/>
+    <paraStyle name="Heading" fontName="Helvetica" fontSize="15.0" leading="19" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="Footer" fontName="Times-Roman"/>
+    <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
+    <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.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="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+  </stylesheet>
+  <images/>
+  <story>
+    <para style="terp_default_8">
+      <font color="white"> </font>
+    </para>
+    <section>
+      <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
+      <para style="terp_default_8">[[ setLang(o.lang) ]]</para>
+      <para style="terp_default_9">[[ o.name ]]</para>
+      <para style="terp_default_9">[[ o.vat or removeParentNode('para') ]]</para>
+      <blockTable colWidths="56.0,137.0,52.0,72.0,62.0,59.0,58.0" style="Tabla1">
+        <tr>
+          <td>
+            <para style="terp_tblheader_Details">Date</para>
+          </td>
+          <td>
+            <para style="terp_tblheader_Details">Description</para>
+          </td>
+          <td>
+            <para style="terp_tblheader_Details_Centre">Ref</para>
+          </td>
+          <td>
+            <para style="terp_tblheader_Details_Centre">Maturity date</para>
+          </td>
+          <td>
+            <para style="terp_tblheader_Details_Right">Due</para>
+          </td>
+          <td>
+            <para style="terp_tblheader_Details_Right">Paid</para>
+          </td>
+          <td>
+            <para style="terp_tblheader_Details_Right">Maturity</para>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="terp_default_8">
+        <font color="white"> </font>
+      </para>
+      <section>
+        <para style="terp_default_8">[[repeatIn(getLines(o), 'line') ]]</para>
+        <blockTable colWidths="56.0,138.0,52.0,73.0,62.0,59.0,58.0" style="Tabla2">
+          <tr>
+            <td>
+              <para style="terp_default_9">[[ formatLang(line['date'],date=True) ]]</para>
+            </td>
+            <td>
+              <para style="terp_default_9">[[ line['name'] ]]</para>
+            </td>
+            <td>
+              <para style="terp_default_Centre_9">[[ line['ref'] ]]</para>
+            </td>
+            <td>
+              <para style="terp_default_Centre_9">[[ line['date_maturity'] ]]</para>
+            </td>
+            <td>
+              <para style="terp_default_Right_9">[[ formatLang(line['debit']) and formatLang(line['debit'] * (line['account_id']['type'] == 'payable' and -1 or 1)) ]]</para>
+            </td>
+            <td>
+              <para style="terp_default_Right_9">[[ formatLang(line['credit']) and formatLang(line['credit'] * (line['account_id']['type'] == 'payable' and -1 or 1)) ]]</para>
+            </td>
+            <td>
+              <para style="terp_default_Right_9">[[ formatLang((line['date_maturity'] &lt; time.strftime('%Y-%m-%d')) and ((line['debit'] - line['credit']) * (line['account_id']['type'] == 'payable' and -1 or 1))) ]]</para>
+            </td>
+          </tr>
+        </blockTable>
+      </section>
+      <blockTable colWidths="244.0,75.0,62.0,59.0,58.0" style="Tabla4">
+        <tr>
+          <td>
+            <para style="terp_default_Bold_9"></para>
+          </td>
+          <td>
+            <para style="terp_default_Bold_9">Sub-Total : </para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + (y['debit'] * (y['account_id']['type'] == 'payable' and -1 or 1)), getLines(o), 0))) ]]</para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x ,y: x + (y['credit'] * (y['account_id']['type'] == 'payable' and -1 or 1)), getLines(o), 0))) ]] </para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x + ((y['debit'] - y['credit']) * (y['account_id']['type'] == 'payable' and -1 or 1)), filter(lambda x: x['date_maturity'] &lt; time.strftime('%Y-%m-%d'), getLines(o)), 0))) ]]</para>
+          </td>
+        </tr>
+        <tr>
+          <td>
+            <para style="terp_default_Bold_9"></para>
+          </td>
+          <td>
+            <para style="terp_default_Bold_9">Balance : </para>
+          </td>
+          <td>
+            <para style="terp_default_Right_9">[[ formatLang((reduce(lambda x, y: x +((y['debit'] - y['credit']) * (y['account_id']['type'] == 'payable' and -1 or 1)), getLines(o), 0))) ]]</para>
+          </td>
+          <td>
+          </td>
+          <td>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="terp_default_9">Total amount due: [[ formatLang((reduce(lambda x, y: x + ((y['debit'] - y['credit']) * (y['account_id']['type'] == 'payable' and -1 or 1)), getLines(o), 0))) ]] [[ company.currency_id.name ]].</para>
+    <spacer length="2mm"/>
+    </section>
+    <section>
+      <para style="terp_default_8">
+        <font color="white"> </font>
+      </para>
+      <para style="terp_default_9">
+        <font color="white"> </font>
+      </para>
+    </section>
+    <para style="terp_default_9">
+      <font color="white"> </font>
+    </para>
+    <para style="terp_default_8">
+      <font color="white"> </font>
+    </para>
+  </story>
+</document>
+