Skip to Content
This question has been flagged
urgent@api.dependssingletonissueodoov11@api.multi
1 Atsakyti
5318 Rodiniai
Portretas
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
Portretas
Atmesti
Portretas
Niyas Raphy (Walnut Software Solutions)
Best Answer

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

or

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

Portretas
Atmesti
Abdullah
Autorius

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
Autorius

Ok Thank you soo much <3

Related Posts Replies Rodiniai Veikla
Display a list of record in one field from order lines (V11) Solved
many2one urgent related odoov11 Niyas
Portretas
Portretas
3
liep. 22
8112
Odoo(v11) Creation of asset based on quantity in invoice lines Solved
create asset invoicing urgent odoov11
Portretas
Portretas
2
saus. 20
3921
odoo(V11) Adding Bar code functionality in Assets Management Solved
asset barcode urgent barcodes odoov11
Portretas
Portretas
1
saus. 20
6215
Odoo(V11) web.basic_layout leaves empty space on the top of the page Solved
templates reporting urgent odoov11 web.basic
Portretas
Portretas
2
gruod. 19
9164
Odoo (v11) Fetch data of one field from one model to another Solved
urgent related related_fields odoov11 Inventory
Portretas
Portretas
3
gruod. 19
5539