• From: Singapore
  • Registered: 09/23/2012
  • Posts: 17

Topic: Supplier Transaction Inquiry for GRN

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.

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Re: Supplier Transaction Inquiry for GRN

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'";
Phuong

notrinos's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Supplier Transaction Inquiry for GRN

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

The fixed file can be downloaded here.

/Joe

  • From: Singapore
  • Registered: 09/23/2012
  • Posts: 17

Re: Supplier Transaction Inquiry for GRN

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).

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Supplier Transaction Inquiry for GRN

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

apmuthu's Website

  • From: South Africa
  • Registered: 11/24/2009
  • Posts: 275

Re: Supplier Transaction Inquiry for GRN

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

Wynand

seahawk's Website

  • From: South Africa
  • Registered: 11/24/2009
  • Posts: 275

Re: Supplier Transaction Inquiry for GRN

The Purchases/ Inquiries and reports/ supplier transaction inquiry/

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

Wynand

seahawk's Website

  • From: South Africa
  • Registered: 11/24/2009
  • Posts: 275

Re: Supplier Transaction Inquiry for GRN

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

Wynand

seahawk's Website