Sage overdue accounts report

[mjsadler]

Hello,

I'm running Sage 50, 2010, v.16.

I've got a slightly modified report which started out as the standard Customer 'Aged Debtors Analysis (Detailed)' template.

What i'd like to do is modify it so it only shows the invoices that are actually overdue according to my terms, i.e. 15 days old or more. I need a list of people I have to chase for money and it's a waste of paper having a long list of customers when half of them don't require chasing yet.

In the report i've got the categories 'Balance, Current, 15-59 days, 2+ months, 3+ months, 4+ months' which I've been able to adapt to my credit terms, but now I'd like to exclude the Current field so it just lists the categories that are 'overdue' or over 14 days.

I've found the part in the report that needs amending 'Properties, Data Source, Criteria' but now I'm stuck as I'm not sure what criteria to change.

Any help gratefully accepted.

 

[mjsadler]

Apologies for my stupidity. I was looking far too deep into how to do the reports.

Of course, the dates specified in the report are an option you get given right at the beginning! By just changing the second transaction date to 15 days ago it cuts out all the people who are still within my credit terms! Muppetry in the first degree! :redface: