X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_trans.inc;h=911fd58a6abcfd45680aede7d60397ee2b70118f;hb=37f4a02e0f4bea58e5b2097d583bf9395ffc515f;hp=d2e766ad8dc4c59ca0826e36d9897466f87a0e33;hpb=97023f8706bb7149c62ca49eaec123cca3c51fa0;p=fa-stable.git

diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc
index d2e766ad..911fd58a 100644
--- a/gl/includes/db/gl_db_trans.inc
+++ b/gl/includes/db/gl_db_trans.inc
@@ -167,7 +167,7 @@ function get_budget_trans_from_to($from_date, $to_date, $account, $dimension=0,
 	$to = date2sql($to_date);
 	
 	$sql = "SELECT SUM(amount) FROM ".TB_PREF."budget_trans
-		WHERE account=$account ";
+		WHERE account='$account' ";
 	if ($from_date != "")	
 		$sql .= " AND tran_date >= '$from' ";
 	if ($to_date != "")	
@@ -214,8 +214,9 @@ function add_journal_entries($items, $date_, $ref, $reverse, $memo_=null)
 	if ($reverse) 
 	{
 
-    	$reversingDate = date(user_date_display(),
-    		Mktime(0,0,0,get_month($date_)+1,1,get_year($date_)));
+    	//$reversingDate = date(user_date_display(),
+    	//	Mktime(0,0,0,get_month($date_)+1,1,get_year($date_)));
+    	$reversingDate = begin_month(add_months($date_, 1));
 
     	$trans_id_reverse = get_next_trans_no($trans_type);