Community mailing list archives
Re: How to import Opening Balance in Odoo 10.0? gives warning : Cannot create unbalanced journal entry.by
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
On Thursday, April 27, 2017 11:20 AM, Anwar Ahmed <firstname.lastname@example.org> wrote:
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
* Id of the Opening Balance Journal in database.
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
So can you guys hint me what I doing wrong and import it successfully.
Regards,Anand - Odoo (OpenERP) Developer.