ValueError: ValueError singleton

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

ValueError: ValueError singleton

4 Replies

2246 Views

valueerror singleton

Ruturaj Chavda

Hello,

In below code, product_id is my Many2many field of product1 table and price is a field of that table When i select more than one product in Many2many field, I get this error : ValueError: Expected singleton:
product1.product1(2, 4) . can anyone help me.

Thanks in advance.

Code:

total = fields.Float("Total",readonly=True,compute="count")

product_id = fields.Many2many('product1.product1',string="Products")

@api.onchange('product_id')

def count(self):

for i in self:

i.total = i.product_id.price

Cybrosys Techno Solutions Pvt.Ltd

Thanks, Mitul Singala it works.

Mitul Shingala

Best Answer

Hello,

in your code product_id is many2many field. and into method line: i.product_id.price, you get the multiple product ids. that's why you get singleton error.make below change into your code:

@api.onchange('product_id')
def count(self):
    for i in self:
        total = 0
        for prod in i.product_id:
            total += prod.price
        i.total = total

Dhaval Desai

Hi Ruturaj,

ValueError: Expected singleton: product1.product1(2, 4) it means product_id return multiple records you can not directly assign values.

Example:

@api.onchange('product_id')
def count(self):
    for i in self:
        total = 0
        for p in i.product_id:
            total += p.price
        i.total = total
Thank You.

Ruturaj Chavda

Author

This question has been flagged