Re: [Koha] Report help needed - lost items

2019-10-04 Thread Cab Vinton
Very late to the party, but maybe this could provide a clue. The following throws an error, but I believe the basic idea of finding records where the lowest itemlost value isn't zero is on the right track: WHERE itype = <> GROUP BY biblionumber HAVING MIN(itemlost) > 0 I suspect SQL is

[Koha] circulation history data lost

2019-10-04 Thread mauroluri
Hi! I'm still very new in the koha universe... Recently we've found that when checking in a book, the data that should go from table issues to old_issues is missing. I can borrow an item to anyone, but when it's returned it disappears. We have already around 2 days of records lost, and im

Re: [Koha] Lost item refund

2019-10-04 Thread Caroline Cyr-La-Rose
Hi Andreas! Thanks for spotting that. Yes, the user has paid the item at step 3. :) This is the crux of the problem. Caroline On 19-10-04 03 h 20, Andreas Hedström Mace wrote: Hi Caroline! Is there a step missing from your list? Are the fees added to the account in step 3 actually paid by

Re: [Koha] Lost item refund

2019-10-04 Thread Martha Fuerst
We deal with this issue a lot. If a patron pays for a lost item, they have 90 days to return it for a refund. But that refund is handled outside of Koha, usually via our business office (unless it’s under a certain amount - I think $10 - then it comes out of the drawer and staff make a note on

Re: [Koha] Lost item refund

2019-10-04 Thread Andreas Hedström Mace
Hi Caroline! Is there a step missing from your list? Are the fees added to the account in step 3 actually paid by the patron? Otherwise I do not understand why any money would be given back to the patron... (and the credit should apply to the fees automatically, right? unless they have already