Anyone know of a way to find a check lost in the system? I have a patron who claims to have paid by check and that their bank reports that check deposited but it's not on their account. Thanks
The following query might help to see if a check with the same check number was entered somewhere in Tessitura. Put a date range in that spans when the check could have been entered, and put the check number in place of 1210. Make sure that you replace Check% with the appropriate description of check payments from your system. (If you use only one type of check called “check,” use “select id from TR_PAYMENT_METHOD where description = ‘check’”.)
select a.* from t_payment a
where a.pmt_method in (select id from TR_PAYMENT_METHOD where description like 'Check%')
and a.pmt_dt between '9/1/2012' and '9/12/2012'
and a.check_no = 1210
_____________________________Lucie SpielerIT Development and Training Manager
Editor, Season Program BookFLORIDA GRAND opera
thanks for the suggestion, we'll see if it turns up that way.
-Zach