[Koha] Acquisitions - Vendor Purchases History
James Ghiorzi
JGhiorzi at lib.co.san-benito.ca.us
Sat Jul 30 03:48:28 NZST 2011
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-bounces at lists.katipo.co.nz [koha-bounces at lists.katipo.co.nz] On Behalf Of Joel Harbottle [Joel.Harbottle at 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.Services at hotmail.com<UrlBlockedError.aspx>
Web: http://libservices.wordpress.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110729/298340d8/attachment.htm
More information about the Koha
mailing list