[Koha] SQL Report generation for fines - payment, writeoff

Hi It seems while updating the fine payment , itemnumber becomes null in accountlines table. please help how to calculate fines paid and writeoff amount for a range of date through sql reports module. -- Best wishes ऋचा Richa Srivastava