Hi Klas, you will be able to tell the checkin date from old_issues and statistics (depending on the IssueLog system preference). You could combine that with the date the item was marked lost: items.itemlost_on. Hope this helps, Katrin On 27.04.2018 14:15, klas.blomberg@skovde.se wrote:
Our plan is to use an external system for billing our users for lost books, and only mark them as lost in Koha.
I have all pieces in place, except one: we need to know what lost books that have been returned (in last week or some other specified period) so we can know what bills should be withdrawn from the external system.
Is this at all doable with Kohas reports? As the economic transactions not are going to take place in Koha there will be nothing in accountlines, and I haven't found any other candidates
Klas Blomberg IT-bibliotekarie
Stadsbiblioteket Skövde Kulturhus Skövde kommun 541 83 Skövde Direkttelefon 0500-49 85 18 Mobil 070-191 55 78 Kontaktcenter telefon 0500-49 80 00
www.skovde.se
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha