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
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
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!
select distinct a.customer_no, a.pmt_dt, a.pmt_amt, a.pmt_method, b.description
from T_PAYMENT a
join TR_PAYMENT_METHOD b on b.id = a.pmt_method
where a.pmt_dt between '12/1/2014' and '1/1/2015'
and a.pmt_method in (14,15,16,17)
______________________________Lucie Spieler
Thanks again.
Got time for one more? Now I need to pull just the same thing limited to the merchant ID of 101. I need only the walk ins, not mail order/phone order and not web.
When I do this:
where a.pmt_dt between '11/20/2014' and '12/22/2014'
and b.merchant_id = 101
I get no results. Save me.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Lucie SpielerSent: Friday, February 6, 2015 5:23 PMTo: Nick TorresSubject: RE: [Tessitura Finance Forum] Figuring out who bought what when and how
Hi, Nick:
It may be that you need to put a single quote around 101: The definition of the field is as char(3), meaning that it’s looking for a string value there, not a number. Having said that, I get results, even with no single quotes.
Lucie