Odoo Help


[7.0] How can I set decimal precision to 6 for product prices but round actual invoices and sales orders to 2 decimals?

Tim Ingalls
on 4/25/13, 11:53 PM 5,531 views

For some of my products (telecom per-minute rates or USA IRS mileage reimbursement rates) I need to have the product price field extended to 3 or even up to 6 decimal digits. But I also need to round invoices, sales orders, and receipts to 2 digits. But changing the rounding and decimal precision for the Account module (Settings / Configuration / Accounting / Decimal precision on journal entries) (or via the currency config) changes both the product price shown in invoices, expense reports, etc., and the total amount of the invoice. Is there a way to temporarily or permanently make the whole invoice rounded to just 2 decimal digits? To most customers, having an invoice amount of $23.23458 would be confusing when they go to write their check to me. I would like the ability to have all lines in the invoice extended to whatever decimal precision the product is set up for, but still round the total for the invoice to amounts the currency can actually be paid in. How would I do that?

I have the same question and i think the only way is develop some fixture to do it. If you figure out other solution, please let me know. I will do the same ;)

Daniel Santos
on 5/22/13, 1:26 PM
Vincent Van Dyck
On 10/11/13, 6:32 AM

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 : https://accounts.openerp.com/forum/Help-1/question/1299

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

Thanks to https://accounts.openerp.com/forum/Help-1/question/6166

Perfect answer, quick and easy, and it works perfectly!

Kelli Bess
on 3/4/14, 1:26 PM

thanks for the answer . i change all but the product is 3 decimal but in the point of sale i can see 3 decimal but the third still 0 how can i fix that thanks in advance.

on 4/28/14, 6:05 PM

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

1 follower(s)


Asked: 4/25/13, 11:53 PM
Seen: 5531 times
Last updated: 3/16/15, 8:10 AM