| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 336 |
| Technical Name |
import_account_move_csv |
| License | OPL-1 |
| Website | http://www.auneor-conseil.fr |
| Versions | 9.0 10.0 11.0 15.0 13.0 12.0 16.0 14.0 |
Imports account move from csv/ebp file
This modules allows to import account move lines from a csv or ebp file. Each line of the csv/ebp represent an account.move.line.
CSV/EBP file format
The separator has to be the comma, and the delimiter has to be the double quote.
There must be no blank field.
For CSV file format, the column name must be : DATE JAL COMPTE PCE LIBELLE DEBIT CREDIT.
DATE : is the date in DD/MM/YYYY format.
JAL : is the code of the journal.
COMPTE : is the account.account number.
PCE : is a key per account move, to identify to which account move and account move line belongs.
LIBELLE : is the name of the line.
DEBIT : is the amount of debit.
CREDIT : is the amount of credit.
AUX NUM (FEC) : allow to link the account move line to a partner. It accept two formats:
- "ID XXX" with XXX the id of the odoo partner.
- "XXX" with XXX the value of the odoo partner reference field (ref).
For EBP file format, the column sequence is important (you can use what you want in column name) :
- 2 : date in format ddmmyy.
- 3 : (like JAL) is the code of the journal.
- 4 : (like COMPTE) is the account.account number.
- 6 : (like LIBELLE) is the name of the line.
- 7 : (like PCE) a key per account move, to identify to which account move and account move line belongs.
- 8 : amount of the line.
- 9 : debit/credit flag ('D' or 'C').
- 11: name of the currency.
Presentation of the module
This module add the menu item "Import Account Move lines" under "Invoicing/Accounting" menu:
Warning: You must affect the right "Technical Settings / Show Full Accounting Features" on community version.
Here is the view allowing to import the accounting entries in csv / ebp format.
Test import
In the folder example, you will find files in csv and ebp formats allowing you to make tests and see the structure.
Before importing, you can test your file with the "Test import" button. It allow to see some warnings/error about the file. Some examples:
- Couldn't find journal %s in company %s
- Couldn't find account.account %s in company %s
- No partner associated to payable/receivable account.account
Import file
Once the file is imported, new lines appear in the form, these lines represent the imported account move lines.
Link move lines to a partner
For receivable/payable account move lines, this module search a partner with the corresponding account to be linked to this move line. For CSV format, you can specify which of these partners to use with the column "AUX NUM (FEC)". It accept two formats: - "ID XXX" with XXX the id of the odoo partner. - "XXX" with XXX the value of the odoo partner reference field (ref).
If you don't want to link account move lines to a partner for some receivable/payable accounts, you can check "Don't retrieve partner in import account move" on the account configuration (Accounting/Configuration/Account). This module do as follow to link move lines to partners:
If the move line is on payable/receivable account and "Don't retrieve partner in import account move" not checked:
Search partners with the corresponding receivable/payable account.
For CSV format:
If "AUX NUM (FEC)" set, filter the results.
If no matching partner log an error.
If multiple results:
- If only one matching company, use the company.
- If multiple company, use the first one.
- Other-else use the first matching partner.
Support
This module is maintained by Auneor Conseil.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module