web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / customer days sales ou...
Small and medium business | Business Central, N...
Answered

customer days sales outstanding report

(2) ShareShare
ReportReport
Posted on by CU13010319-0
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?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU on at
    customer days sales outstanding 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)
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla on at
    customer days sales outstanding 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.
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... on at
    customer days sales outstanding report
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet on at
    customer days sales outstanding 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. 
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans