Community mailing list archives

community@mail.odoo.com

Avatar

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

by
Dynamic Web Technologies Pty. Ltd., Anwar Ahmed
- 04/27/2017 01:49:47

Hi Anand,

As per the information you provided, you need to add credit leg also in the said journal entry. Its double entry system that is the reason you are getting valid message.


Anwar Ahmed
Business Analyst

Dynamic Web Technologies Pty. Ltd.

[P] +966 13 814 8371
[F] +966 13 814 8376
[M] +966 50 749 7540
[E] a.ahmed@dwt.com.au

http://dwt.com.au/

Disclaimer: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorised review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please destroy all copies of the  original message and notify the sender immediately, so that our address record can be corrected. Dynamic Web Technologies Pty. Ltd. operates in  Saudi Arabia in partnership with Sky Gulf Information Technology Co. Thank you. 
On 27/04/17 08:40, Anand Shukla wrote:
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 1 Bill 001
1000
12* Account Payable Customer 2 Bill 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. 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe