Generating dollar value reports
I'm a newbie, so I apologize if this is a dumb question, but I'm under a time crunch and need some help. How can I run a quick report that tells me the dollar value of our library's inventory? I've got a report for the total number of items by type, but can't figure out how to generate the $$$. Many thanks, and please feel free to email me directly with any suggestions. Best, *Michele Martin* *Director of Information Science (Librarian)Sonoma Academy2500 Farmers LaneSanta Rosa, CA 95404707.545.1770*
Hi Michelle Try this - export as excel - dump out the columns of data you don’t need: Annual Stocktake report: select barcode,items.itype,title,holdingbranch,itemcallnumber,publicationyear,barcode,wthdrawn, copyrightdate,dateaccessioned, price,replacementprice,booksellerid,datelastseen,itemlost,wthdrawn from items,biblioitems,biblio where biblioitems.biblioitemnumber=items.biblioitemnumber and items.biblionumber=biblio.biblionumber limit 150000 (PS Change the 150000 at the end of the stocktake to be larger than you expect your collection to be) Cheers Jo -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Michele Martin Sent: Thursday, 23 July 2015 10:14 a.m. To: koha@lists.katipo.co.nz Subject: [Koha] Generating dollar value reports I'm a newbie, so I apologize if this is a dumb question, but I'm under a time crunch and need some help. How can I run a quick report that tells me the dollar value of our library's inventory? I've got a report for the total number of items by type, but can't figure out how to generate the $$$. Many thanks, and please feel free to email me directly with any suggestions. Best, *Michele Martin* *Director of Information Science (Librarian)Sonoma Academy2500 Farmers LaneSanta Rosa, CA 95404707.545.1770* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ##################################################################################### This e-mail message and any attached files may contain confidential information, and may be subject to legal professional privilege. If you are not the intended recipient, please delete. Unless formally stated, this e-mail and any attachments do not necessarily reflect the views of the the The Horowhenua Trust. The Horowhenua Trust takes extensive precautions with the aim of detecting and removing any virus or defects from its e-mail system but accepts no liability for loss or damage should this e-mail not be virus or defect free or should there be any errors in transmission. #####################################################################################
participants (2)
-
Joann Ransom -
Michele Martin