X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_journal.inc;h=56ec39c31ab5063209cae4d34d257117af7ff485;hp=c44cb335b3328b8fd15179cecb5259439ed66d5a;hb=a3905612a65008c52315b9951010b0bef88c63cb;hpb=3a07ab5b09141aa056c2c628f4f9fec79f45e85b

diff --git a/gl/includes/db/gl_journal.inc b/gl/includes/db/gl_journal.inc
index c44cb335..56ec39c3 100644
--- a/gl/includes/db/gl_journal.inc
+++ b/gl/includes/db/gl_journal.inc
@@ -71,12 +71,10 @@ function write_cust_journal($trans_type, $trans_no, $branch_id, $date, $ref, $am
 {
 	// we have to select any branch_id for given AR_act - in fact w
 	$sql = "INSERT INTO ".TB_PREF."debtor_trans (trans_no, type, debtor_no, branch_code, tran_date, reference, ov_amount, rate)
-		SELECT "
-		.db_escape($trans_no).", ".db_escape($trans_type).", debtor_no,"
-		.db_escape($branch_id).",'".date2sql($date)."', ".db_escape($ref).","
-		.db_escape($amount).", ".db_escape($rate)."
-		FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_id);
-
+        VALUES (".db_escape($trans_no).", ".db_escape($trans_type).", 
+			(SELECT debtor_no FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_id). ") ,"
+			.db_escape($branch_id).",'".date2sql($date)."', ".db_escape($ref).","
+			.db_escape($amount).", ".db_escape($rate).")";
 	return db_query($sql, 'cannot write cust_journal');
 }