How to Make Accession Register Report in KOHA

Step-1

Open Koha Admin Panel -> Go into Reports module and click on the link Create from SQL

Step-2

Put the

Report Name:  accregister

Description: Accession Register
Type:  Tabular

Step-3

In SQL section, paste the following query:

SELECT items.barcode,biblio.author,

biblio.title,items.itemcallnumber,items.holdingbranch,biblioitems.isbn,biblioitems.pages,biblioitems.size,biblioitems.place,biblio.copyrightdate FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY LPAD(items.barcode,30,' ') asc

Step-4

Save Report

Step-5

Go Back to Saved Reports Page and click Run against newly built (Accession Register) report


You can export this report to print accession register.

Download Cloud-Server

Download Direct-Server