- supp.credit_limit - Sum((ov_amount + ov_gst + ov_discount)) as cur_credit, curr_code
- FROM ".TB_PREF."suppliers supp LEFT JOIN "
- .TB_PREF."supp_trans trans ON supp.supplier_id = trans.supplier_id, "
- .TB_PREF."payment_terms terms, "
- .TB_PREF."tax_groups tax_group
- WHERE supp.tax_group_id = tax_group.id
- AND supp.payment_terms=terms.terms_indicator
- AND supp.supplier_id = ".db_escape($supplier_id)." GROUP BY supp.supp_name";
+ supp.credit_limit - Sum((ov_amount + ov_gst + ov_discount)) as cur_credit,
+ supp.curr_code,
+ terms.*
+ FROM ".TB_PREF."suppliers supp
+ LEFT JOIN ".TB_PREF."supp_trans trans ON supp.supplier_id = trans.supplier_id
+ LEFT JOIN ".TB_PREF."payment_terms terms ON supp.payment_terms=terms.id
+ LEFT JOIN ".TB_PREF."tax_groups tax_group ON supp.tax_group_id = tax_group.id
+ WHERE supp.supplier_id = ".db_escape($supplier_id);