<br>Hi.<br><br>Pls. try following sql statement for payment & writeoff <br><br><p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2"><i><u><b>writeoff in a month date wise<br></b></u></i></font></p>

<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif">
</p>
<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2"><i>SELECT borrowers.borrowernumber,
borrowers.cardnumber, accountlines.amount, accountlines.date</i></font></p>
<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2"><i>FROM accountlines, borrowers WHERE
borrowers.borrowernumber = accountlines.borrowernumber AND
accounttype = 'W' AND MONTH(date) = 11 AND YEAR(date)= 2011</i></font></p>
<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2">
</font></p>
<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2"><i><u><b>Payment in a month date wise<br></b></u></i></font></p>
<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif">
</p>
<p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2"><i>SELECT borrowers.borrowernumber,
borrowers.cardnumber, accountlines.amount, accountlines.date</i></font></p>
<p style="margin-bottom: 0cm; font-family: arial,helvetica,sans-serif;"><font size="2"><i>FROM accountlines, borrowers WHERE
borrowers.borrowernumber = accountlines.borrowernumber AND
accounttype = 'pay' AND MONTH(date) = 11 AND YEAR(date)= 2011</i></font></p><p style="margin-bottom: 0cm; font-family: arial,helvetica,sans-serif;"><br></p><p style="margin-bottom: 0cm; font-family: arial,helvetica,sans-serif;">
<font size="2"><i>Nikunj Tyagi</i></font></p><p style="margin-bottom:0cm;font-family:arial,helvetica,sans-serif"><font size="2"><i>DPL<br></i></font></p><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
 
<br>
<br>
<br>
<br>
Message: 3<br>
Date: Wed, 30 Nov 2011 15:39:56 +0530<br>
From: Richa Srivastava <<a href="mailto:richa.srivastava36@gmail.com">richa.srivastava36@gmail.com</a>><br>
To: <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>
Subject: [Koha] SQL Report generation for fines - payment, writeoff<br>
Message-ID:<br>
        <CAHBnVBfV1W=Ji938uO_MkDh_+UBwiN=<a href="mailto:QpY0iOoyyGmeKj79Haw@mail.gmail.com">QpY0iOoyyGmeKj79Haw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi<br>
<br>
It seems while updating the fine payment , itemnumber becomes null in<br>
accountlines table. please help how to calculate fines paid and writeoff<br>
amount for a range of date through sql reports module.<br>
<br>
--<br>
<br>
Best wishes<br>
???<br>
Richa Srivastava<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.katipo.co.nz/pipermail/koha/attachments/20111130/8ad00546/attachment-0001.html" target="_blank">http://lists.katipo.co.nz/pipermail/koha/attachments/20111130/8ad00546/attachment-0001.html</a>><br>

<br>
------------------------------<br>
<br>
</blockquote></div><br>