[Koha-bugs] [Bug 14390] Fine not updated from 'FU' to 'F' on renewal

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14390

--- Comment #68 from Jacek Ablewicz <abl at biblos.pk.edu.pl> ---
(In reply to Katrin Fischer from comment #67)
> It might also depend on configuraton - it's possible to block renewals of
> overdue items now, but it's a more recent feature.

That wasn't it.. turns out I did wrong kind of search the 1st time :(. Sorry
for overlooking this. If I do something like that instead:

  SELECT ac.*, b.cardnumber, iss.date_due
  FROM accountlines ac
  LEFT JOIN issues iss ON (iss.issue_id = ac.issue_id)
  LEFT JOIN borrowers b ON (iss.borrowernumber = b.borrowernumber)
  WHERE ac.accounttype = 'FU'
  AND iss.issue_id IS NOT NULL
  AND iss.date_due >= NOW();

sure enough I get some hits. Not a lot, and they are not "double FU"s per se,
but indeed accounttype in such records should be changed from 'FU' to 'F'.

-- 
You are receiving this mail because:
You are watching all bug changes.