Merge lp:~camptocamp/banking-addons/bank-statement-reconcile_vre into lp:banking-addons/6.1

[Vincent Renaville@camptocamp]

This fix prevent account_advanced_reconcile to crash if ref in the move is not set

Unmerged revisions

93. By Vincent Renaville@camptocamp on 2013-06-07

[FIX] prevent crash if move ref is null

92. By Nicolas Bessi - Camptocamp on 2013-05-24

[MRG] [FIX] Restore default period in bank statement by taking context in account

91. By Nicolas Bessi - Camptocamp on 2013-05-10

[MRG] [IMP] Refine partner label lookup error message
[FIX] Restore error message in log
[FIX] Fix partner label lookup regexp

90. By Nicolas Bessi - Camptocamp on 2013-04-25

[MRG] Major refactoring of statement import and completion:

Fix the way to look default account on partner:
- If master account is provided in profile it will be forced
 - If the customer checkbox is checked on the found partner, type and account will be customer and receivable
 - If the supplier checkbox is checked on the found partner, type and account will be supplier and payable
 - If both checkbox are checked or none of them, it'll be based on the amount :
    If amount is positif the type and account will be customer and receivable,
    If amount is negativ, the type and account will be supplier and payable

Completion:
-Fix and refactor the the invoices lookup for completion
-Various fixes in completion rules
- Non matches lines are not mark as completed.

Optimisation:

Refactoring of statement import:
We by pass ORM to increase performances.
TODO support of sparse field

Refactoring of completion.
We have done some structural changes in order to avoid a lot of un needed call to ORM.
Bypass orm when writing to database.

These merge is required in order to fix transaction id completion rules and import +
Handle the new semantic change in OpenERP partner model

89. By Alexandre Fayolle - camptocamp on 2013-03-28

[FIX] permissions on account.statement.profil: an accountant needs write access on the model to be able to import a bank statement

  otherwise, the message.post call fails

88. By Nicolas Bessi - Camptocamp on 2013-03-22

[MRG] Fixes performance trouble when using bank_statement_label based completion rules by using memoizer pattern.

Add lines in context to be able to acces them in completion rules. It is not
mandatory as we can do line.satement_id.line_ids but it is more efficient.

Some minor cleanup

87. By Nicolas Bessi - Camptocamp on 2013-03-18

[MRG] Improve statement import wizard by using mass writing of statement line in order to avoid store field loop computation.

86. By Nicolas Bessi - Camptocamp on 2013-03-18

[MRG] Improve statement import global usability by retuning usable error message while parsing files.
Allows empty value for float in parsed CSV.

Added note about the additional dependency on python-xlrd in the description.

85. By Nicolas Bessi - Camptocamp on 2013-03-07

[MRG] Add a completion rule to allows supplier invoice completion baser on invoice number

84. By Nicolas Bessi - Camptocamp on 2013-03-07

[MRG] Adds two add-ons that prevent voucher to interfer with the statement ext related add-ons flow

=== added directory 'account_advanced_reconcile'
=== added file 'account_advanced_reconcile/__init__.py'
--- account_advanced_reconcile/__init__.py	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,24 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright 2012 Camptocamp SA
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import easy_reconcile
+import base_advanced_reconciliation
+import advanced_reconciliation
 
=== added file 'account_advanced_reconcile/__openerp__.py'
--- account_advanced_reconcile/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/__openerp__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,83 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright 2012 Camptocamp SA
+#
+#    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': "Advanced Reconcile",
+ 'version': '1.0',
+ 'author': 'Camptocamp',
+ 'maintainer': 'Camptocamp',
+ 'category': 'Finance',
+ 'complexity': 'normal',
+ 'depends': ['account_easy_reconcile',
+             ],
+ 'description': """
+Advanced reconciliation methods for the module account_easy_reconcile.
+
+In addition to the features implemented in account_easy_reconcile, which are:
+ - reconciliation facilities for big volume of transactions
+ - setup different profiles of reconciliation by account
+ - each profile can use many methods of reconciliation
+ - this module is also a base to create others reconciliation methods
+    which can plug in the profiles
+ - a profile a reconciliation can be run manually or by a cron
+ - monitoring of reconcilation runs with an history
+
+It implements a basis to created advanced reconciliation methods in a few lines
+of code.
+
+Typically, such a method can be:
+ - Reconcile Journal items if the partner and the ref are equal
+ - Reconcile Journal items if the partner is equal and the ref
+   is the same than ref or name
+ - Reconcile Journal items if the partner is equal and the ref
+   match with a pattern
+
+And they allows:
+ - Reconciliations with multiple credit / multiple debit lines
+ - Partial reconciliations
+ - Write-off amount as well
+
+A method is already implemented in this module, it matches on items:
+ - Partner
+ - Ref on credit move lines should be case insensitive equals to the ref or
+   the name of the debit move line
+
+The base class to find the reconciliations is built to be as efficient as
+possible.
+
+So basically, if you have an invoice with 3 payments (one per month), the first
+month, it will partial reconcile the debit move line with the first payment, the second
+month, it will partial reconcile the debit move line with 2 first payments,
+the third month, it will make the full reconciliation.
+
+This module is perfectly adapted for E-Commerce business where a big volume of
+move lines and so, reconciliations, are involved and payments often come from
+many offices.
+
+ """,
+ 'website': 'http://www.camptocamp.com',
+ 'data': ['easy_reconcile_view.xml'],
+ 'test': [],
+ 'images': [],
+ 'installable': True,
+ 'auto_install': False,
+ 'license': 'AGPL-3',
+ 'application': True,
+}
 
=== added file 'account_advanced_reconcile/advanced_reconciliation.py'
--- account_advanced_reconcile/advanced_reconciliation.py	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/advanced_reconciliation.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,118 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright 2012 Camptocamp SA
+#
+#    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
+
+
+class easy_reconcile_advanced_ref(orm.TransientModel):
+
+    _name = 'easy.reconcile.advanced.ref'
+    _inherit = 'easy.reconcile.advanced'
+
+    def _skip_line(self, cr, uid, rec, move_line, context=None):
+        """
+        When True is returned on some conditions, the credit move line
+        will be skipped for reconciliation. Can be inherited to
+        skip on some conditions. ie: ref or partner_id is empty.
+        """
+        return not (move_line.get('ref') and move_line.get('partner_id'))
+
+    def _matchers(self, cr, uid, rec, move_line, context=None):
+        """
+        Return the values used as matchers to find the opposite lines
+
+        All the matcher keys in the dict must have their equivalent in
+        the `_opposite_matchers`.
+
+        The values of each matcher key will be searched in the
+        one returned by the `_opposite_matchers`
+
+        Must be inherited to implement the matchers for one method
+
+        For instance, it can return:
+        return ('ref', move_line['rec'])
+
+        or
+        return (('partner_id', move_line['partner_id']),
+                ('ref', "prefix_%s" % move_line['rec']))
+
+        All the matchers have to be found in the opposite lines
+        to consider them as "opposite"
+
+        The matchers will be evaluated in the same order as declared
+        vs the the opposite matchers, so you can gain performance by
+        declaring first the partners with the less computation.
+
+        All matchers should match with their opposite to be considered
+        as "matching".
+        So with the previous example, partner_id and ref have to be
+        equals on the opposite line matchers.
+
+        :return: tuple of tuples (key, value) where the keys are
+            the matchers keys
+            (must be the same than `_opposite_matchers` returns,
+            and their values to match in the opposite lines.
+            A matching key can have multiples values.
+        """
+        return (('partner_id', move_line['partner_id']),
+                ('ref', move_line['ref'].lower().strip()))
+
+    def _opposite_matchers(self, cr, uid, rec, move_line, context=None):
+        """
+        Return the values of the opposite line used as matchers
+        so the line is matched
+
+        Must be inherited to implement the matchers for one method
+        It can be inherited to apply some formatting of fields
+        (strip(), lower() and so on)
+
+        This method is the counterpart of the `_matchers()` method.
+
+        Each matcher has to yield its value respecting the order
+        of the `_matchers()`.
+
+        When a matcher does not correspond, the next matchers won't
+        be evaluated so the ones which need the less computation
+        have to be executed first.
+
+        If the `_matchers()` returns:
+        (('partner_id', move_line['partner_id']),
+         ('ref', move_line['ref']))
+
+        Here, you should yield :
+        yield ('partner_id', move_line['partner_id'])
+        yield ('ref', move_line['ref'])
+
+        Note that a matcher can contain multiple values, as instance,
+        if for a move line, you want to search from its `ref` in the
+        `ref` or `name` fields of the opposite move lines, you have to
+        yield ('partner_id', move_line['partner_id'])
+        yield ('ref', (move_line['ref'], move_line['name'])
+
+        An OR is used between the values for the same key.
+        An AND is used between the differents keys.
+
+        :param dict move_line: values of the move_line
+        :yield: matchers as tuple ('matcher key', value(s))
+        """
+        yield ('partner_id', move_line['partner_id'])
+        yield ('ref', ((move_line['ref'] or '').lower().strip(),
+                       move_line['name'].lower().strip()))
 
=== added file 'account_advanced_reconcile/base_advanced_reconciliation.py'
--- account_advanced_reconcile/base_advanced_reconciliation.py	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/base_advanced_reconciliation.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,272 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright 2012 Camptocamp SA
+#
+#    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 itertools import product
+from openerp.osv import orm
+
+
+class easy_reconcile_advanced(orm.AbstractModel):
+
+    _name = 'easy.reconcile.advanced'
+    _inherit = 'easy.reconcile.base'
+
+    def _query_debit(self, cr, uid, rec, context=None):
+        """Select all move (debit>0) as candidate. """
+        select = self._select(rec)
+        sql_from = self._from(rec)
+        where, params = self._where(rec)
+        where += " AND account_move_line.debit > 0 "
+
+        where2, params2 = self._get_filter(cr, uid, rec, context=context)
+
+        query = ' '.join((select, sql_from, where, where2))
+
+        cr.execute(query, params + params2)
+        return cr.dictfetchall()
+
+    def _query_credit(self, cr, uid, rec, context=None):
+        """Select all move (credit>0) as candidate. """
+        select = self._select(rec)
+        sql_from = self._from(rec)
+        where, params = self._where(rec)
+        where += " AND account_move_line.credit > 0 "
+
+        where2, params2 = self._get_filter(cr, uid, rec, context=context)
+
+        query = ' '.join((select, sql_from, where, where2))
+
+        cr.execute(query, params + params2)
+        return cr.dictfetchall()
+
+    def _matchers(self, cr, uid, rec, move_line, context=None):
+        """
+        Return the values used as matchers to find the opposite lines
+
+        All the matcher keys in the dict must have their equivalent in
+        the `_opposite_matchers`.
+
+        The values of each matcher key will be searched in the
+        one returned by the `_opposite_matchers`
+
+        Must be inherited to implement the matchers for one method
+
+        As instance, it can return:
+        return ('ref', move_line['rec'])
+
+        or
+        return (('partner_id', move_line['partner_id']),
+                ('ref', "prefix_%s" % move_line['rec']))
+
+        All the matchers have to be found in the opposite lines
+        to consider them as "opposite"
+
+        The matchers will be evaluated in the same order as declared
+        vs the the opposite matchers, so you can gain performance by
+        declaring first the partners with the less computation.
+
+        All matchers should match with their opposite to be considered
+        as "matching".
+        So with the previous example, partner_id and ref have to be
+        equals on the opposite line matchers.
+
+        :return: tuple of tuples (key, value) where the keys are
+            the matchers keys
+            (must be the same than `_opposite_matchers` returns,
+            and their values to match in the opposite lines.
+            A matching key can have multiples values.
+        """
+        raise NotImplementedError
+
+    def _opposite_matchers(self, cr, uid, rec, move_line, context=None):
+        """
+        Return the values of the opposite line used as matchers
+        so the line is matched
+
+        Must be inherited to implement the matchers for one method
+        It can be inherited to apply some formatting of fields
+        (strip(), lower() and so on)
+
+        This method is the counterpart of the `_matchers()` method.
+
+        Each matcher has to yield its value respecting the order
+        of the `_matchers()`.
+
+        When a matcher does not correspond, the next matchers won't
+        be evaluated so the ones which need the less computation
+        have to be executed first.
+
+        If the `_matchers()` returns:
+        (('partner_id', move_line['partner_id']),
+         ('ref', move_line['ref']))
+
+        Here, you should yield :
+        yield ('partner_id', move_line['partner_id'])
+        yield ('ref', move_line['ref'])
+
+        Note that a matcher can contain multiple values, as instance,
+        if for a move line, you want to search from its `ref` in the
+        `ref` or `name` fields of the opposite move lines, you have to
+        yield ('partner_id', move_line['partner_id'])
+        yield ('ref', (move_line['ref'], move_line['name'])
+
+        An OR is used between the values for the same key.
+        An AND is used between the differents keys.
+
+        :param dict move_line: values of the move_line
+        :yield: matchers as tuple ('matcher key', value(s))
+        """
+        raise NotImplementedError
+
+    @staticmethod
+    def _compare_values(key, value, opposite_value):
+        """Can be inherited to modify the equality condition
+        specifically according to the matcher key (maybe using
+        a like operator instead of equality on 'ref' as instance)
+        """
+        # consider that empty vals are not valid matchers
+        # it can still be inherited for some special cases
+        # where it would be allowed
+        if not (value and opposite_value):
+            return False
+
+        if value == opposite_value:
+            return True
+        return False
+
+    @staticmethod
+    def _compare_matcher_values(key, values, opposite_values):
+        """ Compare every values from a matcher vs an opposite matcher
+        and return True if it matches
+        """
+        for value, ovalue in product(values, opposite_values):
+            # we do not need to compare all values, if one matches
+            # we are done
+            if easy_reconcile_advanced._compare_values(key, value, ovalue):
+                return True
+        return False
+
+    @staticmethod
+    def _compare_matchers(matcher, opposite_matcher):
+        """
+        Prepare and check the matchers to compare
+        """
+        mkey, mvalue = matcher
+        omkey, omvalue = opposite_matcher
+        assert mkey == omkey, ("A matcher %s is compared with a matcher %s, "
+                " the _matchers and _opposite_matchers are probably wrong" %
+                (mkey, omkey))
+        if not isinstance(mvalue, (list, tuple)):
+            mvalue = mvalue,
+        if not isinstance(omvalue, (list, tuple)):
+            omvalue = omvalue,
+        return easy_reconcile_advanced._compare_matcher_values(mkey, mvalue, omvalue)
+
+    def _compare_opposite(self, cr, uid, rec, move_line, opposite_move_line,
+                          matchers, context=None):
+        """ Iterate over the matchers of the move lines vs opposite move lines
+        and if they all match, return True.
+
+        If all the matchers match for a move line and an opposite move line,
+        they are candidate for a reconciliation.
+        """
+        opp_matchers = self._opposite_matchers(cr, uid, rec, opposite_move_line,
+                context=context)
+        for matcher in matchers:
+            try:
+                opp_matcher = opp_matchers.next()
+            except StopIteration:
+                # if you fall here, you probably missed to put a `yield`
+                # in `_opposite_matchers()`
+                raise ValueError("Missing _opposite_matcher: %s" % matcher[0])
+
+            if not self._compare_matchers(matcher, opp_matcher):
+                # if any of the matcher fails, the opposite line
+                # is not a valid counterpart
+                # directly returns so the next yield of _opposite_matchers
+                # are not evaluated
+                return False
+
+        return True
+
+    def _search_opposites(self, cr, uid, rec, move_line, opposite_move_lines, context=None):
+        """
+        Search the opposite move lines for a move line
+
+        :param dict move_line: the move line for which we search opposites
+        :param list opposite_move_lines: list of dict of move lines values, the move
+            lines we want to search for
+        :return: list of matching lines
+        """
+        matchers = self._matchers(cr, uid, rec, move_line, context=context)
+        return [op for op in opposite_move_lines if
+                self._compare_opposite(
+                    cr, uid, rec, move_line, op, matchers, context=context)]
+
+    def _action_rec(self, cr, uid, rec, context=None):
+        credit_lines = self._query_credit(cr, uid, rec, context=context)
+        debit_lines = self._query_debit(cr, uid, rec, context=context)
+        return self._rec_auto_lines_advanced(
+                cr, uid, rec, credit_lines, debit_lines, context=context)
+
+    def _skip_line(self, cr, uid, rec, move_line, context=None):
+        """
+        When True is returned on some conditions, the credit move line
+        will be skipped for reconciliation. Can be inherited to
+        skip on some conditions. ie: ref or partner_id is empty.
+        """
+        return False
+
+    def _rec_auto_lines_advanced(self, cr, uid, rec, credit_lines, debit_lines, context=None):
+        """ Advanced reconciliation main loop """
+        reconciled_ids = []
+        partial_reconciled_ids = []
+        reconcile_groups = []
+
+        for credit_line in credit_lines:
+            if self._skip_line(cr, uid, rec, credit_line, context=context):
+                continue
+
+            opposite_lines = self._search_opposites(
+                cr, uid, rec, credit_line, debit_lines, context=context)
+
+            if not opposite_lines:
+                continue
+
+            opposite_ids = [l['id'] for l in opposite_lines]
+            line_ids = opposite_ids + [credit_line['id']]
+            for group in reconcile_groups:
+                if any([lid in group for lid in opposite_ids]):
+                    group.update(line_ids)
+                    break
+            else:
+                reconcile_groups.append(set(line_ids))
+
+        lines_by_id = dict([(l['id'], l) for l in credit_lines + debit_lines])
+        for reconcile_group_ids in reconcile_groups:
+            group_lines = [lines_by_id[lid] for lid in reconcile_group_ids]
+            reconciled, full = self._reconcile_lines(
+                cr, uid, rec, group_lines, allow_partial=True, context=context)
+            if reconciled and full:
+                reconciled_ids += reconcile_group_ids
+            elif reconciled:
+                partial_reconciled_ids += reconcile_group_ids
+
+        return reconciled_ids, partial_reconciled_ids
 
=== added file 'account_advanced_reconcile/easy_reconcile.py'
--- account_advanced_reconcile/easy_reconcile.py	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/easy_reconcile.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,36 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright 2012 Camptocamp SA
+#
+#    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
+
+
+class account_easy_reconcile_method(orm.Model):
+
+    _inherit = 'account.easy.reconcile.method'
+
+    def _get_all_rec_method(self, cr, uid, context=None):
+        methods = super(account_easy_reconcile_method, self).\
+            _get_all_rec_method(cr, uid, context=context)
+        methods += [
+            ('easy.reconcile.advanced.ref',
+             'Advanced. Partner and Ref.'),
+        ]
+        return methods
 
=== added file 'account_advanced_reconcile/easy_reconcile_view.xml'
--- account_advanced_reconcile/easy_reconcile_view.xml	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/easy_reconcile_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,19 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data noupdate="0">
+      <record id="view_easy_reconcile_form" model="ir.ui.view">
+          <field name="name">account.easy.reconcile.form</field>
+          <field name="model">account.easy.reconcile</field>
+          <field name="inherit_id" ref="account_easy_reconcile.account_easy_reconcile_form"/>
+          <field name="arch" type="xml">
+              <page name="information" position="inside">
+                <group colspan="2" col="2">
+                    <separator colspan="4" string="Advanced. Partner and Ref"/>
+                    <label string="Match multiple debit vs multiple credit entries. Allow partial reconciliation.
+The lines should have the partner, the credit entry ref. is matched vs the debit entry ref. or name." colspan="4"/>
+                </group>
+              </page>
+          </field>
+      </record>
+    </data>
+</openerp>
 
=== added directory 'account_advanced_reconcile/i18n'
=== added file 'account_advanced_reconcile/i18n/fr.po'
--- account_advanced_reconcile/i18n/fr.po	1970-01-01 00:00:00 +0000
+++ account_advanced_reconcile/i18n/fr.po	2013-06-10 06:07:03 +0000
@@ -0,0 +1,91 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+# 	* account_advanced_reconcile
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.1\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2013-01-04 08:25+0000\n"
+"PO-Revision-Date: 2013-01-04 09:27+0100\n"
+"Last-Translator: Guewen Baconnier <[e-mail]>\n"
+"Language-Team: \n"
+"Language: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: \n"
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,partner_ids:0
+#: field:easy.reconcile.advanced.ref,partner_ids:0
+msgid "Restrict on partners"
+msgstr "Restriction sur les partenaires"
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,account_id:0
+#: field:easy.reconcile.advanced.ref,account_id:0
+msgid "Account"
+msgstr "Compte"
+
+#. module: account_advanced_reconcile
+#: model:ir.model,name:account_advanced_reconcile.model_account_easy_reconcile_method
+msgid "reconcile method for account_easy_reconcile"
+msgstr "Méthode de lettrage pour le module account_easy_reconcile"
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,journal_id:0
+#: field:easy.reconcile.advanced.ref,journal_id:0
+msgid "Journal"
+msgstr "Journal"
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,account_profit_id:0
+#: field:easy.reconcile.advanced.ref,account_profit_id:0
+msgid "Account Profit"
+msgstr "Compte de produit"
+
+#. module: account_advanced_reconcile
+#: view:account.easy.reconcile:0
+msgid "Match multiple debit vs multiple credit entries. Allow partial reconciliation. The lines should have the partner, the credit entry ref. is matched vs the debit entry ref. or name."
+msgstr "Le Lettrage peut s'effectuer sur plusieurs écritures de débit et crédit. Le Lettrage partiel est autorisé. Les écritures doivent avoir le même partenaire et la référence sur les écritures de crédit doit se retrouver dans la référence ou la description sur les écritures de débit."
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,filter:0
+#: field:easy.reconcile.advanced.ref,filter:0
+msgid "Filter"
+msgstr "Filtre"
+
+#. module: account_advanced_reconcile
+#: view:account.easy.reconcile:0
+msgid "Advanced. Partner and Ref"
+msgstr "Avancé. Partenaire et Réf."
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,date_base_on:0
+#: field:easy.reconcile.advanced.ref,date_base_on:0
+msgid "Date of reconciliation"
+msgstr "Date de lettrage"
+
+#. module: account_advanced_reconcile
+#: model:ir.model,name:account_advanced_reconcile.model_easy_reconcile_advanced
+msgid "easy.reconcile.advanced"
+msgstr "easy.reconcile.advanced"
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,account_lost_id:0
+#: field:easy.reconcile.advanced.ref,account_lost_id:0
+msgid "Account Lost"
+msgstr "Compte de charge"
+
+#. module: account_advanced_reconcile
+#: model:ir.model,name:account_advanced_reconcile.model_easy_reconcile_advanced_ref
+msgid "easy.reconcile.advanced.ref"
+msgstr "easy.reconcile.advanced.ref"
+
+#. module: account_advanced_reconcile
+#: field:easy.reconcile.advanced,write_off:0
+#: field:easy.reconcile.advanced.ref,write_off:0
+msgid "Write off allowed"
+msgstr "Écart autorisé"
+
 
=== added directory 'account_easy_reconcile'
=== added file 'account_easy_reconcile/__init__.py'
--- account_easy_reconcile/__init__.py	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright 2012 Camptocamp SA (Guewen Baconnier)
+#    Copyright (C) 2010   Sébastien Beau
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import easy_reconcile
+import base_reconciliation
+import simple_reconciliation
+import easy_reconcile_history
 
=== added file 'account_easy_reconcile/__openerp__.py'
--- account_easy_reconcile/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/__openerp__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,66 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright 2012 Camptocamp SA (Guewen Baconnier)
+#    Copyright (C) 2010   Sébastien Beau
+#
+#    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": "Easy Reconcile",
+    "version": "1.3.0",
+    "depends": ["account"],
+    "author": "Akretion,Camptocamp",
+    "description": """
+Easy Reconcile
+==============
+
+This is a shared work between Akretion and Camptocamp
+in order to provide:
+ - reconciliation facilities for big volume of transactions
+ - setup different profiles of reconciliation by account
+ - each profile can use many methods of reconciliation
+ - this module is also a base to create others
+   reconciliation methods which can plug in the profiles
+ - a profile a reconciliation can be run manually
+   or by a cron
+ - monitoring of reconciliation runs with an history
+   which keep track of the reconciled Journal items
+
+2 simple reconciliation methods are integrated
+in this module, the simple reconciliations works
+on 2 lines (1 debit / 1 credit) and do not allow
+partial reconcilation, they also match on 1 key,
+partner or Journal item name.
+
+You may be interested to install also the
+``account_advanced_reconciliation`` module.
+This latter add more complex reconciliations,
+allows multiple lines and partial.
+
+""",
+    "website": "http://www.akretion.com/",
+    "category": "Finance",
+    "demo_xml": [],
+    "data": ["easy_reconcile.xml",
+             "easy_reconcile_history_view.xml",
+             "security/ir_rule.xml",
+             "security/ir.model.access.csv"],
+    'license': 'AGPL-3',
+    "auto_install": False,
+    "installable": True,
+
+}
 
=== added file 'account_easy_reconcile/base_reconciliation.py'
--- account_easy_reconcile/base_reconciliation.py	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/base_reconciliation.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,208 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright 2012-2013 Camptocamp SA (Guewen Baconnier)
+#    Copyright (C) 2010   Sébastien Beau
+#
+#    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 fields, orm
+from operator import itemgetter, attrgetter
+
+
+class easy_reconcile_base(orm.AbstractModel):
+    """Abstract Model for reconciliation methods"""
+
+    _name = 'easy.reconcile.base'
+
+    _inherit = 'easy.reconcile.options'
+
+    _columns = {
+        'account_id': fields.many2one(
+            'account.account', 'Account', required=True),
+        'partner_ids': fields.many2many(
+            'res.partner', string="Restrict on partners"),
+        # other columns are inherited from easy.reconcile.options
+    }
+
+    def automatic_reconcile(self, cr, uid, ids, context=None):
+        """ Reconciliation method called from the view.
+
+        :return: list of reconciled ids, list of partially reconciled items
+        """
+        if isinstance(ids, (int, long)):
+            ids = [ids]
+        assert len(ids) == 1, "Has to be called on one id"
+        rec = self.browse(cr, uid, ids[0], context=context)
+        return self._action_rec(cr, uid, rec, context=context)
+
+    def _action_rec(self, cr, uid, rec, context=None):
+        """ Must be inherited to implement the reconciliation
+
+        :return: list of reconciled ids
+        """
+        raise NotImplementedError
+
+    def _base_columns(self, rec):
+        """ Mandatory columns for move lines queries
+        An extra column aliased as ``key`` should be defined
+        in each query."""
+        aml_cols = (
+            'id',
+            'debit',
+            'credit',
+            'date',
+            'period_id',
+            'ref',
+            'name',
+            'partner_id',
+            'account_id',
+            'move_id')
+        return ["account_move_line.%s" % col for col in aml_cols]
+
+    def _select(self, rec, *args, **kwargs):
+        return "SELECT %s" % ', '.join(self._base_columns(rec))
+
+    def _from(self, rec, *args, **kwargs):
+        return "FROM account_move_line"
+
+    def _where(self, rec, *args, **kwargs):
+        where = ("WHERE account_move_line.account_id = %s "
+                 "AND account_move_line.reconcile_id IS NULL ")
+        # it would be great to use dict for params
+        # but as we use _where_calc in _get_filter
+        # which returns a list, we have to
+        # accomodate with that
+        params = [rec.account_id.id]
+
+        if rec.partner_ids:
+            where += " AND account_move_line.partner_id IN %s"
+            params.append(tuple([l.id for l in rec.partner_ids]))
+        return where, params
+
+    def _get_filter(self, cr, uid, rec, context):
+        ml_obj = self.pool.get('account.move.line')
+        where = ''
+        params = []
+        if rec.filter:
+            dummy, where, params = ml_obj._where_calc(
+                cr, uid, eval(rec.filter), context=context).get_sql()
+            if where:
+                where = " AND %s" % where
+        return where, params
+
+    def _below_writeoff_limit(self, cr, uid, rec, lines,
+                              writeoff_limit, context=None):
+        precision = self.pool.get('decimal.precision').precision_get(
+            cr, uid, 'Account')
+        keys = ('debit', 'credit')
+        sums = reduce(
+            lambda line, memo:
+                dict((key, value + memo[key])
+                for key, value
+                in line.iteritems()
+                if key in keys), lines)
+
+        debit, credit = sums['debit'], sums['credit']
+        writeoff_amount = round(debit - credit, precision)
+        return bool(writeoff_limit >= abs(writeoff_amount)), debit, credit
+
+    def _get_rec_date(self, cr, uid, rec, lines,
+                      based_on='end_period_last_credit', context=None):
+        period_obj = self.pool.get('account.period')
+
+        def last_period(mlines):
+            period_ids = [ml['period_id'] for ml in mlines]
+            periods = period_obj.browse(
+                cr, uid, period_ids, context=context)
+            return max(periods, key=attrgetter('date_stop'))
+
+        def last_date(mlines):
+            return max(mlines, key=itemgetter('date'))
+
+        def credit(mlines):
+            return [l for l in mlines if l['credit'] > 0]
+
+        def debit(mlines):
+            return [l for l in mlines if l['debit'] > 0]
+
+        if based_on == 'end_period_last_credit':
+            return last_period(credit(lines)).date_stop
+        if based_on == 'end_period':
+            return last_period(lines).date_stop
+        elif based_on == 'newest':
+            return last_date(lines)['date']
+        elif based_on == 'newest_credit':
+            return last_date(credit(lines))['date']
+        elif based_on == 'newest_debit':
+            return last_date(debit(lines))['date']
+        # reconcilation date will be today
+        # when date is None
+        return None
+
+    def _reconcile_lines(self, cr, uid, rec, lines, allow_partial=False, context=None):
+        """ Try to reconcile given lines
+
+        :param list lines: list of dict of move lines, they must at least
+                           contain values for : id, debit, credit
+        :param boolean allow_partial: if True, partial reconciliation will be
+                                      created, otherwise only Full
+                                      reconciliation will be created
+        :return: tuple of boolean values, first item is wether the items
+                 have been reconciled or not,
+                 the second is wether the reconciliation is full (True)
+                 or partial (False)
+        """
+        if context is None:
+            context = {}
+
+        ml_obj = self.pool.get('account.move.line')
+        writeoff = rec.write_off
+
+        line_ids = [l['id'] for l in lines]
+        below_writeoff, sum_debit, sum_credit = self._below_writeoff_limit(
+            cr, uid, rec, lines, writeoff, context=context)
+        date = self._get_rec_date(
+            cr, uid, rec, lines, rec.date_base_on, context=context)
+
+        rec_ctx = dict(context, date_p=date)
+        if below_writeoff:
+            if sum_credit < sum_debit:
+                writeoff_account_id = rec.account_profit_id.id
+            else:
+                writeoff_account_id = rec.account_lost_id.id
+
+            period_id = self.pool.get('account.period').find(
+                cr, uid, dt=date, context=context)[0]
+
+            ml_obj.reconcile(
+                cr, uid,
+                line_ids,
+                type='auto',
+                writeoff_acc_id=writeoff_account_id,
+                writeoff_period_id=period_id,
+                writeoff_journal_id=rec.journal_id.id,
+                context=rec_ctx)
+            return True, True
+        elif allow_partial:
+            ml_obj.reconcile_partial(
+                cr, uid,
+                line_ids,
+                type='manual',
+                context=rec_ctx)
+            return True, False
+
+        return False, False
 
=== added file 'account_easy_reconcile/easy_reconcile.py'
--- account_easy_reconcile/easy_reconcile.py	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/easy_reconcile.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,285 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright 2012-2013 Camptocamp SA (Guewen Baconnier)
+#    Copyright (C) 2010   Sébastien Beau
+#
+#    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 fields, osv, orm
+from openerp.tools.translate import _
+from openerp.tools import DEFAULT_SERVER_DATETIME_FORMAT
+
+
+class easy_reconcile_options(orm.AbstractModel):
+    """Options of a reconciliation profile
+
+    Columns shared by the configuration of methods
+    and by the reconciliation wizards.
+    This allows decoupling of the methods and the
+    wizards and allows to launch the wizards alone
+    """
+
+    _name = 'easy.reconcile.options'
+
+    def _get_rec_base_date(self, cr, uid, context=None):
+        return [('end_period_last_credit', 'End of period of most recent credit'),
+                ('newest', 'Most recent move line'),
+                ('actual', 'Today'),
+                ('end_period', 'End of period of most recent move line'),
+                ('newest_credit', 'Date of most recent credit'),
+                ('newest_debit', 'Date of most recent debit')]
+
+    _columns = {
+            'write_off': fields.float('Write off allowed'),
+            'account_lost_id': fields.many2one(
+                'account.account', 'Account Lost'),
+            'account_profit_id': fields.many2one(
+                'account.account', 'Account Profit'),
+            'journal_id': fields.many2one(
+                'account.journal', 'Journal'),
+            'date_base_on': fields.selection(
+                _get_rec_base_date,
+                required=True,
+                string='Date of reconciliation'),
+            'filter': fields.char('Filter', size=128),
+    }
+
+    _defaults = {
+        'write_off': 0.,
+        'date_base_on': 'end_period_last_credit',
+    }
+
+
+class account_easy_reconcile_method(orm.Model):
+
+    _name = 'account.easy.reconcile.method'
+    _description = 'reconcile method for account_easy_reconcile'
+
+    _inherit = 'easy.reconcile.options'
+
+    _order = 'sequence'
+
+    def _get_all_rec_method(self, cr, uid, context=None):
+        return [
+            ('easy.reconcile.simple.name', 'Simple. Amount and Name'),
+            ('easy.reconcile.simple.partner', 'Simple. Amount and Partner'),
+            ('easy.reconcile.simple.reference', 'Simple. Amount and Reference'),
+            ]
+
+    def _get_rec_method(self, cr, uid, context=None):
+        return self._get_all_rec_method(cr, uid, context=None)
+
+    _columns = {
+            'name': fields.selection(
+                _get_rec_method, 'Type', required=True),
+            'sequence': fields.integer(
+                'Sequence',
+                required=True,
+                help="The sequence field is used to order "
+                     "the reconcile method"),
+            'task_id': fields.many2one(
+                'account.easy.reconcile',
+                string='Task',
+                required=True,
+                ondelete='cascade'),
+            'company_id': fields.related('task_id','company_id',
+                                         relation='res.company',
+                                         type='many2one',
+                                         string='Company',
+                                         store=True,
+                                         readonly=True),
+    }
+
+    _defaults = {
+        'sequence': 1,
+    }
+
+    def init(self, cr):
+        """ Migration stuff
+
+        Name is not anymore methods names but the name
+        of the model which does the reconciliation
+        """
+        cr.execute("""
+        UPDATE account_easy_reconcile_method
+        SET name = 'easy.reconcile.simple.partner'
+        WHERE name = 'action_rec_auto_partner'
+        """)
+        cr.execute("""
+        UPDATE account_easy_reconcile_method
+        SET name = 'easy.reconcile.simple.name'
+        WHERE name = 'action_rec_auto_name'
+        """)
+
+
+class account_easy_reconcile(orm.Model):
+
+    _name = 'account.easy.reconcile'
+    _description = 'account easy reconcile'
+
+    def _get_total_unrec(self, cr, uid, ids, name, arg, context=None):
+        obj_move_line = self.pool.get('account.move.line')
+        res = {}
+        for task in self.browse(cr, uid, ids, context=context):
+            res[task.id] = len(obj_move_line.search(
+                cr, uid,
+                [('account_id', '=', task.account.id),
+                 ('reconcile_id', '=', False),
+                 ('reconcile_partial_id', '=', False)],
+                context=context))
+        return res
+
+    def _get_partial_rec(self, cr, uid, ids, name, arg, context=None):
+        obj_move_line = self.pool.get('account.move.line')
+        res = {}
+        for task in self.browse(cr, uid, ids, context=context):
+            res[task.id] = len(obj_move_line.search(
+                cr, uid,
+                [('account_id', '=', task.account.id),
+                 ('reconcile_id', '=', False),
+                 ('reconcile_partial_id', '!=', False)],
+                context=context))
+        return res
+
+    def _last_history(self, cr, uid, ids, name, args, context=None):
+        result = {}
+        for history in self.browse(cr, uid, ids, context=context):
+            result[history.id] = False
+            if history.history_ids:
+                # history is sorted by date desc
+                result[history.id] = history.history_ids[0].id
+        return result
+
+    _columns = {
+        'name': fields.char('Name', required=True),
+        'account': fields.many2one(
+            'account.account', 'Account', required=True),
+        'reconcile_method': fields.one2many(
+            'account.easy.reconcile.method', 'task_id', 'Method'),
+        'unreconciled_count': fields.function(
+            _get_total_unrec, type='integer', string='Unreconciled Items'),
+        'reconciled_partial_count': fields.function(
+            _get_partial_rec,
+            type='integer',
+            string='Partially Reconciled Items'),
+        'history_ids': fields.one2many(
+            'easy.reconcile.history',
+            'easy_reconcile_id',
+            string='History',
+            readonly=True),
+        'last_history':
+            fields.function(
+                _last_history,
+                string='Last History',
+                type='many2one',
+                relation='easy.reconcile.history',
+                readonly=True),
+        'company_id': fields.many2one('res.company', 'Company'),
+    }
+
+    def _prepare_run_transient(self, cr, uid, rec_method, context=None):
+        return {'account_id': rec_method.task_id.account.id,
+                'write_off': rec_method.write_off,
+                'account_lost_id': (rec_method.account_lost_id and
+                                    rec_method.account_lost_id.id),
+                'account_profit_id': (rec_method.account_profit_id and
+                                      rec_method.account_profit_id.id),
+                'journal_id': (rec_method.journal_id and
+                               rec_method.journal_id.id),
+                'date_base_on': rec_method.date_base_on,
+                'filter': rec_method.filter}
+
+    def run_reconcile(self, cr, uid, ids, context=None):
+        def find_reconcile_ids(fieldname, move_line_ids):
+            if not move_line_ids:
+                return []
+            sql = ("SELECT DISTINCT " + fieldname +
+                   " FROM account_move_line "
+                   " WHERE id in %s "
+                   " AND " + fieldname + " IS NOT NULL")
+            cr.execute(sql, (tuple(move_line_ids),))
+            res = cr.fetchall()
+            return [row[0] for row in res]
+
+        for rec in self.browse(cr, uid, ids, context=context):
+            all_ml_rec_ids = []
+            all_ml_partial_ids = []
+
+            for method in rec.reconcile_method:
+                rec_model = self.pool.get(method.name)
+                auto_rec_id = rec_model.create(
+                    cr, uid,
+                    self._prepare_run_transient(
+                        cr, uid, method, context=context),
+                    context=context)
+
+                ml_rec_ids, ml_partial_ids = rec_model.automatic_reconcile(
+                    cr, uid, auto_rec_id, context=context)
+
+                all_ml_rec_ids += ml_rec_ids
+                all_ml_partial_ids += ml_partial_ids
+
+            reconcile_ids = find_reconcile_ids(
+                    'reconcile_id', all_ml_rec_ids)
+            partial_ids = find_reconcile_ids(
+                    'reconcile_partial_id', all_ml_partial_ids)
+
+            self.pool.get('easy.reconcile.history').create(
+                cr,
+                uid,
+                {'easy_reconcile_id': rec.id,
+                 'date': fields.datetime.now(),
+                 'reconcile_ids': [(4, rid) for rid in reconcile_ids],
+                 'reconcile_partial_ids': [(4, rid) for rid in partial_ids]},
+                context=context)
+        return True
+
+    def _no_history(self, cr, uid, rec, context=None):
+        """ Raise an `osv.except_osv` error, supposed to
+        be called when there is no history on the reconciliation
+        task.
+        """
+        raise osv.except_osv(
+                _('Error'),
+                _('There is no history of reconciled '
+                  'items on the task: %s.') % rec.name)
+
+    def last_history_reconcile(self, cr, uid, rec_id, context=None):
+        """ Get the last history record for this reconciliation profile
+        and return the action which opens move lines reconciled
+        """
+        if isinstance(rec_id, (tuple, list)):
+            assert len(rec_id) == 1, \
+                    "Only 1 id expected"
+            rec_id = rec_id[0]
+        rec = self.browse(cr, uid, rec_id, context=context)
+        if not rec.last_history:
+            self._no_history(cr, uid, rec, context=context)
+        return rec.last_history.open_reconcile()
+
+    def last_history_partial(self, cr, uid, rec_id, context=None):
+        """ Get the last history record for this reconciliation profile
+        and return the action which opens move lines reconciled
+        """
+        if isinstance(rec_id, (tuple, list)):
+            assert len(rec_id) == 1, \
+                    "Only 1 id expected"
+            rec_id = rec_id[0]
+        rec = self.browse(cr, uid, rec_id, context=context)
+        if not rec.last_history:
+            self._no_history(cr, uid, rec, context=context)
+        return rec.last_history.open_partial()
 
=== added file 'account_easy_reconcile/easy_reconcile.xml'
--- account_easy_reconcile/easy_reconcile.xml	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/easy_reconcile.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,156 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<openerp>
+<data>
+
+    <!-- account.easy.reconcile view -->
+    <record id="account_easy_reconcile_form" model="ir.ui.view">
+        <field name="name">account.easy.reconcile.form</field>
+        <field name="priority">20</field>
+        <field name="model">account.easy.reconcile</field>
+        <field name="arch" type="xml">
+            <form string="Automatic Easy Reconcile" version="7.0">
+                <header>
+                    <button name="run_reconcile" class="oe_highlight"
+                        string="Start Auto Reconciliation" type="object"/>
+                    <button icon="STOCK_JUMP_TO" name="last_history_reconcile"
+                        class="oe_highlight"
+                        string="Display items reconciled on the last run"
+                        type="object"/>
+                    <button icon="STOCK_JUMP_TO" name="last_history_partial"
+                        class="oe_highlight"
+                        string="Display items partially reconciled on the last run"
+                        type="object"/>
+                </header>
+                <sheet>
+                    <separator colspan="4" string="Profile Information" />
+                    <group>
+                        <group>
+                            <field name="name" select="1"/>
+                            <field name="account"/>
+                            <field name="company_id" groups="base.group_multi_company"/>
+                        </group>
+                        <group>
+                            <field name="unreconciled_count"/>
+                            <field name="reconciled_partial_count"/>
+                        </group>
+                    </group>
+                    <notebook colspan="4">
+                        <page name="methods" string="Configuration">
+                            <field name="reconcile_method" colspan = "4" nolabel="1"/>
+                        </page>
+                        <page name="history" string="History">
+                            <field name="history_ids" nolabel="1">
+                                <tree string="Automatic Easy Reconcile History">
+                                    <field name="date"/>
+                                    <button icon="STOCK_JUMP_TO" name="open_reconcile"
+                                        string="Go to reconciled items" type="object"/>
+                                    <button icon="STOCK_JUMP_TO" name="open_partial"
+                                        string="Go to partially reconciled items" type="object"/>
+                                </tree>
+                            </field>
+                        </page>
+                        <page name="information" string="Information">
+                          <separator colspan="4" string="Simple. Amount and Name"/>
+                          <label string="Match one debit line vs one credit line. Do not allow partial reconciliation.
+The lines should have the same amount (with the write-off) and the same name to be reconciled." colspan="4"/>
+
+                          <separator colspan="4" string="Simple. Amount and Partner"/>
+                          <label string="Match one debit line vs one credit line. Do not allow partial reconciliation.
+The lines should have the same amount (with the write-off) and the same partner to be reconciled." colspan="4"/>
+
+                          <separator colspan="4" string="Simple. Amount and Reference"/>
+                          <label string="Match one debit line vs one credit line. Do not allow partial reconciliation.
+The lines should have the same amount (with the write-off) and the same reference to be reconciled." colspan="4"/>
+
+                        </page>
+                    </notebook>
+                </sheet>
+            </form>
+        </field>
+    </record>
+
+    <record id="account_easy_reconcile_tree" model="ir.ui.view">
+        <field name="name">account.easy.reconcile.tree</field>
+        <field name="priority">20</field>
+        <field name="model">account.easy.reconcile</field>
+        <field name="arch" type="xml">
+            <tree string="Automatic Easy Reconcile">
+                <field name="name"/>
+                <field name="account"/>
+                <field name="company_id" groups="base.group_multi_company"/>
+                <field name="unreconciled_count"/>
+                <field name="reconciled_partial_count"/>
+                <button icon="gtk-ok" name="run_reconcile" colspan="4"
+                    string="Start Auto Reconcilation" type="object"/>
+                <button icon="STOCK_JUMP_TO" name="last_history_reconcile" colspan="2"
+                    string="Display items reconciled on the last run" type="object"/>
+                <button icon="STOCK_JUMP_TO" name="last_history_partial" colspan="2"
+                    string="Display items partially reconciled on the last run"
+                    type="object"/>
+            </tree>
+        </field>
+    </record>
+
+    <record id="action_account_easy_reconcile" model="ir.actions.act_window">
+        <field name="name">Easy Automatic Reconcile</field>
+        <field name="type">ir.actions.act_window</field>
+        <field name="res_model">account.easy.reconcile</field>
+        <field name="view_type">form</field>
+        <field name="view_mode">tree,form</field>
+        <field name="help" type="html">
+          <p class="oe_view_nocontent_create">
+            Click to add a reconciliation profile.
+          </p><p>
+            A reconciliation profile specifies, for one account, how
+            the entries should be reconciled.
+            You can select one or many reconciliation methods which will
+            be run sequentially to match the entries between them.
+          </p>
+        </field>
+    </record>
+
+
+    <!-- account.easy.reconcile.method view -->
+
+    <record id="account_easy_reconcile_method_form" model="ir.ui.view">
+        <field name="name">account.easy.reconcile.method.form</field>
+        <field name="priority">20</field>
+        <field name="model">account.easy.reconcile.method</field>
+        <field name="arch" type="xml">
+            <form string="Automatic Easy Reconcile Method">
+                <field name="sequence"/>
+                <field name="name"/>
+                <field name="write_off"/>
+                <field name="account_lost_id" attrs="{'required':[('write_off','>',0)]}"/>
+                <field name="account_profit_id" attrs="{'required':[('write_off','>',0)]}"/>
+                <field name="journal_id" attrs="{'required':[('write_off','>',0)]}"/>
+                <field name="date_base_on"/>
+            </form>
+        </field>
+    </record>
+
+    <record id="account_easy_reconcile_method_tree" model="ir.ui.view">
+        <field name="name">account.easy.reconcile.method.tree</field>
+        <field name="priority">20</field>
+        <field name="model">account.easy.reconcile.method</field>
+        <field name="arch" type="xml">
+            <tree editable="top" string="Automatic Easy Reconcile Method">
+                <field name="sequence"/>
+                <field name="name"/>
+                <field name="write_off"/>
+                <field name="account_lost_id" attrs="{'required':[('write_off','>',0)]}"/>
+                <field name="account_profit_id" attrs="{'required':[('write_off','>',0)]}"/>
+                <field name="journal_id" attrs="{'required':[('write_off','>',0)]}"/>
+                <field name="date_base_on"/>
+            </tree>
+        </field>
+    </record>
+
+    <!-- menu item -->
+
+    <menuitem action="action_account_easy_reconcile"
+        id="menu_easy_reconcile"
+        parent="account.periodical_processing_reconciliation"/>
+
+</data>
+</openerp>
 
=== added file 'account_easy_reconcile/easy_reconcile_history.py'
--- account_easy_reconcile/easy_reconcile_history.py	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/easy_reconcile_history.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,153 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright 2012 Camptocamp SA
+#
+#    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 _
+
+
+class easy_reconcile_history(orm.Model):
+    """ Store an history of the runs per profile
+    Each history stores the list of reconciliations done"""
+
+    _name = 'easy.reconcile.history'
+    _rec_name = 'easy_reconcile_id'
+    _order = 'date DESC'
+
+    def _reconcile_line_ids(self, cr, uid, ids, name, args, context=None):
+        result = {}
+
+        for history in self.browse(cr, uid, ids, context=context):
+            result[history.id] = {}
+
+            move_line_ids = []
+            for reconcile in history.reconcile_ids:
+                move_line_ids += [line.id
+                                    for line
+                                    in reconcile.line_id]
+            result[history.id]['reconcile_line_ids'] = move_line_ids
+
+            move_line_ids = []
+            for reconcile in history.reconcile_partial_ids:
+                move_line_ids += [line.id
+                                    for line
+                                    in reconcile.line_partial_ids]
+            result[history.id]['partial_line_ids'] = move_line_ids
+
+        return result
+
+    _columns = {
+            'easy_reconcile_id': fields.many2one(
+                'account.easy.reconcile', 'Reconcile Profile', readonly=True),
+            'date': fields.datetime('Run date', readonly=True),
+            'reconcile_ids': fields.many2many(
+                'account.move.reconcile',
+                'account_move_reconcile_history_rel',
+                string='Reconciliations', readonly=True),
+            'reconcile_partial_ids': fields.many2many(
+                'account.move.reconcile',
+                'account_move_reconcile_history_partial_rel',
+                string='Partial Reconciliations', readonly=True),
+            'reconcile_line_ids':
+                fields.function(
+                    _reconcile_line_ids,
+                    string='Reconciled Items',
+                    type='many2many',
+                    relation='account.move.line',
+                    readonly=True,
+                    multi='lines'),
+            'partial_line_ids':
+                fields.function(
+                    _reconcile_line_ids,
+                    string='Partially Reconciled Items',
+                    type='many2many',
+                    relation='account.move.line',
+                    readonly=True,
+                    multi='lines'),
+            'company_id': fields.related('easy_reconcile_id','company_id',
+                                         relation='res.company',
+                                         type='many2one',
+                                         string='Company',
+                                         store=True,
+                                         readonly=True),
+
+        }
+
+    def _open_move_lines(self, cr, uid, history_id, rec_type='full', context=None):
+        """ For an history record, open the view of move line with
+        the reconciled or partially reconciled move lines
+
+        :param history_id: id of the history
+        :param rec_type: 'full' or 'partial'
+        :return: action to open the move lines
+        """
+        assert rec_type in ('full', 'partial'), \
+                "rec_type must be 'full' or 'partial'"
+
+        history = self.browse(cr, uid, history_id, context=context)
+
+        if rec_type == 'full':
+            field = 'reconcile_line_ids'
+            name = _('Reconciliations')
+        else:
+            field = 'partial_line_ids'
+            name = _('Partial Reconciliations')
+
+        move_line_ids = [line.id for line in getattr(history, field)]
+
+        return {
+            'name': name,
+            'view_mode': 'tree,form',
+            'view_id': False,
+            'view_type': 'form',
+            'res_model': 'account.move.line',
+            'type': 'ir.actions.act_window',
+            'nodestroy': True,
+            'target': 'current',
+            'domain': unicode([('id', 'in', move_line_ids)]),
+            }
+
+    def open_reconcile(self, cr, uid, history_ids, context=None):
+        """ For an history record, open the view of move line
+        with the reconciled move lines
+
+        :param history_ids: id of the record as int or long
+                            Accept a list with 1 id too to be
+                            used from the client.
+        """
+        if isinstance(history_ids, (tuple, list)):
+            assert len(history_ids) == 1, "only 1 ID is accepted"
+            history_ids = history_ids[0]
+        return self._open_move_lines(
+                cr, uid, history_ids, rec_type='full', context=None)
+
+    def open_partial(self, cr, uid, history_ids, context=None):
+        """ For an history record, open the view of move line
+        with the partially reconciled move lines
+
+        :param history_ids: id of the record as int or long
+                            Accept a list with 1 id too to be
+                            used from the client.
+        """
+        if isinstance(history_ids, (tuple, list)):
+            assert len(history_ids) == 1, "only 1 ID is accepted"
+            history_ids = history_ids[0]
+        return self._open_move_lines(
+                cr, uid, history_ids, rec_type='partial', context=None)
 
=== added file 'account_easy_reconcile/easy_reconcile_history_view.xml'
--- account_easy_reconcile/easy_reconcile_history_view.xml	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/easy_reconcile_history_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,98 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data noupdate="0">
+
+    <record id="view_easy_reconcile_history_search" model="ir.ui.view">
+        <field name="name">easy.reconcile.history.search</field>
+        <field name="model">easy.reconcile.history</field>
+        <field name="arch" type="xml">
+            <search string="Automatic Easy Reconcile History">
+                <filter icon="terp-go-today" string="Today"
+                    domain="[('date','&lt;', time.strftime('%%Y-%%m-%%d 23:59:59')), ('date','&gt;=', time.strftime('%%Y-%%m-%%d 00:00:00'))]"
+                    help="Todays' Reconcilations" />
+                <filter icon="terp-go-week" string="7 Days"
+                    help="Reconciliations of last 7 days"
+                    domain="[('date','&lt;', time.strftime('%%Y-%%m-%%d 23:59:59')),('date','&gt;=',(datetime.date.today()-datetime.timedelta(days=7)).strftime('%%Y-%%m-%%d 00:00:00'))]"
+                />
+
+                <separator orientation="vertical"/>
+                <field name="easy_reconcile_id"/>
+                <field name="date"/>
+
+                <newline/>
+                <group expand="0" string="Group By...">
+                    <filter string="Reconciliation Profile"
+                        icon="terp-stock_effects-object-colorize"
+                        domain="[]" context="{'group_by': 'easy_reconcile_id'}"/>
+                    <filter string="Date" icon="terp-go-month" domain="[]"
+                        context="{'group_by': 'date'}"/>
+                </group>
+            </search>
+        </field>
+    </record>
+
+    <record id="easy_reconcile_history_form" model="ir.ui.view">
+        <field name="name">easy.reconcile.history.form</field>
+        <field name="model">easy.reconcile.history</field>
+        <field name="arch" type="xml">
+            <form string="Automatic Easy Reconcile History" version="7.0">
+                <header>
+                    <button name="open_reconcile"
+                        string="Go to reconciled items"
+                        icon="STOCK_JUMP_TO" type="object"/>
+                    <button name="open_partial"
+                        string="Go to partially reconciled items"
+                        icon="STOCK_JUMP_TO" type="object"/>
+                </header>
+                <sheet>
+                    <group>
+                        <field name="easy_reconcile_id"/>
+                        <field name="date"/>
+                        <field name="company_id" groups="base.group_multi_company"/>
+                    </group>
+                    <group col="2">
+                        <separator colspan="2" string="Reconciliations"/>
+                        <field name="reconcile_ids" nolabel="1"/>
+                    </group>
+                    <group col="2">
+                        <separator colspan="2" string="Partial Reconciliations"/>
+                        <field name="reconcile_partial_ids" nolabel="1"/>
+                    </group>
+                </sheet>
+            </form>
+        </field>
+    </record>
+
+    <record id="easy_reconcile_history_tree" model="ir.ui.view">
+        <field name="name">easy.reconcile.history.tree</field>
+        <field name="model">easy.reconcile.history</field>
+        <field name="arch" type="xml">
+            <tree string="Automatic Easy Reconcile History">
+                <field name="easy_reconcile_id"/>
+                <field name="date"/>
+                <button icon="STOCK_JUMP_TO" name="open_reconcile"
+                    string="Go to reconciled items" type="object"/>
+                <button icon="STOCK_JUMP_TO" name="open_partial"
+                    string="Go to partially reconciled items" type="object"/>
+            </tree>
+        </field>
+    </record>
+
+    <record id="action_easy_reconcile_history" model="ir.actions.act_window">
+        <field name="name">Easy Automatic Reconcile History</field>
+        <field name="type">ir.actions.act_window</field>
+        <field name="res_model">easy.reconcile.history</field>
+        <field name="view_type">form</field>
+        <field name="view_mode">tree,form</field>
+    </record>
+
+    <act_window
+      context="{'search_default_easy_reconcile_id': [active_id], 'default_easy_reconcile_id': active_id}"
+      id="act_easy_reconcile_to_history"
+      name="History Details"
+      groups=""
+      res_model="easy.reconcile.history"
+      src_model="account.easy.reconcile"/>
+
+    </data>
+</openerp>
 
=== added directory 'account_easy_reconcile/i18n'
=== added file 'account_easy_reconcile/i18n/fr.po'
--- account_easy_reconcile/i18n/fr.po	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/i18n/fr.po	2013-06-10 06:07:03 +0000
@@ -0,0 +1,425 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+# 	* account_easy_reconcile
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.1\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2013-01-04 08:39+0000\n"
+"PO-Revision-Date: 2013-01-04 09:55+0100\n"
+"Last-Translator: Guewen Baconnier <[e-mail]>\n"
+"Language-Team: \n"
+"Language: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: \n"
+
+#. module: account_easy_reconcile
+#: code:addons/account_easy_reconcile/easy_reconcile_history.py:101
+#: view:easy.reconcile.history:0
+#: field:easy.reconcile.history,reconcile_ids:0
+#, python-format
+msgid "Reconciliations"
+msgstr "Lettrages"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+#: view:easy.reconcile.history:0
+msgid "Automatic Easy Reconcile History"
+msgstr "Historique des lettrages automatisés"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Information"
+msgstr "Information"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+#: view:easy.reconcile.history:0
+msgid "Go to partially reconciled items"
+msgstr "Voir les entrées partiellement lettrées"
+
+#. module: account_easy_reconcile
+#: help:account.easy.reconcile.method,sequence:0
+msgid "The sequence field is used to order the reconcile method"
+msgstr "La séquence détermine l'ordre des méthodes de lettrage"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_history
+msgid "easy.reconcile.history"
+msgstr "easy.reconcile.history"
+
+#. module: account_easy_reconcile
+#: model:ir.actions.act_window,help:account_easy_reconcile.action_account_easy_reconcile
+msgid ""
+"<p class=\"oe_view_nocontent_create\">\n"
+"            Click to add a reconciliation profile.\n"
+"          </p><p>\n"
+"            A reconciliation profile specifies, for one account, how\n"
+"            the entries should be reconciled.\n"
+"            You can select one or many reconciliation methods which will\n"
+"            be run sequentially to match the entries between them.\n"
+"          </p>\n"
+"        "
+msgstr ""
+"<p class=\"oe_view_nocontent_create\">\n"
+"            Cliquez pour ajouter un profil de lettrage.\n"
+"          </p><p>\n"
+"            Un profil de lettrage spécifie, pour un compte, comment\n"
+"            les écritures doivent être lettrées.\n"
+"            Vous pouvez sélectionner une ou plusieurs méthodes de lettrage\n"
+"            qui seront lancées successivement pour identifier les écritures\n"
+"            devant être lettrées.          </p>\n"
+"        "
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_options
+msgid "easy.reconcile.options"
+msgstr "easy.reconcile.options"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "Group By..."
+msgstr "Grouper par..."
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile,unreconciled_count:0
+msgid "Unreconciled Items"
+msgstr "Écritures non lettrées"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_base
+msgid "easy.reconcile.base"
+msgstr "easy.reconcile.base"
+
+#. module: account_easy_reconcile
+#: field:easy.reconcile.history,reconcile_line_ids:0
+msgid "Reconciled Items"
+msgstr "Écritures lettrées"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile,reconcile_method:0
+msgid "Method"
+msgstr "Méthode"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "7 Days"
+msgstr "7 jours"
+
+#. module: account_easy_reconcile
+#: model:ir.actions.act_window,name:account_easy_reconcile.action_easy_reconcile_history
+msgid "Easy Automatic Reconcile History"
+msgstr "Lettrage automatisé"
+
+#. module: account_easy_reconcile
+#: field:easy.reconcile.history,date:0
+msgid "Run date"
+msgstr "Date de lancement"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Match one debit line vs one credit line. Do not allow partial reconciliation. The lines should have the same amount (with the write-off) and the same reference to be reconciled."
+msgstr "Lettre un débit avec un crédit ayant le même montant et la même référence. Le lettrage ne peut être partiel (écriture d'ajustement en cas d'écart)."
+
+#. module: account_easy_reconcile
+#: model:ir.actions.act_window,name:account_easy_reconcile.act_easy_reconcile_to_history
+msgid "History Details"
+msgstr "Détails de l'historique"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Display items reconciled on the last run"
+msgstr "Voir les entrées lettrées au dernier lettrage"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,name:0
+msgid "Type"
+msgstr "Type"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,journal_id:0
+#: field:easy.reconcile.base,journal_id:0
+#: field:easy.reconcile.options,journal_id:0
+#: field:easy.reconcile.simple,journal_id:0
+#: field:easy.reconcile.simple.name,journal_id:0
+#: field:easy.reconcile.simple.partner,journal_id:0
+#: field:easy.reconcile.simple.reference,journal_id:0
+msgid "Journal"
+msgstr "Journal"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,account_profit_id:0
+#: field:easy.reconcile.base,account_profit_id:0
+#: field:easy.reconcile.options,account_profit_id:0
+#: field:easy.reconcile.simple,account_profit_id:0
+#: field:easy.reconcile.simple.name,account_profit_id:0
+#: field:easy.reconcile.simple.partner,account_profit_id:0
+#: field:easy.reconcile.simple.reference,account_profit_id:0
+msgid "Account Profit"
+msgstr "Compte de profits"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "Todays' Reconcilations"
+msgstr "Lettrages du jour"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Simple. Amount and Name"
+msgstr "Simple. Montant et description"
+
+#. module: account_easy_reconcile
+#: field:easy.reconcile.base,partner_ids:0
+#: field:easy.reconcile.simple,partner_ids:0
+#: field:easy.reconcile.simple.name,partner_ids:0
+#: field:easy.reconcile.simple.partner,partner_ids:0
+#: field:easy.reconcile.simple.reference,partner_ids:0
+msgid "Restrict on partners"
+msgstr "Filtrer sur des partenaires"
+
+#. module: account_easy_reconcile
+#: model:ir.actions.act_window,name:account_easy_reconcile.action_account_easy_reconcile
+#: model:ir.ui.menu,name:account_easy_reconcile.menu_easy_reconcile
+msgid "Easy Automatic Reconcile"
+msgstr "Lettrage automatisé"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "Today"
+msgstr "Aujourd'hui"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "Date"
+msgstr "Date"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile,last_history:0
+msgid "Last History"
+msgstr "Dernier historique"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Configuration"
+msgstr "Configuration"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile,reconciled_partial_count:0
+#: field:easy.reconcile.history,partial_line_ids:0
+msgid "Partially Reconciled Items"
+msgstr "Écritures partiellement lettrées"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_simple_partner
+msgid "easy.reconcile.simple.partner"
+msgstr "easy.reconcile.simple.partner"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,write_off:0
+#: field:easy.reconcile.base,write_off:0
+#: field:easy.reconcile.options,write_off:0
+#: field:easy.reconcile.simple,write_off:0
+#: field:easy.reconcile.simple.name,write_off:0
+#: field:easy.reconcile.simple.partner,write_off:0
+#: field:easy.reconcile.simple.reference,write_off:0
+msgid "Write off allowed"
+msgstr "Écart autorisé"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Automatic Easy Reconcile"
+msgstr "Lettrage automatisé"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile,account:0
+#: field:easy.reconcile.base,account_id:0
+#: field:easy.reconcile.simple,account_id:0
+#: field:easy.reconcile.simple.name,account_id:0
+#: field:easy.reconcile.simple.partner,account_id:0
+#: field:easy.reconcile.simple.reference,account_id:0
+msgid "Account"
+msgstr "Compte"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,task_id:0
+msgid "Task"
+msgstr "Tâche"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile,name:0
+msgid "Name"
+msgstr "Nom"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Simple. Amount and Partner"
+msgstr "Simple. Montant et partenaire"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Start Auto Reconcilation"
+msgstr "Lancer le lettrage automatisé"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_simple_name
+msgid "easy.reconcile.simple.name"
+msgstr "easy.reconcile.simple.name"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,filter:0
+#: field:easy.reconcile.base,filter:0
+#: field:easy.reconcile.options,filter:0
+#: field:easy.reconcile.simple,filter:0
+#: field:easy.reconcile.simple.name,filter:0
+#: field:easy.reconcile.simple.partner,filter:0
+#: field:easy.reconcile.simple.reference,filter:0
+msgid "Filter"
+msgstr "Filtre"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Match one debit line vs one credit line. Do not allow partial reconciliation. The lines should have the same amount (with the write-off) and the same partner to be reconciled."
+msgstr "Lettre un débit avec un crédit ayant le même montant et le même partenaire. Le lettrage ne peut être partiel (écriture d'ajustement en cas d'écart)."
+
+#. module: account_easy_reconcile
+#: field:easy.reconcile.history,easy_reconcile_id:0
+msgid "Reconcile Profile"
+msgstr "Profil de réconciliation"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Start Auto Reconciliation"
+msgstr "Lancer le lettrage automatisé"
+
+#. module: account_easy_reconcile
+#: code:addons/account_easy_reconcile/easy_reconcile.py:250
+#, python-format
+msgid "Error"
+msgstr "Erreur"
+
+#. module: account_easy_reconcile
+#: code:addons/account_easy_reconcile/easy_reconcile.py:251
+#, python-format
+msgid "There is no history of reconciled items on the task: %s."
+msgstr "Il n'y a pas d'historique d'écritures lettrées sur la tâche: %s."
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Match one debit line vs one credit line. Do not allow partial reconciliation. The lines should have the same amount (with the write-off) and the same name to be reconciled."
+msgstr "Lettre un débit avec un crédit ayant le même montant et la même description. Le lettrage ne peut être partiel (écriture d'ajustement en cas d'écart)."
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,account_lost_id:0
+#: field:easy.reconcile.base,account_lost_id:0
+#: field:easy.reconcile.options,account_lost_id:0
+#: field:easy.reconcile.simple,account_lost_id:0
+#: field:easy.reconcile.simple.name,account_lost_id:0
+#: field:easy.reconcile.simple.partner,account_lost_id:0
+#: field:easy.reconcile.simple.reference,account_lost_id:0
+msgid "Account Lost"
+msgstr "Compte de pertes"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "Reconciliation Profile"
+msgstr "Profil de réconciliation"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+#: field:account.easy.reconcile,history_ids:0
+msgid "History"
+msgstr "Historique"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+#: view:easy.reconcile.history:0
+msgid "Go to reconciled items"
+msgstr "Voir les entrées lettrées"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Profile Information"
+msgstr "Information sur le profil"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile.method:0
+msgid "Automatic Easy Reconcile Method"
+msgstr "Méthode de lettrage automatisé"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Simple. Amount and Reference"
+msgstr "Simple. Montant et référence"
+
+#. module: account_easy_reconcile
+#: view:account.easy.reconcile:0
+msgid "Display items partially reconciled on the last run"
+msgstr "Afficher les entrées partiellement lettrées au dernier lettrage"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,sequence:0
+msgid "Sequence"
+msgstr "Séquence"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_simple
+msgid "easy.reconcile.simple"
+msgstr "easy.reconcile.simple"
+
+#. module: account_easy_reconcile
+#: view:easy.reconcile.history:0
+msgid "Reconciliations of last 7 days"
+msgstr "Lettrages des 7 derniers jours"
+
+#. module: account_easy_reconcile
+#: field:account.easy.reconcile.method,date_base_on:0
+#: field:easy.reconcile.base,date_base_on:0
+#: field:easy.reconcile.options,date_base_on:0
+#: field:easy.reconcile.simple,date_base_on:0
+#: field:easy.reconcile.simple.name,date_base_on:0
+#: field:easy.reconcile.simple.partner,date_base_on:0
+#: field:easy.reconcile.simple.reference,date_base_on:0
+msgid "Date of reconciliation"
+msgstr "Date de lettrage"
+
+#. module: account_easy_reconcile
+#: code:addons/account_easy_reconcile/easy_reconcile_history.py:104
+#: view:easy.reconcile.history:0
+#: field:easy.reconcile.history,reconcile_partial_ids:0
+#, python-format
+msgid "Partial Reconciliations"
+msgstr "Lettrages partiels"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_account_easy_reconcile_method
+msgid "reconcile method for account_easy_reconcile"
+msgstr "Méthode de lettrage"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_easy_reconcile_simple_reference
+msgid "easy.reconcile.simple.reference"
+msgstr "easy.reconcile.simple.reference"
+
+#. module: account_easy_reconcile
+#: model:ir.model,name:account_easy_reconcile.model_account_easy_reconcile
+msgid "account easy reconcile"
+msgstr "Lettrage automatisé"
+
+#~ msgid "Unreconciled Entries"
+#~ msgstr "Écritures non lettrées"
+
+#, fuzzy
+#~ msgid "Partially Reconciled Entries"
+#~ msgstr "Lettrages partiels"
+
+#~ msgid "Task Information"
+#~ msgstr "Information sur la tâche"
+
+#~ msgid "Reconcile Method"
+#~ msgstr "Méthode de lettrage"
+
+#~ msgid "Log"
+#~ msgstr "Historique"
 
=== added directory 'account_easy_reconcile/security'
=== added file 'account_easy_reconcile/security/ir.model.access.csv'
--- account_easy_reconcile/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/security/ir.model.access.csv	2013-06-10 06:07:03 +0000
@@ -0,0 +1,15 @@
+id,name,model_id:id,group_id:id,perm_read,perm_write,perm_create,perm_unlink
+access_easy_reconcile_options_acc_user,easy.reconcile.options,model_easy_reconcile_options,account.group_account_user,1,0,0,0
+access_account_easy_reconcile_method_acc_user,account.easy.reconcile.method,model_account_easy_reconcile_method,account.group_account_user,1,0,0,0
+access_account_easy_reconcile_acc_user,account.easy.reconcile,model_account_easy_reconcile,account.group_account_user,1,1,0,0
+access_easy_reconcile_simple_name_acc_user,easy.reconcile.simple.name,model_easy_reconcile_simple_name,account.group_account_user,1,0,0,0
+access_easy_reconcile_simple_partner_acc_user,easy.reconcile.simple.partner,model_easy_reconcile_simple_partner,account.group_account_user,1,0,0,0
+access_easy_reconcile_simple_reference_acc_user,easy.reconcile.simple.reference,model_easy_reconcile_simple_reference,account.group_account_user,1,0,0,0
+access_easy_reconcile_options_acc_mgr,easy.reconcile.options,model_easy_reconcile_options,account.group_account_user,1,0,0,0
+access_account_easy_reconcile_method_acc_mgr,account.easy.reconcile.method,model_account_easy_reconcile_method,account.group_account_user,1,1,1,1
+access_account_easy_reconcile_acc_mgr,account.easy.reconcile,model_account_easy_reconcile,account.group_account_user,1,1,1,1
+access_easy_reconcile_simple_name_acc_mgr,easy.reconcile.simple.name,model_easy_reconcile_simple_name,account.group_account_user,1,0,0,0
+access_easy_reconcile_simple_partner_acc_mgr,easy.reconcile.simple.partner,model_easy_reconcile_simple_partner,account.group_account_user,1,0,0,0
+access_easy_reconcile_simple_reference_acc_mgr,easy.reconcile.simple.reference,model_easy_reconcile_simple_reference,account.group_account_user,1,0,0,0
+access_easy_reconcile_history_acc_user,easy.reconcile.history,model_easy_reconcile_history,account.group_account_user,1,1,1,0
+access_easy_reconcile_history_acc_mgr,easy.reconcile.history,model_easy_reconcile_history,account.group_account_manager,1,1,1,1
 
=== added file 'account_easy_reconcile/security/ir_rule.xml'
--- account_easy_reconcile/security/ir_rule.xml	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/security/ir_rule.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+  <data noupdate="1">
+    <record id="easy_reconcile_rule" model="ir.rule">
+      <field name="name">Easy reconcile multi-company</field>
+      <field name="model_id" ref="model_account_easy_reconcile"/>
+      <field name="global" eval="True"/>
+      <field name="domain_force">['|', ('company_id', '=', False), ('company_id', 'child_of', [user.company_id.id])]</field>
+    </record>
+
+    <record id="easy_reconcile_history_rule" model="ir.rule">
+      <field name="name">Easy reconcile history multi-company</field>
+      <field name="model_id" ref="model_easy_reconcile_history"/>
+      <field name="global" eval="True"/>
+      <field name="domain_force">['|', ('company_id', '=', False), ('company_id', 'child_of', [user.company_id.id])]</field>
+    </record>
+
+    <record id="easy_reconcile_method_rule" model="ir.rule">
+      <field name="name">Easy reconcile method multi-company</field>
+      <field name="model_id" ref="model_account_easy_reconcile_method"/>
+      <field name="global" eval="True"/>
+      <field name="domain_force">['|', ('company_id', '=', False), ('company_id', 'child_of', [user.company_id.id])]</field>
+    </record>
+  </data>
+</openerp>
 
=== added file 'account_easy_reconcile/simple_reconciliation.py'
--- account_easy_reconcile/simple_reconciliation.py	1970-01-01 00:00:00 +0000
+++ account_easy_reconcile/simple_reconciliation.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,120 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright 2012-2013 Camptocamp SA (Guewen Baconnier)
+#    Copyright (C) 2010   Sébastien Beau
+#
+#    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.orm import AbstractModel, TransientModel
+
+
+class easy_reconcile_simple(AbstractModel):
+
+    _name = 'easy.reconcile.simple'
+    _inherit = 'easy.reconcile.base'
+
+    # has to be subclassed
+    # field name used as key for matching the move lines
+    _key_field = None
+
+    def rec_auto_lines_simple(self, cr, uid, rec, lines, context=None):
+        if context is None:
+            context = {}
+
+        if self._key_field is None:
+            raise ValueError("_key_field has to be defined")
+
+        count = 0
+        res = []
+        while (count < len(lines)):
+            for i in xrange(count+1, len(lines)):
+                writeoff_account_id = False
+                if lines[count][self._key_field] != lines[i][self._key_field]:
+                    break
+
+                check = False
+                if lines[count]['credit'] > 0 and lines[i]['debit'] > 0:
+                    credit_line = lines[count]
+                    debit_line = lines[i]
+                    check = True
+                elif lines[i]['credit'] > 0  and lines[count]['debit'] > 0:
+                    credit_line = lines[i]
+                    debit_line = lines[count]
+                    check = True
+                if not check:
+                    continue
+
+                reconciled, dummy = self._reconcile_lines(
+                    cr, uid, rec, [credit_line, debit_line],
+                    allow_partial=False, context=context)
+                if reconciled:
+                    res += [credit_line['id'], debit_line['id']]
+                    del lines[i]
+                    break
+            count += 1
+        return res, []  # empty list for partial, only full rec in "simple" rec
+
+    def _simple_order(self, rec, *args, **kwargs):
+        return "ORDER BY account_move_line.%s" % self._key_field
+
+    def _action_rec(self, cr, uid, rec, context=None):
+        """Match only 2 move lines, do not allow partial reconcile"""
+        select = self._select(rec)
+        select += ", account_move_line.%s " % self._key_field
+        where, params = self._where(rec)
+        where += " AND account_move_line.%s IS NOT NULL " % self._key_field
+
+        where2, params2 = self._get_filter(cr, uid, rec, context=context)
+        query = ' '.join((
+            select,
+            self._from(rec),
+            where, where2,
+            self._simple_order(rec)))
+
+        cr.execute(query, params + params2)
+        lines = cr.dictfetchall()
+        return self.rec_auto_lines_simple(cr, uid, rec, lines, context)
+
+
+class easy_reconcile_simple_name(TransientModel):
+
+    _name = 'easy.reconcile.simple.name'
+    _inherit = 'easy.reconcile.simple'
+
+    # has to be subclassed
+    # field name used as key for matching the move lines
+    _key_field = 'name'
+
+
+class easy_reconcile_simple_partner(TransientModel):
+
+    _name = 'easy.reconcile.simple.partner'
+    _inherit = 'easy.reconcile.simple'
+
+    # has to be subclassed
+    # field name used as key for matching the move lines
+    _key_field = 'partner_id'
+
+
+class easy_reconcile_simple_reference(TransientModel):
+
+    _name = 'easy.reconcile.simple.reference'
+    _inherit = 'easy.reconcile.simple'
+
+    # has to be subclassed
+    # field name used as key for matching the move lines
+    _key_field = 'ref'
 
=== added directory 'account_statement_base_completion'
=== added file 'account_statement_base_completion/__init__.py'
--- account_statement_base_completion/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,23 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import statement
+import partner
 
=== added file 'account_statement_base_completion/__openerp__.py'
--- account_statement_base_completion/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/__openerp__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,74 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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': "Bank statement base completion",
+ 'version': '1.0',
+ 'author': 'Camptocamp',
+ 'maintainer': 'Camptocamp',
+ 'category': 'Finance',
+ 'complexity': 'normal',
+ 'depends': ['account_statement_ext'],
+ 'description': """
+ The goal of this module is to improve the basic bank statement, help dealing with huge volume of
+ reconciliation by providing basic rules to identify the partner of a bank statement line.
+ Each bank statement profile can have its own rules to be applied according to a sequence order.
+
+ Some basic rules are provided in this module:
+
+ 1) Match from statement line label (based on partner field 'Bank Statement Label')
+ 2) Match from statement line label (based on partner name)
+ 3) Match from statement line reference (based on SO number)
+ 3) Match from statement line reference (based on Invoice number)
+
+ You can easily override this module and add your own rules in your own one. The basic rules only
+ fill in  the partner, but you can use them to fill in any value of the line (in the future, we will
+ add a rule to automatically match and reconcile the line).
+
+ It adds as well a label on the bank statement line (on which the pre-define rules can match) and
+ a char field on the partner called 'Bank Statement Label'. Using the pre-define rules, you will be
+ able to match various labels for a partner.
+
+ The reference of the line is always used by the reconciliation process. We're supposed to copy
+ there (or write manually) the matching string. This can be: the order Number or an invoice number,
+ or anything that will be found in the invoice accounting entry part to make the match.
+
+ You can use it with  our account_advanced_reconcile module to automatize the reconciliation process.
+
+
+ TODO: The rules that look for invoices to find out the partner should take back the payable / receivable
+       account from there directly instead of retrieving it from partner properties !
+
+ """,
+ 'website': 'http://www.camptocamp.com',
+ 'init_xml': [],
+ 'update_xml': [
+     'statement_view.xml',
+     'partner_view.xml',
+     'data.xml',
+     'security/ir.model.access.csv',
+ ],
+ 'demo_xml': [],
+ 'test': [],
+ 'installable': True,
+ 'images': [],
+ 'auto_install': False,
+ 'license': 'AGPL-3',
+}
 
=== added file 'account_statement_base_completion/data.xml'
--- account_statement_base_completion/data.xml	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/data.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data noupdate="1">
+
+     <record id="bank_statement_completion_rule_2" model="account.statement.completion.rule">
+          <field name="name">Match from line label (based on partner field 'Bank Statement Label')</field>
+          <field name="sequence">60</field>
+          <field name="function_to_call">get_from_label_and_partner_field</field>
+      </record>
+
+    <record id="bank_statement_completion_rule_3" model="account.statement.completion.rule">
+         <field name="name">Match from line label (based on partner name)</field>
+         <field name="sequence">70</field>
+         <field name="function_to_call">get_from_label_and_partner_name</field>
+     </record>
+
+     <record id="bank_statement_completion_rule_1" model="account.statement.completion.rule">
+          <field name="name">Match from line reference (based on SO number)</field>
+          <field name="sequence">50</field>
+          <field name="function_to_call">get_from_ref_and_so</field>
+      </record>
+
+     <record id="bank_statement_completion_rule_4" model="account.statement.completion.rule">
+          <field name="name">Match from line reference (based on Invoice number)</field>
+          <field name="sequence">40</field>
+          <field name="function_to_call">get_from_ref_and_invoice</field>
+      </record>
+
+     <record id="bank_statement_completion_rule_5" model="account.statement.completion.rule">
+          <field name="name">Match from line reference (based on Invoice Supplier number)</field>
+          <field name="sequence">45</field>
+          <field name="function_to_call">get_from_ref_and_supplier_invoice</field>
+      </record>
+
+
+</data>
+</openerp>
 
