Validation in items group


In Quotation/Sale Order, when I click on the items to add the item to my order, it saw me all the products including the services, products, consumable etc.

But I want to validate that item by their groups. Means that only Products items will be displayed in the list of items when I select the items from the sale order.

Can you suggest me the solution?

Thank You.

write a custom query for the items link field.

There is an another way that I found to solve this problem.

In item form view, there is a field named as ‘is_sales_item’. In my service type product, this checkbox was checked. I just unchecked in that field and I got the output without any coding.