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
- Kirjanpito
- Varastointi
- PoS
- Projekti
- MRP
Tämä kysymys on merkitty
1
Vastaa
2524
Näkymät
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
Nautitko keskustelusta? Älä vain lue, vaan osallistu!
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
1
jouluk. 25
|
332 | ||
|
3
syysk. 25
|
3779 | ||
|
0
elok. 25
|
1168 | ||
|
1
elok. 25
|
3546 | ||
|
2
heinäk. 25
|
9182 |
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