Merge lp:~cci-team/openobject-addons/cci_crm_fix-invoice_id-redundacy into lp:openobject-addons

[Philmer]

Fix an ambiguous name on crm.case.

n cci_crm, we add an 'invoice_id'. Or in 'event', the object 'event.registration' inherits from crm.case but had already an 'invoice_id' name. This 'event.registration' has two fields 'invoice_id' : one on crm.case and one on 'event.registration'. This ambuguity causes some problems to show or use this field.

To correct this, I've changed the 'invoice_id' on cci_crm to 'sponsor_invoice_id' because this is the real usage of this field : to link a case to the invoice of a sponsor and only for this (on screen it appears in 'sponsor' part of view).

[qdp (OpenERP) (qdp)]

Hello Philmer,

mmh i think you wrongly choose the branch aimed by your proposal: this is for addons trunk. Let me choose the right target.

See you soon,
Quentin

Unmerged revisions

150. By Philippe Vandermeer <philmer@philmer-laptop2> on 2012-06-28

[FIX] ambiguous invoice_id name with module cci_event renamed to sponsor_invoice_id

149. By Olivier Laurent (Open ERP) on 2012-03-12

[FIX] temporary fix for ccih install: bug in account.invoice 'name_get' method: it receives a list of tuples instead of a list of ids

148. By nel on 2012-02-27

[FIX] cci_account: reconcile

147. By nel on 2012-02-23

[FIX] reconciliation

146. By Olivier Laurent (Open ERP) on 2012-02-16

[FIX] opw 381817

145. By nel on 2012-02-13

[FIX] reconciliation

144. By Olivier Laurent (Open ERP) on 2012-01-16

[ADD] added certificate numbers

143. By Olivier Laurent (Open ERP) on 2012-01-13

[FIX] bad indentation

142. By Olivier Laurent (Open ERP) on 2012-01-13

[FIX] tabs2spaces

141. By Philippe Vandermeer <philmer@philmer-laptop2> on 2011-12-19

FIX: doesn't block all invoices if one partner has no address

=== added file '.bzrignore'
--- .bzrignore	1970-01-01 00:00:00 +0000
+++ .bzrignore	2012-06-28 13:21:29 +0000
@@ -0,0 +1,1 @@
+*.pyc

=== renamed file '.bzrignore' => '.bzrignore.moved'
=== added directory 'account_analytic_package'
=== added file 'account_analytic_package/__init__.py'
--- account_analytic_package/__init__.py	1970-01-01 00:00:00 +0000
+++ account_analytic_package/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,23 @@
+##############################################################################
+#    
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.     
+#
+##############################################################################
+
+import account_analytic_package
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_analytic_package/__terp__.py'
--- account_analytic_package/__terp__.py	1970-01-01 00:00:00 +0000
+++ account_analytic_package/__terp__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,43 @@
+##############################################################################
+#    
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.     
+#
+##############################################################################
+
+{
+    "name" : "Account Analytic Package - To configure Analytic Account for product packages",
+    "description": """The Module allows to configure analytic account for product packages.
+    Views for total and monthly product packages weight, Amount analysis.""",
+    "version" : "1.0",
+    "author" : "Tiny",
+    "category" : "Generic Modules/Accounting",
+    "module": "",
+    "website": "http://www.openerp.com",
+    "depends" : ["account","product","crm"],
+    "init_xml" : [],
+    "update_xml" : [
+        "security/ir.model.access.csv",
+        "account_analytic_package_view.xml"
+    ],
+    "demo_xml" : [],
+    "active": False,
+    "installable": True,
+
+'certificate': '00181681485805',
+}
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_analytic_package/account_analytic_package.py'
--- account_analytic_package/account_analytic_package.py	1970-01-01 00:00:00 +0000
+++ account_analytic_package/account_analytic_package.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,160 @@
+##############################################################################
+#    
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.     
+#
+##############################################################################
+
+import operator
+from osv import osv, fields
+
+
+class account_analytic_account(osv.osv):
+    _inherit = "account.analytic.account"
+    _columns = {
+        'package_ok': fields.boolean('Used in Package'),
+    }
+account_analytic_account()
+
+
+class product_product(osv.osv):
+    _inherit = "product.product"
+    _columns = {
+        'package_weight': fields.float('Package Weight', digits=(16,2)),
+    }
+    _defaults = {
+        'package_weight': lambda *args: 0.0
+    }
+product_product()
+
+class crm_case_section(osv.osv):
+    _inherit = "crm.case.section"
+    _columns = {
+        'package_product_id': fields.many2one('product.product', 'Package Product'),
+        'analytic_account_id': fields.many2one('account.analytic.account', 'Main Analytic Account'),
+        'analytic_journal_id': fields.many2one('account.analytic.journal', 'Analytic Journal'),
+    }
+crm_case_section()
+
+class crm_case(osv.osv):
+    _inherit = "crm.case"
+    def case_open(self, cr, uid, ids, *args):
+        res = super(crm_case, self).case_open(cr, uid, ids, *args)
+        for case in self.browse(cr,uid, ids):
+            section = case.section_id
+            if section.package_product_id and section.analytic_account_id and section.analytic_journal_id:
+                partner = self.pool.get('res.users').browse(cr, uid, uid).address_id.partner_id.id
+                aids = self.pool.get('account.analytic.account').search(cr, uid, [('partner_id','=',partner),('state','in',('open','draft','pending')),('parent_id','child_of',[section.analytic_account_id.id])])
+                if not aids:
+                    raise osv.except_osv('You can not open this case !', 'No valid analytic account defined for your user.\nPlease contact the administrator.')
+                self.pool.get('account.analytic.line').create(cr, uid, {
+                    'name': case.name,
+                    'amount': 0.0,
+                    'unit_amount': 1,
+                    'product_uom_id': section.package_product_id.uom_id.id,
+                    'product_id': section.package_product_id.id,
+                    'account_id': aids[0],
+                    'general_account_id': section.package_product_id.property_account_income.id or section.package_product_id.categ_id.property_account_income_categ.id,
+                    'journal_id': section.analytic_journal_id.id,
+                    'user_id': uid,
+                    'ref': 'CASE'+str(case.id)
+                })
+        return res
+crm_case()
+
+
+class account_analytic_line_package(osv.osv):
+    _name = "account.analytic.line.package"
+    _auto = False
+    _order = 'date desc'
+    def init(self, cr):
+        cr.execute("""
+            CREATE OR REPLACE VIEW account_analytic_line_package AS (
+                select
+                    l.id,
+                    l.name,
+                    l.date,
+                    a.partner_id,
+                    a.id as account_id,
+                    l.product_id,
+                    p.package_weight as unit_weight,
+                    p.package_weight*l.unit_amount as total_weight,
+                    l.unit_amount 
+                from 
+                    account_analytic_line l 
+                left join 
+                    account_analytic_account a on (l.account_id=a.id) 
+                left join 
+                    product_product p on (p.id=l.product_id) 
+                where 
+                    l.product_id is not null and
+                    p.package_weight<>0 and
+                    a.package_ok
+            )
+        """)
+    _columns = {
+        'name': fields.char('Name', size=128, readonly=True, select=1),
+        'date': fields.date('Date', readonly=True, select=1),
+        'partner_id': fields.many2one('res.partner', 'Partner', readonly=True),
+        'account_id': fields.many2one('account.analytic.account', 'Account', readonly=True),
+        'product_id': fields.many2one('product.product', 'Product', select=2, readonly=True),
+        'unit_amount': fields.float('Quantity', readonly=True),
+        'unit_weight': fields.float('Unit Weight', readonly=True),
+        'total_weight': fields.float('Total Weight', readonly=True),
+    }
+account_analytic_line_package()
+
+class account_analytic_line_package_month(osv.osv):
+    _name = "account.analytic.line.package.month"
+    _auto = False
+    def init(self, cr):
+        cr.execute("""
+            CREATE OR REPLACE VIEW account_analytic_line_package_month AS (
+                select
+                    min(l.id) as id,
+                    to_char(l.date, 'YYYY-MM-01') as name,
+                    a.partner_id,
+                    l.product_id,
+                    sum(p.package_weight*l.unit_amount) as total_weight,
+                    sum(case when p.package_weight>0 then p.package_weight*l.unit_amount else 0 end) as total_activity,
+                    sum(case when p.package_weight<0 then -p.package_weight*l.unit_amount else 0 end) as total_service
+                from 
+                    account_analytic_line l 
+                left join 
+                    account_analytic_account a on (l.account_id=a.id) 
+                left join 
+                    product_product p on (p.id=l.product_id) 
+                where 
+                    l.product_id is not null and
+                    p.package_weight<>0 and
+                    a.package_ok
+                group by
+                    l.product_id,
+                    a.partner_id,
+                    to_char(l.date, 'YYYY-MM-01')
+            )
+        """)
+    _columns ={
+        'name': fields.date('Date', readonly=True, select=1),
+        'partner_id': fields.many2one('res.partner', 'Partner', readonly=True),
+        'product_id': fields.many2one('product.product', 'Product', select=2, readonly=True),
+        'total_weight': fields.float('Total Weight', readonly=True),
+        'total_activity': fields.float('Total Activity', readonly=True),
+        'total_service': fields.float('Total Service', readonly=True),
+    }
+account_analytic_line_package_month()
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_analytic_package/account_analytic_package_view.xml'
--- account_analytic_package/account_analytic_package_view.xml	1970-01-01 00:00:00 +0000
+++ account_analytic_package/account_analytic_package_view.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,235 @@
+<?xml version="1.0" ?>
+<openerp>
+	<data>
+
+	<record model="ir.ui.view" id="view_account_analytic_package">
+		<field name="name">account.analytic.account.package.form</field>
+		<field name="model">account.analytic.account</field>
+		<field name="inherit_id" ref="account.view_account_analytic_account_form" />
+		<field name="type">form</field>
+		<field name="arch" type="xml">
+			<notebook position="inside">
+				<page string="Package Weight">
+					<field name="package_ok"/>
+				</page>
+			</notebook>
+		</field>
+	</record>
+
+
+	<record model="ir.ui.view" id="view_crm_section_form_package">
+		<field name="name">crm.case.section.package.form</field>
+		<field name="model">crm.case.section</field>
+		<field name="inherit_id" ref="crm.crm_case_section_view_form" />
+		<field name="type">form</field>
+		<field name="arch" type="xml">
+			<notebook position="inside">
+				<page string="Package Weight">
+					<separator string="Analytic Package" colspan="4"/>
+					<field name="package_product_id" colspan="4" />
+					<field name="analytic_journal_id" colspan="4" />
+					<field name="analytic_account_id" colspan="4" />
+					<label string="The parent account of all package account" colspan="4"/>
+				</page>
+			</notebook>
+		</field>
+	</record>
+
+
+	<record model="ir.ui.view" id="view_product_form_package">
+		<field name="name">product.normal.package.form</field>
+		<field name="model">product.product</field>
+		<field name="inherit_id" ref="product.product_normal_form_view" />
+		<field name="type">form</field>
+		<field name="arch" type="xml">
+			<notebook position="inside">
+				<page string="Package Units">
+				<separator string="Analytic Package" colspan="4"/>
+				<field name="package_weight" colspan="4" />
+				<label string="Zero if not part of a package" colspan="4"/>
+				<label string="&lt;0 if it's a service unit" colspan="4"/>
+				<label string="&gt;0 if it's a activity unit" colspan="4"/>
+				</page>
+			</notebook>
+		</field>
+	</record>
+
+	<record model="ir.ui.view" id="view_account_analytic_line_package_tree_simplified">
+		<field name="name">account.analytic.line.package.simplified.tree</field>
+		<field name="model">account.analytic.line.package</field>
+		<field name="type">tree</field>
+		<field name="priority">32</field>
+		<field name="arch" type="xml">
+			<tree string="Service &amp; Activity Units">
+				<field name="date"/>
+				<field name="name"/>
+				<field name="product_id"/>
+				<field name="unit_amount"/>
+				<field name="unit_weight"/>
+				<field name="total_weight" sum="Units"/>
+			</tree>
+		</field>
+	</record>
+	<record model="ir.actions.act_window" id="action_account_analytic_line_package_tree_simplified">
+		<field name="name">Service &amp; Activity Units (no partner and account)</field>
+		<field name="res_model">account.analytic.line.package</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">tree</field>
+		<field name="view_id" ref="view_account_analytic_line_package_tree_simplified"/>
+	</record>
+
+
+	<record model="ir.ui.view" id="view_account_analytic_line_package_form">
+		<field name="name">account.analytic.line.package.form</field>
+		<field name="model">account.analytic.line.package</field>
+		<field name="type">form</field>
+		<field name="arch" type="xml">
+			<form string="Service &amp; Activity Units">
+				<field name="date" select="1"/>
+				<field name="name" select="2"/>
+				<field name="partner_id" select="1"/>
+				<field name="account_id" select="1"/>
+				<field name="product_id" select="2"/>
+				<field name="unit_amount"/>
+				<field name="unit_weight"/>
+				<field name="total_weight" sum="Units"/>
+			</form>
+		</field>
+	</record>
+	<record model="ir.ui.view" id="view_account_analytic_line_package_tree">
+		<field name="name">account.analytic.line.package.tree</field>
+		<field name="model">account.analytic.line.package</field>
+		<field name="type">tree</field>
+		<field name="arch" type="xml">
+			<tree string="Service &amp; Activity Units">
+				<field name="date"/>
+				<field name="name"/>
+				<field name="partner_id"/>
+				<field name="account_id"/>
+				<field name="product_id"/>
+				<field name="unit_amount"/>
+				<field name="unit_weight"/>
+				<field name="total_weight" sum="Units"/>
+			</tree>
+		</field>
+	</record>
+	<record model="ir.actions.act_window" id="action_account_analytic_line_package_tree">
+		<field name="name">Service &amp; Activity Units</field>
+		<field name="res_model">account.analytic.line.package</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">tree</field>
+		<field name="view_id" ref="view_account_analytic_line_package_tree"/>
+	</record>
+	<menuitem name="Packages" id="menu_account_analytic_line_package" parent="account.menu_finance_reporting"/>
+	<menuitem name="Service &amp; Activity Units" parent="menu_account_analytic_line_package" 
+		id="menu_account_analytic_line_package_tree" 
+		action="action_account_analytic_line_package_tree"/>
+
+	<record model="ir.actions.act_window" id="action_account_analytic_line_package_service_tree">
+		<field name="name">Service Units</field>
+		<field name="res_model">account.analytic.line.package</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">tree</field>
+		<field name="domain">[('total_weight','&lt;=',0.0)]</field>
+		<field name="view_id" ref="view_account_analytic_line_package_tree"/>
+	</record>
+	<menuitem  parent="menu_account_analytic_line_package_tree"
+		id="menu_account_analytic_line_package_service_tree" 
+		action="action_account_analytic_line_package_service_tree"/>
+	<record model="ir.actions.act_window" id="action_account_analytic_line_package_activity_tree">
+		<field name="name">Activity Units</field>
+		<field name="res_model">account.analytic.line.package</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">tree</field>
+		<field name="domain">[('total_weight','&gt;=',0.0)]</field>
+		<field name="view_id" ref="view_account_analytic_line_package_tree"/>
+	</record>
+	<menuitem  parent="menu_account_analytic_line_package_tree"
+		id="menu_account_analytic_line_package_activity_tree" 
+		action="action_account_analytic_line_package_activity_tree"/>
+
+
+	<record model="ir.ui.view" id="view_account_analytic_line_package_month_graph">
+		<field name="name">account.analytic.line.package.month.graph</field>
+		<field name="model">account.analytic.line.package.month</field>
+		<field name="type">graph</field>
+		<field name="arch" type="xml">
+			<graph string="Analytic Package" type="bar">
+				<field name="name"/>
+				<field name="total_activity" operator="+"/>
+				<field name="total_service" operator="+"/>
+			</graph>
+		</field>
+	</record>
+	<record model="ir.ui.view" id="view_account_analytic_line_package_month_form">
+		<field name="name">account.analytic.line.package.month.form</field>
+		<field name="model">account.analytic.line.package.month</field>
+		<field name="type">form</field>
+		<field name="arch" type="xml">
+			<form string="Analytic Package">
+				<field name="name" select="1"/>
+				<field name="partner_id" select="1"/>
+				<field name="product_id" select="2"/>
+				<field name="total_weight" sum="Signed Units" select="2"/>
+				<field name="total_activity" sum="Activity Units" select="2"/>
+				<field name="total_service" sum="Service Units" select="2"/>
+			</form>
+		</field>
+	</record>
+	<record model="ir.ui.view" id="view_account_analytic_line_package_month_tree">
+		<field name="name">account.analytic.line.package.month.tree</field>
+		<field name="model">account.analytic.line.package.month</field>
+		<field name="type">tree</field>
+		<field name="arch" type="xml">
+			<tree string="Analytic Package">
+				<field name="name"/>
+				<field name="partner_id"/>
+				<field name="product_id"/>
+				<field name="total_weight" sum="Signed Units"/>
+				<field name="total_activity" sum="Activity Units"/>
+				<field name="total_service" sum="Service Units"/>
+			</tree>
+		</field>
+	</record>
+	<record model="ir.actions.act_window" id="action_account_analytic_line_package_month_tree">
+		<field name="name">Monthly Services &amp; Activity Units</field>
+		<field name="res_model">account.analytic.line.package.month</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">graph,tree</field>
+		<field name="view_id" eval="False"/>
+	</record>
+	<menuitem parent="menu_account_analytic_line_package"
+		id="menu_account_analytic_line_package_month_tree" 
+		action="action_account_analytic_line_package_month_tree"/>
+
+	<record model="ir.ui.view" id="package_product_tree">
+		<field name="name">Products List</field>
+		<field name="model">product.product</field>
+		<field name="type">tree</field>
+		<field name="priority">64</field>
+		<field name="arch" type="xml">
+			<tree string="Products Units" link="0">
+				<field name="name"/>
+				<field name="package_weight"/>
+			</tree>
+		</field>
+	</record>
+	<record model="ir.actions.act_window" id="action_package_product_tree">
+		<field name="name">Products Units</field>
+		<field name="res_model">product.product</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">tree</field>
+		<field name="view_id" eval="package_product_tree"/>
+		<field name="domain">[('package_weight','&lt;&gt;',0)]</field>
+	</record>
+	<menuitem parent="menu_account_analytic_line_package" 
+		id="menu_action_package_product_tree" 
+		action="action_package_product_tree"/>
+
+
+
+
+
+
+	</data>
+</openerp>

