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
HI Jam,
I think you can use Customer payment prediction which gives you lot of information
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
Your best bet would be to have a Power BI report developed. F&O is light on metrics that most accounting teams use daily.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156