How to add Account filter in Trial Balance Report

ERPNext
1

How can I add Account multiselect filter in trial balance report just like General Ledger report?

2

Hi @Atiq0629,

Please check the reference.

Thank You!

3

@NCP Thank you for your response. How do I effect it to the report? Can you please help me to do this filter effects on report which is in .py files code I guess.

4

not sure but test it and then apply it.

5

@NCP Thanks again. I already tested it. Not filtered. Its connected with this function get_accounts_with_children. Declared this function also. but now filtering too

6 
if filters.account:
		acc_data = frappe.db.get_value("Account", filters.account)
		additional_conditions += """ and account in (select name from `tabAccount`
			)""" % (
			acc_data
		)

Adding this code but show’s an error
TypeError: not all arguments converted during string formatting