Drill Down In Report Designer - Customer Invoice Disputes to drill down to Customer Invoice

SOLVED

In Report Designer I am editing the report called 'Customer Invoice Disputes' and I'd like to drill-down on the Invoice Reference to show the actual invoice. I am able to locate the drill-down function on the properties menu, but unable to find the right instruction to give to the report (to link the invoice reference to show the actual invoice when the curser is on the invoice reference).

Any ideas that may help are welcome!

Thank you

Jenny

  • +1
    verified answer

    I've had a look at this and it's not possible AFAIK because drill down effectively runs another report  based on the parameters passed. There's no way of linking directly to an invoice.

    It sounds a good idea if you have lots of disputes / large customer base.

    Have you tried the Chase Debt option on the Customer list display. It might help you  It has Disputes as a filter.

  • +1 in reply to Ken Starnes
    verified answer

    That's really useful info - thank you!

    This idea stemmed from the existing 'Aged Debtors Analysis (Drillable)' Report which does enable a drill-down to an invoice rather than a report - I was hoping to replicate this in a custom designed 'Customer Invoice Disputes (Drillable)' report. It's unfortunate that this function is not available in report designer as I'd use it in all kinds of custom reports. Perhaps I will suggest it to Sage?

    I will most certainly look into the Chase Debt option on the Customer list display (Thank you also for the screenshot to help me find it!) - I can see that the Chase Debt screen displays a column to indicate disputed invoices so this is also helpful.

    Thanks very much Ken!