function prepaid_invoice_remainder($order)
{
$sql = "SELECT so.total - IFNULL(SUM(inv.prep_amount),0) FROM "
.TB_PREF."sales_orders so,
function prepaid_invoice_remainder($order)
{
$sql = "SELECT so.total - IFNULL(SUM(inv.prep_amount),0) FROM "
.TB_PREF."sales_orders so,
- ".TB_PREF."debtor_trans inv
- LEFT JOIN ".TB_PREF."payment_terms pt ON inv.payment_terms=pt.terms_indicator
+ ".TB_PREF."debtor_trans inv,
+ ".TB_PREF."payment_terms pt
WHERE so.order_no=".db_escape($order)
." AND so.trans_type=".ST_SALESORDER
." AND inv.type=".ST_SALESINVOICE
." AND inv.order_=so.order_no"
WHERE so.order_no=".db_escape($order)
." AND so.trans_type=".ST_SALESORDER
." AND inv.type=".ST_SALESINVOICE
." AND inv.order_=so.order_no"