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 Regards 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 privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any 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. <p><b>CAN'T OPEN ATTACHMENTS?</b></p> 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/> _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
