[Bug 23638] New: Database cannot store a discount of 100%
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23638 Bug ID: 23638 Summary: Database cannot store a discount of 100% Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org The Koha database cannot store a discount of 100%. When setting up a vendor, if you enter a 100% default discount it will be stored in aqbooksellers as 99.9999%. When entering an order, if you enter a 100% discount it gets stored in aqorders as 99.9999%. This is because the discount field is set up as a FLOAT 6,4 value. -- 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=23638 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |azucena.aguayo@uvu.edu, | |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23638 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- So 100% would be used to set the rental to 0, right? Maybe we should consider fixing bug 13520 instead. The whole idea of discounting makes it a bit of a math puzzle right now. :( -- 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=23638 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=13520 -- 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=23638 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Database cannot store a |Database cannot store an |discount of 100% |acquisitions discount of | |100% -- 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=23638 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Oh, acq! Could you explain the use case a bit? -- 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=23638 --- Comment #3 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- Actually, this is the discount in acquisitions, not the rental charge discount in circ. The values I'm looking at are stored in aqbooksellers.discount and aqorders.discount. I've changed the bug name to make this more clear. -- 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=23638 --- Comment #4 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- The library in question is using acq discounts of 100% to track donations and the cost thereof without showing any actual spending. As donations are received, they are entered in acquisitions with their suggested retail price in Vendor Price but with a discount of 100%, charged to a Donations fund of $0. Except they were really ending up with a 99.9999% discount, which eventually led to a grand total of $0.01 spend against the Donations fund, which produced an over-budget error. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org