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

Question

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

Ken Starnes · Accepted 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.

Jenny Lloyd · 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!

Sage 50 Accounts

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

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING