Small and medium business | Business Central, N...

How to Generate Average Collection Period Report for Customers.

(3) Share

Report

Posted on by DynamicsBC

208

Hi Community,

I’m trying to find a way to generate a report that shows the average collection period for customers in Dynamics 365 Business Central. Essentially, I want to analyze how long it takes on average for customers to pay their invoices.

Is there a built-in report or method to calculate this within BC?

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

Yes the Report called "Average Collection Period" is available in Business Central.

But for that you need to Setup the Power BI.

This Report is available in Power BI Dashboard of Business Central.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (0)

Report

Adding to below. Please see the link below for your quick report on average collection period

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-powerbi-average-collection-period

Thanks

Ramesh

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (0)

Report

Just adding some information:

Business Central 2024 wave 2 (BC25.1): Use embedded Power BI reports out of the box (In-client Power BI reports)

https://yzhums.com/57847/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (1)

Report

Please Check: https://learn.microsoft.com/en-us/dynamics365/business-central/finance-powerbi-average-collection-period

https://experience.dynamics.com/ideas/idea/?ideaid=32d0b6ae-86b3-ee11-92bd-000d3a0f8799

Was this reply helpful? Yes No