[Koha] Till Reconciliation - Create from SQL

[SANDEEP BHAVSAR]

Thanks a lot for your instant reply.
I will be in touch with you.

On Thu, Apr 23, 2009 at 5:46 AM, Joann Ransom <jransom at library.org.nz>wrote:

> 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
>> @@@@@@@@@@@@@@@@@@@@@@@@@@
>>
>


-- 
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
Mob     : 9987049099
elibrary :http://www.vpmthane.org/im/elib/main.htm
@@@@@@@@@@@@@@@@@@@@@@@@@@
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090423/0ef895c2/attachment.htm