Aide

0

accumulated error from product lines in taxes

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

Avatar
Annuler
1 Réponse
0
Avatar
Ermin Trevisan
Meilleure réponse

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"


18 Commentaires
Avatar
Annuler
Avatar
Borja
-

Where can i check decimal precision of pricelists and currencies?

Avatar
Ermin Trevisan
-

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

Avatar
Borja
-

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?

Avatar
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.

Avatar
Ermin Trevisan
-

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

Avatar
Borja
-

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

Avatar
Ermin Trevisan
-

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

Avatar
Ermin Trevisan
-

See my amended answer for the decimal accuracy.

Avatar
Borja
-

Decimal accuracy is set to 2 digits for product price.

Avatar
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.

Avatar
Borja
-

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

Avatar
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.

Avatar
Borja
-

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.

Avatar
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.

Avatar
Borja
-

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

Avatar
Borja
-

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

Avatar
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.

Avatar
Borja
-

Thanks anyway Ermin.