Vimal, You should have delete privileges on your MySQL database. I'm guessing you can truncate the circ and other transaction table by delete existing records. Just a thought. Regards, Jerry Brock e-Libris Technologies, LLC On Tue, Aug 13, 2013 at 4:32 AM, Vimal Kumar V. <vimal0212@gmail.com> wrote:
Dear Friends,
Today our Koha officially started in production mode.
Trial transaction (checkout, checkin, fines etc) details are still in Koha.
We wish to clean all transaction details from Koha and start the transactions fresh from today. If old transactions persist in Koha, auditors create problems at the year end.
How can we clean the transaction table and get ready for a fresh startup?
Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jerry Brock e-Libris Technologies, LLC email: elibris.helpdesk@gmail.com <elibrishelpdesk@gmail.com> phone: 1-877-723-9447 ext. 2