How to Filter child table

KanchanChauhan · November 16, 2016, 5:58am

Do something like this:

frappe/erpnext/blob/develop/erpnext/accounts/doctype/mode_of_payment/mode_of_payment.js#L4-L13


      
          frappe.ui.form.on('Mode of Payment', {
          	setup: function(frm) {
          		frm.set_query("default_account", "accounts", function(doc, cdt, cdn) {
          			let d = locals[cdt][cdn];
          			return {
          				filters: [
          					['Account', 'account_type', 'in', 'Bank, Cash, Receivable'],
          					['Account', 'is_group', '=', 0],
          					['Account', 'company', '=', d.company]
          				]