Customize koha Accession Register (Koha SQL Reports Queries)

Lib Power Tech March 12, 2021

Accession Register Customize
  • Crete the New SQL Report
  • Copy and Paste  following lines in the SQL report. Save and close.

SELECT items.Barcode,biblioitems.biblionumber,items.itemcallnumber AS 'Call Number',biblio.Author,biblio.Title AS Titles,biblioitems.size As 'Bill No', biblioitems.Pages, biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.illus AS 'OPAC Price',biblioitems.publishercode AS Publisher,biblioitems.Place AS 'Place of Publication',biblio.unititle AS Subject,items.ccode AS Collection,items.location AS 'Department Wise', items.itype AS 'Book Status / Item type',biblioitems.itemtype AS Department,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes As ' General Notes/Remarks',biblio.Serial,items.Issues,items.Renewals
FROM items 
LEFT JOIN biblioitems ON (items.biblioitemumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblnio.biblionumber)
ORDER BY LPAD(items.barcode,40,' ') ASC

Run Report

Lib Power Tech

Posted by Lib Power Tech

This situation will change

Post a Comment

5 Comments

  1. PrikshitDecember 23, 2020 at 6:47 PM

    I have put Bill No. in 541$b, Bill Date 541$d and subject in 650$a. Please customise the accession register report including these fields.

    ReplyDelete
    Replies
    1. Lib Power TechMarch 12, 2021 at 1:47 PM

      The Fields you asked for are updated.

      Bill No. in 300$c, Bill Date 300$e and subject in 650$a.

      Delete
  2. Shonu MishraApril 22, 2022 at 5:00 PM

    thank you for sharing this wonderfull article we also provide (SEO, Digital Marketing, business, Affiliate Marketing, Earn Money Online, Instagram marketing, blogging or blogger Couses for free) and much more like news andall other tech things, i wish that you will wonder here.

    ReplyDelete
  3. Yesan SellanJanuary 7, 2026 at 11:02 AM

    Tried using the code for generating report, it shows

    The following error was encountered:
    The database returned the following error:
    Unknown column 'items.biblioitemumber' in 'ON'
    Please check the log for further details.
    Pl check, if i have to modify anything,

    ReplyDelete
    Replies
    1. Yesan SellanJanuary 7, 2026 at 11:08 AM

      SELECT items.Barcode,biblioitems.biblionumber,items.itemcallnumber AS 'Call Number',biblio.Author,biblio.Title AS Titles,biblioitems.size As 'Bill No', biblioitems.Pages, biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.illus AS 'OPAC Price',biblioitems.publishercode AS Publisher,biblioitems.Place AS 'Place of Publication',biblio.unititle AS Subject,items.ccode AS Collection,items.location AS 'Department Wise', items.itype AS 'Book Status / Item type',biblioitems.itemtype AS Department,biblioitems.url AS OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes As ' General Notes/Remarks',biblio.Serial,items.Issues,items.Renewals
      FROM items
      LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
      LEFT JOIN biblio ON (biblioitems.biblionumber=biblioitems.biblionumber)
      ORDER BY LPAD(items.barcode,40,' ') ASC

      Delete