> s.date_ret AS xact_finish, You may be doing this part prematurely. If xact_finish is set, then the transaction is closed (and the billings and payments are supposed to be in balance).
-- Jason Etheridge | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com | Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
