customer days sales outstanding report

(2) Share

Report

Posted on by CU13010319-0

458

on the customer card the average collection period summary statistic shows. What reports would best show the average amount of time it took to pay a invoice, per invoice, and time outstanding an invoice is due?

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

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

Like (0)

Report

Hi, For customer (Receivable), you can use Aged Accounts Receivable report.

But for Vendor (Payable), there is the following interesting feature, but as far as I know, Customer does not have it.

Business Central 2023 wave 2 (BC23): Large companies to report payment times (Payment Practices feature)

https://yzhums.com/42298/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Please run the Aged Accounts Receivable report to get information on due invoices. We currently do not have a report that shows how long it takes to pay an invoice, but you can create one by reviewing the customer ledger entries and checking the posting dates of the applied payment entries.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

Aged Accounts Receivables (report) - Business Central | Microsoft Learn

Creating An Aged Accounts Receivable Report In Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (1)

Report

What reports would best show the average amount of time it took to pay a invoice, per invoice, and time outstanding an invoice is due?

The Aged Accounts Receivable report will show the time outstanding an invoice is due. However, as this report only shows open invoices, it won't show the time it took to pay and invoice/per invoice. As far as know there's no report in the system that does this. If you have this requirement, you will need to build a custom report either in the system or using third party reporting tools such as Power BI or Jet Reports.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No