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?
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:
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 '11/20/2014' and '12/22/2014'
and a.pmt_method in (14,15,16,17)
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
where a.pmt_dt between '12/1/2014' and '1/1/2015'
______________________________Lucie Spieler
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!