=== added directory 'account_analytic_package/i18n'
=== added file 'account_analytic_package/i18n/account_analytic_package.pot'
--- account_analytic_package/i18n/account_analytic_package.pot	1970-01-01 00:00:00 +0000
+++ account_analytic_package/i18n/account_analytic_package.pot	2012-06-28 13:21:29 +0000
@@ -0,0 +1,220 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_analytic_package
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 5.0.6\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2009-11-24 12:16:03+0000\n"
+"PO-Revision-Date: 2009-11-24 12:16:03+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: account_analytic_package
+#: constraint:ir.model:0
+msgid "The Object name must start with x_ and not contain any special character !"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+msgid "Signed Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.model,name:account_analytic_package.model_account_analytic_line_package
+msgid "account.analytic.line.package"
+msgstr ""
+
+#. module: account_analytic_package
+#: constraint:ir.ui.view:0
+msgid "Invalid XML for View Architecture!"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.account:0
+#: view:crm.case.section:0
+#: field:product.product,package_weight:0
+msgid "Package Weight"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_tree
+msgid "Service & Activity Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: constraint:ir.actions.act_window:0
+msgid "Invalid model name in the action definition."
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package:0
+msgid "Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "<0 if it's a service unit"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_tree_simplified
+msgid "Service & Activity Units (no partner and account)"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,product_id:0
+#: field:account.analytic.line.package.month,product_id:0
+msgid "Product"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:crm.case.section,analytic_journal_id:0
+msgid "Analytic Journal"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: view:crm.case.section:0
+#: view:product.product:0
+msgid "Analytic Package"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "Zero if not part of a package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package.month,total_service:0
+msgid "Total Service"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,unit_weight:0
+msgid "Unit Weight"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "Package Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,date:0
+#: field:account.analytic.line.package.month,name:0
+msgid "Date"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package
+msgid "Packages"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_service_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_service_tree
+msgid "Service Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,total_weight:0
+#: field:account.analytic.line.package.month,total_weight:0
+msgid "Total Weight"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_package_product_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_action_package_product_tree
+#: view:product.product:0
+msgid "Products Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.module.module,description:account_analytic_package.module_meta_information
+msgid "The Module allows to configure analytic account for product packages.\n"
+"    Views for total and monthly product packages weight, Amount analysis."
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,account_id:0
+msgid "Account"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.module.module,shortdesc:account_analytic_package.module_meta_information
+msgid "account_analytic_package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,name:0
+msgid "Name"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_activity_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_activity_tree
+msgid "Activity Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:crm.case.section:0
+msgid "The parent account of all package account"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:crm.case.section,package_product_id:0
+msgid "Package Product"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid ">0 if it's a activity unit"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_month_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_month_tree
+msgid "Monthly Services & Activity Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.model,name:account_analytic_package.model_account_analytic_line_package_month
+msgid "account.analytic.line.package.month"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,unit_amount:0
+msgid "Quantity"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:crm.case.section,analytic_account_id:0
+msgid "Main Analytic Account"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.account,package_ok:0
+msgid "Used in Package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,partner_id:0
+#: field:account.analytic.line.package.month,partner_id:0
+msgid "Partner"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package.month,total_activity:0
+msgid "Total Activity"
+msgstr ""
+

=== added file 'account_analytic_package/i18n/fr_BE.po'
--- account_analytic_package/i18n/fr_BE.po	1970-01-01 00:00:00 +0000
+++ account_analytic_package/i18n/fr_BE.po	2012-06-28 13:21:29 +0000
@@ -0,0 +1,220 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_analytic_package
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 5.0.6\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2009-11-24 12:16:03+0000\n"
+"PO-Revision-Date: 2009-11-24 12:16:03+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: account_analytic_package
+#: constraint:ir.model:0
+msgid "The Object name must start with x_ and not contain any special character !"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+msgid "Signed Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.model,name:account_analytic_package.model_account_analytic_line_package
+msgid "account.analytic.line.package"
+msgstr ""
+
+#. module: account_analytic_package
+#: constraint:ir.ui.view:0
+msgid "Invalid XML for View Architecture!"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.account:0
+#: view:crm.case.section:0
+#: field:product.product,package_weight:0
+msgid "Package Weight"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_tree
+msgid "Service & Activity Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: constraint:ir.actions.act_window:0
+msgid "Invalid model name in the action definition."
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package:0
+msgid "Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "<0 if it's a service unit"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_tree_simplified
+msgid "Service & Activity Units (no partner and account)"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,product_id:0
+#: field:account.analytic.line.package.month,product_id:0
+msgid "Product"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:crm.case.section,analytic_journal_id:0
+msgid "Analytic Journal"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: view:crm.case.section:0
+#: view:product.product:0
+msgid "Analytic Package"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "Zero if not part of a package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package.month,total_service:0
+msgid "Total Service"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,unit_weight:0
+msgid "Unit Weight"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "Package Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,date:0
+#: field:account.analytic.line.package.month,name:0
+msgid "Date"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package
+msgid "Packages"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_service_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_service_tree
+msgid "Service Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,total_weight:0
+#: field:account.analytic.line.package.month,total_weight:0
+msgid "Total Weight"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_package_product_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_action_package_product_tree
+#: view:product.product:0
+msgid "Products Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.module.module,description:account_analytic_package.module_meta_information
+msgid "The Module allows to configure analytic account for product packages.\n"
+"    Views for total and monthly product packages weight, Amount analysis."
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,account_id:0
+msgid "Account"
+msgstr "Compte"
+
+#. module: account_analytic_package
+#: model:ir.module.module,shortdesc:account_analytic_package.module_meta_information
+msgid "account_analytic_package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,name:0
+msgid "Name"
+msgstr "Nom"
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_activity_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_activity_tree
+msgid "Activity Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:crm.case.section:0
+msgid "The parent account of all package account"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:crm.case.section,package_product_id:0
+msgid "Package Product"
+msgstr ""
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid ">0 if it's a activity unit"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_month_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_month_tree
+msgid "Monthly Services & Activity Units"
+msgstr ""
+
+#. module: account_analytic_package
+#: model:ir.model,name:account_analytic_package.model_account_analytic_line_package_month
+msgid "account.analytic.line.package.month"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,unit_amount:0
+msgid "Quantity"
+msgstr "Quantité"
+
+#. module: account_analytic_package
+#: field:crm.case.section,analytic_account_id:0
+msgid "Main Analytic Account"
+msgstr "Compte analytique principal"
+
+#. module: account_analytic_package
+#: field:account.analytic.account,package_ok:0
+msgid "Used in Package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,partner_id:0
+#: field:account.analytic.line.package.month,partner_id:0
+msgid "Partner"
+msgstr "Partenaire"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package.month,total_activity:0
+msgid "Total Activity"
+msgstr ""
+

=== added file 'account_analytic_package/i18n/pl.po'
--- account_analytic_package/i18n/pl.po	1970-01-01 00:00:00 +0000
+++ account_analytic_package/i18n/pl.po	2012-06-28 13:21:29 +0000
@@ -0,0 +1,227 @@
+# Polish translation for openobject-addons
+# Copyright (c) 2010 Rosetta Contributors and Canonical Ltd 2010
+# This file is distributed under the same license as the openobject-addons package.
+# FIRST AUTHOR <EMAIL@ADDRESS>, 2010.
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: openobject-addons\n"
+"Report-Msgid-Bugs-To: FULL NAME <EMAIL@ADDRESS>\n"
+"POT-Creation-Date: 2009-11-24 12:16+0000\n"
+"PO-Revision-Date: 2010-05-31 04:43+0000\n"
+"Last-Translator: OpenERP Administrators <Unknown>\n"
+"Language-Team: Polish <[e-mail]>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"X-Launchpad-Export-Date: 2010-08-26 04:05+0000\n"
+"X-Generator: Launchpad (build Unknown)\n"
+
+#. module: account_analytic_package
+#: constraint:ir.model:0
+msgid ""
+"The Object name must start with x_ and not contain any special character !"
+msgstr ""
+"Nazwa obiektu musi zaczynać się od x_ oraz nie może zawierać znaków "
+"specjalnych !"
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+msgid "Signed Units"
+msgstr "Uzgodnione jednostki"
+
+#. module: account_analytic_package
+#: model:ir.model,name:account_analytic_package.model_account_analytic_line_package
+msgid "account.analytic.line.package"
+msgstr ""
+
+#. module: account_analytic_package
+#: constraint:ir.ui.view:0
+msgid "Invalid XML for View Architecture!"
+msgstr "XML niewłaściwy dla tej architektury wyświetlania!"
+
+#. module: account_analytic_package
+#: view:account.analytic.account:0
+#: view:crm.case.section:0
+#: field:product.product,package_weight:0
+msgid "Package Weight"
+msgstr "Waga opakowania"
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_tree
+msgid "Service & Activity Units"
+msgstr "Jednostki usług i aktywności"
+
+#. module: account_analytic_package
+#: constraint:ir.actions.act_window:0
+msgid "Invalid model name in the action definition."
+msgstr "Nieprawidłowa nazwa modelu w definicji akcji."
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package:0
+msgid "Units"
+msgstr "Jednostki"
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "<0 if it's a service unit"
+msgstr "<0 jeśli jednostka usługi"
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_tree_simplified
+msgid "Service & Activity Units (no partner and account)"
+msgstr "Jednostki usług i aktywności (bez partnerów i kont)"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,product_id:0
+#: field:account.analytic.line.package.month,product_id:0
+msgid "Product"
+msgstr "Produkt"
+
+#. module: account_analytic_package
+#: field:crm.case.section,analytic_journal_id:0
+msgid "Analytic Journal"
+msgstr "Dziennik analityczny"
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: view:crm.case.section:0
+#: view:product.product:0
+msgid "Analytic Package"
+msgstr "Analityka opakowania"
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "Zero if not part of a package"
+msgstr "Zero , jeśli nie jest częścią opakowania"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package.month,total_service:0
+msgid "Total Service"
+msgstr "Suma usług"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,unit_weight:0
+msgid "Unit Weight"
+msgstr "Waga jednostkowa"
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid "Package Units"
+msgstr "Jednostki opakowania"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,date:0
+#: field:account.analytic.line.package.month,name:0
+msgid "Date"
+msgstr "Data"
+
+#. module: account_analytic_package
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package
+msgid "Packages"
+msgstr "Opakowania"
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_service_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_service_tree
+msgid "Service Units"
+msgstr "Jednostki usług"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,total_weight:0
+#: field:account.analytic.line.package.month,total_weight:0
+msgid "Total Weight"
+msgstr "Suma wag"
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_package_product_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_action_package_product_tree
+#: view:product.product:0
+msgid "Products Units"
+msgstr "Jednostki produktów"
+
+#. module: account_analytic_package
+#: model:ir.module.module,description:account_analytic_package.module_meta_information
+msgid ""
+"The Module allows to configure analytic account for product packages.\n"
+"    Views for total and monthly product packages weight, Amount analysis."
+msgstr ""
+"Moduł pozwala konfigurować konto analityczne dla opakowań produktu.\n"
+"    Widoki dla sum i miesięcznych wag opakowań, Analiza wartościowa."
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,account_id:0
+msgid "Account"
+msgstr "Konto"
+
+#. module: account_analytic_package
+#: model:ir.module.module,shortdesc:account_analytic_package.module_meta_information
+msgid "account_analytic_package"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,name:0
+msgid "Name"
+msgstr "Nazwa"
+
+#. module: account_analytic_package
+#: view:account.analytic.line.package.month:0
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_activity_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_activity_tree
+msgid "Activity Units"
+msgstr "Jednostki aktywności"
+
+#. module: account_analytic_package
+#: view:crm.case.section:0
+msgid "The parent account of all package account"
+msgstr "Konto nadrzędne dla wszystkich kont opakowań"
+
+#. module: account_analytic_package
+#: field:crm.case.section,package_product_id:0
+msgid "Package Product"
+msgstr "Opakowanie produktu"
+
+#. module: account_analytic_package
+#: view:product.product:0
+msgid ">0 if it's a activity unit"
+msgstr ">0 jeśli jednostka aktywności"
+
+#. module: account_analytic_package
+#: model:ir.actions.act_window,name:account_analytic_package.action_account_analytic_line_package_month_tree
+#: model:ir.ui.menu,name:account_analytic_package.menu_account_analytic_line_package_month_tree
+msgid "Monthly Services & Activity Units"
+msgstr "Jednostki miesięcznych usług i aktywności"
+
+#. module: account_analytic_package
+#: model:ir.model,name:account_analytic_package.model_account_analytic_line_package_month
+msgid "account.analytic.line.package.month"
+msgstr ""
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,unit_amount:0
+msgid "Quantity"
+msgstr "Ilość"
+
+#. module: account_analytic_package
+#: field:crm.case.section,analytic_account_id:0
+msgid "Main Analytic Account"
+msgstr "Główne konto analityczne"
+
+#. module: account_analytic_package
+#: field:account.analytic.account,package_ok:0
+msgid "Used in Package"
+msgstr "Stosowane w opakowaniach"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package,partner_id:0
+#: field:account.analytic.line.package.month,partner_id:0
+msgid "Partner"
+msgstr "Partner"
+
+#. module: account_analytic_package
+#: field:account.analytic.line.package.month,total_activity:0
+msgid "Total Activity"
+msgstr "Suma aktywności"

=== added directory 'account_analytic_package/security'
=== added file 'account_analytic_package/security/ir.model.access.csv'
--- account_analytic_package/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_analytic_package/security/ir.model.access.csv	2012-06-28 13:21:29 +0000
@@ -0,0 +1,3 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_account_analytic_line_package","account.analytic.line.package","model_account_analytic_line_package","account.group_account_user",1,1,1,1
+"access_account_analytic_line_package_month","account.analytic.line.package.month","model_account_analytic_line_package_month","account.group_account_user",1,1,1,1
\ No newline at end of file

=== added directory 'account_coda'
=== renamed directory 'account_coda' => 'account_coda.moved'
=== added file 'account_coda/__init__.py'
--- account_coda/__init__.py	1970-01-01 00:00:00 +0000
+++ account_coda/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,26 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#    
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.     
+#
+##############################################################################
+
+import account_coda
+import wizard
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_coda/__terp__.py'
--- account_coda/__terp__.py	1970-01-01 00:00:00 +0000
+++ account_coda/__terp__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,44 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+{
+    "name"      : "Account CODA - import bank statements from coda file",
+    "version"   : "1.0",
+    "author"    : "OpenERP SA",
+    "category"  : "Account CODA",
+    "description": """
+    Module provides functionality to import
+    bank statements from coda files.
+    """,
+    "depends"   : ["account"],
+    "demo_xml"  : [],
+    "init_xml"  : [],
+    "update_xml": ["security/ir.model.access.csv",
+                    "wizard/account_coda_import.xml",
+                    "account_coda_view.xml"],
+    "active"    : False,
+    "installable" : True,
+
+'certificate': '001319613245022826189',
+}
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_coda/account_coda.py'
--- account_coda/account_coda.py	1970-01-01 00:00:00 +0000
+++ account_coda/account_coda.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,51 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import time
+from osv import osv,fields
+
+class account_coda(osv.osv):
+    _name = "account.coda"
+    _description = "coda for an Account"
+    _columns = {
+        'name': fields.binary('Coda file', readonly=True, help="Store the detail of bank statements"),
+        'statement_ids': fields.one2many('account.bank.statement', 'coda_id', 'Generated Bank Statements', readonly=True),
+        'note': fields.text('Import log', readonly=True),
+        'journal_id': fields.many2one('account.journal', 'Journal', readonly=True, select=True, help="Bank Journal"),
+        'date': fields.date('Date', readonly=True, select=True, help="Import Date"),
+        'user_id': fields.many2one('res.users', 'User', readonly=True, select=True),
+    }
+    _defaults = {
+        'date': time.strftime('%Y-%m-%d'),
+        'user_id': lambda self,cr,uid,context: uid,
+    }
+    
+account_coda()
+
+class account_bank_statement(osv.osv):
+    _inherit = "account.bank.statement"
+    _columns = {
+        'coda_id':fields.many2one('account.coda', 'Coda'),
+    }
+    
+account_bank_statement()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
\ No newline at end of file

=== added file 'account_coda/account_coda_demo.xml'
--- account_coda/account_coda_demo.xml	1970-01-01 00:00:00 +0000
+++ account_coda/account_coda_demo.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,5 @@
+<?xml version="1.0"?>
+<openerp>
+<data noupdate="1">
+</data>
+</openerp>

=== added file 'account_coda/account_coda_view.xml'
--- account_coda/account_coda_view.xml	1970-01-01 00:00:00 +0000
+++ account_coda/account_coda_view.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,64 @@
+<?xml version="1.0" ?>
+<openerp>
+<data>
+
+	<record model="ir.ui.view" id="view_account_coda_form">
+		<field name="name">account.coda.form</field>
+		<field name="model">account.coda</field>
+		<field name="type">form</field>
+		<field name="arch" type="xml">
+			<form string="Coda import">
+				<field name="name" />
+				<field name="journal_id" />
+				<field name="date" />
+				<field name="user_id" />
+				<notebook colspan="4">
+					<page string="Log">
+					   <field name="note" colspan="4" nolabel="1"/>
+					</page>
+					<page string="Statements">
+					   <field name="statement_ids" colspan="4" nolabel="1"/>
+					</page>
+				</notebook>
+			</form>
+		</field>
+	</record>
+
+	<record model="ir.ui.view" id="view_account_coda_tree">
+		<field name="name">account.coda.tree</field>
+		<field name="model">account.coda</field>
+		<field name="type">tree</field>
+		<field name="arch" type="xml">
+			<tree string="Coda import">
+				<field name="journal_id" />
+				<field name="date" />
+				<field name="user_id" />
+				<field name="statement_ids"/>
+			</tree>
+		</field>
+	</record>
+
+
+	<record model="ir.actions.act_window" id="action_account_coda">
+		<field name="name">Coda Statements</field>
+		<field name="type">ir.actions.act_window</field>
+		<field name="res_model">account.coda</field>
+		<field name="view_type">form</field>
+		<field name="view_mode">tree,form</field>
+	</record>
+
+
+	<menuitem name="Financial Management/Reporting/Coda Statements" id="menu_account_coda_statement" action="action_account_coda" sequence="15"/>
+
+	<menuitem name="Financial Management/Periodical Processing/Import Coda Statements" action="action_account_coda_import" id="menu_account_coda_import" sequence="13"/>
+
+	<act_window name="Coda File"
+		domain="[('statement_ids', 'in', [active_id])]"
+		res_model="account.coda"
+		src_model="account.bank.statement"
+		view_type="form"
+		view_mode="tree,form"
+ 		id="act_account_payment_account_bank_statement"/>
+
+	</data>
+</openerp>

