Patrons Writeoff Fine List with in Date Wise (Koha SQL Reports Queries)

Patrons Writeoff Fine List.

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT accountlines.Date,borrowers.Cardnumber,borrowers.Surname,borrowers.borrowernotes AS Department, accountlines.Amount

FROM accountlines, borrowers WHERE borrowers.borrowernumber = accountlines.borrowernumber AND accounttype = 'W' AND date BETWEEN <<Between Date (dd-mm-yyyy)|date>> AND <<and (dd-mm-yyyy)|date>>

Run Report