Merge lp:~akretion-team/banking-addons/70-sepa-trf-dd-updates into lp:banking-addons

[Alexis de Lattre]

This branch contains :
- support for SEPA direct debit
- the work I carried out with Luc de Meyer (Noviat) during a code sprint on November 21st to get the additionnal features that were present in Luc's module account_pain for SEPA credit transfer (including the "Initiating Party Issuer", which is required by a few countries including Belgium and structured remittance info)
- the module account_banking_pain_base : this module allows to share as much code as possible between the module for credit transfers and the module for direct debits

This merge proposal replaces my former merge proposal which took too much time (the code was already out-dated) :
https://code.launchpad.net/~akretion-team/banking-addons/70-sepa-direct-debit/+merge/195139

P.S. : 38 days left before SEPA migration deadline !

[Alexis de Lattre (alexis-via)]

One small note for the PEP8 fundamentalists : the 3 modules account_banking_pain_base, account_banking_sepa_credit_transfer and account_banking_sepa_direct_debit are fully PEP8 compliant, so you won't be able to block this merge proposal for such a stupid reason :)

[Stefan Rijnhart (Opener) (stefan-opener)]

Hi,

first of all sorry for my absense on the community front, I have been too busy with first of January deadlines. Hope to show my face more often soon.

So I just had a quick glance and I must thank you Alexis and Luc for your great work. Just one thought about the removal of the communication2 field from the payment line view: does SEPA not allow additional comments on the order lines? And if it really doesn't, maybe we could make the payment view a little bit more dynamic depending on the payment type in a future proposal. Could you leave it in for now?

A cosmetic thing: it seems that remittance_info_unstructured_2_100 should be called remittance_info_structured_2_100

review: Needs Information

[Stéphane Bidoul (Acsone) (sbi)]

Thanks Alexis and Luc for this great effort.

I made a quick test of account_banking_sepa_credit_transfer and it looks good.

In combination with base_iban_bic_not_required however, it complains with Cannot compute 'Debtor BIC' or 'Creditor BIC'. the PAIN xsd have the BIC elements optional. Can you fix that one?

On the nitpicking side, I noticed a few "return True" and the end of generate_*_block methods which are unncessary.

review: Needs Fixing (sct test)

[lp:~akretion-team/banking-addons/70-sepa-trf-dd-updates]

226. By Alexis de Lattre on 2014-01-04

Put the field communication2 back in the view of payment lines.
Rename a badly named variable (thanks to Stefan Rijnhart for spotting this)

[Alexis de Lattre (alexis-via)]

@Stefan :

I fixed the variable name, thanks for spotting.

About the communication2 field :
- for the unstructured remittance info, there is only a single field of 140 chars. The PAIN standard says "[0..n]" for the unstructured tag, but the EPC guidelines explicitely say "Format Rule: Only one occurrence of ‘Unstructured’ is allowed."
- for the structured remittance info, we use the communication field for the 2.126 reference field (35 chars) ; maybe we could use the communication2 field for the 2.129 "Additionnal Remittance information" field, which is fully optional. But, at the moment, when you have the communication type set to structured, OpenERP prevent you from using the field "communication2" ; it seems that this is managed by addons-70/account_payment/account_payment.py in the function fields_get() at the end of the file.

I must say that I don't like to have these 2 fields "communication" and "communication2", because I find it confusing for the users, and I would prefer a single field "communication" to make things simple and avoid mistakes.

By the way, investigating this made me realize that, when communication type = "Free", you can't use the field "communication" because it is readonly ; only the field "communication2" is usable in this case. This is really a mess and the help message on the communication fields don't mention that at all ; I find it very confusing.

@Stéphane Bidoul:

About the "BIC not required". First, looking at the XSD file is not enough, because the target is to respect the guidelines of the European Payment Council (EPC) for SEPA, which may add some constrains that are not in the PAIN standard and thus that are not in the XSD file. When I look at the EPC guidelines, I understand this :

- for the Debtor agent (2.21), this tag is [1..1], but it seems possible to not use the "BIC" and set "Debtor Agent > Financial Institution Identification > Other > Identification" to "NOTPROVIDED".

- for the Creditor agent (2.77), it says explicitely "Usage Rule: Only BIC is allowed", but the Credit Agent tag (2.77) is [0..1], so it may be dropped.

From what I understand, BIC is required for international payments but not required for national payment. When I look at the code of the module "base_iban_bic_not_required", I see that it drops the constraint all together, so, with this module, the user is allowed to enter a foreigh bank account without BIC, which is a problem.

So who handles the check that BIC is present if the IBAN is from a different country than the country of the company ?
Option A : we update the module "base_iban_bic_not_required" to have a constraints which make BIC required when the country of the IBAN is different from the country of "Your Company".
Option B : I handle this check in the code of the SEPA modules.

I think option B is better because it will block user earlier in the process (when entering the bank account in OpenERP, not when generating the SEPA XML file). If we agree on option B :
- someone has to update the module "base_iban_bic_not_required" to have a constraints which make BIC required when the country of the IBAN is different from the country of "Your Company".
- I will update ...

[Stefan Rijnhart (Opener) (stefan-opener)]

Thanks for your changes! As for optional bics, you wrote you preferred B but I when I read carefully you mean option A.
However, res.partner.bank is not linked to a company, unless it is a bank account of the company itself. Therefore, I do think option B is the only feasible possibility for the constraint, because only then the company and therefore its country is known.

[Alexis de Lattre (alexis-via)]

@Stefan

Yes, I meant option A, but I understand you remark about the fact that res.partner.bank is not linked to a company.

So it leaves us with option B... which means I will have to do all the work in my code ! :) But it shouldn't be very hard, as I just have to check that the 2 first letters of the IBAN of the creditor correspond to the country of the debtor (for a SCT).

[lp:~akretion-team/banking-addons/70-sepa-trf-dd-updates]

227. By Alexis de Lattre on 2014-01-04

If it's a national payment, we now support "BIC not provided".

[Alexis de Lattre (alexis-via)]

@Stéphane Bidoul:

I have implemented option B in revno 227.

I am wondering something : if it's a cross-border credit transfer, we have to provide the BIC of the foreign creditors (my code checks this and raises a nice error msg if it's not the case), but do we have to provide the BIC of the debtor (= Your Company) ?

I am still interested in reading more documentation about the "BIC not required", because I haven't found accurate info about it yet.

[Stefan Rijnhart (Opener) (stefan-opener)]

Basic facts:

The Business Identifier Code (BIC) may still be required until 1 February 2014 for domestic payments and 1 February 2016 for cross-border payments. Member States may defer the requirement relating to the provision of the BIC for national payment transactions until 1 February 2016.

http://www.ecb.europa.eu/paym/sepa/about/migration/html/index.en.html

This is expressed differently in different bank's specifications. One bank says: the BIC field is ignored, don't use it. Another bank says: the field is optional. You should use it if the bank cannot determine the BIC by itself.

I know it's not that well specified, but it seems to me that there is even less need for the bank to know the BIC of their own customers. Then again, it seems just good practice if the company BIC were stored properly in OpenERP (I think it is printed by default in the standard report footer). Maybe this is something that can be implemented as a contraint in the not_required module.

[Stefan Rijnhart (Opener) (stefan-opener)]

BTW thanks for already coding the support for missing BICs. In this code, you catch the general exception. Can you catch the actual exception raised instead, or if it's only an exception caused by missing BIC, deal with this differently than a try/catch block?

review: Needs Fixing

[lp:~akretion-team/banking-addons/70-sepa-trf-dd-updates]

228. By Alexis de Lattre on 2014-01-05

For SCT, if BIC is not provided, we should not put the 'Creditor Agent' block at all, according to EPC guidelines (on this point, it is different from the Direct Debit !)

[Alexis de Lattre (alexis-via)]

@Stefan

Thanks for your very clear explaination about BIC and for the URL you provided. It is very clear for me now.

I made some test on the website of a French bank and read this interesting document which precisely deal with this topic (the doc is in French, sorry) :
http://universwiftnet.files.wordpress.com/2013/07/addendum-guides-utilisation-standard-iso20022-remises-ordres-sepa-v1-0.pdf

This document underline a small detail that I didn't catch when reading the guidelines of the EPC : in a credit transfer, for the creditor, you should not put the CreditorAgent block at all (but, in a direct debit, for the debtor, you should use the current implementation Financial Institution Identification > Other > Identification = NOTPROVIDED). I checked again in the guidelines of the EPC and it confirm this. So I have just modified my code to reflect this.

About the exception, you are right, my code is not as good as it should. I am not an expert in this, but i'll try to do better in a later commit.

[Stéphane Bidoul (Acsone) (sbi)]

Thanks a lot for the improvement with missing BICs.

I tested it again and checked with the ING validator.

LGTM for SCT.

review: Approve (test sct)

[lp:~akretion-team/banking-addons/70-sepa-trf-dd-updates]

229. By Alexis de Lattre on 2014-01-13

Only catch the openerp exception in generate_party_agent(), as suggested by Stefan on the MP.

[Alexis de Lattre (alexis-via)]

@Stefan

Could you tell me if my last commit revno 229 addresses your point about the management of the exception ?

[Stefan Rijnhart (Opener) (stefan-opener)]

To be honest, I am still wondering what exception is actually raised in the 'try' block. Is it a direct consequence of the missing BIC? In that case, a simple if-clause would be nicer.

review: Needs Information

[Alexis de Lattre (alexis-via)]

@Stefan

Yes, it is a direct consequence of the support of the missing BIC. I can't put an "if" clause, because the content of the if would be different depending on the origin of the function call :

- if we are in block B, we would have to test "sepa_export.payment_order_ids[0].mode.bank_id.bank.bic"

- if we are in block C, we would have to test "line.bank_id.bank.bic"

I think that, if we want to avoid this "try/except" in generate_party_agent(), I would need to fully re-organize the code about BIC following the introduction of the support of the missing BIC :
- check if we have a BIC or not in wizard/export_sepa.py just before each call to the function generate_party_block() and pass this information in the call of the function generate_party_block()
- then I could remove the try/except in the function generate_party_agent()

So, if you still want me to remove the try/except in generate_party_agent() and you agree with my proposal to re-organise the code, I will make the change described above.

[Stefan Rijnhart (Opener) (stefan-opener)]

Thank you for your response, Alexis. I see it is a little more complicated than a simple if-clause. An alternative solution could be to throw proper ValueError (if it is empty) and TypeError (if it is not a str/unicode) exceptions in _prepare_field, so you could catch these specific exceptions in the try/catch block. But if these were to occur elsewhere, the user would be confronted with a backtrace instead of a popup error from the except_orm.

Given the deadline, maybe this issue should better be put this on the todo list so I'll approve this one now.

review: Approve

[Christophe Combelles (ccomb)]

We're successfully using this module in production for a few weeks,
thanks for the work!

review: Approve

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

Excellent work. Thanks

review: Approve

=== added directory 'account_banking_pain_base'
=== added file 'account_banking_pain_base/__init__.py'
--- account_banking_pain_base/__init__.py	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/__init__.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,26 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    PAIN Base module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from . import payment_line
+from . import payment_mode
+from . import company
+from . import banking_export_pain
 
=== added file 'account_banking_pain_base/__openerp__.py'
--- account_banking_pain_base/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/__openerp__.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,50 @@
+##############################################################################
+#
+#    PAIN base module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+{
+    'name': 'Account Banking PAIN Base Module',
+    'summary': 'Base module for PAIN file generation',
+    'version': '0.1',
+    'license': 'AGPL-3',
+    'author': 'Akretion, Noviat',
+    'website': 'http://openerp-community-association.org/',
+    'category': 'Hidden',
+    'depends': ['account_banking_payment_export'],
+    'external_dependencies': {
+        'python': ['unidecode', 'lxml'],
+        },
+    'data': [
+        'payment_line_view.xml',
+        'payment_mode_view.xml',
+        'company_view.xml',
+    ],
+    'description': '''
+Base module for PAIN file generation
+====================================
+
+This module contains fields and functions that are used by the module for SEPA Credit Transfer (account_banking_sepa_credit_transfer) and SEPA Direct Debit (account_banking_sepa_direct_debit). This module doesn't provide any functionnality by itself.
+
+This module is part of the banking addons: https://launchpad.net/banking-addons
+
+This module was started during the Akretion-Noviat code sprint of November 21st 2013 in Epiais les Louvres (France).
+    ''',
+    'active': False,
+    'installable': True,
+}
 
=== added file 'account_banking_pain_base/banking_export_pain.py'
--- account_banking_pain_base/banking_export_pain.py	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/banking_export_pain.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,439 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    PAIN Base module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.osv import orm
+from openerp.tools.translate import _
+from openerp.tools.safe_eval import safe_eval
+from datetime import datetime
+from unidecode import unidecode
+from lxml import etree
+from openerp import tools
+import logging
+import base64
+
+logger = logging.getLogger(__name__)
+
+
+class banking_export_pain(orm.AbstractModel):
+    _name = 'banking.export.pain'
+
+    def _validate_iban(self, cr, uid, iban, context=None):
+        '''if IBAN is valid, returns IBAN
+        if IBAN is NOT valid, raises an error message'''
+        partner_bank_obj = self.pool.get('res.partner.bank')
+        if partner_bank_obj.is_iban_valid(cr, uid, iban, context=context):
+            return iban.replace(' ', '')
+        else:
+            raise orm.except_orm(
+                _('Error:'), _("This IBAN is not valid : %s") % iban)
+
+    def _prepare_field(
+            self, cr, uid, field_name, field_value, eval_ctx, max_size=0,
+            gen_args=None, context=None):
+        '''This function is designed to be inherited !'''
+        if gen_args is None:
+            gen_args = {}
+        assert isinstance(eval_ctx, dict), 'eval_ctx must contain a dict'
+        try:
+            value = safe_eval(field_value, eval_ctx)
+            # SEPA uses XML ; XML = UTF-8 ; UTF-8 = support for all characters
+            # But we are dealing with banks...
+            # and many banks don't want non-ASCCI characters !
+            # cf section 1.4 "Character set" of the SEPA Credit Transfer
+            # Scheme Customer-to-bank guidelines
+            if gen_args.get('convert_to_ascii'):
+                value = unidecode(value)
+                unallowed_ascii_chars = [
+                    '"', '#', '$', '%', '&', '*', ';', '<', '>', '=', '@',
+                    '[', ']', '^', '_', '`', '{', '}', '|', '~', '\\', '!']
+                for unallowed_ascii_char in unallowed_ascii_chars:
+                    value = value.replace(unallowed_ascii_char, '-')
+        except:
+            line = eval_ctx.get('line')
+            if line:
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("Cannot compute the '%s' of the Payment Line with "
+                        "reference '%s'.")
+                    % (field_name, line.name))
+            else:
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("Cannot compute the '%s'.") % field_name)
+        if not isinstance(value, (str, unicode)):
+            raise orm.except_orm(
+                _('Field type error:'),
+                _("The type of the field '%s' is %s. It should be a string "
+                    "or unicode.")
+                % (field_name, type(value)))
+        if not value:
+            raise orm.except_orm(
+                _('Error:'),
+                _("The '%s' is empty or 0. It should have a non-null value.")
+                % field_name)
+        if max_size and len(value) > max_size:
+            value = value[0:max_size]
+        return value
+
+    def _prepare_export_sepa(
+            self, cr, uid, total_amount, transactions_count, xml_string,
+            gen_args, context=None):
+        return {
+            'batch_booking': gen_args['sepa_export'].batch_booking,
+            'charge_bearer': gen_args['sepa_export'].charge_bearer,
+            'total_amount': total_amount,
+            'nb_transactions': transactions_count,
+            'file': base64.encodestring(xml_string),
+            'payment_order_ids': [(
+                6, 0, [x.id for x in gen_args['sepa_export'].payment_order_ids]
+            )],
+        }
+
+    def _validate_xml(self, cr, uid, xml_string, gen_args, context=None):
+        xsd_etree_obj = etree.parse(
+            tools.file_open(gen_args['pain_xsd_file']))
+        official_pain_schema = etree.XMLSchema(xsd_etree_obj)
+
+        try:
+            root_to_validate = etree.fromstring(xml_string)
+            official_pain_schema.assertValid(root_to_validate)
+        except Exception, e:
+            logger.warning(
+                "The XML file is invalid against the XML Schema Definition")
+            logger.warning(xml_string)
+            logger.warning(e)
+            raise orm.except_orm(
+                _('Error:'),
+                _("The generated XML file is not valid against the official "
+                    "XML Schema Definition. The generated XML file and the "
+                    "full error have been written in the server logs. Here "
+                    "is the error, which may give you an idea on the cause "
+                    "of the problem : %s")
+                % str(e))
+        return True
+
+    def finalize_sepa_file_creation(
+            self, cr, uid, ids, xml_root, total_amount, transactions_count,
+            gen_args, context=None):
+        xml_string = etree.tostring(
+            xml_root, pretty_print=True, encoding='UTF-8',
+            xml_declaration=True)
+        logger.debug(
+            "Generated SEPA XML file in format %s below"
+            % gen_args['pain_flavor'])
+        logger.debug(xml_string)
+        self._validate_xml(cr, uid, xml_string, gen_args, context=context)
+
+        file_id = gen_args['file_obj'].create(
+            cr, uid, self._prepare_export_sepa(
+                cr, uid, total_amount, transactions_count,
+                xml_string, gen_args, context=context),
+            context=context)
+
+        self.write(
+            cr, uid, ids, {
+                'file_id': file_id,
+                'state': 'finish',
+            }, context=context)
+
+        action = {
+            'name': 'SEPA File',
+            'type': 'ir.actions.act_window',
+            'view_type': 'form',
+            'view_mode': 'form,tree',
+            'res_model': self._name,
+            'res_id': ids[0],
+            'target': 'new',
+            }
+        return action
+
+    def generate_group_header_block(
+            self, cr, uid, parent_node, gen_args, context=None):
+        group_header_1_0 = etree.SubElement(parent_node, 'GrpHdr')
+        message_identification_1_1 = etree.SubElement(
+            group_header_1_0, 'MsgId')
+        message_identification_1_1.text = self._prepare_field(
+            cr, uid, 'Message Identification',
+            'sepa_export.payment_order_ids[0].reference',
+            {'sepa_export': gen_args['sepa_export']}, 35,
+            gen_args=gen_args, context=context)
+        creation_date_time_1_2 = etree.SubElement(group_header_1_0, 'CreDtTm')
+        creation_date_time_1_2.text = datetime.strftime(
+            datetime.today(), '%Y-%m-%dT%H:%M:%S')
+        if gen_args.get('pain_flavor') == 'pain.001.001.02':
+            # batch_booking is in "Group header" with pain.001.001.02
+            # and in "Payment info" in pain.001.001.03/04
+            batch_booking = etree.SubElement(group_header_1_0, 'BtchBookg')
+            batch_booking.text = \
+                str(gen_args['sepa_export'].batch_booking).lower()
+        nb_of_transactions_1_6 = etree.SubElement(
+            group_header_1_0, 'NbOfTxs')
+        control_sum_1_7 = etree.SubElement(group_header_1_0, 'CtrlSum')
+        # Grpg removed in pain.001.001.03
+        if gen_args.get('pain_flavor') == 'pain.001.001.02':
+            grouping = etree.SubElement(group_header_1_0, 'Grpg')
+            grouping.text = 'GRPD'
+        self.generate_initiating_party_block(
+            cr, uid, group_header_1_0, gen_args,
+            context=context)
+        return group_header_1_0, nb_of_transactions_1_6, control_sum_1_7
+
+    def generate_start_payment_info_block(
+            self, cr, uid, parent_node, payment_info_ident,
+            priority, local_instrument, sequence_type, requested_date,
+            eval_ctx, gen_args, context=None):
+        payment_info_2_0 = etree.SubElement(parent_node, 'PmtInf')
+        payment_info_identification_2_1 = etree.SubElement(
+            payment_info_2_0, 'PmtInfId')
+        payment_info_identification_2_1.text = self._prepare_field(
+            cr, uid, 'Payment Information Identification',
+            payment_info_ident, eval_ctx, 35,
+            gen_args=gen_args, context=context)
+        payment_method_2_2 = etree.SubElement(payment_info_2_0, 'PmtMtd')
+        payment_method_2_2.text = gen_args['payment_method']
+        if gen_args.get('pain_flavor') != 'pain.001.001.02':
+            batch_booking_2_3 = etree.SubElement(payment_info_2_0, 'BtchBookg')
+            batch_booking_2_3.text = \
+                str(gen_args['sepa_export'].batch_booking).lower()
+        # The "SEPA Customer-to-bank
+        # Implementation guidelines" for SCT and SDD says that control sum
+        # and nb_of_transactions should be present
+        # at both "group header" level and "payment info" level
+            nb_of_transactions_2_4 = etree.SubElement(
+                payment_info_2_0, 'NbOfTxs')
+            control_sum_2_5 = etree.SubElement(payment_info_2_0, 'CtrlSum')
+        payment_type_info_2_6 = etree.SubElement(
+            payment_info_2_0, 'PmtTpInf')
+        if priority:
+            instruction_priority_2_7 = etree.SubElement(
+                payment_type_info_2_6, 'InstrPrty')
+            instruction_priority_2_7.text = priority
+        service_level_2_8 = etree.SubElement(
+            payment_type_info_2_6, 'SvcLvl')
+        service_level_code_2_9 = etree.SubElement(service_level_2_8, 'Cd')
+        service_level_code_2_9.text = 'SEPA'
+        if local_instrument:
+            local_instrument_2_11 = etree.SubElement(
+                payment_type_info_2_6, 'LclInstrm')
+            local_instr_code_2_12 = etree.SubElement(
+                local_instrument_2_11, 'Cd')
+            local_instr_code_2_12.text = local_instrument
+        if sequence_type:
+            sequence_type_2_14 = etree.SubElement(
+                payment_type_info_2_6, 'SeqTp')
+            sequence_type_2_14.text = sequence_type
+
+        if gen_args['payment_method'] == 'DD':
+            request_date_tag = 'ReqdColltnDt'
+        else:
+            request_date_tag = 'ReqdExctnDt'
+        requested_date_2_17 = etree.SubElement(
+            payment_info_2_0, request_date_tag)
+        requested_date_2_17.text = requested_date
+        return payment_info_2_0, nb_of_transactions_2_4, control_sum_2_5
+
+    def generate_initiating_party_block(
+            self, cr, uid, parent_node, gen_args, context=None):
+        my_company_name = self._prepare_field(
+            cr, uid, 'Company Name',
+            'sepa_export.payment_order_ids[0].mode.bank_id.partner_id.name',
+            {'sepa_export': gen_args['sepa_export']},
+            gen_args.get('name_maxsize'), gen_args=gen_args, context=context)
+        initiating_party_1_8 = etree.SubElement(parent_node, 'InitgPty')
+        initiating_party_name = etree.SubElement(initiating_party_1_8, 'Nm')
+        initiating_party_name.text = my_company_name
+        initiating_party_identifier = self.pool['res.company'].\
+            _get_initiating_party_identifier(
+                cr, uid,
+                gen_args['sepa_export'].payment_order_ids[0].company_id.id,
+                context=context)
+        initiating_party_issuer = gen_args['sepa_export'].\
+            payment_order_ids[0].company_id.initiating_party_issuer
+        if initiating_party_identifier and initiating_party_issuer:
+            iniparty_id = etree.SubElement(initiating_party_1_8, 'Id')
+            iniparty_org_id = etree.SubElement(iniparty_id, 'OrgId')
+            iniparty_org_other = etree.SubElement(iniparty_org_id, 'Othr')
+            iniparty_org_other_id = etree.SubElement(iniparty_org_other, 'Id')
+            iniparty_org_other_id.text = initiating_party_identifier
+            iniparty_org_other_issuer = etree.SubElement(
+                iniparty_org_other, 'Issr')
+            iniparty_org_other_issuer.text = initiating_party_issuer
+        return True
+
+    def generate_party_agent(
+            self, cr, uid, parent_node, party_type, party_type_label,
+            order, party_name, iban, bic, eval_ctx, gen_args, context=None):
+        '''Generate the piece of the XML file corresponding to BIC
+        This code is mutualized between TRF and DD'''
+        assert order in ('B', 'C'), "Order can be 'B' or 'C'"
+        try:
+            bic = self._prepare_field(
+                cr, uid, '%s BIC' % party_type_label, bic, eval_ctx,
+                gen_args=gen_args, context=context)
+            party_agent = etree.SubElement(parent_node, '%sAgt' % party_type)
+            party_agent_institution = etree.SubElement(
+                party_agent, 'FinInstnId')
+            party_agent_bic = etree.SubElement(
+                party_agent_institution, gen_args.get('bic_xml_tag'))
+            party_agent_bic.text = bic
+        except except_orm:
+            if order == 'C':
+                if iban[0:2] != gen_args['initiating_party_country_code']:
+                    raise orm.except_orm(
+                        _('Error:'),
+                        _("The bank account with IBAN '%s' of partner '%s' "
+                            "must have an associated BIC because it is a "
+                            "cross-border SEPA operation.")
+                        % (iban, party_name))
+            if order == 'B' or (
+                    order == 'C' and gen_args['payment_method'] == 'DD'):
+                party_agent = etree.SubElement(
+                    parent_node, '%sAgt' % party_type)
+                party_agent_institution = etree.SubElement(
+                    party_agent, 'FinInstnId')
+                party_agent_other = etree.SubElement(
+                    party_agent_institution, 'Othr')
+                party_agent_other_identification = etree.SubElement(
+                    party_agent_other, 'Id')
+                party_agent_other_identification.text = 'NOTPROVIDED'
+            # for Credit Transfers, in the 'C' block, if BIC is not provided,
+            # we should not put the 'Creditor Agent' block at all,
+            # as per the guidelines of the EPC
+        return True
+
+    def generate_party_block(
+            self, cr, uid, parent_node, party_type, order, name, iban, bic,
+            eval_ctx, gen_args, context=None):
+        '''Generate the piece of the XML file corresponding to Name+IBAN+BIC
+        This code is mutualized between TRF and DD'''
+        assert order in ('B', 'C'), "Order can be 'B' or 'C'"
+        if party_type == 'Cdtr':
+            party_type_label = 'Creditor'
+        elif party_type == 'Dbtr':
+            party_type_label = 'Debtor'
+        party_name = self._prepare_field(
+            cr, uid, '%s Name' % party_type_label, name, eval_ctx,
+            gen_args.get('name_maxsize'),
+            gen_args=gen_args, context=context)
+        piban = self._prepare_field(
+            cr, uid, '%s IBAN' % party_type_label, iban, eval_ctx,
+            gen_args=gen_args,
+            context=context)
+        viban = self._validate_iban(cr, uid, piban, context=context)
+        # At C level, the order is : BIC, Name, IBAN
+        # At B level, the order is : Name, IBAN, BIC
+        if order == 'B':
+            gen_args['initiating_party_country_code'] = viban[0:2]
+        elif order == 'C':
+            self.generate_party_agent(
+                cr, uid, parent_node, party_type, party_type_label,
+                order, party_name, viban, bic,
+                eval_ctx, gen_args, context=context)
+        party = etree.SubElement(parent_node, party_type)
+        party_nm = etree.SubElement(party, 'Nm')
+        party_nm.text = party_name
+        party_account = etree.SubElement(
+            parent_node, '%sAcct' % party_type)
+        party_account_id = etree.SubElement(party_account, 'Id')
+        party_account_iban = etree.SubElement(
+            party_account_id, 'IBAN')
+        party_account_iban.text = viban
+        if order == 'B':
+            self.generate_party_agent(
+                cr, uid, parent_node, party_type, party_type_label,
+                order, party_name, viban, bic,
+                eval_ctx, gen_args, context=context)
+        return True
+
+    def generate_remittance_info_block(
+            self, cr, uid, parent_node, line, gen_args, context=None):
+
+        remittance_info_2_91 = etree.SubElement(
+            parent_node, 'RmtInf')
+        if line.state == 'normal':
+            remittance_info_unstructured_2_99 = etree.SubElement(
+                remittance_info_2_91, 'Ustrd')
+            remittance_info_unstructured_2_99.text = \
+                self._prepare_field(
+                    cr, uid, 'Remittance Unstructured Information',
+                    'line.communication', {'line': line}, 140,
+                    gen_args=gen_args,
+                    context=context)
+        else:
+            if not line.struct_communication_type:
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("Missing 'Structured Communication Type' on payment "
+                        "line with reference '%s'.")
+                    % (line.name))
+            remittance_info_structured_2_100 = etree.SubElement(
+                remittance_info_2_91, 'Strd')
+            creditor_ref_information_2_120 = etree.SubElement(
+                remittance_info_structured_2_100, 'CdtrRefInf')
+            if gen_args.get('pain_flavor') == 'pain.001.001.02':
+                creditor_ref_info_type_2_121 = etree.SubElement(
+                    creditor_ref_information_2_120, 'CdtrRefTp')
+                creditor_ref_info_type_code_2_123 = etree.SubElement(
+                    creditor_ref_info_type_2_121, 'Cd')
+                creditor_ref_info_type_issuer_2_125 = etree.SubElement(
+                    creditor_ref_info_type_2_121, 'Issr')
+                creditor_reference_2_126 = etree.SubElement(
+                    creditor_ref_information_2_120, 'CdtrRef')
+            else:
+                creditor_ref_info_type_2_121 = etree.SubElement(
+                    creditor_ref_information_2_120, 'Tp')
+                creditor_ref_info_type_or_2_122 = etree.SubElement(
+                    creditor_ref_info_type_2_121, 'CdOrPrtry')
+                creditor_ref_info_type_code_2_123 = etree.SubElement(
+                    creditor_ref_info_type_or_2_122, 'Cd')
+                creditor_ref_info_type_issuer_2_125 = etree.SubElement(
+                    creditor_ref_info_type_2_121, 'Issr')
+                creditor_reference_2_126 = etree.SubElement(
+                    creditor_ref_information_2_120, 'Ref')
+
+            creditor_ref_info_type_code_2_123.text = 'SCOR'
+            creditor_ref_info_type_issuer_2_125.text = \
+                line.struct_communication_type
+            creditor_reference_2_126.text = \
+                self._prepare_field(
+                    cr, uid, 'Creditor Structured Reference',
+                    'line.communication', {'line': line}, 35,
+                    gen_args=gen_args,
+                    context=context)
+        return True
+
+    def generate_creditor_scheme_identification(
+            self, cr, uid, parent_node, identification, identification_label,
+            eval_ctx, scheme_name_proprietary, gen_args, context=None):
+        csi_id = etree.SubElement(
+            parent_node, 'Id')
+        csi_privateid = csi_id = etree.SubElement(csi_id, 'PrvtId')
+        csi_other = etree.SubElement(csi_privateid, 'Othr')
+        csi_other_id = etree.SubElement(csi_other, 'Id')
+        csi_other_id.text = self._prepare_field(
+            cr, uid, identification_label, identification, eval_ctx,
+            gen_args=gen_args, context=context)
+        csi_scheme_name = etree.SubElement(csi_other, 'SchmeNm')
+        csi_scheme_name_proprietary = etree.SubElement(
+            csi_scheme_name, 'Prtry')
+        csi_scheme_name_proprietary.text = scheme_name_proprietary
+        return True
 
