Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Customer Average Time to Pay

(0) ShareShare
ReportReport
Posted on by 5

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

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    RE: Customer Average Time to Pay

    HI Jam,

    I think you can use Customer payment prediction which gives you lot of information

  • Suggested answer
    JamesT Profile Picture
    JamesT 341 on at
    RE: Customer Average Time to Pay

    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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,259 Super User 2025 Season 1 on at
    RE: Customer Average Time to Pay

    Your best bet would be to have a Power BI report developed.  F&O is light on metrics that most accounting teams use daily.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans