Hi folks

We've recently cut our customer credit back to 7 days for all accounts and have set this value in any active customer accounts in the Sales Ledger. I have changed the Ageing/Due Date in customer settings to reflect this as best I can, but we are still required to enter all 4 ageing periods despite anything over 7 days being overdue in our case. I had intended to break the ageing summary on our statement into a 7 Days value and an Overdue value but, as mentioned, the Ageing/Due Dates in Sage 50c don't make this straightforward

So instead I'm considering getting rid of the Ageing breakdown on the bottom of the statement, displaying the total amount due and then showing a line "Account is running x days overdue"

I would perhaps base the x days on the days passed since the oldest balance outstanding on the account

Any ideas of what I need to hit in an expression? Does Sage 50c store the age of a balance anywhere or better, how many days overdue an account is?

Thanks