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
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
1
Rispondi
2330
Visualizzazioni
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
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
0
ago 25
|
165 | ||
|
1
ago 25
|
2123 | ||
|
1
lug 25
|
2593 | ||
|
2
lug 25
|
8034 | ||
|
2
lug 25
|
4489 |
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