News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Accounts Receivable - ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Accounts Receivable - Payment History

(1) Share

Report

Report

Posted on by JackBurton07

24

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?

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

BillurSamdancioglu 15,791 Most Valuable Professional on at

Like (0)

Report

Accounts Receivable - Payment History

Please check this link below:

https://learn.microsoft.com/en-us/dynamics365/finance/accounts-receivable/payment-insights-overview
Bharath jain 800 on at

Like (0)

Report

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... 4,034 Super User 2024 Season 2 on at

Like (1)

Report

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans