Thanks a lot for your instant reply.<br>I will be in touch with you.<br><br><div class="gmail_quote">On Thu, Apr 23, 2009 at 5:46 AM, Joann Ransom <span dir="ltr"><<a href="mailto:jransom@library.org.nz">jransom@library.org.nz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi there,<br>
<br>
I wrote this a while back, but we reconcile our daily cash receipts at each branch every day.<br>
<br>
I will try and find the bugs I loaded at the time ... I'm not sure they are in the latest bugzilla.<br>
<br>
I'll stay in touch and I'd love to hear how you get on!<div class="im"><br>
<br>
Cheers Jo..<br>
<br>
SANDEEP BHAVSAR wrote:<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
Yes Please send me ASAP.<br>
<br></div><div><div></div><div class="h5">
On Thu, Apr 23, 2009 at 3:51 AM, Joann Ransom <<a href="mailto:jransom@library.org.nz" target="_blank">jransom@library.org.nz</a> <mailto:<a href="mailto:jransom@library.org.nz" target="_blank">jransom@library.org.nz</a>>> wrote:<br>
<br>
Hi Sandep,<br>
<br>
We run the til reconciliation report in Koha, and while its not<br>
perfect it can be mnade to work. I know whats wrong with it but<br>
don't have the skills to fix it<br>
so I export it over into excel and then tweak it to get exactly<br>
the rights showing.<br>
<br>
Would you like m,e to send you through what I know?<br>
<br>
Cheers Jo.<br>
<br>
..<br>
SANDEEP BHAVSAR wrote:<br>
<br>
<br>
Respected All<br>
<br>
I have gone through the previously posted messages on “ Report<br>
Generation-Till Reconciliation for each branch libraries” by<br>
Mr. Basu on /Wed, Dec 10, 2008 at 10:31 AM/ and also read the<br>
views of Joe Atzberger , BWS Johnson, Joshua Ferraro and<br>
Henri-Damien<br>
<br>
I am sure that the each and every public library in India<br>
would like to know about how much money they have collected at<br>
the end of the day from their all category of patrons.<br>
<br>
Is it possible to generate the same Till Reconciliation Report<br>
with *Total amount paid* through /Home › Reports › Guided<br>
Reports Wizard › Create from SQL/ .<br>
<br>
<br>
If yes, Please share the SQL Command.<br>
<br>
<br>
-------Advance Technology News for elibrarians<br>
<a href="http://sandeepbhavsar.blogspot.com/" target="_blank">http://sandeepbhavsar.blogspot.com/</a> ------<br>
<br>
<br>
Thanks and Regards<br>
<br>
Sandeep Bhavsar<br>
Librarian<br>
Dr.V.N.Bedekar Institute of Management Studies<br>
Thane(W) 400601<br>
MUMBAI. INDIA<br>
@@@@@@@@@@@@@@@@@@@@@@@@@@<br>
email : <a href="mailto:sandeep.bhavsar@gmail.com" target="_blank">sandeep.bhavsar@gmail.com</a><br>
<mailto:<a href="mailto:sandeep.bhavsar@gmail.com" target="_blank">sandeep.bhavsar@gmail.com</a>><br>
<mailto:<a href="mailto:sandeep.bhavsar@gmail.com" target="_blank">sandeep.bhavsar@gmail.com</a><br>
<mailto:<a href="mailto:sandeep.bhavsar@gmail.com" target="_blank">sandeep.bhavsar@gmail.com</a>>><br>
<br>
Mob : 9987049099<br>
elibrary :<a href="http://www.vpmthane.org/im/elib/main.htm" target="_blank">http://www.vpmthane.org/im/elib/main.htm</a><br>
@@@@@@@@@@@@@@@@@@@@@@@@@@<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Koha mailing list<br></div></div>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a> <mailto:<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a>><div class="im"><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br>
<br>
<br>
<br>
-- <br>
Thanks and Regards<br>
<br>
Sandeep Bhavsar<br>
Librarian<br>
Dr.V.N.Bedekar Institute of Management Studies<br>
Thane(W) 400601<br>
MUMBAI. INDIA<br>
@@@@@@@@@@@@@@@@@@@@@@@@@@<br></div><div class="im">
email : <a href="mailto:sandeep.bhavsar@gmail.com" target="_blank">sandeep.bhavsar@gmail.com</a> <mailto:<a href="mailto:sandeep.bhavsar@gmail.com" target="_blank">sandeep.bhavsar@gmail.com</a>><br>
Mob : 9987049099<br>
elibrary :<a href="http://www.vpmthane.org/im/elib/main.htm" target="_blank">http://www.vpmthane.org/im/elib/main.htm</a><br>
@@@@@@@@@@@@@@@@@@@@@@@@@@<br>
</div></blockquote>
</blockquote></div><br><br clear="all"><br>-- <br>Thanks and Regards<br><br>Sandeep Bhavsar<br>Librarian<br>Dr.V.N.Bedekar Institute of Management Studies<br>Thane(W) 400601<br>MUMBAI. INDIA<br>@@@@@@@@@@@@@@@@@@@@@@@@@@<br>
email : <a href="mailto:sandeep.bhavsar@gmail.com">sandeep.bhavsar@gmail.com</a><br>Mob : 9987049099<br>elibrary :<a href="http://www.vpmthane.org/im/elib/main.htm">http://www.vpmthane.org/im/elib/main.htm</a><br>@@@@@@@@@@@@@@@@@@@@@@@@@@<br>