Odoo Help


Opening balance through Journal.

umer farooq
on 9/26/13, 11:06 AM 2,013 views


I am setting up accounting and finance module of openerp7 in my office now I need to define opening balance for my two sub accounts need to give values in debit section now when i give first account debit value it becomes Credit value for the other account then i give debit value for second account when i save it i get this error.

Constraint Error

Wrong credit or debit value in accounting entry !

please guide me.??

On 2/15/14, 1:20 PM

Dear Umer You can create Opening Entries as explained below

1) Create an Opening Entries Journal: In most of the Chart of Accounts this comes by default. If it's not present, create a journal "Opening Entries Journal" with Type="Opening/Closing Situation". Check the "Centralized Counterpart" option. 1a) create an Account "Opening Expense Account" of Internal Type="Regular" and Account Type="Expense" and set this as the Default Debit Account for the above journal 1b) create an Account "Opening Income Account" of Internal Type="Regular" and Account Type="Income" and set this as the Default Credit Account for the above journal

2) Now go to Accounting->Journal Entries-> Journal Entries and click "Create" to create the opening journal entry

3) Now select Journal="Opening Etnries Journal" and add all your Accounts here with their Opening balances. Make sure you enter the amount in credit or debit columns based on the opening balance type of respective accounts

4) Once all entries are made, save the journal entry and post it. If the opening entries you entered are unbalanced (means sum of credits are not equal to sum of debits), then automatically the balance amount will be posted to the Default Debit Account or Default Credit Account of the Journal created in the first step

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/26/13, 11:06 AM
Seen: 2013 times
Last updated: 10/26/15, 2:07 AM