Re: [OPEN-ILS-GENERAL] Amnesty project

2020-06-26 Thread Jason Stephenson
Lynn,

There is a script to forgive bills by patron is available in the
examples from my 2019 Evergreen pre-conference presenation:

https://github.com/Dyrcona/evergreen2019-preconference/blob/master/examples/forgive_bills.pl

This could be used a starting point. The script eliminates bills by
applying a forgive payment to them.

HtH,
Jason

On 6/26/20 9:35 AM, Floyd, Angelia Lynn wrote:
> One of our library systems is wanting to do an Amnesty project, and
> clear all bills over 5 yrs old.  Anyone have a script we can start with?
> Or any gotchas We should know about?
> 
>  
> 
> -
> Lynn Floyd
> MIS Supervisor
> 
> 
> Indiana State Library
> https://www.in.gov/library/
> 315 W Ohio St
> Indianapolis, IN 46202
> 317-232-3290
> lflo...@library.in.gov 
> 
>  
> 


Re: [OPEN-ILS-GENERAL] Amnesty project

2020-06-26 Thread Rogan Hamby
Hi Lynn,

I've done a few of these projects on a database level for libraries.  A
quick question, do they want to clear all bills over five years old or all
bills associated with transactions that are more than five years old?  The
difference can lead to some odd edge-case scenarios.  My experience from
making things as simple as possible for the patrons and staff to deal with
is to clear out transactions over five years.  So, some billings might be
more recent but the circ or booking that started them would be more than
five years old.  That really helps remove the oddball cases that cause
confusion in the future. I would also recommend closing out those
transactions.

You'll also want to consider what you want to do with negative balances.
At a minimum, you don't want to make them worse by applying additional
payment offsets to them and applying a negative forgive payment might work
but makes me twitch uncomfortably.

I'll look to see if I have a script I can share that can be cribbed from
but my general approach is:

a) does the transaction have any payments on it?  If no then void it.
b) is the balance negative?  if so then adjust to zero.
c) the balance is positive?  forgive outstanding amount.





On Fri, Jun 26, 2020 at 9:35 AM Floyd, Angelia Lynn 
wrote:

> One of our library systems is wanting to do an Amnesty project, and clear
> all bills over 5 yrs old.  Anyone have a script we can start with? Or any
> gotchas We should know about?
>
>
>
> -
> Lynn Floyd
> MIS Supervisor
>
>
> Indiana State Library
> https://www.in.gov/library/
> 315 W Ohio St
> Indianapolis, IN 46202
> 317-232-3290
> lflo...@library.in.gov
>
>
>


[OPEN-ILS-GENERAL] Amnesty project

2020-06-26 Thread Floyd, Angelia Lynn
One of our library systems is wanting to do an Amnesty project, and clear all 
bills over 5 yrs old.  Anyone have a script we can start with? Or any gotchas 
We should know about?

-
Lynn Floyd
MIS Supervisor

Indiana State Library
https://www.in.gov/library/
315 W Ohio St
Indianapolis, IN 46202
317-232-3290
lflo...@library.in.gov