Skip ke Konten
Pertanyaan ini telah diberikan tanda
decimalormrelated
6 Replies
18901 Tampilan
Avatar
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.


Avatar
Buang
Avatar
Axel Mendoza
Jawaban Terbai

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') )

Avatar
Buang
Lucas Huber
Penulis

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

Yenthe Van Ginneken (Mainframe Monkey)

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

Avatar
Nihal Mohamood KC
Jawaban Terbai

is the error solved?

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
How to add a related field Many2one in ORM? Diselesaikan
orm related
Avatar
Avatar
1
Jan 23
33356
why there is no module: decimal_precision in my odoo13 local host system ? how to manually install it? Diselesaikan
decimal
Avatar
Avatar
2
Nov 22
8817
ORM Relationship in Odoo 12
orm
Avatar
0
Sep 19
98
Can we control decimal accuracy per field or object in OpenERP?
decimal
Avatar
Avatar
1
Nov 18
6966
Sequence of calling any orm override method, if override is done in multiple custom module
orm
Avatar
Avatar
1
Jul 17
5005