FrontAccounting forum — Supplier Transaction Inquiry for GRN

Re: Supplier Transaction Inquiry for GRN

null@example.com (seahawk) — Mon, 14 Jan 2019 14:39:35 +0000

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

null@example.com (seahawk) — Mon, 14 Jan 2019 12:17:18 +0000

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

null@example.com (seahawk) — Mon, 14 Jan 2019 11:42:36 +0000

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

Re: Supplier Transaction Inquiry for GRN

null@example.com (apmuthu) — Wed, 09 Jan 2019 08:46:58 +0000

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

Re: Supplier Transaction Inquiry for GRN

null@example.com (kanay) — Tue, 08 Jan 2019 22:16:16 +0000

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

null@example.com (joe) — Wed, 02 Jan 2019 08:16:39 +0000

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

null@example.com (notrinos) — Wed, 02 Jan 2019 06:46:01 +0000

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

null@example.com (kanay) — Wed, 02 Jan 2019 04:21:47 +0000

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.