How to include values from two doctype in report filters

ERPNext Reports
1

Can someone please help me to include or display values from two doctypes (Supplier and Customer) in a single filters option in report.
“filters”: [
{
“fieldname”:“party”,
“label”: __(“Party”),
“fieldtype”: “Select”,
“get_options”: function() {
frappe.call({
method: ‘erpnext.accounts.general_ledger.get_parties’,
args: {
“inter_company”: 1,
},
callback: function(r) {
if(r.message)
{
console.log(r.message);
options = [];
for (i = 0; i < r.message.length; i++) {
options[i]= r.message[i];
}
}
}
});
return options;
}
},

2

You can develop your custom api that get all the data from custom and supplier.

3

Have you done before. I am not able to do. I would appreciate if you can provide some guide

4

Why not two different filters ?

5

Because we have some common customer and supplier and I want to display receivable and payable . So I want to display it in a single filter

6

Yes, You can use dynamic link as well.

7

I will be grateful if you can share me some examples or guide

8

Example of Dynamic Link:

Invoice Type and Invoice Number

You can use customer and supplier as type:

9

I am not able to understand what you are saying

10

There is one field type “Dynamic Link”, you can use it for that.