Decimal precision in ORM

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Decimal precision in ORM

decimal orm related

6 Odpowiedzi

17938 Widoki

Lucas Huber

I would like to include a related field from res.currency in a ORM model, but can't find any information how to deal with decimal precision in ORM.

exchange_rate = fields.Float('res.currency.rate', 
        'Exchange Rate', related='currency_id.rate',
        readonly=True)

When I open a view with the fields I get this error:

 File "/opt/odoo/odoo-server/openerp/tools/float_utils.py", line 29, in _float_check_precision

    return 10 ** -precision_digits

TypeError: bad operand type for unary -: 'str'

Would be glad to know a workaround to solve this problem.

Axel Mendoza

Najlepsza odpowiedź

as docs saids in

https://www.odoo.com/documentation/8.0/reference/orm.html

class openerp.fields.Float(string=None, digits=None, **kwargs) 
The precision digits are given by the attribute
        Parameters digits -- a pair (total, decimal), or a function taking a database cursor and returning a pair (total, decimal)

Your definition could be changed to this:

exchange_rate = fields.Float('res.currency.rate', 'Exchange Rate', related='currency_id.rate', readonly=True, digits=(16,2))

or you could use a managed decimal precision already defined like

import openerp.addons.decimal_precision as dp
...
exchange_rate = fields.Float('res.currency.rate', 'Exchange Rate', related='currency_id.rate', readonly=True, digits=dp.get_precision('Account') )

Lucas Huber

Autor

Thank you Axel, Your solution will probably work only with not related fields. In my case I get with both solutions a "duplicate value for keyword arguments "digits"" Error.

Axel Mendoza

related fields are function fields and they need pretty much all the required attributes/arguments for field definition than normal fields, because when it gets calculated the field continue as the normal field type float and needs the digits param

Axel Mendoza

solved?

Yenthe Van Ginneken (Mainframe Monkey)

Marked it as solved as this is a good answer that works fine. ;)

Nihal Mohamood KC

is the error solved?

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to add a related field Many2one in ORM? Rozwiązane orm related	1 sty 23	32445
why there is no module: decimal_precision in my odoo13 local host system ? how to manually install it? Rozwiązane decimal	2 lis 22	7862
ORM Relationship in Odoo 12 orm	0 wrz 19	98
Can we control decimal accuracy per field or object in OpenERP? decimal	1 lis 18	6213
Sequence of calling any orm override method, if override is done in multiple custom module orm	1 lip 17	4176

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!