function getTransactions($supplier, $date)
{
    $date = date2sql($date);
    $dec = user_price_dec();

    $sql = "SELECT  supp_reference, tran_date, due_date, trans_no, type, rate,
            (ABS( ov_amount) + ABS( ov_gst) -  alloc) AS Balance,
            (ABS( ov_amount) + ABS( ov_gst) ) AS TranTotal
        FROM ".TB_PREF."supp_trans
        WHERE  supplier_id = '$supplier'
        AND ROUND(ABS( ov_amount),$dec) + ROUND(ABS( ov_gst),$dec) - 
        ROUND( alloc,$dec) != 0
        AND  tran_date <='$date'
        ORDER BY  type,
             trans_no";

    return db_query($sql, "No transactions were returned");
}

 
function getTransactions($supplier, $date)
{
    $date = date2sql($date);
    $dec = user_price_dec();

    $sql = "SELECT  reference AS supp_reference, tran_date, due_date, trans_no, type, rate,   // Here I have modified to make the reference as supp_reference
            (ABS( ov_amount) + ABS( ov_gst) -  alloc) AS Balance,
            (ABS( ov_amount) + ABS( ov_gst) ) AS TranTotal
        FROM ".TB_PREF."supp_trans
        WHERE  supplier_id = '$supplier'
        AND ROUND(ABS( ov_amount),$dec) + ROUND(ABS( ov_gst),$dec) - 
        ROUND( alloc,$dec) != 0
        AND  tran_date <='$date'
        ORDER BY tran_date,  type,   // New Order by Here with tran_date
             trans_no";

    return db_query($sql, "No transactions were returned");
}