=== added directory 'account_statement_base_completion/i18n'
=== added file 'account_statement_base_completion/i18n/fr.po'
--- account_statement_base_completion/i18n/fr.po	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/i18n/fr.po	2013-06-10 06:07:03 +0000
@@ -0,0 +1,180 @@
+#. module: account_statement_base_completion
+#: view:account.statement.completion.rule:0
+msgid "Related Profiles"
+msgstr "Profils liés"
+
+#. module: account_statement_base_completion
+#: help:account.statement.completion.rule,sequence:0
+msgid "Lower means parsed first."
+msgstr "Plus petite séquence analysée en premier."
+
+#. module: account_statement_base_completion
+#: code:addons/account_statement_base_completion/statement.py:150
+#: code:addons/account_statement_base_completion/statement.py:182
+#: code:addons/account_statement_base_completion/statement.py:219
+#: code:addons/account_statement_base_completion/statement.py:252
+#, python-format
+msgid "Line named \"%s\" (Ref:%s) was matched by more than one partner."
+msgstr "La ligne nommée \"%s\" (Ref:%s) correspond à plusieurs partenaires."
+
+#. module: account_statement_base_completion
+#: field:account.bank.statement,completion_logs:0
+msgid "Completion Log"
+msgstr "Journal des complétions"
+
+#. module: account_statement_base_completion
+#: field:account.bank.statement.line,label:0
+msgid "Label"
+msgstr "Description"
+
+#. module: account_statement_base_completion
+#: help:account.bank.statement.line,label:0
+msgid ""
+"Generiy field to store a label given from the bank/office on which we "
+"can             base the default/standard providen rule."
+msgstr ""
+"Ce champs permet de stocker une description complémentaire fournie par la banque."
+"Le lettrage avancé pourra être effectué sur ce critère."
+
+#. module: account_statement_base_completion
+#: model:ir.model,name:account_statement_base_completion.model_account_bank_statement
+msgid "Bank Statement"
+msgstr "Relevé bancaire"
+
+#. module: account_statement_base_completion
+#: field:account.statement.completion.rule,function_to_call:0
+msgid "Method"
+msgstr "Méthode"
+
+#. module: account_statement_base_completion
+#: code:addons/account_statement_base_completion/statement.py:352
+#, python-format
+msgid "Bank Statement ID %s has %s lines completed by %s"
+msgstr "Le relevé bancaire avec l'ID %s a %s lignes completées par %s"
+
+#. module: account_statement_base_completion
+#: field:account.bank.statement.line,additionnal_bank_fields:0
+msgid "Additionnal infos from bank"
+msgstr "Informations additionnelles de la banque"
+
+#. module: account_statement_base_completion
+#: view:account.statement.profile:0
+msgid "Auto-Completion Rules"
+msgstr "Règles d'auto-complétion"
+
+#. module: account_statement_base_completion
+#: help:account.bank.statement.line,additionnal_bank_fields:0
+msgid ""
+"Used by completion and import system. Adds every field that is present in "
+"your bank/office             statement file"
+msgstr ""
+"Utilisé au niveau de l'auto-complétion et de l'import. Permet l'ajout de n'importe quel "
+"champs additionnel communiqué par la banque"
+
+#. module: account_statement_base_completion
+#: view:account.bank.statement:0
+msgid "Importation related infos"
+msgstr "Importation des informations liées"
+
+#. module: account_statement_base_completion
+#: model:ir.model,name:account_statement_base_completion.model_account_statement_profile
+msgid "Statement Profil"
+msgstr "Profil de relevé"
+
+#. module: account_statement_base_completion
+#: field:account.statement.completion.rule,name:0
+msgid "Name"
+msgstr "Nom"
+
+#. module: account_statement_base_completion
+#: constraint:account.statement.profile:0
+msgid "You need to put a partner if you tic the 'Force partner on bank move' !"
+msgstr ""
+"Vous devez indiquer un partenaire si vous avez coché 'Indiquer un partenaire sur la ligne d'écriture de la banque' !"
+
+#. module: account_statement_base_completion
+#: model:ir.model,name:account_statement_base_completion.model_account_bank_statement_line
+msgid "Bank Statement Line"
+msgstr "Ligne de relevé bancaire"
+
+#. module: account_statement_base_completion
+#: view:account.statement.completion.rule:0
+#: model:ir.actions.act_window,name:account_statement_base_completion.action_st_completion_rule_tree
+#: model:ir.ui.menu,name:account_statement_base_completion.menu_action_st_completion_rule_tree_menu
+msgid "Statement Completion Rule"
+msgstr "Règle d'auto-complétion du relevé"
+
+#. module: account_statement_base_completion
+#: model:ir.model,name:account_statement_base_completion.model_account_statement_completion_rule
+msgid "account.statement.completion.rule"
+msgstr "account.statement.completion.rule"
+
+#. module: account_statement_base_completion
+#: field:account.statement.completion.rule,profile_ids:0
+#: field:account.statement.profile,rule_ids:0
+msgid "Related statement profiles"
+msgstr "Profils liés"
+
+#. module: account_statement_base_completion
+#: constraint:account.bank.statement.line:0
+msgid ""
+"The amount of the voucher must be the same amount as the one on the "
+"statement line"
+msgstr ""
+"Le montant du justificatif doit être identique à celui de la ligne le "
+"concernant sur le relevé"
+
+#. module: account_statement_base_completion
+#: field:account.bank.statement.line,already_completed:0
+msgid "Auto-Completed"
+msgstr "Auto-Completé"
+
+#. module: account_statement_base_completion
+#: view:account.bank.statement:0
+msgid "Auto Completion"
+msgstr "Auto-complétion"
+
+#. module: account_statement_base_completion
+#: field:account.statement.completion.rule,sequence:0
+msgid "Sequence"
+msgstr "Séquence"
+
+#. module: account_statement_base_completion
+#: constraint:account.bank.statement:0
+msgid "The journal and period chosen have to belong to the same company."
+msgstr "Le journal et la période doivent appartenir à la même société."
+
+#. module: account_statement_base_completion
+#: field:res.partner,bank_statement_label:0
+msgid "Bank Statement Label"
+msgstr "Description de relevé bancaire"
+
+#. module: account_statement_base_completion
+#: help:account.bank.statement.line,already_completed:0
+msgid ""
+"When this checkbox is ticked, the auto-completion process/button will ignore "
+"this line."
+msgstr ""
+"Les lignes cochées seront ignorées lorsque vous cliquez sur le bouton auto-complétion"
+
+#. module: account_statement_base_completion
+#: help:res.partner,bank_statement_label:0
+msgid ""
+"Enter the various label found on your bank statement separated by a ; "
+"If                  one of this label is include in the bank statement line, "
+"the partner will be automatically                  filled (as long as you "
+"use this method/rules in your statement profile)."
+msgstr ""
+"Entrez les différentes descriptions/informations sur votre relevé bancaire séparées par un ';' "
+"Si l'une d'entre elles figure dans la ligne du relevé, le partenaire correspondant pourra"
+"être automatiquement retrouvé (à condition d'utiliser un règle de lettrage dans le profil)."
+
+#. module: account_statement_base_completion
+#: model:ir.model,name:account_statement_base_completion.model_res_partner
+msgid "Partner"
+msgstr "Partenaire"
+
+#. module: account_statement_base_completion
+#: view:account.bank.statement:0
+msgid "Completion Logs"
+msgstr "Journaux d'auto-complétion"
 
=== added file 'account_statement_base_completion/partner.py'
--- account_statement_base_completion/partner.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/partner.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,38 @@
+# -*- coding: utf-8 -*-
+#################################################################################
+#                                                                               #
+#    Copyright (C) 2011 Akretion & Camptocamp
+#    Author : Sébastien BEAU, Joel Grand-Guillaume                              #
+#                                                                               #
+#    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.orm import Model
+from openerp.osv import fields, osv
+
+
+class res_partner(Model):
+    """
+    Add a bank label on the partner so that we can use it to match
+    this partner when we found this in a statement line.
+    """
+    _inherit = 'res.partner'
+
+    _columns = {
+        'bank_statement_label': fields.char('Bank Statement Label', size=100,
+                help="Enter the various label found on your bank statement separated by a ; If \
+                 one of this label is include in the bank statement line, the partner will be automatically \
+                 filled (as long as you use this method/rules in your statement profile)."),
+            }
 
=== added file 'account_statement_base_completion/partner_view.xml'
--- account_statement_base_completion/partner_view.xml	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/partner_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<openerp>
+	<data>
+
+        <record id="bk_view_partner_form" model="ir.ui.view">
+            <field name="name">account_bank_statement_import.view.partner.form</field>
+            <field name="model">res.partner</field>
+            <field name="type">form</field>
+            <field name="priority">20</field>
+            <field name="inherit_id" ref="account.view_partner_property_form"/>
+            <field name="arch" type="xml">
+                <field name="property_account_payable" position="after">
+                    <field name="bank_statement_label"/>
+                </field>
+            </field>
+        </record>
+
+                
+    </data>
+</openerp>
 
=== added directory 'account_statement_base_completion/security'
=== added file 'account_statement_base_completion/security/ir.model.access.csv'
--- account_statement_base_completion/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/security/ir.model.access.csv	2013-06-10 06:07:03 +0000
@@ -0,0 +1,3 @@
+id,name,model_id:id,group_id:id,perm_read,perm_write,perm_create,perm_unlink
+access_account_bank_st_cmpl_user,account.statement.completion.rule,model_account_statement_completion_rule,account.group_account_user,1,0,0,0
+access_account_bank_st_cmpl_manager,account.statement.completion.rule,model_account_statement_completion_rule,account.group_account_manager,1,1,1,1
 
=== added file 'account_statement_base_completion/statement.py'
--- account_statement_base_completion/statement.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/statement.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,527 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Nicolas Bessi, Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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/>.
+#
+##############################################################################
+# TODO replace customer supplier by package constant
+import traceback
+import sys
+import logging
+
+from collections import defaultdict
+import re
+from tools.translate import _
+from openerp.osv import osv, orm, fields
+from openerp.tools import DEFAULT_SERVER_DATETIME_FORMAT
+from operator import attrgetter
+import datetime
+
+_logger = logging.getLogger(__name__)
+
+
+class ErrorTooManyPartner(Exception):
+    """
+    New Exception definition that is raised when more than one partner is matched by
+    the completion rule.
+    """
+    def __init__(self, value):
+        self.value = value
+
+    def __str__(self):
+        return repr(self.value)
+
+    def __repr__(self):
+        return repr(self.value)
+
+
+class AccountStatementProfil(orm.Model):
+    """
+    Extend the class to add rules per profile that will match at least the partner,
+    but it could also be used to match other values as well.
+    """
+
+    _inherit = "account.statement.profile"
+
+    _columns = {
+        # @Akretion: For now, we don't implement this features, but this would probably be there:
+        # 'auto_completion': fields.text('Auto Completion'),
+        # 'transferts_account_id':fields.many2one('account.account', 'Transferts Account'),
+        # => You can implement it in a module easily, we design it with your needs in mind
+        # as well!
+
+        'rule_ids': fields.many2many(
+            'account.statement.completion.rule',
+            string='Related statement profiles',
+            rel='as_rul_st_prof_rel'),
+    }
+
+    def _get_callable(self, cr, uid, profile, context=None):
+        if isinstance(profile, (int, long)):
+            prof = self.browse(cr, uid, profile, context=context)
+        else:
+            prof = profile
+        # We need to respect the sequence order
+        sorted_array = sorted(prof.rule_ids, key=attrgetter('sequence'))
+        return tuple((x.function_to_call for x in sorted_array))
+
+    def _find_values_from_rules(self, cr, uid, calls, line, context=None):
+        """
+        This method will execute all related rules, in their sequence order,
+        to retrieve all the values returned by the first rules that will match.
+        :param calls: list of lookup function name available in rules
+        :param dict line: read of the concerned account.bank.statement.line
+        :return:
+            A dict of value that can be passed directly to the write method of
+            the statement line or {}
+           {'partner_id': value,
+            'account_id: value,
+
+            ...}
+        """
+        if context is None:
+            context = {}
+        if not calls:
+            calls = self._get_callable(cr, uid, line['profile_id'], context=context)
+        rule_obj = self.pool.get('account.statement.completion.rule')
+
+        for call in calls:
+            method_to_call = getattr(rule_obj, call)
+            result = method_to_call(cr, uid, line, context)
+            if result:
+                result['already_completed'] = True
+                return result
+        return None
+
+
+class AccountStatementCompletionRule(orm.Model):
+    """
+    This will represent all the completion method that we can have to
+    fullfill the bank statement lines. You'll be able to extend them in you own module
+    and choose those to apply for every statement profile.
+    The goal of a rule is to fullfill at least the partner of the line, but
+    if possible also the reference because we'll use it in the reconciliation
+    process. The reference should contain the invoice number or the SO number
+    or any reference that will be matched by the invoice accounting move.
+    """
+
+    _name = "account.statement.completion.rule"
+    _order = "sequence asc"
+
+    def _get_functions(self, cr, uid, context=None):
+        """
+        List of available methods for rules. Override this to add you own.
+        """
+        return [
+            ('get_from_ref_and_invoice', 'From line reference (based on customer invoice number)'),
+            ('get_from_ref_and_supplier_invoice', 'From line reference (based on supplier invoice number)'),
+            ('get_from_ref_and_so', 'From line reference (based on SO number)'),
+            ('get_from_label_and_partner_field', 'From line label (based on partner field)'),
+            ('get_from_label_and_partner_name', 'From line label (based on partner name)')]
+
+    _columns = {
+        'sequence': fields.integer('Sequence', help="Lower means parsed first."),
+        'name': fields.char('Name', size=128),
+        'profile_ids': fields.many2many(
+            'account.statement.profile',
+            rel='as_rul_st_prof_rel',
+            string='Related statement profiles'),
+        'function_to_call': fields.selection(_get_functions, 'Method'),
+    }
+
+    def _find_invoice(self, cr, uid, st_line, inv_type, context=None):
+        """Find invoice related to statement line"""
+        inv_obj = self.pool.get('account.invoice')
+        if inv_type == 'supplier':
+            type_domain = ('in_invoice', 'in_refund')
+            number_field = 'supplier_invoice_number'
+        elif inv_type == 'customer':
+            type_domain = ('out_invoice', 'out_refund')
+            number_field = 'number'
+        else:
+            raise osv.except_osv(_('System error'),
+                                 _('Invalid invoice type for completion: %') % inv_type)
+
+        inv_id = inv_obj.search(cr, uid,
+                                [(number_field, '=', st_line['ref'].strip()),
+                                 ('type', 'in', type_domain)],
+                                context=context)
+        if inv_id:
+            if len(inv_id) == 1:
+                inv = inv_obj.browse(cr, uid, inv_id[0], context=context)
+            else:
+                raise ErrorTooManyPartner(_('Line named "%s" (Ref:%s) was matched by more '
+                                            'than one partner while looking on %s invoices') %
+                                          (st_line['name'], st_line['ref'], inv_type))
+            return inv
+        return False
+
+    def _from_invoice(self, cr, uid, line, inv_type, context):
+        """Populate statement line values"""
+        if not inv_type in ('supplier', 'customer'):
+            raise osv.except_osv(_('System error'),
+                                 _('Invalid invoice type for completion: %') % inv_type)
+        res = {}
+        inv = self._find_invoice(cr, uid, line, inv_type, context=context)
+        if inv:
+            res = {'partner_id': inv.partner_id.id,
+                   'account_id': inv.account_id.id,
+                   'type': inv_type}
+            override_acc = line['master_account_id']
+            if override_acc:
+                res['account_id'] = override_acc
+        return res
+
+    # Should be private but data are initialised with no update XML
+    def get_from_ref_and_supplier_invoice(self, cr, uid, line, context=None):
+        """
+        Match the partner based on the invoice supplier invoice number and the reference of the statement
+        line. Then, call the generic get_values_for_line method to complete other values.
+        If more than one partner matched, raise the ErrorTooManyPartner error.
+
+        :param dict line: read of the concerned account.bank.statement.line
+        :return:
+            A dict of value that can be passed directly to the write method of
+            the statement line or {}
+           {'partner_id': value,
+            'account_id': value,
+
+            ...}
+        """
+        return self._from_invoice(cr, uid, line, 'supplier', context=context)
+
+    # Should be private but data are initialised with no update XML
+    def get_from_ref_and_invoice(self, cr, uid, line, context=None):
+        """
+        Match the partner based on the invoice number and the reference of the statement
+        line. Then, call the generic get_values_for_line method to complete other values.
+        If more than one partner matched, raise the ErrorTooManyPartner error.
+
+        :param dict line: read of the concerned account.bank.statement.line
+        :return:
+            A dict of value that can be passed directly to the write method of
+            the statement line or {}
+           {'partner_id': value,
+            'account_id': value,
+            ...}
+        """
+        return self._from_invoice(cr, uid, line, 'customer', context=context)
+
+    # Should be private but data are initialised with no update XML
+    def get_from_ref_and_so(self, cr, uid, st_line, context=None):
+        """
+        Match the partner based on the SO number and the reference of the statement
+        line. Then, call the generic get_values_for_line method to complete other values.
+        If more than one partner matched, raise the ErrorTooManyPartner error.
+
+        :param int/long st_line: read of the concerned account.bank.statement.line
+        :return:
+            A dict of value that can be passed directly to the write method of
+            the statement line or {}
+           {'partner_id': value,
+            'account_id': value,
+
+            ...}
+        """
+        st_obj = self.pool.get('account.bank.statement.line')
+        res = {}
+        if st_line:
+            so_obj = self.pool.get('sale.order')
+            so_id = so_obj.search(cr,
+                                  uid,
+                                  [('name', '=', st_line['ref'])],
+                                  context=context)
+            if so_id:
+                if so_id and len(so_id) == 1:
+                    so = so_obj.browse(cr, uid, so_id[0], context=context)
+                    res['partner_id'] = so.partner_id.id
+                elif so_id and len(so_id) > 1:
+                    raise ErrorTooManyPartner(_('Line named "%s" (Ref:%s) was matched by more '
+                                                'than one partner while looking on SO by ref.') %
+                                              (st_line['name'], st_line['ref']))
+                st_vals = st_obj.get_values_for_line(cr,
+                                                     uid,
+                                                     profile_id=st_line['profile_id'],
+                                                     master_account_id=st_line['master_account_id'],
+                                                     partner_id=res.get('partner_id', False),
+                                                     line_type='customer',
+                                                     amount=st_line['amount'] if st_line['amount'] else 0.0,
+                                                     context=context)
+                res.update(st_vals)
+        return res
+
+    # Should be private but data are initialised with no update XML
+    def get_from_label_and_partner_field(self, cr, uid, st_line, context=None):
+        """
+        Match the partner based on the label field of the statement line
+        and the text defined in the 'bank_statement_label' field of the partner.
+        Remember that we can have values separated with ; Then, call the generic
+        get_values_for_line method to complete other values.
+        If more than one partner matched, raise the ErrorTooManyPartner error.
+
+        :param dict st_line: read of the concerned account.bank.statement.line
+        :return:
+            A dict of value that can be passed directly to the write method of
+            the statement line or {}
+           {'partner_id': value,
+            'account_id': value,
+
+            ...}
+            """
+        partner_obj = self.pool.get('res.partner')
+        st_obj = self.pool.get('account.bank.statement.line')
+        res = {}
+        # As we have to iterate on each partner for each line,
+        # we memoize the pair to avoid
+        # to redo computation for each line.
+        # Following code can be done by a single SQL query
+        # but this option is not really maintanable
+        if not context.get('label_memoizer'):
+            context['label_memoizer'] = defaultdict(list)
+            partner_ids = partner_obj.search(cr,
+                                             uid,
+                                             [('bank_statement_label', '!=', False)])
+            line_ids = context.get('line_ids', [])
+            for partner in partner_obj.browse(cr, uid, partner_ids, context=context):
+                vals = '|'.join(re.escape(x.strip()) for x in partner.bank_statement_label.split(';'))
+                or_regex = ".*%s.*" % vals
+                sql = ("SELECT id from account_bank_statement_line"
+                       " WHERE id in %s"
+                       " AND name ~* %s")
+                cr.execute(sql, (line_ids, or_regex))
+                pairs = cr.fetchall()
+                for pair in pairs:
+                    context['label_memoizer'][pair[0]].append(partner)
+
+        if st_line['id'] in context['label_memoizer']:
+            found_partner = context['label_memoizer'][st_line['id']]
+            if len(found_partner) > 1:
+                msg = (_('Line named "%s" (Ref:%s) was matched by '
+                         'more than one partner while looking on partner label: %s') %
+                       (st_line['name'], st_line['ref'], ','.join([x.name for x in found_partner])))
+                raise ErrorTooManyPartner(msg)
+            res['partner_id'] = found_partner[0].id
+            st_vals = st_obj.get_values_for_line(cr,
+                                                 uid,
+                                                 profile_id=st_line['profile_id'],
+                                                 master_account_id=st_line['master_account_id'],
+                                                 partner_id=found_partner[0].id,
+                                                 line_type=False,
+                                                 amount=st_line['amount'] if st_line['amount'] else 0.0,
+                                                 context=context)
+            res.update(st_vals)
+        return res
+
+    def get_from_label_and_partner_name(self, cr, uid, st_line, context=None):
+        """
+        Match the partner based on the label field of the statement line
+        and the name of the partner.
+        Then, call the generic get_values_for_line method to complete other values.
+        If more than one partner matched, raise the ErrorTooManyPartner error.
+
+        :param dict st_line: read of the concerned account.bank.statement.line
+        :return:
+            A dict of value that can be passed directly to the write method of
+            the statement line or {}
+           {'partner_id': value,
+            'account_id': value,
+
+            ...}
+            """
+        res = {}
+        # We memoize allowed partner
+        if not context.get('partner_memoizer'):
+            context['partner_memoizer'] = tuple(self.pool['res.partner'].search(cr, uid, []))
+        if not context['partner_memoizer']:
+            return res
+        st_obj = self.pool.get('account.bank.statement.line')
+        sql = "SELECT id FROM res_partner WHERE name ~* %s and id in %s"
+        pattern = ".*%s.*" % re.escape(st_line['name'])
+        cr.execute(sql, (pattern, context['partner_memoizer']))
+        result = cr.fetchall()
+        if not result:
+            return res
+        if len(result) > 1:
+            raise ErrorTooManyPartner(_('Line named "%s" (Ref:%s) was matched by more '
+                                        'than one partner while looking on partner by name') %
+                                      (st_line['name'], st_line['ref']))
+        res['partner_id'] = result[0][0]
+        st_vals = st_obj.get_values_for_line(cr,
+                                             uid,
+                                             profile_id=st_line['porfile_id'],
+                                             master_account_id=st_line['master_account_id'],
+                                             partner_id=res['partner_id'],
+                                             line_type=False,
+                                             amount=st_line['amount'] if st_line['amount'] else 0.0,
+                                             context=context)
+        res.update(st_vals)
+        return res
+
+
+class AccountStatementLine(orm.Model):
+    """
+    Add sparse field on the statement line to allow to store all the
+    bank infos that are given by a bank/office. You can then add you own in your
+    module. The idea here is to store all bank/office infos in the additionnal_bank_fields
+    serialized field when importing the file. If many values, add a tab in the bank
+    statement line to store your specific one. Have a look in account_statement_base_import
+    module to see how we've done it.
+    """
+    _inherit = "account.bank.statement.line"
+
+    _columns = {
+        'additionnal_bank_fields': fields.serialized(
+            'Additionnal infos from bank',
+            help="Used by completion and import system. Adds every field that "
+                 "is present in your bank/office statement file"),
+        'label': fields.sparse(
+            type='char',
+            string='Label',
+            serialization_field='additionnal_bank_fields',
+            help="Generic field to store a label given from the "
+                 "bank/office on which we can base the default/standard "
+                 "providen rule."),
+        'already_completed': fields.boolean(
+            "Auto-Completed",
+            help="When this checkbox is ticked, the auto-completion "
+                 "process/button will ignore this line."),
+    }
+
+    _defaults = {
+        'already_completed': False,
+    }
+
+    def _get_line_values_from_rules(self, cr, uid, line, rules, context=None):
+        """
+        We'll try to find out the values related to the line based on rules setted on
+        the profile.. We will ignore line for which already_completed is ticked.
+
+        :return:
+            A dict of dict value that can be passed directly to the write method of
+            the statement line or {}. The first dict has statement line ID as a key:
+            {117009: {'partner_id': 100997, 'account_id': 489L}}
+        """
+        profile_obj = self.pool.get('account.statement.profile')
+        if line.get('already_completed'):
+            return {}
+        # Ask the rule
+        vals = profile_obj._find_values_from_rules(cr, uid, rules, line, context)
+        if vals:
+            vals['id'] = line['id']
+            return vals
+        return {}
+
+
+class AccountBankSatement(orm.Model):
+    """
+    We add a basic button and stuff to support the auto-completion
+    of the bank statement once line have been imported or manually fullfill.
+    """
+    _inherit = "account.bank.statement"
+
+    _columns = {
+        'completion_logs': fields.text('Completion Log', readonly=True),
+    }
+
+    def write_completion_log(self, cr, uid, stat_id, error_msg, number_imported, context=None):
+        """
+        Write the log in the completion_logs field of the bank statement to let the user
+        know what have been done. This is an append mode, so we don't overwrite what
+        already recoded.
+
+        :param int/long stat_id: ID of the account.bank.statement
+        :param char error_msg: Message to add
+        :number_imported int/long: Number of lines that have been completed
+        :return True
+        """
+        user_name = self.pool.get('res.users').read(cr, uid, uid,
+                                                    ['name'], context=context)['name']
+
+        log = self.read(cr, uid, stat_id, ['completion_logs'],
+                        context=context)['completion_logs']
+        log = log if log else ""
+
+        completion_date = datetime.datetime.now().strftime(DEFAULT_SERVER_DATETIME_FORMAT)
+        message = (_("%s Bank Statement ID %s has %s lines completed by %s \n%s\n%s\n") %
+                   (completion_date, stat_id, number_imported, user_name, error_msg, log))
+        self.write(cr, uid, [stat_id], {'completion_logs': message}, context=context)
+
+        body = (_('Statement ID %s auto-completed for %s lines completed') %
+                (stat_id, number_imported)),
+        self.message_post(cr, uid,
+                          [stat_id],
+                          body=body,
+                          context=context)
+        return True
+
+    def button_auto_completion(self, cr, uid, ids, context=None):
+        """
+        Complete line with values given by rules and tic the already_completed
+        checkbox so we won't compute them again unless the user untick them!
+        """
+        if context is None:
+            context = {}
+        stat_line_obj = self.pool['account.bank.statement.line']
+        profile_obj = self.pool.get('account.statement.profile')
+        compl_lines = 0
+        stat_line_obj.check_access_rule(cr, uid, [], 'create')
+        stat_line_obj.check_access_rights(cr, uid, 'create', raise_exception=True)
+        for stat in self.browse(cr, uid, ids, context=context):
+            msg_lines = []
+            ctx = context.copy()
+            ctx['line_ids'] = tuple((x.id for x in stat.line_ids))
+            b_profile = stat.profile_id
+            rules = profile_obj._get_callable(cr, uid, b_profile, context=context)
+            profile_id = b_profile.id  # Only for perfo even it gains almost nothing
+            master_account_id = b_profile.receivable_account_id
+            master_account_id = master_account_id.id if master_account_id else False
+            res = False
+            for line in stat_line_obj.read(cr, uid, ctx['line_ids']):
+                try:
+                    # performance trick
+                    line['master_account_id'] = master_account_id
+                    line['profile_id'] = profile_id
+                    res = stat_line_obj._get_line_values_from_rules(cr, uid, line,
+                                                                    rules, context=ctx)
+                    if res:
+                        compl_lines += 1
+                except ErrorTooManyPartner, exc:
+                    msg_lines.append(repr(exc))
+                except Exception, exc:
+                    msg_lines.append(repr(exc))
+                    error_type, error_value, trbk = sys.exc_info()
+                    st = "Error: %s\nDescription: %s\nTraceback:" % (error_type.__name__, error_value)
+                    st += ''.join(traceback.format_tb(trbk, 30))
+                    _logger.error(st)
+                if res:
+                    #stat_line_obj.write(cr, uid, [line.id], vals, context=ctx)
+                    try:
+                        stat_line_obj._update_line(cr, uid, res, context=context)
+                    except Exception as exc:
+                        msg_lines.append(repr(exc))
+                        error_type, error_value, trbk = sys.exc_info()
+                        st = "Error: %s\nDescription: %s\nTraceback:" % (error_type.__name__, error_value)
+                        st += ''.join(traceback.format_tb(trbk, 30))
+                        _logger.error(st)
+                    # we can commit as it is not needed to be atomic
+                    # commiting here adds a nice perfo boost
+                    if not compl_lines % 500:
+                        cr.commit()
+            msg = u'\n'.join(msg_lines)
+            self.write_completion_log(cr, uid, stat.id,
+                                      msg, compl_lines, context=context)
+        return True
 
