[Koha] Till Reconciliation - Create from SQL

[Joann Ransom]

Hi there,

I wrote this a while back, but we reconcile our daily cash receipts at 
each branch every day.

I will try and find the bugs I loaded at the time ... I'm not sure they 
are in the latest bugzilla.

I'll stay in touch and I'd love to hear how you get on!

Cheers Jo..

SANDEEP BHAVSAR wrote:
> Yes Please send me ASAP.
>
> On Thu, Apr 23, 2009 at 3:51 AM, Joann Ransom <jransom at library.org.nz 
> <mailto:jransom at library.org.nz>> wrote:
>
>     Hi Sandep,
>
>     We run the til reconciliation report in Koha, and while its not
>     perfect it can be mnade to work. I know whats wrong with it but
>     don't have the skills to fix it
>     so I export it over into excel and then tweak it to get exactly
>     the rights showing.
>
>     Would you like m,e to send you through what I know?
>
>     Cheers Jo.
>
>     ..
>     SANDEEP BHAVSAR wrote:
>
>
>         Respected All
>
>          
>         I have gone through the previously posted messages on “ Report
>         Generation-Till Reconciliation for each branch libraries” by
>         Mr. Basu on /Wed, Dec 10, 2008 at 10:31 AM/ and also read the
>         views of Joe Atzberger , BWS Johnson, Joshua Ferraro and
>         Henri-Damien
>
>         I am sure that the each and every public library in India
>         would like to know about how much money they have collected at
>         the end of the day from their all category of patrons.
>
>          
>         Is it possible to generate the same Till Reconciliation Report
>         with *Total amount paid* through /Home › Reports › Guided
>         Reports Wizard › Create from SQL/ .
>
>
>         If yes, Please share the SQL Command.
>
>
>         -------Advance Technology News for elibrarians
>          http://sandeepbhavsar.blogspot.com/ ------
>
>
>         Thanks and Regards
>
>         Sandeep Bhavsar
>         Librarian
>         Dr.V.N.Bedekar Institute of Management Studies
>         Thane(W) 400601
>         MUMBAI. INDIA
>         @@@@@@@@@@@@@@@@@@@@@@@@@@
>         email    : sandeep.bhavsar at gmail.com
>         <mailto:sandeep.bhavsar at gmail.com>
>         <mailto:sandeep.bhavsar at gmail.com
>         <mailto:sandeep.bhavsar at gmail.com>>
>
>         Mob     : 9987049099
>         elibrary :http://www.vpmthane.org/im/elib/main.htm
>         @@@@@@@@@@@@@@@@@@@@@@@@@@
>         ------------------------------------------------------------------------
>
>         _______________________________________________
>         Koha mailing list
>         Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>         http://lists.katipo.co.nz/mailman/listinfo/koha
>          
>
>
>
>
> -- 
> Thanks and Regards
>
> Sandeep Bhavsar
> Librarian
> Dr.V.N.Bedekar Institute of Management Studies
> Thane(W) 400601
> MUMBAI. INDIA
> @@@@@@@@@@@@@@@@@@@@@@@@@@
> email    : sandeep.bhavsar at gmail.com <mailto:sandeep.bhavsar at gmail.com>
> Mob     : 9987049099
> elibrary :http://www.vpmthane.org/im/elib/main.htm
> @@@@@@@@@@@@@@@@@@@@@@@@@@
-------------- next part --------------
A non-text attachment was scrubbed...
Name: To Get Daily Cash Reconciliation Report.doc
Type: application/msword
Size: 306176 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20090423/d55b9973/attachment-0001.doc 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jransom.vcf
Type: text/x-vcard
Size: 290 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20090423/d55b9973/attachment-0001.vcf