Odoo Help


Decimal precision "Product Price": 4 digits --> use OOE to show only 2 digits for unit price

on 6/18/13, 6:40 AM 7,833 views

I am using 4 digits decimal precision for the Product Price, because otherwise some prices don't add up properly under our purchase orders. However, it would be preferable if I could only show 2 digits behind the "," seperator for invoices and sale orders.

Is it possible to either:

  1. Use the Open Office Editor to change the way the Product Price field is displayed, and make it leave out the last two characters of the value in this field. Or filter out the last two digits behind the "," seperator.
  2. Split up the decimal precision in "Product Price Purchase" and "Product Price Sale". Under "Decimal Precision" there is no option to select values, and "Product Price" is just entered as plain text. I don't know if other values can be used here?

I found <para style="terp_default_Right_9">[[ formatLang(l.price_unit ) ]]</para> in the .rml file of print_invoice, under Account.

I also saw other fields such as: <para style="terp_default_Centre_9">[[ formatLang(l.discount, dp='Account') ]] </para>

I figure "dp='Account'" means it is dependant on the decimal precision under "Account". I formated price_unit as: <para style="terp_default_Centre_9">[[ formatLang(l.discount, dp='Account') ]] </para>

Next I updated my module list, and the Account module - but sadly it is not working, and still showing 4 digits behind the seperator. Under Decimal Precision --> Account I have 2 digits. I guess I need to make a change elsewhere as well.

Vincent Van Dyck
On 10/11/13, 6:39 AM

Leave accounting/global to 2 decimal and change product decimal to 4 according to this :

In the User Access rights, enable "Technical Features". Go to Settings > Technical > Database Structure > Decimal Accuracy > Product Price

A more detailed answer can be found here : help.openerp.com/question/1299/how-to-change-products-cost-decimal-precision/

Don't forget to restart the server for the change to take effect.

Thanks to help.openerp.com/question/6166/change-product-price-precision/ (had to remove link because of insufficient karma)

I'm not sure about other versions of Odoo,but you don't have to restart if you have Odoo 9.0

Alaa Alnajjar
on 6/5/16, 8:03 AM

About This Community

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 6/18/13, 6:40 AM
Seen: 7833 times
Last updated: 7/31/15, 4:55 AM