=== added file 'account_banking_pain_base/company.py'
--- account_banking_pain_base/company.py	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/company.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,78 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    PAIN Base module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    Copyright (C) 2013 Noviat (http://www.noviat.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#    @author: Luc de Meyer (Noviat)
+#
+#    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 openerp.osv import orm, fields
+
+
+class res_company(orm.Model):
+    _inherit = 'res.company'
+
+    _columns = {
+        'initiating_party_issuer': fields.char(
+            'Initiating Party Issuer', size=35,
+            help="This will be used as the 'Initiating Party Issuer' in the "
+            "PAIN files generated by OpenERP."),
+    }
+
+    def _get_initiating_party_identifier(
+            self, cr, uid, company_id, context=None):
+        '''The code here may be different from one country to another.
+        If you need to add support for an additionnal country, you can
+        contribute your code here or inherit this function in the
+        localization modules for your country'''
+        assert isinstance(company_id, int), 'Only one company ID'
+        company = self.browse(cr, uid, company_id, context=context)
+        company_vat = company.vat
+        party_identifier = False
+        if company_vat and company_vat[0:2].upper() in ['BE']:
+            party_identifier = company_vat[2:].replace(' ', '')
+        return party_identifier
+
+    def _initiating_party_issuer_default(self, cr, uid, context=None):
+        '''If you need to add support for an additionnal country, you can
+        add an entry in the dict "party_issuer_per_country" here
+        or inherit this function in the localization modules for
+        your country'''
+        initiating_party_issuer = ''
+        # If your country require the 'Initiating Party Issuer', you should
+        # contribute the entry for your country in the dict below
+        party_issuer_per_country = {
+            'BE': 'KBO-BCE',  # KBO-BCE = the registry of companies in Belgium
+        }
+        company_id = self._company_default_get(
+            cr, uid, 'res.company', context=context)
+        if company_id:
+            company = self.browse(cr, uid, company_id, context=context)
+            country_code = company.country_id.code
+            initiating_party_issuer = party_issuer_per_country.get(
+                country_code, '')
+        return initiating_party_issuer
+
+    def _initiating_party_issuer_def(self, cr, uid, context=None):
+        return self._initiating_party_issuer_default(
+            cr, uid, context=context)
+
+    _defaults = {
+        'initiating_party_issuer': _initiating_party_issuer_def,
+    }
 
=== added file 'account_banking_pain_base/company_view.xml'
--- account_banking_pain_base/company_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/company_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,24 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="view_company_form" model="ir.ui.view">
+    <field name="name">pain.group.on.res.company.form</field>
+    <field name="model">res.company</field>
+    <field name="inherit_id" ref="base.view_company_form"/>
+    <field name="arch" type="xml">
+        <group name="account_grp" position="after">
+            <group name="pain" string="Payment Initiation">
+                <field name="initiating_party_issuer"/>
+            </group>
+        </group>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== added directory 'account_banking_pain_base/i18n'
=== added file 'account_banking_pain_base/i18n/account_banking_pain_base.pot'
--- account_banking_pain_base/i18n/account_banking_pain_base.pot	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/i18n/account_banking_pain_base.pot	2014-01-13 12:42:46 +0000
@@ -0,0 +1,146 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_banking_pain_base
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 7.0\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2013-12-23 21:26+0000\n"
+"PO-Revision-Date: 2013-12-23 21:26+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_banking_pain_base
+#: field:res.company,initiating_party_issuer:0
+msgid "Initiating Party Issuer"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:122
+#, python-format
+msgid "The generated XML file is not valid against the official XML Schema Definition. The generated XML file and the full error have been written in the server logs. Here is the error, which may give you an idea on the cause of the problem : %s"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: field:payment.line,priority:0
+msgid "Priority"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_payment_line
+msgid "Payment Line"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_payment_mode
+msgid "Payment Mode"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: help:res.company,initiating_party_issuer:0
+msgid "This will be used as the 'Initiating Party Issuer' in the PAIN files generated by OpenERP."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:351
+#, python-format
+msgid "Missing 'Structured Communication Type' on payment line with reference '%s'."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: selection:payment.line,priority:0
+msgid "Normal"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:70
+#, python-format
+msgid "Cannot compute the '%s' of the Payment Line with reference '%s'."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:77
+#, python-format
+msgid "Cannot compute the '%s'."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:81
+#, python-format
+msgid "The type of the field '%s' is %s. It should be a string or unicode."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:47
+#: code:addons/account_banking_pain_base/banking_export_pain.py:69
+#: code:addons/account_banking_pain_base/banking_export_pain.py:76
+#: code:addons/account_banking_pain_base/banking_export_pain.py:86
+#: code:addons/account_banking_pain_base/banking_export_pain.py:121
+#: code:addons/account_banking_pain_base/banking_export_pain.py:350
+#, python-format
+msgid "Error:"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_res_company
+msgid "Companies"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:47
+#, python-format
+msgid "This IBAN is not valid : %s"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:80
+#, python-format
+msgid "Field type error:"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: field:payment.line,struct_communication_type:0
+msgid "Structured Communication Type"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:87
+#, python-format
+msgid "The '%s' is empty or 0. It should have a non-null value."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_banking_export_pain
+msgid "banking.export.pain"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: help:payment.mode,convert_to_ascii:0
+msgid "If active, OpenERP will convert each accented caracter to the corresponding unaccented caracter, so that only ASCII caracters are used in the generated PAIN file."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: help:payment.line,priority:0
+msgid "This field will be used as the 'Instruction Priority' in the generated PAIN file."
+msgstr ""
+
+#. module: account_banking_pain_base
+#: view:res.company:0
+msgid "Payment Initiation"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: selection:payment.line,priority:0
+msgid "High"
+msgstr ""
+
+#. module: account_banking_pain_base
+#: field:payment.mode,convert_to_ascii:0
+msgid "Convert to ASCII"
+msgstr ""
+
 
=== added file 'account_banking_pain_base/i18n/fr.po'
--- account_banking_pain_base/i18n/fr.po	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/i18n/fr.po	2014-01-13 12:42:46 +0000
@@ -0,0 +1,146 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* account_banking_pain_base
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 7.0\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2013-12-23 21:27+0000\n"
+"PO-Revision-Date: 2013-12-23 21:27+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_banking_pain_base
+#: field:res.company,initiating_party_issuer:0
+msgid "Initiating Party Issuer"
+msgstr "Initiating Party Issuer"
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:122
+#, python-format
+msgid "The generated XML file is not valid against the official XML Schema Definition. The generated XML file and the full error have been written in the server logs. Here is the error, which may give you an idea on the cause of the problem : %s"
+msgstr "Le fichier XML généré n'est pas valide par rapport à la Définition du Schéma XML officiel. Le fichier XML généré et le message d'erreur complet ont été écrits dans les logs du serveur. Voici l'erreur, qui vous donnera peut-être une idée sur la cause du problème : %s"
+
+#. module: account_banking_pain_base
+#: field:payment.line,priority:0
+msgid "Priority"
+msgstr "Priorité"
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_payment_line
+msgid "Payment Line"
+msgstr "Ligne de paiement"
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_payment_mode
+msgid "Payment Mode"
+msgstr "Mode de paiement"
+
+#. module: account_banking_pain_base
+#: help:res.company,initiating_party_issuer:0
+msgid "This will be used as the 'Initiating Party Issuer' in the PAIN files generated by OpenERP."
+msgstr "Ce champ sera le 'Initiating Party Issuer' dans les fichiers PAIN générés par OpenERP."
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:351
+#, python-format
+msgid "Missing 'Structured Communication Type' on payment line with reference '%s'."
+msgstr "Le 'Type de communication structuré' n'est pas renseigné sur la ligne de paiement ayant la référence '%s'."
+
+#. module: account_banking_pain_base
+#: selection:payment.line,priority:0
+msgid "Normal"
+msgstr "Normal"
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:70
+#, python-format
+msgid "Cannot compute the '%s' of the Payment Line with reference '%s'."
+msgstr "Impossible de calculer le '%s' de la ligne de paiement ayant la référence '%s'."
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:77
+#, python-format
+msgid "Cannot compute the '%s'."
+msgstr "Impossible de calculer le '%s'."
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:81
+#, python-format
+msgid "The type of the field '%s' is %s. It should be a string or unicode."
+msgstr "Le type du champ '%s' est %s. Il devrait être de type string ou unicode."
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:47
+#: code:addons/account_banking_pain_base/banking_export_pain.py:69
+#: code:addons/account_banking_pain_base/banking_export_pain.py:76
+#: code:addons/account_banking_pain_base/banking_export_pain.py:86
+#: code:addons/account_banking_pain_base/banking_export_pain.py:121
+#: code:addons/account_banking_pain_base/banking_export_pain.py:350
+#, python-format
+msgid "Error:"
+msgstr "Erreur :"
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_res_company
+msgid "Companies"
+msgstr "Sociétés"
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:47
+#, python-format
+msgid "This IBAN is not valid : %s"
+msgstr "Cet IBAN n'est pas valide : %s"
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:80
+#, python-format
+msgid "Field type error:"
+msgstr "Erreur dans le type de champ :"
+
+#. module: account_banking_pain_base
+#: field:payment.line,struct_communication_type:0
+msgid "Structured Communication Type"
+msgstr "Type de communication structurée"
+
+#. module: account_banking_pain_base
+#: code:addons/account_banking_pain_base/banking_export_pain.py:87
+#, python-format
+msgid "The '%s' is empty or 0. It should have a non-null value."
+msgstr "Le '%s' est vide ou égal à 0. Il devrait avoir une valeur non-nulle."
+
+#. module: account_banking_pain_base
+#: model:ir.model,name:account_banking_pain_base.model_banking_export_pain
+msgid "banking.export.pain"
+msgstr "banking.export.pain"
+
+#. module: account_banking_pain_base
+#: help:payment.mode,convert_to_ascii:0
+msgid "If active, OpenERP will convert each accented caracter to the corresponding unaccented caracter, so that only ASCII caracters are used in the generated PAIN file."
+msgstr "Si actif, OpenERP convertira chaque caractère accentué en son équivalent non accentué, de telle façon que seuls des caractères ASCII soient utilisés dans le fichier PAIN généré."
+
+#. module: account_banking_pain_base
+#: help:payment.line,priority:0
+msgid "This field will be used as the 'Instruction Priority' in the generated PAIN file."
+msgstr "Ce champ sera le 'Instruction Priority' dans le fichier PAIN généré."
+
+#. module: account_banking_pain_base
+#: view:res.company:0
+msgid "Payment Initiation"
+msgstr "Payment Initiation"
+
+#. module: account_banking_pain_base
+#: selection:payment.line,priority:0
+msgid "High"
+msgstr "Élevé"
+
+#. module: account_banking_pain_base
+#: field:payment.mode,convert_to_ascii:0
+msgid "Convert to ASCII"
+msgstr "Convertir en ASCII"
+
 
=== added file 'account_banking_pain_base/payment_line.py'
--- account_banking_pain_base/payment_line.py	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/payment_line.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,52 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    PAIN Base module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.osv import orm, fields
+
+
+class payment_line(orm.Model):
+    _inherit = 'payment.line'
+
+    def _get_struct_communication_types(self, cr, uid, context=None):
+        return [('ISO', 'ISO')]
+
+    _columns = {
+        'priority': fields.selection([
+            ('NORM', 'Normal'),
+            ('HIGH', 'High'),
+            ], 'Priority',
+            help="This field will be used as the 'Instruction Priority' in "
+            "the generated PAIN file."),
+        # Update size from 64 to 140, because PAIN allows 140 caracters
+        'communication': fields.char(
+            'Communication', size=140, required=True,
+            help="Used as the message between ordering customer and current "
+            "company. Depicts 'What do you want to say to the recipient "
+            "about this order ?'"),
+        'struct_communication_type': fields.selection(
+            _get_struct_communication_types, 'Structured Communication Type'),
+    }
+
+    _defaults = {
+        'priority': 'NORM',
+        'struct_communication_type': 'ISO',
+    }
 
=== added file 'account_banking_pain_base/payment_line_view.xml'
--- account_banking_pain_base/payment_line_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/payment_line_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="view_payment_line_form" model="ir.ui.view">
+    <field name="name">pain.base.payment.line.form</field>
+    <field name="model">payment.line</field>
+    <field name="inherit_id" ref="account_payment.view_payment_line_form"/>
+    <field name="arch" type="xml">
+        <field name="bank_id" position="after">
+            <field name="priority"/>
+            <newline />
+        </field>
+        <field name="state" position="after">
+            <field name="struct_communication_type" attrs="{'invisible': [('state', '!=', 'structured')], 'required': [('state', '=', 'structured')]}"/>
+        </field>
+    </field>
+</record>
+
+<record id="view_payment_order_form" model="ir.ui.view">
+    <field name="name">pain.base.payment.line.inside.order.form</field>
+    <field name="model">payment.order</field>
+    <field name="inherit_id" ref="account_payment.view_payment_order_form"/>
+    <field name="arch" type="xml">
+        <xpath expr="//field[@name='line_ids']/form//field[@name='bank_id']" position="after">
+            <field name="priority"/>
+            <newline />
+        </xpath>
+        <xpath expr="//field[@name='line_ids']/form//field[@name='state']" position="after">
+            <field name="struct_communication_type" attrs="{'invisible': [('state', '!=', 'structured')], 'required': [('state', '=', 'structured')]}"/>
+        </xpath>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== added file 'account_banking_pain_base/payment_mode.py'
--- account_banking_pain_base/payment_mode.py	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/payment_mode.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,39 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    PAIN Base module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.osv import orm, fields
+
+
+class payment_mode(orm.Model):
+    _inherit = 'payment.mode'
+
+    _columns = {
+        'convert_to_ascii': fields.boolean(
+            'Convert to ASCII',
+            help="If active, OpenERP will convert each accented caracter to "
+            "the corresponding unaccented caracter, so that only ASCII "
+            "caracters are used in the generated PAIN file."),
+    }
+
+    _defaults = {
+        'convert_to_ascii': True,
+    }
 
=== added file 'account_banking_pain_base/payment_mode_view.xml'
--- account_banking_pain_base/payment_mode_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_pain_base/payment_mode_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="view_payment_mode_form_inherit" model="ir.ui.view">
+    <field name="name">add.convert_to_ascii.in.payment.mode.form</field>
+    <field name="model">payment.mode</field>
+    <field name="inherit_id" ref="account_banking_payment_export.view_payment_mode_form_inherit"/>
+    <field name="arch" type="xml">
+        <field name="type" position="after">
+            <field name="convert_to_ascii"/>
+        </field>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== modified file 'account_banking_payment/__openerp__.py'
--- account_banking_payment/__openerp__.py	2013-08-13 09:18:15 +0000
+++ account_banking_payment/__openerp__.py	2014-01-13 12:42:46 +0000
@@ -39,6 +39,7 @@
         'view/banking_transaction_wizard.xml',
         'view/payment_mode.xml',
         'view/payment_mode_type.xml',
+        'view/payment_order_create_view.xml',
         'workflow/account_payment.xml',
     ],
     'description': '''
 
=== modified file 'account_banking_payment/model/__init__.py'
--- account_banking_payment/model/__init__.py	2013-08-13 09:18:15 +0000
+++ account_banking_payment/model/__init__.py	2014-01-13 12:42:46 +0000
@@ -1,7 +1,7 @@
 import account_payment
 import payment_line
+import payment_mode_type
 import payment_mode
-import payment_mode_type
 import payment_order_create
 import banking_import_transaction
 import banking_transaction_wizard
 
=== modified file 'account_banking_payment/model/account_payment.py'
--- account_banking_payment/model/account_payment.py	2013-10-14 11:18:42 +0000
+++ account_banking_payment/model/account_payment.py	2014-01-13 12:42:46 +0000
@@ -107,6 +107,7 @@
         'payment_order_type': fields.selection(
             [('payment', 'Payment'),('debit', 'Direct debit')],
             'Payment order type', required=True,
+            readonly=True, states={'draft': [('readonly', False)]},
             ),
         'date_sent': fields.date('Send date', readonly=True),
     }
 
=== modified file 'account_banking_payment/model/payment_mode.py'
--- account_banking_payment/model/payment_mode.py	2013-08-13 09:18:15 +0000
+++ account_banking_payment/model/payment_mode.py	2014-01-13 12:42:46 +0000
@@ -34,10 +34,9 @@
             'account.account', 'Transfer account',
             domain=[('type', '=', 'other'),
                     ('reconcile', '=', True)],
-            help=('Pay off lines in sent orders with a '
-                  'move on this account. For debit type modes only. '
-                  'You can only select accounts of type regular that '
-                  'are marked for reconciliation'),
+            help=('Pay off lines in sent orders with a move on this '
+                  'account. You can only select accounts of type regular '
+                  'that are marked for reconciliation'),
             ),
         'transfer_journal_id': fields.many2one(
             'account.journal', 'Transfer journal',
@@ -50,4 +49,8 @@
             help=('Limit selected invoices to invoices with these payment '
                   'terms')
             ),
+        'payment_order_type': fields.related(
+            'type', 'payment_order_type', readonly=True, type='selection',
+            selection=[('payment', 'Payment'), ('debit', 'Direct debit')],
+            string="Payment Order Type"),
         }
 
=== modified file 'account_banking_payment/view/payment_mode.xml'
--- account_banking_payment/view/payment_mode.xml	2013-08-13 09:18:15 +0000
+++ account_banking_payment/view/payment_mode.xml	2014-01-13 12:42:46 +0000
@@ -11,6 +11,7 @@
             <field name="inherit_id" ref="account_banking_payment_export.view_payment_mode_form_inherit"/>
             <field name="arch" type="xml">
                 <field name="type" position="after">
+                    <field name="payment_order_type"/>
                     <group colspan="4" col="4">
                         <group colspan="2">
                             <separator colspan="2"
 
=== added file 'account_banking_payment/view/payment_order_create_view.xml'
--- account_banking_payment/view/payment_order_create_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_payment/view/payment_order_create_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="view_create_payment_order_lines" model="ir.ui.view">
+    <field name="name">add.context.to.display.maturity.date</field>
+    <field name="model">payment.order.create</field>
+    <field name="inherit_id" ref="account_payment.view_create_payment_order_lines"/>
+    <field name="arch" type="xml">
+        <field name="entries" position="attributes">
+            <attribute name="context">{'journal_type': 'sale'}</attribute>
+            <attribute name="nolabel">1</attribute>
+        </field>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== modified file 'account_banking_sepa_credit_transfer/__openerp__.py'
--- account_banking_sepa_credit_transfer/__openerp__.py	2013-11-13 08:19:50 +0000
+++ account_banking_sepa_credit_transfer/__openerp__.py	2014-01-13 12:42:46 +0000
@@ -26,7 +26,7 @@
     'author': 'Akretion',
     'website': 'http://www.akretion.com',
     'category': 'Banking addons',
-    'depends': ['account_banking_payment_export'],
+    'depends': ['account_banking_pain_base'],
     'external_dependencies': {
         'python': ['unidecode', 'lxml'],
         },
 
=== modified file 'account_banking_sepa_credit_transfer/account_banking_sepa.py'
--- account_banking_sepa_credit_transfer/account_banking_sepa.py	2013-11-12 21:38:21 +0000
+++ account_banking_sepa_credit_transfer/account_banking_sepa.py	2014-01-13 12:42:46 +0000
@@ -48,22 +48,31 @@
             'banking_export_sepa_id', 'account_order_id',
             'Payment Orders',
             readonly=True),
-        'prefered_exec_date': fields.date(
-            'Prefered Execution Date', readonly=True),
         'nb_transactions': fields.integer(
             'Number of Transactions', readonly=True),
-        'total_amount': fields.float('Total Amount',
-            digits_compute=dp.get_precision('Account'), readonly=True),
+        'total_amount': fields.float(
+            'Total Amount', digits_compute=dp.get_precision('Account'),
+            readonly=True),
         'batch_booking': fields.boolean(
             'Batch Booking', readonly=True,
-            help="If true, the bank statement will display only one debit line for all the wire transfers of the SEPA XML file ; if false, the bank statement will display one debit line per wire transfer of the SEPA XML file."),
+            help="If true, the bank statement will display only one debit "
+            "line for all the wire transfers of the SEPA XML file ; "
+            "if false, the bank statement will display one debit line "
+            "per wire transfer of the SEPA XML file."),
         'charge_bearer': fields.selection([
             ('SLEV', 'Following Service Level'),
             ('SHAR', 'Shared'),
             ('CRED', 'Borne by Creditor'),
             ('DEBT', 'Borne by Debtor'),
             ], 'Charge Bearer', readonly=True,
-            help='Following service level : transaction charges are to be applied following the rules agreed in the service level and/or scheme (SEPA Core messages must use this). Shared : transaction charges on the creditor side are to be borne by the creditor, transaction charges on the debtor side are to be borne by the debtor. Borne by creditor : all transaction charges are to be borne by the creditor. Borne by debtor : all transaction charges are to be borne by the debtor.'),
+            help="Following service level : transaction charges are to be "
+            "applied following the rules agreed in the service level and/or "
+            "scheme (SEPA Core messages must use this). Shared : "
+            "transaction charges on the creditor side are to be borne by "
+            "the creditor, transaction charges on the debtor side are to "
+            "be borne by the debtor. Borne by creditor : all transaction "
+            "charges are to be borne by the creditor. Borne by debtor : "
+            "all transaction charges are to be borne by the debtor."),
         'create_date': fields.datetime('Generation Date', readonly=True),
         'file': fields.binary('SEPA XML File', readonly=True),
         'filename': fields.function(
 
=== modified file 'account_banking_sepa_credit_transfer/account_banking_sepa_view.xml'
--- account_banking_sepa_credit_transfer/account_banking_sepa_view.xml	2013-11-07 11:50:36 +0000
+++ account_banking_sepa_credit_transfer/account_banking_sepa_view.xml	2014-01-13 12:42:46 +0000
@@ -16,7 +16,6 @@
                 <page string="General Information">
                     <field name="total_amount" />
                     <field name="nb_transactions" />
-                    <field name="prefered_exec_date" />
                     <field name="batch_booking" />
                     <field name="charge_bearer"/>
                     <field name="create_date" />
@@ -47,7 +46,6 @@
     <field name="arch" type="xml">
         <tree string="SEPA Credit Transfer">
             <field name="filename"/>
-            <field name="prefered_exec_date"/>
             <field name="create_date"/>
             <field name="nb_transactions"/>
         </tree>
 
=== modified file 'account_banking_sepa_credit_transfer/i18n/account_banking_sepa_credit_transfer.pot'
--- account_banking_sepa_credit_transfer/i18n/account_banking_sepa_credit_transfer.pot	2013-11-13 09:17:33 +0000
+++ account_banking_sepa_credit_transfer/i18n/account_banking_sepa_credit_transfer.pot	2014-01-13 12:42:46 +0000
@@ -6,8 +6,8 @@
 msgstr ""
 "Project-Id-Version: OpenERP Server 7.0\n"
 "Report-Msgid-Bugs-To: \n"
-"POT-Creation-Date: 2013-11-13 09:13+0000\n"
-"PO-Revision-Date: 2013-11-13 09:13+0000\n"
+"POT-Creation-Date: 2013-12-23 22:49+0000\n"
+"PO-Revision-Date: 2013-12-23 22:49+0000\n"
 "Last-Translator: <>\n"
 "Language-Team: \n"
 "MIME-Version: 1.0\n"
@@ -16,12 +16,6 @@
 "Plural-Forms: \n"
 
 #. module: account_banking_sepa_credit_transfer
-#: field:banking.export.sepa,prefered_exec_date:0
-#: field:banking.export.sepa.wizard,prefered_exec_date:0
-msgid "Prefered Execution Date"
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: selection:banking.export.sepa.wizard,state:0
 msgid "Create"
 msgstr ""
@@ -55,12 +49,6 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:117
-#, python-format
-msgid "Cannot compute the '%s' of the Payment Line with Invoice Reference '%s'."
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: selection:banking.export.sepa,charge_bearer:0
 #: selection:banking.export.sepa.wizard,charge_bearer:0
 msgid "Shared"
@@ -73,8 +61,13 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
+#: selection:banking.export.sepa,state:0
+msgid "Sent"
+msgstr ""
+
+#. module: account_banking_sepa_credit_transfer
 #: model:ir.model,name:account_banking_sepa_credit_transfer.model_banking_export_sepa_wizard
-msgid "Export SEPA Credit Transfer XML file"
+msgid "Export SEPA Credit Transfer File"
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
@@ -105,23 +98,6 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:122
-#, python-format
-msgid "Cannot compute the '%s'."
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:126
-#, python-format
-msgid "The type of the field '%s' is %s. It should be a string or unicode."
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
-#: selection:banking.export.sepa,state:0
-msgid "Sent"
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: view:banking.export.sepa.wizard:0
 msgid "Validate"
 msgstr ""
@@ -132,25 +108,14 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:169
-#, python-format
-msgid "The generated XML file is not valid against the official XML Schema Definition. The generated XML file and the full error have been written in the server logs. Here is the error, which may give you an idea on the cause of the problem : %s"
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: selection:banking.export.sepa,charge_bearer:0
 #: selection:banking.export.sepa.wizard,charge_bearer:0
 msgid "Borne by Debtor"
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:90
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:116
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:121
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:130
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:168
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:206
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:350
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:128
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:245
 #, python-format
 msgid "Error:"
 msgstr ""
@@ -173,18 +138,12 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:125
-#, python-format
-msgid "Field type error:"
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: model:ir.model,name:account_banking_sepa_credit_transfer.model_banking_export_sepa
 msgid "SEPA export"
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:351
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:246
 #, python-format
 msgid "Missing Bank Account on invoice '%s' (payment order line reference '%s')."
 msgstr ""
@@ -196,29 +155,17 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:131
-#, python-format
-msgid "The '%s' is empty or 0. It should have a non-null value."
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: help:banking.export.sepa,charge_bearer:0
 msgid "Following service level : transaction charges are to be applied following the rules agreed in the service level and/or scheme (SEPA Core messages must use this). Shared : transaction charges on the creditor side are to be borne by the creditor, transaction charges on the debtor side are to be borne by the debtor. Borne by creditor : all transaction charges are to be borne by the creditor. Borne by debtor : all transaction charges are to be borne by the debtor."
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:207
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:129
 #, python-format
 msgid "Payment Type Code '%s' is not supported. The only Payment Type Codes supported for SEPA Credit Transfers are 'pain.001.001.02', 'pain.001.001.03', 'pain.001.001.04' and 'pain.001.001.05'."
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:90
-#, python-format
-msgid "This IBAN is not valid : %s"
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: view:banking.export.sepa:0
 #: field:banking.export.sepa,payment_order_ids:0
 #: field:banking.export.sepa.wizard,payment_order_ids:0
@@ -244,11 +191,6 @@
 msgstr ""
 
 #. module: account_banking_sepa_credit_transfer
-#: help:banking.export.sepa.wizard,prefered_exec_date:0
-msgid "This is the date on which the file should be processed by the bank. Please keep in mind that banks only execute on working days and typically use a delay of two days between execution date and effective transfer date."
-msgstr ""
-
-#. module: account_banking_sepa_credit_transfer
 #: field:banking.export.sepa.wizard,file:0
 msgid "File"
 msgstr ""
 
=== modified file 'account_banking_sepa_credit_transfer/i18n/fr.po'
--- account_banking_sepa_credit_transfer/i18n/fr.po	2013-12-03 06:20:09 +0000
+++ account_banking_sepa_credit_transfer/i18n/fr.po	2014-01-13 12:42:46 +0000
@@ -6,21 +6,14 @@
 msgstr ""
 "Project-Id-Version: OpenERP Server 7.0\n"
 "Report-Msgid-Bugs-To: \n"
-"POT-Creation-Date: 2013-11-13 09:13+0000\n"
-"PO-Revision-Date: 2013-12-02 16:36+0000\n"
-"Last-Translator: Alexis de Lattre <[e-mail]>\n"
+"POT-Creation-Date: 2013-12-23 22:52+0000\n"
+"PO-Revision-Date: 2013-12-23 22:52+0000\n"
+"Last-Translator: <>\n"
 "Language-Team: \n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
-"Content-Transfer-Encoding: 8bit\n"
-"X-Launchpad-Export-Date: 2013-12-03 06:20+0000\n"
-"X-Generator: Launchpad (build 16856)\n"
-
-#. module: account_banking_sepa_credit_transfer
-#: field:banking.export.sepa,prefered_exec_date:0
-#: field:banking.export.sepa.wizard,prefered_exec_date:0
-msgid "Prefered Execution Date"
-msgstr "Date d'exécution demandée"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
 
 #. module: account_banking_sepa_credit_transfer
 #: selection:banking.export.sepa.wizard,state:0
@@ -52,31 +45,8 @@
 
 #. module: account_banking_sepa_credit_transfer
 #: help:banking.export.sepa.wizard,charge_bearer:0
-msgid ""
-"Following service level : transaction charges are to be applied following "
-"the rules agreed in the service level and/or scheme (SEPA Core messages must "
-"use this). Shared : transaction charges on the debtor side are to be borne "
-"by the debtor, transaction charges on the creditor side are to be borne by "
-"the creditor. Borne by creditor : all transaction charges are to be borne by "
-"the creditor. Borne by debtor : all transaction charges are to be borne by "
-"the debtor."
-msgstr ""
-"Suivant le niveau de service : la répartition des frais bancaires suit les "
-"règles pré-établies dans le schema ou dans le contrat avec la banque (les "
-"messages SEPA Core doivent utiliser ce paramètre). Partagés : les frais "
-"bancaires côté débiteur sont à la charge du débiteur, les frais bancaires "
-"côté créancier sont à la charge du créancier. Supportés par le créancier : "
-"tous les frais bancaires sont à la charge du créancier. Supportés par le "
-"débiteur : tous les frais bancaires sont à la charge du débiteur."
-
-#. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:117
-#, python-format
-msgid ""
-"Cannot compute the '%s' of the Payment Line with Invoice Reference '%s'."
-msgstr ""
-"Impossible de générer le '%s' de la ligne de paiement ayant la référence de "
-"facture '%s'."
+msgid "Following service level : transaction charges are to be applied following the rules agreed in the service level and/or scheme (SEPA Core messages must use this). Shared : transaction charges on the debtor side are to be borne by the debtor, transaction charges on the creditor side are to be borne by the creditor. Borne by creditor : all transaction charges are to be borne by the creditor. Borne by debtor : all transaction charges are to be borne by the debtor."
+msgstr "Suivant le niveau de service : la répartition des frais bancaires suit les règles pré-établies dans le schema ou dans le contrat avec la banque (les messages SEPA Core doivent utiliser ce paramètre). Partagés : les frais bancaires côté débiteur sont à la charge du débiteur, les frais bancaires côté créancier sont à la charge du créancier. Supportés par le créancier : tous les frais bancaires sont à la charge du créancier. Supportés par le débiteur : tous les frais bancaires sont à la charge du débiteur."
 
 #. module: account_banking_sepa_credit_transfer
 #: selection:banking.export.sepa,charge_bearer:0
@@ -91,9 +61,14 @@
 msgstr "Débit groupé"
 
 #. module: account_banking_sepa_credit_transfer
+#: selection:banking.export.sepa,state:0
+msgid "Sent"
+msgstr "Envoyé"
+
+#. module: account_banking_sepa_credit_transfer
 #: model:ir.model,name:account_banking_sepa_credit_transfer.model_banking_export_sepa_wizard
-msgid "Export SEPA Credit Transfer XML file"
-msgstr "Exporte the fichier de virement SEPA XML"
+msgid "Export SEPA Credit Transfer File"
+msgstr "Exporte le fichier de virement SEPA"
 
 #. module: account_banking_sepa_credit_transfer
 #: view:banking.export.sepa:0
@@ -123,24 +98,6 @@
 msgstr "Supportés par le destinataire"
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:122
-#, python-format
-msgid "Cannot compute the '%s'."
-msgstr "Impossible de générer le '%s'."
-
-#. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:126
-#, python-format
-msgid "The type of the field '%s' is %s. It should be a string or unicode."
-msgstr ""
-"Le champ '%s' est de type %s. Le type devrait être string ou unicode."
-
-#. module: account_banking_sepa_credit_transfer
-#: selection:banking.export.sepa,state:0
-msgid "Sent"
-msgstr "Envoyé"
-
-#. module: account_banking_sepa_credit_transfer
 #: view:banking.export.sepa.wizard:0
 msgid "Validate"
 msgstr "Valider"
@@ -151,33 +108,14 @@
 msgstr "Générer"
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:169
-#, python-format
-msgid ""
-"The generated XML file is not valid against the official XML Schema "
-"Definition. The generated XML file and the full error have been written in "
-"the server logs. Here is the error, which may give you an idea on the cause "
-"of the problem : %s"
-msgstr ""
-"Le fichier XML généré n'est pas valide par rapport à la Définition du Schéma "
-"XML officiel. Le fichier XML généré et le message d'erreur complet ont été "
-"écrits dans les logs du serveur. Voici l'erreur, qui vous donnera peut-être "
-"une idée sur la cause du problème : %s"
-
-#. module: account_banking_sepa_credit_transfer
 #: selection:banking.export.sepa,charge_bearer:0
 #: selection:banking.export.sepa.wizard,charge_bearer:0
 msgid "Borne by Debtor"
 msgstr "Supportés par l'émetteur"
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:90
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:116
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:121
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:130
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:168
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:206
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:350
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:128
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:245
 #, python-format
 msgid "Error:"
 msgstr "Erreur :"
@@ -200,24 +138,15 @@
 msgstr "Génération du fichier SEPA"
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:125
-#, python-format
-msgid "Field type error:"
-msgstr "Erreur dans le type de champ:"
-
-#. module: account_banking_sepa_credit_transfer
 #: model:ir.model,name:account_banking_sepa_credit_transfer.model_banking_export_sepa
 msgid "SEPA export"
 msgstr "Export SEPA"
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:351
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:246
 #, python-format
-msgid ""
-"Missing Bank Account on invoice '%s' (payment order line reference '%s')."
-msgstr ""
-"Compte bancaire manquant sur la facture '%s' (référence de la ligne de "
-"paiement : '%s')."
+msgid "Missing Bank Account on invoice '%s' (payment order line reference '%s')."
+msgstr "Compte bancaire manquant sur la facture '%s' (référence de la ligne de paiement : '%s')."
 
 #. module: account_banking_sepa_credit_transfer
 #: field:banking.export.sepa,file:0
@@ -226,47 +155,15 @@
 msgstr "Fichier SEPA XML"
 
 #. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:131
-#, python-format
-msgid "The '%s' is empty or 0. It should have a non-null value."
-msgstr "Le '%s' est vide ou égal à 0. La valeur devrait être non nulle."
-
-#. module: account_banking_sepa_credit_transfer
 #: help:banking.export.sepa,charge_bearer:0
-msgid ""
-"Following service level : transaction charges are to be applied following "
-"the rules agreed in the service level and/or scheme (SEPA Core messages must "
-"use this). Shared : transaction charges on the creditor side are to be borne "
-"by the creditor, transaction charges on the debtor side are to be borne by "
-"the debtor. Borne by creditor : all transaction charges are to be borne by "
-"the creditor. Borne by debtor : all transaction charges are to be borne by "
-"the debtor."
-msgstr ""
-"Suivant le niveau de service : la répartition des frais bancaires suit les "
-"règles pré-établies dans le schema ou dans le contrat avec la banque (les "
-"messages SEPA Core doivent utiliser ce paramètre). Partagés : les frais "
-"bancaires côté débiteur sont à la charge du débiteur, les frais bancaires "
-"côté créancier sont à la charge du créancier. Supportés par le créancier : "
-"tous les frais bancaires sont à la charge du créancier. Supportés par le "
-"débiteur : tous les frais bancaires sont à la charge du débiteur."
-
-#. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:207
-#, python-format
-msgid ""
-"Payment Type Code '%s' is not supported. The only Payment Type Codes "
-"supported for SEPA Credit Transfers are 'pain.001.001.02', "
-"'pain.001.001.03', 'pain.001.001.04' and 'pain.001.001.05'."
-msgstr ""
-"Le code du Type de paiement '%s' n'est pas supporté. Les seuls codes de Type "
-"de paiement supportés pour les virements SEPA sont 'pain.001.001.02', "
-"'pain.001.001.03', 'pain.001.001.04' et 'pain.001.001.05'."
-
-#. module: account_banking_sepa_credit_transfer
-#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:90
-#, python-format
-msgid "This IBAN is not valid : %s"
-msgstr "Cet IBAN n'est pas valide : %s"
+msgid "Following service level : transaction charges are to be applied following the rules agreed in the service level and/or scheme (SEPA Core messages must use this). Shared : transaction charges on the creditor side are to be borne by the creditor, transaction charges on the debtor side are to be borne by the debtor. Borne by creditor : all transaction charges are to be borne by the creditor. Borne by debtor : all transaction charges are to be borne by the debtor."
+msgstr "Suivant le niveau de service : la répartition des frais bancaires suit les règles pré-établies dans le schema ou dans le contrat avec la banque (les messages SEPA Core doivent utiliser ce paramètre). Partagés : les frais bancaires côté débiteur sont à la charge du débiteur, les frais bancaires côté créancier sont à la charge du créancier. Supportés par le créancier : tous les frais bancaires sont à la charge du créancier. Supportés par le débiteur : tous les frais bancaires sont à la charge du débiteur."
+
+#. module: account_banking_sepa_credit_transfer
+#: code:addons/account_banking_sepa_credit_transfer/wizard/export_sepa.py:129
+#, python-format
+msgid "Payment Type Code '%s' is not supported. The only Payment Type Codes supported for SEPA Credit Transfers are 'pain.001.001.02', 'pain.001.001.03', 'pain.001.001.04' and 'pain.001.001.05'."
+msgstr "Le code du Type de paiement '%s' n'est pas supporté. Les seuls codes de Type de paiement supportés pour les virements SEPA sont 'pain.001.001.02', 'pain.001.001.03', 'pain.001.001.04' et 'pain.001.001.05'."
 
 #. module: account_banking_sepa_credit_transfer
 #: view:banking.export.sepa:0
@@ -290,26 +187,8 @@
 #. module: account_banking_sepa_credit_transfer
 #: help:banking.export.sepa,batch_booking:0
 #: help:banking.export.sepa.wizard,batch_booking:0
-msgid ""
-"If true, the bank statement will display only one debit line for all the "
-"wire transfers of the SEPA XML file ; if false, the bank statement will "
-"display one debit line per wire transfer of the SEPA XML file."
-msgstr ""
-"Si coché, le relevé de compte ne comportera qu'une ligne de débit pour tous "
-"les virements du fichier SEPA XML ; si non coché, le relevé de compte "
-"comportera une ligne de débit pour chaque virement du fichier SEPA XML."
-
-#. module: account_banking_sepa_credit_transfer
-#: help:banking.export.sepa.wizard,prefered_exec_date:0
-msgid ""
-"This is the date on which the file should be processed by the bank. Please "
-"keep in mind that banks only execute on working days and typically use a "
-"delay of two days between execution date and effective transfer date."
-msgstr ""
-"C'est la date à laquelle le fichier doit être traité par la banque. Gardez "
-"en tête que les banques réalisent des traitements seulement les jours ouvrés "
-"et ont habituellement un délai de 2 jours entre la date de traitement et la "
-"date du transfert effectif."
+msgid "If true, the bank statement will display only one debit line for all the wire transfers of the SEPA XML file ; if false, the bank statement will display one debit line per wire transfer of the SEPA XML file."
+msgstr "Si coché, le relevé de compte ne comportera qu'une ligne de débit pour tous les virements du fichier SEPA XML ; si non coché, le relevé de compte comportera une ligne de débit pour chaque virement du fichier SEPA XML."
 
 #. module: account_banking_sepa_credit_transfer
 #: field:banking.export.sepa.wizard,file:0
@@ -326,88 +205,3 @@
 msgid "Generation Date"
 msgstr "Date de génération"
 
-#~ msgid "SEPA XML file"
-#~ msgstr "Fichier SEPA XML"
-
-#~ msgid "Payment order"
-#~ msgstr "Ordre de paiement"
-
-#~ msgid ""
-#~ "This is the message identification of the entire SEPA XML file. 35 "
-#~ "characters max."
-#~ msgstr ""
-#~ "Ceci est le libellé d'identification du fichier SEPA XML. 35 caractères "
-#~ "maximum."
-
-#~ msgid "Prefered execution date"
-#~ msgstr "Date d'exécution demandée"
-
-#~ msgid "Generation date"
-#~ msgstr "Date de génération"
-
-#~ msgid "Message identification"
-#~ msgstr "Libellé d'identification"
-
-#~ msgid "Total amount"
-#~ msgstr "Montant total"
-
-#~ msgid ""
-#~ "Shared : transaction charges on the sender side are to be borne by the "
-#~ "debtor, transaction charges on the receiver side are to be borne by the "
-#~ "creditor (most transfers use this). Borne by creditor : all transaction "
-#~ "charges are to be borne by the creditor. Borne by debtor : all transaction "
-#~ "charges are to be borne by the debtor. Following service level : transaction "
-#~ "charges are to be applied following the rules agreed in the service level "
-#~ "and/or scheme."
-#~ msgstr ""
-#~ "Partagés : les frais bancaires côté émetteur sont à la charge de l'émetteur "
-#~ "et les frais bancaires côté destinataire sont à la charge du destinataire "
-#~ "(la plupart des virements utilisent cette répartition). Supportés par le "
-#~ "destinataire : tous les frais bancaires sont à la charge du destinataire. "
-#~ "Supportés par l'émetteur : tous les frais bancaires sont à la charge de "
-#~ "l'émetteur. Suivant le niveau de service : la répartition des frais "
-#~ "bancaires suit les règles pré-établies dans le contrat avec la banque."
-
-#~ msgid "Borne by creditor"
-#~ msgstr "Supportés par le destinataire"
-
-#~ msgid "Payment orders"
-#~ msgstr "Ordres de paiement"
-
-#~ msgid "SEPA XML file generation"
-#~ msgstr "Génération du fichier SEPA XML"
-
-#~ msgid "Reference for further communication"
-#~ msgstr "Référence pour communication ultérieure"
-
-#~ msgid "Processing details"
-#~ msgstr "Paramètres"
-
-#~ msgid "Borne by debtor"
-#~ msgstr "Supportés par l'émetteur"
-
-#~ msgid "Number of transactions"
-#~ msgstr "Nombre de transactions"
-
-#~ msgid "Following service level"
-#~ msgstr "Suivant le niveau de service"
-
-#~ msgid "Charge bearer"
-#~ msgstr "Répartition des frais"
-
-#, python-format
-#~ msgid ""
-#~ "Payment Type Code '%s' is not supported. The only Payment Type Codes "
-#~ "supported for SEPA Credit Transfers are 'pain.001.001.02', 'pain.001.001.03' "
-#~ "and 'pain.001.001.04'."
-#~ msgstr ""
-#~ "Le code '%s' pour le Type de Paiment n'est pas supporté. Les seuls codes de "
-#~ "Types de Paiement supportés pour les virements SEPA sont 'pain.001.001.02', "
-#~ "'pain.001.001.03' et 'pain.001.001.04'."
-
-#, python-format
-#~ msgid "Error :"
-#~ msgstr "Erreur :"
-
-#~ msgid "Batch booking"
-#~ msgstr "Débit groupé"
 
=== modified file 'account_banking_sepa_credit_transfer/wizard/export_sepa.py'
--- account_banking_sepa_credit_transfer/wizard/export_sepa.py	2013-11-12 21:38:21 +0000
+++ account_banking_sepa_credit_transfer/wizard/export_sepa.py	2014-01-13 12:42:46 +0000
@@ -22,20 +22,14 @@
 
 
 from openerp.osv import orm, fields
-import base64
-from datetime import datetime
 from openerp.tools.translate import _
-from openerp.tools.safe_eval import safe_eval
-from openerp import tools, netsvc
+from openerp import netsvc
 from lxml import etree
-import logging
-from unidecode import unidecode
-
-_logger = logging.getLogger(__name__)
 
 
 class banking_export_sepa_wizard(orm.TransientModel):
     _name = 'banking.export.sepa.wizard'
+    _inherit = ['banking.export.pain']
     _description = 'Export SEPA Credit Transfer File'
 
     _columns = {
@@ -45,17 +39,24 @@
             ], 'State', readonly=True),
         'batch_booking': fields.boolean(
             'Batch Booking',
-            help="If true, the bank statement will display only one debit line for all the wire transfers of the SEPA XML file ; if false, the bank statement will display one debit line per wire transfer of the SEPA XML file."),
-        'prefered_exec_date': fields.date(
-            'Prefered Execution Date',
-            help='This is the date on which the file should be processed by the bank. Please keep in mind that banks only execute on working days and typically use a delay of two days between execution date and effective transfer date.'),
+            help="If true, the bank statement will display only one debit "
+            "line for all the wire transfers of the SEPA XML file ; if "
+            "false, the bank statement will display one debit line per wire "
+            "transfer of the SEPA XML file."),
         'charge_bearer': fields.selection([
             ('SLEV', 'Following Service Level'),
             ('SHAR', 'Shared'),
             ('CRED', 'Borne by Creditor'),
             ('DEBT', 'Borne by Debtor'),
             ], 'Charge Bearer', required=True,
-            help='Following service level : transaction charges are to be applied following the rules agreed in the service level and/or scheme (SEPA Core messages must use this). Shared : transaction charges on the debtor side are to be borne by the debtor, transaction charges on the creditor side are to be borne by the creditor. Borne by creditor : all transaction charges are to be borne by the creditor. Borne by debtor : all transaction charges are to be borne by the debtor.'),
+            help="Following service level : transaction charges are to be "
+            "applied following the rules agreed in the service level and/or "
+            "scheme (SEPA Core messages must use this). Shared : transaction "
+            "charges on the debtor side are to be borne by the debtor, "
+            "transaction charges on the creditor side are to be borne by "
+            "the creditor. Borne by creditor : all transaction charges are "
+            "to be borne by the creditor. Borne by debtor : all transaction "
+            "charges are to be borne by the debtor."),
         'nb_transactions': fields.related(
             'file_id', 'nb_transactions', type='integer',
             string='Number of Transactions', readonly=True),
@@ -79,16 +80,6 @@
         'state': 'create',
         }
 
-    def _validate_iban(self, cr, uid, iban, context=None):
-        '''if IBAN is valid, returns IBAN
-        if IBAN is NOT valid, raises an error message'''
-        partner_bank_obj = self.pool.get('res.partner.bank')
-        if partner_bank_obj.is_iban_valid(cr, uid, iban, context=context):
-            return iban.replace(' ', '')
-        else:
-            raise orm.except_orm(
-                _('Error:'), _("This IBAN is not valid : %s") % iban)
-
     def create(self, cr, uid, vals, context=None):
         payment_order_ids = context.get('active_ids', [])
         vals.update({
@@ -97,85 +88,16 @@
         return super(banking_export_sepa_wizard, self).create(
             cr, uid, vals, context=context)
 
-    def _prepare_field(
-            self, cr, uid, field_name, field_value, eval_ctx, max_size=0,
-            context=None):
-        '''This function is designed to be inherited !'''
-        assert isinstance(eval_ctx, dict), 'eval_ctx must contain a dict'
-        try:
-            # SEPA uses XML ; XML = UTF-8 ; UTF-8 = support for all characters
-            # But we are dealing with banks...
-            # and many banks don't want non-ASCCI characters !
-            # cf section 1.4 "Character set" of the SEPA Credit Transfer
-            # Scheme Customer-to-bank guidelines
-            value = unidecode(safe_eval(field_value, eval_ctx))
-        except:
-            line = eval_ctx.get('line')
-            if line:
-                raise orm.except_orm(
-                    _('Error:'),
-                    _("Cannot compute the '%s' of the Payment Line with Invoice Reference '%s'.")
-                    % (field_name, self.pool['account.invoice'].name_get(cr, uid, [line.ml_inv_ref.id], context=context)[0][1]))
-            else:
-                raise orm.except_orm(
-                    _('Error:'),
-                    _("Cannot compute the '%s'.") % field_name)
-        if not isinstance(value, (str, unicode)):
-            raise orm.except_orm(
-                _('Field type error:'),
-                _("The type of the field '%s' is %s. It should be a string or unicode.")
-                % (field_name, type(value)))
-        if not value:
-            raise orm.except_orm(
-                _('Error:'),
-                _("The '%s' is empty or 0. It should have a non-null value.")
-                % field_name)
-        if max_size and len(value) > max_size:
-            value = value[0:max_size]
-        return value
-
-    def _prepare_export_sepa(
-            self, cr, uid, sepa_export, total_amount, transactions_count,
-            xml_string, context=None):
-        return {
-            'batch_booking': sepa_export.batch_booking,
-            'charge_bearer': sepa_export.charge_bearer,
-            'prefered_exec_date': sepa_export.prefered_exec_date,
-            'total_amount': total_amount,
-            'nb_transactions': transactions_count,
-            'file': base64.encodestring(xml_string),
-            'payment_order_ids': [
-                (6, 0, [x.id for x in sepa_export.payment_order_ids])
-            ],
-        }
-
-    def _validate_xml(self, cr, uid, xml_string, pain_flavor):
-        xsd_etree_obj = etree.parse(
-            tools.file_open(
-                'account_banking_sepa_credit_transfer/data/%s.xsd'
-                % pain_flavor))
-        official_pain_schema = etree.XMLSchema(xsd_etree_obj)
-
-        try:
-            root_to_validate = etree.fromstring(xml_string)
-            official_pain_schema.assertValid(root_to_validate)
-        except Exception, e:
-            _logger.warning(
-                "The XML file is invalid against the XML Schema Definition")
-            _logger.warning(xml_string)
-            _logger.warning(e)
-            raise orm.except_orm(
-                _('Error:'),
-                _('The generated XML file is not valid against the official XML Schema Definition. The generated XML file and the full error have been written in the server logs. Here is the error, which may give you an idea on the cause of the problem : %s')
-                % str(e))
-        return True
-
     def create_sepa(self, cr, uid, ids, context=None):
         '''
         Creates the SEPA Credit Transfer file. That's the important code !
         '''
+        if context is None:
+            context = {}
         sepa_export = self.browse(cr, uid, ids[0], context=context)
         pain_flavor = sepa_export.payment_order_ids[0].mode.type.code
+        convert_to_ascii = \
+            sepa_export.payment_order_ids[0].mode.convert_to_ascii
         if pain_flavor == 'pain.001.001.02':
             bic_xml_tag = 'BIC'
             name_maxsize = 70
@@ -204,124 +126,98 @@
         else:
             raise orm.except_orm(
                 _('Error:'),
-                _("Payment Type Code '%s' is not supported. The only Payment Type Codes supported for SEPA Credit Transfers are 'pain.001.001.02', 'pain.001.001.03', 'pain.001.001.04' and 'pain.001.001.05'.")
+                _("Payment Type Code '%s' is not supported. The only "
+                    "Payment Type Codes supported for SEPA Credit Transfers "
+                    "are 'pain.001.001.02', 'pain.001.001.03', "
+                    "'pain.001.001.04' and 'pain.001.001.05'.")
                 % pain_flavor)
-        if sepa_export.prefered_exec_date:
-            my_requested_exec_date = sepa_export.prefered_exec_date
-        else:
-            my_requested_exec_date = fields.date.context_today(
-                self, cr, uid, context=context)
+
+        gen_args = {
+            'bic_xml_tag': bic_xml_tag,
+            'name_maxsize': name_maxsize,
+            'convert_to_ascii': convert_to_ascii,
+            'payment_method': 'TRF',
+            'pain_flavor': pain_flavor,
+            'sepa_export': sepa_export,
+            'file_obj': self.pool['banking.export.sepa'],
+            'pain_xsd_file':
+            'account_banking_sepa_credit_transfer/data/%s.xsd'
+            % pain_flavor,
+        }
 
         pain_ns = {
             'xsi': 'http://www.w3.org/2001/XMLSchema-instance',
             None: 'urn:iso:std:iso:20022:tech:xsd:%s' % pain_flavor,
             }
 
-        root = etree.Element('Document', nsmap=pain_ns)
-        pain_root = etree.SubElement(root, root_xml_tag)
-
-        my_company_name = self._prepare_field(
-            cr, uid, 'Company Name',
-            'sepa_export.payment_order_ids[0].mode.bank_id.partner_id.name',
-            {'sepa_export': sepa_export}, name_maxsize, context=context)
+        xml_root = etree.Element('Document', nsmap=pain_ns)
+        pain_root = etree.SubElement(xml_root, root_xml_tag)
+        pain_03_to_05 = \
+            ['pain.001.001.03', 'pain.001.001.04', 'pain.001.001.05']
 
         # A. Group header
-        group_header_1_0 = etree.SubElement(pain_root, 'GrpHdr')
-        message_identification_1_1 = etree.SubElement(
-            group_header_1_0, 'MsgId')
-        message_identification_1_1.text = self._prepare_field(
-            cr, uid, 'Message Identification',
-            'sepa_export.payment_order_ids[0].reference',
-            {'sepa_export': sepa_export}, 35, context=context)
-        creation_date_time_1_2 = etree.SubElement(group_header_1_0, 'CreDtTm')
-        creation_date_time_1_2.text = datetime.strftime(
-            datetime.today(), '%Y-%m-%dT%H:%M:%S')
-        if pain_flavor == 'pain.001.001.02':
-            # batch_booking is in "Group header" with pain.001.001.02
-            # and in "Payment info" in pain.001.001.03/04
-            batch_booking = etree.SubElement(group_header_1_0, 'BtchBookg')
-            batch_booking.text = str(sepa_export.batch_booking).lower()
-        nb_of_transactions_1_6 = etree.SubElement(
-            group_header_1_0, 'NbOfTxs')
-        control_sum_1_7 = etree.SubElement(group_header_1_0, 'CtrlSum')
-        # Grpg removed in pain.001.001.03
-        if pain_flavor == 'pain.001.001.02':
-            grouping = etree.SubElement(group_header_1_0, 'Grpg')
-            grouping.text = 'GRPD'
-        initiating_party_1_8 = etree.SubElement(group_header_1_0, 'InitgPty')
-        initiating_party_name = etree.SubElement(initiating_party_1_8, 'Nm')
-        initiating_party_name.text = my_company_name
-
-        # B. Payment info
-        payment_info_2_0 = etree.SubElement(pain_root, 'PmtInf')
-        payment_info_identification_2_1 = etree.SubElement(
-            payment_info_2_0, 'PmtInfId')
-        payment_info_identification_2_1.text = self._prepare_field(
-            cr, uid, 'Payment Information Identification',
-            "sepa_export.payment_order_ids[0].reference",
-            {'sepa_export': sepa_export}, 35, context=context)
-        payment_method_2_2 = etree.SubElement(payment_info_2_0, 'PmtMtd')
-        payment_method_2_2.text = 'TRF'
-        if pain_flavor in [
-                'pain.001.001.03', 'pain.001.001.04', 'pain.001.001.05']:
-            # batch_booking is in "Group header" with pain.001.001.02
-            # and in "Payment info" in pain.001.001.03/04
-            batch_booking_2_3 = etree.SubElement(payment_info_2_0, 'BtchBookg')
-            batch_booking_2_3.text = str(sepa_export.batch_booking).lower()
-        # It may seem surprising, but the
-        # "SEPA Credit Transfer Scheme Customer-to-bank Implementation
-        # guidelines" v6.0 says that control sum and nb_of_transactions
-        # should be present at both "group header" level and "payment info"
-        # level. This seems to be confirmed by the tests carried out at
-        # BNP Paribas in PAIN v001.001.03
-        if pain_flavor in [
-                'pain.001.001.03', 'pain.001.001.04', 'pain.001.001.05']:
-            nb_of_transactions_2_4 = etree.SubElement(
-                payment_info_2_0, 'NbOfTxs')
-            control_sum_2_5 = etree.SubElement(payment_info_2_0, 'CtrlSum')
-        payment_type_info_2_6 = etree.SubElement(payment_info_2_0, 'PmtTpInf')
-        service_level_2_8 = etree.SubElement(payment_type_info_2_6, 'SvcLvl')
-        service_level_code_2_9 = etree.SubElement(service_level_2_8, 'Cd')
-        service_level_code_2_9.text = 'SEPA'
-        requested_exec_date_2_17 = etree.SubElement(
-            payment_info_2_0, 'ReqdExctnDt')
-        requested_exec_date_2_17.text = my_requested_exec_date
-        debtor_2_19 = etree.SubElement(payment_info_2_0, 'Dbtr')
-        debtor_name = etree.SubElement(debtor_2_19, 'Nm')
-        debtor_name.text = my_company_name
-        debtor_account_2_20 = etree.SubElement(payment_info_2_0, 'DbtrAcct')
-        debtor_account_id = etree.SubElement(debtor_account_2_20, 'Id')
-        debtor_account_iban = etree.SubElement(debtor_account_id, 'IBAN')
-        debtor_account_iban.text = self._validate_iban(
-            cr, uid, self._prepare_field(
-                cr, uid, 'Company IBAN',
-                'sepa_export.payment_order_ids[0].mode.bank_id.acc_number',
-                {'sepa_export': sepa_export}, context=context),
-            context=context)
-        debtor_agent_2_21 = etree.SubElement(payment_info_2_0, 'DbtrAgt')
-        debtor_agent_institution = etree.SubElement(
-            debtor_agent_2_21, 'FinInstnId')
-        debtor_agent_bic = etree.SubElement(
-            debtor_agent_institution, bic_xml_tag)
-        # TODO validate BIC with pattern
-        # [A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1}
-        # because OpenERP doesn't have a constraint on BIC
-        debtor_agent_bic.text = self._prepare_field(
-            cr, uid, 'Company BIC',
-            'sepa_export.payment_order_ids[0].mode.bank_id.bank.bic',
-            {'sepa_export': sepa_export}, context=context)
-        charge_bearer_2_24 = etree.SubElement(payment_info_2_0, 'ChrgBr')
-        charge_bearer_2_24.text = sepa_export.charge_bearer
-
-        transactions_count = 0
+        group_header_1_0, nb_of_transactions_1_6, control_sum_1_7 = \
+            self.generate_group_header_block(
+                cr, uid, pain_root, gen_args, context=context)
+
+        transactions_count_1_6 = 0
         total_amount = 0.0
-        amount_control_sum = 0.0
-        # Iterate on payment orders
+        amount_control_sum_1_7 = 0.0
+        lines_per_group = {}
+        # key = (requested_date, priority)
+        # values = list of lines as object
+        today = fields.date.context_today(self, cr, uid, context=context)
         for payment_order in sepa_export.payment_order_ids:
             total_amount = total_amount + payment_order.total
-            # Iterate each payment lines
             for line in payment_order.line_ids:
-                transactions_count += 1
+                priority = line.priority
+                if payment_order.date_prefered == 'due':
+                    requested_date = line.ml_maturity_date or today
+                elif payment_order.date_prefered == 'fixed':
+                    requested_date = payment_order.date_scheduled or today
+                else:
+                    requested_date = today
+                key = (requested_date, priority)
+                if key in lines_per_group:
+                    lines_per_group[key].append(line)
+                else:
+                    lines_per_group[key] = [line]
+                # Write requested_date on 'Payment date' of the pay line
+                if requested_date != line.date:
+                    self.pool['payment.line'].write(
+                        cr, uid, line.id,
+                        {'date': requested_date}, context=context)
+
+        for (requested_date, priority), lines in lines_per_group.items():
+            # B. Payment info
+            payment_info_2_0, nb_of_transactions_2_4, control_sum_2_5 = \
+                self.generate_start_payment_info_block(
+                    cr, uid, pain_root,
+                    "sepa_export.payment_order_ids[0].reference + '-' "
+                    "+ requested_date.replace('-', '')  + '-' + priority",
+                    priority, False, False, requested_date, {
+                        'sepa_export': sepa_export,
+                        'priority': priority,
+                        'requested_date': requested_date,
+                    }, gen_args, context=context)
+
+            self.generate_party_block(
+                cr, uid, payment_info_2_0, 'Dbtr', 'B',
+                'sepa_export.payment_order_ids[0].mode.bank_id.partner_id.'
+                'name',
+                'sepa_export.payment_order_ids[0].mode.bank_id.acc_number',
+                'sepa_export.payment_order_ids[0].mode.bank_id.bank.bic',
+                {'sepa_export': sepa_export},
+                gen_args, context=context)
+
+            charge_bearer_2_24 = etree.SubElement(payment_info_2_0, 'ChrgBr')
+            charge_bearer_2_24.text = sepa_export.charge_bearer
+
+            transactions_count_2_4 = 0
+            amount_control_sum_2_5 = 0.0
+            for line in lines:
+                transactions_count_1_6 += 1
+                transactions_count_2_4 += 1
                 # C. Credit Transfer Transaction Info
                 credit_transfer_transaction_info_2_27 = etree.SubElement(
                     payment_info_2_0, 'CdtTrfTxInf')
@@ -331,104 +227,54 @@
                     payment_identification_2_28, 'EndToEndId')
                 end2end_identification_2_30.text = self._prepare_field(
                     cr, uid, 'End to End Identification', 'line.name',
-                    {'line': line}, 35, context=context)
+                    {'line': line}, 35, gen_args=gen_args,
+                    context=context)
                 currency_name = self._prepare_field(
                     cr, uid, 'Currency Code', 'line.currency.name',
-                    {'line': line}, 3, context=context)
+                    {'line': line}, 3, gen_args=gen_args,
+                    context=context)
                 amount_2_42 = etree.SubElement(
                     credit_transfer_transaction_info_2_27, 'Amt')
                 instructed_amount_2_43 = etree.SubElement(
                     amount_2_42, 'InstdAmt', Ccy=currency_name)
                 instructed_amount_2_43.text = '%.2f' % line.amount_currency
-                amount_control_sum += line.amount_currency
-                creditor_agent_2_77 = etree.SubElement(
-                    credit_transfer_transaction_info_2_27, 'CdtrAgt')
-                creditor_agent_institution = etree.SubElement(
-                    creditor_agent_2_77, 'FinInstnId')
+                amount_control_sum_1_7 += line.amount_currency
+                amount_control_sum_2_5 += line.amount_currency
+
                 if not line.bank_id:
                     raise orm.except_orm(
                         _('Error:'),
-                        _("Missing Bank Account on invoice '%s' (payment order line reference '%s').")
+                        _("Missing Bank Account on invoice '%s' (payment "
+                            "order line reference '%s').")
                         % (line.ml_inv_ref.number, line.name))
-                creditor_agent_bic = etree.SubElement(
-                    creditor_agent_institution, bic_xml_tag)
-                creditor_agent_bic.text = self._prepare_field(
-                    cr, uid, 'Customer BIC', 'line.bank_id.bank.bic',
-                    {'line': line}, context=context)
-                creditor_2_79 = etree.SubElement(
-                    credit_transfer_transaction_info_2_27, 'Cdtr')
-                creditor_name = etree.SubElement(creditor_2_79, 'Nm')
-                creditor_name.text = self._prepare_field(
-                    cr, uid, 'Customer Name', 'line.partner_id.name',
-                    {'line': line}, name_maxsize, context=context)
-                creditor_account_2_80 = etree.SubElement(
-                    credit_transfer_transaction_info_2_27, 'CdtrAcct')
-                creditor_account_id = etree.SubElement(
-                    creditor_account_2_80, 'Id')
-                creditor_account_iban = etree.SubElement(
-                    creditor_account_id, 'IBAN')
-                creditor_account_iban.text = self._validate_iban(
-                    cr, uid, self._prepare_field(
-                        cr, uid, 'Customer IBAN',
-                        'line.bank_id.acc_number', {'line': line},
-                        context=context),
+                self.generate_party_block(
+                    cr, uid, credit_transfer_transaction_info_2_27, 'Cdtr',
+                    'C', 'line.partner_id.name', 'line.bank_id.acc_number',
+                    'line.bank_id.bank.bic', {'line': line}, gen_args,
                     context=context)
-                remittance_info_2_91 = etree.SubElement(
-                    credit_transfer_transaction_info_2_27, 'RmtInf')
-                # switch to Structured (Strdr) ?
-                # If we do it, beware that the format is not the same
-                # between pain 02 and pain 03
-                remittance_info_unstructured_2_99 = etree.SubElement(
-                    remittance_info_2_91, 'Ustrd')
-                remittance_info_unstructured_2_99.text = self._prepare_field(
-                    cr, uid, 'Remittance Information', 'line.communication',
-                    {'line': line}, 140, context=context)
-
-        if pain_flavor in [
-                'pain.001.001.03', 'pain.001.001.04', 'pain.001.001.05']:
-            nb_of_transactions_1_6.text = nb_of_transactions_2_4.text = \
-                str(transactions_count)
-            control_sum_1_7.text = control_sum_2_5.text = \
-                '%.2f' % amount_control_sum
+
+                self.generate_remittance_info_block(
+                    cr, uid, credit_transfer_transaction_info_2_27,
+                    line, gen_args, context=context)
+
+            if pain_flavor in pain_03_to_05:
+                nb_of_transactions_2_4.text = str(transactions_count_2_4)
+                control_sum_2_5.text = '%.2f' % amount_control_sum_2_5
+
+        if pain_flavor in pain_03_to_05:
+            nb_of_transactions_1_6.text = str(transactions_count_1_6)
+            control_sum_1_7.text = '%.2f' % amount_control_sum_1_7
         else:
-            nb_of_transactions_1_6.text = str(transactions_count)
-            control_sum_1_7.text = '%.2f' % amount_control_sum
-
-        xml_string = etree.tostring(
-            root, pretty_print=True, encoding='UTF-8', xml_declaration=True)
-        _logger.debug(
-            "Generated SEPA Credit Transfer XML file in format %s below"
-            % pain_flavor)
-        _logger.debug(xml_string)
-        self._validate_xml(cr, uid, xml_string, pain_flavor)
-
-        # CREATE the banking.export.sepa record
-        file_id = self.pool.get('banking.export.sepa').create(
-            cr, uid, self._prepare_export_sepa(
-                cr, uid, sepa_export, total_amount, transactions_count,
-                xml_string, context=context),
-            context=context)
-
-        self.write(
-            cr, uid, ids, {
-                'file_id': file_id,
-                'state': 'finish',
-            }, context=context)
-
-        action = {
-            'name': 'SEPA Credit Transfer File',
-            'type': 'ir.actions.act_window',
-            'view_type': 'form',
-            'view_mode': 'form,tree',
-            'res_model': self._name,
-            'res_id': ids[0],
-            'target': 'new',
-            }
-        return action
+            nb_of_transactions_1_6.text = str(transactions_count_1_6)
+            control_sum_1_7.text = '%.2f' % amount_control_sum_1_7
+
+        return self.finalize_sepa_file_creation(
+            cr, uid, ids, xml_root, total_amount, transactions_count_1_6,
+            gen_args, context=context)
 
     def cancel_sepa(self, cr, uid, ids, context=None):
         '''
