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
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
1
Trả lời
2333
Lượt xem
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
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
3
thg 9 25
|
2658 | ||
|
0
thg 8 25
|
211 | ||
|
1
thg 8 25
|
2180 | ||
|
2
thg 7 25
|
8075 | ||
|
2
thg 7 25
|
4525 |
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