Hi all,
Is there a way to get a list of all open/unpaid invoices sitting in the system? I’m not entirely sure what tables I’m playing with, so either SQL queries or reports would be most helpful!
Thanks,
Adrienne Steer
Adrienne Steer | Patron Services Manager
Kitchener-Waterloo Symphony | kwsymphony.caConrad Centre for the Performing Arts36 King St W | Kitchener ON N2G 1A3
519.745.4711 x 278
asteer@kwsymphony.on.ca
2012/13 Season now on sale
Make Time for Great Music!
KWS Patron Services: 519.745.4711 | 888.745.4717 Subscribe Now
The invoice detail report in the finance folder should do the trick. There is an option to choose not only the invoice type, but "due" invoices as well.