https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884
--- Comment #2 from Alex C <alexanderchen...@gmail.com> --- Hi Tomas, I think it's old vs new data prior/after an update, you can take a look at this patron's account: 20165100573549, if you filter only "writeoff" numbers, you can see that writeoff balances prior to 2017 were all positive values shown in red (like fines), but after 2017 they were all negative values shown in green like payments. I believe if you pull a SQL report to show writeoff balances from any db it might show the same thing, I don't think it's specifically our DB. I think you can use the timestamps when 17.05 or 17.11 updates were done to see if the values started to look differently prior/after the updates. Hope my explanation made sense ... sorry I can't find the SQLs I wrote back then when I first discovered this, we were doing library system-wide stats on fines and accounts sent to collection, that's how I found some fines were canceling each other out because of the pos/neg values. Thanks. Alex. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/