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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Odoo (v11) ValueError: Expected singleton: product.product(10, 11, 12, 13)

urgent @api.depends singletonissue odoov11 @api.multi

1 Vastaa

5319 Näkymät

Abdullah

hey! i've following line of code which is fetching value of prod_min_qty from stock.warehouse.orderpoint to product.template but it is giving me this singleton error. Can you suggest what should i use with it like @api.one,@api.multi,@api.depends and why? i'll be very thankful.

def _get_min_qty(self):
    for prod_tml in self:
        product = self.env['product.product'].search([('product_tmpl_id', '=', prod_tml.id)])
        product_reorder = self.env['stock.warehouse.orderpoint'].search([('product_id', '=', product.id)], limit=1)
        if product_reorder:
            prod_tml.min_qty = product_reorder.product_min_qty

Niyas Raphy (Walnut Software Solutions)

Paras vastaus

Hi,

Update the code like this,

def _get_min_qty(self):
    for prod_tml in self:
        product = self.env['product.product'].search([('product_tmpl_id', '=', prod_tml.id)])
        for pro in product:
            product_reorder = self.env['stock.warehouse.orderpoint'].search([('product_id', '=', pro.id)], limit=1)
            if product_reorder:
                prod_tml.min_qty = product_reorder.product_min_qty

def _get_min_qty(self):
    for prod_tml in self:
        product = self.env['product.product'].search([('product_tmpl_id', '=', prod_tml.id)], limit=1)
        product_reorder = self.env['stock.warehouse.orderpoint'].search([('product_id', '=', product.id)], limit=1)
        if product_reorder:
            prod_tml.min_qty = product_reorder.product_min_qty

Thanks

Abdullah

Tekijä

Hey man Thank you so much. It is working now. Can you kindly explain me this ? Also i am using @api.multi with it so it is fine right?

Niyas Raphy (Walnut Software Solutions)

This product = self.env['product.product'].search([('product_tmpl_id', '=', prod_tml.id)]) line is returning multiple values, so you have to iterate over a for loop to get single rec

Abdullah

Tekijä

Ok Thank you soo much <3

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Display a list of record in one field from order lines (V11) Ratkaistu many2one urgent related odoov11 Niyas	3 heinäk. 22	8112
Odoo(v11) Creation of asset based on quantity in invoice lines Ratkaistu create asset invoicing urgent odoov11	2 tammik. 20	3921
odoo(V11) Adding Bar code functionality in Assets Management Ratkaistu asset barcode urgent barcodes odoov11	1 tammik. 20	6215
Odoo(V11) web.basic_layout leaves empty space on the top of the page Ratkaistu templates reporting urgent odoov11 web.basic	2 jouluk. 19	9164
Odoo (v11) Fetch data of one field from one model to another Ratkaistu urgent related related_fields odoov11 Inventory	3 jouluk. 19	5539

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!