=== added directory 'account_coda/i18n'
=== added directory 'account_coda/security'
=== added file 'account_coda/security/ir.model.access.csv'
--- account_coda/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_coda/security/ir.model.access.csv	2012-06-28 13:21:29 +0000
@@ -0,0 +1,6 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_account_coda","account.coda","model_account_coda","account.group_account_user",1,0,0,0
+"access_account_coda_manager","account.coda","model_account_coda","account.group_account_manager",1,1,1,1
+"access_account_coda_import_manager","account.coda.import","model_account_coda_import","account.group_account_manager",1,1,1,1
+"access_account_coda_import_user","account.coda","model_account_coda","account.group_account_user",1,0,0,0
+"access_account_coda_system","account.coda system","model_account_coda","base.group_system",1,0,0,0

=== added directory 'account_coda/test_coda_file'
=== added file 'account_coda/test_coda_file/statement_coda.txt'
--- account_coda/test_coda_file/statement_coda.txt	1970-01-01 00:00:00 +0000
+++ account_coda/test_coda_file/statement_coda.txt	2012-06-28 13:21:29 +0000
@@ -0,0 +1,10 @@
+0000006060712505   00000CPH CODA  TINY                      0047747270100477472701 00000                                       1
+1 049126201326907 EUR0BE                  0000000015632900050607TINY                      COMPTE COURANT ORDINAIRE           049
[phone]                     0000000001150000060607001500000INVOICE OF 2006-12-19                                0606070020100
[phone]                                                                               EUR000000001150000                  100
+2300010000301915554082                         PROLIBRE SARL             CAROUGE GE                                          000
[phone]                     0000000000500000060607001500000CONTRACT PARTNER ERREUR ECART      YEA               0606070030100
[phone]RTY CONTRACT PARTNER                                                           EUR000000000500000                  100
+2300020000050000000017                         SEDNACOM                  43 ALLEE DES FOUGERES     9522 0 HERBLAY            000
+8049126201326907                         0000000017282900060607                                                                 
+9               000008000000000000000000000001650000                                                                           2

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

=== added file 'account_coda/wizard/account_coda_import.py'
--- account_coda/wizard/account_coda_import.py	1970-01-01 00:00:00 +0000
+++ account_coda/wizard/account_coda_import.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,309 @@
+# -*- 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/>.
+#
+##############################################################################
+
+import time
+import base64
+
+from osv import fields
+from osv import osv
+from tools.translate import _
+
+def str2date(date_str):
+    return time.strftime("%y/%m/%d", time.strptime(date_str, "%d%m%y"))
+
+def str2float(str):
+    try:
+        return float(str)
+    except:
+        return 0.0
+
+def list2float(lst):
+    try:
+        return str2float((lambda s : s[:-3] + '.' + s[-3:])(lst))
+    except:
+        return 0.0
+
+class account_coda_import(osv.osv_memory):
+    _name = 'account.coda.import'
+    _description = 'Account Coda Import'
+    _columns = {
+            'journal_id': fields.many2one('account.journal', 'Bank Journal', required=True),
+            'def_payable': fields.many2one('account.account', 'Default Payable Account', domain=[('type', '=', 'payable')], required=True, help= 'Set here the payable account that will be used, by default, if the partner is not found'),
+            'def_receivable': fields.many2one('account.account', 'Default Receivable Account', domain=[('type', '=', 'receivable')], required=True, help= 'Set here the receivable account that will be used, by default, if the partner is not found',),
+            'awaiting_account': fields.many2one('account.account', 'Default Account for Unrecognized Movement', required=True, help= 'Set here the default account that will be used, if the partner is found but does not have the bank account , or if he is domiciled',),
+            'coda': fields.binary('Coda File', required=True),
+            'note':fields.text('Log'),
+    }
+    
+    def coda_parsing(self, cr, uid, ids, context=None):
+
+        journal_obj=self.pool.get('account.journal')
+        account_period_obj = self.pool.get('account.period')
+        partner_bank_obj = self.pool.get('res.partner.bank')
+        bank_statement_obj = self.pool.get('account.bank.statement')
+        move_line_obj = self.pool.get('account.move.line')
+        bank_statement_line_obj = self.pool.get('account.bank.statement.line')
+        statement_reconcile_obj = self.pool.get('account.bank.statement.reconcile')
+        account_coda_obj = self.pool.get('account.coda')
+        mod_obj = self.pool.get('ir.model.data')
+        
+        if not context:
+            context = {}
+            
+        data = self.read(cr, uid, ids)[0]
+
+        codafile = data['coda']
+        journal_code = journal_obj.browse(cr, uid, data['journal_id'], context).code
+
+        period = account_period_obj.find(cr, uid, context=context)[0]
+        def_pay_acc = data['def_payable']
+        def_rec_acc = data['def_receivable']
+
+        str_log = ""
+        err_log = "Errors:\n------\n"
+        nb_err=0
+        std_log=''
+        str_log1 = "Coda File is Imported  :  "
+        str_not=''
+        str_not1=''
+
+        bank_statements=[]
+        bank_statement = {}
+        recordlist = base64.decodestring(codafile).split('\n')
+        recordlist.pop()
+        i=0
+        bkst_list=[]
+        for line in recordlist:
+            if line[0] == '0':
+                # header data
+
+                bank_statement["bank_statement_line"]={}
+                bank_statement_lines = {}
+                bank_statement['date'] = str2date(line[5:11])
+                bank_statement['journal_id']=data['journal_id']
+                period_id = account_period_obj.search(cr, uid, [('date_start', '<=', time.strftime('%Y-%m-%d', time.strptime(bank_statement['date'], "%y/%m/%d"))), ('date_stop', '>=', time.strftime('%Y-%m-%d', time.strptime(bank_statement['date'], "%y/%m/%d")))])
+                bank_statement['period_id'] = period_id and period_id[0] or False
+                bank_statement['state']='draft'
+            elif line[0] == '1':
+                # old balance data
+                bal_start = list2float(line[43:58])
+                if line[42] == '1':
+                    bal_start = - bal_start
+                bank_statement["balance_start"]= bal_start
+                bank_statement["acc_number"]=line[5:17]
+                bank_statement["acc_holder"]=line[64:90]
+                bank_statement['name'] = journal_code + ' ' + str(line[2:5])
+
+            elif line[0]=='2':
+                # movement data record 2
+                if line[1]=='1':
+                    # movement data record 2.1
+                    if bank_statement_lines.has_key(line[2:6]):
+                        continue
+                    st_line = {}
+                    st_line['extra_note'] = ''
+                    st_line['statement_id']=0
+                    st_line['ref'] = line[2:10]
+                    st_line['date'] = time.strftime('%Y-%m-%d', time.strptime(str2date(line[115:121]), "%y/%m/%d")),
+                    st_line_amt = list2float(line[32:47])
+
+                    if line[61]=='1':
+                        st_line['toreconcile'] = True
+                        st_line['name']=line[65:77]
+                    else:
+                        st_line['toreconcile'] = False
+                        st_line['name']=line[62:115]
+
+                    st_line['free_comm'] = st_line['name']
+                    st_line['val_date']=time.strftime('%Y-%m-%d', time.strptime(str2date(line[47:53]), "%y/%m/%d")),
+                    st_line['entry_date']=time.strftime('%Y-%m-%d', time.strptime(str2date(line[115:121]), "%y/%m/%d")),
+                    st_line['partner_id']=0
+                    if line[31] == '1':
+                        st_line_amt = - st_line_amt
+                        st_line['account_id'] = def_pay_acc
+                    else:
+                        st_line['account_id'] = def_rec_acc
+                    st_line['amount'] = st_line_amt
+                    bank_statement_lines[line[2:6]]=st_line
+                    bank_statement["bank_statement_line"]=bank_statement_lines
+                elif line[1] == '2':
+                    st_line_name = line[2:6]
+                    bank_statement_lines[st_line_name].update({'account_id': data['awaiting_account']})
+
+                elif line[1] == '3':
+                    # movement data record 3.1
+                    st_line_name = line[2:6]
+                    st_line_partner_acc = str(line[10:47]).strip()
+                    cntry_number=line[10:47].strip()
+                    contry_name=line[47:125].strip()
+                    bank_ids = partner_bank_obj.search(cr, uid, [('acc_number', '=', st_line_partner_acc)])
+                    bank_statement_lines[st_line_name].update({'cntry_number': cntry_number, 'contry_name': contry_name})
+                    if bank_ids:
+                        bank = partner_bank_obj.browse(cr, uid, bank_ids[0], context)
+                        if line and bank.partner_id:
+                            bank_statement_lines[st_line_name].update({'partner_id': bank.partner_id.id})
+                            if bank_statement_lines[st_line_name]['amount'] < 0 :
+                                bank_statement_lines[st_line_name].update({'account_id': bank.partner_id.property_account_payable.id})
+                            else :
+                                bank_statement_lines[st_line_name].update({'account_id': bank.partner_id.property_account_receivable.id})
+                    else:
+                        nb_err += 1
+                        err_log += _('The bank account %s is not defined for the partner %s.\n')%(cntry_number, contry_name)
+                        bank_statement_lines[st_line_name].update({'account_id': data['awaiting_account']})
+
+                    bank_statement["bank_statement_line"]=bank_statement_lines
+            elif line[0]=='3':
+                if line[1] == '1':
+                    st_line_name = line[2:6]
+                    bank_statement_lines[st_line_name]['extra_note'] += '\n' + line[40:113].decode('utf-8','replace').encode('utf-8')
+                elif line[1] == '2':
+                    st_line_name = line[2:6]
+                    bank_statement_lines[st_line_name]['extra_note'] += '\n' + line[10:115].decode('utf-8','replace').encode('utf-8')
+                elif line[1] == '3':
+                    st_line_name = line[2:6]
+                    bank_statement_lines[st_line_name]['extra_note'] += '\n' + line[10:100].decode('utf-8','replace').encode('utf-8')
+            elif line[0]=='8':
+                # new balance record
+                bal_end = list2float(line[42:57])
+                if line[41] == '1':
+                    bal_end = - bal_end
+                bank_statement["balance_end_real"]= bal_end
+
+            elif line[0]=='9':
+                # footer record
+                bank_statement['id%d'%i] = i
+                i+=1
+                bank_statements.append(bank_statement)
+                statement = bank_statement
+                try:
+                    bk_st_id =bank_statement_obj.create(cr, uid, {
+                        'journal_id': statement['journal_id'],
+                        'date':time.strftime('%Y-%m-%d', time.strptime(statement['date'], "%y/%m/%d")),
+                        'period_id':statement['period_id'] or period,
+                        'balance_start': statement["balance_start"],
+                        'balance_end_real': statement["balance_end_real"],
+                        'state': 'draft',
+                        'name': statement['name'],
+                    })
+                    lines=statement["bank_statement_line"]
+                    for value in lines:
+                        line=lines[value]
+                        reconcile_id = False
+                        if line['toreconcile']:
+                            name = line['name'][:3] + '/' + line['name'][3:7] + '/' + line['name'][7:]
+                            rec_id = self.pool.get('account.move.line').search(cr, uid, [('name','=', name),('reconcile_id','=',False),('account_id.reconcile','=',True)])
+                            if rec_id:
+                                reconcile_id = statement_reconcile_obj.create(cr, uid, {
+                                    'line_ids': [(6, 0, rec_id)]
+                                    }, context=context)
+                                mv = self.pool.get('account.move.line').browse(cr, uid, rec_id[0], context=context)
+                                if mv.partner_id:
+                                    line['partner_id'] = mv.partner_id.id
+                                    if line['amount'] < 0 :
+                                        line['account_id'] = mv.partner_id.property_account_payable.id
+                                    else :
+                                        line['account_id'] = mv.partner_id.property_account_receivable.id
+                        str_not1 = ''
+                        if line.has_key('contry_name') and line.has_key('cntry_number'):
+                            str_not1="Partner name:%s \n Partner Account Number:%s \n Communication:%s \n Value Date:%s \n Entry Date:%s \n"%(line["contry_name"], line["cntry_number"], line["free_comm"]+line['extra_note'].decode('utf-8','replace').encode('utf-8'), line["val_date"][0], line["entry_date"][0])
+                        id=bank_statement_line_obj.create(cr, uid, {
+                                   'name':line['name'],
+                                   'date': line['date'],
+                                   'type': (line['amount']>0 and 'customer') or  (line['amount']<0 and 'supplier') or 'general',
+                                   'amount': line['amount'],
+                                   'partner_id':line['partner_id'] or 0,
+                                   'account_id':line['account_id'],
+                                   'statement_id': bk_st_id,
+                                   'reconcile_id': reconcile_id,
+                                   'note':str_not1,
+                                   'ref':line['ref'],
+                                   })
+
+                    str_not= "\n \n Account Number: %s \n Account Holder Name: %s " %(statement["acc_number"], statement["acc_holder"])
+                    std_log += "\nStatement : %s , Date  : %s, Starting Balance :  %.2f , Ending Balance : %.2f \n"\
+                              %(statement['name'], statement['date'], float(statement["balance_start"]), float(statement["balance_end_real"]))
+                    bkst_list.append(bk_st_id)
+
+                except osv.except_osv, e:
+                    cr.rollback()
+                    nb_err+=1
+                    err_log += '\n Application Error : ' + str(e)
+                    raise # REMOVEME
+
+                except Exception, e:
+                    cr.rollback()
+                    nb_err+=1
+                    err_log += '\n System Error : '+str(e)
+                    raise # REMOVEME
+                except :
+                    cr.rollback()
+                    nb_err+=1
+                    err_log += '\n Unknown Error'
+                    raise
+            err_log += '\n\nNumber of statements : '+ str(len(bkst_list))
+            err_log += '\nNumber of error :'+ str(nb_err) +'\n'
+
+            account_coda_obj.create(cr, uid, {
+                'name':codafile,
+                'statement_ids': [(6, 0, bkst_list,)],
+                'note':str_log1+str_not+std_log+err_log,
+                'journal_id':data['journal_id'],
+                'date':time.strftime("%Y-%m-%d"),
+                'user_id':uid,
+                })
+            test=''
+            test=str_log1 + std_log + err_log
+        self.write(cr, uid, ids, {'note':test}, context=context)
+        extraction= { 'statment_ids':bkst_list}
+        context.update({ 'statment_ids':bkst_list})
+        model_data_ids = mod_obj.search(cr, uid, [('model', '=', 'ir.ui.view'), ('name', '=', 'account_coda_note_view')], context=context)
+        resource_id = mod_obj.read(cr, uid, model_data_ids, fields=['res_id'], context=context)[0]['res_id']
+        
+        return {
+                'name': _('Result'),
+                'res_id': ids[0],
+                'view_type': 'form',
+                'view_mode': 'form',
+                'res_model': 'account.coda.import',
+                'view_id': False,
+                'target':'new',
+                'views': [(resource_id, 'form')],
+                'context': context,
+                'type': 'ir.actions.act_window',
+        }
+        
+    def action_open_window(self, cr, uid, data, context=None):
+        if not context:
+            cotext = {}
+        return {
+            'domain':"[('id','in',%s)]"%(context.get('statment_ids', False)),
+            'name': 'Statement',
+            'view_type': 'form',
+            'view_mode': 'tree,form',
+            'res_model': 'account.bank.statement',
+            'view_id': False,
+            'type': 'ir.actions.act_window',
+        }
+        
+account_coda_import()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'account_coda/wizard/account_coda_import.xml'
--- account_coda/wizard/account_coda_import.xml	1970-01-01 00:00:00 +0000
+++ account_coda/wizard/account_coda_import.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,59 @@
+<?xml version="1.0" ?>
+<openerp>
+<data>
+        <record id="account_coda_import_view" model="ir.ui.view">
+             <field name="name">Import Coda Statement</field>
+             <field name="model">account.coda.import</field>
+             <field name="type">form</field>
+             <field name="arch" type="xml">
+				<form string="Import Coda Statement">
+				<separator colspan="4" string="Configure Your Journal and Account :" />
+				    <field name="journal_id" colspan="1" domain="[('type','=','cash')]" />
+				    <newline />
+				    <field name="def_payable" />
+				    <newline />
+				    <field name="def_receivable" />
+				    <newline />
+				    <field name="awaiting_account" />
+				    <separator string="Click on 'New' to select your file :" colspan="4"/>
+				    <field name="coda"/>
+				    <newline/>
+					<group colspan="4" col="6">
+                       	<separator colspan="6"/>
+     					<button special="cancel" string="Cancel" icon="gtk-cancel"/>
+               			<button name="coda_parsing" string="Import" type="object" icon="gtk-ok"/>
+ 					</group>				    
+				</form>
+			</field>
+		</record>
+		
+		<record id="account_coda_note_view" model="ir.ui.view">
+	         <field name="name">Import Coda Statement</field>
+	         <field name="model">account.coda.import</field>
+	         <field name="type">form</field>
+	         <field name="arch" type="xml">
+				<form string="Result of Imported Coda Statements">
+					<group height="420">
+						<separator colspan="4" string="Results :" />
+				    	<field name="note" colspan="4" nolabel="1"/>
+				    	<newline/>
+						<separator colspan="6"/>
+						<button special="cancel" string="Close" icon="gtk-cancel"/>
+						<button name="action_open_window" string="Open Statements" type="object" icon="gtk-apply"/>
+					</group>		    	
+		    	</form>
+	    	</field>
+	   	</record>
+	   	
+	   	<record id="action_account_coda_import" model="ir.actions.act_window">
+            <field name="name">Import Coda Statement</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">account.coda.import</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+   			<field name="view_id" ref="account_coda_import_view"/>            
+        </record>
+
+</data>
+</openerp>

