X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=reporting%2Frep705.php;h=0d2c370fa833cf49b8ac127ee48a12e496c9d49c;hb=510d6e1925c4d1621ae3efd85e117cc9bb4320f0;hp=4361b6e7cea3ee10d63448dbe11a05e58e5aa958;hpb=902f1015d874c33bd7946b17de2ad80b4f2144b6;p=fa-stable.git

diff --git a/reporting/rep705.php b/reporting/rep705.php
index 4361b6e7..0d2c370f 100644
--- a/reporting/rep705.php
+++ b/reporting/rep705.php
@@ -61,10 +61,10 @@ function getPeriods($year, $account, $dimension, $dimension2)
 		   		SUM(CASE WHEN tran_date >= '$date12' AND tran_date < '$date13' THEN amount / 1000 ELSE 0 END) AS per12
     			FROM ".TB_PREF."gl_trans
 				WHERE account='$account'";
-	if ($dimension > 0)
-		$sql .= " AND dimension_id = $dimension";
-	if ($dimension2 > 0)
-		$sql .= " AND dimension2_id = $dimension2";
+	if ($dimension != 0)
+  		$sql .= " AND dimension_id = ".($dimension<0?0:db_escape($dimension));
+	if ($dimension2 != 0)
+  		$sql .= " AND dimension2_id = ".($dimension2<0?0:db_escape($dimension2));
 
 	$result = db_query($sql, "Transactions for account $account could not be calculated");