- $sql = "UPDATE ".TB_PREF."debtors_master SET name=" . db_escape($_POST['CustName']) . ",
- address=".db_escape($_POST['address']) . ",
- tax_id=".db_escape($_POST['tax_id']) . ",
- curr_code=".db_escape($_POST['curr_code']) . ",
- email=".db_escape($_POST['email']) . ",
- dimension_id=".db_escape($_POST['dimension_id']) . ",
- dimension2_id=".db_escape($_POST['dimension2_id']) . ",
- credit_status=".db_escape($_POST['credit_status']) . ",
- payment_terms=".db_escape($_POST['payment_terms']) . ",
- discount=" . input_num('discount') / 100 . ",
- pymt_discount=" . input_num('pymt_discount') / 100 . ",
- credit_limit=" . input_num('credit_limit') . ",
- sales_type = ".db_escape($_POST['sales_type']) . "
- WHERE debtor_no = '". $_POST['customer_id'] . "'";
-
- db_query($sql,"The customer could not be updated");
+ update_record_status($_POST['customer_id'], $_POST['inactive'],
+ 'debtors_master', 'debtor_no');
+
+ $Ajax->activate('customer_id'); // in case of status change