=== added directory 'account_l10nbe_domiciliation'
=== added file 'account_l10nbe_domiciliation/__init__.py'
--- account_l10nbe_domiciliation/__init__.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,27 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import l10nbe_domiciliation
+import report
+import wizard
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_l10nbe_domiciliation/__terp__.py'
--- account_l10nbe_domiciliation/__terp__.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/__terp__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,46 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#    
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.     
+#
+##############################################################################
+{
+    "name" : "Account l10nbe Domiciliation",
+    "version" : "1.0",
+    "author" : "Tiny",
+    "website" : "http://www.openerp.com",
+    "category" : "Generic Modules/Account l10nbe Domiciliation",
+    "description": """
+        Related with l10n_be module.
+        Adds Domiciled and Domiciled send date fields on invoice.
+        Domiciliation and Domiciliation Number fields on partner.
+    """,
+    "depends" : ["base","account","l10n_be"],
+    "init_xml" : [],
+    "demo_xml" : [],
+
+    "update_xml" : ["l10nbe_domiciliation_view.xml", 
+                            "l10nbe_domiciliation_report.xml",
+                            "l10nbe_domiciliation_wizard.xml"
+                            ],
+    "active": False,
+    "installable": True,
+
+'certificate': '00405683612189',
+}
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added directory 'account_l10nbe_domiciliation/i18n'
=== added file 'account_l10nbe_domiciliation/i18n/account_l10nbe_domiciliation.pot'
--- account_l10nbe_domiciliation/i18n/account_l10nbe_domiciliation.pot	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/i18n/account_l10nbe_domiciliation.pot	2012-06-28 13:21:29 +0000
@@ -0,0 +1,237 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_l10nbe_domiciliation
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 5.0.6\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2009-11-24 13:07:05+0000\n"
+"PO-Revision-Date: 2009-11-24 13:07:05+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: account_l10nbe_domiciliation
+#: view:res.company:0
+msgid "Dom80 Export"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.module.module,shortdesc:account_l10nbe_domiciliation.module_meta_information
+msgid "Account l10nbe Domiciliation"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,export,note:0
+msgid "Log"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,file:0
+msgid "Saved File"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:account.invoice,domiciled_send_date:0
+msgid "Domiciliation Sending Date"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: constraint:ir.model:0
+msgid "The Object name must start with x_ and not contain any special character !"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,msg2:0
+msgid "Message to the payer, part 2."
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,collection_date:0
+msgid "Collection Date"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,export:0
+msgid "Note"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: selection:invoice.export.log,state:0
+msgid "Failed"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,export:0
+msgid "Save File..."
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,note:0
+msgid "Creation Log"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: constraint:ir.actions.act_window:0
+msgid "Invalid model name in the action definition."
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.actions.act_window,name:account_l10nbe_domiciliation.action_account_invoice_log_tree
+#: model:ir.ui.menu,name:account_l10nbe_domiciliation.menu_action_action_invoice_export_tree
+msgid "Invoice Export Logs"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:res.company,id_sender:0
+msgid "Identification number of the Sender"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,state:0
+msgid "Status"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: help:res.company,id_creditor:0
+msgid "Creditor Id for Dom80 export header"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,create_date:0
+msgid "Creation Date"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: view:invoice.export.log:0
+msgid "Payment Export Logs"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,msg1:0
+msgid "Message to the payer, part 1."
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,create_uid:0
+msgid "Creation User"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:res.partner.bank,institution_code:0
+msgid "Institution Code"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: help:res.company,id_sender:0
+msgid "Sender Id for Dom80 export header"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.ui.menu,name:account_l10nbe_domiciliation.menu_action_action_invoice_export
+msgid "Invoice Export"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,init:0
+msgid "Export invoice to DOM80 format"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:res.partner,domiciliation:0
+msgid "Domiciliation Number"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: constraint:ir.ui.view:0
+msgid "Invalid XML for View Architecture!"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_button:invoice.export.dom,export,close:0
+msgid "Ok"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.actions.wizard,name:account_l10nbe_domiciliation.wizard_invoice_export_dom
+msgid "Export Invoice"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: selection:invoice.export.log,state:0
+msgid "Succeeded"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,export,invoice_file:0
+msgid "Export File"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:res.company,id_creditor:0
+msgid "Identification number of the Creditor"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: help:invoice.export.dom,init,collection_date:0
+msgid "Requested collection date"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,init:0
+msgid "Export Invoices"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,ref_file:0
+msgid "Reference of the file"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:account.invoice,domiciled:0
+msgid "Domiciled"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: help:invoice.export.dom,init,ref_file:0
+msgid "Reference of the file, Used for Dom80 header"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.module.module,description:account_l10nbe_domiciliation.module_meta_information
+msgid "\n"
+"        Related with l10n_be module.\n"
+"        Adds Domiciled and Domiciled send date fields on invoice.\n"
+"        Domiciliation and Domiciliation Number fields on partner.\n"
+"    "
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_button:invoice.export.dom,init,export:0
+msgid "Export"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: help:res.partner.bank,institution_code:0
+msgid "Code of the financial institution used for Dom80 Export"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: wizard_button:invoice.export.dom,init,end:0
+msgid "Cancel"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: field:res.partner,domiciliation_bool:0
+msgid "Domiciliation"
+msgstr ""
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.model,name:account_l10nbe_domiciliation.model_invoice_export_log
+msgid "Invoice Export History"
+msgstr ""
+

=== added file 'account_l10nbe_domiciliation/i18n/fr_BE.po'
--- account_l10nbe_domiciliation/i18n/fr_BE.po	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/i18n/fr_BE.po	2012-06-28 13:21:29 +0000
@@ -0,0 +1,241 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_l10nbe_domiciliation
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 5.0.6\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2009-11-24 13:07:05+0000\n"
+"PO-Revision-Date: 2009-11-24 13:07:05+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: account_l10nbe_domiciliation
+#: view:res.company:0
+msgid "Dom80 Export"
+msgstr "Export DOM80"
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.module.module,shortdesc:account_l10nbe_domiciliation.module_meta_information
+msgid "Account l10nbe Domiciliation"
+msgstr "Account l10nbe Domiciliation"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,export,note:0
+msgid "Log"
+msgstr "Log"
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,file:0
+msgid "Saved File"
+msgstr "Fichier enregistré"
+
+#. module: account_l10nbe_domiciliation
+#: field:account.invoice,domiciled_send_date:0
+msgid "Domiciliation Sending Date"
+msgstr "Date d'envoi de la domiciliation"
+
+#. module: account_l10nbe_domiciliation
+#: constraint:ir.model:0
+msgid "The Object name must start with x_ and not contain any special character !"
+msgstr "Le nom de l'Objet doit commencer par x_ et ne pas comporter de caractères spéciaux !"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,msg2:0
+msgid "Message to the payer, part 2."
+msgstr "Messaye pour le payeur, seconde partie"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,collection_date:0
+msgid "Collection Date"
+msgstr "Date pivot"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,export:0
+msgid "Note"
+msgstr "Note"
+
+#. module: account_l10nbe_domiciliation
+#: selection:invoice.export.log,state:0
+msgid "Failed"
+msgstr "Raté"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,export:0
+msgid "Save File..."
+msgstr "Enregistre fichier..."
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,note:0
+msgid "Creation Log"
+msgstr "Log de création"
+
+#. module: account_l10nbe_domiciliation
+#: constraint:ir.actions.act_window:0
+msgid "Invalid model name in the action definition."
+msgstr "Nom de modèle incorrect dans la définition de l'action"
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.actions.act_window,name:account_l10nbe_domiciliation.action_account_invoice_log_tree
+#: model:ir.ui.menu,name:account_l10nbe_domiciliation.menu_action_action_invoice_export_tree
+msgid "Invoice Export Logs"
+msgstr "Logs des exportations de factures"
+
+#. module: account_l10nbe_domiciliation
+#: field:res.company,id_sender:0
+msgid "Identification number of the Sender"
+msgstr "Numéro d'identification de l'expéditeur"
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,state:0
+msgid "Status"
+msgstr "Status"
+
+#. module: account_l10nbe_domiciliation
+#: help:res.company,id_creditor:0
+msgid "Creditor Id for Dom80 export header"
+msgstr "ID créditeur dans l'en-tête DOM80"
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,create_date:0
+msgid "Creation Date"
+msgstr "Date de création"
+
+#. module: account_l10nbe_domiciliation
+#: view:invoice.export.log:0
+msgid "Payment Export Logs"
+msgstr "Logs des Export de paiement"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,msg1:0
+msgid "Message to the payer, part 1."
+msgstr "Message au payeur, première partie"
+
+#. module: account_l10nbe_domiciliation
+#: field:invoice.export.log,create_uid:0
+msgid "Creation User"
+msgstr "Créateur"
+
+#. module: account_l10nbe_domiciliation
+#: field:res.partner.bank,institution_code:0
+msgid "Institution Code"
+msgstr "Code de l'institution"
+
+#. module: account_l10nbe_domiciliation
+#: help:res.company,id_sender:0
+msgid "Sender Id for Dom80 export header"
+msgstr "ID de l'expéditeur dans le'en-tête DOM80"
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.ui.menu,name:account_l10nbe_domiciliation.menu_action_action_invoice_export
+msgid "Invoice Export"
+msgstr "Exporter les factures"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,init:0
+msgid "Export invoice to DOM80 format"
+msgstr "Exporter les factures au format DOM80"
+
+#. module: account_l10nbe_domiciliation
+#: field:res.partner,domiciliation:0
+msgid "Domiciliation Number"
+msgstr "Numéro de domiciliation"
+
+#. module: account_l10nbe_domiciliation
+#: constraint:ir.ui.view:0
+msgid "Invalid XML for View Architecture!"
+msgstr "XML incorrect pour l'Architecture des Vues !"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_button:invoice.export.dom,export,close:0
+msgid "Ok"
+msgstr "Ok"
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.actions.wizard,name:account_l10nbe_domiciliation.wizard_invoice_export_dom
+msgid "Export Invoice"
+msgstr "Exoporte les factures"
+
+#. module: account_l10nbe_domiciliation
+#: selection:invoice.export.log,state:0
+msgid "Succeeded"
+msgstr "Réussi"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,export,invoice_file:0
+msgid "Export File"
+msgstr "Fichier Exporté"
+
+#. module: account_l10nbe_domiciliation
+#: field:res.company,id_creditor:0
+msgid "Identification number of the Creditor"
+msgstr "Numéro d'identification du créditeur"
+
+#. module: account_l10nbe_domiciliation
+#: help:invoice.export.dom,init,collection_date:0
+msgid "Requested collection date"
+msgstr "Date pivot"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_view:invoice.export.dom,init:0
+msgid "Export Invoices"
+msgstr "Exporter les factures"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_field:invoice.export.dom,init,ref_file:0
+msgid "Reference of the file"
+msgstr "Référence du fichier"
+
+#. module: account_l10nbe_domiciliation
+#: field:account.invoice,domiciled:0
+msgid "Domiciled"
+msgstr "Domiciliée"
+
+#. module: account_l10nbe_domiciliation
+#: help:invoice.export.dom,init,ref_file:0
+msgid "Reference of the file, Used for Dom80 header"
+msgstr "Référence du fichier, utilisée dans l'en-tête DOM80"
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.module.module,description:account_l10nbe_domiciliation.module_meta_information
+msgid "\n"
+"        Related with l10n_be module.\n"
+"        Adds Domiciled and Domiciled send date fields on invoice.\n"
+"        Domiciliation and Domiciliation Number fields on partner.\n"
+"    "
+msgstr "\n"
+"        Lié au module l10n_be.\n"
+"        Ajoute les champs 'Domiciled' and 'Domiciled send date' aux factures,\n"
+"        et 'Domiciliation' et 'Domiciliation Number' sur les partenaires.\n"
+"    "
+
+#. module: account_l10nbe_domiciliation
+#: wizard_button:invoice.export.dom,init,export:0
+msgid "Export"
+msgstr "Export"
+
+#. module: account_l10nbe_domiciliation
+#: help:res.partner.bank,institution_code:0
+msgid "Code of the financial institution used for Dom80 Export"
+msgstr "Code de l'institution financière utilisée dans l'export DOM80"
+
+#. module: account_l10nbe_domiciliation
+#: wizard_button:invoice.export.dom,init,end:0
+msgid "Cancel"
+msgstr "Annule"
+
+#. module: account_l10nbe_domiciliation
+#: field:res.partner,domiciliation_bool:0
+msgid "Domiciliation"
+msgstr "Domiciliation"
+
+#. module: account_l10nbe_domiciliation
+#: model:ir.model,name:account_l10nbe_domiciliation.model_invoice_export_log
+msgid "Invoice Export History"
+msgstr "Historique de l'Export des factures"
+

=== added file 'account_l10nbe_domiciliation/l10nbe_domiciliation.py'
--- account_l10nbe_domiciliation/l10nbe_domiciliation.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/l10nbe_domiciliation.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,72 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+from osv import fields, osv
+
+class account_invoice(osv.osv):
+    _inherit = 'account.invoice'
+    _description = 'Account Invoice'
+    _columns = {
+        'domiciled' : fields.boolean('Domiciled'),
+        'domiciled_send_date' : fields.date('Domiciliation Sending Date', readonly=True, help='This field contains the sending date of the document for direct debit invoices collecting'),
+        }
+
+    def on_change_partner_id(self, cr, uid, ids, type, partner_id,date_invoice=False, payment_term=False):
+        data=super(account_invoice,self).onchange_partner_id( cr, uid, ids, type, partner_id,date_invoice, payment_term)
+        if not partner_id:
+            return data['value'].update({'domiciled' : False})
+        partner_obj = self.pool.get('res.partner').browse(cr, uid, partner_id)
+        domiciled = partner_obj.domiciliation_bool
+        data['value']['domiciled'] = domiciled
+        return data
+
+account_invoice()
+
+class res_partner(osv.osv):
+    _inherit = 'res.partner'
+    _description = 'Partner'
+    _columns = {
+        'domiciliation_bool':fields.boolean('Direct Debit Permission', help="Check this field if you can collect direct debit invoices for this partner."),
+        'domiciliation' : fields.char('Direct Debit Number', size=12)
+        }
+res_partner()
+
+class res_partner_bank(osv.osv):
+    _inherit = "res.partner.bank"
+    _columns = {
+        'institution_code':fields.char('Institution Code', size=3, help="Code of the financial institution used for Dom80 Export"),
+    }
+res_partner_bank()
+
+class invoice_export_log(osv.osv):
+    _name = "invoice.export.log"
+    _description = "Invoice Export History"
+    _rec_name = 'invoice_id'
+    _columns = {
+        'state': fields.selection([('failed', 'Failed'), ('succeeded', 'Succeeded')], 'Status', readonly=True),
+        'file': fields.binary('Saved File', readonly=True),
+        'note': fields.text('Creation Log', readonly=True),
+        'create_date': fields.datetime('Creation Date', required=True, readonly=True),
+        'create_uid': fields.many2one('res.users', 'Creation User', required=True, readonly=True),
+    }
+invoice_export_log()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_l10nbe_domiciliation/l10nbe_domiciliation_report.xml'
--- account_l10nbe_domiciliation/l10nbe_domiciliation_report.xml	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/l10nbe_domiciliation_report.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+	<data>
+		<report auto="False" id="account.account_invoices" menu="False"
+			model="account.invoice" name="account.invoice.domiciliated"
+			rml="account_l10nbe_domiciliation/report/invoice.rml"
+			string="Invoices"
+		/>
+<!--		<report auto="False" id="invoice_domiciliation_save"-->
+<!--			model="account.invoice" name="invoice.domiciliation.dom"-->
+<!--			rml="account_l10nbe_domiciliation/report/domiciliations.rml"-->
+<!--			string="Rapport domiciliations" multi="True"  header="False"-->
+<!--		/>-->
+
+	</data>
+</openerp>

=== added file 'account_l10nbe_domiciliation/l10nbe_domiciliation_view.xml'
--- account_l10nbe_domiciliation/l10nbe_domiciliation_view.xml	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/l10nbe_domiciliation_view.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,121 @@
+<?xml version="1.0" ?>
+<openerp>
+    <data>
+<!-- Account Invoice object view (inherited) -->
+        <record model="ir.ui.view" id="invoice_form_domicile">
+            <field name="name">account.invoice.domicile.form</field>
+            <field name="type">form</field>
+            <field name="model">account.invoice</field>
+            <field name="inherit_id" ref="account.invoice_form"/>
+            <field name="arch" type="xml">
+                <field name="period_id" position="before">
+                    <field name="domiciled"/>
+                    <field name="domiciled_send_date"/>
+                </field>
+            </field>
+        </record>
+
+        <record model="ir.ui.view" id="invoice_form_partner_domiciled">
+            <field name="name">account.invoice.partner.domicile.form</field>
+            <field name="type">form</field>
+            <field name="model">account.invoice</field>
+            <field name="inherit_id" ref="account.invoice_form"/>
+            <field name="arch" type="xml">
+                <field name="partner_id" position="replace">
+                    <field name="partner_id" on_change="on_change_partner_id(type, partner_id, date_invoice,payment_term)"/>
+                </field>
+            </field>
+        </record>
+
+
+        <record model="ir.ui.view" id="supplier_invoice_form_domicile">
+            <field name="name">supplier.invoice.domicile.form</field>
+            <field name="type">form</field>
+            <field name="model">account.invoice</field>
+            <field name="inherit_id" ref="account.invoice_supplier_form"/>
+            <field name="arch" type="xml">
+                <field name="period_id" position="before">
+                    <field name="domiciled"/>
+                    <field name="domiciled_send_date"/>
+                </field>
+            </field>
+        </record>
+
+
+<!-- Partner object view (inherited) -->
+        <record model="ir.ui.view" id="view_partner_domicile_form">
+            <field name="name">res.partner.domicile.form</field>
+            <field name="type">form</field>
+            <field name="model">res.partner</field>
+            <field name="inherit_id" ref="base.view_partner_form"/>
+            <field name="arch" type="xml">
+                <field name="date" position="after">
+                    <field name="domiciliation"/>
+                </field>
+            </field>
+        </record>
+
+    <record model="ir.ui.view" id="view_partner_form_inherit_code">
+        <field name="name">res.partner.form.insti.code.inherit</field>
+        <field name="model">res.partner</field>
+        <field name="type">form</field>
+        <field name="inherit_id" ref="base.view_partner_form"/>
+        <field name="arch" type="xml">
+            <field name="bank" position="before">
+                <field name="institution_code" select="1"/>
+                <newline/>
+            </field>
+        </field>
+    </record>
+
+<!--  Export Logs views and menuitems-->
+
+    <record model="ir.ui.view" id="view_account_pay_tree">
+            <field name="name">invoice.export.log.tree</field>
+            <field name="model">invoice.export.log</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Payment Export Logs">
+                    <field name="file"/>
+                    <field name="create_date"/>
+                    <field name="create_uid"/>
+                    <field name="note"/>
+                    <field name="state"/>
+                </tree>
+            </field>
+        </record>
+
+        <record model="ir.ui.view" id="view_payment_mode_form">
+            <field name="name">invoice.export.log.form</field>
+            <field name="model">invoice.export.log</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Payment Export Logs">
+                    <field name="create_date" select="1"/>
+                    <field name="create_uid" select="2"/>
+                    <newline/>
+                    <field name="file" colspan="4" select="1"/>
+                    <newline/>
+                    <field name="note" colspan="4"/>
+                    <newline/>
+                    <field name="state" select="2"/>
+                </form>
+            </field>
+        </record>
+        <record model="ir.actions.act_window" id="action_account_invoice_log_tree">
+            <field name="name">Invoice Export Logs</field>
+            <field name="res_model">invoice.export.log</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+        </record>
+
+        <menuitem
+            name="Invoice Export" parent="account.menu_finance_configuration"
+            id="menu_action_action_invoice_export" />
+
+        <menuitem
+            parent="menu_action_action_invoice_export"
+            id="menu_action_action_invoice_export_tree" action="action_account_invoice_log_tree"/>
+
+    </data>
+</openerp>

