Re: Delete a catlog Record which already check in and checked out

Posted by Verus Open Source Support on Feb 22, 2012; 4:21am
URL: http://ngl.70.s1.nabble.com/problem-in-Check-in-and-check-out-tp6027050p7307122.html

Hi,
Open your Pgadmin3-> SQL Window and type the below 2 queries. Each query will yield a result. Send me the results of both these queries

select status from document where accession_number='your accession number.Note single quotes must be there';

select * from cir_transaction where accession_number='your accession number.Note single quotes must be there';


On 02/22/2012 07:42 AM, pedroparkero [via NewGenLib] wrote:

Hello, I have a problem. An item is still charged to a patron even though it is already checked in. As a result, whenever I input the Userid, "Patron holds overdue Material" message shows. I have tried to check in the item that shows in "Items held by patron" in Patron Information, but the Check in module say "Document available in library". I have also tried using "Re-index catalogue record" module to reindex the affected accession number, but it still shows as charged to that patron. Please tell me how to remove it.

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/problem-in-Check-in-and-check-out-tp6027050p7306950.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML