SageForum for UK versions of Sage 50- Help and support.

Hi,

My boss asked me if I can produce a report for him showing Outstanding Sales Invoices Over 60 days. Invoices Over 6 Months are shown in Customer Reports / Customer Inv. Reports / Outstanding Sales, but not over 60 days. Is it possible to design it somehow? or perhaps to enter a Settlement date so it will show on some report? I'm using Sage 12.01.0034.

Thank you

Lots of questions.

There is a due date on each transaction, this is calculated using the "due days" when the invoice is entered onto the ledger.

The ageing of the customer ledger is flexible.
I suggest that the best way to do this is to set one of the ageing periods to be 60 days. You can then use a search to find customers with balances over 60 days and run a report like the detailed aged debtors to show the invoices.

You could also alter the aged debtors detailed report to only show items over 60 days.

Have a look at the credit control letters guide to see how you can mix and match reporting and reports so that you can use a generic report with a custom record selection.

http://sage.support.makingithappen.co.u ... ditLetters