Trial Balance or any other default Report - Add custom Button

Helio_Jesus · March 9, 2020, 1:04pm

Hi all,
I have searched the groups for a small extend on existing Query Report / Script Report …
I would like to add a Custom Button (Extend) to Trial Balance or any other Script Report .
To achieve (Exportar XLS) this i had to create a local Trial Balance (copy original) and add the button but i wonder if there is no other way like in hooks “query_js = …/trial_balance.js” to extend existing like we do with Docktype and other JS files.

Helio_Jesus · January 8, 2021, 7:31pm

Hi all,
Does anyone knows how to extend JS Report?
Need to add and extra button on Accounts Receivable.

Thanks.

tmatteson · July 22, 2022, 11:24pm

There should be a better resource for this, but here’s some breadcrumbs:

github.com

frappe/erpnext/blob/c5a16a999cb3c19861cd156f76f902e50cd9346e/erpnext/public/js/financial_statements.js#L60


      
          		let fiscal_year = frappe.defaults.get_user_default("fiscal_year")
          
          
		frappe.model.with_doc("Fiscal Year", fiscal_year, function(r) {
          			var fy = frappe.model.get_doc("Fiscal Year", fiscal_year);
          			frappe.query_report.set_filter_value({
          				period_start_date: fy.year_start_date,
          				period_end_date: fy.year_end_date
          			});
          		});
          
          
		const views_menu = report.page.add_custom_button_group(__('Financial Statements'));
          
          
		report.page.add_custom_menu_item(views_menu, __("Balance Sheet"), function() {
          			var filters = report.get_values();
          			frappe.set_route('query-report', 'Balance Sheet', {company: filters.company});
          		});
          
          
		report.page.add_custom_menu_item(views_menu, __("Profit and Loss"), function() {
          			var filters = report.get_values();
          			frappe.set_route('query-report', 'Profit and Loss Statement', {company: filters.company});
          		});