How can I produce an A/R Aging report that ONLY shows customers that are delinquent?
Thanks!
You need to set your aging options on tab 2 of accounts receivable options to age by Due Date. I assume you have it set to age by invoice date now.
I think the request is to show all past due (even one day), which I don't think the stock report handles.
You have control over your aging buckets, and can set the first one to a single day if you wish.
Hi! When in AR > Reports > AR Aged Invoice Report, halfway down the page in the "options" there is a drop down "Aging Option to Print". Here you can select All Open Invoices or 30/60/90/120 Days Past Due
Unfortunately, that doesn't get me where I want to go. I'd tried that already. I just want a list of customers that are past their terms. I'm not savvy enough with Crystal Reports or I could probably create a formula to suppress anyone that is current...
Thanks though...
You need to set your aging options on tab 2 of accounts receivable options to age by Due Date. I assume you have it set to age by invoice date now.
TomTarget, I've changed the AR setting to Age by Due Date. But I still do not see how to produce an Aging report showing only past due invoices. Please help.
It gets really complicated if you want to consider the possibility of un-applied payments / CM / total customer balance, but just seeing invoices past due is not hard from raw data:
Excel query of AR_OpenInvoice for Balance <> 0. Filter based on due date.
I think the request is to show all past due (even one day), which I don't think the stock report handles.
Exactly, KevinM. And it amazes me that this is not an option as a stock report.
You have control over your aging buckets, and can set the first one to a single day if you wish.
That is a great idea! Yes - 1, 30, 60, 90 should do it. Thank you!
*Community Hub is the new name for Sage City