-        Cancel the SEPA PAIN: just drop the file
+        Cancel the SEPA file: just drop the file
         '''
         sepa_export = self.browse(cr, uid, ids[0], context=context)
         self.pool.get('banking.export.sepa').unlink(
@@ -437,7 +283,7 @@
 
     def save_sepa(self, cr, uid, ids, context=None):
         '''
-        Save the SEPA PAIN: send the done signal to all payment
+        Save the SEPA file: send the done signal to all payment
         orders in the file. With the default workflow, they will
         transition to 'done', while with the advanced workflow in
         account_banking_payment they will transition to 'sent' waiting
 
=== modified file 'account_banking_sepa_credit_transfer/wizard/export_sepa_view.xml'
--- account_banking_sepa_credit_transfer/wizard/export_sepa_view.xml	2013-11-07 11:50:36 +0000
+++ account_banking_sepa_credit_transfer/wizard/export_sepa_view.xml	2014-01-13 12:42:46 +0000
@@ -15,7 +15,6 @@
             <field name="state" invisible="True"/>
             <group states="create">
                 <field name="batch_booking" />
-                <field name="prefered_exec_date" />
                 <field name="charge_bearer" />
             </group>
             <group states="finish">
 
=== added directory 'account_banking_sepa_direct_debit'
=== added file 'account_banking_sepa_direct_debit/__init__.py'
--- account_banking_sepa_direct_debit/__init__.py	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/__init__.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,25 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    SEPA Direct Debit module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from . import company
+from . import wizard
+from . import account_banking_sdd
 
