Statement ageing incorrect

Question

Ageing report shows:

Statement shows:

This has only recently started happening again, no changes to set up for any customers.

Trushka · Answer

Hi

I found another factor with aging - we run recurring invoices for a few hundred customers.  It appears if the terms were incorrect when the recurring was set up this overrules the card. If you fix the recurring (see Terms on top bar) this corrects future sales.  I think you need to go into previous invoices and fix the terms there too, again top bar on my invoice (if they are unpaid and you want the statement to make sense).

Trushka · Answer

Also, it appears that even if your terms are payment by 20th of the next month statement will only age an invoice not paid unless you date the statement criteria as the 1st of the next month.

Trushka · Answer

Hi

I have spent an enormous number of hours looking at statement aging - this is what I think:

* we have both commercial 20th next month and residential 7 day customers
* some customers have been set up with the wrong terms
* when you change the terms it does NOT correct invoices created at the time the terms were wrong EVEN IF YOU DELETE AND RE-ENTER THE INVOICES!!
* this tells me the terms are tied by date to the customer card
* new invoices entered after the date has changed - OK!:-)
* you could create a new customer card, with correct terms and renter invoices (and merge to copy history) - this may work. Haven't tied this
* however if you are like us and have thousands of customers we have decided to correct terms and wait the aging cycle out

Hope this saves someone else hours and hours and consultant costs