ValueError: <class 'ValueError'>: "Expected singleton: sale.order.line(<NewId ref='virtual_117'>, <NewId ref='virtual_131'>)"

sale.order.line sale.order

1 Vastaa

5369 Näkymät

Testingsl, Renato Paolo Espinoza Terrones

Odoo v15

I create a "Margin 2 [x_studio_margen_2]" field at "sale.order" that is supposed to be the sum of every field "Total Margin 2 [x_studio_total_margen_2" at "sale.order.line".

When I add one product, everything is ok, but the problem comes when I add a second product.

I though that it would work but it release an "Expected singleton" error

total = 0
for record in self:
total += record.order_line.x_studio_total_margen_2
record['x_studio_margen_2'] = tot

I've read another post with same error but not the same case and I haven't fix it.

Sudhir Arya (ERP Harbor Consulting Services)

When you access the "order_line" One2many field, it gives you the number of recordsets (in your case 2 recordsets because you have added 2nd product also).

So you need to use a loop on "order_line" to access every line.

Try the following code:

for record in self:
    total = 0
    for line in record.order_line:
        total += line.x_studio_total_margen_2
    record['x_studio_margen_2'] = total

I am sure this will work as you expect.

Testingsl, Renato Paolo Espinoza Terrones

Tekijä

Thanks a lot!!

That's true, it is now working but another problem happens.

"x_studio_margen_2" is not being updating as "margin" default field does.

For example:

A product with a cost by default 2€ but without a default price_unit that appears at the order line with a "x_studio_total_margen_2" = -2€, so "x_studio_margen_2" now is -2€.

So if I add the price_unit of it product as 3€ it's supposed to have a "x_studio_margen_2" of 1€ but the operation that it does is "-2€ + 1€= so the result is "x_studio_margen_2" = -1€.

Another example:

If I delete the product, "x_studio_margen_2" is still with the -2€, so if I add a product with 3€ of margin ("x_studio_total_margen_2)", now the "x_studio_margen_2" will be -2 + 3 = 1€.

I've tried to only use the formula of "x_studio_total_margen_2" while number is more than 0, but it doesn't work when I delete any product.

Thanks again!

Sudhir Arya (ERP Harbor Consulting Services)

I would suggest to accept this and create another post.

Testingsl, Renato Paolo Espinoza Terrones

Tekijä

I agree.

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
Merge Same Item in Sale Order Line Ratkaistu sale.order.line sale.order	2 tammik. 24	7705
Combine inline editing with more detailed form view sale.order.line sale.order	0 kesäk. 23	3926
How to update a custom field as "Margin" default from sale.order does, when some product of sale.order.line is updated/deleted. sale.order.line sale.order	0 huhtik. 22	4196
How to count stockable product in orderline in Quotations Ratkaistu sale.order.line sale.order	1 huhtik. 19	7877
Odoo 19 - how does rounding work on Sales Order Lines? The Total isn't the sum of the order line totals Ratkaistu sale sale.order.line sale.order	1 marrask. 25	1895

Tämä kysymys on merkitty

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