=== added file 'account_banking_sepa_direct_debit/__openerp__.py'
--- account_banking_sepa_direct_debit/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/__openerp__.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,60 @@
+##############################################################################
+#
+#    SEPA Direct Debit module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+{
+    'name': 'Account Banking SEPA Direct Debit',
+    'summary': 'Create SEPA files for Direct Debit',
+    'version': '0.1',
+    'license': 'AGPL-3',
+    'author': 'Akretion',
+    'website': 'http://www.akretion.com',
+    'category': 'Banking addons',
+    'depends': ['account_direct_debit', 'account_banking_pain_base'],
+    'external_dependencies': {
+        'python': ['unidecode', 'lxml'],
+        },
+    'data': [
+        'security/original_mandate_required_security.xml',
+        'account_banking_sdd_view.xml',
+        'sdd_mandate_view.xml',
+        'res_partner_bank_view.xml',
+        'account_payment_view.xml',
+        'company_view.xml',
+        'mandate_expire_cron.xml',
+        'account_invoice_view.xml',
+        'wizard/export_sdd_view.xml',
+        'data/payment_type_sdd.xml',
+        'data/mandate_reference_sequence.xml',
+        'security/ir.model.access.csv',
+    ],
+    'description': '''
+Module to export direct debit payment orders in SEPA XML file format.
+
+SEPA PAIN (PAyment INitiation) is the new european standard for Customer-to-Bank payment instructions. This module implements SEPA Direct Debit (SDD), more specifically PAIN versions 008.001.02, 008.001.03 and 008.001.04. It is part of the ISO 20022 standard, available on http://www.iso20022.org.
+
+The Implementation Guidelines for SEPA Direct Debit published by the European Payments Council (http://http://www.europeanpaymentscouncil.eu) use PAIN version 008.001.02. So if you don't know which version your bank supports, you should try version 008.001.02 first.
+
+This module uses the framework provided by the banking addons, cf https://launchpad.net/banking-addons
+
+Please contact Alexis de Lattre from Akretion <[e-mail]> for any help or question about this module.
+    ''',
+    'active': False,
+    'installable': True,
+}
 
