Skip to Content
This question has been flagged
sale.order.linesale.order
1 Reply
6273 Views
Avatar
Mostafa Alaa

i want to know how many stockable product in the order


Avatar
Discard
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
Discard
Mostafa Alaa
Author

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 Views Activity
Merge Same Item in Sale Order Line Solved
sale.order.line sale.order
Avatar
Avatar
Avatar
2
Jan 24
5547
Combine inline editing with more detailed form view
sale.order.line sale.order
Avatar
0
Jun 23
2111
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
3469
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
2651
Track visibility in a field sale.order.line model
sale.order.line sale.order trackvisibility
Avatar
Avatar
Avatar
2
Jul 25
3920