Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
4 Vastaukset
1943 Näkymät

Hi, 

How i can force odoo 18 to reduce decimal accuracy from 3 to 2.

It was changed from 2 to 3 but later the accountant request to return it to 2.

I need your support urgent please.

Avatar
Hylkää
Paras vastaus

Go to Settings > General Settings, scroll down to the bottom of the page and Activate the developer mode. Then go to Settings > Technical > Database Structure > Decimal Accuracy and update the required setting.

Avatar
Hylkää
Paras vastaus

Hi, 


You can change the decimal precision from the frontend.


- Settings > Tehinacal > Decimal Accuracy




Hope it helps

Avatar
Hylkää
Tekijä Paras vastaus

Dear Paresh Wagh

I tried this way Settings > General Settings, scroll down to the bottom of the page and Activate the developer mode. Then go to Settings > Technical > Database Structure > Decimal Accuracy, but found that i cant Change from 3 to 2, only accepting if i want increase the decimal accuracy.

Can you provide another way if possible, thanks for your support 

Avatar
Hylkää

Unfortunately, this is the only way to do it reliably.

Paras vastaus

Where Odoo Stores Decimal Precision

Odoo uses the model: decimal.precision (or in recent versions, decimal.accuracy or just via res.config.settings depending on the field).

For example:

  • Product Unit of Measure → Product Unit of Measure Precision
  • Accounting (Price, Amounts) → Account precision
  • Currency Rounding → Decimal Places on currency

🔧 Step-by-Step: Change Decimal Precision (back to 2 digits)

Option 1: Update Decimal Precision in UI

  1. Activate Developer Mode
    • Go to Settings → Activate the Developer Mode (⚙️ icon > "Activate Developer Mode")
  2. Go to Technical → Decimal Accuracy
    • Navigate to Settings > Technical > Database Structure > Decimal Accuracy
    • Look for entries like:
      • Product Unit of Measure
      • Account
      • Product Price
      • etc.
  3. Edit the relevant entries
    • Change from 3 to 2
    • Save

✅ That’s it! All relevant views and calculations will now show 2 digits instead of 3.

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
0
heinäk. 25
717
0
toukok. 25
965
1
tammik. 25
1301
1
kesäk. 25
824
2
kesäk. 25
904