=== added file 'account_banking_sepa_direct_debit/account_banking_sdd.py'
--- account_banking_sepa_direct_debit/account_banking_sdd.py	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/account_banking_sdd.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,424 @@
+##############################################################################
+#
+#    SEPA Direct Debit module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.osv import orm, fields
+from openerp.tools.translate import _
+from openerp.addons.decimal_precision import decimal_precision as dp
+from unidecode import unidecode
+from datetime import datetime
+from dateutil.relativedelta import relativedelta
+import logging
+
+NUMBER_OF_UNUSED_MONTHS_BEFORE_EXPIRY = 36
+
+logger = logging.getLogger(__name__)
+
+
+class banking_export_sdd(orm.Model):
+    '''SEPA Direct Debit export'''
+    _name = 'banking.export.sdd'
+    _description = __doc__
+    _rec_name = 'filename'
+
+    def _generate_filename(self, cr, uid, ids, name, arg, context=None):
+        res = {}
+        for sepa_file in self.browse(cr, uid, ids, context=context):
+            ref = sepa_file.payment_order_ids[0].reference
+            if ref:
+                label = unidecode(ref.replace('/', '-'))
+            else:
+                label = 'error'
+            res[sepa_file.id] = 'sdd_%s.xml' % label
+        return res
+
+    _columns = {
+        'payment_order_ids': fields.many2many(
+            'payment.order',
+            'account_payment_order_sdd_rel',
+            'banking_export_sepa_id', 'account_order_id',
+            'Payment Orders',
+            readonly=True),
+        'nb_transactions': fields.integer(
+            'Number of Transactions', readonly=True),
+        'total_amount': fields.float(
+            'Total Amount', digits_compute=dp.get_precision('Account'),
+            readonly=True),
+        'batch_booking': fields.boolean(
+            'Batch Booking', readonly=True,
+            help="If true, the bank statement will display only one credit "
+            "line for all the direct debits of the SEPA file ; if false, "
+            "the bank statement will display one credit line per direct "
+            "debit of the SEPA file."),
+        'charge_bearer': fields.selection([
+            ('SLEV', 'Following Service Level'),
+            ('SHAR', 'Shared'),
+            ('CRED', 'Borne by Creditor'),
+            ('DEBT', 'Borne by Debtor'),
+            ], 'Charge Bearer', readonly=True,
+            help="Following service level : transaction charges are to be "
+            "applied following the rules agreed in the service level and/or "
+            "scheme (SEPA Core messages must use this). Shared : "
+            "transaction charges on the creditor side are to be borne by "
+            "the creditor, transaction charges on the debtor side are to be "
+            "borne by the debtor. Borne by creditor : all transaction "
+            "charges are to be borne by the creditor. Borne by debtor : "
+            "all transaction charges are to be borne by the debtor."),
+        'create_date': fields.datetime('Generation Date', readonly=True),
+        'file': fields.binary('SEPA File', readonly=True),
+        'filename': fields.function(
+            _generate_filename, type='char', size=256,
+            string='Filename', readonly=True, store=True),
+        'state': fields.selection([
+            ('draft', 'Draft'),
+            ('sent', 'Sent'),
+            ('done', 'Reconciled'),
+            ], 'State', readonly=True),
+    }
+
+    _defaults = {
+        'state': 'draft',
+    }
+
+
+class sdd_mandate(orm.Model):
+    '''SEPA Direct Debit Mandate'''
+    _name = 'sdd.mandate'
+    _description = __doc__
+    _rec_name = 'unique_mandate_reference'
+    _inherit = ['mail.thread']
+    _order = 'signature_date desc'
+    _track = {
+        'state': {
+            'account_banking_sepa_direct_debit.mandate_valid':
+            lambda self, cr, uid, obj, ctx=None:
+            obj['state'] == 'valid',
+            'account_banking_sepa_direct_debit.mandate_expired':
+            lambda self, cr, uid, obj, ctx=None:
+            obj['state'] == 'expired',
+            'account_banking_sepa_direct_debit.mandate_cancel':
+            lambda self, cr, uid, obj, ctx=None:
+            obj['state'] == 'cancel',
+            },
+        'recurrent_sequence_type': {
+            'account_banking_sepa_direct_debit.recurrent_sequence_type_first':
+            lambda self, cr, uid, obj, ctx=None:
+            obj['recurrent_sequence_type'] == 'first',
+            'account_banking_sepa_direct_debit.'
+            'recurrent_sequence_type_recurring':
+            lambda self, cr, uid, obj, ctx=None:
+            obj['recurrent_sequence_type'] == 'recurring',
+            'account_banking_sepa_direct_debit.recurrent_sequence_type_final':
+            lambda self, cr, uid, obj, ctx=None:
+            obj['recurrent_sequence_type'] == 'final',
+            }
+        }
+
+    _columns = {
+        'partner_bank_id': fields.many2one(
+            'res.partner.bank', 'Bank Account', track_visibility='onchange'),
+        'partner_id': fields.related(
+            'partner_bank_id', 'partner_id', type='many2one',
+            relation='res.partner', string='Partner', readonly=True),
+        'company_id': fields.many2one('res.company', 'Company', required=True),
+        'unique_mandate_reference': fields.char(
+            'Unique Mandate Reference', size=35, readonly=True,
+            track_visibility='always'),
+        'type': fields.selection([
+            ('recurrent', 'Recurrent'),
+            ('oneoff', 'One-Off'),
+            ], 'Type of Mandate', required=True, track_visibility='always'),
+        'recurrent_sequence_type': fields.selection([
+            ('first', 'First'),
+            ('recurring', 'Recurring'),
+            ('final', 'Final'),
+            ], 'Sequence Type for Next Debit', track_visibility='onchange',
+            help="This field is only used for Recurrent mandates, not for "
+            "One-Off mandates."),
+        'signature_date': fields.date(
+            'Date of Signature of the Mandate', track_visibility='onchange'),
+        'scan': fields.binary('Scan of the Mandate'),
+        'last_debit_date': fields.date(
+            'Date of the Last Debit', readonly=True),
+        'state': fields.selection([
+            ('draft', 'Draft'),
+            ('valid', 'Valid'),
+            ('expired', 'Expired'),
+            ('cancel', 'Cancelled'),
+            ], 'Status',
+            help="Only valid mandates can be used in a payment line. A "
+            "cancelled mandate is a mandate that has been cancelled by "
+            "the customer. A one-off mandate expires after its first use. "
+            "A recurrent mandate expires after it's final use or if it "
+            "hasn't been used for 36 months."),
+        'payment_line_ids': fields.one2many(
+            'payment.line', 'sdd_mandate_id', "Related Payment Lines"),
+        'sepa_migrated': fields.boolean(
+            'Migrated to SEPA', track_visibility='onchange',
+            help="If this field is not active, the mandate section of the "
+            "next direct debit file that include this mandate will contain "
+            "the 'Original Mandate Identification' and the 'Original "
+            "Creditor Scheme Identification'. This is required in a few "
+            "countries (Belgium for instance), but not in all countries. "
+            "If this is not required in your country, you should keep this "
+            "field always active."),
+        'original_mandate_identification': fields.char(
+            'Original Mandate Identification', size=35,
+            track_visibility='onchange',
+            help="When the field 'Migrated to SEPA' is not active, this "
+            "field will be used as the Original Mandate Identification in "
+            "the Direct Debit file."),
+        }
+
+    _defaults = {
+        'company_id': lambda self, cr, uid, context:
+        self.pool['res.company']._company_default_get(
+            cr, uid, 'sdd.mandate', context=context),
+        'unique_mandate_reference': lambda self, cr, uid, ctx:
+        self.pool['ir.sequence'].get(cr, uid, 'sdd.mandate.reference'),
+        'state': 'draft',
+        'sepa_migrated': True,
+    }
+
+    _sql_constraints = [(
+        'mandate_ref_company_uniq',
+        'unique(unique_mandate_reference, company_id)',
+        'A Mandate with the same reference already exists for this company !'
+        )]
+
+    def _check_sdd_mandate(self, cr, uid, ids):
+        for mandate in self.browse(cr, uid, ids):
+            if (mandate.signature_date and
+                    mandate.signature_date >
+                    datetime.today().strftime('%Y-%m-%d')):
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("The date of signature of mandate '%s' is in the "
+                        "future !")
+                    % mandate.unique_mandate_reference)
+            if mandate.state == 'valid' and not mandate.signature_date:
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("Cannot validate the mandate '%s' without a date of "
+                        "signature.")
+                    % mandate.unique_mandate_reference)
+            if mandate.state == 'valid' and not mandate.partner_bank_id:
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("Cannot validate the mandate '%s' because it is not "
+                        "attached to a bank account.")
+                    % mandate.unique_mandate_reference)
+
+            if (mandate.signature_date and mandate.last_debit_date and
+                    mandate.signature_date > mandate.last_debit_date):
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("The mandate '%s' can't have a date of last debit "
+                        "before the date of signature.")
+                    % mandate.unique_mandate_reference)
+            if (mandate.type == 'recurrent'
+                    and not mandate.recurrent_sequence_type):
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("The recurrent mandate '%s' must have a sequence type.")
+                    % mandate.unique_mandate_reference)
+            if (mandate.type == 'recurrent' and not mandate.sepa_migrated
+                    and mandate.recurrent_sequence_type != 'first'):
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("The recurrent mandate '%s' which is not marked as "
+                        "'Migrated to SEPA' must have its recurrent sequence "
+                        "type set to 'First'.")
+                    % mandate.unique_mandate_reference)
+            if (mandate.type == 'recurrent' and not mandate.sepa_migrated
+                    and not mandate.original_mandate_identification):
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("You must set the 'Original Mandate Identification' "
+                        "on the recurrent mandate '%s' which is not marked "
+                        "as 'Migrated to SEPA'.")
+                    % mandate.unique_mandate_reference)
+        return True
+
+    _constraints = [
+        (_check_sdd_mandate, "Error msg in raise", [
+            'last_debit_date', 'signature_date', 'state', 'partner_bank_id',
+            'type', 'recurrent_sequence_type', 'sepa_migrated',
+            'original_mandate_identification',
+            ]),
+    ]
+
+    def mandate_type_change(self, cr, uid, ids, type):
+        if type == 'recurrent':
+            recurrent_sequence_type = 'first'
+        else:
+            recurrent_sequence_type = False
+        res = {'value': {'recurrent_sequence_type': recurrent_sequence_type}}
+        return res
+
+    def mandate_partner_bank_change(
+            self, cr, uid, ids, partner_bank_id, type, recurrent_sequence_type,
+            last_debit_date, state):
+        res = {'value': {}}
+        if partner_bank_id:
+            partner_bank_read = self.pool['res.partner.bank'].read(
+                cr, uid, partner_bank_id, ['partner_id'])['partner_id']
+            if partner_bank_read:
+                res['value']['partner_id'] = partner_bank_read[0]
+        if (state == 'valid' and partner_bank_id
+                and type == 'recurrent'
+                and recurrent_sequence_type != 'first'):
+            res['value']['recurrent_sequence_type'] = 'first'
+            res['warning'] = {
+                'title': _('Mandate update'),
+                'message': _(
+                    "As you changed the bank account attached to this "
+                    "mandate, the 'Sequence Type' has been set back to "
+                    "'First'."),
+                }
+        return res
+
+    def validate(self, cr, uid, ids, context=None):
+        to_validate_ids = []
+        for mandate in self.browse(cr, uid, ids, context=context):
+            assert mandate.state == 'draft', 'Mandate should be in draft state'
+            to_validate_ids.append(mandate.id)
+        self.write(
+            cr, uid, to_validate_ids, {'state': 'valid'}, context=context)
+        return True
+
+    def cancel(self, cr, uid, ids, context=None):
+        to_cancel_ids = []
+        for mandate in self.browse(cr, uid, ids, context=context):
+            assert mandate.state in ('draft', 'valid'),\
+                'Mandate should be in draft or valid state'
+            to_cancel_ids.append(mandate.id)
+        self.write(
+            cr, uid, to_cancel_ids, {'state': 'cancel'}, context=context)
+        return True
+
+    def _sdd_mandate_set_state_to_expired(self, cr, uid, context=None):
+        logger.info('Searching for SDD Mandates that must be set to Expired')
+        expire_limit_date = datetime.today() + \
+            relativedelta(months=-NUMBER_OF_UNUSED_MONTHS_BEFORE_EXPIRY)
+        expire_limit_date_str = expire_limit_date.strftime('%Y-%m-%d')
+        expired_mandate_ids = self.search(cr, uid, [
+            '|',
+            ('last_debit_date', '=', False),
+            ('last_debit_date', '<=', expire_limit_date_str),
+            ('state', '=', 'valid'),
+            ('signature_date', '<=', expire_limit_date_str),
+            ], context=context)
+        if expired_mandate_ids:
+            self.write(
+                cr, uid, expired_mandate_ids, {'state': 'expired'},
+                context=context)
+            logger.info(
+                'The following SDD Mandate IDs has been set to expired: %s'
+                % expired_mandate_ids)
+        else:
+            logger.info('0 SDD Mandates must be set to Expired')
+        return True
+
+
+class res_partner_bank(orm.Model):
+    _inherit = 'res.partner.bank'
+
+    _columns = {
+        'sdd_mandate_ids': fields.one2many(
+            'sdd.mandate', 'partner_bank_id', 'SEPA Direct Debit Mandates'),
+        }
+
+
+class payment_line(orm.Model):
+    _inherit = 'payment.line'
+
+    _columns = {
+        'sdd_mandate_id': fields.many2one(
+            'sdd.mandate', 'SEPA Direct Debit Mandate',
+            domain=[('state', '=', 'valid')]),
+        }
+
+    def create(self, cr, uid, vals, context=None):
+        '''If the customer invoice has a mandate, take it
+        otherwise, take the first valid mandate of the bank account'''
+        if context is None:
+            context = {}
+        if not vals:
+            vals = {}
+        partner_bank_id = vals.get('bank_id')
+        move_line_id = vals.get('move_line_id')
+        if (context.get('default_payment_order_type') == 'debit'
+                and 'sdd_mandate_id' not in vals):
+            if move_line_id:
+                line = self.pool['account.move.line'].browse(
+                    cr, uid, move_line_id, context=context)
+                if (line.invoice and line.invoice.type == 'out_invoice'
+                        and line.invoice.sdd_mandate_id):
+                    vals.update({
+                        'sdd_mandate_id': line.invoice.sdd_mandate_id.id,
+                        'bank_id':
+                        line.invoice.sdd_mandate_id.partner_bank_id.id,
+                    })
+            if partner_bank_id and 'sdd_mandate_id' not in vals:
+                mandate_ids = self.pool['sdd.mandate'].search(cr, uid, [
+                    ('partner_bank_id', '=', partner_bank_id),
+                    ('state', '=', 'valid'),
+                    ], context=context)
+                if mandate_ids:
+                    vals['sdd_mandate_id'] = mandate_ids[0]
+        return super(payment_line, self).create(cr, uid, vals, context=context)
+
+    def _check_mandate_bank_link(self, cr, uid, ids):
+        for payline in self.browse(cr, uid, ids):
+            if (payline.sdd_mandate_id and payline.bank_id
+                    and payline.sdd_mandate_id.partner_bank_id.id !=
+                    payline.bank_id.id):
+                raise orm.except_orm(
+                    _('Error:'),
+                    _("The payment line with reference '%s' has the bank "
+                        "account '%s' which is not attached to the mandate "
+                        "'%s' (this mandate is attached to the bank account "
+                        "'%s').") % (
+                        payline.name,
+                        self.pool['res.partner.bank'].name_get(
+                            cr, uid, [payline.bank_id.id])[0][1],
+                        payline.sdd_mandate_id.unique_mandate_reference,
+                        self.pool['res.partner.bank'].name_get(
+                            cr, uid,
+                            [payline.sdd_mandate_id.partner_bank_id.id])[0][1],
+                    ))
+        return True
+
+    _constraints = [
+        (_check_mandate_bank_link, 'Error msg in raise',
+            ['sdd_mandate_id', 'bank_id']),
+    ]
+
+
+class account_invoice(orm.Model):
+    _inherit = 'account.invoice'
+
+    _columns = {
+        'sdd_mandate_id': fields.many2one(
+            'sdd.mandate', 'SEPA Direct Debit Mandate',
+            domain=[('state', '=', 'valid')], readonly=True,
+            states={'draft': [('readonly', False)]})
+        }
 
