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?
Lucie, thank you so much. That did the trick. Fantastic.
One more question, where do I see what each of those 14,15,16,17 match up to
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Lucie SpielerSent: Friday, February 6, 2015 4:25 PMTo: Nick TorresSubject: RE: [Tessitura Finance Forum] Figuring out who bought what when and how
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
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!