Decimal Accuracy In Odoo || Decimal Precision In Odoo

[@muhammadduha1962]

what about the sum in the tree view? i have tried changing the decimal precision in the field and it works. but it doesn't work on the sum of tree views, the decimal precision of the sum is still 2 even though I have set it to 4. For your information I am using odoo 16. thx

[@rupeshdalvi3460]

Hello Odoo Mates, I changed the rounding factor to 6 and added some products to the cart on the website. But when I try to revert it back to 2, I get a user error message as below, "You cannot reduce the number of decimal places of a currency which has already been used to make accounting entries." Please suggest a way to revert it back.

[@OdooMates]

direcly update from db using query, also make sure that it doesnt make any issues

[@rupeshdalvi3460]

​@@OdooMates, should I update field rounding from a query?

[@OdooMates]

Yes

[@rupeshdalvi3460]

@@OdooMates Thank you!! It worked.

[@OdooMates]

@@rupeshdalvi3460 glad to hear it

[@zieddams]

Hi Odoo Mates, thanks for videos , i am asking about rounding tthe total of orders,quotations, invoices is this related and if not please give me a hint to find what i am looking for , have a nice day sir.

[@mnsmns84]

Hi Odoo Mates, thanks for videos I have same Rupesh Dalvi issue! where pleases I can found (db using query)? so Ican change it..

[@rafaelpriego481]

use the module Query Manager and: UPDATE res_currency SET decimal_places = 2 WHERE name = 'EUR';

[@daffaatalla6054]

mine doesn't work :'(

[@OdooMates]

Which scenario did you tried and Which is not working for you

[@daffaatalla6054]

@@OdooMates cuz i use monetary widget on xml

[@daffaatalla6054]

@@OdooMates when i remove that widget. it works