=== added file 'account_banking_sepa_direct_debit/account_banking_sdd_view.xml'
--- account_banking_sepa_direct_debit/account_banking_sdd_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/account_banking_sdd_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="view_banking_export_sdd_form" model="ir.ui.view">
+    <field name="name">account.banking.export.sdd.form</field>
+    <field name="model">banking.export.sdd</field>
+    <field name="arch" type="xml">
+        <form string="SEPA Direct Debit">
+            <notebook>
+                <page string="General Information">
+                    <field name="total_amount" />
+                    <field name="nb_transactions" />
+                    <field name="batch_booking" />
+                    <field name="charge_bearer"/>
+                    <field name="create_date" />
+                    <newline />
+                    <field name="file" filename="filename"/>
+                    <field name="filename" invisible="True"/>
+                </page>
+                <page string="Payment Orders">
+                    <field name="payment_order_ids" colspan="4" nolabel="1">
+                        <tree colors="blue:state in ('draft');gray:state in ('cancel','done');black:state in ('open')" string="Payment Orders">
+                            <field name="reference"/>
+                            <field name="date_created"/>
+                            <field name="date_done"/>
+                            <field name="total"/>
+                            <field name="state"/>
+                        </tree>
+                    </field>
+                </page>
+            </notebook>
+        </form>
+    </field>
+</record>
+
+
+<record id="view_banking_export_sdd_tree" model="ir.ui.view">
+    <field name="name">account.banking.export.sdd.tree</field>
+    <field name="model">banking.export.sdd</field>
+    <field name="arch" type="xml">
+        <tree string="SEPA Direct Debit">
+            <field name="filename"/>
+            <field name="create_date"/>
+            <field name="nb_transactions"/>
+        </tree>
+    </field>
+</record>
+
+
+<record id="action_account_banking_sdd" model="ir.actions.act_window">
+    <field name="name">SEPA Direct Debit Files</field>
+    <field name="res_model">banking.export.sdd</field>
+    <field name="view_type">form</field>
+    <field name="view_mode">tree,form</field>
+</record>
+
+
+<menuitem id="menu_account_banking_sdd"
+          parent="account_payment.menu_main_payment"
+          action="action_account_banking_sdd"
+          sequence="20"
+          />
+
+<act_window id="act_banking_export_sdd_payment_order"
+    name="Generated SEPA Direct Debit Files"
+    domain="[('payment_order_ids', '=', active_id)]"
+    res_model="banking.export.sdd"
+    src_model="payment.order"
+    view_type="form"
+    view_mode="tree,form"
+/>
+
+</data>
+</openerp>
 