=== added file 'account_l10nbe_domiciliation/l10nbe_domiciliation_wizard.xml'
--- account_l10nbe_domiciliation/l10nbe_domiciliation_wizard.xml	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/l10nbe_domiciliation_wizard.xml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<openerp>
+	<data>
+
+		<wizard
+			string="Export Domiciliated Invoices"
+			model="account.invoice"
+			name="invoice.export.dom"
+ 			id="wizard_invoice_export_dom"
+                        menu="False"
+ 			/>
+
+        <menuitem name="Export Domiciliated Invoices" action="wizard_invoice_export_dom" parent="account.menu_finance_periodical_processing"
+        type="wizard"  id="menu_account_coda_wizard" sequence="15"/>
+
+
+	</data>
+</openerp>

=== added directory 'account_l10nbe_domiciliation/report'
=== added file 'account_l10nbe_domiciliation/report/Rapport.sxw'
Binary files account_l10nbe_domiciliation/report/Rapport.sxw	1970-01-01 00:00:00 +0000 and account_l10nbe_domiciliation/report/Rapport.sxw	2012-06-28 13:21:29 +0000 differ
=== added file 'account_l10nbe_domiciliation/report/__init__.py'
--- account_l10nbe_domiciliation/report/__init__.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/report/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,27 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution	
+#    Copyright (C) 2004-2008 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/>.
+#
+##############################################################################
+
+import account_invoice
+import report_domiciliations
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_l10nbe_domiciliation/report/account_invoice.py'
--- account_l10nbe_domiciliation/report/account_invoice.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/report/account_invoice.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,37 @@
+# -*- 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/>.
+#
+##############################################################################
+
+import time
+from report import report_sxw
+
+class account_invoice(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(account_invoice, self).__init__(cr, uid, name, context)
+        self.localcontext.update({
+            'time': time,
+        })
+report_sxw.report_sxw(
+    'report.account.invoice.domiciliated',
+    'account.invoice',
+    'addons/account_l10nbe_domiciliation/report/invoice.rml',
+    parser=account_invoice
+)
\ No newline at end of file

=== added file 'account_l10nbe_domiciliation/report/domiciliations.rml'
--- account_l10nbe_domiciliation/report/domiciliations.rml	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/report/domiciliations.rml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,261 @@
+<?xml version="1.0"?>
+<document filename="dom80.pdf">
+  <template pageSize="(595.0,842.0)" title="dom80" author="Martin Simon" allowSplitting="20">
+    <pageTemplate id="first">
+      <frame id="first" x1="57.0" y1="57.0" width="481" height="728"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table1">
+      <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"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table3">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table4">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#ececec" start="0,-1" stop="4,-1"/>
+    </blockTableStyle>
+
+    <blockTableStyle id="TableH1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
+    </blockTableStyle>
+
+    <blockTableStyle id="TableC1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="4,0" stop="4,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,1" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,1" stop="4,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="4,1" stop="4,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,2" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,2" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,2" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,2" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,2" stop="4,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#000000" start="4,2" stop="4,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+    </blockTableStyle>
+
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+
+    <paraStyle name="P1" fontName="Helvetica-Bold" fontSize="18.0" leading="17" alignment="CENTER"/>
+    <paraStyle name="P2" fontName="Helvetica" fontSize="15.0" leading="14" alignment="LEFT"/>
+    <paraStyle name="P3" fontName="Helvetica-Bold" fontSize="11.0" leading="14" alignment="LEFT"/>
+    <paraStyle name="P4" fontName="Helvetica-BoldOblique" fontSize="6.0" leading="8" alignment="LEFT"/>
+    <paraStyle name="P5" fontName="Helvetica-Oblique" fontSize="9" alignment="LEFT"/>
+    <paraStyle name="P6" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
+    <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
+    <paraStyle name="P8" fontName="Helvetica-BoldOblique" fontSize="8.0" leading="10" alignment="CENTER"/>
+    <paraStyle name="P9" fontName="Helvetica-BoldOblique" fontSize="8.0" leading="10" alignment="CENTER"/>
+    <paraStyle name="P10" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
+    <paraStyle name="P11" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" alignment="LEFT"/>
+    <paraStyle name="P12" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" alignment="CENTER"/>
+    <paraStyle name="P13" fontName="Helvetica-BoldOblique" fontSize="8.0" leading="10" alignment="LEFT"/>
+    <paraStyle name="P14" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT"/>
+    <paraStyle name="P15" fontName="Helvetica-BoldOblique" fontSize="2.0" leading="3" alignment="CENTER"/>
+    <paraStyle name="P16" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="11.0" leading="14" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P17" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="5.0" leading="7" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P18" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P19" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <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="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_8" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
+  </stylesheet>
+  <images/>
+  <story>
+    <para style="P4">
+      <font color="white"> </font>
+    </para>
+    <para style="P1"><u>Liste des domiciliations préparées le [[ formatLang(time.strftime('%d-%m-%Y'),date_time = True) ]]</u></para>
+    <para style="P2">
+      <font color="white"> </font>
+    </para>
+    <para style="P2">
+      <font color="white"> </font>
+    </para>
+    <para style="P2">
+      <font color="white"> </font>
+    </para>
+    <blockTable colWidths="95.0,95.0,95.0,95.0,95.0" style="Table1">
+      <tr>
+        <td>
+          <para style="P3">Client</para>
+        </td>
+        <td>
+          <para style="P3">Numéro domiciliation</para>
+        </td>
+        <td>
+          <para style="P3">Montant (Euro)</para>
+        </td>
+        <td>
+          <para style="P3">Banque</para>
+        </td>
+        <td>
+          <para style="P3">Communication</para>
+        </td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="482.0" style="Table3">
+      <tr>
+        <td>
+          <para style="P17">[[ repeatIn(invoice_details(data['form']['inv_ids']), 'a') ]]</para>
+          <blockTable colWidths="95.0,95.0,95.0,95.0,95.0" style="Table4">
+            <tr>
+              <td>
+                <para style="P5">[[ a['client'] ]]</para>
+              </td>
+              <td>
+                <para style="P5">[[ a['number'] ]]</para>
+              </td>
+              <td>
+                <para style="P5">[[ a['amount'] ]]</para>
+              </td>
+              <td>
+                <para style="P5">[[ a['bank'] ]]</para>
+              </td>
+              <td>
+                <para style="P5">[[ a['communication'] ]]</para>
+              </td>
+            </tr>
+          </blockTable>
+        </td>
+      </tr>
+    </blockTable>
+    <para style="P16">
+      <font color="white"> </font>
+    </para>
+    <para style="P19">
+      <font color="white"> </font>
+    </para>
+    <para style="P19">
+      <font color="white"> </font>
+    </para>
+
+    <blockTable colWidths="100.0,200.0,200.0" style="TableH1">
+      <tr>
+        <td>
+          <para style="P17">[[ repeatIn(statastics_details(data['form']['account_bank_number'],data['form']['inv_ids']), 's') ]]</para>
+        </td>
+        <td>
+          <para style="P8">Banque [[ s['bank_name'] ]]</para>
+        </td>
+        <td>
+          <para style="P9">Autres banques</para>
+        </td>
+      </tr>
+    </blockTable>
+
+    <blockTable colWidths="100.0,100.0,100.0,100.0,100.0" style="TableC1">
+      <tr>
+        <td>
+            <para style="P17">[[ repeatIn(statastics_details(data['form']['account_bank_number'],data['form']['inv_ids']), 's') ]]</para>
+        </td>
+        <td>
+          <para style="P12">Nombre</para>
+        </td>
+        <td>
+          <para style="P12">Valeur totale</para>
+        </td>
+        <td>
+          <para style="P12">Nombre</para>
+        </td>
+        <td>
+          <para style="P12">Valeur totale</para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P13">Recouvrements</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['rec_bank_tot'] ]]</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['rec_bank_val'] ]]</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['rec_other_tot'] ]]</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['rec_other_val'] ]]</para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P13">Remboursements</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['ref_bank_tot'] ]]</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['ref_bank_val'] ]]</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['ref_other_tot'] ]]</para>
+        </td>
+        <td>
+          <para style="P10">[[ s['ref_other_val'] ]]</para>
+        </td>
+      </tr>
+    </blockTable>
+
+    <para style="P19">
+      <font color="white"> </font>
+    </para>
+  </story>
+</document>

=== added file 'account_l10nbe_domiciliation/report/invoice.rml'
--- account_l10nbe_domiciliation/report/invoice.rml	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/report/invoice.rml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,429 @@
+<?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="34.0" y1="28.0" width="530" height="786"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Partner_Address">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Invoice_General_Header">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_General_Detail_Content">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#e6e6e6" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#e6e6e6" start="2,0" stop="2,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="2,-1" stop="2,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Header_Invoice_Line">
+      <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"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Invoice_Line_Content">
+      <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="Table_Format_2">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#ffffff" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#ffffff" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#ffffff" start="2,0" stop="2,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="2,0" stop="2,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBEFORE" colorName="#ffffff" start="3,0" stop="3,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#ffffff" start="3,0" stop="3,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="3,0" stop="3,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="10,0" stop="10,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="11,0" stop="11,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="12,0" stop="12,0"/>
+      <lineStyle kind="LINEBEFORE" colorName="#ffffff" start="0,1" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="0,1" stop="0,1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#ffffff" start="1,1" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="1,1" stop="1,1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,2" stop="0,2"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,2" stop="1,2"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,2" stop="2,2"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,4" stop="0,4"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,4" stop="1,4"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,4" stop="2,4"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_format_Table_Line_total">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#ffffff" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#ffffff" start="1,0" stop="1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="1,-1" stop="1,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_eclu_Taxes_Total">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Taxes_Total">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Total_Include_Taxes">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Main_Table">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#ffffff" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#ffffff" start="0,0" stop="0,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" 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="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="LINEBEFORE" colorName="#ffffff" start="0,2" stop="0,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#ffffff" start="0,2" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" 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="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="#ffffff" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="2,-1" stop="2,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="3,-1" stop="3,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="2,-1" stop="2,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Tax_Header">
+      <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"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Tax_Content">
+      <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"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Table_Border_White">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="0,-1" stop="0,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="1,-1" stop="1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#ffffff" start="2,-1" stop="2,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Final_Border">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="0,0" stop="0,0"/>
+      <lineStyle kind="LINEABOVE" colorName="#ffffff" start="1,0" stop="1,0"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Coment_Payment_Term">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_Payment_Terms">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </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="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_8" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="Footer" fontName="Times-Roman"/>
+    <paraStyle name="P8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="0.0"/>
+    <paraStyle name="Horizontal Line" fontName="Times-Roman" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.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_Bold_8" rightIndent="0.0" leftIndent="0.0" 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" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Centre_8" rightIndent="0.0" leftIndent="0.0" 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="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="terp_default_address" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_9" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Bold_9" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Centre_9" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Bold_Right_9" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_2" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_White_2" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Note" rightIndent="0.0" leftIndent="9.0" fontName="Helvetica-Oblique" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+  </stylesheet>
+  <images/>
+  <story>
+    <para style="terp_default_8">[[ repeatIn(objects,'o') ]]</para>
+    <para style="terp_default_8">[[ o.partner_id.name ]]</para>
+    <para style="terp_default_8">[[ setLang(o.partner_id.lang) ]] </para>
+    <blockTable colWidths="297.0,233.0" style="Table_Partner_Address">
+      <tr>
+        <td><para style="P8"><font color="white"> </font></para></td>
+        <td>
+          <para style="terp_default_8">[[ o.partner_id.title or '' ]] [[ o.partner_id.name ]]</para>
+          <para style="terp_default_8">[[ o.address_invoice_id.title or '' ]] [[ o.address_invoice_id.name ]]</para>
+          <para style="terp_default_8">[[ o.address_invoice_id.street ]]</para>
+          <para style="terp_default_8">[[ o.address_invoice_id.street2 or '' ]]</para>
+          <para style="terp_default_8">[[ o.address_invoice_id.zip or '' ]] [[ o.address_invoice_id.city or '' ]]</para>
+          <para style="terp_default_8">[[ o.address_invoice_id.state_id and o.address_invoice_id.state_id.name or '' ]]</para>
+          <para style="terp_default_8">[[ o.address_invoice_id.country_id and o.address_invoice_id.country_id.name or '' ]]</para>
+          <para style="P8"><font color="white"> </font></para>
+          <para style="terp_default_8">Tel. : [[ o.address_invoice_id.phone or removeParentNode('para') ]]</para>
+          <para style="terp_default_8">Fax : [[ o.address_invoice_id.fax or removeParentNode('para') ]]</para>
+          <para style="terp_default_8">VAT : [[ o.partner_id.vat or removeParentNode('para') ]]</para>
+        </td>
+      </tr>
+    </blockTable>
+    <para style="terp_header">Invoice [[ ((o.type == 'out_invoice' and (o.state == 'open' or o.state == 'paid')) or removeParentNode('para')) and '' ]] [[ o.number ]]</para>
+    <para style="terp_header">PRO-FORMA [[ ((o.type == 'out_invoice' and o.state == 'proforma2') or removeParentNode('para')) and '' ]]</para>
+    <para style="terp_header">Draft Invoice [[ ((o.type == 'out_invoice' and o.state == 'draft') or removeParentNode('para')) and '' ]]</para>
+    <para style="terp_header">Canceled Invoice [[ ((o.type == 'out_invoice' and o.state == 'cancel') or removeParentNode('para')) and '' ]]</para>
+    <para style="terp_header">Refund [[ (o.type=='out_refund' or removeParentNode('para')) and '' ]] [[ o.number ]]</para>
+    <para style="terp_header">Supplier Refund [[ (o.type=='in_refund' or removeParentNode('para')) and '' ]] [[ o.number ]]</para>
+    <para style="terp_header">Supplier Invoice [[ (o.type=='in_invoice' or removeParentNode('para')) and '' ]] [[ o.number ]]</para>
+    <para style="P8"><font color="white"> </font></para>
+    <blockTable colWidths="177.0,177.0,177.0" style="Table_Invoice_General_Header">
+      <tr>
+        <td><para style="terp_tblheader_General_Centre">Document</para></td>
+        <td><para style="terp_tblheader_General_Centre">Invoice Date</para></td>
+        <td><para style="terp_tblheader_General_Centre">Partner Ref.</para></td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="177.0,177.0,177.0" style="Table_General_Detail_Content">
+      <tr>
+        <td><para style="terp_default_Centre_9">[[ o.name ]]</para></td>
+        <td><para style="terp_default_Centre_9">[[ formatLang(o.date_invoice,date=True) ]]</para></td>
+        <td><para style="terp_default_Centre_9">[[ o.address_invoice_id.partner_id.ref or '' ]]</para></td>
+      </tr>
+    </blockTable>
+    <para style="P8"><font color="white"></font></para>
+    <para style="P8"><font color="white"> </font></para>
+    <blockTable colWidths="211.0,62.0,63.0,63.0,40.0,84.0" style="Table_Header_Invoice_Line">
+      <tr>
+        <td><para style="terp_tblheader_Details">Description</para></td>
+        <td><para style="terp_tblheader_Details">Taxes</para></td>
+        <td><para style="terp_tblheader_Details">Quantity</para></td>
+        <td><para style="terp_tblheader_Details_Centre">Unit Price</para></td>
+        <td><para style="terp_tblheader_Details">Disc.(%)</para></td>
+        <td><para style="terp_tblheader_Details_Centre">Price</para></td>
+      </tr>
+    </blockTable>
+    <section>
+      <para style="terp_default_8">[[ repeatIn(o.invoice_line,'l') ]]</para>
+      <blockTable colWidths="211.0,62.0,36.0,27.0,63.0,36.0,62.0,26.0" style="Table_Invoice_Line_Content">
+        <tr>
+          <td><para style="terp_default_9">[[ l.name ]]</para></td>
+          <td><para style="terp_default_9">[[ ', '.join([ lt.description or '' for lt in l.invoice_line_tax_id ]) ]]</para></td>
+          <td><para style="terp_default_Right_9">[[ formatLang(l.quantity)]]</para></td>
+          <td><para style="terp_default_Right_9">[[ (l.uos_id and l.uos_id.name) or '' ]]</para></td>
+          <td><para style="terp_default_Right_9">[[ formatLang(l.price_unit) ]]</para></td>
+          <td><para style="terp_default_Right_9">[[ formatLang(l.discount) ]] </para></td>
+          <td><para style="terp_default_Right_9">[[ formatLang(l.price_subtotal) ]]</para></td>
+          <td><para style="terp_default_Right_9">[[ o.currency_id.code ]]</para></td>
+        </tr>
+        <tr>
+          <td><para style="terp_default_Note">[[ format(l.note) or removeParentNode('tr') ]]</para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+          <td><para style="terp_default_Note"><font color="white"> </font></para></td>
+        </tr>
+      </blockTable>
+    </section>
+    <blockTable colWidths="371.0,153.0" style="Table_Format_2">
+      <tr>
+        <td>
+          <blockTable colWidths="176.0,258.0" style="Table_format_Table_Line_total">
+            <tr>
+              <td><para style="terp_default_2"><font color="white"> </font></para></td>
+              <td><para style="terp_default_2"><font color="white"> </font></para></td>
+            </tr>
+          </blockTable>
+        </td>
+        <td>
+          <blockTable colWidths="62.0,59.0,25.0" style="Table_eclu_Taxes_Total">
+            <tr>
+              <td><para style="terp_default_Bold_9">Net Total:</para></td>
+              <td><para style="terp_default_Right_9">[[ formatLang(o.amount_untaxed) ]]</para></td>
+              <td><para style="terp_default_Right_9">[[ o.currency_id.code ]]</para></td>
+            </tr>
+          </blockTable>
+          <blockTable colWidths="63.0,58.0,26.0" style="Table_Taxes_Total">
+            <tr>
+              <td><para style="terp_default_Bold_9">Taxes:</para></td>
+              <td><para style="terp_default_Right_9">[[ formatLang(o.amount_tax) ]]</para></td>
+              <td><para style="terp_default_Right_9">[[ o.currency_id.code ]]</para></td>
+            </tr>
+          </blockTable>
+          <blockTable colWidths="63.0,58.0,26.0" style="Table_Total_Include_Taxes">
+            <tr>
+              <td><para style="terp_default_Bold_9">Total:</para></td>
+              <td><para style="terp_default_Right_9">[[ formatLang(o.amount_total) ]]</para></td>
+              <td><para style="terp_default_Right_9">[[ o.currency_id.code ]]</para></td>
+            </tr>
+          </blockTable>
+        </td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="530.0" style="Table_Main_Table">
+      <tr>
+        <td>
+          <blockTable colWidths="54.0,80.0,67.0" style="Table_Tax_Header">
+            <tr>
+              <td><para style="terp_tblheader_Details_Centre">Tax</para></td>
+              <td><para style="terp_tblheader_Details_Right">Base</para></td>
+              <td><para style="terp_tblheader_Details_Right">Amount</para></td>
+            </tr>
+          </blockTable>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="terp_default_8">[[ repeatIn(o.tax_line,'t') ]]</para>
+          <blockTable colWidths="53.0,80.0,65.0" style="Table_Tax_Content">
+            <tr>
+              <td><para style="terp_default_Centre_8">[[ t.name ]] </para></td>
+              <td><para style="terp_default_Right_8">[[ formatLang(t.base) ]]</para></td>
+              <td><para style="terp_default_Right_8">[[ (t.tax_code_id and t.tax_code_id.notprintable) and removeParentNode('blockTable') or '' ]][[ formatLang(t.amount) ]]</para></td>
+            </tr>
+          </blockTable>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <blockTable colWidths="53.0,60.0,65.0" style="Table_Table_Border_White">
+            <tr>
+              <td><para style="terp_default_2"><font color="white"> </font></para></td>
+              <td><para style="terp_default_2"><font color="white"> </font></para></td>
+              <td><para style="terp_default_2"><font color="white"> </font></para></td>
+            </tr>
+          </blockTable>
+        </td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="180.0,350.0" style="Table_Final_Border">
+      <tr>
+        <td><para style="terp_default_2"><font color="white"> </font></para></td>
+        <td><para style="terp_default_2"><font color="white"> </font></para></td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="530.0" style="Table_Coment_Payment_Term">
+      <tr>
+        <td><para style="terp_default_9">[[ format(o.comment or removeParentNode('blockTable')) ]]</para></td>
+      </tr>
+    </blockTable>
+   <blockTable colWidths="530.0" style="Table_Coment_Payment_Term">
+     <tr>
+      <td><para style="terp_default_9">Domiciliated [[ ((o.domiciled== True or removeParentNode('para')) and '') ]]</para></td>
+        </tr>
+    </blockTable>
+     
+    <para style="terp_default_2">
+      <font color="white"> </font>
+    </para>
+    <blockTable colWidths="530.0" style="Table_Payment_Terms">
+      <tr>
+        <td><para style="terp_default_9">[[ format((o.payment_term and o.payment_term.note) or removeParentNode('blockTable')) ]]</para></td>
+      </tr>
+    </blockTable>
+    <para style="terp_default_2">
+      <font color="white"> </font>
+    </para>
+    <blockTable colWidths="128.0,402.0" style="Standard_Outline">
+      <tr>
+        <td>
+          <para style="terp_default_Bold_9">Fiscal Position Remark :</para>
+        </td>
+        <td>
+          <para style="terp_default_9">[[ format(o.fiscal_position and o.fiscal_position.note or removeParentNode('blockTable')) ]]</para>
+        </td>
+       </tr>
+     </blockTable>
+     <para style="terp_default_2">
+       <font color="white"> </font>
+     </para>
+    
+  </story>
+</document>

