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

accumulated error from product lines in taxes

Subscribe

Get notified when there's activity on this post

This question has been flagged
pricetaxesprecisiondecimalsodoo9
1 Reply
5257 Views
Avatar
Borja

Hello,


I'm using Odoo 9 in a debian server and i faced a serious problem because in my country invoices resulting from my instance are illegal. 

It seems odoo 9 uses 2 decimal precision for prices. But, in case total price of line is not "xx.x0" (where x is any digit) it applies a round to only one decimal. For example, for a price 19.65, odoo is rounding to 19,70 before calculating taxes. And its doing this for each line, so the cumulative sum of all this results is a completely wrong total price (with taxes). 

I think there is an option to change this behaviour. Can somebody help?

Thanks

0
Avatar
Discard
Avatar
Ermin Trevisan
Best Answer

What you describe is not true for an Odoo standard set up. If your system behaves like that, you have misconfigured it.

Please check your settings concerning:

- Tax rounding method (globally or per line), see "Accountings/Settings/Chart of Account/Configure your company data"

- decimal precision of your pricelists

- decimal precision of your currencies

- decimal accuracy "Settings/Technical/Database structure/Decimal Accuracy"


0
Avatar
Discard
Borja
Author

Where can i check decimal precision of pricelists and currencies?

Ermin Trevisan

You have to activate the developer mode to see the options.

Borja
Author

I found these options. I changed tax rounding method to globally, but its ignoring me.

If i change precision to 00,001 odoo shows prices with 3 decimals.

Why its ignoring me?

Ermin Trevisan

There is another setting, which I have amended to my answer, decimal accuracy, check this also. However, somebody obviously did change the settings in your system because out of the box Odoo works properly with 2 digits and proper rounding.

Ermin Trevisan

Or did you install a module such as "Swedish rounding"?

Borja
Author

I didnt install an other country module. This is spanish mod. I have developer options actived but can't find decimal accuracy. Only rounding factor.

Thanks

Ermin Trevisan

"Swedish rounding" is not a country module, that's a special rounding (5 cents rounding).

Ermin Trevisan

See my amended answer for the decimal accuracy.

Borja
Author

Decimal accuracy is set to 2 digits for product price.

Ermin Trevisan

Then I do not have any more ideas than just completely updating your Odoo instance. Either you or somebody else did manipulate the original settings either manually or be installing a module.

Borja
Author

Where can i check if sweedish rounding is active??? Thanks

Ermin Trevisan

You must have installed a module like https://www.odoo.com/apps/modules/8.0/smile_decimal_precision/ in order to have swedish rounding, or have a rounding factor of 0.1 in your currency definition.

Borja
Author

i have not installes any modules for change decimal precision. Also, rounding factor is set to 0.01 and rounding for taxes is set to globally and not "per line". The option is set and saved. I reboot the server and didnt change anything. Its ignoring me.

Its Odoo9.

Ermin Trevisan

You have messed up your instance, don't ask me how and why. It is properly working for thousands of installations. Look at your logs if there's anything suspicious, else try to update your instance and see if it works, otherwise I would recommend you a new clean install.

Borja
Author

its a new install, its tunning for only a month aprox. I dont understand. Its installed over debian 8.

Borja
Author

how can i try to update the instance without losing data?

Ermin Trevisan

Sorry, but this goes already far beyond my capacities. Do a system image, make a backup of the database, do the update (be sure you know how to do that), hope and pray.

Borja
Author

Thanks anyway Ermin.

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
Change no of decimals in POS?
precision decimals
Avatar
Avatar
2
Apr 17
8289
How to do the manual tax adjustment in the Invoice form?
accounting taxes odoo9
Avatar
0
Oct 25
6488
What is the different between lst_price and list_price in product_template? Solved
product price odoo9
Avatar
Avatar
1
Jan 24
12080
Display both tax excluded and included in product form
product price taxes
Avatar
0
Apr 22
1520
[V10] Access all taxes included price in Point of Sale
price taxes point_of_sale
Avatar
4
May 17
3378
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