Odoo Help


How to remove decimals in invoice ? [Closed]

Anne-Sylvie Burri
on 5/6/13, 11:28 AM 4,443 views

The Question has been closed

Ray Carnes
on 05/08/2013 13:55:21

Hi everybody !

I try to remove decimals for "Quantity" and "Discount" in invoice.

I already change in settings/Database Structure/Decimal Accuracy but nothing changes in my invoice.

Someone could help me ?

Many thanks in advance.



Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 5/6/13, 2:12 PM

Reports should be using the get_digits function to determine how many decimals to display.

In version 7.0, Invoices call this function to return the decimal accuracy of the Account.

Check the digits of the Account record under Settings -> Technical -> Database Structure -> Decimal Accuracy

Thanks for your answer. If I can't modify the decimal accuracy "Account" beacuse of links with other modules. Do you know in wich file is it possible to modify this function ?

J.-M. Burri - Bureau ing.-conseils informatique, Anne-Sylvie Burri
on 5/7/13, 7:04 AM

account_print_invoice.rml in addons/account/report - just replace the function with the number of digits you want to use. Once you get this working, I suggest you create your own RML file and own report, so it will not be reverted if you upgrade OpenERP.

Ray Carnes
on 5/7/13, 2:20 PM

Thank you very much it works perfectly :-) I gonna follow your advice and create my own report.

J.-M. Burri - Bureau ing.-conseils informatique, Anne-Sylvie Burri
on 5/8/13, 5:21 AM

Sudhir Arya (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 




Sudhir Arya
ERP Harbor Consulting Services
Sudhir Arya (ERP Harbor Consulting Services)
On 5/6/13, 11:35 AM

Make sure you have made changes in Product Unit of Measure for Quantity and Discount for Discount in Decimal Accuracy and set Digits=0.

Thanks for your answer. I already changed this parameters but no results in my invoice.

J.-M. Burri - Bureau ing.-conseils informatique, Anne-Sylvie Burri
on 5/6/13, 11:38 AM

Same thing is working for me.

Sudhir Arya (ERP Harbor Consulting Services)
on 5/6/13, 11:40 AM

It changes in the lines form in OpenERP but not in the report.

J.-M. Burri - Bureau ing.-conseils informatique, Anne-Sylvie Burri
on 5/6/13, 12:16 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

0 follower(s)


Asked: 5/6/13, 11:28 AM
Seen: 4443 times
Last updated: 3/16/15, 8:10 AM