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

Accounts Receivable - Payment History

(1) ShareShare
ReportReport
Posted on by 26
We would like to track customers average time to pay. And then we want to know if customers' average elapsed time to pay their invoices exceeds that average. So if a customer normally pays within 40 days and one of their invoices goes to 50, we have an alert or event to prompting to reach out and getting them paid up and back on track. 
 
Any idea how to structure this? 
I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    18,192 Most Valuable Professional on at
    Accounts Receivable - Payment History
  • Bharath jain Profile Picture
    1,299 Super User 2025 Season 2 on at
    Accounts Receivable - Payment History
    Hi Jack,
     
    You can use the collection letters setup to send reminders, but collection letters are based on due date.
     
    Not sure if there is any option to use average time. Lets see of anyone has any suggestions.
     
    Regards,
    Bharath Jain
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,613 Super User 2025 Season 2 on at
    Accounts Receivable - Payment History
    Have you looked at the Analytics tab in the Credit and collections workspace?  I don't have a demo environment that has the Analytics working but they may provide some insight as to how to proceed with your requirements.

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans