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
I use the Invoice Detail report in the Finance folder. Check the parameters to make sure you are requesting the information you want.
Jean J. RiversControllerSan Jose Repertory Theatre101 Paseo de San AntonioSan Jose, CA 95113t: (408) 367-7286f: (408) 367-7237e: jeanr@sjrep.comwww.SJREP.com