=== added file 'account_statement_base_completion/statement_view.xml'
--- account_statement_base_completion/statement_view.xml	1970-01-01 00:00:00 +0000
+++ account_statement_base_completion/statement_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,104 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data>
+
+    <record id="bank_statement_view_form" model="ir.ui.view">
+         <field name="name">account_bank_statement_import_base.bank_statement.view_form</field>
+         <field name="model">account.bank.statement</field>
+         <field name="inherit_id" ref="account.view_bank_statement_form" />
+         <field eval="16" name="priority"/>
+         <field name="type">form</field>
+         <field name="arch" type="xml">
+             <data>
+                 <xpath expr="/form/sheet/notebook/page/field[@name='line_ids']/form/group/field[@name='sequence']" position="after">
+                     <separator colspan="4" string="Importation related infos"/>
+                    <field name="label" />
+                    <field name="already_completed" />
+                 </xpath>
+
+                 <!-- <xpath expr="/form/group[2]" position="attributes">
+                                     <attribute name="col">10</attribute>
+                                 </xpath> -->
+
+                 <xpath expr="/form/sheet/div[@name='import_buttons']" position="after">
+                     <button name="button_auto_completion" string="Auto Completion" states='draft,open' type="object" colspan="1"/>
+                 </xpath>
+                 
+                 <xpath expr="/form/sheet/notebook/page[@string='Transactions']" position="after">
+                      <page string="Completion Logs" attrs="{'invisible':[('completion_logs','=',False)]}">
+                          <field name="completion_logs" colspan="4" nolabel="1" attrs="{'invisible':[('completion_logs','=',False)]}"/>
+                      </page>
+                 </xpath>
+
+             </data>
+         </field>
+     </record>
+    <record id="bank_statement_view_form2" model="ir.ui.view">
+         <field name="name">account_bank_statement_import_base.bank_statement.auto_cmpl</field>
+         <field name="model">account.bank.statement</field>
+         <field name="inherit_id" ref="account.view_bank_statement_form" />
+         <field name="type">form</field>
+         <field name="arch" type="xml">
+             <data>
+                 <xpath expr="/form/sheet/notebook/page/field[@name='line_ids']/tree/field[@name='amount']" position="after">
+                    <field name="already_completed" />
+                 </xpath>
+             </data>
+         </field>
+     </record>
+
+     <record id="statement_rules_view_form" model="ir.ui.view">
+         <field name="name">account.statement.profile.view</field>
+         <field name="model">account.statement.profile</field>
+         <field name="inherit_id" ref="account_statement_ext.statement_importer_view_form"/>
+         <field name="type">form</field>
+         <field name="arch" type="xml">
+             <field name="bank_statement_prefix" position="after">
+                 <separator colspan="4" string="Auto-Completion Rules"/>
+                 <field name="rule_ids" colspan="4" nolabel="1"/>
+             </field>
+         </field>
+     </record>
+    
+    
+         <record id="statement_st_completion_rule_view_form" model="ir.ui.view">
+             <field name="name">account.statement.completion.rule.view</field>
+             <field name="model">account.statement.completion.rule</field>
+             <field name="type">form</field>
+             <field name="arch" type="xml">
+                 <form string="Statement Completion Rule">
+                     <field name="sequence"/>
+                     <field name="name" select="1" />
+                     <field name="function_to_call"/>
+                     <separator colspan="4" string="Related Profiles"/>
+                     <field name="profile_ids" nolabel="1" colspan="4"/>
+                 </form>
+             </field>
+         </record>
+
+         <record id="statement_st_completion_rule_view_tree" model="ir.ui.view">
+             <field name="name">account.statement.completion.rule.view</field>
+             <field name="model">account.statement.completion.rule</field>
+             <field name="type">tree</field>
+             <field name="arch" type="xml">
+                 <tree string="Statement Completion Rule">
+                     <field name="sequence"/>
+                     <field name="name" select="1" />
+                     <field name="profile_ids" />
+                     <field name="function_to_call"/>
+                 </tree>
+             </field>
+         </record>
+         <record id="action_st_completion_rule_tree" model="ir.actions.act_window">
+             <field name="name">Statement Completion Rule</field>
+             <field name="res_model">account.statement.completion.rule</field>
+             <field name="view_type">form</field>
+             <field name="view_mode">tree,form</field>
+         </record>
+
+         <menuitem string="Statement Completion Rule" action="action_st_completion_rule_tree"
+             id="menu_action_st_completion_rule_tree_menu" parent="account.menu_configuration_misc" 
+             sequence="30"/>
+    
+</data>
+</openerp>
 
=== added directory 'account_statement_base_import'
=== added file 'account_statement_base_import/__init__.py'
--- account_statement_base_import/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,23 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import parser
+import wizard
+import statement
 
=== added file 'account_statement_base_import/__openerp__.py'
--- account_statement_base_import/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/__openerp__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,70 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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': "Bank statement base import",
+ 'version': '1.0',
+ 'author': 'Camptocamp',
+ 'maintainer': 'Camptocamp',
+ 'category': 'Finance',
+ 'complexity': 'normal',
+ 'depends': [
+     'account_statement_ext',
+     'account_statement_base_completion'
+     ],
+ 'description': """
+ This module brings basic methods and fields on bank statement to deal with
+ the importation of different bank and offices. A generic abstract method is defined and an
+ example that gives you a basic way of importing bank statement through a standard file is provided.
+
+ This module improves the bank statement and allows you to import your bank transactions with
+ a standard .csv or .xls file (you'll find it in the 'data' folder). It respects the profile
+ (provided by the accouhnt_statement_ext module) to pass the entries. That means,
+ you'll have to choose a file format for each profile.
+ In order to achieve this it uses the `xlrd` Python module which you will need to install
+ separately in your environment.
+
+ This module can handle a commission taken by the payment office and has the following format:
+
+ * ref :               the SO number, INV number or any matching ref found. It'll be used as reference
+                       in the generated entries and will be useful for reconciliation process
+ * date :              date of the payment
+ * amount :            amount paid in the currency of the journal used in the importation profile
+ * commission_amount : amount of the comission for each line
+ * label :             the comunication given by the payment office, used as communication in the
+                       generated entries.
+
+ The goal is here to populate the statement lines of a bank statement with the infos that the
+ bank or office give you. Fell free to inherit from this module to add your own format.Then,
+ if you need to complete data from there, add your own account_statement_*_completion module and implement
+ the needed rules.
+
+ """,
+ 'website': 'http://www.camptocamp.com',
+ 'data': [
+        "wizard/import_statement_view.xml",
+        "statement_view.xml",
+ ],
+ 'test': [],
+ 'installable': True,
+ 'images': [],
+ 'auto_install': False,
+ 'license': 'AGPL-3',
+}
 
=== added directory 'account_statement_base_import/data'
=== added file 'account_statement_base_import/data/statement.csv'
--- account_statement_base_import/data/statement.csv	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/data/statement.csv	2013-06-10 06:07:03 +0000
@@ -0,0 +1,4 @@
+"ref";"date";"amount";"commission_amount";"label"
[phone];2011-03-07 13:45:14;118.4;-11.84;"label a"
[phone];2011-03-05 13:45:14;189;-15.12;"label b"
[phone];2011-03-02 17:45:14;189;-15.12;"label c"
 
=== added file 'account_statement_base_import/data/statement.xls'
 Binary files account_statement_base_import/data/statement.xls	1970-01-01 00:00:00 +0000 and account_statement_base_import/data/statement.xls	2013-06-10 06:07:03 +0000 differ
=== added directory 'account_statement_base_import/i18n'
=== added file 'account_statement_base_import/i18n/fr.po'
--- account_statement_base_import/i18n/fr.po	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/i18n/fr.po	2013-06-10 06:07:03 +0000
@@ -0,0 +1,253 @@
+#. module: account_statement_base_import
+#: view:credit.statement.import:0
+#: model:ir.actions.act_window,name:account_statement_base_import.statement_importer_action
+msgid "Import statement"
+msgstr "Import de relevé"
+
+#. module: account_statement_base_import
+#: model:ir.model,name:account_statement_base_import.model_credit_statement_import
+msgid "credit.statement.import"
+msgstr "credit.statement.import"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:218
+#, python-format
+msgid "The statement cannot be created : %s"
+msgstr "Le relevé ne peut être créé : %s"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,input_statement:0
+msgid "Statement file"
+msgstr "Fichier à importer"
+
+#. module: account_statement_base_import
+#: view:account.statement.profile:0
+msgid "Import Logs"
+msgstr "Journaux d'import"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,journal_id:0
+msgid "Financial journal to use transaction"
+msgstr "Journal"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/parser/file_parser.py:100
+#, python-format
+msgid "Column %s not present in file"
+msgstr "Colonne %s non présente dans le fichier"
+
+#. module: account_statement_base_import
+#: view:account.statement.profile:0
+#: model:ir.ui.menu,name:account_statement_base_import.statement_importer_menu
+msgid "Import Bank Statement"
+msgstr "Importation de relevé"
+
+#. module: account_statement_base_import
+#: model:ir.model,name:account_statement_base_import.model_account_statement_profile
+msgid "Statement Profil"
+msgstr "Profil du relevé"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:100
+#, python-format
+msgid "Commission line"
+msgstr "Ligne de commission"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,commission_account_id:0
+msgid "Commission account"
+msgstr "Compte de commission"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:172
+#, python-format
+msgid "Column %s you try to import is not present in the bank statement line !"
+msgstr ""
+"La colonne %s que vous essayez d'importer n'est pas présente dans la ligne de relevé !"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:71
+#, python-format
+msgid "Bank Statement ID %s have been imported with %s lines "
+msgstr "Le relevé avec l'ID %s a été importé avec %s lignes "
+
+#. module: account_statement_base_import
+#: field:account.statement.profile,launch_import_completion:0
+msgid "Launch completion after import"
+msgstr "Lancer l'auto-complétion après import"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,partner_id:0
+msgid "Credit insitute partner"
+msgstr "Organisme bancaire"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:160
+#, python-format
+msgid "No Profile !"
+msgstr "Aucun Profil !"
+
+#. module: account_statement_base_import
+#: view:account.statement.profile:0
+msgid "Import related infos"
+msgstr "Importation des informations liées"
+
+#. module: account_statement_base_import
+#: help:credit.statement.import,force_partner_on_bank:0
+msgid ""
+"Tic that box if you want to use the credit insitute "
+"partner                                                    in the "
+"counterpart of the treasury/banking move."
+msgstr ""
+"Cochez cette case si vous voulez utiliser comme partenaire "
+"l'organisme bancaire au niveau de la ligne de banque"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/wizard/import_statement.py:93
+#, python-format
+msgid "Please use a file with an extention"
+msgstr "Veuillez sélectionner un fichier avec une extension"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:161
+#, python-format
+msgid "You must provide a valid profile to import a bank statement !"
+msgstr "Vous devez fournir un profil valide pour importer un relevé !"
+
+#. module: account_statement_base_import
+#: help:credit.statement.import,balance_check:0
+msgid ""
+"Tic that box if you want OpenERP to control the start/end "
+"balance                                                    before confirming "
+"a bank statement. If don't ticked, no balance control will be done."
+msgstr ""
+"Cochez cette case si vous souhaitez un contrôle du solde final "
+"avant la validation du relevé."
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/parser/file_parser.py:31
+#: code:addons/account_statement_base_import/parser/generic_file_parser.py:31
+#, python-format
+msgid "Please install python lib xlrd"
+msgstr "Veuillez installer la bibliothèque python xlrd"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/parser/file_parser.py:58
+#, python-format
+msgid "Invalide file type %s. please use csv or xls"
+msgstr "Type de fichier invalide : %s. Veuillez utiliser un csv ou un xls"
+
+#. module: account_statement_base_import
+#: field:account.statement.profile,last_import_date:0
+msgid "Last Import Date"
+msgstr "Date de dernier import"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,commission_analytic_id:0
+msgid "Commission analytic account"
+msgstr "Compte analytique de la commission"
+
+#. module: account_statement_base_import
+#: constraint:account.statement.profile:0
+msgid "You need to put a partner if you tic the 'Force partner on bank move' !"
+msgstr ""
+"Vous devez spécifier un partenaire si vous avez coché 'Forcer un partenaire sur la ligne de la banque' !"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:217
+#, python-format
+msgid "Statement import error"
+msgstr "Erreur d'import de relevé"
+
+#. module: account_statement_base_import
+#: field:account.bank.statement.line,commission_amount:0
+msgid "Line Commission Amount"
+msgstr "Montant de la commission de la ligne"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/statement.py:171
+#, python-format
+msgid "Missing column !"
+msgstr "Colonne manquante !"
+
+#. module: account_statement_base_import
+#: field:account.statement.profile,rec_log:0
+msgid "log"
+msgstr "journal"
+
+#. module: account_statement_base_import
+#: field:account.statement.profile,import_type:0
+msgid "Type of import"
+msgstr "Type d'import"
+
+#. module: account_statement_base_import
+#: constraint:account.bank.statement.line:0
+msgid ""
+"The amount of the voucher must be the same amount as the one on the "
+"statement line"
+msgstr ""
+"Le montant du justificatif doit être identique à celui de la ligne le "
+"concernant sur le relevé"
+
+#. module: account_statement_base_import
+#: help:account.statement.profile,launch_import_completion:0
+msgid ""
+"Tic that box to automatically launch the completion on each "
+"imported                file using this profile."
+msgstr ""
+"Cocher cette case pour lancer automatiquement l'auto-complétion sur"
+"chaque fichier importé avec ce profil."
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,profile_id:0
+msgid "Import configuration parameter"
+msgstr "Paramètres de configuration d'import"
+
+#. module: account_statement_base_import
+#: code:addons/account_statement_base_import/parser/parser.py:156
+#, python-format
+msgid "No buffer file given."
+msgstr "Pas de fichier tampon donné."
+
+#. module: account_statement_base_import
+#: view:credit.statement.import:0
+msgid "Import Parameters Summary"
+msgstr "Résumé des paramètres d'import"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,balance_check:0
+msgid "Balance check"
+msgstr "Vérification des soldes"
+
+#. module: account_statement_base_import
+#: model:ir.model,name:account_statement_base_import.model_account_bank_statement_line
+msgid "Bank Statement Line"
+msgstr "Ligne de relevé bancaire"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,force_partner_on_bank:0
+msgid "Force partner on bank move"
+msgstr "Forcer un partenaire sur la ligne du compte de banque"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,file_name:0
+msgid "File Name"
+msgstr "Nom du fichier"
+
+#. module: account_statement_base_import
+#: field:credit.statement.import,receivable_account_id:0
+msgid "Force Receivable/Payable Account"
+msgstr "Forcer le compte Client/Fournisseur"
+
+#. module: account_statement_base_import
+#: help:account.statement.profile,import_type:0
+msgid ""
+"Choose here the method by which you want to import bank statement for this "
+"profile."
+msgstr ""
+"Choisissez la méthode d'import de relevé pour ce profil."
+
+#. module: account_statement_base_import
+#: view:credit.statement.import:0
+msgid "Cancel"
+msgstr "Annulation"
 
