Odoo thousands separator

How to define Odoo thousands separator?

Accountants are used to the thousands separator e.g. 100000.00 EUR is represented as 100,000.00.
The setup of the thousands separator is located under:
Settings > Translations > Languages.

Odoo thousands separator

For each language, you can set a different separator format.

3 options modify the format of a number:

Separator format: number of digits between separators
Decimal Separator: character displayed before the decimals
Thousands Separator: the character displayed at each separation

The correct form for a separator between each 3 digits whatever the number of digits is: [3,0]

You have to logout and login again to see the change.

Odoo is a modern Software For Smart Businesses.
Boost your sales, step up productivity and manage all day-to-day activities. Fully integrated, simple and mobile.
More about odoo

That’s all folks!


Change Odoo decimal precision configuration

Change Odoo decimal precision configuration in few easy steps.

1.) Make sure your techincal features are turned on (Go to Settings/Users/admin)

Change Odoo decimal precision configuration

2.) Change accounting settings (Go to Settings/Configuration/Accounting)
Change Decimal precision on journal entries to 4.

Change Odoo decimal precision configuration

Change Rounding factor to 0.000100 in your Default Company Currency Setting (Go to Settings/Configuration/Accounting/Default company currency).

3.) Change Decimal Accuracy setting (Go to Settings/Database Structure/Decimal Accuracy)
Change value of Product Price and Account to 4.

Change Odoo decimal precision configuration

And the final result is Quote or Sales Order with 4 digits.

Final result


Run Odoo on port 80 instead of 8069

Setup your ubuntu server and run Odoo on port 80 instead of 8069

1.) Connect with ssh client to your Ubuntu server
2.) Use your favorite text editor (vim, nano…) to edit /etc/rc.local file

sudo nano /etc/rc.local

3.) Paste this into /etc/rc.local file

iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-port 8069

4.) Reboot your Ubuntu server to see effect

sudo reboot

5.) Access Odoo on port 80

That’s all folks!


Delete emails from Exim queue

A little reminder of how to delete emails from Exim queue if cPanel queue manager does not work.

cd /var/spool/exim
find input -type f -exec rm -rf {} \;
find msglog -type f -exec rm -rf {} \;
service exim restart