Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
5 Trả lời
3665 Lượt xem

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.

Ảnh đại diện
Huỷ bỏ
Tác giả

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

Câu trả lời hay nhất

Hi, you can follow https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU

I hope it helps, thanks

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Tác giả

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.

Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Tác giả

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.

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 3 24
2323
1
thg 4 23
1679
0
thg 10 15
4282
3
thg 2 25
2675
0
thg 10 24
1012