Skip to Content
This question has been flagged
relationalmany2one odoo openerpOdoo13.0
1 Atsakyti
6282 Rodiniai
Portretas
Sevate Software Services Pvt Ltd

Hi there

Using Odoo 13 CE, I built a custom module(x.cost) having several computed fields,

I am trying to update value from a computed field(u_cost) into product.template(cost_price) field

Here is the code

u_cost = fields.Float(string='my cost', compute='_ucost_calc', store=True)

@api.depends('total_cost', 'quantity')
def _ucost_calc(self):
    for a in self:
         a.u_cost = a.total_cost / a.quantity

I'm trying to update this 'u_cost' value into the Product.template 'cost_price' field.

have tried cr.execute, self.env and most of the methods, but unable to get the u_cost value into the product.template cost_price field...

Being new to python coding, would appreciate exact code for this

Thank you in advance

Portretas
Atmesti
Sehrish

If you are new to odoo and python development, have a look at this:

https://goo.gl/8HgnCF

Portretas
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Try the following code

from odoo import models, fields, api


class XCost(models.Model):

    _name = 'x.cost'

    _description = 'X Cost'


    total_cost = fields.Float(string='Total Cost')

    quantity = fields.Float(string='Quantity')

    u_cost = fields.Float(string='My Cost', compute='_ucost_calc', store=True)

    product_id = fields.Many2one('product.template', string='Product')



    @api.depends('total_cost', 'quantity')

    def _ucost_calc(self):

        for a in self:

            if a.quantity != 0:

                a.u_cost = a.total_cost / a.quantity

                # Assuming there's a Many2one field linking to the product template, e.g., product_id

                if a.product_id:

                    a.product_id.cost_price = a.u_cost

            else:

                a.u_cost = 0.0


Hope it helps

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Odoo 13. Don't close a wizard when Click a button Solved
Odoo13.0
Portretas
Portretas
Portretas
Portretas
4
geg. 24
14350
Permission error while user printing excel sheet report in odoo 13 Solved
Odoo13.0
Portretas
Portretas
1
bal. 24
4490
One2many field edited from Transient Model cannot be made empty.
Odoo13.0
Portretas
0
lapkr. 23
3167
Blank White Page After log in to Odoo13 Solved
Odoo13.0
Portretas
1
rugs. 23
3288
How can I translate Options in Selection.field? Solved
Odoo13.0
Portretas
Portretas
2
rugp. 23
6121