Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
5 Odpowiedzi
5172 Widoki
Awatar
Impressiv

Okay, This is very strange. I can't revert back to 2 decimals of my default currency. 


Recently I have changed the decimal of default currency from 2 to 3 (shown in pic). But now I am trying to revert back it says.  " You won't be able to reduce the number of decimal places of a currency which has already been used to make accounting entries."


I have tried within my Technical Settings>Data Structure>Decimal Accuracy (shown in pic)


These all options are default ones, So I tried creating a new one but it doesn't work.


Isn't there any simple way to revert back to 2 decimals?


Note: I am using Enterprise version 14 with Studio installed.

Awatar
Odrzuć
Awatar
Malay Khamar (Serpent Consulting Services Pvt. Ltd.)
Najlepsza odpowiedź

Hi, 

This will happened when you increased the decimal place in the currency. It is ok when you decrease it. 

You need to update the "Rounding Factor" Field of the currency by database side using query. Decimal will be changed based on that. 

Hope it will help you. 



Awatar
Odrzuć
Awatar
Ayman Alkurdi
Najlepsza odpowiedź

Hi all,


Please let us know how you solve or force the system to reduce decimal accuracy in currency to 2??

Awatar
Odrzuć
Awatar
Thomas DROUOT (Skillreso)
Najlepsza odpowiedź

Hi everyone,

  1. The simpliest for people on Odoo Saas without an access to the db : just add and field amount there:
    1. Got Settings -> Technical -> Database Structure -> Decimal Accuracy
    2. Then add "Amount" as field with 2-digit options : all the amounts in the db will be show with 2 digits and you keep the rounding accuracy with more than 2-digits. It is what the users want usually.
  3. You have to request on command line with SQL (not recommanded on production db !!! ). Check on local or in a staging branch if no constraints are broken. 

Just go into the shell and enter the postgres prompt with 

psql

Select the currency you want to revert back to 2-digitsmode with :

select * from res_currency where id={ID DEVISE}; //to check we are 	​	​	​	​	​	​	​	​	​	​	​ //working on the right 	​	​	​	​	​	​	​	​	​	​   //currency
UPDATE res_currency SET rounding = 0.01 WHERE id = {ID DEVISE};


Hope it helps !

Thomas

Awatar
Odrzuć
Awatar
Nicolás Calvo Hernández
Najlepsza odpowiedź

Hi,

I have the same issue with Oddo16 cloud. 

Malay, Could I kindly ask you to write the appropriate query to get it back to 2 decimals?

Thanks in advance.

Awatar
Odrzuć
Malay Khamar (Serpent Consulting Services Pvt. Ltd.)

UPDATE res_currency SET rounding = 0.01 WHERE id = id_of_currency;

Awatar
Michael Ramb
Najlepsza odpowiedź

i have the same issue with Odoo16.
Is there any way to get it back to 2 decimals?

Awatar
Odrzuć