<img alt="License" src="https://img.shields.io/badge/licence-AGPL--3-blue.svg"> <a name="import-invoice-lines"></a> <h2>Import Invoice Lines</h2> <p>This module adds a button on the Supplier Invoice Form to allow the import of invoice lines from a CSV file.</p> <a name="usage"></a> <h2>Usage</h2> <p><strong>Input file column headers:</strong></p> <ul> <li><p class="first">Description</p> </li> <li><p class="first">Product</p> <p>The value must be unique. A lookup will be peformed on the 'Internal Reference' (default_code) field of the Product record. In case of no result, a second lookup will be initiated on the Product Name.</p> </li> <li><p class="first">Unit of Measure</p> </li> <li><p class="first">Account</p> </li> <li><p class="first">Quantity</p> </li> <li><p class="first">Unit Price</p> </li> <li><p class="first">Taxes</p> <p>A lookup will be peformed on the 'Tax Code' (description) field of the Tax object. In case of no result, a second lookup will be initiated on the Tax Name. Use a comma as separator character to add multiple taxes.</p> </li> <li><p class="first">Analytic Account</p> </li> </ul> <p>Extra columns can be added and will be processed as long as the column header is equal to the 'ORM' name of the field. Input fields with no corresponding ORM field will be ignored.</p> <p>A blank column header indicates the end of the columns that will be processed. This allows 'comment' columns on the input lines.</p> <p>Empty lines or lines starting with '#' will be ignored.</p> <p><strong>Input file example:</strong></p> <p>Cf. directory 'sample_import_file' of this module.</p> <a name="known-issues"></a> <h2>Known Issues</h2> <p>This module uses the Python <em>csv</em> module for the reading of the input csv file. The input csv file should take into account the limitations of the <em>csv</em> module:</p> <p>Unicode input is not supported. Also, there are some issues regarding ASCII NUL characters. Accordingly, all input should be UTF-8 or printable ASCII. Results are unpredictable when this is not the case.</p>