How to create a list of people who purchased tickets for a specific GL code

(Last updated on: October 13, 2015)

Perhaps you want to send an email blast to everyone who bought tickets to a show listed in a specific GL code. There’s an easy way to do this.

Click on Reports | Other reports | Export email | Edit the query tab.

Enter the query like this:

select showname, mainsale.abbrev, customer.first, customer.last, customer.email from master
left join gl_codes on master.gl_code = gl_codes.gl_codes_id
left join mainsale using(master_id)
left join customer using( customer_id)
where gl_codes.gl_code='NAME OF GL CODE'
group by customer_id
order by customer.last, customer.first

Click on Export list and you will get the results.

matthew

Note: This query can be expanded in many ways. For instance, you can ask for more data or you can limit the records returned to a more stringent condition.

This entry was posted in Desktop Software, Wintix5 and tagged . Bookmark the permalink.

Leave a Reply