Se rendre au contenu
Cette question a été signalée
purchase_orderenvcomputed-fieldspurchase.order.line
1 Répondre
5332 Vues
Avatar
Abdel-Rahman Megahed

I am currntly running Odoo v13 Community Edition. I am trying to edit the purchase order model by inheriting the model to my custom created model. I want to get the currency_rate field by using the env stuff. I still do not fully understand how it works so I tried to calculate the field (by using the code below) and I got a ZeroDivisionError (below the code)

I need help if anyone can tell me how do I search the env for the purchase order tied with the orderline and why do I get the ZeroDivisionError.

Thank you in advance


Here is the code:

class PurchOrderLine(models.Model):

    _inherit = 'purchase.order.line'

    x_price_unit = fields.Float(readonly=True, compute="calc_unit_p", string='Unit Price in EGP', store=False)

    x_sub_tot = fields.Float(readonly=True, compute="calc_sub_t", string='Subtotal in EGP', store=False)


    @api.depends('price_unit')

    def calc_unit_p(self):

        for p in self:

            po = p.env['purchase.order'].search([])

            p.x_price_unit = p.price_unit / po.currency_rate


    @api.depends('price_subtotal')

    def calc_sub_t(self):

        for p in self:

            if 

            po = p.env['purchase.order'].search([])

            p.x_sub_tot = p.price_subtotal / po.currency_rate


And this is the Full Error:

Error:

Odoo Server Error


Traceback (most recent call last):

  File "/opt/odoo/odoo/odoo/api.py", line 745, in get

    value = self._data[field][record._ids[0]]

KeyError: <NewId 0x7f9aff5a7490>


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/opt/odoo/odoo/odoo/fields.py", line 1000, in __get__

    value = env.cache.get(record, self)

  File "/opt/odoo/odoo/odoo/api.py", line 751, in get

    raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: ('purchase.order.line(<NewId 0x7f9aff5a7490>,).x_price_unit', None)


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/opt/odoo/odoo/odoo/http.py", line 624, in _handle_exception

    return super(JsonRequest, self)._handle_exception(exception)

  File "/opt/odoo/odoo/odoo/http.py", line 310, in _handle_exception

    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

  File "/opt/odoo/odoo/odoo/tools/pycompat.py", line 14, in reraise

    raise value

  File "/opt/odoo/odoo/odoo/http.py", line 669, in dispatch

    result = self._call_function(**self.params)

  File "/opt/odoo/odoo/odoo/http.py", line 350, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/opt/odoo/odoo/odoo/service/model.py", line 94, in wrapper

    return f(dbname, *args, **kwargs)

  File "/opt/odoo/odoo/odoo/http.py", line 339, in checked_call

    result = self.endpoint(*a, **kw)

  File "/opt/odoo/odoo/odoo/http.py", line 915, in __call__

    return self.method(*args, **kw)

  File "/opt/odoo/odoo/odoo/http.py", line 515, in response_wrap

    response = f(*args, **kw)

  File "/opt/odoo/odoo/addons/web/controllers/main.py", line 1322, in call_kw

    return self._call_kw(model, method, args, kwargs)

  File "/opt/odoo/odoo/addons/web/controllers/main.py", line 1314, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/opt/odoo/odoo/odoo/api.py", line 387, in call_kw

    result = _call_kw_multi(method, model, args, kwargs)

  File "/opt/odoo/odoo/odoo/api.py", line 374, in _call_kw_multi

    result = method(recs, *args, **kwargs)

  File "/opt/odoo/odoo/odoo/models.py", line 6149, in onchange

    value = record[name]

  File "/opt/odoo/odoo/odoo/models.py", line 5684, in __getitem__

    return self._fields[key].__get__(self, type(self))

  File "/opt/odoo/odoo/odoo/fields.py", line 1024, in __get__

    self.compute_value(recs)

  File "/opt/odoo/odoo/odoo/fields.py", line 1109, in compute_value

    records._compute_field_value(self)

  File "/opt/odoo/odoo/odoo/models.py", line 3966, in _compute_field_value

    getattr(self, field.compute)()

  File "/opt/odoo/odoo/cust_addons/invoice/invoice.py", line 32, in calc_unit_p

    p.x_price_unit = p.price_unit / po.currency_rate

ZeroDivisionError: float division by zero

Avatar
Ignorer
Avatar
Niyas Raphy (Walnut Software Solutions)
Meilleure réponse

Hi,

You are getting zero division error because the value in po.currency_rate used in division is 0. And as per the math, we cannot divide a number by 0. So you have to add a if condition to ensure that po.currency_rate have non zero value. Also rest of the code seems to have issue(check and correct it per logic/need).

@api.depends('price_unit')
def calc_unit_p(self):
for p in self:
 po = p.env['purchase.order'].search([], limit=1)
if po.currency_rate != 0:
 p.x_price_unit = p.price_unit / po.currency_rate
else:
 p.x_price_unit = p.price_unit

Thanks

Avatar
Ignorer
Abdel-Rahman Megahed
Auteur

How can the currency rate value be 0 when it is displayed as another value? maybe the p.env line is wrong?

I cannot tell because I do not understand it that well. If it was wrong, how can I modify it so that the purchase order that the purchase order line is part of becomes stored in po?

Thank you for your answer

Publications associées Réponses Vues Activité
How can I customize purchase order report and purchase order form view Résolu
purchase_order purchase.order.line
Avatar
Avatar
1
sept. 21
8143
Need Help in Computing a Field Value in Purchase Order
purchase_order compute purchase.order.line
Avatar
2
oct. 20
3841
By Selecting Product, Vendor's Name will Appear
res.partner purchase_order vendor purchase.order.line
Avatar
0
janv. 24
2049
How do I get a field from another Model
purchase purchase_order compute order.line purchase.order.line
Avatar
Avatar
1
janv. 23
6859
How to create compute fields in purchase order line Résolu
python xml purchase_order v14 purchase.order.line
Avatar
Avatar
Avatar
2
avr. 22
5015