=== added directory 'account_statement_base_import/parser'
=== added file 'account_statement_base_import/parser/__init__.py'
--- account_statement_base_import/parser/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/parser/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Nicolas Bessi, Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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 parser import new_bank_statement_parser
+from parser import BankStatementImportParser
+import file_parser
+import generic_file_parser
 
=== added file 'account_statement_base_import/parser/file_parser.py'
--- account_statement_base_import/parser/file_parser.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/parser/file_parser.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,218 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright Camptocamp SA
+#    Author Nicolas Bessi, Joel Grand-Guillaume
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+from openerp.tools.translate import _
+from openerp.osv.osv import except_osv
+import tempfile
+import datetime
+from parser import BankStatementImportParser
+from parser import UnicodeDictReader
+try:
+    import xlrd
+except:
+    raise Exception(_('Please install python lib xlrd'))
+
+
+class FileParser(BankStatementImportParser):
+    """
+    Generic abstract class for defining parser for .csv or .xls file format.
+    """
+
+    def __init__(self, parse_name, keys_to_validate=None, ftype='csv', conversion_dict=None,
+                 header=None, *args, **kwargs):
+        """
+            :param char: parse_name : The name of the parser
+            :param list: keys_to_validate : contain the key that need to be present in the file
+            :param char ftype: extension of the file (could be csv or xls)
+            :param: conversion_dict : keys and type to convert of every column in the file like
+                {
+                    'ref': unicode,
+                    'label': unicode,
+                    'date': datetime.datetime,
+                    'amount': float,
+                    'commission_amount': float
+                }
+            :param list: header : specify header fields if the csv file has no header
+            """
+
+        super(FileParser, self).__init__(parse_name, *args, **kwargs)
+        if ftype in ('csv', 'xls'):
+            self.ftype = ftype
+        else:
+            raise except_osv(_('User Error'),
+                             _('Invalid file type %s. Please use csv or xls') % ftype)
+        self.keys_to_validate = keys_to_validate if keys_to_validate is not None else [] 
+        self.conversion_dict = conversion_dict
+        self.fieldnames = header
+        self._datemode = 0  # used only for xls documents,
+                            # 0 means Windows mode (1900 based dates).
+                            # Set in _parse_xls, from the contents of the file
+
+    def _custom_format(self, *args, **kwargs):
+        """
+        No other work on data are needed in this parser.
+        """
+        return True
+
+    def _pre(self, *args, **kwargs):
+        """
+        No pre-treatment needed for this parser.
+        """
+        return True
+
+    def _parse(self, *args, **kwargs):
+        """
+        Launch the parsing through .csv or .xls depending on the
+        given ftype
+        """
+
+        res = None
+        if self.ftype == 'csv':
+            res = self._parse_csv()
+        else:
+            res = self._parse_xls()
+        self.result_row_list = res
+        return True
+
+    def _validate(self, *args, **kwargs):
+        """
+        We check that all the key of the given file (means header) are present
+        in the validation key provided. Otherwise, we raise an Exception.
+        We skip the validation step if the file header is provided separately
+        (in the field: fieldnames).
+        """
+        if self.fieldnames is None:
+            parsed_cols = self.result_row_list[0].keys()
+            for col in self.keys_to_validate:
+                if col not in parsed_cols:
+                    raise except_osv(_('Invalid data'),
+                                     _('Column %s not present in file') % col)
+        return True
+
+    def _post(self, *args, **kwargs):
+        """
+        Cast row type depending on the file format .csv or .xls after parsing the file.
+        """
+        self.result_row_list = self._cast_rows(*args, **kwargs)
+        return True
+
+    def _parse_csv(self):
+        """
+        :return: list of dict from csv file (line/rows)
+        """
+        csv_file = tempfile.NamedTemporaryFile()
+        csv_file.write(self.filebuffer)
+        csv_file.flush()
+        with open(csv_file.name, 'rU') as fobj:
+            reader = UnicodeDictReader(fobj, fieldnames=self.fieldnames)
+            return list(reader)
+
+    def _parse_xls(self):
+        """
+        :return: dict of dict from xls file (line/rows)
+        """
+        wb_file = tempfile.NamedTemporaryFile()
+        wb_file.write(self.filebuffer)
+        # We ensure that cursor is at beginig of file
+        wb_file.seek(0)
+        with xlrd.open_workbook(wb_file.name) as wb:
+            self._datemode = wb.datemode
+            sheet = wb.sheet_by_index(0)
+            header = sheet.row_values(0)
+            res = []
+            for rownum in range(1, sheet.nrows):
+                res.append(dict(zip(header, sheet.row_values(rownum))))
+        return res
+
+    def _from_csv(self, result_set, conversion_rules):
+        """
+        Handle the converstion from the dict and handle date format from
+        an .csv file.
+        """
+        for line in result_set:
+            for rule in conversion_rules:
+                if conversion_rules[rule] == datetime.datetime:
+                    try:
+                        date_string = line[rule].split(' ')[0]
+                        line[rule] = datetime.datetime.strptime(date_string,
+                                                                '%Y-%m-%d')
+                    except ValueError as err:
+                        raise except_osv(_("Date format is not valid."),
+                                         _(" It should be YYYY-MM-DD for column: %s"
+                                           " value: %s \n \n"
+                                           " \n Please check the line with ref: %s"
+                                           " \n \n Detail: %s") % (rule,
+                                                                   line.get(rule, _('Missing')),
+                                                                   line.get('ref', line),
+                                                                   repr(err)))
+                else:
+                    try:
+                        line[rule] = conversion_rules[rule](line[rule])
+                    except Exception as err:
+                        raise except_osv(_('Invalid data'),
+                                         _("Value %s of column %s is not valid."
+                                           "\n Please check the line with ref %s:"
+                                           "\n \n Detail: %s") % (line.get(rule, _('Missing')),
+                                                                  rule,
+                                                                  line.get('ref', line),
+                                                                  repr(err)))
+        return result_set
+
+    def _from_xls(self, result_set, conversion_rules):
+        """
+        Handle the converstion from the dict and handle date format from
+        an .xls file.
+        """
+        for line in result_set:
+            for rule in conversion_rules:
+                if conversion_rules[rule] == datetime.datetime:
+                    try:
+                        t_tuple = xlrd.xldate_as_tuple(line[rule], self._datemode)
+                        line[rule] = datetime.datetime(*t_tuple)
+                    except Exception as err:
+                        raise except_osv(_("Date format is not valid"),
+                                         _("Please modify the cell formatting to date format"
+                                           " for column: %s"
+                                           " value: %s"
+                                           "\n Please check the line with ref: %s"
+                                           "\n \n Detail: %s") % (rule,
+                                                                  line.get(rule, _('Missing')),
+                                                                  line.get('ref', line),
+                                                                  repr(err)))
+                else:
+                    try:
+                        line[rule] = conversion_rules[rule](line[rule])
+                    except Exception as err:
+                        raise except_osv(_('Invalid data'),
+                                         _("Value %s of column %s is not valid."
+                                           "\n Please check the line with ref %s:"
+                                           "\n \n Detail: %s") % (line.get(rule, _('Missing')),
+                                                                  rule,
+                                                                  line.get('ref', line),
+                                                                  repr(err)))
+        return result_set
+
+    def _cast_rows(self, *args, **kwargs):
+        """
+        Convert the self.result_row_list using the self.conversion_dict providen.
+        We call here _from_xls or _from_csv depending on the self.ftype variable.
+        """
+        func = getattr(self, '_from_%s' % self.ftype)
+        res = func(self.result_row_list, self.conversion_dict)
+        return res
 
=== added file 'account_statement_base_import/parser/generic_file_parser.py'
--- account_statement_base_import/parser/generic_file_parser.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/parser/generic_file_parser.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,102 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Copyright Camptocamp SA
+#    Author Joel Grand-Guillaume
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.tools.translate import _
+import base64
+import csv
+import tempfile
+import datetime
+from file_parser import FileParser
+try:
+    import xlrd
+except:
+    raise Exception(_('Please install python lib xlrd'))
+
+
+def float_or_zero(val):
+    """ Conversion function used to manage
+    empty string into float usecase"""
+    return float(val) if val else 0.0
+
+
+class GenericFileParser(FileParser):
+    """
+    Standard parser that use a define format in csv or xls to import into a
+    bank statement. This is mostely an example of how to proceed to create a new
+    parser, but will also be useful as it allow to import a basic flat file.
+    """
+
+    def __init__(self, parse_name, ftype='csv'):
+        conversion_dict = {
+                            'ref': unicode,
+                            'label': unicode,
+                            'date': datetime.datetime,
+                            'amount': float_or_zero,
+                            'commission_amount': float_or_zero
+                          }
+        # Order of cols does not matter but first row of the file has to be header
+        keys_to_validate = ['ref', 'label', 'date', 'amount', 'commission_amount']
+        super(GenericFileParser, self).__init__(parse_name, keys_to_validate=keys_to_validate, ftype=ftype, conversion_dict=conversion_dict)
+
+    @classmethod
+    def parser_for(cls, parser_name):
+        """
+        Used by the new_bank_statement_parser class factory. Return true if
+        the providen name is generic_csvxls_so
+        """
+        return parser_name == 'generic_csvxls_so'
+
+    def get_st_line_vals(self, line, *args, **kwargs):
+        """
+        This method must return a dict of vals that can be passed to create
+        method of statement line in order to record it. It is the responsibility
+        of every parser to give this dict of vals, so each one can implement his
+        own way of recording the lines.
+            :param:  line: a dict of vals that represent a line of result_row_list
+            :return: dict of values to give to the create method of statement line,
+                     it MUST contain at least:
+                {
+                    'name':value,
+                    'date':value,
+                    'amount':value,
+                    'ref':value,
+                    'label':value,
+                    'commission_amount':value,
+                }
+        In this generic parser, the commission is given for every line, so we store it
+        for each one.
+        """
+        return {'name': line.get('label', line.get('ref', '/')),
+                'date': line.get('date', datetime.datetime.now().date()),
+                'amount': line.get('amount', 0.0),
+                'ref': line.get('ref', '/'),
+                'label': line.get('label', ''),
+                'commission_amount': line.get('commission_amount', 0.0)}
+
+    def _post(self, *args, **kwargs):
+        """
+        Compute the commission from value of each line
+        """
+        res = super(GenericFileParser, self)._post(*args, **kwargs)
+        val = 0.0
+        for row in self.result_row_list:
+            val += row.get('commission_amount', 0.0)
+        self.commission_global_amount = val
+        return res
 
=== added file 'account_statement_base_import/parser/parser.py'
--- account_statement_base_import/parser/parser.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/parser/parser.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,219 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import base64
+import csv
+
+
+def UnicodeDictReader(utf8_data, **kwargs):
+    sniffer = csv.Sniffer()
+    pos = utf8_data.tell()
+    sample_data = utf8_data.read(1024)
+    utf8_data.seek(pos)
+    dialect = sniffer.sniff(sample_data, delimiters=',;\t')
+    csv_reader = csv.DictReader(utf8_data, dialect=dialect, **kwargs)
+    for row in csv_reader:
+        yield dict([(key, unicode(value, 'utf-8')) for key, value in row.iteritems()])
+
+
+class BankStatementImportParser(object):
+    """
+    Generic abstract class for defining parser for different files and
+    format to import in a bank statement. Inherit from it to create your
+    own. If your file is a .csv or .xls format, you should consider inheirt
+    from the FileParser instead.
+    """
+
+    def __init__(self, parser_name, *args, **kwargs):
+        # The name of the parser as it will be called
+        self.parser_name = parser_name
+        # The result as a list of row. One row per line of data in the file, but
+        # not the commission one !
+        self.result_row_list = None
+        # The file buffer on which to work on
+        self.filebuffer = None
+        # Concatenate here the global commission taken by the bank/office
+        # for this statement.
+        self.commission_global_amount = None
+
+    @classmethod
+    def parser_for(cls, parser_name):
+        """
+        Override this method for every new parser, so that new_bank_statement_parser can
+        return the good class from his name.
+        """
+        return False
+
+    def _decode_64b_stream(self):
+        """
+        Decode self.filebuffer in base 64 and override it
+        """
+        self.filebuffer = base64.b64decode(self.filebuffer)
+        return True
+
+    def _format(self, decode_base_64=True, **kwargs):
+        """
+        Decode into base 64 if asked and Format the given filebuffer by calling
+        _custom_format method.
+        """
+        if decode_base_64:
+            self._decode_64b_stream()
+        self._custom_format(kwargs)
+        return True
+
+    def _custom_format(self, *args, **kwargs):
+        """
+        Implement a method in your parser to convert format, encoding and so on before
+        starting to work on datas. Work on self.filebuffer
+        """
+        return NotImplementedError
+
+    def _pre(self, *args, **kwargs):
+        """
+        Implement a method in your parser to make a pre-treatment on datas before parsing
+        them, like concatenate stuff, and so... Work on self.filebuffer
+        """
+        return NotImplementedError
+
+    def _parse(self, *args, **kwargs):
+        """
+        Implement a method in your parser to save the result of parsing self.filebuffer
+        in self.result_row_list instance property.
+        """
+        return NotImplementedError
+
+    def _validate(self, *args, **kwargs):
+        """
+        Implement a method in your parser  to validate the self.result_row_list instance
+        property and raise an error if not valid.
+        """
+        return NotImplementedError
+
+    def _post(self, *args, **kwargs):
+        """
+        Implement a method in your parser to make some last changes on the result of parsing
+        the datas, like converting dates, computing commission, ...
+        Work on self.result_row_list and put the commission global amount if any
+        in the self.commission_global_amount one.
+        """
+        return NotImplementedError
+
+    def get_st_line_vals(self, line, *args, **kwargs):
+        """
+        Implement a method in your parser that must return a dict of vals that can be
+        passed to create method of statement line in order to record it. It is the responsibility
+        of every parser to give this dict of vals, so each one can implement his
+        own way of recording the lines.
+            :param:  line: a dict of vals that represent a line of result_row_list
+            :return: dict of values to give to the create method of statement line,
+                     it MUST contain at least:
+                {
+                    'name':value,
+                    'date':value,
+                    'amount':value,
+                    'ref':value,
+                }
+        """
+        return NotImplementedError
+
+    def get_st_line_commision(self, *args, **kwargs):
+        """
+        This is called by the importation method to create the commission line in
+        the bank statement. We will always create one line for the commission in the
+        bank statement, but it could be computated from a value of each line, or given
+        in a single line for the whole file.
+            return: float of the whole commission (self.commission_global_amount)
+        """
+        return self.commission_global_amount
+
+    def parse(self, filebuffer, *args, **kwargs):
+        """
+        This will be the method that will be called by wizard, button and so
+        to parse a filebuffer by calling successively all the private method
+        that need to be define for each parser.
+        Return:
+             [] of rows as {'key':value}
+
+        Note: The row_list must contain only value that are present in the account.
+        bank.statement.line object !!!
+        """
+        if filebuffer:
+            self.filebuffer = filebuffer
+        else:
+            raise Exception(_('No buffer file given.'))
+        self._format(*args, **kwargs)
+        self._pre(*args, **kwargs)
+        self._parse(*args, **kwargs)
+        self._validate(*args, **kwargs)
+        self._post(*args, **kwargs)
+        return self.result_row_list
+
+
+def itersubclasses(cls, _seen=None):
+    """
+    itersubclasses(cls)
+
+    Generator over all subclasses of a given class, in depth first order.
+
+    >>> list(itersubclasses(int)) == [bool]
+    True
+    >>> class A(object): pass
+    >>> class B(A): pass
+    >>> class C(A): pass
+    >>> class D(B,C): pass
+    >>> class E(D): pass
+    >>>
+    >>> for cls in itersubclasses(A):
+    ...     print(cls.__name__)
+    B
+    D
+    E
+    C
+    >>> # get ALL (new-style) classes currently defined
+    >>> [cls.__name__ for cls in itersubclasses(object)] #doctest: +ELLIPSIS
+    ['type', ...'tuple', ...]
+    """
+    if not isinstance(cls, type):
+        raise TypeError('itersubclasses must be called with '
+                        'new-style classes, not %.100r' % cls)
+    if _seen is None:
+        _seen = set()
+    try:
+        subs = cls.__subclasses__()
+    except TypeError:  # fails only when cls is type
+        subs = cls.__subclasses__(cls)
+    for sub in subs:
+        if sub not in _seen:
+            _seen.add(sub)
+            yield sub
+            for sub in itersubclasses(sub, _seen):
+                yield sub
+
+
+def new_bank_statement_parser(parser_name, *args, **kwargs):
+    """
+    Return an instance of the good parser class base on the providen name
+    :param char: parser_name
+    :return: class instance of parser_name providen.
+    """
+    for cls in itersubclasses(BankStatementImportParser):
+        if cls.parser_for(parser_name):
+            return cls(parser_name, *args, **kwargs)
+    raise ValueError
 
