From: Janusz Dobrowolski <janusz@frontaccouting.eu>
Date: Wed, 7 Mar 2012 19:51:39 +0000 (+0100)
Subject: Fixed multiplied amounts in Journal Inquiry.
X-Git-Tag: 2.3-final~477
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=207ae289c358ff57c1adc55304a65b17a5dc4132

Fixed multiplied amounts in Journal Inquiry.
---

diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc
index fe9599af..2802c793 100644
--- a/gl/includes/db/gl_db_trans.inc
+++ b/gl/includes/db/gl_db_trans.inc
@@ -634,7 +634,7 @@ function get_sql_for_journal_inquiry($filter, $from, $to, $ref='', $memo='', $al
 	if (!$alsoclosed) {
 		$sql .= " AND gl_seq=0";
 	}
-	$sql .= " GROUP BY gl.type, gl.type_no";
+	$sql .= " GROUP BY gl.tran_date, a.gl_seq, gl.type, gl.type_no";
 	return $sql;
 }
 ?>
\ No newline at end of file