2009/10/2 Kyle Hall <kyle.m.hall@gmail.com>:
I just thought of a reasonably easy way to track both the payment made by a borrower, and the payment as applied to charges on a borrowers account. Let's start with the three $5 fine scenario again, which the borrower is paying in full.
1. A payment of $15 is made, it is inserted with a new accounttype ( say BORPMNT ). 2. This payment is broken down into 3 $5 payments, each of which reference one of the existing charges. 3. Each of these payments also reference the $15 payment through a new column, say accountno_pmnt
The BORPMNT could either live in the existing accountlines table, or could be stored in yet another table.
The real question is: is this necessary? Do any libraries using Koha need to track total payments against individual fine payments?
Yes, they need to be able to say to a person who queries their account, you paid $15 on this day, and it went against these 3 fines. Or paid off $15 of this lost book replacement charge. The more information they have when a borrower queries their account the easier their lives are. Chris