Skip to Content
This question has been flagged
accountingexportimportjournal_entryjournal_item
3 Replies
384 Zobrazenia
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
Zrušiť
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
Codesphere Tech
Best Answer

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


Hope this helps
Thanks

Avatar
Zrušiť
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
Zrušiť
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


Yes, this is standard behavior in Odoo 18. The Import option is not available for Journal Items (account.move.line) because they are accounting entries generated from source documents, and Odoo restricts direct modifications to preserve accounting integrity.


If you need to update journal items, the recommended approach is to update the originating document (invoice, bill, payment, or journal entry) and let Odoo regenerate the entries. For posted entries, direct bulk updates via import are not supported out of the box.


Hope it helps

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
Import Journal Entries in different currencies.
accounting import journal_entry
Avatar
2
máj 25
3400
What is "Matching Number" in a Journal Item? Solved
accounting journal_entry journal_item
Avatar
Avatar
Avatar
3
dec 19
11207
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
júl 17
5555