'$%.2f outstanding balance',
];
}
- $count_query .= " FROM cust_bill $join_cust_main WHERE $extra_sql";
+ $count_query .= " FROM cust_bill $join_cust_main $extra_sql";
$sql_query = {
'table' => 'cust_bill',
FS::cust_bill->owed_sql. ' AS owed',
FS::cust_bill->net_sql. ' AS net',
),
- 'extra_sql' => "$extra_sql $orderby"
+ 'extra_sql' => $extra_sql,
+ 'order_by' => $orderby,
};
}
</SCRIPT>';
my $menubar = [
- 'Main menu' => $p,
'Print these invoices' =>
"javascript:confirm_print_process()",
'Email these invoices' =>