Merge lp:~julie-w/unifield-server/US-6766 into lp:unifield-server

[jftempo]

=== modified file 'bin/addons/account/__openerp__.py'
--- bin/addons/account/__openerp__.py	2019-10-10 15:06:49 +0000
+++ bin/addons/account/__openerp__.py	2020-04-27 09:12:30 +0000
@@ -85,6 +85,7 @@
         'wizard/account_reconcile_view.xml',
         'wizard/account_reconcile_partner_process_view.xml',
         'wizard/account_automatic_reconcile_view.xml',
+        'wizard/account_invoice_import.xml',
         'project/wizard/project_account_analytic_line_view.xml',
         'account_end_fy.xml',
         'account_invoice_view.xml',

=== modified file 'bin/addons/account/account_report.xml'
--- bin/addons/account/account_report.xml	2020-04-06 16:32:38 +0000
+++ bin/addons/account/account_report.xml	2020-04-27 09:12:30 +0000
@@ -165,5 +165,17 @@
                               ('name', '=', 'Invoice Excel Export')]]" />
             <value eval="{'sequence': 97}" />
         </function>
+
+         <!-- Export Invoice report -->
+         <report id="export_invoice"
+                 string="Export - Invoice"
+                 target_filename="Export - Invoice"
+                 model="account.invoice"
+                 name="account.export_invoice"
+                 file="account/report/export_invoice.mako"
+                 report_type="webkit"
+                 header="False"
+                 auto="False"
+                 menu="False"/>
     </data>
 </openerp>

=== modified file 'bin/addons/account/report/__init__.py'
--- bin/addons/account/report/__init__.py	2020-04-03 14:03:55 +0000
+++ bin/addons/account/report/__init__.py	2020-04-27 09:12:30 +0000
@@ -43,6 +43,7 @@
 import account_liquidity_balance
 import free_allocation_report
 import invoice_excel_export
+import export_invoice
 
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 

=== added file 'bin/addons/account/report/export_invoice.mako'
--- bin/addons/account/report/export_invoice.mako	1970-01-01 00:00:00 +0000
+++ bin/addons/account/report/export_invoice.mako	2020-04-27 09:12:30 +0000
@@ -0,0 +1,171 @@
+<?xml version="1.0"?>
+<?mso-application progid="Excel.Sheet"?>
+<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
+ xmlns:o="urn:schemas-microsoft-com:office:office"
+ xmlns:x="urn:schemas-microsoft-com:office:excel"
+ xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
+ xmlns:html="http://www.w3.org/TR/REC-html40">
+ <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
+  <Title>${_('Export - Invoice')}</Title>
+ </DocumentProperties>
+ <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+  <WindowHeight>13170</WindowHeight>
+  <WindowWidth>19020</WindowWidth>
+  <WindowTopX>120</WindowTopX>
+  <WindowTopY>60</WindowTopY>
+  <ProtectStructure>False</ProtectStructure>
+  <ProtectWindows>False</ProtectWindows>
+ </ExcelWorkbook>
+<Styles>
+  <Style ss:ID="editable">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+    </Borders>
+    <Protection ss:Protected="0"/>
+  </Style>
+  <Style ss:ID="editable_number">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+    </Borders>
+    <NumberFormat ss:Format="Standard"/>
+    <Protection ss:Protected="0"/>
+  </Style>
+  <Style ss:ID="non_editable">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Interior ss:Color="#ffcc99" ss:Pattern="Solid"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+    </Borders>
+    <Protection/>
+  </Style>
+  <Style ss:ID="non_editable_number">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Interior ss:Color="#ffcc99" ss:Pattern="Solid"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+    </Borders>
+    <NumberFormat ss:Format="Standard"/>
+    <Protection/>
+  </Style>
+  <Style ss:ID="non_editable_date">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Interior ss:Color="#ffcc99" ss:Pattern="Solid"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+    </Borders>
+    <NumberFormat ss:Format="Short Date"/>
+    <Protection/>
+  </Style>
+</Styles>
+% for o in objects:
+<!-- Sheet must be protected otherwise the protection on the cells has no effect -->
+<!-- Default Sheet name is "Sheet1" (we can export only one inv. at a time) -->
+<ss:Worksheet ss:Name="${o.number or "%s%s" % (_('Sheet'), 1)|x}" ss:Protected="1">
+<Table x:FullColumns="1" x:FullRows="1">
+  <Column ss:AutoFitWidth="1" ss:Width="100"/>
+  <Column ss:AutoFitWidth="1" ss:Width="250"/>
+  <Column ss:AutoFitWidth="1" ss:Width="100"/>
+  <Column ss:AutoFitWidth="1" ss:Width="150" ss:Span="1"/>
+
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Number')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${o.number or ''|x}</Data></Cell>
+  </Row>
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Journal')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${o.journal_id.code|x}</Data></Cell>
+  </Row>
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Currency')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${o.currency_id.name|x}</Data></Cell>
+  </Row>
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Partner')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${o.partner_id.name|x}</Data></Cell>
+  </Row>
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Document Date')}</Data></Cell>
+      <Cell ss:StyleID="non_editable_date"><Data ss:Type="DateTime">${o.document_date or False|n}T00:00:00.000</Data></Cell>
+  </Row>
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Posting Date')}</Data></Cell>
+      <Cell ss:StyleID="non_editable_date"><Data ss:Type="DateTime">${o.date_invoice or False|n}T00:00:00.000</Data></Cell>
+  </Row>
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Account')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${o.account_id.code|x}</Data></Cell>
+  </Row>
+
+  <Row><Cell ss:StyleID="editable"><Data ss:Type="String"></Data></Cell></Row>
+
+  <Row>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Line number')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Product')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Account')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Quantity')}</Data></Cell>
+      <Cell ss:StyleID="non_editable"><Data ss:Type="String">${_('Unit Price')}</Data></Cell>
+  </Row>
+
+  <% is_ro = is_readonly(o) %>
+  % for inv_line in o.invoice_line:
+    <Row>
+        <Cell ss:StyleID="non_editable"><Data ss:Type="String">${inv_line.line_number or ''|x}</Data></Cell>
+        % if is_ro:
+            <Cell ss:StyleID="non_editable">
+        % else:
+            <Cell ss:StyleID="editable">
+        % endif
+        <Data ss:Type="String">${inv_line.product_id and inv_line.product_id.default_code or ''|x}</Data></Cell>
+
+        <Cell ss:StyleID="editable"><Data ss:Type="String">${inv_line.account_id.code|x}</Data></Cell>
+
+        % if is_ro:
+            <Cell ss:StyleID="non_editable_number">
+        % else:
+            <Cell ss:StyleID="editable_number">
+        % endif
+        <Data ss:Type="Number">${inv_line.quantity|x}</Data></Cell>
+
+        <Cell ss:StyleID="editable_number"><Data ss:Type="Number">${inv_line.price_unit|x}</Data></Cell>
+    </Row>
+  % endfor
+
+</Table>
+<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+   <FitToPage/>
+   <PageSetup>
+       <Layout x:Orientation="Portrait"/>
+       <Header x:Margin="0.4921259845"/>
+       <Footer x:Margin="0.4921259845"/>
+       <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996" x:Right="0.78740157499999996" x:Top="0.984251969"/>
+   </PageSetup>
+   <Print>
+       <ValidPrinterInfo/>
+       <PaperSizeIndex>9</PaperSizeIndex>
+       <HorizontalResolution>600</HorizontalResolution>
+       <VerticalResolution>600</VerticalResolution>
+   </Print>
+   <Selected/>
+   <ProtectObjects>False</ProtectObjects>
+   <ProtectScenarios>False</ProtectScenarios>
+</WorksheetOptions>
+</ss:Worksheet>
+% endfor
+</Workbook>

=== added file 'bin/addons/account/report/export_invoice.py'
--- bin/addons/account/report/export_invoice.py	1970-01-01 00:00:00 +0000
+++ bin/addons/account/report/export_invoice.py	2020-04-27 09:12:30 +0000
@@ -0,0 +1,58 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2020 TeMPO Consulting, MSF. All Rights Reserved
+#
+#    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 report import report_sxw
+from spreadsheet_xml.spreadsheet_xml_write import SpreadsheetReport
+
+
+def is_readonly(self, inv):
+    """
+    Returns True if the fields Product and Quantity of the invoice must be readonly = not editable
+    """
+    if inv.type == 'in_invoice' and not inv.is_direct_invoice and not inv.is_inkind_donation:  # IVI or SI
+        is_readonly = inv.from_supply or inv.synced
+    elif inv.type == 'out_invoice' and inv.is_intermission:  # IVO
+        is_readonly = inv.from_supply
+    elif inv.type == 'out_invoice' and not inv.is_intermission and not inv.is_debit_note:  # STV
+        is_readonly = inv.from_supply and inv.partner_type == 'section'
+    else:  # other inv. types are not supposed to be handled in this report
+        is_readonly = True
+    return is_readonly
+
+
+class export_invoice(report_sxw.rml_parse):
+
+    def __init__(self, cr, uid, name, context=None):
+        super(export_invoice, self).__init__(cr, uid, name, context=context)
+        self.localcontext.update({
+            'is_readonly': self.is_readonly,
+        })
+
+    def is_readonly(self, inv):
+        """
+        Returns True if the fields Product and Quantity of the invoice must be readonly = not editable
+        """
+        return is_readonly(self, inv)
+
+
+SpreadsheetReport('report.account.export_invoice', 'account.invoice',
+                  'addons/account/report/export_invoice.mako', parser=export_invoice)
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== modified file 'bin/addons/account/wizard/__init__.py'
--- bin/addons/account/wizard/__init__.py	2019-07-24 14:20:02 +0000
+++ bin/addons/account/wizard/__init__.py	2020-04-27 09:12:30 +0000
@@ -66,6 +66,7 @@
 import account_report_liquidity_balance
 
 import free_allocation_wizard
+import account_invoice_import
 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 
 

=== added file 'bin/addons/account/wizard/account_invoice_import.py'
--- bin/addons/account/wizard/account_invoice_import.py	1970-01-01 00:00:00 +0000
+++ bin/addons/account/wizard/account_invoice_import.py	2020-04-27 09:12:30 +0000
@@ -0,0 +1,300 @@
+#!/usr/bin/env python
+#-*- encoding:utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) TeMPO Consulting (<http://www.tempo-consulting.fr/>), MSF.
+#    All Rights Reserved
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from osv import osv
+from osv import fields
+from tools.translate import _
+from tempfile import NamedTemporaryFile
+from base64 import decodestring
+from spreadsheet_xml.spreadsheet_xml import SpreadsheetXML
+from account.report import export_invoice
+from datetime import datetime
+import threading
+import pooler
+import logging
+import tools
+
+
+class account_invoice_import(osv.osv_memory):
+    _name = 'account.invoice.import'
+
+    _columns = {
+        'file': fields.binary(string="File", filters='*.xml, *.xls', required=True),
+        'filename': fields.char(string="Imported filename", size=256),
+        'progression': fields.float(string="Progression", readonly=True),
+        'message': fields.char(string="Message", size=256, readonly=True),
+        'state': fields.selection([('draft', 'Created'), ('inprogress', 'In Progress'), ('error', 'Error'), ('done', 'Done')],
+                                  string="State", readonly=True, required=True),
+        'error_ids': fields.one2many('account.invoice.import.errors', 'wizard_id', "Errors", readonly=True),
+        'invoice_id': fields.many2one('account.invoice', 'Invoice', required=True, readonly=True),
+    }
+
+    _defaults = {
+        'progression': lambda *a: 0.0,
+        'state': lambda *a: 'draft',
+    }
+
+    def _import(self, dbname, uid, ids, context=None):
+        """
+        Checks file data, and either updates the lines or displays the errors found
+        """
+        if context is None:
+            context = {}
+        cr = pooler.get_db(dbname).cursor()
+        errors = []
+        invoice_obj = self.pool.get('account.invoice')
+        invoice_line_obj = self.pool.get('account.invoice.line')
+        currency_obj = self.pool.get('res.currency')
+        partner_obj = self.pool.get('res.partner')
+        account_obj = self.pool.get('account.account')
+        product_obj = self.pool.get('product.product')
+        import_cell_data_obj = self.pool.get('import.cell.data')
+        errors_obj = self.pool.get('account.invoice.import.errors')
+
+        try:
+            for wiz in self.browse(cr, uid, ids, context):
+                self.write(cr, uid, [wiz.id], {'message': _('Checking file…'), 'progression': 1.00}, context)
+                if not wiz.file:
+                    raise osv.except_osv(_('Error'), _('Nothing to import.'))
+                fileobj = NamedTemporaryFile('w+b', delete=False)
+                fileobj.write(decodestring(wiz.file))
+                fileobj.close()
+                content = SpreadsheetXML(xmlfile=fileobj.name, context=context)
+                if not content:
+                    raise osv.except_osv(_('Warning'), _('No content.'))
+                invoice = wiz.invoice_id
+                if invoice.state != 'draft':
+                    raise osv.except_osv(_('Warning'), _('The import is allowed only in Draft state.'))
+                rows = content.getRows()
+                nb_rows = len([x for x in content.getRows()])
+                self.write(cr, uid, [wiz.id], {'message': _('Checking header…'), 'progression': 5.00}, context)
+                # indexes of the file columns:
+                cols = {
+                    'line_number': 0,
+                    'product': 1,
+                    'account': 2,
+                    'quantity': 3,
+                    'unit_price': 4,
+                }
+                # number of the first line in the file containing data (not header)
+                base_num = 10
+                rows.next()  # number is ignored
+                rows.next()  # journal is ignored
+                currency_line = import_cell_data_obj.get_line_values(cr, uid, ids, rows.next())
+                try:
+                    currency_name = currency_line[1]
+                except IndexError, e:
+                    raise osv.except_osv(_('Warning'), _('No currency found.'))
+                currency_ids = currency_obj.search(cr, uid,
+                                                   [('name', '=', currency_name), ('currency_table_id', '=', False),
+                                                    ('active', '=', True)], limit=1, context=context)
+                if not currency_ids:
+                    raise osv.except_osv(_('Error'), _("Currency %s not found or inactive.") % (currency_name or '',))
+                partner_line = import_cell_data_obj.get_line_values(cr, uid, ids, rows.next())
+                try:
+                    partner_name = partner_line[1]
+                except IndexError, e:
+                    raise osv.except_osv(_('Warning'), _('No partner found.'))
+                partner_ids = partner_obj.search(cr, uid, [('name', '=', partner_name), ('active', '=', True)], context=context)
+                if not partner_ids:
+                    raise osv.except_osv(_('Error'), _("Partner %s not found or inactive.") % (partner_name or '',))
+                rows.next()  # document date is ignored
+                posting_date_line = import_cell_data_obj.get_line_values(cr, uid, ids, rows.next())
+                try:
+                    posting_date = posting_date_line[1] or False
+                except IndexError, e:
+                    posting_date = False
+                if posting_date:
+                    try:
+                        posting_date = posting_date.strftime('%Y-%m-%d')
+                    except AttributeError, e:
+                        raise osv.except_osv(_('Warning'), _("The posting date has a wrong format."))
+                invoice_dom = [('id', '=', invoice.id),
+                               ('currency_id', '=', currency_ids[0]),
+                               ('partner_id', '=', partner_ids[0]),
+                               ('date_invoice', '=', posting_date)]
+                if not invoice_obj.search_exist(cr, uid, invoice_dom, context=context):
+                    raise osv.except_osv(_('Warning'),
+                                         _("The combination \"Currency, Partner and Posting Date\" of the imported file "
+                                           "doesn't match with the current invoice."))
+                # ignore: header account, empty line, line with titles
+                for i in range(3):
+                    rows.next()
+                header_percent = 10  # percentage of the process reached AFTER having checked the header
+                self.write(cr, uid, [wiz.id], {'message': _('Checking lines…'), 'progression': header_percent}, context)
+                lines_percent = 99  # % of the process to be reached AFTER having checked and updated the lines
+                # use the method from export_invoice to determine whether the product and quantity columns are editable
+                all_fields_editable = not export_invoice.is_readonly(self, invoice)
+                # check the lines
+                for num, r in enumerate(rows):
+                    current_line_num = num + base_num
+                    vals = {}
+                    line = import_cell_data_obj.get_line_values(cr, uid, ids, r)
+                    line.extend([False for i in range(len(cols) - len(line))])
+                    # get the data
+                    line_number = line[cols['line_number']] and tools.ustr(line[cols['line_number']])
+                    product_code = line[cols['product']] and tools.ustr(line[cols['product']])
+                    account_code = line[cols['account']] and tools.ustr(line[cols['account']])
+                    quantity = line[cols['quantity']] or 0.0
+                    unit_price = line[cols['unit_price']] or 0.0
+                    if not line_number:
+                        errors.append(_('Line %s: the line number is missing.') % (current_line_num,))
+                        continue
+                    invoice_line_dom = [('invoice_id', '=', invoice.id), ('line_number', '=', line_number)]
+                    invoice_line_ids = invoice_line_obj.search(cr, uid, invoice_line_dom, limit=1, context=context)
+                    if not invoice_line_ids:
+                        errors.append(_("Line %s: the line number %s doesn't exist in the invoice.") % (current_line_num, line_number))
+                        continue
+                    if not account_code:
+                        errors.append(_("Line %s: the account (mandatory) is missing.") % (current_line_num,))
+                        continue
+                    account_ids = account_obj.search(cr, uid, [('code', '=', account_code)], limit=1, context=context)
+                    if not account_ids:
+                        errors.append(_("Line %s: the account %s doesn't exist.") % (current_line_num, account_code))
+                        continue
+                    account = account_obj.browse(cr, uid, account_ids[0], fields_to_fetch=['activation_date', 'inactivation_date'],
+                                                 context=context)
+                    checking_date = posting_date or datetime.now().strftime('%Y-%m-%d')
+                    if checking_date < account.activation_date or (account.inactivation_date and checking_date >= account.inactivation_date):
+                        errors.append(_("Line %s: the account %s is inactive.") % (current_line_num, account_code))
+                        continue
+                    # restricted_area = accounts allowed. Note: the context is different for each type and used in the related fnct_search
+                    if invoice.is_intermission:
+                        restricted_area = 'intermission_lines'  # for IVI / IVO
+                    else:
+                        restricted_area = 'invoice_lines'  # for SI / STV
+                    if not account_obj.search_exist(cr, uid, [('id', '=', account.id), ('restricted_area', '=', restricted_area)],
+                                                    context=context):
+                        errors.append(_("Line %s: the account %s is not allowed.") % (current_line_num, account_code))
+                        continue
+                    vals['account_id'] = account.id
+                    try:
+                        unit_price = float(unit_price)
+                    except ValueError, e:
+                        errors.append(_("Line %s: the unit price format is incorrect.") % (current_line_num,))
+                        continue
+                    vals['price_unit'] = unit_price
+                    # edit the Product and Quantity only if it is allowed
+                    if all_fields_editable:
+                        if not product_code:
+                            vals['product_id'] = False  # delete the existing value
+                        else:
+                            product_ids = product_obj.search(cr, uid, [('default_code', '=', product_code), ('active', '=', True)],
+                                                             limit=1, context=context)
+                            if not product_ids:
+                                errors.append(_("Line %s: the product %s doesn't exist or is inactive.") % (current_line_num, product_code))
+                                continue
+                            vals['product_id'] = product_ids[0]
+                        try:
+                            quantity = float(quantity)
+                        except ValueError, e:
+                            errors.append(_("Line %s: the quantity format is incorrect.") % (current_line_num,))
+                            continue
+                        vals['quantity'] = quantity
+                    # update the line
+                    invoice_line_obj.write(cr, uid, invoice_line_ids[0], vals, context=context)
+                    # update the percent
+                    if current_line_num == nb_rows:
+                        self.write(cr, uid, [wiz.id], {'progression': lines_percent}, context)
+                    elif current_line_num % 5 == 0:  # refresh every 5 lines
+                        self.write(cr, uid, [wiz.id],
+                                   {'progression': header_percent + (current_line_num / float(nb_rows) * (lines_percent - header_percent))},
+                                   context)
+            wiz_state = 'done'
+            # cancel the process in case of errors
+            if errors:
+                cr.rollback()
+                message = _('Import FAILED.')
+                # delete old errors and create new ones
+                error_ids = errors_obj.search(cr, uid, [], context)
+                if error_ids:
+                    errors_obj.unlink(cr, uid, error_ids, context)
+                for e in errors:
+                    errors_obj.create(cr, uid, {'wizard_id': wiz.id, 'name': e}, context)
+                wiz_state = 'error'
+            else:
+                message = _('Import successful.')
+            # 100% progression
+            self.write(cr, uid, ids, {'message': message, 'state': wiz_state, 'progression': 100.0}, context)
+            cr.commit()
+            cr.close(True)
+        except osv.except_osv as osv_error:
+            logging.getLogger('account.invoice.import').warn('OSV Exception', exc_info=True)
+            cr.rollback()
+            self.write(cr, uid, ids, {'message': _("An error occurred: %s: %s") %
+                                                 (osv_error.name, osv_error.value), 'state': 'done', 'progression': 100.0})
+            cr.close(True)
+        except Exception as e:
+            logging.getLogger('account.invoice.import').warn('Exception', exc_info=True)
+            cr.rollback()
+            self.write(cr, uid, ids, {'message': _("An error occurred: %s") %
+                                                 (e and e.args and e.args[0] or ''), 'state': 'done', 'progression': 100.0})
+            cr.close(True)
+        return True
+
+    def button_validate(self, cr, uid, ids, context=None):
+        """
+        Starts thread and returns the wizard with the state "inprogress"
+        """
+        if context is None:
+            context = {}
+        thread = threading.Thread(target=self._import, args=(cr.dbname, uid, ids, context))
+        thread.start()
+        self.write(cr, uid, ids, {'state': 'inprogress'}, context)
+        return {
+            'type': 'ir.actions.act_window',
+            'res_model': 'account.invoice.import',
+            'view_type': 'form',
+            'view_mode': 'form',
+            'res_id': ids[0],
+            'context': context,
+            'target': 'new',
+        }
+
+    def button_update(self, cr, uid, ids, context=None):
+        """
+        Updates the view to follow the progression
+        """
+        return False
+
+    def button_refresh_invoice(self, cr, uid, ids, context=None):
+        """
+        Closes the wizard and refreshes the invoice view
+        """
+        return {'type': 'ir.actions.act_window_close'}
+
+
+account_invoice_import()
+
+
+class account_invoice_import_errors(osv.osv_memory):
+    _name = 'account.invoice.import.errors'
+
+    _columns = {
+        'name': fields.text("Description", readonly=True, required=True),
+        'wizard_id': fields.many2one('account.invoice.import', "Wizard", required=True, readonly=True),
+    }
+
+
+account_invoice_import_errors()
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'bin/addons/account/wizard/account_invoice_import.xml'
--- bin/addons/account/wizard/account_invoice_import.xml	1970-01-01 00:00:00 +0000
+++ bin/addons/account/wizard/account_invoice_import.xml	2020-04-27 09:12:30 +0000
@@ -0,0 +1,48 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+
+        <record id="wizard_account_invoice_import_errors_tree" model="ir.ui.view">
+            <field name="name">wizard.account.invoice.import.errors.tree</field>
+            <field name="model">account.invoice.import.errors</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Information">
+                    <field name="name" />
+                </tree>
+            </field>
+        </record>
+
+        <!-- Import invoice wizard -->
+        <record model="ir.ui.view" id="wizard_account_invoice_import_form">
+            <field name='name'>wizard.account.invoice.import.form</field>
+            <field name='model'>account.invoice.import</field>
+            <field name='type'>form</field>
+            <field name='arch' type='xml'>
+                <form string="Import Invoice">
+                    <label string="Select file to import" colspan="4" align="0.0"/>
+                    <newline/>
+                    <group col="4" colspan="4">
+                        <field name="file" filename="filename" colspan="4" attrs="{'invisible': [('state', '!=', 'draft')]}"/>
+                        <field name="filename" invisible="1"/>
+                    </group>
+                    <newline />
+                    <field name="progression" widget="progressbar" nolabel="1" attrs="{'invisible': [('state', '=', 'draft')]}" colspan="4" />
+                    <field name="message" nolabel="1" attrs="{'invisible': [('state', '=', 'draft')]}" widget="text"/>
+                    <newline/>
+                    <button name="button_update" type="object" string="Update" icon="gtk-refresh" attrs="{'invisible': [('state', '!=', 'inprogress')]}"/>
+                    <newline />
+                    <field name="error_ids" nolabel="1" attrs="{'invisible': [('state', '!=', 'error')]}"/>
+                    <group colspan="4" col="2" attrs="{'invisible': [('state', '!=', 'draft')]}">
+                        <button string="Cancel" special="cancel" icon="gtk-cancel"/>
+                        <button name="button_validate" type="object" string="Import" icon="terp-camera_test"/>
+                    </group>
+                    <button name="button_refresh_invoice" type="object" icon="terp-camera_test" string="Ok"
+                            attrs="{'invisible': [('state', '!=', 'done')]}"/>
+                    <field name="state" invisible="1"/>
+                </form>
+            </field>
+        </record>
+
+    </data>
+</openerp>

=== modified file 'bin/addons/account_override/account_invoice_view.xml'
--- bin/addons/account_override/account_invoice_view.xml	2020-04-02 16:24:30 +0000
+++ bin/addons/account_override/account_invoice_view.xml	2020-04-27 09:12:30 +0000
@@ -528,8 +528,11 @@
                             <field name="name" string="Reference"
                                    attrs="{'readonly': ['|', ('state', '!=', 'draft'), ('from_supply', '=', True)]}"/>
                             <newline/>
-                            <group name="import" string=" Import Lines " colspan="4" col="4" attrs="{'invisible':[('state', '!=', 'draft')]}">
-                                <button name="wizard_import_si_line" string="Import lines" icon="gtk-dnd" type="object"
+                            <group name="import" string=" Import Lines " colspan="4" col="4">
+                                <button name="import_invoice" string="Import Invoice" icon="gtk-execute" colspan="2" type="object"
+                                        attrs="{'readonly': [('state', '!=', 'draft')]}"/>
+                                <button name="export_invoice" string="Export Invoice" icon="gtk-execute" colspan="2" type="object"/>
+                                <button name="wizard_import_si_line" string="Import lines" icon="gtk-dnd" colspan="4" type="object"
                                         attrs="{'invisible': [('state', '!=', 'draft')],
                                                 'readonly': ['|',
                                                              ('from_supply', '=', True),
@@ -737,8 +740,15 @@
                     <button name="button_reset_taxes" position="replace"/>
                     <button name="invoice_proforma2" position="replace"/>
                     <xpath expr="/form/notebook/page[@string='Invoice']/field[@name='invoice_line']" position="before" >
-                        <group name="import" string=" Import Lines " colspan="4" col="4" attrs="{'invisible':[('state', '!=', 'draft')]}">
-                            <button name="wizard_import_si_line" string="Import lines" icon="gtk-dnd" type="object"
+                        <group name="import" string=" Import Lines " colspan="4" col="4"
+                               attrs="{'invisible': [('state', '!=', 'draft'), ('type', '!=', 'out_invoice')]}">
+                            <button name="import_invoice" string="Import Invoice" icon="gtk-execute" colspan="2" type="object"
+                                    attrs="{'readonly': [('state', '!=', 'draft')],
+                                            'invisible': [('type', '!=', 'out_invoice')]}"/>
+                            <button name="export_invoice" string="Export Invoice" icon="gtk-execute" colspan="2" type="object"
+                                    attrs="{'invisible': [('type', '!=', 'out_invoice')]}"/>
+                            <newline/>
+                            <button name="wizard_import_si_line" string="Import lines" icon="gtk-dnd" colspan="4" type="object"
                                     attrs="{'invisible': [('state', '!=', 'draft')],
                                             'readonly': [('type', '=', 'out_invoice'),
                                                          ('from_supply', '=', True),

=== modified file 'bin/addons/account_override/invoice.py'
--- bin/addons/account_override/invoice.py	2020-04-20 08:28:46 +0000
+++ bin/addons/account_override/invoice.py	2020-04-27 09:12:30 +0000
@@ -1631,6 +1631,33 @@
             return True
         return False
 
+    def export_invoice(self, cr, uid, ids, data, context=None):
+        """
+        Opens the Export Invoice report
+        """
+        return {
+            'type': 'ir.actions.report.xml',
+            'report_name': 'account.export_invoice',
+            'datas': data,
+        }
+
+    def import_invoice(self, cr, uid, ids, data, context=None):
+        """
+        Opens the Import Invoice wizard
+        """
+        if isinstance(ids, (int, long)):
+            ids = [ids]
+        wiz_id = self.pool.get('account.invoice.import').create(cr, uid, {'invoice_id': ids[0]}, context=context)
+        return {
+            'name': _('Import Invoice'),
+            'type': 'ir.actions.act_window',
+            'res_model': 'account.invoice.import',
+            'target': 'new',
+            'view_mode': 'form,tree',
+            'view_type': 'form',
+            'res_id': [wiz_id],
+        }
+
 
 account_invoice()
 

=== modified file 'bin/addons/msf_profile/i18n/fr_MF.po'
--- bin/addons/msf_profile/i18n/fr_MF.po	2020-04-20 08:36:07 +0000
+++ bin/addons/msf_profile/i18n/fr_MF.po	2020-04-27 09:12:30 +0000
@@ -5924,6 +5924,7 @@
 #: field:replenishment.segment,description_seg:0
 #: field:replenishment.segment.line,product_description:0
 #: report:addons/account/report/invoice_excel_export.mako:67
+#: field:account.invoice.import.errors,name:0
 #, python-format
 msgid "Description"
 msgstr "Description"
@@ -8344,6 +8345,7 @@
 #: report:addons/specific_rules/report/unconsistent_stock_report_xls.mako:98
 #: code:addons/stock_override/report/report_stock_move.py:759
 #: report:addons/account/report/invoice_excel_export.mako:68
+#: report:addons/account/report/export_invoice.mako:122
 #, python-format
 msgid "Quantity"
 msgstr "Quantité"
@@ -8680,7 +8682,7 @@
 msgid "The currency used to enter statement"
 msgstr "Devise utilisée pour entrer les relevés"
 
-#. modules: register_accounting, account_hq_entries, msf_homere_interface, msf_doc_import
+#. modules: register_accounting, account_hq_entries, msf_homere_interface, msf_doc_import, account
 #: field:msf.doc.import.accounting,filename:0
 #: field:hq.entries.import,filename:0
 #: field:hr.expat.employee.import,filename:0
@@ -8688,6 +8690,7 @@
 #: field:hr.payroll.employee.import,filename:0
 #: field:hr.payroll.import,filename:0
 #: field:wizard.register.import,filename:0
+#: field:account.invoice.import,filename:0
 msgid "Imported filename"
 msgstr "Nom du fichier importé"
 
@@ -13212,7 +13215,7 @@
 msgid "Line %s of the imported file: UoM [%s] not found ! Details: %s"
 msgstr "Line %s of the imported file: UoM [%s] not found ! Details: %s"
 
-#. modules: msf_budget, register_accounting, msf_homere_interface, supplier_catalogue, consumption_calculation, account_hq_entries, msf_doc_import, analytic_distribution, stock, msf_doc_import
+#. modules: msf_budget, register_accounting, msf_homere_interface, supplier_catalogue, consumption_calculation, account_hq_entries, msf_doc_import, analytic_distribution, stock, msf_doc_import, account
 #: code:addons/msf_doc_import/msf_import_export.py:368
 #: code:addons/stock/physical_inventory.py:662
 #: code:addons/stock/physical_inventory.py:877
@@ -13237,6 +13240,7 @@
 #: code:addons/register_accounting/wizard/wizard_register_import.py:260
 #: code:addons/supplier_catalogue/supplier_catalogue.py:627
 #: code:addons/supplier_catalogue/wizard/catalogue_import_lines.py:45
+#: code:addons/account/wizard/account_invoice_import.py:75
 #, python-format
 msgid "Nothing to import."
 msgstr "Rien à importer."
@@ -18775,10 +18779,11 @@
 msgid " with warning"
 msgstr "avec avertissement"
 
-#. modules: msf_doc_import, register_accounting, account_override
+#. modules: msf_doc_import, register_accounting, account_override, account
 #: code:addons/msf_doc_import/account.py:618
 #: code:addons/register_accounting/wizard/wizard_register_import.py:669
 #: code:addons/account_override/finance_export.py:241
+#: code:addons/account/wizard/account_invoice_import.py:239
 #, python-format
 msgid "An error occurred: %s"
 msgstr "Une erreur est survenue : %s"
@@ -19909,13 +19914,14 @@
 msgid "Some entries are already reconciled !"
 msgstr "Certaines écritures sont déjà lettrées !"
 
-#. modules: msf_doc_import, register_accounting, consumption_calculation
+#. modules: msf_doc_import, register_accounting, consumption_calculation, account
 #: field:weekly.forecast.report,progress:0
 #: field:abstract.wizard.import,progression:0
 #: field:msf.doc.import.accounting,progression:0
 #: field:msf.import.export,progression:0
 #: field:wizard.import.batch,progression:0
 #: field:wizard.register.import,progression:0
+#: field:account.invoice.import,progression:0
 msgid "Progression"
 msgstr "Progression"
 
@@ -21236,9 +21242,10 @@
 msgid "Display accounts?"
 msgstr "Display accounts?"
 
-#. modules: msf_doc_import, register_accounting
+#. modules: msf_doc_import, register_accounting, account
 #: code:addons/msf_doc_import/account.py:601
 #: code:addons/register_accounting/wizard/wizard_register_import.py:653
+#: code:addons/account/wizard/account_invoice_import.py:225
 #, python-format
 msgid "Import successful."
 msgstr "Import réussi."
@@ -22569,9 +22576,10 @@
 msgid "The bank statement used for bank reconciliation"
 msgstr "Relevé bancaire utilisé pour la reconciliation bancaire"
 
-#. modules: msf_doc_import, register_accounting
+#. modules: msf_doc_import, register_accounting, account
 #: code:addons/msf_doc_import/account.py:587
 #: code:addons/register_accounting/wizard/wizard_register_import.py:639
+#: code:addons/account/wizard/account_invoice_import.py:216
 #, python-format
 msgid "Import FAILED."
 msgstr "L'import a ÉCHOUÉ."
@@ -26636,8 +26644,9 @@
 msgid "Paid"
 msgstr "Payé"
 
-#. module: register_accounting
+#. modules: register_accounting, account
 #: code:addons/register_accounting/wizard/wizard_register_import.py:268
+#: code:addons/account/wizard/account_invoice_import.py:81
 #, python-format
 msgid "No content."
 msgstr "Aucun contenu."
@@ -30071,7 +30080,7 @@
 msgid "Operator '%s' not suported"
 msgstr "Operator '%s' not suported"
 
-#. modules: register_accounting, account_mcdb, msf_homere_interface, financing_contract, procurement_request, consumption_calculation, sync_client, msf_config_locations, stock_forecast, base, msf_currency_revaluation, specific_rules, msf_doc_import, stock, analytic_distribution
+#. modules: register_accounting, account_mcdb, msf_homere_interface, financing_contract, procurement_request, consumption_calculation, sync_client, msf_config_locations, stock_forecast, base, msf_currency_revaluation, specific_rules, msf_doc_import, stock, analytic_distribution, account
 #: view:account.line.csv.export:0
 #: field:account.line.csv.export,message:0
 #: field:import.commitment.wizard,last_error:0
@@ -30120,6 +30129,7 @@
 #: view:sync.client.register_entity:0
 #: field:sync.client.register_entity,message:0
 #: selection:sync.client.register_entity,state:0
+#: field:account.invoice.import,message:0
 msgid "Message"
 msgstr "Message"
 
@@ -41935,7 +41945,7 @@
 msgid "Contract code/name:"
 msgstr "Contrat - Code/Nom:"
 
-#. modules: sales_followup, register_accounting, import_data, sync_client, base, purchase_followup, msf_doc_import, stock, product
+#. modules: sales_followup, register_accounting, import_data, sync_client, base, purchase_followup, msf_doc_import, stock, product, account
 #: view:base.module.update:0
 #: view:base.update.translations:0
 #: selection:import_data,import_mode:0
@@ -41962,6 +41972,7 @@
 #: view:product.product:0
 #: view:sync.client.update_entity:0
 #: view:stock.expired.damaged.report:0
+#: view:account.invoice.import:0
 msgid "Update"
 msgstr "Mettre à jour"
 
@@ -43288,11 +43299,12 @@
 msgid "Monthly Budget (XLS)"
 msgstr "Budget Mensuel (XLS)"
 
-#. modules: msf_doc_import, procurement_request
+#. modules: msf_doc_import, procurement_request, account
 #: field:abstract.wizard.import,info_message:0
 #: view:wizard.import.batch:0
 #: field:wizard.import.batch,info_message:0
 #: view:internal.request.import:0
+#: view:account.invoice.import.errors:0
 msgid "Information"
 msgstr "Informations"
 
@@ -45001,7 +45013,7 @@
 msgid "Output Out"
 msgstr "Modèles de Taxe"
 
-#. modules: stock_forecast, register_accounting, msf_outgoing, documents_done, unifield_setup, account_override, purchase_compare_rfq, base, stock, msf_profile, msf_doc_import, sale, account_hq_entries, res_currency_tables
+#. modules: stock_forecast, register_accounting, msf_outgoing, documents_done, unifield_setup, account_override, purchase_compare_rfq, base, stock, msf_profile, msf_doc_import, sale, account_hq_entries, res_currency_tables, account
 #: field:wizard.split.invoice.lines,wizard_id:0
 #: view:ir.actions.wizard:0
 #: field:wizard.ir.model.menu.create.line,wizard_id:0
@@ -45045,6 +45057,7 @@
 #: field:stock.move.processor,wizard_id:0
 #: field:warning.import.currencies.lines,wizard_id:0
 #: field:sale.order.leave.close,wizard_id:0
+#: field:account.invoice.import.errors,wizard_id:0
 msgid "Wizard"
 msgstr "Assistant"
 
@@ -49381,6 +49394,7 @@
 #: field:account.invoice.tax,partner_id:0
 #: field:account.tax,partner_id:0
 #: report:addons/account/report/invoice_excel_export.mako:80
+#: report:addons/account/report/export_invoice.mako:100
 #, python-format
 msgid "Partner"
 msgstr "Partenaire"
@@ -53657,6 +53671,7 @@
 #: report:sale.order.allocation.report:0
 #: report:addons/account/report/free_allocation_report.mako:199
 #: report:addons/account/report/invoice_excel_export.mako:73
+#: report:addons/account/report/export_invoice.mako:0
 #, python-format
 msgid "Account"
 msgstr "Compte"
@@ -54637,15 +54652,28 @@
 msgid "  value amount: 0.02"
 msgstr " valeur du montant : 0,02"
 
-#. modules: msf_doc_import, register_accounting
+#. modules: msf_doc_import, register_accounting, account
 #: code:addons/msf_doc_import/account.py:201
 #: code:addons/msf_doc_import/account.py:254
 #: code:addons/register_accounting/wizard/wizard_register_import.py:257
 #: code:addons/register_accounting/wizard/wizard_register_import.py:355
+#: code:addons/account/wizard/account_invoice_import.py:73
 #, python-format
 msgid "Checking file…"
 msgstr "Vérification du fichier…"
 
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:85
+#, python-format
+msgid "Checking header…"
+msgstr "Vérification de l'en-tête…"
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:134
+#, python-format
+msgid "Checking lines…"
+msgstr "Vérification des lignes…"
+
 #. modules: tender_flow, purchase_allocation_report, register_accounting, return_claim, transport_mgmt, res_currency_tables, stock_override, stock_forecast, analytic, stock, msf_order_date, reason_types_moves, procurement_request, consumption_calculation, purchase_override, kit, out_step, purchase, account, msf_outgoing, sale, sales_followup, procurement
 #: selection:account.account,type:0
 #: selection:account.account.template,type:0
@@ -57361,6 +57389,7 @@
 #: field:wizard.register.creation.lines,journal_id:0
 #: view:stock.picking:0
 #: model:ir.model,name:sync_so.model_account_journal
+#: report:addons/account/report/export_invoice.mako:92
 #, python-format
 msgid "Journal"
 msgstr "Journal"
@@ -58287,6 +58316,7 @@
 #: field:replenishment.inventory.review.line,warning_html:0
 #: field:replenishment.order_calc.line,warning_html:0
 #: view:product.ask.activate.wizard:0
+#: code:addons/account/wizard/account_invoice_import.py:81
 #, python-format
 msgid "Warning"
 msgstr "Avertissement"
@@ -64591,6 +64621,7 @@
 #: field:internal.request.import.error.line,line_number:0
 #: report:addons/msf_supply_doc_export/report/supplier_performance_report_xls.mako:232
 #: report:addons/account/report/invoice_excel_export.mako:65
+#: report:addons/account/report/export_invoice.mako:119
 #, python-format
 msgid "Line number"
 msgstr "Numéro de ligne"
@@ -64970,6 +65001,7 @@
 #: field:hq.entries.split,date:0
 #: selection:integrity.finance.wizard,filter:0
 #: code:addons/account_override/res_company.py:40
+#: report:addons/account/report/export_invoice.mako:108
 #, python-format
 msgid "Posting Date"
 msgstr "Date de Comptabilisation"
@@ -68641,7 +68673,7 @@
 msgid "Kit Composition"
 msgstr "Kit - Composition"
 
-#. modules: register_accounting, msf_homere_interface, account_override, base, msf_doc_import, msf_profile, sync_client, msf_supply_doc_export
+#. modules: register_accounting, msf_homere_interface, account_override, base, msf_doc_import, msf_profile, sync_client, msf_supply_doc_export, account
 #: view:ir.attachment:0
 #: view:ir.attachment:0
 #: selection:msf.doc.import.accounting,state:0
@@ -68654,6 +68686,7 @@
 #: field:account.direct.invoice.wizard.line,create_date:0
 #: selection:sync.client.log_sale_purchase,action_type:0
 #: code:addons/msf_supply_doc_export/msf_supply_doc_export.py:896
+#: selection:account.invoice.import,state:0
 msgid "Created"
 msgstr "Créé"
 
@@ -73483,6 +73516,8 @@
 #: code:addons/account/wizard/account_report_liquidity_balance.py:75
 #: code:addons/account_override/period.py:148
 #: code:addons/account_override/account.py:1256
+#: code:addons/account/wizard/account_invoice_import.py:0
+#: selection:account.invoice.import,state:0
 #, python-format, python-format
 msgid "Error"
 msgstr "Erreur"
@@ -73909,7 +73944,7 @@
 msgid "Do you want to update the Date of Stock Take of all/selected Order lines ?"
 msgstr "Voulez-vous mettre à jour la Date de Prise de Stock sur toutes les lignes de la Commande ou les lignes sélectionnées ?"
 
-#. modules: register_accounting, msf_homere_interface, documents_done, consumption_calculation, msf_button_access_rights, mission_stock, msf_doc_import, analytic_distribution, sourcing, sale
+#. modules: register_accounting, msf_homere_interface, documents_done, consumption_calculation, msf_button_access_rights, mission_stock, msf_doc_import, analytic_distribution, sourcing, sale, account
 #: field:mass.reallocation.verification.wizard,error_ids:0
 #: field:monthly.review.consumption.line,text_error:0
 #: field:real.average.consumption.line,text_error:0
@@ -73926,6 +73961,7 @@
 #: field:wizard.register.import,error_ids:0
 #: field:msf.import.export,error_message:0
 #: code:addons/sourcing/wizard/multiple_sourcing.py:252
+#: field:account.invoice.import,error_ids:0
 #, python-format
 msgid "Errors"
 msgstr "Erreurs"
@@ -74080,6 +74116,7 @@
 #: selection:res.request,ref_doc1:0
 #: selection:res.request,ref_doc2:0
 #: view:account.direct.invoice.wizard:0
+#: field:account.invoice.import,invoice_id:0
 msgid "Invoice"
 msgstr "Facture"
 
@@ -75812,8 +75849,9 @@
 msgid "Asset Follow Up"
 msgstr "Actif - Suivi"
 
-#. module: register_accounting
+#. modules: register_accounting, account
 #: view:wizard.register.import:0
+#: view:account.invoice.import:0
 msgid "Select file to import"
 msgstr "Sélectionner le fichier à importer"
 
@@ -76471,6 +76509,7 @@
 #: code:addons/consumption_calculation/weekly_forecast_report.py:506
 #: report:order.type.donation.certificate:0
 #: report:addons/stock/report/stock_delivery_report_xls.mako:220
+#: report:addons/account/report/export_invoice.mako:123
 #, python-format
 msgid "Unit Price"
 msgstr "Prix Unitaire"
@@ -81011,7 +81050,7 @@
 msgid "Wizard lines for internal picking processor"
 msgstr "Wizard lines for internal picking processor"
 
-#. modules: vertical_integration, register_accounting, res_currency_tables, account_hq_entries, update_client, msf_tools, msf_doc_import, analytic_distribution
+#. modules: vertical_integration, register_accounting, res_currency_tables, account_hq_entries, update_client, msf_tools, msf_doc_import, analytic_distribution, account
 #: view:hq.entries.import:0
 #: view:import.commitment.wizard:0
 #: view:msf.doc.import.accounting:0
@@ -81024,6 +81063,7 @@
 #: view:import.table.currencies:0
 #: view:sync_client.upgrade:0
 #: view:wizard.import.mapping:0
+#: view:account.invoice.import:0
 msgid "Import"
 msgstr "Importer"
 
@@ -81703,6 +81743,7 @@
 #: field:replenishment.inventory.review,state:0
 #: field:replenishment.order_calc,state:0
 #: field:replenishment.segment,state:0
+#: field:account.invoice.import,state:0
 #, python-format
 msgid "State"
 msgstr "Statut"
@@ -82633,6 +82674,7 @@
 #: view:products.situation.report:0
 #: field:replenishment.product.list,product_id:0
 #: report:addons/account/report/invoice_excel_export.mako:66
+#: report:addons/account/report/export_invoice.mako:120
 #, python-format
 msgid "Product"
 msgstr "Produit"
@@ -82803,6 +82845,7 @@
 #: selection:wizard.import.ppl.to.create.ship,state:0
 #: selection:wizard.import.product.line,state:0
 #: selection:product.mass.update,state:0
+#: selection:account.invoice.import,state:0
 #, python-format
 msgid "Done"
 msgstr "Terminé"
@@ -82862,7 +82905,7 @@
 msgid "Computation"
 msgstr "Calcul"
 
-#. modules: register_accounting, msf_homere_interface, import_data, account_hq_entries, export_import_lang, base, msf_doc_import, mission_stock, analytic_distribution
+#. modules: register_accounting, msf_homere_interface, import_data, account_hq_entries, export_import_lang, base, msf_doc_import, mission_stock, analytic_distribution, account
 #: field:int.commitment.export.wizard,data:0
 #: field:import_category,file:0
 #: field:import_nomenclature,file:0
@@ -82880,6 +82923,7 @@
 #: field:hr.payroll.employee.import,file:0
 #: field:hr.payroll.import,file:0
 #: field:wizard.register.import,file:0
+#: field:account.invoice.import,file:0
 msgid "File"
 msgstr "Fichier"
 
@@ -83561,7 +83605,7 @@
 msgid "Sourced-n line"
 msgstr "Ligne sourcée-n"
 
-#. modules: analytic_distribution, sales_followup, register_accounting, reason_types_moves, msf_homere_interface, stock_override, consumption_calculation, sale, specific_rules, order_types, msf_tools, mission_stock, msf_doc_import, stock, product
+#. modules: analytic_distribution, sales_followup, register_accounting, reason_types_moves, msf_homere_interface, stock_override, consumption_calculation, sale, specific_rules, order_types, msf_tools, mission_stock, msf_doc_import, stock, product, acccount
 #: field:import.commitment.wizard,in_progress:0
 #: view:product.history.consumption:0
 #: selection:product.history.consumption,fake_status:0
@@ -83606,6 +83650,7 @@
 #: selection:wizard.import.product.line,state:0
 #: selection:product.mass.update,state:0
 #: selection:stock.expired.damaged.report,state:0
+#: selection:account.invoice.import,state:0
 #, python-format
 msgid "In Progress"
 msgstr "En cours"
@@ -90952,6 +90997,11 @@
 msgid "Number"
 msgstr "Nombre"
 
+#. module: account
+#: report:addons/account/report/export_invoice.mako:88
+msgid "Number"
+msgstr "Numéro"
+
 #. module: msf_doc_import
 #: code:addons/msf_doc_import/account.py:303
 #, python-format
@@ -92851,6 +92901,7 @@
 #: report:order.type.donation.certificate:0
 #: report:addons/msf_supply_doc_export/report/supplier_performance_report_xls.mako:238
 #: report:addons/stock/report/stock_delivery_report_xls.mako:221
+#: report:addons/account/report/export_invoice.mako:96
 #, python-format
 msgid "Currency"
 msgstr "Devise"
@@ -95784,6 +95835,7 @@
 #: report:addons/vertical_integration/report/open_invoices_xls.mako:290
 #: report:account.invoice2:0
 #: code:addons/account_override/res_company.py:40
+#: report:addons/account/report/export_invoice.mako:104
 #, python-format
 msgid "Document Date"
 msgstr "Date du Document"
@@ -96495,6 +96547,7 @@
 #: view:replenishment.order_calc:0
 #: view:replenishment.segment:0
 #: view:product.ask.activate.wizard:0
+#: view:account.invoice.import:0
 #, python-format
 msgid "Cancel"
 msgstr "Annuler"
@@ -97726,6 +97779,7 @@
 #: selection:sync.monitor,user_rights:0
 #: selection:shipment.add.pack.processor.line,integrity_status:0
 #: selection:stock.move,integrity_error:0
+#: view:account.invoice.import:0
 #: code:addons/msf_outgoing/__init__.py:26
 msgid "Ok"
 msgstr "Ok"
@@ -106292,8 +106346,9 @@
 msgid "Impossible to retrieve the account code at line level."
 msgstr "Impossible de récupérer le code comptable au niveau d'une ligne."
 
-#. module: account_override
+#. modules: account_override, account
 #: code:addons/account_override/account_invoice_sync.py:193
+#: code:addons/account/wizard/account_invoice_import.py:107
 #, python-format
 msgid "Currency %s not found or inactive."
 msgstr "Devise %s non trouvée ou inactive."
@@ -109055,6 +109110,7 @@
 
 #. module: account
 #: report:addons/account/report/invoice_excel_export.mako:56
+#: report:addons/account/report/export_invoice.mako:80
 msgid "Sheet"
 msgstr "Feuille"
 
@@ -109195,3 +109251,119 @@
 #: code:addons/account_override/invoice.py:1272
 msgid "Split Stock Transfer Voucher"
 msgstr "Fractionner Bon Client"
+
+#. modules: account_override, register_accounting
+#: view:account.invoice:0
+#: view:account.invoice:0
+msgid "Export Invoice"
+msgstr "Exporter la Facture"
+
+#. module: account
+#: report:addons/account/report/export_invoice.mako:9
+#: model:ir.actions.report.xml,name:account.export_invoice
+msgid "Export - Invoice"
+msgstr "Export - Facture"
+
+#. modules: account_override, account, register_accounting
+#: view:account.invoice.import:0
+#: code:addons/account_override/invoice.py:1652
+#: view:account.invoice:0
+#, python-format
+msgid "Import Invoice"
+msgstr "Importer la Facture"
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:159
+#, python-format
+msgid "Line %s: the account (mandatory) is missing."
+msgstr "Ligne %s : il manque le compte (obligatoire)."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:163
+#, python-format
+msgid "Line %s: the account %s doesn't exist."
+msgstr "Ligne %s : le compte %s n'existe pas."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:115
+#, python-format
+msgid "Partner %s not found or inactive."
+msgstr "Partenaire %s non trouvé ou inactif."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:233
+#, python-format
+msgid "An error occurred: %s: %s"
+msgstr "Une erreur est survenue : %s : %s"
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:177
+#, python-format
+msgid "Line %s: the account %s is not allowed."
+msgstr "Ligne %s : le compte %s n'est pas autorisé."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:168
+#, python-format
+msgid "Line %s: the account %s is inactive."
+msgstr "Ligne %s : le compte %s est inactif."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:102
+#, python-format
+msgid "No currency found."
+msgstr "Pas de devise trouvée."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:112
+#, python-format
+msgid "No partner found."
+msgstr "Pas de partenaire trouvé."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:200
+#, python-format
+msgid "Line %s: the quantity format is incorrect."
+msgstr "Ligne %s : le format de la quantité est incorrect."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:156
+#, python-format
+msgid "Line %s: the line number %s doesn't exist in the invoice."
+msgstr "Ligne %s : le numéro de ligne %s n'existe pas dans la facture."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:151
+#, python-format
+msgid "Line %s: the line number is missing."
+msgstr "Ligne %s : il manque le numéro de ligne."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:128
+#, python-format
+msgid "The combination \"Currency, Partner and Posting Date\" of the imported file doesn't match with the current invoice."
+msgstr "La combinaison \"Devise, Partenaire et Date de Comptabilisation\" du fichier importé ne correspond pas à la facture actuelle."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:121
+#, python-format
+msgid "The posting date has a wrong format."
+msgstr "La date de comptabilisation a un mauvais format."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:183
+#, python-format
+msgid "Line %s: the unit price format is incorrect."
+msgstr "Ligne %s : le format du prix unitaire est incorrect."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:194
+#, python-format
+msgid "Line %s: the product %s doesn't exist or is inactive."
+msgstr "Ligne %s : le produit %s n'existe pas ou est inactif."
+
+#. module: account
+#: code:addons/account/wizard/account_invoice_import.py:86
+#, python-format
+msgid "The import is allowed only in Draft state."
+msgstr "L'import est autorisé uniquement à l'état Brouillon."

=== modified file 'bin/addons/register_accounting/account_invoice_view.xml'
--- bin/addons/register_accounting/account_invoice_view.xml	2020-02-26 15:14:53 +0000
+++ bin/addons/register_accounting/account_invoice_view.xml	2020-04-27 09:12:30 +0000
@@ -317,8 +317,15 @@
                         <field name="supplier_reference"/>
                     </field>
                     <xpath expr="/form/notebook/page[@string='Invoice']/field[@name='invoice_line']" position="before" >
-                        <group name="import" string=" Import Lines " colspan="4" col="4" attrs="{'invisible':[('state', '!=', 'draft')]}">
-                            <button name="wizard_import_si_line" string="Import lines" icon="gtk-dnd" type="object"
+                        <group name="import" string=" Import Lines " colspan="4" col="4"
+                               attrs="{'invisible': [('state', '!=', 'draft'), ('type', '!=', 'in_invoice')]}">
+                            <button name="import_invoice" string="Import Invoice" icon="gtk-execute" colspan="2" type="object"
+                                    attrs="{'readonly': [('state', '!=', 'draft')],
+                                            'invisible': [('type', '!=', 'in_invoice')]}"/>
+                            <button name="export_invoice" string="Export Invoice" icon="gtk-execute" colspan="2" type="object"
+                                    attrs="{'invisible': [('type', '!=', 'in_invoice')]}"/>
+                            <newline/>
+                            <button name="wizard_import_si_line" string="Import lines" icon="gtk-dnd" colspan="4" type="object"
                                     attrs="{'invisible': [('state', '!=', 'draft')],
                                             'readonly': [('type', '=', 'in_invoice'), ('synced', '=', True)]}"/>
                         </group>