Author Topic: Getting the total cost of items waived  (Read 1926 times)

Sherri

  • Global Moderator
  • Full Member
  • *****
  • Posts: 42
Getting the total cost of items waived
« on: February 18, 2010, 01:18:41 PM »
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
Sherri Meadows
Monument, CO