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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

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

store compute computed-fields odoo18

2 الردود

1894 أدوات العرض

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

الكاتب

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

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Odoo does not update a stored value with a new value, it updates with the previous one store computed-fields	0 أغسطس 19	6370
compute issue تم الحل compute computed-fields odoo12.0	1 مايو 21	4456
Compute Value not returning to field. Odoo 11 CE تم الحل store compute odoo11community	2 يونيو 20	7122
Compute Field Store product store compute odoo 17	1 نوفمبر 24	1960
Studio compute field with condition compute studio computed-fields Studio	2 أغسطس 22	6281

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!