Create a report: Prêt Numérique item with «In transit» status
This report will generate the current list of electronic items with the status «In transit». Then, manually check in each item to change the status to «Available».
1 Go to > Reports
2. Click on « + Create from SQL »
3. Fill in the form
4. Copy the following text:
SELECT
biblio.title AS "Titre",
biblio.author AS "Auteur",
items.barcode AS "Code-barres",
DATE(branchtransfers.datesent) AS "En transit depuis le",
CONCAT('<a href="/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=', biblionumber, '&itemnumber=', itemnumber, '#edititem', '">Voir le document</a>' ) AS ""
FROM
branchtransfers
JOIN items USING(itemnumber)
JOIN biblio USING(biblionumber)
WHERE
datearrived IS NULL
AND
tobranch=<<Bibliothèque|branches>>
5. Paste the text in the « SQL» box.
6. Click on « Save report ».
7. Click on « Run report»
7. Select your « digital library » name and click on «Run report»
A list of items will appear. Copy an item barcode and check in manually the item.