Community mailing list archives
Re: How to import Opening Balance in Odoo 10.0? gives warning : Cannot create unbalanced journal entry.by
Same with Anwar, it is double entries concept. We cannot have only credit or debit. It has to be balance both side.
It is not real case if your business has Unbalance openning. It is valid warning from Odoo.
Your ERP Partner
Your ERP Partner
On 27 Apr 2017 1:25 p.m., "Anand Shukla" <email@example.com> wrote:
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 DebitAccount Payable Customer1 Bill1 6258043.4Account Payable Customer2 Bill2 -2372200Account Payable Customer3 Bill3 2536920Account Payable Customer4 Bill4 -378450Account Payable Customer5 Bill5 388600ThanksOn Thursday, April 27, 2017 11:20 AM, Anwar Ahmed <firstname.lastname@example.org> 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] email@example.com 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:
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 BalanceType: MiscellaneousCode: OPBDefault 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.
Regards,Anand - Odoo (OpenERP) Developer.