How can I filter two links

ERPNext Accounting
, , ,
1

I have a sales invoice Doctype which have two links, the first link is Company and the other is Customer.
What I want is when I select a company from Company list and I go to customer link the list will shown only the customer under the chosen company.

2

Hello Brother @Hardik_Gadesha ,
Do you know?

3

@Nada-86 apply filter

4

not working with me

frappe.ui.form.on('Sales Invoice', {
   onload: function(frm) {
        
        cur_frm.set_query("customer", function () 
                {
                        return {
                                filters: { 'company': 'ALMA Safety Company' }
                 };
        });
     }
});
5

also I tried to switch between the customer and company

6 
frappe.ui.form.on('Sales Invoice', {
   onload: function(frm) {
        
        cur_frm.set_query('company', 'ALMA SAFETY', function () 
                {
                        return {
                                filters: { 'customer': 'ALMA SAFETY' }
                };
        });
    }
});

2024-04-166
2024-04-1661588×801 34.3 KB

7

Hi @Nada-86,

Please apply it:

frappe.ui.form.on("Sales Invoice", {
    refresh:function(frm) {
        frm.set_query("customer", function() {
            return {
                "filters": {
                    'company': frm.doc.company
                }
            };
        });
    }
});

Reference documentation: Overriding Link Query By Custom Script

Forum search: Search results for 'set_query order:latest' - Frappe Forum

8

not working :smiling_face_with_tear:

9

It’s version 12, so I don’t know if it worked or not.

But it worked in v13, v14 and v15

Please check it.

image
image2880×1544 324 KB

10

I tried on v13 and become like that

image
image1922×1030 96.2 KB

11

Oh :roll_eyes:

Please check your field name and also set the filter.

Please read the documentation that I provided in the above post.

12

@NCP
Yeah I did but I don’t know why it not working :cry:

13

Hello @NCP ,

I want to ask you if I can apply on item?
it mean when I chose company the item will only shown under the name of company.

14

@NCP

I have this code

frappe.ui.form.on("Sales Invoice", {
 	refresh(frm) {
 	    cur_frm.cscript.onload = function(frm) {
 	        cur_frm.set_query("item_code", "items", function() {
 	            return {
			filters: {"item_group": "Grove Fitting"}
		};
	});
}}
});
15

Please check it.

16

Yeah thanks, I saw this but what I mean is filter depends on company name.

Do I need to use if and if else condition

17

Try it your way!

18

I need help :cry: