Would like to set up a Gridview Report that would list all the AR Customers and tell me who has invoices that are dated back 30 days and more. Can anyone tell me how to set up the filter?

Hi Gail

There's a standard report that does that. It's called the Overdue Receivables report - you can print it in summary (one line per customer) or in detail (one line per transaction).

Just select "Number of Days" as one of the Sort By fields, and enter 30 in the starting field and 9999 in the ending field.

Steve

Hi Gail,

You cn also use the Calculate Customer Aging function and create a Filter to list only the overdue customers. This function can be run every time you start Receivables so that the aging is always up to date.