=== added file 'account_l10nbe_domiciliation/report/invoice.sxw'
Binary files account_l10nbe_domiciliation/report/invoice.sxw	1970-01-01 00:00:00 +0000 and account_l10nbe_domiciliation/report/invoice.sxw	2012-06-28 13:21:29 +0000 differ
=== added file 'account_l10nbe_domiciliation/report/report_domiciliations.py'
--- account_l10nbe_domiciliation/report/report_domiciliations.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/report/report_domiciliations.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,121 @@
+# -*- 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/>.
+#
+##############################################################################
+
+import time
+from report import report_sxw
+from osv import osv
+
+class invoice_domiciliations(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(invoice_domiciliations, self).__init__(cr, uid, name, context)
+        self.localcontext.update({
+            'time': time,
+            'invoice_details' : self._get_invoice_details,
+            'statastics_details' : self._statastics_details,
+        })
+
+    def _get_invoice_details(self, inv_ids):
+        lines = []
+        inv_obj = self.pool.get('account.invoice')
+        for inv in inv_obj.browse(self.cr, self.uid, inv_ids):
+            res = {}
+            res['client'] = inv.partner_id.name
+            res['number'] = inv.partner_id.domiciliation
+            res['bank'] = inv.partner_bank and inv.partner_bank.name or ''
+            res['amount'] = (inv.type == 'out_refund') and -inv.residual or inv.residual
+            res['communication'] = inv.name or ''  
+            lines.append(res)
+        return lines
+    
+    def _statastics_details(self, bank_account_id, inv_ids):
+        lines = []
+        datas = ['rec_bank_tot', 'rec_bank_val', 'ref_bank_tot', 'ref_bank_val' , \
+                                          'rec_other_tot', 'rec_other_val', 'ref_other_tot', 'ref_other_val' ]
+        res = {}
+        user = self.pool.get('res.users').browse(self.cr, self.uid, self.uid)
+        bank = self.pool.get('res.partner.bank').browse(self.cr, self.uid, bank_account_id)
+        res['bank_name'] = ''
+        if not bank.bank:
+            bank_id = '0'
+        else:
+            bank_id = str(bank.bank.id)
+            res['bank_name'] = bank.bank.name
+        invoice_ids = ','.join(map(str,inv_ids)) 
+        self.cr.execute("select count(ai.id) as tot, coalesce(sum(residual),0)as val from account_invoice ai \
+                            join res_partner_bank rpb on (ai.partner_bank=rpb.id)\
+                            join res_bank bank on (rpb.bank=bank.id)\
+                            where bank.id =%s \
+                             and type not like '%%refund' \
+                             and ai.id in (%s)" % (bank_id,invoice_ids))
+        val1= self.cr.dictfetchall()
+        if val1:
+            res['rec_bank_tot'] = val1[0]['tot'] # 1
+            res['rec_bank_val'] = val1[0]['val'] # 2
+        
+        self.cr.execute("select count(ai.id) as tot, coalesce(sum(residual),0)as val from account_invoice ai \
+                            join res_partner_bank rpb on (ai.partner_bank=rpb.id)\
+                            join res_bank bank on (rpb.bank=bank.id)\
+                            where bank.id =%s \
+                             and type like '%%refund' \
+                             and ai.id in (%s)" % (bank_id,invoice_ids))
+
+        val2= self.cr.dictfetchall()
+        if val2:
+            res['ref_bank_tot'] = val2[0]['tot'] # 5
+            res['ref_bank_val'] = val2[0]['val'] # 6
+        
+        self.cr.execute("select count(ai.id) as tot, coalesce(sum(residual),0)as val from account_invoice ai \
+                            join res_partner_bank rpb on (ai.partner_bank=rpb.id)\
+                            join res_bank bank on (rpb.bank=bank.id)\
+                            where bank.id !=%s \
+                             and type not like '%%refund' \
+                             and ai.id in (%s)" % (bank_id,invoice_ids))
+        val3= self.cr.dictfetchall()
+        if val3:
+            res['rec_other_tot'] = val3[0]['tot'] # 3
+            res['rec_other_val'] = val3[0]['val'] # 4
+       
+        self.cr.execute("select count(ai.id) as tot, coalesce(sum(residual),0)as val from account_invoice ai \
+                            join res_partner_bank rpb on (ai.partner_bank=rpb.id)\
+                            join res_bank bank on (rpb.bank=bank.id)\
+                            where bank.id !=%s \
+                             and type like '%%refund' \
+                             and ai.id in (%s)" % (bank_id,invoice_ids))
+        val4= self.cr.dictfetchall()
+        if val4:
+            res['ref_other_tot'] = val4[0]['tot'] # 7
+            res['ref_other_val'] = val4[0]['val'] # 8
+
+        for d in datas:
+            res.setdefault(0.0)
+
+        lines.append(res)
+        return lines
+
+report_sxw.report_sxw(
+    'report.invoice.domiciliation.dom',
+    'account.invoice',
+    'addons/account_l10nbe_domiciliation/report/domiciliations.rml',
+    parser=invoice_domiciliations, header=False
+)
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'account_l10nbe_domiciliation/wizard'
=== added file 'account_l10nbe_domiciliation/wizard/__init__.py'
--- account_l10nbe_domiciliation/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/wizard/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,26 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution	
+#    Copyright (C) 2004-2008 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/>.
+#
+##############################################################################
+
+import export_invoice
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'account_l10nbe_domiciliation/wizard/export_invoice.py'
--- account_l10nbe_domiciliation/wizard/export_invoice.py	1970-01-01 00:00:00 +0000
+++ account_l10nbe_domiciliation/wizard/export_invoice.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,382 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution	
+#    Copyright (C) 2004-2008 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/>.
+#
+##############################################################################
+import pooler
+import wizard
+import base64
+from osv import osv
+import time
+from tools.translate import _
+
+form = """<?xml version="1.0"?>
+<form string="Export Invoices">
+<separator string="Export invoice to DOM80 format" colspan="4" />
+   <field name="ref_file" colspan="4" />
+   <field name="collection_date" colspan="4" />
+   <field name="account_bank_number" colspan="4" />
+   <field name="sender" colspan="4" />
+   <field name="credit_note" colspan="4" />
+</form>"""
+
+fields = {
+        'ref_file' : {
+        'string':'Reference of the file', 
+        'type':'char', 
+        'size' : 10,
+        'help' : "Reference of the file, Used for Dom80 header",
+        'required': True,
+    },
+    'collection_date' : {
+        'string':'Collection Date', 
+        'type':'date', 
+        'required': True,
+        'default' : time.strftime('%Y-%m-%d'),
+        'help' : "Requested collection date"
+    },
+        'sender': {
+        'string': 'Document Sender',
+        'type': 'many2one',
+        'relation': 'res.partner',
+        'help': 'This field have to be filled in cases where the sender is different from the creditor'
+    },
+        'account_bank_number': {
+        'string': 'Account Bank Number',
+        'type': 'many2one',
+        'relation': 'res.partner.bank',
+        'help': 'Select here the creditor account number',
+        'domain': "[('state','=','bank'),('partner_id','=',1)]", #to improve: partner of the company of the uid
+        'required': True
+    },
+        'credit_note': {
+        'string': 'With Credit Note?',
+        'type': 'boolean',
+        'help': 'Check if you want to export credit note'
+    },
+
+    }
+
+save_form = """<?xml version="1.0"?>
+<form string="Save File...">
+   <field name="invoice_file"/>
+   <separator string="Note" colspan="4" />
+   <field name="note" colspan="4" nolabel="1" readonly="1"/>
+   </form>"""
+
+save_fields = {
+    'invoice_file' : {
+        'string':'Export File', 
+        'type':'binary', 
+        'required': False, 
+        'readonly':True, 
+    }, 
+    'note' : {'string':'Log', 'type':'text'}, 
+}
+
+trans=[(u'ￃﾩ', 'e'), 
+       (u'ￃﾨ', 'e'), 
+       (u'ￃﾠ', 'a'), 
+       (u'ￃﾪ', 'e'), 
+       (u'ￃﾮ', 'i'), 
+       (u'ￃﾯ', 'i'), 
+       (u'ￃﾢ', 'a'), 
+       (u'ￃﾤ', 'a')]
+
+def tr(s):
+    s= s.decode('utf-8')
+    for k in trans:
+        s = s.replace(k[0], k[1])
+    try:
+        res= s.encode('ascii', 'replace')
+    except:
+        res = s
+    return res
+
+class record:
+    def __init__(self, global_context_dict):
+
+        for i in global_context_dict:
+            global_context_dict[i]= global_context_dict[i] and tr(global_context_dict[i])
+        self.fields = []
+        self.global_values = global_context_dict
+        self.pre={'padding':'', 'seg_num1':'0', 'seg_num2':'1', 
+                  'seg_num3':'1', 'seg_num4':'1', 'seg_num5':'1', 'seg_num8':'1', 'seg_num_t':'9', 
+                   'flag':'0', 'flag1':'\n'
+                           }
+        self.init_local_context()
+
+    def init_local_context(self):
+        """
+        Must instanciate a fields list, field = (name,size)
+        and update a local_values dict.
+        """
+        raise "not implemented"
+
+    def generate(self):
+        res=''
+        value=0
+        go=True
+        for field in self.fields :
+            if self.pre.has_key(field[0]):
+                value = self.pre[field[0]]
+            elif self.global_values.has_key(field[0]):
+                value = self.global_values[field[0]]
+            else :
+                continue
+                #raise Exception(field[0]+' not found !')
+            try:
+                res = res + c_ljust(value, field[1])
+            except :
+                pass
+
+        return res
+
+class record_header(record):
+    def init_local_context(self):
+        self.fields=[
+            #Header record start
+            ('identification', 1), 
+            ('zeros', 4), ('creation_date', 6), 
+            ('institution_code', 3), ('app_code', 2), ('ref_file', 10), ('id_sender', 11), ('id_creditor', 11), 
+            ('acc_num_creditor', 12), ('version_code', 1), ('if_duplicate', 1), ('collection_date', 6), ('blanks', 60)
+            ]
+
+class record_trailer(record):
+    def init_local_context(self):
+        self.fields=[
+            #Trailer record start
+            ('identification', 1), 
+            ('tot_collection', 4), ('tot_amount_collection', 12) , 
+             ('tot_collection_direct_debit_num', 15), 
+            ('tot_reversal_inst', 4), ('tot_amount_reversal_inst', 12), 
+             ('tot_reversal_direct_debit_num', 15), 
+            ('blanks', 65), 
+            ]
+
+class record_invoice_data(record):
+    def init_local_context(self):
+        self.fields=[
+            ('identification', 1), ('serial_num', 4), ('direct_debit_num', 12), 
+            ('type_code', 1), 
+            ('amount_collection', 12), ('creditor', 26), ('msg_payer_1', 15), 
+            ('msg_payer_2', 15), ('creditor_ref', 12), ('blanks', 30), 
+            ]
+
+def c_ljust(s, size):
+    """
+    check before calling ljust
+    """
+    s= s or ''
+    if len(s) > size:
+        s= s[:size]
+    s = s.decode('utf-8').encode('latin1', 'replace').ljust(size)
+    return s
+
+class Log:
+    def __init__(self):
+        self.content= ""
+        self.error= False
+    def add(self, s, error=True):
+        self.content= self.content + s
+        if error:
+            self.error= error
+    def __call__(self):
+        return self.content
+
+def _create_file(self, cr, uid, data, context):
+    v1 = {}
+    v2 = {}
+    v3 = {}
+    log=''
+    log = Log()
+    blank_space = ' '
+
+    seq = 0
+    inv_seq = 0
+    total = 0
+    inv_total = 0
+    invoice_data = ''
+    
+    pool = pooler.get_pool(cr.dbname)
+    partner_obj = pool.get('res.partner')
+    bank_obj = pool.get('res.partner.bank')
+    invoice_obj = pool.get('account.invoice')
+    obj_cmpny = pooler.get_pool(cr.dbname).get('res.users').browse(cr, uid, uid).company_id
+    
+    #Header Record Start
+    
+    v1['identification']='0'   #1
+    v1['zeros']='0000'  # 2-5
+    v1['creation_date']= time.strftime('%d%m%y')    #6-11
+    code =  bank_obj.browse(cr, uid, data['form']['account_bank_number']).institution_code
+    if not code:
+        return {'note':_('Please provide Institution Code number for the bank of the creditor.'), 'invoice_file': False, 'state':'' }
+    
+    v1['institution_code'] = code # 12-14
+    v1['app_code']= '02' # 15-16
+    v1['ref_file']= data['form']['ref_file'] or '' # 17-26
+
+    id_creditor = obj_cmpny.partner_id.vat
+    if not id_creditor:
+        return {'note': _('Please Provide VAT number for the creditor.'), 'invoice_file': False, 'state':'failed' }
+    v1['id_creditor']= '0' + id_creditor[-10:]
+
+    sender_rec = data['form']['sender'] and partner_obj.browse(cr, uid, data['form']['sender']) or obj_cmpny.partner_id
+    id_sender = sender_rec.vat
+    if not id_sender:
+        return {'note': _('Please Provide VAT number for the Sender.'), 'invoice_file': False, 'state':'failed' }
+    v1['id_sender']= '0' + id_sender[-10:] # 27-37
+
+    #Taken bank account num of main company
+    partner_bank = bank_obj.browse(cr, uid, data['form']['account_bank_number']).acc_number
+    
+    if partner_bank:
+        v1['acc_num_creditor'] = partner_bank
+    else:
+        return {'note':_('Please Provide Bank number for the creditor.'), 'invoice_file': False, 'state':'failed' }
+    
+    v1['version_code']='5' #61
+    v1['if_duplicate']=' ' # 62
+    collection_date = time.strptime(data['form']['collection_date'], '%Y-%m-%d')
+    v1['collection_date'] = time.strftime('%d%m%y', collection_date)
+    v1['blanks'] = ' '*60
+    file_header =record_header(v1).generate()
+    #Header Record End
+    
+    #Data Record Start
+    direct_debit_num_tot = 0
+    inv_direct_debit_num_tot = 0
+    if data['form']['credit_note']:
+        cr.execute("select id from account_invoice where domiciled=True and domiciled_send_date is null and type in('out_refund', 'out_invoice') and state ='open'")
+    else:
+        cr.execute("select id from account_invoice where domiciled=True and domiciled_send_date is null and type in('out_invoice') and state ='open'")
+
+    inv_ids = map(lambda x:x[0], cr.fetchall())
+    if not inv_ids:
+        return {'note': _('There is no no invoices to export'), 'invoice_file': False, 'state':'failed' }
+   
+    collected_invoice_ids = []
+    for inv in invoice_obj.browse(cr, uid, inv_ids):
+        seq=seq+1
+        v2['identification'] = '1'
+        v2['serial_num'] = str(seq)[-4:].rjust(4, '0')
+        v2['direct_debit_num'] =  inv.partner_id.domiciliation
+        v2['amount_collection'] = (('%.2f' % inv.residual).replace('.', '')).rjust(12, '0')
+        v2['msg_payer_1'] = inv.name
+        v2['msg_payer_2'] = ''
+        v2['creditor_ref' ] = '0' * 12
+        v2['blanks' ] = ' ' * 30
+        
+        if inv.type == 'out_refund':
+            v2['type_code'] =  '1'
+            inv_total += inv.residual
+            inv_seq += 1
+            inv_direct_debit_num_tot += int(v2['direct_debit_num'])
+            v2['creditor'] = inv.partner_id.name
+        else:
+            total += inv.residual
+            direct_debit_num_tot += int(v2['direct_debit_num'])
+            v2['type_code'] =  '0'
+            v2['creditor'] = obj_cmpny.partner_id.name#inv.partner_id.name#.ljust(26 , ' ')
+
+        invoice_data = invoice_data+ '\n' + record_invoice_data(v2).generate()
+        collected_invoice_ids.append(inv.id)
+    #Data Record End
+    
+    #Trailer Record Start
+    v3['identification'] = '9'
+    v3['tot_collection'] = str(seq-inv_seq).rjust(4, '0')
+    v3['tot_amount_collection'] = (('%.2f' % total).replace('.', '')).rjust(12, '0')
+    v3['tot_collection_direct_debit_num'] = str(direct_debit_num_tot).rjust(15, '0')
+    
+    v3['tot_reversal_inst'] = str(inv_seq).rjust(4, '0')
+    v3['tot_amount_reversal_inst']  = (('%.2f' % inv_total).replace('.','')).rjust(12, '0')
+    v3['tot_reversal_direct_debit_num']  = str(inv_direct_debit_num_tot).rjust(15, '0')
+    
+    v3['blanks' ] = ' ' * 65
+
+    file_trailer = '\n' + record_trailer(v3).generate()
+    
+    #Trailer Record End
+
+    dom_data = file_header + invoice_data + file_trailer
+    log.add("Successfully Exported\n--------------------\nSummary:\n\nTotal amount collected : %.2f \nTotal Number of collection : %d \n-------------------- " %(total, seq))
+    invoice_obj.write(cr, uid, collected_invoice_ids,{'domiciled_send_date': time.strftime('%Y-%m-%d')},context=context)
+    return {'note':log(), 'invoice_file': base64.encodestring(dom_data), 'state':'succeeded', 'inv_ids':collected_invoice_ids}
+
+
+def float2str(lst):
+    return str(lst).rjust(16).replace('.', '')
+
+def _log_create(self, cr, uid, data, context):
+    pool = pooler.get_pool(cr.dbname)
+    pool.get('invoice.export.log').create(cr, uid, {
+        'note': data['form']['note'], 
+        'file': data['form']['invoice_file'] and data['form']['invoice_file'] or False, 
+        'state': data['form']['state'], 
+    })
+
+    return {}
+
+def _check(self, cr, uid, data, context):
+    if data['form']['state'] == 'failed':
+        return 'failed'
+    return 'close'
+
+class wizard_pay_create(wizard.interface):
+    
+    states = {
+        'init' : {
+            'actions' : [],  
+            'result' : {'type' : 'form', 
+                        'arch' : form, 
+                        'fields' : fields, 
+                        'state' : [('end', 'Cancel'), ('export', 'Export') ]}
+        }, 
+        'export' : {
+            'actions' : [_create_file], 
+            'result' : {'type' : 'form', 
+                        'arch' : save_form, 
+                        'fields' : save_fields, 
+                        'state' : [('next_state_check', 'Ok', 'gtk-ok') ]}
+        },
+       'next_state_check': {
+            'actions': [_log_create],
+            'result' : {'type': 'choice', 'next_state': _check }
+        },
+      'failed': {
+                'actions': [],
+                'result': {'type': 'state', 'state':'end'}
+            },
+
+      'close': {
+                'actions': [],
+                'result': {'type': 'state', 'state':'report'}
+            },
+      'report': {
+            'actions': [],
+            'result': {'type':'print', 'report':'invoice.domiciliation.dom', 'state':'end'}
+        }
+    }
+wizard_pay_create('invoice.export.dom')
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
+

=== added directory 'account_report_aged_partner_balance_v6'
=== added file 'account_report_aged_partner_balance_v6/__init__.py'
--- account_report_aged_partner_balance_v6/__init__.py	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,26 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import account_move_line
+import wizard
+import report
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'account_report_aged_partner_balance_v6/__terp__.py'
--- account_report_aged_partner_balance_v6/__terp__.py	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/__terp__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,42 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+
+{
+    'name': 'Backport of the accounting report \'aged partner balance\' of v6',
+    'version': '1.1',
+    'category': 'Generic Modules/Accounting',
+    'description': """This module contains the financial an accounting reports defined in the v6 with few changements in order to get them compatible for v5. It directly comes from the extra_addons module account_v6_reports_backport but include only the aged partner balance in order to don't remove cci customization on other reports.
+    """,
+    'author': 'OpenERP SA',
+    'website': 'http://www.openerp.com',
+    'depends': ['account', 'account_report_bs_pl'],
+    'init_xml': [],
+    'update_xml': [
+        'wizard/account_report_aged_partner_balance_view.xml',
+    ],
+    'demo_xml': [],
+    'test': [],
+    'installable': True,
+    'active': False,
+    'certificate': '00544170409926159389',
+}
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'account_report_aged_partner_balance_v6/account_move_line.py'
--- account_report_aged_partner_balance_v6/account_move_line.py	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/account_move_line.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,136 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from osv import fields, osv
+
+class account_account(osv.osv):
+    _inherit = "account.account"
+
+    def _get_level(self, cr, uid, ids, field_name, arg, context={}):
+        res={}
+        accounts = self.browse(cr, uid, ids)
+        for account in accounts:
+            level = 0
+            if account.parent_id:
+                obj = self.browse(cr, uid, account.parent_id.id)
+                level = obj.level + 1
+            res[account.id] = level
+        return res
+
+    _columns = {
+        'level': fields.function(_get_level, string='Level', method=True, store=True, type='integer'),
+    }
+account_account()
+
+#modifications on class account_period and account_move_line are deprecated because of code in account_report_bs_pl module
+#class account_period(osv.osv):
+#    _inherit = "account.period"
+#
+#    def build_ctx_periods(self, cr, uid, period_from_id, period_to_id):
+#        period_from = self.browse(cr, uid, period_from_id)
+#        period_date_start = period_from.date_start
+#        #company1_id = period_from.company_id and period_from.company_id.id or False
+#        period_to = self.browse(cr, uid, period_to_id)
+#        period_date_stop = period_to.date_stop
+#        #company2_id = period_to.company_id and period_from.company_id.id or False
+#        #if company1_id != company2_id:
+#        #    raise osv.except_osv(_('Error'), _('You should have chosen periods that belongs to the same company'))
+#        if period_date_start > period_date_stop:
+#            raise osv.except_osv(_('Error'), _('Start period should be smaller then End period'))
+#        return self.search(cr, uid, [('date_start', '>=', period_date_start), ('date_stop', '<=', period_date_stop),])# ('company_id', '=', company1_id)])
+#account_period()
+#
+#class account_move_line(osv.osv):
+#    _inherit = "account.move.line"
+#
+#    def _query_get(self, cr, uid, obj='l', context=None):
+#        fiscalyear_obj = self.pool.get('account.fiscalyear')
+#        fiscalperiod_obj = self.pool.get('account.period')
+#        account_obj = self.pool.get('account.account')
+#        fiscalyear_ids = []
+#        if context is None:
+#            context = {}
+#        initial_bal = context.get('initial_bal', False)
+#        company_clause = " "
+#        if context.get('company_id', False):
+#            company_clause = " AND " +obj+".company_id = %s" % context.get('company_id', False)
+#        if not context.get('fiscalyear', False):
+#            if context.get('all_fiscalyear', False):
+#                #this option is needed by the aged balance report because otherwise, if we search only the draft ones, an open invoice of a closed fiscalyear won't be displayed
+#                fiscalyear_ids = fiscalyear_obj.search(cr, uid, [])
+#            else:
+#                fiscalyear_ids = fiscalyear_obj.search(cr, uid, [('state', '=', 'draft')])
+#        else:
+#            #for initial balance as well as for normal query, we check only the selected FY because the best practice is to generate the FY opening entries
+#            fiscalyear_ids = [context['fiscalyear']]
+#
+#        fiscalyear_clause = (','.join([str(x) for x in fiscalyear_ids])) or '0'
+#        state = context.get('state', False)
+#        where_move_state = ''
+#        where_move_lines_by_date = ''
+#
+#        if context.get('date_from', False) and context.get('date_to', False):
+#            if initial_bal:
+#                where_move_lines_by_date = " AND " +obj+".move_id IN (SELECT id FROM account_move WHERE date < '" +context['date_from']+"')"
+#            else:
+#                where_move_lines_by_date = " AND " +obj+".move_id IN (SELECT id FROM account_move WHERE date >= '" +context['date_from']+"' AND date <= '"+context['date_to']+"')"
+#
+#        if state:
+#            if state.lower() not in ['all']:
+#                where_move_state= " AND "+obj+".move_id IN (SELECT id FROM account_move WHERE account_move.state = '"+state+"')"
+#
+#        if context.get('period_from', False) and context.get('period_to', False) and not context.get('periods', False):
+#            if initial_bal:
+#                period_company_id = fiscalperiod_obj.browse(cr, uid, context['period_from'], context=context).company_id.id
+#                first_period = fiscalperiod_obj.search(cr, uid, [('company_id', '=', period_company_id)], order='date_start', limit=1)[0]
+#                context['periods'] = fiscalperiod_obj.build_ctx_periods(cr, uid, first_period, context['period_from'])
+#            else:
+#                context['periods'] = fiscalperiod_obj.build_ctx_periods(cr, uid, context['period_from'], context['period_to'])
+#        if context.get('periods', False):
+#            if initial_bal:
+#                query = obj+".state <> 'draft' AND "+obj+".period_id IN (SELECT id FROM account_period WHERE fiscalyear_id IN (%s)) %s %s" % (fiscalyear_clause, where_move_state, where_move_lines_by_date)
+#                period_ids = fiscalperiod_obj.search(cr, uid, [('id', 'in', context['periods'])], order='date_start', limit=1)
+#                if period_ids and period_ids[0]:
+#                    first_period = fiscalperiod_obj.browse(cr, uid, period_ids[0], context=context)
+#                    # Find the old periods where date start of those periods less then Start period
+#                    periods = fiscalperiod_obj.search(cr, uid, [('date_start', '<', first_period.date_start)])
+#                    periods = ','.join([str(x) for x in periods])
+#                    if periods:
+#                        query = obj+".state <> 'draft' AND "+obj+".period_id IN (SELECT id FROM account_period WHERE fiscalyear_id IN (%s) AND id IN (%s)) %s %s" % (fiscalyear_clause, periods, where_move_state, where_move_lines_by_date)
+#            else:
+#                ids = ','.join([str(x) for x in context['periods']])
+#                query = obj+".state <> 'draft' AND "+obj+".period_id IN (SELECT id FROM account_period WHERE fiscalyear_id IN (%s) AND id IN (%s)) %s %s" % (fiscalyear_clause, ids, where_move_state, where_move_lines_by_date)
+#        else:
+#            query = obj+".state <> 'draft' AND "+obj+".period_id IN (SELECT id FROM account_period WHERE fiscalyear_id IN (%s)) %s %s" % (fiscalyear_clause, where_move_state, where_move_lines_by_date)
+#
+#        if context.get('journal_ids', False):
+#            query += ' AND '+obj+'.journal_id IN (%s)' % ','.join(map(str, context['journal_ids']))
+#
+#        if context.get('chart_account_id', False):
+#            child_ids = account_obj._get_children_and_consol(cr, uid, [context['chart_account_id']], context=context)
+#            query += ' AND '+obj+'.account_id IN (%s)' % ','.join(map(str, child_ids))
+#
+#        query += company_clause
+#
+#        return query
+#account_move_line()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added directory 'account_report_aged_partner_balance_v6/report'
=== added file 'account_report_aged_partner_balance_v6/report/__init__.py'
--- account_report_aged_partner_balance_v6/report/__init__.py	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/report/__init__.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,23 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import common_report_header
+import account_aged_partner_balance
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'account_report_aged_partner_balance_v6/report/account_aged_partner_balance.py'
--- account_report_aged_partner_balance_v6/report/account_aged_partner_balance.py	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/report/account_aged_partner_balance.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,382 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import time
+from report import report_sxw
+from common_report_header import common_report_header
+
+class aged_trial_report(report_sxw.rml_parse, common_report_header):
+
+    def __init__(self, cr, uid, name, context):
+        super(aged_trial_report, self).__init__(cr, uid, name, context=context)
+        print "v6 report"
+        self.total_account = []
+        self.localcontext.update({
+            'time': time,
+            'get_lines_with_out_partner': self._get_lines_with_out_partner,
+            'get_lines': self._get_lines,
+            'get_total': self._get_total,
+            'get_direction': self._get_direction,
+            'get_for_period': self._get_for_period,
+            'get_company': self._get_company,
+            'get_currency': self._get_currency,
+            'get_partners':self._get_partners,
+            'get_account': self._get_account,
+            'get_fiscalyear': self._get_fiscalyear,
+            'get_target_move': self._get_target_move,
+        })
+
+    def set_context(self, objects, data, ids, report_type=None):
+        obj_move = self.pool.get('account.move.line')
+        ctx = data['form'].get('used_context', {})
+        ctx.update({'fiscalyear': False, 'all_fiscalyear': True})
+        self.query = obj_move._query_get(self.cr, self.uid, obj='l', context=ctx)
+        self.direction_selection = data['form'].get('direction_selection', 'past')
+        self.target_move = data['form'].get('target_move', 'all')
+        self.date_from = data['form'].get('date_from', time.strftime('%Y-%m-%d'))
+        if (data['form']['result_selection'] == 'customer' ):
+            self.ACCOUNT_TYPE = ['receivable']
+        elif (data['form']['result_selection'] == 'supplier'):
+            self.ACCOUNT_TYPE = ['payable']
+        else:
+            self.ACCOUNT_TYPE = ['payable','receivable']
+        return super(aged_trial_report, self).set_context(objects, data, ids, report_type=report_type)
+
+    def _get_lines(self, form):
+        res = []
+        move_state = ['draft','posted']
+        if self.target_move == 'posted':
+            move_state = ['posted']
+        self.cr.execute('SELECT DISTINCT res_partner.id AS id,\
+                    res_partner.name AS name \
+                FROM res_partner,account_move_line AS l, account_account, account_move am\
+                WHERE (l.account_id=account_account.id) \
+                    AND (l.move_id=am.id) \
+                    AND (am.state IN %s)\
+                    AND (account_account.type IN %s)\
+                    AND account_account.active\
+                    AND ((reconcile_id IS NULL)\
+                       OR (reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                    AND (l.partner_id=res_partner.id)\
+                    AND (l.date <= %s)\
+                    AND ' + self.query + ' \
+                ORDER BY res_partner.name', (tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from, self.date_from,))
+        partners = self.cr.dictfetchall()
+        ## mise a 0 du total
+        for i in range(7):
+            self.total_account.append(0)
+        #
+        # Build a string like (1,2,3) for easy use in SQL query
+        partner_ids = [x['id'] for x in partners]
+        if not partner_ids:
+            return []
+        # This dictionary will store the debit-credit for all partners, using partner_id as key.
+
+        totals = {}
+        self.cr.execute('SELECT l.partner_id, SUM(l.debit-l.credit) \
+                    FROM account_move_line AS l, account_account, account_move am \
+                    WHERE (l.account_id = account_account.id) AND (l.move_id=am.id) \
+                    AND (am.state IN %s)\
+                    AND (account_account.type IN %s)\
+                    AND (l.partner_id IN %s)\
+                    AND ((l.reconcile_id IS NULL)\
+                    OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                    AND ' + self.query + '\
+                    AND account_account.active\
+                    AND (l.date <= %s)\
+                    GROUP BY l.partner_id ', (tuple(move_state), tuple(self.ACCOUNT_TYPE), tuple(partner_ids), self.date_from, self.date_from,))
+        t = self.cr.fetchall()
+        for i in t:
+            totals[i[0]] = i[1]
+
+        # This dictionary will store the future or past of all partners
+        future_past = {}
+        if self.direction_selection == 'future':
+            self.cr.execute('SELECT l.partner_id, SUM(l.debit-l.credit) \
+                        FROM account_move_line AS l, account_account, account_move am \
+                        WHERE (l.account_id=account_account.id) AND (l.move_id=am.id) \
+                        AND (am.state IN %s)\
+                        AND (account_account.type IN %s)\
+                        AND (COALESCE(l.date_maturity, l.date) < %s)\
+                        AND (l.partner_id IN %s)\
+                        AND ((l.reconcile_id IS NULL)\
+                        OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                        AND '+ self.query + '\
+                        AND account_account.active\
+                    AND (l.date <= %s)\
+                        GROUP BY l.partner_id', (tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from, tuple(partner_ids),self.date_from, self.date_from,))
+            t = self.cr.fetchall()
+            for i in t:
+                future_past[i[0]] = i[1]
+        elif self.direction_selection == 'past': # Using elif so people could extend without this breaking
+            self.cr.execute('SELECT l.partner_id, SUM(l.debit-l.credit) \
+                    FROM account_move_line AS l, account_account, account_move am \
+                    WHERE (l.account_id=account_account.id) AND (l.move_id=am.id)\
+                        AND (am.state IN %s)\
+                        AND (account_account.type IN %s)\
+                        AND (COALESCE(l.date_maturity,l.date) > %s)\
+                        AND (l.partner_id IN %s)\
+                        AND ((l.reconcile_id IS NULL)\
+                        OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                        AND '+ self.query + '\
+                        AND account_account.active\
+                    AND (l.date <= %s)\
+                        GROUP BY l.partner_id', (tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from, tuple(partner_ids), self.date_from, self.date_from,))
+            t = self.cr.fetchall()
+            for i in t:
+                future_past[i[0]] = i[1]
+
+        # Use one query per period and store results in history (a list variable)
+        # Each history will contain: history[1] = {'<partner_id>': <partner_debit-credit>}
+        history = []
+        for i in range(5):
+            args_list = (tuple(move_state), tuple(self.ACCOUNT_TYPE), tuple(partner_ids),self.date_from,)
+            dates_query = '(COALESCE(l.date_maturity,l.date)'
+            if form[str(i)]['start'] and form[str(i)]['stop']:
+                dates_query += ' BETWEEN %s AND %s)'
+                args_list += (form[str(i)]['start'], form[str(i)]['stop'])
+            elif form[str(i)]['start']:
+                dates_query += ' > %s)'
+                args_list += (form[str(i)]['start'],)
+            else:
+                dates_query += ' < %s)'
+                args_list += (form[str(i)]['stop'],)
+            args_list += (self.date_from,)
+            self.cr.execute('''SELECT l.partner_id, SUM(l.debit-l.credit)
+                    FROM account_move_line AS l, account_account, account_move am 
+                    WHERE (l.account_id = account_account.id) AND (l.move_id=am.id)
+                        AND (am.state IN %s)
+                        AND (account_account.type IN %s)
+                        AND (l.partner_id IN %s)
+                        AND ((l.reconcile_id IS NULL)
+                          OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))
+                        AND ''' + self.query + '''
+                        AND account_account.active
+                        AND ''' + dates_query + '''
+                    AND (l.date <= %s)
+                    GROUP BY l.partner_id''', args_list)
+            t = self.cr.fetchall()
+            d = {}
+            for i in t:
+                d[i[0]] = i[1]
+            history.append(d)
+
+        for partner in partners:
+            values = {}
+            ## If choise selection is in the future
+            if self.direction_selection == 'future':
+                # Query here is replaced by one query which gets the all the partners their 'before' value
+                before = False
+                if future_past.has_key(partner['id']):
+                    before = [ future_past[partner['id']] ]
+                self.total_account[6] = self.total_account[6] + (before and before[0] or 0.0)
+                values['direction'] = before and before[0] or 0.0
+            elif self.direction_selection == 'past': # Changed this so people could in the future create new direction_selections
+                # Query here is replaced by one query which gets the all the partners their 'after' value
+                after = False
+                if future_past.has_key(partner['id']): # Making sure this partner actually was found by the query
+                    after = [ future_past[partner['id']] ]
+
+                self.total_account[6] = self.total_account[6] + (after and after[0] or 0.0)
+                values['direction'] = after and after[0] or 0.0
+
+            for i in range(5):
+                during = False
+                if history[i].has_key(partner['id']):
+                    during = [ history[i][partner['id']] ]
+                # Ajout du compteur
+                self.total_account[(i)] = self.total_account[(i)] + (during and during[0] or 0)
+                values[str(i)] = during and during[0] or 0.0
+            total = False
+            if totals.has_key( partner['id'] ):
+                total = [ totals[partner['id']] ]
+            values['total'] = total and total[0] or 0.0
+            ## Add for total
+            self.total_account[(i+1)] = self.total_account[(i+1)] + (total and total[0] or 0.0)
+            values['name'] = partner['name']
+
+            res.append(values)
+
+        total = 0.0
+        totals = {}
+        for r in res:
+            total += float(r['total'] or 0.0)
+            for i in range(5)+['direction']:
+                totals.setdefault(str(i), 0.0)
+                totals[str(i)] += float(r[str(i)] or 0.0)
+        return res
+
+    def _get_lines_with_out_partner(self, form):
+        res = []
+        move_state = ['draft','posted']
+        if self.target_move == 'posted':
+            move_state = ['posted']
+
+        ## mise a 0 du total
+        for i in range(7):
+            self.total_account.append(0)
+        totals = {}
+        self.cr.execute('SELECT SUM(l.debit-l.credit) \
+                    FROM account_move_line AS l, account_account, account_move am \
+                    WHERE (l.account_id = account_account.id) AND (l.move_id=am.id)\
+                    AND (am.state IN %s)\
+                    AND (l.partner_id IS NULL)\
+                    AND (account_account.type IN %s)\
+                    AND ((l.reconcile_id IS NULL) \
+                    OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                    AND ' + self.query + '\
+                    AND (l.date <= %s)\
+                    AND account_account.active ',(tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from, self.date_from,))
+        t = self.cr.fetchall()
+        for i in t:
+            totals['Unknown Partner'] = i[0]
+        future_past = {}
+        if self.direction_selection == 'future':
+            self.cr.execute('SELECT SUM(l.debit-l.credit) \
+                        FROM account_move_line AS l, account_account, account_move am\
+                        WHERE (l.account_id=account_account.id) AND (l.move_id=am.id)\
+                        AND (am.state IN %s)\
+                        AND (l.partner_id IS NULL)\
+                        AND (account_account.type IN %s)\
+                        AND (COALESCE(l.date_maturity, l.date) < %s)\
+                        AND ((l.reconcile_id IS NULL)\
+                        OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                        AND '+ self.query + '\
+                        AND account_account.active ', (tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from, self.date_from))
+            t = self.cr.fetchall()
+            for i in t:
+                future_past['Unknown Partner'] = i[0]
+        elif self.direction_selection == 'past': # Using elif so people could extend without this breaking
+            self.cr.execute('SELECT SUM(l.debit-l.credit) \
+                    FROM account_move_line AS l, account_account, account_move am \
+                    WHERE (l.account_id=account_account.id) AND (l.move_id=am.id)\
+                        AND (am.state IN %s)\
+                        AND (l.partner_id IS NULL)\
+                        AND (account_account.type IN %s)\
+                        AND (COALESCE(l.date_maturity,l.date) > %s)\
+                        AND ((l.reconcile_id IS NULL)\
+                        OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                        AND '+ self.query + '\
+                        AND account_account.active ', (tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from, self.date_from))
+            t = self.cr.fetchall()
+            for i in t:
+                future_past['Unknown Partner'] = i[0]
+        history = []
+
+        for i in range(5):
+            args_list = (tuple(move_state), tuple(self.ACCOUNT_TYPE), self.date_from,)
+            dates_query = '(COALESCE(l.date_maturity,l.date)'
+            if form[str(i)]['start'] and form[str(i)]['stop']:
+                dates_query += ' BETWEEN %s AND %s)'
+                args_list += (form[str(i)]['start'], form[str(i)]['stop'])
+            elif form[str(i)]['start']:
+                dates_query += ' > %s)'
+                args_list += (form[str(i)]['start'],)
+            else:
+                dates_query += ' < %s)'
+                args_list += (form[str(i)]['stop'],)
+            args_list += (self.date_from,)
+            self.cr.execute('SELECT SUM(l.debit-l.credit)\
+                    FROM account_move_line AS l, account_account, account_move am \
+                    WHERE (l.account_id = account_account.id) AND (l.move_id=am.id)\
+                        AND (am.state IN %s)\
+                        AND (account_account.type IN %s)\
+                        AND (l.partner_id IS NULL)\
+                        AND ((l.reconcile_id IS NULL)\
+                        OR (l.reconcile_id IN (SELECT recon.id FROM account_move_reconcile AS recon WHERE recon.create_date > %s )))\
+                        AND '+ self.query + '\
+                        AND account_account.active\
+                        AND ' + dates_query + '\
+                    AND (l.date <= %s)\
+                    GROUP BY l.partner_id', args_list)
+            t = self.cr.fetchall()
+            d = {}
+            for i in t:
+                d['Unknown Partner'] = i[0]
+            history.append(d)
+
+        values = {}
+        if self.direction_selection == 'future':
+            before = False
+            if future_past.has_key('Unknown Partner'):
+                before = [ future_past['Unknown Partner'] ]
+            self.total_account[6] = self.total_account[6] + (before and before[0] or 0.0)
+            values['direction'] = before and before[0] or 0.0
+        elif self.direction_selection == 'past':
+            after = False
+            if future_past.has_key('Unknown Partner'):
+                after = [ future_past['Unknown Partner'] ]
+            self.total_account[6] = self.total_account[6] + (after and after[0] or 0.0)
+            values['direction'] = after and after[0] or 0.0
+
+        for i in range(5):
+            during = False
+            if history[i].has_key('Unknown Partner'):
+                during = [ history[i]['Unknown Partner'] ]
+            self.total_account[(i)] = self.total_account[(i)] + (during and during[0] or 0)
+            values[str(i)] = during and during[0] or 0.0
+
+        total = False
+        if totals.has_key( 'Unknown Partner' ):
+            total = [ totals['Unknown Partner'] ]
+        values['total'] = total and total[0] or 0.0
+        ## Add for total
+        self.total_account[(i+1)] = self.total_account[(i+1)] + (total and total[0] or 0.0)
+        values['name'] = 'Unknown Partner'
+
+        if values['total']:
+            res.append(values)
+
+        total = 0.0
+        totals = {}
+        for r in res:
+            total += float(r['total'] or 0.0)
+            for i in range(5)+['direction']:
+                totals.setdefault(str(i), 0.0)
+                totals[str(i)] += float(r[str(i)] or 0.0)
+        return res
+
+    def _get_total(self,pos):
+        period = self.total_account[int(pos)]
+        return period or 0.0
+
+    def _get_direction(self,pos):
+        period = self.total_account[int(pos)]
+        return period or 0.0
+
+    def _get_for_period(self,pos):
+        period = self.total_account[int(pos)]
+        return period or 0.0
+
+    def _get_partners(self,data):
+        if data['form']['result_selection'] == 'customer':
+            return 'Receivable Accounts'
+        elif data['form']['result_selection'] == 'supplier':
+            return 'Payable Accounts'
+        elif data['form']['result_selection'] == 'customer_supplier':
+            return 'Receivable and Payable Accounts'
+        return ''
+
+report_sxw.report_sxw('report.v6.account.aged_trial_balance', 'res.partner',
+        'addons/account_report_aged_partner_balance_v6/report/account_aged_partner_balance.rml',parser=aged_trial_report, header=False)
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'account_report_aged_partner_balance_v6/report/account_aged_partner_balance.rml'
--- account_report_aged_partner_balance_v6/report/account_aged_partner_balance.rml	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/report/account_aged_partner_balance.rml	2012-06-28 13:21:29 +0000
@@ -0,0 +1,290 @@
+<?xml version="1.0"?>
+<document filename="Aged Trial Balance.pdf">
+   <template pageSize="(842.0,595.0)" title="Aged Trial Balance" author="OpenERP S.A.([e-mail])" allowSplitting="20">
+<pageTemplate>
+    <frame id="first" x1="28.0" y1="28.0" width="786" height="525"/>
+    <pageGraphics>
+        <fill color="black"/>
+        <stroke color="black"/>
+        <drawString x="25" y="555"> [[ formatLang(time.strftime("%Y-%m-%d"), date=True) ]]  [[ time.strftime("%H:%M") ]]</drawString>
+        <drawString x="382" y="555">[[ company.partner_id.name ]]</drawString>
+        <stroke color="#000000"/>
+        <lines>25 550 818 550</lines>
+    </pageGraphics>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <blockBackground colorName="#e6e6e6" start="0,0" stop="0,0"/>
+      <blockBackground colorName="#e6e6e6" start="1,0" stop="1,0"/>
+      <blockBackground colorName="#e6e6e6" start="2,0" stop="2,0"/>
+      <blockBackground colorName="#e6e6e6" start="0,1" stop="0,1"/>
+      <blockBackground colorName="#e6e6e6" start="1,1" stop="1,1"/>
+      <blockBackground colorName="#e6e6e6" start="2,1" stop="2,1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table_header_Content">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tableau1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="GRID" colorName="black"/>
+    </blockTableStyle>
+   <blockTableStyle id="Table2">
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,0" stop="-1,0"/>
+      <lineStyle kind="LINEBELOW" colorName="#000000" start="0,1" stop="-1,1"/>
+      <lineStyle kind="LINEBELOW" colorName="#e6e6e6" start="0,2" stop="-1,-1"/>
+
+      <blockValign value="TOP"/>
+      <blockAlignment value="LEFT" start="2,1" stop="-1,-1"/>
+    </blockTableStyle>
+    <blockTableStyle id="Table8">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
+      <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="-1,-1"/>
+      <lineStyle kind="LINEAFTER" colorName="#cccccc" start="0,0" stop="-1,-1"/>
+      <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,0" stop="-1,-1"/>
+    </blockTableStyle>
+
+    <blockTableStyle id="Tableau3">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+      <lineStyle kind="GRID" colorName="black"/>
+    </blockTableStyle>
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="P1" fontName="Helvetica" fontSize="20.0" leading="25" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P2" fontName="Helvetica" fontSize="8.3" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P2_content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Total" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Total_right" fontName="Helvetica-Bold" fontSize="8.5" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P3" fontName="Helvetica" fontSize="15.0" leading="20" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P4" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P5" fontName="Helvetica" fontSize="8.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P6" fontName="Helvetica" fontSize="8.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P7" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P8" fontName="Helvetica" fontSize="8.3" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="content" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P10" fontName="Helvetica" fontSize="8.0" leading="14" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P11" fontName="Helvetica" fontSize="8.0" leading="14" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P12" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P13" fontName="Helvetica" fontSize="8.0" leading="10" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="13" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="P10" fontName="Helvetica" alignment="RIGHT" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Standard" fontName="Helvetica"/>
+    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Heading" fontName="Helvetica" fontSize="8.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Caption" fontName="Helvetica" fontSize="8.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="Index" fontName="Helvetica"/>
+    <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_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" 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="15" 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"/>
+    <paraStyle name="terp_default_9_italic" fontName="Helvetica-Oblique" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+    <paraStyle name="terp_default_Right_9_Bold" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+  	<paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+
+  </stylesheet>
+  <story>
+
+     <blockTable colWidths="180.0,180.0,180.0" style="Table_header_Content">
+      <tr>
+        <td><para style="terp_header"><font color="white"> </font></para>
+        </td>
+        <td><para style="terp_header_Centre">Aged Trial Balance</para></td>
+        <td><para style="terp_header"><font color="white"> </font></para></td>
+      </tr>
+    </blockTable>
+    <blockTable colWidths="110.0,110.0,110.0,110.0,128.0,93.0,110.0" style="Table8">
+      <tr>
+        <td>
+          <para style="terp_tblheader_General_Centre">Chart of Account</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_General_Centre">Fiscal Year</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_General_Centre">Start Date</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_General_Centre">Period Length(days)</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_General_Centre">Partner's</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_General_Centre">Analysis Direction</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_General_Centre">Target Moves</para>
+        </td>
+      </tr>
+        <tr>
+        <td>
+          <para style="terp_default_Centre_8">[[ get_account(data) or '' ]]</para>
+        </td>
+        <td>
+          <para style="terp_default_Centre_8">[[ get_fiscalyear(data) or '' ]]</para>
+        </td>
+        <td>
+          <para style="terp_default_Centre_8">[[ formatLang(data['form']['date_from'],date=True) ]]</para>
+        </td>
+        <td>
+          <para style="terp_default_Centre_8">[[ data['form']['period_length'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_default_Centre_8">[[ get_partners(data) ]]</para>
+        </td>
+        <td>
+          <para style="terp_default_Centre_8">[[ data['form']['direction_selection'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_default_Centre_8">[[ get_target_move(data) ]]</para>
+        </td>
+      </tr>
+      </blockTable>
+	<para style="P9">
+      <font color="white"> </font>
+    </para>
+    <blockTable colWidths="135.0,90.0,90.0,90.0,90.0,90.0,90.0,90.0" style="Table2" repeatRows="1">
+      <tr>
+        <td>
+          <para style="terp_tblheader_Details">Partners</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">[[ data['form']['direction_selection'] == 'future' and 'Due' or 'Not due' ]]</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">[[ data['form']['4']['name'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">[[ data['form']['3']['name'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">[[ data['form']['2']['name'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">[[ data['form']['1']['name'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">[[ data['form']['0']['name'] ]]</para>
+        </td>
+        <td>
+          <para style="terp_tblheader_Details_Right">Total</para>
+        </td>
+      </tr>
+
+      <tr>
+
+        <td>
+          <para style="P3"> <font color="white">[[ (get_lines(data['form']), 'partner') == False or removeParentNode('para')  ]]</font></para>
+          <para style="P3"> <font color="white">[[ (get_lines_with_out_partner(data['form']), 'not_partner') == False or removeParentNode('para')  ]]</font></para>
+          <para style="Total">Account Total</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_direction('6')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_for_period('4')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_for_period('3')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_for_period('2')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_for_period('1')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_for_period('0')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="Total_right">[[ formatLang(get_total('5')) ]] [[ company.currency_id.code ]]</para>
+        </td>
+      </tr>
+
+      <tr>
+        <td>
+          <para style="P3">[[ repeatIn(get_lines(data['form']), 'partner') ]]</para>
+          <para style="P2_content">[[ partner['name'] ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['direction']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['4'])]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['3'])]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['2']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['1'])  ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['0']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(partner['total']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+      </tr>
+      <tr>
+        <td>
+          <para style="P3">[[ repeatIn(get_lines_with_out_partner(data['form']), 'not_partner') ]]</para>
+          <para style="P2_content">[[ not_partner['name'] ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['direction']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['4'])]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['3'])]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['2']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['1'])  ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['0']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+        <td>
+          <para style="content">[[ formatLang(not_partner['total']) ]] [[ company.currency_id.code ]]</para>
+        </td>
+      </tr>
+    </blockTable>
+
+    <para style="P9">
+      <font color="white"> </font>
+    </para>
+  </story>
+</document>
+

=== added file 'account_report_aged_partner_balance_v6/report/common_report_header.py'
--- account_report_aged_partner_balance_v6/report/common_report_header.py	1970-01-01 00:00:00 +0000
+++ account_report_aged_partner_balance_v6/report/common_report_header.py	2012-06-28 13:21:29 +0000
@@ -0,0 +1,143 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import pooler
+from tools.translate import _
+
+class common_report_header(object):
+
+    def _sum_debit(self, period_id=False, journal_id=False):
+        if journal_id and isinstance(journal_id, int):
+            journal_id = [journal_id]
+        if period_id and isinstance(period_id, int):
+            period_id = [period_id]
+        if not journal_id:
+            journal_id = self.journal_ids
+        if not period_id:
+            period_id = self.period_ids
+        if not (period_id and journal_id):
+            return 0.0
+        self.cr.execute('SELECT SUM(debit) FROM account_move_line l '
+                        'WHERE period_id IN %s AND journal_id IN %s ' + self.query_get_clause + ' ',
+                        (tuple(period_id), tuple(journal_id)))
+        return self.cr.fetchone()[0] or 0.0
+
+    def _sum_credit(self, period_id=False, journal_id=False):
+        if journal_id and isinstance(journal_id, int):
+            journal_id = [journal_id]
+        if period_id and isinstance(period_id, int):
+            period_id = [period_id]
+        if not journal_id:
+            journal_id = self.journal_ids
+        if not period_id:
+            period_id = self.period_ids
+        if not (period_id and journal_id):
+            return 0.0
+        self.cr.execute('SELECT SUM(credit) FROM account_move_line l '
+                        'WHERE period_id IN %s AND journal_id IN %s '+ self.query_get_clause+'',
+                        (tuple(period_id), tuple(journal_id)))
+        return self.cr.fetchone()[0] or 0.0
+
+    def _get_start_date(self, data):
+        if data.get('form', False) and data['form'].get('date_from', False):
+            return data['form']['date_from']
+        return ''
+
+    def _get_target_move(self, data):
+        if data.get('form', False) and data['form'].get('target_move', False):
+            if data['form']['target_move'] == 'all':
+                return 'All Entries'
+            return 'All Posted Entries'
+        return ''
+
+    def _get_end_date(self, data):
+        if data.get('form', False) and data['form'].get('date_to', False):
+            return data['form']['date_to']
+        return ''
+
+    def get_start_period(self, data):
+        if data.get('form', False) and data['form'].get('period_from', False):
+            return pooler.get_pool(self.cr.dbname).get('account.period').browse(self.cr,self.uid,data['form']['period_from']).name
+        return ''
+
+    def get_end_period(self, data):
+        if data.get('form', False) and data['form'].get('period_to', False):