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
amshukla
- 04/27/2017 02:20:33
Hi Anwar,
Thanks for prompt response, but as I have only single side data in my .csv and need to import, so what is best to import that .csv file?
given csv llike...
Account                   Customer      Label            Debit   
Account Payable Customer1 Bill1 6258043.4
Account Payable Customer2 Bill2 -2372200
Account Payable Customer3 Bill3 2536920
Account Payable Customer4 Bill4 -378450
Account Payable Customer5 Bill5 388600

Thanks



On Thursday, April 27, 2017 11:20 AM, Anwar Ahmed <a.ahmed@dwt.com.au> wrote:


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

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