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.
Based on the following, it seems as though Decimal is a more appropriate type to
use when dealing with currency and accounting data. Is there reason to be
concerned about rounding accuracy in Odoo?
Your statement is true.. decimal indeed is better for accounting and financial number representation
But whole odoo ( ex openerp, ex-ex tiny erp) orm is developed on float numbers, there is a number of tools developed to handle floating numbers in odoo /openerp (check openerp/tools/float_utils.py ...) and you just need to learn how to use it and will probably not get into problems with floating point number rounding accuracy... The reason for this decision is most likely overall speed...
Math functions with float numbers are way faster than with decimal...
On the other hand.. if you are so eager to use decimal numbers ( and once again i agree it is more precise ) .. you can try using tryton...
wich is a fork of tiny erp and wich is completly based on decimal numbers...
i will not post link to it on this forum, but our old friend google mingt know a site or two that will clearify this issue a bit more...
as for me... i'll stick to odoo even if it is based on float numbers...
you just need to be aware what you are doing...
p.s. i have encountered problem with acuracy and number represenation a few times....
and found an easy and fast workaround : i let postgres do the math instead of python... (just write correct sql)
it is fast and accurate... (with no floating point problems) :)
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 10/30/14, 10:54 AM|
|Seen: 2408 times|
|Last updated: 3/16/15, 8:10 AM|