Skip to Content
Menu
This question has been flagged
2 Replies
1505 Views

i have model purchase.request the user enter product line in line_ids one2many field for  this model the user can create purchase order with products inserted in the line_ids in purchase.request model, the user can delete one line from order_lines in purchase,order.

how can i check if the line_ids from purchase.request model is existing in order_line in purchase.order model,

i have 3 model:

purchase.request.line linked with purchase.request using request_id.

and purchase.order linked with purchase.request using request_ids many2many field.

i try this code:

for rec in self:
purchase_orders = self.env['purchase.order'].search([('request_ids', 'in', rec.id)])
for order_line in purchase_orders.order_line:
for line in rec.line_ids:
if line.product_id in order_line:
rec.line_ids.purchase_state = 'rfq'

but i get below error:

TypeError: Mixing apples and oranges: product.product(1549,) in purchase.order.line(1570,)


Thanks .....

Avatar
Discard
Best Answer

Hi,

The error is beacuse you are trying to check if product_id is existing in order line object,

Replace your condition as below: 


Hope this will help you
Thank you

Avatar
Discard
Author

Thank you for replay but i am still getting error :
TypeError: Mixing apples and oranges: 617 in purchase.order.line(1683,)

Best Answer

Hello Loay elhaj,

You can used bellow example. 

Please find code in comment. 

I hope this will be helpful.

Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari 

Avatar
Discard

for rec in self:
purchase_orders = self.env['purchase.order'].search([('request_ids', 'in', rec.id)])
for order_line in purchase_orders.order_line:
for line in rec.line_ids:

# check condition for if purchase order line product and line product id.
if order_line.product_id == line.product_id.id:
line.purchase_state = 'rfq'

Or used billow code..

product = order_line.filtered(lambda x: x.product_id == line.product_id.id):
if product:
line.purchase_state = 'rfq'

Author

Thanks but its showing:
Comparing apples and oranges: product.product(351,) == 665

Related Posts Replies Views Activity
1
Jul 22
1163
0
Apr 22
1673
1
Dec 21
2751
1
Jan 21
5822
1
Dec 20
2447