Notifications
Announcements
No record found.
I am looking for a report that will show the Customer account No, Customer Name and Average Time to Pay e.g. -
CUS0001 Customer 1 33 days
Is that possible in D365 F&O
Any help would be appreciated.
Kind regards,
Jam
Your best bet would be to have a Power BI report developed. F&O is light on metrics that most accounting teams use daily.
Hi Jamie
The Credit and Collections module does provide for a calculation of AVERAGE PAYMENT DAYS.
learn.microsoft.com/.../cm-periodic-tasks
However the downside is that last time I checked there is no option, be it report or data entity to export this information.
So what we did for a previous client was have a data entity created that provided for the export of this data (modification required)
Regards
James
HI Jam,
I think you can use Customer payment prediction which gives you lot of information
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
