Skip to main content

Notifications

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

Emailing of reports on a scheduled basis

Posted on by 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:
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 3,952 on at
    Emailing of reports on a scheduled basis
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 1,007 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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans