[Koha] Acquisitions - Vendor Purchases History

[James Ghiorzi]

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