|  login  |  register

List of Payments by Check & Waiver/Release Still Needed

Beware

The check amounts below are NOT always exactly what is on the check. A Handler may have used one check for many entries, many people, etc. This list is for general info only. Copy/Paste it into your check registar or spread sheet for review against the physical payments you have received.


Also, this report uses 'rollup' by check number within a single Event. Some checks may pay for multiple events.)
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pa.pa_id = en.pa_id and en_ttl_paid > 0 and en.en_id not in ( ' at line 13
Select concat( concat(pa_lname, ', '), pa_fname) as Name , en_chkNbr as CKnbr , sum(en_ttl_paid) as CKamt , sum(en_ttl_fees) as Fees , en_pay_status as Status , en.pa_id as IDx , en.pa_id as Id from pa_participant pa, en_summary en where en.ev_id = and pa.pa_id = en.pa_id and en_ttl_paid > 0 and en.en_id not in ( select e2.en_id from en_summary e2 where e2.ev_id = and ( upper(en_chkNbr) like ('%PAY%') -- paypal or upper(en_chkNbr) like ('%POP%') -- PopMoney or upper(en_chkNbr) like ('%ZEL%') -- Zelle or upper(en_chkNbr) like ('%VEN%') -- Venmo or upper(en_chkNbr) like ('%CAS%') -- CashApp or upper(en_chkNbr) like ('%SQU%') -- Square or upper(en_chkNbr) like ('%APL%') -- ApplePay or upper(en_chkNbr) like ('%SAM%') -- SamsungPay ) ) group by en_chkNbr, en.pa_id, en.pa_id, en.pa_id, en_pay_status , Name union all Select concat( concat(pa_lname, ', '), pa_fname) as Name , cs_chkNbr as CKnbr , sum(cs_ttl_paid) as CKamt , sum(cs_ttl_fees) as Fees , cs_pay_status as Status , cs.pa_id as IDx , cs.pa_id as Id -- used by report facility, not displayed from pa_participant pa, cs_summary cs where cs.ev_id = and pa.pa_id = cs.pa_id and cs_ttl_paid > 0 and upper(cs_chkNbr) not like ('%PAY%') -- paypal and upper(cs_chkNbr) not like ('%POP%') -- PopMoney and upper(cs_chkNbr) not like ('%ZEL%') -- Zelle and upper(cs_chkNbr) not like ('%VEN%') -- Venmo and upper(cs_chkNbr) not like ('%CAS%') -- CashApp and upper(cs_chkNbr) not like ('%SQU%') -- Square and upper(cs_chkNbr) not like ('%APL%') -- ApplePay and upper(cs_chkNbr) not like ('%SAM%') -- SamsungPay group by cs_chkNbr, cs.pa_id, cs.pa_id, cs.pa_id, cs_pay_status, Name order by Name, CKnbr
Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1128

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1158

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pa.pa_id = en.pa_id and en.en_id in ( select e2.en_id fr' at line 15
Select concat( concat(pa_lname, ', '), pa_fname) as Name , en_pay_status as Status , en_chkNbr as PayType , en_ttl_fees as Fee , en_ttl_paid as FeePd , en_epay_amt as e_PaidAmt , en_epay_chg as e_NoRefund , en.pa_id as ID , en.pa_id as Id -- used by report facility, not displayed from pa_participant pa, en_summary en where en.ev_id = and pa.pa_id = en.pa_id and en.en_id in ( select e2.en_id from en_summary e2 where e2.ev_id = and ( upper(e2.en_chkNbr) like ('%PAY%') -- paypal or upper(e2.en_chkNbr) like ('%POP%') -- PopMoney or upper(e2.en_chkNbr) like ('%ZEL%') -- Zelle or upper(e2.en_chkNbr) like ('%VEN%') -- Venmo or upper(e2.en_chkNbr) like ('%CAS%') -- CashApp or upper(e2.en_chkNbr) like ('%SQU%') -- Square or upper(e2.en_chkNbr) like ('%APL%') -- ApplePay or upper(e2.en_chkNbr) like ('%SAM%') -- SamsungPay ) ) union all Select concat( concat(pa_lname, ', '), pa_fname) as Name , cs_pay_status as Status , cs_chkNbr as PayType , cs_ttl_fees as Fee , cs_ttl_paid as FeePd , ' ' as e_PaidAmt -- cs_epay_amt (future enhancement) , ' ' as e_NoRefund -- cs_epay_chg (future enhancement) , cs.pa_id as ID , cs.pa_id as Id -- used by report facility, not displayed from pa_participant pa, cs_summary cs where cs.ev_id = and pa.pa_id = cs.pa_id and cs.cs_id in ( select c2.cs_id from cs_summary c2 where c2.ev_id = and ( upper(c2.cs_chkNbr) like ('%PAY%') -- paypal or upper(c2.cs_chkNbr) like ('%POP%') -- PopMoney or upper(c2.cs_chkNbr) like ('%ZEL%') -- Zelle or upper(c2.cs_chkNbr) like ('%VEN%') -- Venmo or upper(c2.cs_chkNbr) like ('%CAS%') -- CashApp or upper(c2.cs_chkNbr) like ('%SQU%') -- Square or upper(c2.cs_chkNbr) like ('%APL%') -- ApplePay or upper(c2.cs_chkNbr) like ('%SAM%') -- SamsungPay ) ) order by Name, PayType

Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1128

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1158

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pa.pa_id = en.pa_id and ( pa.pa_id not in ( Select e2.pa_id fr' at line 7
Select concat( concat(pa_lname, ', '), pa_fname) as Name , ' ' as 'Waiver Check Off' , en.pa_id as Id -- used by report facility, not displayed from pa_participant pa, en_summary en where en.ev_id = and pa.pa_id = en.pa_id and ( pa.pa_id not in ( Select e2.pa_id from en_summary e2 where e2.ev_id = and ( (upper(e2.en_chknbr) like 'W-%' ) or (upper(e2.en_chknbr) like 'X-%') ) ) ) group by Name, 'Waiver Check Off', Id order by Name

Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1128

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1158


Admin Menu Return
Admin Menu Return

Admin Selection Options

o Who is entered and with what STATUS? (w/Drill Down) Show Entries (Drill Down Details)
o How many runs in each class, seperated by day? Trial Totals: Dogs / Classes / Dinners etc.
o Who is entered at what cost? (w/Drill Down) Participant Summary (Drill Down Details)
o Wait List Info, Is the Trial OVER full? Wait List Determination
o What handlers are tardy with their payment? UnPaid Participants
o Which Classes Have Been Approved for Each Person? Classes "Approved" for Each Person Entered
o What is the Running Order for this trial? Show Running Order
o Is the Running Order ready for all to see online? Publish Running Order(one time only)
o Are there scores that need to be posted? Update/Finalize Scores
o What Participants have withdrawn? Cancelled Entries
o Do you need to UPDATE Particpant Status? Approve, Waitlist, Cancel an Entry
o Who paid by check? Check Payments
o Do you need to PRINT Score Sheets? PRINT Score Sheets
o How many USBCHA Open and Nursery Runs for this trial? Show USBCHA required information
o Do Sponsors need to be Managed by Dog? Dog Sponsor Management
o Approve Dogs that made the Draw? Draw Dog Approval
o Assist with Entry? Assist a Participant with Entry


Training ~ Demos ~ Lessons

Dawn Boyce, www.CollieGirl.com



Return to Admin Menu


Copyright © 2004-, all rights reserved. DogTrialEntry.com operates in association with Participant Events. All information submitted on this website is protected by our privacy policy.