Does anyone know, or has anyone been able to search for a patron by the check number paid on their order? We are attempting to track down an order, and would like to be able to look it up with the check number.
Hi Audrey,
This isn't possible from the constituent search screen. But depending on what details you know about this transaction and what access levels you have you should be able to find it with minimal effort.
If you know the day (or approximate day) of the order you could pull up the batches in batch administrator and look at the payments screen. The check no is stored there and that column can be sorted to help find a specific one in numerical order.
If you have someone on staff with SQL skills and access to the database it's probably fastest that way to track it down. Again, this would depend on how much information you know about that transaction so you can narrow it down. For example, if I know the check no and that the payment happened sometime in the first two weeks of May I would search for it using a query like this:
select distinct customer_no, check_name, check_no, batch_no from t_paymentwhere check_no = #### --insert check number hereand pmt_dt between '2015-05-01' and '2015-05-15' --insert date range here
There may be other ways to search as well that I'm not thinking of at the moment. But in case no one else chimes in, I hope one of these will prove helpful!
This procedure has saved me many times in the past nine years. Update for the check number and the date range.
use impresario
select customer_no,
sum(pmt_amt) as chkamt,
check_no
from t_payment where check_no = 4037 -- customer's check #
and pmt_dt between '2015-02-21 00:01' and '2015-05-15 23:59' -- date payment should have been processed
group by customer_no, check_no
order by check_no asc
Lee Schlosser
IT Manager
Florida Studio Theatre, Inc.
1241 North Palm Avenue
Sarasota, FL 34236
Phone: 941-366-9017 ext 365
Fax: 941-955-4137
email: lschlosser@floridastudiotheatre.org
website: www.floridastudiotheatre.org
Confidentiality Statement: This electronic message contains information from Florida Studio Theatre, and may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately by reply e-mail or telephone 941.366.9017. Please be aware that all mail sent to and from Florida Studio Theatre is subject to the public records law of Florida.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Audrey Greaves Sent: Monday, June 08, 2015 3:47 PM To: Lee Schlosser Subject: [Tessitura Finance Forum] Search by Check #
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!
Hi, We have a report that will allow for the search of a check no returning the order or contribution along with the payment details. if interested ill post the files.
Could one add the field for check_no in the t_keyword systems table and search that field data using the list manager? This would make it easier in the long run wouldn't it? Or am I missing something that would make this not possible. Thanks!
Hi there! I know it's been a while, but we would love to have this report if you're still looking to share! Is it on TASK? Thank you!
-Molly