Skip to main content
Solved

AR Statement only for 30+ days past due

  • December 5, 2024
  • 3 replies
  • 77 views

debbiereed72
Jr Varsity III
Forum|alt.badge.img

 

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.

 

Thanks

Best answer by NageswaraRaoAddanki60

Hello ​@debbiereed72,

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.

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img

Hi ​@debbiereed72,

You can try this, I think it’s helps 

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:
    FinanceAccounts ReceivableAging.
  • 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:
    FinanceAccounts ReceivableAR 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.

debbiereed72
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 95 replies
  • December 5, 2024

Hi ​@NageswaraRaoAddanki60 - I appreciate the response.

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?


Forum|alt.badge.img

Hello ​@debbiereed72,

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings