I wanted to see how much we had to pay for items ordered from Awana out of our budget (as opposed to items getting reimbursed by parents). In other words, I wanted the total of items waived, not including dues. Since the Ledger's Fees grid did not have a way to show partial payments that were waived, I used the following sql query:
select Sum(FP.Amount) as Total from Payment P, Fee F, Fee_Payment FP
where P.Type = 'Waived' and F.For_Dues = False and P.Payment_ID = FP.Payment_ID and FP.Fee_ID = F.Fee_ID and F.Club_Year = '2009-2010'
See the following thread for more details:
http://approvedworkman.com/forum/index.php?topic=826