From a3905612a65008c52315b9951010b0bef88c63cb Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sun, 8 Aug 2021 12:29:42 +0200 Subject: [PATCH] Bug in gl/includes/db/gl_journal.inc. Fixed by @barbarian. --- gl/includes/db/gl_journal.inc | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) 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'); } -- 2.30.2