[Koha] Payment Report help needed.

[MAMCET Library]

Dear all please help.
Patrons fine pay report not generated Error in  '*accounttype*'
Koha version 20.5

Any Account type report not  generated for example " Write amount, Pay
amount and New card Collection .

I enclosed the Error Screen  and report coding.

SELECT
    CONCAT("<a href=\"/cgi-bin/koha/members/boraccount.pl?borrowernumber=
<http://boraccount.pl/?borrowernumber=>", T1.borrowernumber, "\"
target=\"_blank\">View Transaction</a>") AS 'Click to view'
    , DATE_FORMAT(DATE(T1.timestamp), "%d/%m/%Y") AS 'Txn Date'
    , T2.cardnumber AS 'Lib Card No.'
    , CONCAT(T2.surname) AS 'Students Name'
    , T3.description AS 'Category'
  , T2.borrowernotes AS 'Dapartment'
    , CONCAT(LPAD(REPLACE(ROUND(T1.amount, 2),"-", ""), 8, " ")) AS 'Paid
Amount'
FROM
    `accountlines` T1
     LEFT JOIN borrowers T2 USING (borrowernumber)
    LEFT JOIN categories T3 USING (categorycode)
WHERE
    T1.accounttype="PAY"
    AND
   DATE(T1.timestamp) BETWEEN <<From date|date>> AND <<To date|date>>
ORDER BY DATE(T1.timestamp)


-- 
 Thank you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.