web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

can i send statements to accounts with outstanding invoices in current period only?

(0) ShareShare
ReportReport
Posted on by 5

We are currently sending statements to our clients. these are only produced for accounts with invoices older than 30 days at statement date. I would like to send statements to clients who have invoices outstanding, independently of the age.

for example, on the 1st day of august, i would like to send statements to everyone, even if their invoices were processed on 31 July and even if this is the only outstanding invoice on their account.

is this possible and where would I find the settings for this please?

Categories:
I have the same question (0)
  • Suggested answer
    Lucas Reuss Profile Picture
    on at
    RE: can i send statements to accounts with outstanding invoices in current period only?

    Hello and thank you for your post:

    The default Report Writer Statement in combination with the Date to Print selected in the Print Receivables Statements should allow you to print statements for customers with invoices in their "Current" bucket.  You are likely using a different setting in the Date to Print option in the Print Receivables Statements window that is controlling this.  You might also be using a Modified Report that has removed the Current Aging bucket from the report.  I have included a screenshot below of what the report looks like by default, using the default version of the RM Statement on Blank Paper from the Fabrikam company.  I used a Date to Print of 4/1/2027, when my current system date for Fabrikam is 4/12/2027.  I did summarize the data from before that particular date as well, just to be able to show the whole report for this Customer.

    As you can see in the screenshot, the report shows Invoices and Payments from the period that I ran the report for, even though they are not 30 days old.  These transactions add up into the Current aging bucket at the bottom of the report.

    RM-Statement.png

    Please let me know if that helps to explain how the RM Statements work!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 775 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 634 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 622 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans