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

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

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Issue with Displaying Partners (many2many) in Purchase Orders When Using Computed Fields (Odoo 18)

store compute computed-fields odoo18

2 Odpowiedzi

1895 Widoki

Vasilis Zartilas

Dear All,

I am trying to add a field in purchases to display all the Partners from the Sale Orders that are linked to the Purchase.

I have the following code, and I am facing an issue:

When I do not use “store=True“ the function works correctly and displays the partners. However, in order to save the Partners in Purchases that are not linked to any sale order (since I have a compute method in my field), I set “store=True“ but then the first case does not work.

In other words, when I do not use store, the function works correctly and the customer is displayed. However, when I set store, the function does not work, and the related partners do not appear, although the new partners are saved correctly in the Purchase.

What am I missing, and how can I fix this?

class PurchaseOrder(models.Model):
    _inherit = 'purchase.order'

    name_ids = fields.Many2many(comodel_name='res.partner',compute='_compute_customer_names',
        string="Customers",store=True)

    def _compute_customer_names(self):
        for purchase in self:
            sale_order_ids = purchase._get_sale_orders()
            for sale_order in sale_order_ids:
                purchase.name_ids = sale_order.partner_id

Waleed Ali Mohsen

Hello,

if you want to store the field in DB with store =True result you must to to specify the dependencies on the compute method with the decorator depends()

Thanks.

Vasilis Zartilas

Autor

I had tried using 'depends()' as well, but it still didn't work.

Waleed Ali Mohsen

The value of a computed field usually depends on the values of other fields so you need to specify these fields in @api.depends() so if any of these fields in changed then the computed field will be recomputed again.

Waleed Ali Mohsen

If you added the property store=True to the field which already created, It will not be recomputed. Try to test it with creating a new purchase order after adding @api.depends()

Cybrosys Techno Solutions Pvt.Ltd

Hi,

If you want to store a computed field in the database, the field must depend on one or more other fields (via @api.depends).

Try the following code

class PurchaseOrder(models.Model):
    _inherit = 'purchase.order'

    name_ids = fields.Many2many(comodel_name='res.partner',compute='_compute_customer_names',
        string="Customers",store=True)

    @api.depends('order_line.sale_order_id')
    def _compute_customer_names(self):
        for purchase in self:
            sale_order_ids = purchase._get_sale_orders()
            if sale_order_ids:
                for sale_order in sale_order_ids:
                    purchase.name_ids = sale_order.partner_id
            else:
                purchase.name_ids = None

Hope it helps

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
Odoo does not update a stored value with a new value, it updates with the previous one store computed-fields	0 sie 19	6370
compute issue Rozwiązane compute computed-fields odoo12.0	1 maj 21	4456
Compute Value not returning to field. Odoo 11 CE Rozwiązane store compute odoo11community	2 cze 20	7123
Compute Field Store product store compute odoo 17	1 lis 24	1960
Studio compute field with condition compute studio computed-fields Studio	2 sie 22	6282

To pytanie dostało ostrzeżenie

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