Enabling Currency Field Links in Script Reports

Anisha_Jain · May 19, 2024, 1:46pm

Hello Everyone,

I’ve created a script report that includes a currency field. I want to enable users to click on the currency field and be redirected to another report that applies the same filter. Could anyone help me with how to achieve this?

Thank you!

NCP · May 20, 2024, 4:58am

Please check the base report,

github.com

frappe/erpnext/blob/develop/erpnext/accounts/report/accounts_payable/accounts_payable.js#L176-L179


      
          		report.page.add_inner_button(__("Accounts Payable Summary"), function () {
          			var filters = report.get_values();
          			frappe.set_route("query-report", "Accounts Payable Summary", { company: filters.company });
          		});

action will be performed on the button.

Anisha_Jain · May 22, 2024, 12:28pm

Hi,
Thank you for your response to my question. However, the solution provided doesn’t quite address what I’m looking for. Let me clarify my requirements further:

I have a column in my Python configuration, defined as follows:

{
            'label': _('Invoice Amount'),
            'fieldtype': 'Currency',
            'fieldname': 'invoice_amount',
            'width': 150,
        },

What I need is for this column to be interactive, such that when a user clicks on any cell in this “Invoice Amount” column, it triggers a redirection to another report.

Screenshot from 2024-05-22 17-53-29

Thanks

Anisha_Jain · May 27, 2024, 10:09am

Can anyone help me with this issue? I still haven’t found any solution