How to Filter Department Based on Company (Purchase Order)

1

Hello,

I added a custom field to purchase order to query department on my purchase order doctype and I have multiple companies in the site. I want to filter department based on selected company and set permissions to only allow department selection if permitted. I created a custom script for the filter based on company:

frm.set_query(“department”, function(doc) {
return {
filters: {
‘company’: frm.doc.company
}
};
});

but I am getting this error:

eval code
eval@[native code]
setup@https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:636871
setup@https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:683414
refresh@https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:686383
load@https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:590926
https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:590649
https://erp.octo5.co/assets/js/desk.min.js?ver=1564608065.0:1:138043
initializePromise@[native code]
Promise@[native code]
with_doc@https://erp.octo5.co/assets/js/desk.min.js?ver=1564608065.0:1:137806
show_doc@https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:590582
https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:589930
with_doctype@https://erp.octo5.co/assets/js/desk.min.js?ver=1564608065.0:1:137478
make@https://erp.octo5.co/assets/js/form.min.js?ver=1564608065.0:1:589782
show@https://erp.octo5.co/assets/js/desk.min.js?ver=1564608065.0:1:320058
route@https://erp.octo5.co/assets/js/desk.min.js?ver=1564608065.0:1:83953
https://erp.octo5.co/assets/js/desk.min.js?ver=1564608065.0:1:86334
dispatch@https://erp.octo5.co/assets/frappe/js/lib/jquery/jquery.min.js:3:7542
handle@https://erp.octo5.co/assets/frappe/js/lib/jquery/jquery.min.js:3:5625

Can anyone tell me what I might be doing wrong?

2

As it turns out, the standard filter script doesn’t apply directly and this is what gave me result:

frappe.ui.form.on(‘Purchase Order’, {

onload(frm) {
	frm.set_query('department', () => {
        return {
            filters: {
                company: frm.doc.company
            }
        }
    });
}

})