ÿþDetail Accession Register Report/Format

    Developer: Vinod Kumar Mishra (http://mishravk.com/)
    Module: Acquisitions
    Purpose: This report will help all Libraries to print the accession record of a book and maintain the register especially as per Indian GFR2017 prescribed accession register format. 

    Status: Complete tested on Koha 16.11.11 

SELECT 
    oo.dateaccessioned AS 'Date', oo.barcode AS 'Acc. No.', ooo.title AS 'Title',
ooo.author AS 'Author/Editor', concat_ws(' , ', o.editionstatement, oo.enumchron) AS 'Ed./Vol.',
concat_ws(' ', o.place, o.publishercode) AS 'Place & Publisher',
ooo.copyrightdate AS 'Year', o.pages AS 'Page(s)', ooooooo.name AS 'Source',
oo.itemcallnumber AS 'Class No./Book No.', concat_ws(', ¹ ', concat(' ', ooooo.symbol, oooo.listprice), oooo.rrp_tax_included) AS 'Cost', concat_ws(' , ', oooooo.invoicenumber, oooooo.shipmentdate) AS 'Bill No. & Date', '' AS 'Withdrawn Date', '' AS 'Remarks'
 
FROM biblioitems o
LEFT JOIN items oo ON oo.biblioitemnumber=o.biblioitemnumber
LEFT JOIN biblio ooo ON ooo.biblionumber=o.biblionumber
LEFT JOIN aqorders oooo ON oooo.biblionumber=o.biblionumber
LEFT JOIN currency ooooo ON ooooo.currency=oooo.currency
LEFT JOIN aqinvoices oooooo ON oooooo.booksellerid=oo.booksellerid
LEFT JOIN aqbooksellers ooooooo ON ooooooo.id=oo.booksellerid
 
WHERE cast(oo.barcode AS UNSIGNED) BETWEEN <<Accession Number>> AND <<To Accession Number>>
GROUP BY oo.barcode
ORDER BY oo.barcode ASC