Community mailing list archives

community@mail.odoo.com

Avatar

How to import Opening Balance in Odoo 10.0? gives warning : Cannot create unbalanced journal entry.

by
amshukla
- 04/27/2017 01:35:44
Hello, Community!

I trying to import Opening balance in odoo 10.0 but its giving me following warning. 

"Cannot create unbalanced journal entry. "

I have created Opening Balance Journal as,
Journal Name: Opening Balance 
Type: Miscellaneous
Code: OPB
Default Debit Account: Opening Expense account [ Account Configuration : Name: Opening Expesnse Account, and Type: Expense]
Defalut Credit Account : Opening Income account [ Account Configuration:  Name: Opening Income Account, and Type: Other Income]

Now when I try to import My following Data for account.move.line, at that time above warning raised and not allowed to import journal entries in account.move.line, As I remember in 8.0 same warning was at time of posting entry but something changed in 10.0.

     <td height="17" align="left" sdnum="16393;0;@" id="yui_3_16_0_ym19_1_1493268792589_31315">5-03-17 <td align="left" sdnum="16393;0;@" id="yui_3_16_0_ym19_1_1493268792589_31324">20-04-17 <td height="17" align="left" sdnum="16393;0;@" id="yui_3_16_0_ym19_1_1493268792589_31326">2-03-17 <td align="left" sdnum="16393;0;@" id="yui_3_16_0_ym19_1_1493268792589_31335">21-04-17
date journal_id/id line_ids/account_id line_ids/partner_id line_ids/name line_ids/debit line_ids/credit line_ids/date_maturity
12* Account Payable    Customer 1Bill 001
1000
12*Account Payable Customer 2Bill 002

15000
    * Id of the Opening Balance Journal in database. 

So can you guys hint me what I doing wrong and import it successfully. 

Thanks

Regards,
Anand - Odoo (OpenERP) Developer.