When I try to import the journal entries from the excel sheet I get the following error
Cannot create unbalanced journal entry
But the debit and credit is matching.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 회계
- 재고 관리
- PoS
- Project
- MRP
신고된 질문입니다
5
답글
3730
화면
I am having the same issue when I try to enter a Journal entry.
The format I use is (below)...this doesn't seem to work??????
| journal_id | move_id | date | partner_id | name | account_id | debit | credit |
| MISC | MISC/2023/00001 | 2023-10-06 | Keith2 | rent | 7900 Rent or Lease | 20 |
the format is here https://app.box.com/s/g9nubruskfi8ubz9l4d6oy5srq9yo55g
The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.
Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.
Found a Solution at https://github.com/odoo/odoo/issues/33469
I am using Odoo 15 . so commented the following line in
/opt/bitnami/apps/odoo/lib/odoo-{your-version}.egg/odoo/addons/account/models/ account_move.py
#raise UserError(("Cannot create unbalanced journal entry."))
After this the Import is working however the Debit and Credit balancing has to be ensured by you as the system will not check for the balancing of debit and credit
I could upload without commenting the code. The issue was with the file format. The subsequent lines of the Journal entry should not have date,Journal,ref,account_code. These should be left blank to be considered as the same journal entry.
The problem might be after the decimal point
for example
credit: 1900.0002
debit: 1900.0
this wont match based on you currency decimal points
so instead of commenting the code you should make the credit equals debit.
The debit and credit is matching. There are no decimals. I tried a test upload with only two entries. that too failed. Kindly let me know the format for uploading the journal entries.
| 관련 게시물 | 답글 | 화면 | 활동 | |
|---|---|---|---|---|
|
1
3월 24
|
2361 | ||
|
1
4월 23
|
1679 | ||
|
0
10월 15
|
4300 | ||
|
3
2월 25
|
2708 | ||
|
0
10월 24
|
1046 |
Hi,
Refer to this odoo16 Accounting Enterprise book
https://www.cybrosys.com/odoo/odoo-books/odoo-book-v16/accounting/accounting-import/
Hope it helps you
The issue is each line is taken as a Journal Entry Instead of a Journal Item. Kind share the format for importing Journal Item within the Journal Entry