[Koha] Introduction / Inventory questions

Sue McMillan sue.mcmillan at STDC.govt.nz
Tue Oct 16 12:30:39 NZDT 2012

Hi Natalie,

We undertook a stocktake earlier this year using Koha 3.4.  We didn't use the stocktake module though.  What we did was return all items through the circulation desk.  This changes their last seen date to the current date.  Once we had done that I then made a report which showed the biblio/item details and included whether the item was on loan or not and the date last seen.

Any item not on issue or not seen prior to the date the stocktake began was considered missing and its status was changed to lost.

We have undertaken stocktakes using the same process and with three different Library Management Systems and have come to the conclusion it is the best method.  Using a laptop with scanner and wifi connection means you aren't dragging books to the issue desk.

Below is the report I use, which could also be used as a shelf check list. If you only have one branch then take out the highlighted line.  Not sure that it would work in your version but worth a try :)

SELECT  items.barcode,items.homebranch,items.holdingbranch,items.datelastseen,items.ccode,items.itemcallnumber,biblio.author,biblio.title,items.onloan,items.reserves FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)   WHERE items.homebranch=<<homebranch|branches>> ORDER BY items.datelastseen asc

Susan McMillan
Cataloguing and Systems Administrator| South Taranaki District Council, New Zealand.
105-111 Albion St, Private Bag 902, Hawera 4610, NZ
Phone: +64 6 278 0555 | www.southtaranaki.com

This e-mail and any attachments may contain confidential and 
information. If you are not the intended recipient, please notify the 
sender immediately by return e-mail, delete this e-mail and destroy 
copies. Any dissemination or use of this information by a person other 
than the intended recipient is unauthorised and may be illegal. Please 
note that this communication does not designate an information system 
for the purposes of the Electronic Transactions Act 2002.

The Council has upgraded to Microsoft office 2007 suite. This may mean you cannot open attachments if you have older versions of office. <a href="http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en"> Click here to access Microsoft Office 2007's compatibility website.<a/> 

More information about the Koha mailing list