Re: Supplier Payment Report rep203

null@example.com (kvvaradha) — Wed, 18 Mar 2020 10:23:22 +0000

Good to hear it.

Re: Supplier Payment Report rep203

null@example.com (rafat) — Wed, 18 Mar 2020 10:16:41 +0000

Thanks @kvvaradha

It works..as attached.

Re: Supplier Payment Report rep203

null@example.com (kvvaradha) — Wed, 18 Mar 2020 09:50:00 +0000

Within the rep203.php file. you need to change something to get it.

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");
}

Here you need to add some changes.

 
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");
}

Supplier Payment Report rep203

null@example.com (rafat) — Wed, 18 Mar 2020 05:01:49 +0000

Supplier Payment Report rep203 has two things that seem not correct; (to me at least).

1. Transaction # is showing Supplier Reference Instead.
2. Not sorted by date.. (a more logical display of info)... its sorted by some internal choice I guess

How can one correct the above?

As attached.

FrontAccounting forum — Supplier Payment Report rep203

Re: Supplier Payment Report rep203

Re: Supplier Payment Report rep203

Re: Supplier Payment Report rep203

Supplier Payment Report rep203