[Koha-bugs] [Bug 10946] New: pay fine amout showing negative value
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Sep 25 15:50:26 CEST 2013
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10946
Bug ID: 10946
Summary: pay fine amout showing negative value
Change sponsored?: ---
Product: Koha
Version: 3.12
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Circulation
Assignee: koha-bugs at lists.koha-community.org
Reporter: prajeeshb77 at gmail.com
QA Contact: testopia at bugs.koha-community.org
CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com
Created attachment 21443
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21443&action=edit
pay fine negative amount
When paying a fine the amount tab showing (under Finetab)negative amount. when
we run the report based on the follwing SQL query the result showing negative
amounts.
SELECT
borrowers.cardnumber,borrowers.surname,accountlines.date,accountlines.amount
FROM borrowers LEFT JOIN accountlines on
(borrowers.borrowernumber=accountlines.borrowernumber)
WHERE DATE(timestamp) BETWEEN <<Added BETWEEN (yyyy-mm-dd)>> AND <<and
(yyyy-mm-dd)>> AND (accounttype='PAY')
is it the problem of Koha or in SQL query. Please help me.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list