Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Initial Balances - V12

Subscribe

Get notified when there's activity on this post

This question has been flagged
accountingerrorbalanceinitial
9 Replies
9430 Views
Avatar
Darren

Hi 

We are trying to input our initial balances in V12 Enterprise . We seem to have to do this in Journal Entries and manually input the Debit and Credit amounts. But we only get so far 274 entries and then we get the following error when we save.



Odoo Server Error - Validation Error

Wrong credit or debit value in accounting entry! Credit or debit should be zero.


We have checked all entries, they look correct and all have a corresponding entry.

In V11, there was an Initial Balances setup in the dashboard of the Accounting App. But this seems to have been removed in V12.

Does anyone know how to set up Initial Balance in V12??


Thanks

Darren


0
Avatar
Discard
Avatar
Ajeet Yadav (Softprime Consulting Pvt Ltd)
Best Answer

If you click on chart of account from accounting dashboard on top it will redirect accounts list where you can set opening credit and debit for each accounts. If you allready close it or open it, then it will not show you. In that case you can show that tree view with little cutomization and then fill your values.

3
Avatar
Discard
Darren
Author

Thanks Ajeet, I cannot see chart of accounting in the dashboard. Configuration steps is missing in V12.

See screenshot of V12

https://www.dropbox.com/s/1xjpy1gc6b0u4tu/Accounting Dah V12.png?dl=0

See a screenshot of V11 which has got it.

https://www.dropbox.com/s/mbsn98atap9n9xb/Screenshot 2019-09-28 06.59.10.png?dl=0

Can you explain : "In that case you can show that tree view with little cutomization and then fill your values."

Avatar
Ricardo Gross
Best Answer

Its possible to access initial Balances from the dashboard until it is disabled by the user: Initial setup


2
Avatar
Discard
Darren
Author

Thanks Ricardo

How can I reinable the Initial Setup on the dashboard. I think it was disabled accidentally

Ricardo Gross

That's a good question, Find the answer at: https://www.odoo.com/forum/help-1/question/v12-how-to-reactivate-the-accounting-onboarding-panel-156612

Thanks

Darren
Author

Thanks Ricardo, I’ll give that a try

Avatar
Julia van orsouw
Best Answer

You can get the configuration steps back by editing view 'account.setup.company.form' and remove the 'invisible =true' part of the field. 

\https://drive.google.com/open?id=1mvN2x0HlaT8KGBJ6rMygECaPtcCvRBdW

Then you can uncheck  the 'hide setup-bar' in the account configuration. the configuration steps are shown again on the dashboard and you can open and edit the chart of accounts with the initial balances, or open the initial balance move lines. 

Have you checked if you have an account more than once in your inital balance, maybe once with a debit value and once with a credit value? Or perhaps you have a debtor with a credit value? 

0
Avatar
Discard
Avatar
Jake Robinson
Best Answer

This particular error is caused by having a single line that has both a debit and a credit. This can happen at any time, not just during opening balances. 

If you are trying to import a line with say a credit of 10 and a debit of 6, you can either balance them off and keep the credit of 4, or have two lines, one with a credit of 10 and one with a debit of 6.

0
Avatar
Discard
Darren
Author

Thanks Jake, I have checked all lines and there is no line that has both a debit and credit on the same line

For each customer we add a line :

Account Partner Label Debit Credit

110000 Debtors Control Account (1100) Customer Name Bal B/Fwd 0.00 €1,162.97 €0.00

Then we add the balancing line:

304000 Change Over Suspense Account 0.00 €0.00 €1,162.97

We do that for each customer.

https://www.dropbox.com/s/yld7h7ts587k4un/Screenshot 2019-09-27 09.31.10.png?dl=0

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Setting up Accouting apps to start using Odoo
accounting balance
Avatar
Avatar
Avatar
5
Jun 18
6398
Errors in Accounting module
accounting error
Avatar
0
Jun 15
3633
Initial balance
balance initial
Avatar
Avatar
Avatar
2
Mar 15
11114
Error when posted opening entries and then making payment to supplier
accounting error
Avatar
Avatar
1
Mar 15
4550
Error account entry
accounting balance entry
Avatar
Avatar
1
Nov 24
13072
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now