$err_msg = "Cannot insert a supplier transaction record";
db_query($sql, $err_msg);
$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_);
. TB_PREF . "bank_trans,"
. TB_PREF . "bank_accounts "
. "WHERE "
. TB_PREF . "bank_trans,"
. TB_PREF . "bank_accounts "
. "WHERE "
. "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 "
. "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 "