.. image:: https://img.shields.io/badge/licence-AGPL--3-blue.svg
:target: http://www.gnu.org/licenses/agpl-3.0-standalone.html
:alt: License: AGPL-3
=========================
Import Accounting Entries
=========================
This module adds a button on the ‘Journal Entry’ screen to allow the import of the entry lines from a CSV file.
Before starting the import a number of sanity checks are performed such as:
- check if partner references are correct
- check if account codes are correct
- check if the sum of debits and credits are balanced
If no issues are found the entry lines will be loaded.
The resulting Journal Entry will be in draft mode to allow a final check before posting the entry.
Usage
=====
Input file column headers
-------------------------
Mandatory Fields
''''''''''''''''
- Account
Account codes are looked up via exact match.
- Debit
- Credit
Other Fields
''''''''''''
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
unless special support has been added for that field in this
module (or a module that extends the capabilities of this module).
This module has implemented specific support for the following fields:
- Name
If not specified, a '/' will be used as name.
- Partner
The value must be unique.
Lookup logic : exact match on partner reference,
if not found exact match on partner name.
- Product
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.
- Due date (or date_maturity)
Date format must be yyyy-mm-dd)
- Currency
Specify currency code, e.g. 'USD', 'EUR', ... )
- Tax Account (or tax_code)
Lookup logic : exact match on tax case 'code' field, if not found exact match on tax case 'name'.
- Analytic Account (or analytic_account)
Lookup logic : exact match on code,
if not found exact match on name.
A blank column header indicates the end of the columns that will be
processed. This allows 'comment' columns on the input lines.
Empty lines or lines starting with '#' will be ignored.
Input file example
------------------
Cf. directory 'sample_import_file' of this module.
Known Issues
============
This module uses the Python *csv* module for the reading of the input csv file.
The input csv file should take into account the limitations of the *csv* module:
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.
Bug Tracker
===========
Bugs are tracked on `GitHub Issues
<https://github.com/OCA/account-financial-tools/issues>`_. In case of trouble, please
check there if your issue has already been reported. If you spotted it first,
help us smashing it by providing a detailed and welcomed feedback.
Credits
=======
Contributors
------------
* Luc De Meyer, Noviat <info@noviat.com>
Maintainer
----------
.. image:: https://odoo-community.org/logo.png
:alt: Odoo Community Association
:target: https://odoo-community.org
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose
mission is to support the collaborative development of Odoo features and
promote its widespread use.
To contribute to this module, please visit https://odoo-community.org.
Raw data
{
"_id": null,
"home_page": "http://www.noviat.com",
"name": "odoo8-addon-account-move-line-import",
"maintainer": "",
"docs_url": null,
"requires_python": "~=2.7",
"maintainer_email": "",
"keywords": "",
"author": "Noviat,Odoo Community Association (OCA)",
"author_email": "support@odoo-community.org",
"download_url": "",
"platform": "",
"description": ".. image:: https://img.shields.io/badge/licence-AGPL--3-blue.svg\n :target: http://www.gnu.org/licenses/agpl-3.0-standalone.html\n :alt: License: AGPL-3\n\n=========================\nImport Accounting Entries\n=========================\n\nThis module adds a button on the \u2018Journal Entry\u2019 screen to allow the import of the entry lines from a CSV file.\n\nBefore starting the import a number of sanity checks are performed such as:\n\n- check if partner references are correct\n- check if account codes are correct\n- check if the sum of debits and credits are balanced\n\nIf no issues are found the entry lines will be loaded.\nThe resulting Journal Entry will be in draft mode to allow a final check before posting the entry.\n\nUsage\n=====\n\nInput file column headers\n-------------------------\n\nMandatory Fields\n''''''''''''''''\n\n- Account\n\n Account codes are looked up via exact match.\n\n- Debit\n\n- Credit\n\nOther Fields\n''''''''''''\n\nExtra columns can be added and will be processed as long as\nthe column header is equal to the 'ORM' name of the field.\nInput fields with no corresponding ORM field will be ignored\nunless special support has been added for that field in this\nmodule (or a module that extends the capabilities of this module).\n\nThis module has implemented specific support for the following fields:\n\n- Name\n\n If not specified, a '/' will be used as name.\n\n- Partner\n\n The value must be unique.\n Lookup logic : exact match on partner reference,\n if not found exact match on partner name.\n\n- Product\n\n The value must be unique.\n A lookup will be peformed on the 'Internal Reference' (default_code) field of the Product record.\n In case of no result, a second lookup will be initiated on the Product Name. \n\n- Due date (or date_maturity)\n\n Date format must be yyyy-mm-dd)\n\n- Currency\n\n Specify currency code, e.g. 'USD', 'EUR', ... )\n\n- Tax Account (or tax_code)\n\n Lookup logic : exact match on tax case 'code' field, if not found exact match on tax case 'name'.\n\n- Analytic Account (or analytic_account)\n\n Lookup logic : exact match on code,\n if not found exact match on name.\n\nA blank column header indicates the end of the columns that will be\nprocessed. This allows 'comment' columns on the input lines.\n\nEmpty lines or lines starting with '#' will be ignored.\n\nInput file example\n------------------\n\nCf. directory 'sample_import_file' of this module.\n\nKnown Issues\n============\n\nThis module uses the Python *csv* module for the reading of the input csv file.\nThe input csv file should take into account the limitations of the *csv* module:\n\nUnicode input is not supported. Also, there are some issues regarding ASCII NUL characters.\nAccordingly, all input should be UTF-8 or printable ASCII.\nResults are unpredictable when this is not the case.\n\nBug Tracker\n===========\n\nBugs are tracked on `GitHub Issues\n<https://github.com/OCA/account-financial-tools/issues>`_. In case of trouble, please\ncheck there if your issue has already been reported. If you spotted it first,\nhelp us smashing it by providing a detailed and welcomed feedback.\n\nCredits\n=======\n\nContributors\n------------\n\n* Luc De Meyer, Noviat <info@noviat.com>\n\nMaintainer\n----------\n\n.. image:: https://odoo-community.org/logo.png\n :alt: Odoo Community Association\n :target: https://odoo-community.org\n\nThis module is maintained by the OCA.\n\nOCA, or the Odoo Community Association, is a nonprofit organization whose\nmission is to support the collaborative development of Odoo features and\npromote its widespread use.\n\nTo contribute to this module, please visit https://odoo-community.org.\n\n\n",
"bugtrack_url": null,
"license": "AGPL-3",
"summary": "Import Accounting Entries",
"version": "8.0.1.0.3",
"project_urls": {
"Homepage": "http://www.noviat.com"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "cec4be8acd2dc64d9635e616def78cf8c561a92a0627200b7399ce5fd77b6dae",
"md5": "35dc6c8054db28fb4f63d7cd57adee91",
"sha256": "32cae8bbc290c610e701acc8d64872f1eda91deb52f102067c49d582633ac23c"
},
"downloads": -1,
"filename": "odoo8_addon_account_move_line_import-8.0.1.0.3-py2-none-any.whl",
"has_sig": false,
"md5_digest": "35dc6c8054db28fb4f63d7cd57adee91",
"packagetype": "bdist_wheel",
"python_version": "py2",
"requires_python": "~=2.7",
"size": 196998,
"upload_time": "2017-10-17T04:30:25",
"upload_time_iso_8601": "2017-10-17T04:30:25.603029Z",
"url": "https://files.pythonhosted.org/packages/ce/c4/be8acd2dc64d9635e616def78cf8c561a92a0627200b7399ce5fd77b6dae/odoo8_addon_account_move_line_import-8.0.1.0.3-py2-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2017-10-17 04:30:25",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "odoo8-addon-account-move-line-import"
}
JSON