Our issue is regarding the Aged Debtors reports - and specifically the ageing...

Our issue is regarding the Aged Debtors reports - and specifically the ageing. We have a customer who is set up with 60DEOM terms - the "credit control" section of this customer reads, "Payment Due: 60" "Payment Due From: Days from the first day of the following month". When you pull the activity report for this customer and filter by O/S only - there are invoices that state a due date of 30/09/2021 that the report is putting into Period 2 - because the invoices were created in June 2021.

This is because in settings and customer defaults the ageing it is set by period - but TBH no matter which option you choose in that area - it does not change the outcome.

So in short - you are able to amend the credit terms for a customer but this does not impact the debtor report - and it will always report incorrectly for those customers who are not on standard terms?!?!?!

This feels fairly basic to me - instead of ageing against invoice date they could use due date? I asked if my issue would be passed to development and was advised it wouldn't and that this was a system limitation??!?!

Anyone else had a similar issue and have a resolution for it? TIA.

Sage Query.xlsx

Parents Reply Children