ov_freight=".db_escape($Freight).", ov_freight_tax=$FreightTax, rate=$rate,
ship_via=".db_escape($ship_via).", alloc=$AllocAmt,
dimension_id=".db_escape($dimension_id).", dimension2_id=".db_escape($dimension2_id).",
- payment_terms=".db_escape($payment_terms).",
+ payment_terms=".db_escape($payment_terms, true).",
tax_included=".db_escape($tax_included)."
prep_amount =".db_escape($prep_amount)."
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type);
//----------------------------------------------------------------------------------------
-function get_customer_trans_from_ref($type, $ref)
-{
- $sql = "SELECT trans_no FROM ".TB_PREF."debtor_trans WHERE type=".db_escape($type)."
- AND reference=".db_escape($ref);
-
- $result = db_query($sql, "Cannot retreive a debtor transaction");
-
- $row = db_fetch_row($result);
- return $row[0];
-}
-
-//----------------------------------------------------------------------------------------
-
// retreives the related sales order for a given trans
function get_customer_trans_order($type, $type_no)