1 Topic by MarkAndrew (edited by MarkAndrew 02/19/2015 12:50:52 pm)

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Topic: Bug in customer aging

I noticed the following:

When I process a customer payment with today's date it appears in the customer aged analysis in the 30 day column and not the current column.

Tried several times with same result.

Then I processed a customer payment with last month's date.  Instead of showing in the 30 day column in the customer aged analysis it showed in the 60 day column.

Did same test with a payment to supplier with same results as above.

Conclusion: it looks like customer / supplier payments are shown on the customer/supplier aged analysis one aging column too old which means customer/supplier aged analysis report is not always reliable. A fix is needed.

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

Re: Bug in customer aging

Yes, there were a 1 day failure in the aging routines. These errors have been here for 8 years wink.

Well, not a serious bug perhaps, but as you say Mark, quite annoying.

The HG repo for 2.3.23 will be updated asap. If you can't wait you can download:

/reporting/rep.102.php1 and /reporting/rep202.php1. Rename the files to .php.

/sales/includes/db/customers_db.inc and /purchasing/includes/db/suppliers_db.inc.

And replace the files.

/Joe

Post's attachments

customers_db.inc 6.8 kb, 2 downloads since 2015-02-20 

rep102.php1 9.6 kb, 2 downloads since 2015-02-20 

rep202.php1 9.8 kb, 1 downloads since 2015-02-20 

suppliers_db.inc 6.5 kb, 1 downloads since 2015-02-20 

You don't have the permssions to download the attachments of this post.
  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Bug in customer aging

Thanks Joe
Appreciated as always.
Reports that are generated with wrong info is serious as we make decisions based on reports from Front.
Glad it's fixed after 8 yrs!
Mark