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

ValueError: Expected singleton

sale.order odoo10 singeltonerror

2 Vastaukset

32085 Näkymät

Dishon Kadoh

I have added an extra field which relates to the project.project model in the sale order

class InheritSaleOrder(models.Model):
    _inherit = 'sale.order'

    project_name = fields.Many2one(comodel_name="project.project", string="Project Name", required=False)

i also have a customized module for project budget which is supposed to automatically pick the all the products in the sale order line relating to a specific order using onchange here is my function

@api.multi
@api.onchange('project_id')
def change_project_id(self):
    #get quotation id
    quotation_id = self.project_id

    if(quotation_id!=""):

        #get quotation info
        quotation_list = self.env['sale.order'].search([('project_name','=',quotation_id.id)])
        data = {}
        #loop through quotation lines
        new_lines = self.env['project.budget.line']
        for line in quotation_list.order_line: #line 83
            ##populate items
            data = {
                'product_id': line.product_id.id,
                'product_categ_id':line.product_categ_id,
                'product_qty':line.product_uom_qty ,
                'product_uom' : line.product_uom.id ,
                'price_unit': line.product_id.standard_price #TODO - Use the pricelist to retrieve item prices
            }
            new_line = new_lines.new(data) #adding new items to the model
            new_lines += new_line
        #self.update('reference_bq' : value)
        self.budget_line_items += new_lines # set budget lines
        return {}
    #return vals

    # on change update lines

however when i try to run my code i get a singleton error i dont know what am missing kindly assist

File "/home/dishon/Desktop/odoo-dev/todo_app/project_budget/models/models.py", line 83, in change_project_id
    for line in quotation_list.order_line:
  File "/home/dishon/Desktop/odoo-dev/odoo/odoo/fields.py", line 909, in __get__
    record.ensure_one()
  File "/home/dishon/Desktop/odoo-dev/odoo/odoo/models.py", line 4848, in ensure_one
    raise ValueError("Expected singleton: %s" % self)
ValueError: Expected singleton: sale.order(23, 22, 21)

Sehrish

Read Odoo Customization: https://learnopenerp.tumblr.com/

Caret IT Solutions Pvt. Ltd.

Paras vastaus

Hi,

This error occurred because you are trying to access multiple records list.

The error is from this line:

for line in quotation_list.order_line:

because quotation_list has sale.order(23, 22, 21) records so you have to put one more for loop in quotation_list

So your code should be:

@api.multi

@api.onchange('project_id')

def change_project_id(self):

#get quotation id

quotation_id = self.project_id

if(quotation_id!=""):

#get quotation info

quotation_list = self.env['sale.order'].search([('project_name','=',quotation_id.id)])

data = {}

#loop through quotation lines

new_lines = self.env['project.budget.line']

for quotation in quotation_list: #line 83

for line in quotation.order_line:

##populate items

data = {

'product_id': line.product_id.id,

'product_categ_id':line.product_categ_id,

'product_qty':line.product_uom_qty ,

'product_uom' : line.product_uom.id ,

'price_unit': line.product_id.standard_price #TODO - Use the pricelist to retrieve item prices

}

new_line = new_lines.new(data) #adding new items to the model

new_lines += new_line

#self.update('reference_bq' : value)

self.budget_line_items += new_lines # set budget lines

return {}

#return vals

# on change update lines

Dishon Kadoh

Tekijä

Thanks its working now

Mitul Shingala

hello

in your code, at somewhere you get the multiple records and from that you try access the field.

for eg. into your code you get multiple records into the variable quotation_list. and into the for loop you directly

access the order_line. that's why you get an error.

try like below code:

for quotation in quotation_list:

for line in quotation.order_line: # made this change in line 83 and add above for loop into your code.

# your code here

##populate items

I hope may this will helps you.

Dishon Kadoh

Tekijä

Thanks Mitul Shingala its working right

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
Confirm Sale and skip Payment - net_amount is getting added to prev_outstanding_balance sale.order odoo10	0 lokak. 22	2674
sale.order.warehouse_id change doesn´t affect warehouse_id in stock.picking, stock.move, stock.quant models stock sale.order odoo10	0 toukok. 20	4464
Customer pricelist in odoo 10 sale.order pricelist odoo10	3 heinäk. 18	6327
Adding a new field to sale order lines in sale orders (quotes/sale orders) Ratkaistu qweb sale.order.line sale.order odoo10	1 heinäk. 18	8500
How to return sales order view action on Quotation view screen for odoo 10 sale.order return odoo odoo10	0 toukok. 18	5975

Tämä kysymys on merkitty

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