Skip to Content
Menu
This question has been flagged

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

Avatar
Discard
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"


Avatar
Discard
Author

Where can i check decimal precision of pricelists and currencies?

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

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?

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.

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

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

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

See my amended answer for the decimal accuracy.

Author

Decimal accuracy is set to 2 digits for product price.

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.

Author

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

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.

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.

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.

Author

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

Author

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

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.

Author

Thanks anyway Ermin.

Related Posts Replies Views Activity
2
Apr 17
6450
1
Jan 24
9076
0
Apr 22
403
0
Aug 18
4500
4
May 17
2165