http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6383 Bug #: 6383 Summary: itemnumber not stored when a lost item is returned and credited to account Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Circulation AssignedTo: kyle.m.hall@gmail.com ReportedBy: nengard@gmail.com QAContact: koha-bugs@lists.koha-community.org CC: gmcharlt@gmail.com When a lost item is returned and no longer lost the patron's account is credited, but the item number isn't stored in the itemnumber field in the db. To see what I mean try this report: select b.surname, b.firstname, bib.title, i.itemcallnumber, a.description from accountlines a left join borrowers b on (b.borrowernumber=a.borrowernumber) left join items i on (i.itemnumber=a.itemnumber) left join biblio bib on (bib.biblionumber=i.biblionumber) where a.accounttype='CR' and a.description like 'Item Returned%'; Since the barcode is printing in the description getting the itemnumber in to that table shouldn't be difficult ... I would think. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.