Adding customer contact on sales order

ERPNext Selling/CRM
, ,
1

Hi, I have added a custom field called “customer contact” in the sales order form. I want this field to have options of all the contacts linked to the customer selected which are stored in the CRM > Contact. how do I achieve this ?

2

Hi @Akshay_Chordia,

That for, Please apply the client script.

frappe.ui.form.on("Sales Order", {
    refresh: function(frm) {
        frm.set_query("customer_contact", function() {
            return {
                filters: [
                    ["Dynamic Link","link_doctype", "=", "Customer"],
                    ["Dynamic Link","link_name", "=", frm.doc.customer]
                ]
            };
        });
    }
});

Then reload and check it.

image
image1822×901 108 KB

Thank You!

3

Hi, Thanks a lot for replying. But where do I add this script

4

Hi @Akshay_Chordia,

Please go to the Client Script Doctype and then add it.

Please check it.

image
image1295×528 51.2 KB

Thank You!

1 Like
5

Thanks a lot for your help