=== added file 'account_statement_base_import/statement.py'
--- account_statement_base_import/statement.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/statement.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,303 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import sys
+import traceback
+
+import psycopg2
+
+from openerp.tools.translate import _
+import datetime
+from openerp.osv.orm import Model
+from openerp.osv import fields, osv
+from parser import new_bank_statement_parser
+
+
+class AccountStatementProfil(Model):
+    _inherit = "account.statement.profile"
+
+    def get_import_type_selection(self, cr, uid, context=None):
+        """
+        Has to be inherited to add parser
+        """
+        return [('generic_csvxls_so', 'Generic .csv/.xls based on SO Name')]
+
+    _columns = {
+        'launch_import_completion': fields.boolean(
+            "Launch completion after import",
+            help="Tic that box to automatically launch the completion "
+                 "on each imported file using this profile."),
+        'last_import_date': fields.datetime("Last Import Date"),
+        #  we remove deprecated as it floods logs in standard/warning level sob...
+        'rec_log': fields.text('log', readonly=True),  # Deprecated
+        'import_type': fields.selection(
+            get_import_type_selection,
+            'Type of import',
+            required=True,
+            help="Choose here the method by which you want to import bank"
+                 "statement for this profile."),
+
+    }
+
+    def write_logs_after_import(self, cr, uid, ids, statement_id, num_lines, context):
+        """
+        Write the log in the logger
+
+        :param int/long statement_id: ID of the concerned account.bank.statement
+        :param int/long num_lines: Number of line that have been parsed
+        :return: True
+        """
+        self.message_post(cr,
+                          uid,
+                          ids,
+                          body=_('Statement ID %s have been imported with %s lines.') %
+                                (statement_id, num_lines),
+                          context=context)
+        return True
+
+    def prepare_global_commission_line_vals(
+            self, cr, uid, parser, result_row_list, profile, statement_id, context):
+        """
+        Prepare the global commission line if there is one. The global
+        commission is computed by by calling the get_st_line_commision
+        of the parser. Feel free to override the method to compute
+        your own commission line from the result_row_list.
+
+            :param:    browse_record of the current parser
+            :param:    result_row_list: [{'key':value}]
+            :param:    profile: browserecord of account.statement.profile
+            :param:    statement_id: int/long of the current importing statement ID
+            :param:    context: global context
+            return:    dict of vals that will be passed to create method of statement line.
+        """
+        comm_values = False
+        if parser.get_st_line_commision():
+            partner_id = profile.partner_id and profile.partner_id.id or False
+            commission_account_id = profile.commission_account_id and profile.commission_account_id.id or False
+            commission_analytic_id = profile.commission_analytic_id and profile.commission_analytic_id.id or False
+            comm_values = {
+                'name': 'IN ' + _('Commission line'),
+                'date': datetime.datetime.now().date(),
+                'amount': parser.get_st_line_commision(),
+                'partner_id': partner_id,
+                'type': 'general',
+                'statement_id': statement_id,
+                'account_id': commission_account_id,
+                'ref': 'commission',
+                'analytic_account_id': commission_analytic_id,
+                # !! We set the already_completed so auto-completion will not update those values!
+                'already_completed': True,
+            }
+        return comm_values
+
+    def prepare_statetement_lines_vals(
+            self, cr, uid, parser_vals, account_payable, account_receivable,
+            statement_id, context):
+        """
+        Hook to build the values of a line from the parser returned values. At
+        least it fullfill the statement_id and account_id. Overide it to add your
+        own completion if needed.
+
+        :param dict of vals from parser for account.bank.statement.line (called by
+                parser.get_st_line_vals)
+        :param int/long account_payable: ID of the receivable account to use
+        :param int/long account_receivable: ID of the payable account to use
+        :param int/long statement_id: ID of the concerned account.bank.statement
+        :return: dict of vals that will be passed to create method of statement line.
+        """
+        statement_obj = self.pool.get('account.bank.statement')
+        values = parser_vals
+        values['statement_id'] = statement_id
+        values['account_id'] = statement_obj.get_account_for_counterpart(cr,
+                                                                         uid,
+                                                                         parser_vals['amount'],
+                                                                         account_receivable,
+                                                                         account_payable)
+
+        date = values.get('date')
+        period_memoizer = context.get('period_memoizer')
+        if not period_memoizer:
+            period_memoizer = {}
+            context['period_memoizer'] = period_memoizer
+        if period_memoizer.get(date):
+            values['period_id'] = period_memoizer[date]
+        else:
+            # This is awfully slow...
+            periods = self.pool.get('account.period').find(cr, uid,
+                                                           dt=values.get('date'),
+                                                           context=context)
+            values['period_id'] = periods[0]
+            period_memoizer[date] = periods[0]
+        values['type'] = 'general'
+        return values
+
+    def statement_import(self, cr, uid, ids, profile_id, file_stream, ftype="csv", context=None):
+        """
+        Create a bank statement with the given profile and parser. It will fullfill the bank statement
+        with the values of the file providen, but will not complete data (like finding the partner, or
+        the right account). This will be done in a second step with the completion rules.
+        It will also create the commission line if it apply and record the providen file as
+        an attachement of the bank statement.
+
+        :param int/long profile_id: ID of the profile used to import the file
+        :param filebuffer file_stream: binary of the providen file
+        :param char: ftype represent the file exstension (csv by default)
+        :return: ID of the created account.bank.statemênt
+        """
+        statement_obj = self.pool.get('account.bank.statement')
+        statement_line_obj = self.pool.get('account.bank.statement.line')
+        attachment_obj = self.pool.get('ir.attachment')
+        prof_obj = self.pool.get("account.statement.profile")
+        if not profile_id:
+            raise osv.except_osv(_("No Profile!"),
+                                 _("You must provide a valid profile to import a bank statement!"))
+        prof = prof_obj.browse(cr, uid, profile_id, context=context)
+
+        parser = new_bank_statement_parser(prof.import_type, ftype=ftype)
+        result_row_list = parser.parse(file_stream)
+        # Check all key are present in account.bank.statement.line!!
+        if not result_row_list:
+            raise osv.except_osv(_("Nothing to import"),
+                                 _("The file is empty"))
+        parsed_cols = parser.get_st_line_vals(result_row_list[0]).keys()
+        for col in parsed_cols:
+            if col not in statement_line_obj._columns:
+                raise osv.except_osv(_("Missing column!"),
+                                     _("Column %s you try to import is not "
+                                       "present in the bank statement line!") % col)
+
+        statement_id = statement_obj.create(cr, uid,
+                                            {'profile_id': prof.id},
+                                            context=context)
+        if prof.receivable_account_id:
+            account_receivable = account_payable = prof.receivable_account_id.id
+        else:
+            account_receivable, account_payable = statement_obj.get_default_pay_receiv_accounts(
+                                                       cr, uid, context)
+        try:
+            # Record every line in the bank statement and compute the global commission
+            # based on the commission_amount column
+            statement_store = []
+            for line in result_row_list:
+                parser_vals = parser.get_st_line_vals(line)
+                values = self.prepare_statetement_lines_vals(cr, uid, parser_vals, account_payable,
+                                                             account_receivable, statement_id, context)
+                statement_store.append(values)
+            # Hack to bypass ORM poor perfomance. Sob...
+            statement_line_obj._insert_lines(cr, uid, statement_store, context=context)
+
+            # Build and create the global commission line for the whole statement
+            comm_vals = self.prepare_global_commission_line_vals(cr, uid, parser, result_row_list,
+                                                                 prof, statement_id, context)
+            if comm_vals:
+                statement_line_obj.create(cr, uid, comm_vals, context=context)
+            else:
+                # Trigger store field computation if someone has better idea
+                start_bal = statement_obj.read(cr, uid, statement_id,
+                                               ['balance_start'],
+                                               context=context)
+                start_bal = start_bal['balance_start']
+                statement_obj.write(cr, uid, [statement_id],
+                                    {'balance_start': start_bal})
+
+            attachment_obj.create(cr,
+                                  uid,
+                                  {'name': 'statement file',
+                                   'datas': file_stream,
+                                   'datas_fname': "%s.%s" % (
+                                       datetime.datetime.now().date(),
+                                       ftype),
+                                   'res_model': 'account.bank.statement',
+                                   'res_id': statement_id},
+                                  context=context)
+
+            # If user ask to launch completion at end of import, do it!
+            if prof.launch_import_completion:
+                statement_obj.button_auto_completion(cr, uid, [statement_id], context)
+
+            # Write the needed log infos on profile
+            self.write_logs_after_import(cr, uid, prof.id,
+                                         statement_id,
+                                         len(result_row_list),
+                                         context)
+
+        except Exception:
+            statement_obj.unlink(cr, uid, [statement_id], context=context)
+            error_type, error_value, trbk = sys.exc_info()
+            st = "Error: %s\nDescription: %s\nTraceback:" % (error_type.__name__, error_value)
+            st += ''.join(traceback.format_tb(trbk, 30))
+            raise osv.except_osv(_("Statement import error"),
+                                 _("The statement cannot be created: %s") % st)
+        return statement_id
+
+
+class AccountStatementLine(Model):
+    """
+    Add sparse field on the statement line to allow to store all the
+    bank infos that are given by an office. In this basic sample case
+    it concern only commission_amount.
+    """
+    _inherit = "account.bank.statement.line"
+
+    def _get_available_columns(self, statement_store):
+        """Return writeable by SQL columns"""
+        statement_line_obj = self.pool['account.bank.statement.line']
+        model_cols = statement_line_obj._columns
+        avail = [k for k, col in model_cols.iteritems() if not hasattr(col, '_fnct')]
+        keys = [k for k in statement_store[0].keys() if k in avail]
+        keys.sort()
+        return keys
+
+    def _insert_lines(self, cr, uid, statement_store, context=None):
+        """ Do raw insert into database because ORM is awfully slow
+            when doing batch write. It is a shame that batch function
+            does not exist"""
+        statement_line_obj = self.pool['account.bank.statement.line']
+        statement_line_obj.check_access_rule(cr, uid, [], 'create')
+        statement_line_obj.check_access_rights(cr, uid, 'create', raise_exception=True)
+        cols = self._get_available_columns(statement_store)
+        tmp_vals = (', '.join(cols), ', '.join(['%%(%s)s' % i for i in cols]))
+        sql = "INSERT INTO account_bank_statement_line (%s) VALUES (%s);" % tmp_vals
+        try:
+            cr.executemany(sql, tuple(statement_store))
+        except psycopg2.Error as sql_err:
+            cr.rollback()
+            raise osv.except_osv(_("ORM bypass error"),
+                                 sql_err.pgerror)
+
+    def _update_line(self, cr, uid, vals, context=None):
+        """ Do raw update into database because ORM is awfully slow
+            when cheking security."""
+        cols = self._get_available_columns([vals])
+        tmp_vals = (', '.join(['%s = %%(%s)s' % (i, i) for i in cols]))
+        sql = "UPDATE account_bank_statement_line SET %s where id = %%(id)s;" % tmp_vals
+        try:
+            cr.execute(sql, vals)
+        except psycopg2.Error as sql_err:
+            cr.rollback()
+            raise osv.except_osv(_("ORM bypass error"),
+                                 sql_err.pgerror)
+
+    _columns = {
+        'commission_amount': fields.sparse(
+            type='float',
+            string='Line Commission Amount',
+            serialization_field='additionnal_bank_fields'),
+    }
 
=== added file 'account_statement_base_import/statement_view.xml'
--- account_statement_base_import/statement_view.xml	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/statement_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data>
+
+
+    <record id="statement_importer_view_form" model="ir.ui.view">
+        <field name="name">account.statement.profile.view</field>
+        <field name="model">account.statement.profile</field>
+        <field name="inherit_id" ref="account_statement_ext.statement_importer_view_form"/>
+        <field name="type">form</field>
+        <field name="arch" type="xml">
+            <field name="bank_statement_prefix" position="after">
+                <separator colspan="4" string="Import related infos"/>
+                <field name="launch_import_completion"/>
+                <field name="last_import_date"/>
+                <field name="import_type"/>
+                <button name="%(account_statement_base_import.statement_importer_action)d"
+                                                        string="Import Bank Statement"
+                                                        type="action" icon="gtk-ok"
+                                                        colspan = "2"/>
+                <group attrs="{'invisible': [('rec_log', '=', False)]}">
+                    <separator colspan="4" string="Historical Import Logs"/>
+                    <field name="rec_log" colspan="4" nolabel="1" />
+                </group>
+            </field>
+        </field>
+    </record>
+
+    <record id="bank_statement_view_form" model="ir.ui.view">
+         <field name="name">account_bank_statement.bank_statement.view_form</field>
+         <field name="model">account.bank.statement</field>
+         <field name="inherit_id" ref="account_statement_base_completion.bank_statement_view_form" />
+         <field name="type">form</field>
+         <field eval="20" name="priority"/>
+         <field name="arch" type="xml">
+             <data>
+                 <xpath expr="/form/sheet/notebook/page/field[@name='line_ids']/form/group/field[@name='label']" position="after">
+                     <field name="commission_amount" />
+                 </xpath>
+             </data>
+         </field>
+     </record>
+
+
+</data>
+</openerp>
 
=== added directory 'account_statement_base_import/wizard'
=== added file 'account_statement_base_import/wizard/__init__.py'
--- account_statement_base_import/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/wizard/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,20 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author Nicolas Bessi, Joel Grand-Guillaume. Copyright Camptocamp SA
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU General Public License as published by
+#    the Free Software Foundation, either version 3 of the License, or
+#    (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU General Public License for more details.
+#
+#    You should have received a copy of the GNU General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import import_statement
 
=== added file 'account_statement_base_import/wizard/import_statement.py'
--- account_statement_base_import/wizard/import_statement.py	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/wizard/import_statement.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,122 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Nicolas Bessi, Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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/>.
+#
+##############################################################################
+
+"""
+Wizard to import financial institute date in bank statement
+"""
+
+from openerp.osv import orm, fields
+
+from openerp.tools.translate import _
+import os
+
+
+class CreditPartnerStatementImporter(orm.TransientModel):
+    _name = "credit.statement.import"
+
+    def default_get(self, cr, uid, fields, context=None):
+        if context is None:
+            context = {}
+        res = {}
+        if (context.get('active_model', False) == 'account.statement.profile' and
+            context.get('active_ids', False)):
+            ids = context['active_ids']
+            assert len(ids) == 1, 'You cannot use this on more than one profile !'
+            res['profile_id'] = ids[0]
+            other_vals = self.onchange_profile_id(cr, uid, [], res['profile_id'], context=context)
+            res.update(other_vals.get('value', {}))
+        return res
+
+    _columns = {
+        'profile_id': fields.many2one('account.statement.profile',
+                                      'Import configuration parameter',
+                                      required=True),
+        'input_statement': fields.binary('Statement file', required=True),
+        'partner_id': fields.many2one('res.partner',
+                                      'Credit insitute partner'),
+        'journal_id': fields.many2one('account.journal',
+                                      'Financial journal to use transaction'),
+        'file_name': fields.char('File Name', size=128),
+        'commission_account_id': fields.many2one('account.account',
+                                                 'Commission account'),
+        'commission_analytic_id': fields.many2one('account.analytic.account',
+                                                 'Commission analytic account'),
+        'receivable_account_id': fields.many2one('account.account',
+                                                 'Force Receivable/Payable Account'),
+        'force_partner_on_bank': fields.boolean(
+            'Force partner on bank move',
+            help="Tic that box if you want to use the credit insitute partner "
+            "in the counterpart of the treasury/banking move."),
+        'balance_check': fields.boolean(
+            'Balance check',
+            help="Tic that box if you want OpenERP to control the "
+            "start/end balance before confirming a bank statement. "
+            "If don't ticked, no balance control will be done."),
+    }
+
+    def onchange_profile_id(self, cr, uid, ids, profile_id, context=None):
+        res = {}
+        if profile_id:
+            c = self.pool.get("account.statement.profile").browse(
+                    cr, uid, profile_id, context=context)
+            res = {'value':
+                    {'partner_id': c.partner_id and c.partner_id.id or False,
+                     'journal_id': c.journal_id and c.journal_id.id or False,
+                     'commission_account_id':
+                        c.commission_account_id and c.commission_account_id.id or False,
+                     'receivable_account_id': c.receivable_account_id and c.receivable_account_id.id or False,
+                     'commission_a': c.commission_analytic_id and c.commission_analytic_id.id or False,
+                     'force_partner_on_bank': c.force_partner_on_bank,
+                     'balance_check': c.balance_check,
+                     }
+                }
+        return res
+
+    def _check_extension(self, filename):
+        (__, ftype) = os.path.splitext(filename)
+        if not ftype:
+            #We do not use osv exception we do not want to have it logged
+            raise Exception(_('Please use a file with an extention'))
+        return ftype
+
+    def import_statement(self, cr, uid, req_id, context=None):
+        """This Function import credit card agency statement"""
+        context = context or {}
+        if isinstance(req_id, list):
+            req_id = req_id[0]
+        importer = self.browse(cr, uid, req_id, context)
+        ftype = self._check_extension(importer.file_name)
+        sid = self.pool.get(
+                'account.statement.profile').statement_import(
+                                            cr,
+                                            uid,
+                                            False,
+                                            importer.profile_id.id,
+                                            importer.input_statement,
+                                            ftype.replace('.', ''),
+                                            context=context
+                                        )
+        model_obj = self.pool.get('ir.model.data')
+        action_obj = self.pool.get('ir.actions.act_window')
+        action_id = model_obj.get_object_reference(cr, uid, 'account', 'action_bank_statement_tree')[1]
+        res = action_obj.read(cr, uid, action_id)
+        res['domain'] = res['domain'][:-1] + ",('id', '=', %d)]" % sid
+        return res
 
=== added file 'account_statement_base_import/wizard/import_statement_view.xml'
--- account_statement_base_import/wizard/import_statement_view.xml	1970-01-01 00:00:00 +0000
+++ account_statement_base_import/wizard/import_statement_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record id="statement_importer_view" model="ir.ui.view">
+            <field name="name">credit.statement.import.config.view</field>
+            <field name="model">credit.statement.import</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Import statement">
+                    <group colspan="4" >
+                        <field name="profile_id" on_change="onchange_profile_id(profile_id)"/>
+                        <field name="input_statement" filename="file_name" colspan="2"/>
+                        <field name="file_name" colspan="2" invisible="1"/>
+                        <separator string="Import Parameters Summary" colspan="4"/>
+                        <field name="partner_id" readonly="1"/>
+                        <field name="journal_id" readonly="1"/>
+                        <field name="commission_account_id" readonly="1"/>
+                        <field name="commission_analytic_id" readonly="1"/>
+                        <field name="receivable_account_id" readonly="1"/>
+                        <field name="force_partner_on_bank" readonly="1"/>
+                        <field name="balance_check" readonly="1"/>
+                    </group>
+                    <separator string="" colspan="4"/>
+                    <group colspan="4" col="6">
+                        <button  icon="gtk-cancel" special="cancel" string="Cancel"/>
+                        <button  icon="gtk-ok" name="import_statement" string="Import statement" type="object"/>
+                    </group>
+                </form>
+            </field>
+        </record>
+
+        <record id="statement_importer_action" model="ir.actions.act_window">
+            <field name="name">Import statement</field>
+            <field name="res_model">credit.statement.import</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+            <field name="view_id" ref="statement_importer_view"/>
+            <field name="target">new</field>
+        </record>
+
+        <menuitem id="statement_importer_menu" name="Import Bank Statement" action="statement_importer_action" parent="account.menu_finance_bank_and_cash"/>
+
+    </data>
+</openerp>
 
=== added directory 'account_statement_completion_voucher'
=== added file 'account_statement_completion_voucher/__init__.py'
--- account_statement_completion_voucher/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_completion_voucher/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,20 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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/>.
+#
+##############################################################################
 
=== added file 'account_statement_completion_voucher/__openerp__.py'
--- account_statement_completion_voucher/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_statement_completion_voucher/__openerp__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,46 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Joel Grand-Guillaume
+#    Copyright 2011-2012 Camptocamp SA
+#
+#    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': "Bank statement extension with voucher",
+ 'version': '1.0',
+ 'author': 'Camptocamp',
+ 'maintainer': 'Camptocamp',
+ 'category': 'Finance',
+ 'complexity': 'normal',
+ 'depends': [
+     'account_statement_base_completion',
+     'account_voucher'
+     ],
+ 'description': """
+ This module is only needed when using account_statement_base_completion with voucher in order adapt the view correctly.
+ """,
+ 'website': 'http://www.camptocamp.com',
+ 'init_xml': [],
+ 'update_xml': [
+    "statement_view.xml",
+ ],
+ 'demo_xml': [],
+ 'test': [],
+ 'installable': False,
+ 'images': [],
+ 'auto_install': False,
+ 'license': 'AGPL-3',
+}
 
=== added file 'account_statement_completion_voucher/statement_view.xml'
--- account_statement_completion_voucher/statement_view.xml	1970-01-01 00:00:00 +0000
+++ account_statement_completion_voucher/statement_view.xml	2013-06-10 06:07:03 +0000
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+<data>
+
+    <!-- Override what we have in account_statement_base_completion to replace the one in the voucher -->
+    <!-- <record id="account_statement_base_completion.bank_statement_view_form2" model="ir.ui.view">
+         <field name="name">account_bank_statement_import_base.bank_statement.auto_cmpl</field>
+         <field name="model">account.bank.statement</field>
+         <field name="inherit_id" ref="account_voucher.view_bank_statement_tree_voucher" />
+         <field name="type">form</field>
+         <field name="arch" type="xml">
+             <data>
+                 <xpath expr="/form/sheet/notebook/page/field[@name='line_ids']/tree/field[@name='voucher_id']" position="after">
+                    <field name="already_completed" />
+                 </xpath>
+             </data>
+         </field>
+     </record> -->
+    
+</data>
+</openerp>
 
=== added directory 'account_statement_ext'
=== added file 'account_statement_ext/__init__.py'
--- account_statement_ext/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_ext/__init__.py	2013-06-10 06:07:03 +0000
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-