Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Emailing of reports on...
Small and medium business | Business Central, N...
Suggested answer

Emailing of reports on a scheduled basis

(1) ShareShare
ReportReport
Posted on by SG-18090638-0 2
Hi all! I've been doing hours upon hours of research and simply can't find a way to scheduled reports that are then emailed to certain users. 
 
For example - once a week, I would like an Aged Accounts Receivable report to run and email to our accounts receivable clerk. 
 
I have found videos relating to scheduling reports, however these only run to the Report Inbox within Business Central and as it appears, no 'working' solution to get them from there to email.
 
I've been looking into Power Automate, but can't seem to action a report to run. 
 
Would Jet Reports or Power BI be a way to action this? 
 
Any help would be GREATLY appreciated! 😊
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 4,744 on at
    Emailing of reports on a scheduled basis
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,450 Super User 2024 Season 2 on at
    Emailing of reports on a scheduled basis
    Hello,
     
    The standard schedule email cannot generate the report with a dynamic period.
    If you want the schedule email function to send to email instead of Report Inbox, you can refer to this youtube guide.
    https://www.youtube.com/watch?v=m4r8hFRTKFc
     
    JetReports and PowerBi are mainly used as financial dashboard/analytics.
     
    You can take a look at the AppSource for this solution.
     
    Otherwise, I have one app created for this purpose.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans