Skip to Content
This question has been flagged
accountingexportimportjournal_entryjournal_item
2 Replies
222 Views
Avatar
Abdallah Mahmoud

Hello,

I am using Odoo 18 Enterprise and I need to update some existing Journal Items.

I exported the Journal Items list, modified some values in the exported file, and now I want to import the updated data back into Odoo. However, I noticed that the Import button is not available on the Journal Items (account.move.line) list view, while it is available on many other models.

Is this the standard behavior in Odoo 18? If so, what is the recommended way to perform a bulk update on existing Journal Items using an import file?

My goal is to update existing records rather than create new ones.

Thank you.

Avatar
Discard
Chris TRINGHAM

You can import Journal Entries, you should be able to update them (if in draft) by exporting, updating and importing - including the Journal Items in each Journal Entry. Have you tried that?

Avatar
Zehntech Technologies Inc.
Best Answer

Hello,

Yes, this is generally standard behavior in Odoo 18. Journal Items (account.move.line) are core accounting records, and Odoo restricts direct import access on certain accounting models to preserve data integrity and auditability.

The recommended approach depends on what you need to update and whether the related journal entries are in Draft or Posted status. In many cases, updates should be performed through the parent Journal Entry rather than directly on Journal Items. For large-scale changes, a custom import/update process may be required.

Could you share which fields you are trying to update and whether the entries are posted or draft? That will help determine the safest approach.

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

Avatar
Discard
Avatar
Codesphere Tech
Best Answer

Hello
Use the Accounting Import from Accounting --> Configuration --> Settings:


Hope this helps
Thanks

Avatar
Discard
Related Posts Replies Views Activity
Import Journal Entries in different currencies.
accounting import journal_entry
Avatar
2
May 25
3328
What is "Matching Number" in a Journal Item? Solved
accounting journal_entry journal_item
Avatar
Avatar
Avatar
3
Dec 19
11125
I HAVE AN DOLLAR , EURO TRANSACTIONS I WANT TO GET TOTAL FOR EACH FOREIGN CURRENCY AND HOW MUCH DOLLAR AND EURO I OWE IN EACH JOURNAL
accounting currency journal_entry journal_item
Avatar
0
Dec 25
1395
Put fields of an employee in accounting through a module
accounting employee journal_entry journal_item
Avatar
0
Dec 17
13
import error in acounting module
accounting import journal_entry odoo10
Avatar
0
Jul 17
5499