[Koha-bugs] [Bug 6383] New: itemnumber not stored when a lost item is returned and credited to account
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri May 20 19:47:55 CEST 2011
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 at gmail.com
ReportedBy: nengard at gmail.com
QAContact: koha-bugs at lists.koha-community.org
CC: gmcharlt at 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.
More information about the Koha-bugs
mailing list