Journal entry import in V12

Question

Hi, when I import journal entry in V12 facing following errors,
1. Found multiple matches for field 'Journal Items'
2. Unknown error during import: <class 'odoo.exceptions.UserError'>: ('Cannot create unbalanced journal entry.', '')
​

Dhivya N · Accepted Answer

Hi all, my issue resolved by removing "journal name" in each line.

Journal
Items/Account/Display Name
Partner
Journal Items/Date
Journal Items/Debit
Journal Items/Credit
Journal Items/Due date
Reference
Journal Items/Label
*journal*

Account
Receivable
Arun
2019-07-30
200
0
2019-07-30

Test
Customer Invoices

Product
Sales
Arun
2019-07-30
0
200
2019-07-30

Test

​

Florian · Answer

In the actual version, I am able to import by removing Journal, Description/Reference and Date for the counterparts of a journal entry.

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Regarding the first error,
1. You might be importing using the name, there might be multiple records with same name. So rather than importing with the name, import using the external ID.
2. Debit and Credit  side might be not equal, so you are getting this unbalanced error.

Thanks

المنشورات ذات الصلة	الردود	أدوات العرض
How to handle modification to a journal entry when it's already confirmed ? تم الحل accounting modification journal entry	1 سبتمبر 23	7835
Bank Journal Prefix Not Reflecting in Entries accounting journal	0 مارس 26	3
FAILURE TO IMPORT JOURNAL ENTRIES accounting import	1 فبراير 25	5103
Import plan comptable accounting import	0 مارس 24	3781
How to handle existing Odoo-data when setting up Odoo accounting? accounting import	1 أبريل 24	4036

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

Journal Items/Account/Display Name	Partner	Journal Items/Date	Journal Items/Debit	Journal Items/Credit	Journal Items/Due date	Reference	Journal Items/Label	journal
Account Receivable	Arun	2019-07-30	200	0	2019-07-30		Test	Customer Invoices
Product Sales	Arun	2019-07-30	0	200	2019-07-30		Test