$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 "
else {
$sql .= " AND trans.tran_date >= '$date_after'
AND trans.tran_date <= '$date_to'";
+ $sql2 .= " AND trans.delivery_date >= '$date_after'
+ AND trans.delivery_date <= '$date_to'";
}
if ($supplier_id != ALL_TEXT) {
{
$sql .= " AND trans.type = ".ST_SUPPCREDIT." ";
}
+ elseif (($filter == '7'))
+ {
+ $sql .= " AND trans.type = ".ST_JOURNAL." ";
+ }
if (($filter == '2') || ($filter == '5'))
{