Skip to Content
This question has been flagged
sale.order.linesale.order
1 Odpoveď
6801 Zobrazenia
Avatar
Mostafa Alaa

i want to know how many stockable product in the order


Avatar
Zrušiť
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

If you are looking to display/get the no of the stock-able product in the sale order, you can add a compute field in the sale order model and compute the count into it.

stock_product_count = fields.Integer(string='Count', compute='get_pro_count')


@api.multi
def get_pro_count(self):
    for rec in self:
        count = 0
        for line in rec.order_line:
            if line.product_id.type == 'product':
                count += 1
        rec.stock_product_count = count


Thanks

Avatar
Zrušiť
Mostafa Alaa
Autor

raise ValueError("Expected singleton: %s" % self)

ValueError: Expected singleton: sale.order(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)

Niyas Raphy (Walnut Software Solutions)

Hope you have added the field in tree view also, you can update the code like this,

@api.multi

def get_pro_count(self):

for rec in self:

count = 0

for line in rec.order_line:

if line.product_id.type == 'product':

count += 1

rec.stock_product_count = count

Related Posts Replies Zobrazenia Aktivita
Merge Same Item in Sale Order Line Solved
sale.order.line sale.order
Avatar
Avatar
Avatar
2
jan 24
6224
Combine inline editing with more detailed form view
sale.order.line sale.order
Avatar
0
jún 23
2721
ValueError: <class 'ValueError'>: "Expected singleton: sale.order.line(<NewId ref='virtual_117'>, <NewId ref='virtual_131'>)"
sale.order.line sale.order
Avatar
Avatar
1
dec 22
4157
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
Avatar
0
apr 22
3196
Odoo 19 - how does rounding work on Sales Order Lines? The Total isn't the sum of the order line totals Solved
sale sale.order.line sale.order
Avatar
Avatar
1
nov 25
236