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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 558 Super User 2026 Season 1
Giorgio Bonacorsi 402
Diego Mancassola 261
