Hello @joe,
This post is for the @joe and @apmuthu to update their repo.
gl/includes/db/gl_journal.inc
Here there is a function for update_journal
function update_journal($type, $trans_no, $amount, $tran_date, $currency, $reference, $source_ref='', $rate=1,
$event_date='', $doc_date='')
{
$sql = "UPDATE ".TB_PREF."journal SET "
."`amount`=".db_escape($amount).","
."`currency`=".db_escape($currency).","
."`rate`=".db_escape($rate).","
."`reference`=".db_escape($reference).","
."`source_ref`=".db_escape($source_ref).","
."`tran_date`="."'".date2sql($tran_date)."',"
."`event_date`="."'".date2sql($event_date)."',"
."`doc_date`="."'".date2sql($doc_date)."') // here the '(' should be removed.
WHERE `type`=".db_escape($type)." AND " ."`trans_no`=".db_escape($trans_no);
return db_query($sql, 'cannot update journal entry');
}