Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
Guewen works at Camptocamp as an Odoo developer since 2010. He is the lead developer of the Odoo Connector framework and the Magento Connector. He is a delegate member of the OCA, a committer and an active contributor to the OCA projects.
The setup of the thousands separator is located under: Settings > Translations > Languages.
For each language, you can set a different separator format (and few other formatting options like the dates format or the text direction).
3 options modify the format of a number:
If you use [3,3,3,-1], the number 1232345.01 will be displayed 1,232,345.01. However, the number 1237891232345.01 will be displayed 1237'891'232'345.01.
The -1 at the end of the list means 'stop the separation'. The value 0 can be used to mean 'repeat the last group at infinite'.
So the correct form for a separator between each 3 digits whatever the number of digits is: [3, 0].
Reference: Olivier Dony's comment
i have made these changes but got js error , undefine seprator bcz i think by mistake i have do this way [,3,3,3, -1] now please tell me how to resolve it please help me
Under Settings > Languages > Your favorite language you will find two fields: thousands separator which is , in English by default, but to make it work you also need to set the Separator Format. [3,3,3,-1] will make sure e.g. that 1232345.01 EUR appears as 1,232,345.01 EUR. The tooltip of the Separator Format will show you that the separator is fully customizable. Apparently, some countries prefer 4 instead of 3 digits for separation.
Please see my response, the format [3,3,3,-1] is not correct when the number of digits is > 12.
I found that by doing exactly this, a number such as 108,253 is changed automatically into 108 when creating accounting entries. I used [3,3,3,-1], "," as decimal and "." as thousands separator.
That is because I used the . as decimal and , as thousands separator and you do the opposite. The precision of your accounting entries depends on the Decimal Precision in the Technical Features.
i have used by mistake [,3,3,3, -1] now please tell me how to resolve it
For those who are looking format prices in emails templates, this worked for me: (You should get prices like: 9,000.00 )
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.
RegisterAccess to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it now
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
But it dont work with e-mail template! REFERENCES Order number: SO008 Order total: 7315.0 EUR