Finance | Project Operations, Human Resources, ...

Accounts Receivable - Payment History

(1) Share

Report

Posted on by JackBurton07

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 (3)

Answers (0)

Sort by

Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.
Bharath jain 1,584 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

BillurSamdancioglu 21,414 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please check this link below:

https://learn.microsoft.com/en-us/dynamics365/finance/accounts-receivable/payment-insights-overview