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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to domain product variant based on pricelist in sale order

sale.order.line sale.order.form Odoo13.0

1 Odpowiedz

6803 Widoki

Hoang

Hi everyone,

I'm trying to domain product_id in sale.order.line based on pricelist in sale.order form.

I'm using a dynamic domain for it but it's not working. Here is my code in sale.order:

@api.onchange('pricelist_id')

def onchange_pricelist_id(self):

product_id = self.order_line.product_id

product_ids = []

if self.pricelist_id:

for rec in self.pricelist_id.item_ids:

product_ids.append(rec.id)

return {'domain': {'product_id': [('id', 'in', product_ids)]}}

I'm also trying to use name_get() in product.product:

def name_get(self):

if self._context.get('temp'):

return super(ProductProduct, self).name_get()

product_list = []

pricelist = self.env['product.pricelist'].browse(self._context.get('pricelist'))

if pricelist:

for rec in pricelist.item_ids:

if rec.applied_on == '0_product_variant':

product_list.append(rec.product_id.id)

if product_list:

self = self.browse(product_list)

result = super(ProductProduct, self).name_get()

return result

but it throws :

Error:
Odoo Server Error

Traceback (most recent call last):
File "/opt/odoo13/odoo/odoo/loglevels.py", line 92, in ustr
return text_type(value)
File "/opt/odoo13/odoo/odoo/tools/func.py", line 150, in __str__
def __str__(self): return str(self._value)
File "/opt/odoo13/odoo/odoo/tools/func.py", line 137, in _value
value = self._func(*self._args, **self._kwargs)
File "/opt/odoo13/odoo/odoo/tools/func.py", line 167, in __getitem__
def __getitem__(self, key): return self._value[key]
KeyError: 36

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/opt/odoo13/odoo/odoo/http.py", line 619, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo13/odoo/odoo/http.py", line 309, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/opt/odoo13/odoo/odoo/tools/pycompat.py", line 14, in reraise
raise value
File "/opt/odoo13/odoo/odoo/http.py", line 678, in dispatch
return self._json_response(result)
File "/opt/odoo13/odoo/odoo/http.py", line 607, in _json_response
body = json.dumps(response, default=date_utils.json_default)
File "/usr/lib/python3.7/json/__init__.py", line 238, in dumps
**kw).encode(obj)
File "/usr/lib/python3.7/json/encoder.py", line 199, in encode
chunks = self.iterencode(o, _one_shot=True)
File "/usr/lib/python3.7/json/encoder.py", line 257, in iterencode
return _iterencode(o, 0)
File "/opt/odoo13/odoo/odoo/tools/date_utils.py", line 211, in json_default
return ustr(obj)
File "/opt/odoo13/odoo/odoo/loglevels.py", line 94, in ustr
raise UnicodeError('unable to convert %r' % (value,))
UnicodeError: unable to convert <odoo.tools.func.lazy object at 0x7fbec8aa6900>

Is anyone have solutions for this? Please help me.

Best regards

Sylvain Michel Ratsarafahatra

Najlepsza odpowiedź

Hi,

I suggest you to add only a dynamic domain depending of pricelist selected when you choose a product in the order lines.

e.g.:

class SaleOrderLine(models.Model):
    _inherit = "sale.order.line"

    @api.onchange('product_id')
    def onchange_product_id(self):
        if self.order_id.pricelist_id:
            product_template_ids = self.env['product.template'].search([]).filtered(
                lambda x: self.order_id.pricelist_id.id in x.item_ids.mapped('pricelist_id').ids)
            product_ids = self.env['product.product'].search([('product_tmpl_id', 'in', product_template_ids.ids)])
            return {'domain': {'product_id': [('id', 'in', product_ids.ids)]}}

Best regards!

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Odoo 13: How do you switch from inline adding of products to the detail window? Rozwiązane sale.order.line Odoo13.0	2 sie 20	3338
Section and Note is not adding in order line sale.order.line Odoo13.0	0 lut 20	4582
Tax Calculation in Sales Module(Sales.Order.Line ) Rozwiązane sale.order.line sale.order.form	2 paź 16	9597
Modificación Lista de Productos en una Orden de Venta Rozwiązane sale.order.line sale.order.form sale.order	2 kwi 25	1535
Sales Order From Excel Sheets Rozwiązane sales sale.order.line sale.order.form	1 lis 24	2630

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!