I have a new business and starting to use odoo 14 cloud hosted after using odoo 11 on premise years ago and I need to import journals.
I created xls using example in youtube video titled 'How to import Journal Entries in Odoo V14'
I tried with just one journal made up of a heading line and three data lines (2 debits and 1 credit) that all balance as a whole but obviously each line does not balance.
I get the following errors:
Unknown error during import: (class 'odoo . exceptions . UserError'): Cannot create unbalanced journal entry. Ids: (9180) Differences debit - credit: (103.56) at row 2 Resolve other errors first
Unknown error during import: (class 'odoo . exceptions . UserError'): Cannot create unbalanced journal entry. Ids: (9181) Differences debit - credit: (10.36) at row 3 Resolve other errors first
Unknown error during import: (class 'odoo . exceptions . UserError'): Cannot create unbalanced journal entry. Ids: (9182) Differences debit - credit: (-113.92) at row 4 Resolve other errors first
How can I import when each line will not balance but the whole journal of multiple lines does balance?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
1999
Views
Hi Khaled, I am struggling importing a journal with multiple line items in Odoo v14. I have exported an example, trying to reimport a file base on the same field names but this doesn't work, the journal is created but without any line items. Would you mind sharing your file format?
Thx
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Nov 24
|
1479 | ||
|
|
1
Nov 24
|
1184 | ||
|
2
Sep 24
|
1046 | ||
|
Update stock quantity
Solved
|
|
1
Aug 24
|
2448 | |
|
3
Aug 24
|
2681 |
You need to import all journal entry with all items and you have to leave journal entry fields blank from second item as you watched in the youtube video.
Please share your file data which you tried to import So the community can help you.
I had that. But I have now solved it. I had additonal fields in the file and even though I had marked them as "do not import / ingore", something weird was happening. I reformatted the file and got rid of the extra ununsed fields and bingo, all done. Thanks for your help