[Bug 21884] New: Writeoff "amount" changed from positive values to negative values.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 Bug ID: 21884 Summary: Writeoff "amount" changed from positive values to negative values. Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Fines and fees Assignee: koha-bugs@lists.koha-community.org Reporter: alexanderchen530@gmail.com QA Contact: testopia@bugs.koha-community.org Created attachment 82653 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=82653&action=edit Example of pos/neg writeoff values. Hi, This is not a recent issue, I discovered it either after 17.05 or 17.11 update. Before the update, writeoff amounts were displayed in "red positive numbers", but after the update, writeoff amounts became "green negative numbers" just like payments. This is not an issue if it's just humans reading it, but it becomes an issue when doing accounting and stats, when I was totaling fines during a certain time range, positive/negative values cancel each other and provide inaccurate total fine amounts. I used ABS() as a workaround, but I hope it can be fixed globally to keep it uniform. Please see attached pics. Also ticket "#49563: Difference in positive and negative values in writeoff charges" has some discussion as well. I also spoke to Kyle regarding this issue at KohaCon18. Thanks. Alex C -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tomascohen@gmail.com --- Comment #1 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Alex, could you please give us some steps to reproduce the issue? Or is it related to old vs. new data on your db? (generated by the change obviously) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 --- Comment #2 from Alex C <alexanderchen530@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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |18100 Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I believe this was due to bug 18100, fixed by bug 15894 We also spotted this and removed some of the payment options from the GUI back then to avoid the issue in the db. As this hasn't been revisited or got more comments since end of 2018, I am hopeful that bug 15894 fixed it for good. Please reopen if there is still an issue after updating to a recent version. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18100 [Bug 18100] Pay amount, Pay selected and individual pay behaving differently -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 Alex C <alexanderchen530@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #4 from Alex C <alexanderchen530@gmail.com> --- Hi Katrin, Yes I haven't updated this bug because there wasn't an actual fix so far to uniform the positive write-off values and negative write-off values. Is there a way or patch to batch modify all the previous (red) positive write-off amounts into (green) negative amounts? Thanks. Alex. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I believe if the database updates haven't taken care of it, there is no official fix and this might need some work locally :( -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21884 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |WONTFIX --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Katrin Fischer from comment #5)
I believe if the database updates haven't taken care of it, there is no official fix and this might need some work locally :(
This turned out to be true. See bug 29559 for some help with the clean-up if you want to do it. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org