I want to see how much we've had to pay for items ordered from Awana out of our budget (as opposed to items getting reimbursed by parents). In other words, I want the total of items waived, not including dues. I thought that I should easily be able to see this total by looking at the Ledger's Fees grid. I filtered the grid with "(Waived=True) and (Dues?=False)".
At first glance, this seemed to be exactly what I wanted, but then I noticed that there were a few items in the list that I didn't remember waiving. Turns out that they were items that had less than a dollar owed on them, so I waived the small amount. (People miscalculated, or rounded down a few cents & I didn't think it was worth bothering them about it)
So, I tried the Payments grid, but it included dues that have been waived & I don't see a way to filter them out.
- Is there a different/better way to get at the info that I'm trying to find? (without using a sql query)
- Should the Ledger's Fees grid maybe have an "Amount Waived" column instead of just a "Waived" checkbox?