Missed an edge case in my idea. If a payment covers all on one fine, but not all of two fines. I was looking at the accountoffsets table ( had to make sure it still exists and is in use ), and realized what the amount column there is for. So have the same column, for the same reason, in the tracking table. It's not as simple an idea now, but it could still work. On Wed, 2009-09-30 at 12:55 -0600, Michael Hafen wrote: [snip]
The trick to getting this to work is having a third table just for tracking the association of credits to invoices. If a payment is made that is more than a single invoice, more rows would be inserted to reflect that. Similarly if many payments are made for one invoice, more rows would be inserted.
-- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha