Purchase Order: strict items based on the supplier field

ERPNext Buying
2

Hi @bghayad ! Yes this is possible. Is your ERPNext self hosted? If it is, you may want to use something like this:

JS:

me.frm.set_query("item_code", "items", function(doc, cdt, cdn) {
	var d = locals[cdt][cdn];
	return {
		query: "app_name.def_name_here",
		filters:{
				'supplier': doc.supplier
		}
	}
});

Python Script:

def name_here(doctype, txt, searchfield, start, page_len, filters):

    return frappe.db.sql("""Select item_code from `tabItem` where default_supplier = %s""", (filters.get("supplier")))

Hope this helps!