=== added file 'account_banking_sepa_direct_debit/account_invoice_view.xml'
--- account_banking_sepa_direct_debit/account_invoice_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/account_invoice_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="invoice_form" model="ir.ui.view">
+    <field name="name">add.sdd.mandate.on.customer.invoice.form</field>
+    <field name="model">account.invoice</field>
+    <field name="inherit_id" ref="account.invoice_form"/>
+    <field name="arch" type="xml">
+        <field name="partner_bank_id" position="after">
+            <field name="sdd_mandate_id" domain="[('partner_id', '=', partner_id), ('state', '=', 'valid')]" attrs="{'invisible': [('type', '=', 'out_refund')]}"/>
+        </field>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== added file 'account_banking_sepa_direct_debit/account_payment_view.xml'
--- account_banking_sepa_direct_debit/account_payment_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/account_payment_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="sdd_view_payment_order_form" model="ir.ui.view">
+    <field name="name">sdd.payment.order.form</field>
+    <field name="model">payment.order</field>
+    <field name="inherit_id" ref="account_payment.view_payment_order_form"/>
+    <field name="arch" type="xml">
+        <xpath expr="//field[@name='line_ids']/form/notebook/page/group/field[@name='bank_id']" position="after">
+            <field name="sdd_mandate_id" domain="[('partner_bank_id', '=', bank_id), ('state', '=', 'valid')]" invisible="context.get('default_payment_order_type')!='debit'" context="{'default_partner_bank_id': bank_id}"/>
+            <newline />
+        </xpath>
+        <xpath expr="//field[@name='line_ids']/tree/field[@name='bank_id']" position="after">
+            <field name="sdd_mandate_id" string="SDD Mandate" invisible="context.get('default_payment_order_type')!='debit'"/>
+        </xpath>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== added file 'account_banking_sepa_direct_debit/company.py'
--- account_banking_sepa_direct_debit/company.py	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/company.py	2014-01-13 12:42:46 +0000
@@ -0,0 +1,89 @@
+##############################################################################
+#
+#    SEPA Direct Debit module for OpenERP
+#    Copyright (C) 2013 Akretion (http://www.akretion.com)
+#    @author: Alexis de Lattre <[e-mail]>
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.osv import orm, fields
+import logging
+
+logger = logging.getLogger(__name__)
+
+
+class res_company(orm.Model):
+    _inherit = 'res.company'
+
+    _columns = {
+        'sepa_creditor_identifier': fields.char(
+            'SEPA Creditor Identifier', size=35,
+            help="Enter the Creditor Identifier that has been attributed "
+            "to your company to make SEPA Direct Debits. This identifier "
+            "is composed of :\n- your country ISO code (2 letters)\n- a "
+            "2-digits checkum\n- a 3-letters business code\n- a "
+            "country-specific identifier"),
+        'original_creditor_identifier': fields.char(
+            'Original Creditor Identifier', size=70),
+    }
+
+    def is_sepa_creditor_identifier_valid(
+            self, cr, uid, sepa_creditor_identifier, context=None):
+        """Check if SEPA Creditor Identifier is valid
+        @param sepa_creditor_identifier: SEPA Creditor Identifier as str
+            or unicode
+        @return: True if valid, False otherwise
+        """
+        if not isinstance(sepa_creditor_identifier, (str, unicode)):
+            return False
+        try:
+            sci_str = str(sepa_creditor_identifier)
+        except:
+            logger.warning(
+                "SEPA Creditor ID should contain only ASCII caracters.")
+            return False
+        sci = sci_str.lower()
+        if len(sci) < 9:
+            return False
+        before_replacement = sci[7:] + sci[0:2] + '00'
+        logger.debug(
+            "SEPA ID check before_replacement = %s" % before_replacement)
+        after_replacement = ''
+        for char in before_replacement:
+            if char.isalpha():
+                after_replacement += str(ord(char)-87)
+            else:
+                after_replacement += char
+        logger.debug(
+            "SEPA ID check after_replacement = %s" % after_replacement)
+        if int(sci[2:4]) == (98 - (int(after_replacement) % 97)):
+            return True
+        else:
+            return False
+
+    def _check_sepa_creditor_identifier(self, cr, uid, ids):
+        for company in self.browse(cr, uid, ids):
+            if company.sepa_creditor_identifier:
+                if not self.is_sepa_creditor_identifier_valid(
+                        cr, uid, company.sepa_creditor_identifier):
+                    return False
+        return True
+
+    _constraints = [
+        (_check_sepa_creditor_identifier,
+            "Invalid SEPA Creditor Identifier.",
+            ['sepa_creditor_identifier']),
+    ]
 
=== added file 'account_banking_sepa_direct_debit/company_view.xml'
--- account_banking_sepa_direct_debit/company_view.xml	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/company_view.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2013 Akretion (http://www.akretion.com)
+  @author: Alexis de Lattre <[e-mail]>
+  The licence is in the file __openerp__.py
+-->
+<openerp>
+<data>
+
+<record id="sdd_res_company_form" model="ir.ui.view">
+    <field name="name">sepa_direct_debit.res.company.form</field>
+    <field name="model">res.company</field>
+    <field name="inherit_id" ref="account_banking_pain_base.view_company_form"/>
+    <field name="arch" type="xml">
+        <group name="pain" position="inside">
+            <field name="sepa_creditor_identifier"/>
+            <field name="original_creditor_identifier" groups="account_banking_sepa_direct_debit.group_original_mandate_required"/>
+        </group>
+    </field>
+</record>
+
+</data>
+</openerp>
 
=== added directory 'account_banking_sepa_direct_debit/data'
=== added file 'account_banking_sepa_direct_debit/data/mandate_reference_sequence.xml'
--- account_banking_sepa_direct_debit/data/mandate_reference_sequence.xml	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/data/mandate_reference_sequence.xml	2014-01-13 12:42:46 +0000
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data noupdate="1">
+
+
+<record id="sdd_mandate_seq_type" model="ir.sequence.type">
+    <field name="name">SDD Mandate Reference</field>
+    <field name="code">sdd.mandate.reference</field>
+</record>
+
+<record id="sdd_mandate_seq" model="ir.sequence">
+    <field name="name">SDD Mandate Reference</field>
+    <field name="code">sdd.mandate.reference</field>
+    <field name="prefix">RUM</field>
+    <field name="padding" eval="7"/>
+    <!-- remember that max size for the mandate ref is 35 -->
+</record>
+
+
+</data>
+</openerp>
 
=== added file 'account_banking_sepa_direct_debit/data/pain.008.001.02.xsd'
--- account_banking_sepa_direct_debit/data/pain.008.001.02.xsd	1970-01-01 00:00:00 +0000
+++ account_banking_sepa_direct_debit/data/pain.008.001.02.xsd	2014-01-13 12:42:46 +0000
@@ -0,0 +1,879 @@
+<?xml version="1.0" encoding="UTF-8" standalone="no"?>
+<!--Generated by SWIFTStandards Workstation (build:R6.1.0.2) on 2009 Jan 08 17:30:53-->
+<xs:schema xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" targetNamespace="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02">
+    <xs:element name="Document" type="Document"/>
+    <xs:complexType name="AccountIdentification4Choice">
+        <xs:sequence>
+            <xs:choice>
+                <xs:element name="IBAN" type="IBAN2007Identifier"/>
+                <xs:element name="Othr" type="GenericAccountIdentification1"/>
+            </xs:choice>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="AccountSchemeName1Choice">
+        <xs:sequence>
+            <xs:choice>
+                <xs:element name="Cd" type="ExternalAccountIdentification1Code"/>
+                <xs:element name="Prtry" type="Max35Text"/>
+            </xs:choice>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:simpleType name="ActiveOrHistoricCurrencyAndAmount_SimpleType">
+        <xs:restriction base="xs:decimal">
+            <xs:minInclusive value="0"/>
+            <xs:fractionDigits value="5"/>
+            <xs:totalDigits value="18"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:complexType name="ActiveOrHistoricCurrencyAndAmount">
+        <xs:simpleContent>
+            <xs:extension base="ActiveOrHistoricCurrencyAndAmount_SimpleType">
+                <xs:attribute name="Ccy" type="ActiveOrHistoricCurrencyCode" use="required"/>
+            </xs:extension>
+        </xs:simpleContent>
+    </xs:complexType>
+    <xs:simpleType name="ActiveOrHistoricCurrencyCode">
+        <xs:restriction base="xs:string">
+            <xs:pattern value="[A-Z]{3,3}"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:simpleType name="AddressType2Code">
+        <xs:restriction base="xs:string">
+            <xs:enumeration value="ADDR"/>
+            <xs:enumeration value="PBOX"/>
+            <xs:enumeration value="HOME"/>
+            <xs:enumeration value="BIZZ"/>
+            <xs:enumeration value="MLTO"/>
+            <xs:enumeration value="DLVY"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:complexType name="AmendmentInformationDetails6">
+        <xs:sequence>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlMndtId" type="Max35Text"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlCdtrSchmeId" type="PartyIdentification32"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlCdtrAgt" type="BranchAndFinancialInstitutionIdentification4"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlCdtrAgtAcct" type="CashAccount16"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlDbtr" type="PartyIdentification32"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlDbtrAcct" type="CashAccount16"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlDbtrAgt" type="BranchAndFinancialInstitutionIdentification4"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlDbtrAgtAcct" type="CashAccount16"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlFnlColltnDt" type="ISODate"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="OrgnlFrqcy" type="Frequency1Code"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:simpleType name="AnyBICIdentifier">
+        <xs:restriction base="xs:string">
+            <xs:pattern value="[A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1}"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:complexType name="Authorisation1Choice">
+        <xs:sequence>
+            <xs:choice>
+                <xs:element name="Cd" type="Authorisation1Code"/>
+                <xs:element name="Prtry" type="Max128Text"/>
+            </xs:choice>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:simpleType name="Authorisation1Code">
+        <xs:restriction base="xs:string">
+            <xs:enumeration value="AUTH"/>
+            <xs:enumeration value="FDET"/>
+            <xs:enumeration value="FSUM"/>
+            <xs:enumeration value="ILEV"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:simpleType name="BICIdentifier">
+        <xs:restriction base="xs:string">
+            <xs:pattern value="[A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1}"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:simpleType name="BatchBookingIndicator">
+        <xs:restriction base="xs:boolean"/>
+    </xs:simpleType>
+    <xs:complexType name="BranchAndFinancialInstitutionIdentification4">
+        <xs:sequence>
+            <xs:element name="FinInstnId" type="FinancialInstitutionIdentification7"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="BrnchId" type="BranchData2"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="BranchData2">
+        <xs:sequence>
+            <xs:element maxOccurs="1" minOccurs="0" name="Id" type="Max35Text"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Nm" type="Max140Text"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="PstlAdr" type="PostalAddress6"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="CashAccount16">
+        <xs:sequence>
+            <xs:element name="Id" type="AccountIdentification4Choice"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Tp" type="CashAccountType2"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Ccy" type="ActiveOrHistoricCurrencyCode"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Nm" type="Max70Text"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="CashAccountType2">
+        <xs:sequence>
+            <xs:choice>
+                <xs:element name="Cd" type="CashAccountType4Code"/>
+                <xs:element name="Prtry" type="Max35Text"/>
+            </xs:choice>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:simpleType name="CashAccountType4Code">
+        <xs:restriction base="xs:string">
+            <xs:enumeration value="CASH"/>
+            <xs:enumeration value="CHAR"/>
+            <xs:enumeration value="COMM"/>
+            <xs:enumeration value="TAXE"/>
+            <xs:enumeration value="CISH"/>
+            <xs:enumeration value="TRAS"/>
+            <xs:enumeration value="SACC"/>
+            <xs:enumeration value="CACC"/>
+            <xs:enumeration value="SVGS"/>
+            <xs:enumeration value="ONDP"/>
+            <xs:enumeration value="MGLD"/>
+            <xs:enumeration value="NREX"/>
+            <xs:enumeration value="MOMA"/>
+            <xs:enumeration value="LOAN"/>
+            <xs:enumeration value="SLRY"/>
+            <xs:enumeration value="ODFT"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:complexType name="CategoryPurpose1Choice">
+        <xs:sequence>
+            <xs:choice>
+                <xs:element name="Cd" type="ExternalCategoryPurpose1Code"/>
+                <xs:element name="Prtry" type="Max35Text"/>
+            </xs:choice>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:simpleType name="ChargeBearerType1Code">
+        <xs:restriction base="xs:string">
+            <xs:enumeration value="DEBT"/>
+            <xs:enumeration value="CRED"/>
+            <xs:enumeration value="SHAR"/>
+            <xs:enumeration value="SLEV"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:complexType name="ClearingSystemIdentification2Choice">
+        <xs:sequence>
+            <xs:choice>
+                <xs:element name="Cd" type="ExternalClearingSystemIdentification1Code"/>
+                <xs:element name="Prtry" type="Max35Text"/>
+            </xs:choice>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="ClearingSystemMemberIdentification2">
+        <xs:sequence>
+            <xs:element maxOccurs="1" minOccurs="0" name="ClrSysId" type="ClearingSystemIdentification2Choice"/>
+            <xs:element name="MmbId" type="Max35Text"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="ContactDetails2">
+        <xs:sequence>
+            <xs:element maxOccurs="1" minOccurs="0" name="NmPrfx" type="NamePrefix1Code"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Nm" type="Max140Text"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="PhneNb" type="PhoneNumber"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="MobNb" type="PhoneNumber"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="FaxNb" type="PhoneNumber"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="EmailAdr" type="Max2048Text"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Othr" type="Max35Text"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:simpleType name="CountryCode">
+        <xs:restriction base="xs:string">
+            <xs:pattern value="[A-Z]{2,2}"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:simpleType name="CreditDebitCode">
+        <xs:restriction base="xs:string">
+            <xs:enumeration value="CRDT"/>
+            <xs:enumeration value="DBIT"/>
+        </xs:restriction>
+    </xs:simpleType>
+    <xs:complexType name="CreditorReferenceInformation2">
+        <xs:sequence>
+            <xs:element maxOccurs="1" minOccurs="0" name="Tp" type="CreditorReferenceType2"/>
+            <xs:element maxOccurs="1" minOccurs="0" name="Ref" type="Max35Text"/>
+        </xs:sequence>
+    </xs:complexType>
+    <xs:complexType name="CreditorReferenceType1Choice">