We sell vouchers (programme, drink, etc) as tickets belonging to a performance set at the end of each year. Once a voucher is redeemed, it is marked as attended.
What we would like to be able to do is to find out when these vouchers were redeemed by reporting on when they were marked attended, but I haven't yet been able to figure out how to do that.
Can anyone point me in the right direction to achieve this or suggest another approach?
Julia
Julia,
It should be possible (assuming of course that you don’t have N-Scan and you’re doing this via Record Attendance) to query T_ORDER_SEAT_HIST to look for event_code = 22 (Attended) and the event_date of that occurring. If you’re using different price types for the different kinds of vouchers, you could filter further by those to find when people are redeeming what kinds of vouchers.
Hope this helps.