$err_msg = "Cannot insert a supplier transaction record";
db_query($sql, $err_msg);
- add_audit_trail($type, $trans_no, $date_);
+ if ($type != ST_JOURNAL && $type != ST_BANKDEPOSIT && $type != ST_BANKPAYMENT)
+ add_audit_trail($type, $trans_no, $date_);
return $trans_no;
}
. TB_PREF . "bank_trans,"
. TB_PREF . "bank_accounts "
. "WHERE "
- . TB_PREF . "supp_trans.supplier_id=" . $supplier_id . " "
+ . TB_PREF . "supp_trans.supplier_id='" . $supplier_id . "' "
. "AND " . TB_PREF . "supp_trans.tran_date<'" . $date . "' "
. "AND " . TB_PREF . "supp_trans.type=" . ST_SUPPAYMENT . " "
. "AND " . TB_PREF . "supp_trans.trans_no=" . TB_PREF . "bank_trans.trans_no "
{
$sql .= " AND trans.type = ".ST_SUPPCREDIT." ";
}
+ elseif (($filter == '7'))
+ {
+ $sql .= " AND trans.type = ".ST_JOURNAL." ";
+ }
if (($filter == '2') || ($filter == '5'))
{