Group: ILLiad Libraries  
RSS
Threads [ Previous | Next ]
Process for calculating daily overdues in borrowing?
Showing 3 results.
Process for calculating daily overdues in borrowing?
Tags: billing overdue
1:26 PM EDT 10/8/09
I seem to recall that the ILLiad Billing Manager doesn't support daily overdue charges for borrowing transactions, so I was wondering if anyone out there has come up with a reasonable process for identifying and calculating daily overdues. I suspect that we could create a SQL or MS Access query that uses the ILLiad data tables for such a thing, but I thought I would see if anyone else has already done this and is willing to share the query structure/code with me.

Thanks!!
RE: Process for calculating daily overdues in borrowing?
10:11 AM EDT 10/19/09 as a reply to Ken Carriveau.
Hey Ken,

During some billing training classes, I have sometimes referenced a couple of emails from Frank Haulgren/Western Washington University
to the ILLiad-L list (Thanks Frank!) where he shared some code for his overdue calculations. I have not tested myself and don't know if Frank still uses them - the posts were from 2005 so might be outdated by now. But if he still uses a similar method he might be willing to share as he has in the past.

Here are links to his original posts from the archive:

Post #2 with code
Post #1

Stephanie
RE: Process for calculating daily overdues in borrowing?
5:55 PM EST 11/13/09 as a reply to Stephanie Spires.
Thanks, Stephanie! I knew I had seen something about this in the past, but couldn't remember when it was posted. I've got the code and will see if I can tweak it to work with version 7.4.