[Koha] Generating dollar value reports

[Joann Ransom]

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 at lists.katipo.co.nz] On Behalf Of Michele Martin
Sent: Thursday, 23 July 2015 10:14 a.m.
To: koha at 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 at 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.

#####################################################################################