FrontAccounting forum — Supplier Transaction Inquiry for GRN

Re: Supplier Transaction Inquiry for GRN

2019-01-14T14:39:35Z

seahawk wrote:

The Purchases/ Inquiries and reports/ supplier transaction inquiry/
It only shows Purchase Order Delivery and nothing else for the supplier.

This was resolved with the above change to the supp_trans_db.inc.

Thanks

Re: Supplier Transaction Inquiry for GRN

2019-01-14T12:17:18Z

The Purchases/ Inquiries and reports/ supplier transaction inquiry/

It only shows Purchase Order Delivery and nothing else for the supplier.

Re: Supplier Transaction Inquiry for GRN

2019-01-14T11:42:36Z

Had the same issue with Supplier Tax Invoices that did not show, but this fixed it.

Re: Supplier Transaction Inquiry for GRN

2019-01-09T08:46:58Z

https://www.w3schools.com/php/default.asp

Re: Supplier Transaction Inquiry for GRN

2019-01-08T22:16:16Z

Noted with thanks.

I think I might make an effort to pick up PHP skills.

Please give some suggestions on what is a good starting point (book or website) for someone to learn PHP and MySQL for web applications (especially ERP applications).

Re: Supplier Transaction Inquiry for GRN

2019-01-02T08:16:39Z

This has been fixed and committed to stable repo. Thanks @notrinos.

The fixed file can be downloaded here.

/Joe

Re: Supplier Transaction Inquiry for GRN

2019-01-02T06:46:01Z

Yes @kanay
This bug can be fixed by adding this code to below the line 260 of supp_trans_db.inc

$sql2 .= " AND trans.delivery_date >= '$date_after'
            AND trans.delivery_date <= '$date_to'";

Supplier Transaction Inquiry for GRN

2019-01-02T04:21:47Z

To the Development Team,

The Supplier Transaction Inquiry for GRN does not filter the results by date range. Instead it shows all the GRN inside the database.

Supplier Transaction Inquiry for Supplier Invoices and Supplier Payments are working okay.

Many thanks for looking into this possible bug.