Fetch Supplier in Purchase invoice from more then one field

[Francisco_Buendia]

The thing is that at that time result that the filter seems that doesn’t work with any field…

Filter by Item Group

I think you are not able to change query for Customer, because there exists query for Customer in ERPNext code and your custom query doesn’t work. Please check it

Work on item_group

Filter by Item Group

I finally made it!!! frappe.ui.form.on("Quotation", "refresh", function(frm) {cur_frm.fields_dict['items'].grid.get_field('item_code').get_query = function(doc) { return { filters: [[ 'Item', 'item_group', '=', doc.tipo_de_orden ]] } }; });

But the same script didn’t work with customer_group

Filter by Item Group

Hi again! Today I’m trying to filter the Customer based on Customer Group, using the same script, but it doesn’t make any changes. frappe.ui.form.on("Quotation", "refresh", function(frm) { cur_frm.fields_dict['customer'].get_query = function(doc, cdt, cdn) { return { filters:[ ['customer_group', '=', 'doc.tipo_de_orden'] ] } } }); Also tried… frappe.ui.form.on("Quotation", "refresh", function(frm) { cur_frm.set_query("customer", function() { …

Hope you find a better solution.