Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
enterpriselocalizationi18nformattinglanaguageodoo16
4 Svar
593 Vyer
Avatar
YEKINI MARCEL

In Odoo 16 Enterprise, for language Portuguese (pt_PT), we set the Thousands Separator to "." in Settings → Languages, but number formatting is not affected (e.g. 1000000 is not shown as 1.000.000).

 We have already verified that the language is active and assigned to the user.

Any idea why this is ignored?

Avatar
Avbryt
Avatar
Kunjan Patel
Bästa svar
Hello IEKINI MARCEL MENDES FERNNANDES,
I hope you are doing well

Fix: Settings → Languages → Portuguese (pt_PT):
- Decimal Separator = ,
- Thousands Separator = .
- Separator Format = [3,0] ← the missing piece

Then refresh/relogin (formatting is ormcached, cleared on write). [3,0] → 1.000.000.

I hope this information helps you

Thanks & Regards,
Kunjan Patel
Avatar
Avbryt
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bästa svar
Hi,

In Odoo 16, the Thousands Separator configured on the language record is not always used by the web client. Number formatting is often determined by the locale definitions (Babel/CLDR) associated with the user's language (pt_PT).

Make sure:

    Ensure the user's language is set to Portuguese (Portugal) - pt_PT and not another Portuguese variant such as pt_BR.
    Log out and log back in after changing the language settings, and clear the browser cache.
    Check whether the issue occurs everywhere or only in specific views/reports. Some reports and custom widgets may format numbers independently.
    Verify that no custom modules or JavaScript customizations are overriding number formatting.


If the issue persists, it is likely that Odoo is using the locale's predefined formatting rather than the manually configured separator values, which may require customization to change.


Hope it helps

Avatar
Avbryt
Avatar
Zehntech Technologies Inc.
Bästa svar

Hello, 

In Odoo 16, the thousands separator defined in the language settings is generally used for number formatting, but some views and widgets may rely on localization rules or client-side formatting that do not immediately reflect changes made in the language configuration.

A few things worth checking:

  • Clear browser cache and reload assets after modifying the language settings.
  • Verify whether the issue occurs in all modules/views or only in specific fields.
  • Confirm that the user is actually using the pt_PT language and not another Portuguese variant.
  • Check whether any localization or custom modules are overriding the default formatting behavior.

If the issue persists in standard Odoo without customizations, it may be related to the localization implementation for pt_PT in Odoo 16 and could require further investigation.

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

Avatar
Avbryt
Avatar
YEKINI MARCEL
Författare Bästa svar

Hello Kunjan Patel,

Thank you. Your solution worked perfectly. Setting Separator Format = [3,0] fixed the issue.

Avatar
Avbryt
Relaterade inlägg Svar Vyer Verksamhet
POS UOM different issue Löst
pos enterprise odoo16
Avatar
1
aug. 24
2713
How to move Odoo 16 community to Odoo 17 enterprise
migration enterprise odoo17 odoo16
Avatar
Avatar
Avatar
2
aug. 24
3092
Error when using module "Documents" in a language other than English
error enterprise documents odoo16
Avatar
0
juni 24
3231
Spread Sheet Total Figure Issue
inventory enterprise valuation spreadsheets odoo16
Avatar
Avatar
1
juni 24
3390
Create A Pop-Up Windows with Odoo Studio
enterprise odoo Studio OdooStudio odoo16
Avatar
0
juni 25
2268