How to count stockable product in orderline in Quotations

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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Project
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How to count stockable product in orderline in Quotations

sale.order.line sale.order

1 Vastaa

6267 Näkymät

Mostafa Alaa

i want to know how many stockable product in the order

Niyas Raphy (Walnut Software Solutions)

Paras vastaus

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

Mostafa Alaa

Tekijä

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

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	5530
Combine inline editing with more detailed form view sale.order.line sale.order	0 kesäk. 23	2107
ValueError: <class 'ValueError'>: "Expected singleton: sale.order.line(<NewId ref='virtual_117'>, <NewId ref='virtual_131'>)" sale.order.line sale.order	1 jouluk. 22	3465
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	2645
Track visibility in a field sale.order.line model sale.order.line sale.order trackvisibility	2 heinäk. 25	3912

Tämä kysymys on merkitty

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