Statement ageing incorrect
Ageing report shows:
Statement shows:
This has only recently started happening again, no changes to set up for any customers.
Forum Discussion
Hi Tim4,
Thanks for posting your concern in the forum.
I'm sorry to hear about your difficulties with your invoice ageing data. Generally, any issue with ageing comes from how the invoice terms are set. I recommend checking the terms for the invoice, as the due dates could have been changed. If the issue persists after making sure everything is correct, feel free to send us a screenshot of the following.
- Reports & Forms Preferences (Setup > Preferences).
- One of the customer's selling details tab.
- One of that customer's invoices.
- A copy of the report showing the customer's name and ageing value.
Let us know if you require any other assistance.
Thanks,
GenreveHi Tim4,
Thanks for responding. We appreciate the effort in attaching these screenshots.In my understanding, since the example invoice was dated 3/11/2023, it is supposed to be due on 30/12/2023. This is also what the screenshots suggest. May I know what we are trying to achieve with these values?
We look forward to your response.
Thanks,
Genreve
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).
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
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.
