Hello - does anyone know of a way to only produce month end AR statements that include invoices that are 30+ days old? If everything for a customer is current, don't even produce a statement. And/Or if there are invoices past due, leave off anything that is current.
You're correct that Aging Buckets are typically defined in Receivables → Statement Cycles in Acumatica. I apologize for the confusion. Let me clarify how you can achieve your goal using Acumatica's existing functionality, and yes, I do indeed mean customizing the AR Statement report via Report Designer for the specific filtering you're looking for.
First, you’ll need to configure your Aging Buckets to categorize invoices that are 30+ days past due. This allows you to filter and isolate the overdue invoices when generating AR statements.
Navigate to: Finance → Accounts Receivable → Aging.
Configure the aging buckets (e.g., 0-30, 31-60, 61-90, etc.) based on your business's requirements. Make sure the 30+ days bucket is included.
AR Statements can be customized to include only overdue invoices based on the aging buckets you've set up. The key is to generate statements using an aging filter so that only the invoices that are past due by 30 days or more are included in the statement.
Navigate to: Finance → Accounts Receivable → AR Statements.
When setting up your AR Statement, ensure that you:
Set the Statement Type to "Aging".
Select the Date Range for the statement (e.g., "As of the end of the month").
Choose the Aging Period to ensure only past-due invoices (such as those 30+ days overdue) are included.
Aging Filter: Ensure the aging filter is configured so that invoices 30+ days overdue are selected, and invoices that are still current (within payment terms) are excluded from the report.
I believe the aging buckets are defined in the Receivables → Statement Cycles.
I don’t find what you are referring to “Set the Statement Type to "Aging".” or an Aging Filter. Do you mean modify the Statement report via report designer?
You're correct that Aging Buckets are typically defined in Receivables → Statement Cycles in Acumatica. I apologize for the confusion. Let me clarify how you can achieve your goal using Acumatica's existing functionality, and yes, I do indeed mean customizing the AR Statement report via Report Designer for the specific filtering you're looking for.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.