Hi Joel,
Took these right off the Wiki
(http://wiki.koha-community.org/wiki/SQL_Reports_Library), hope they help:
Orders in Date Range
* Developer: Nicole C. Engard, ByWater Solutions
* Module: Acquisitions
* Purpose: Show order information for a specific date period.
* Status: Complete
SELECT v.name AS vendor, b.title AS 'book title',
format(o.listprice,2) AS 'list price',
format(o.unitprice,2) AS 'actual price',
ba.basketname, o.notes
FROM aqorders o
LEFT JOIN aqbasket ba USING (basketno)
LEFT JOIN aqbooksellers v ON (v.id = ba.booksellerid)
LEFT JOIN biblio b USING (biblionumber)
WHERE o.entrydate BETWEEN <<Ordered BETWEEN (yyyy-mm-dd)>> AND <<and
(yyyy-mm-dd)>>
Ledger
* Developer: Nicole C. Engard, ByWater Solutions
* Module: Acquisitions
* Purpose: Show's a ledger of all items ordered
* Status: Complete
SELECT b.name AS vendor, i.itype, p.budget_branchcode AS branch, k.basketno,
o.entrydate AS 'order date', format(o.listprice,2) AS 'list price',
format(o.unitprice,2) AS 'unit price', o.quantity,
format(o.totalamount,2) AS 'total amount', o.datereceived AS 'date
received'
FROM aqbasket k
LEFT JOIN aqbooksellers b ON (k.booksellerid=b.id)
LEFT JOIN aqorders o USING (basketno)
LEFT JOIN items i USING (biblioitemnumber)
LEFT JOIN aqbudgets p USING (budget_id)
Respectfully,
James Ghiorzi
Library Assistant II
San Benito County Free Library
470 Fifth St.
Hollister, CA 95023
(831) 636-4107
________________________________
From: koha-boun...@lists.katipo.co.nz [koha-boun...@lists.katipo.co.nz] On
Behalf Of Joel Harbottle [joel.harbot...@hotmail.com.au]
Sent: Friday, July 29, 2011 3:39 AM
To: Koha List
Subject: [Koha] Acquisitions - Vendor Purchases History
Hi All,
Just dropping a quick question for everyone. Does anyone know, if there is a to
either view, directly in the Acquisitions, or via a generated Report, to get a
list of all items purchased from each Vendor in the Acquisitions module?
I’m just going through a few invoices but can’t find a way of searching them in
Acquisitions... Is there a way... I would really love to have this
functionality.
Thanking you in advance :)
Kindest Regards,
Joel
Joel Harbottle
Library Technician
Library Processing Services (Queensland)
Email: library.servi...@hotmail.com<UrlBlockedError.aspx>
Web: http://libservices.wordpress.com/
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
