We had a problem with Transcend last month where our batch numbers matched for a short time. During that week the first batch would post, the second would come back rejected as a dupe. Now we want to re-submit those batches. First though, we want to email our constituents to let them know that a small percentage of these sales did not go through and will be resubmitted and to call us with questions, etc. etc.
Web sales weren't affected.
Here's the question:
How can I pull a list of single ticket buyers for a specific date range where the moto ID is 102 or 101?
Hi, Nick—we had that issue a year ago. Fun!
If you don’t already know this, you will need to get new authorizations for credit card charges, as they are time-sensitive.
First, find out the payment method id’s for the credit cards in question:
select id from tr_payment_method
where merchant_id in (101,102)
Let’s say that the query above returned id’s 10,11,12,13, and you are looking for all patrons who had sales using those payment methods in December 2014:
select distinct customer_no from t_payment
where pmt_method in (10,11,12,13)
and pmt_dt between '12/1/2014' and '1/1/2015'
______________________________Lucie SpielerIT Development and Training Manager
Florida Grand Opera