[Koha-bugs] [Bug 21884] Writeoff "amount" changed from positive values to negative values.

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

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

--- Comment #2 from Alex C <alexanderchen530 at 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.