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.
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!
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!