How to setup scheduled reports in Dynamics 365 Business Central

Modified on Wed, 23 Aug 2023 at 12:11 PM


This is an out-of-the-box functionality that Mircosoft offers to setup scheduled reports in Business central. For example, if you wish to schedule Financial Report. Go to Chart of Accounts >> Reports >> Other >> Financial Reports.

 

https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTUxMDM0NTk2NDk0LCJkb21haW4iOiJ0YW5naWNsb3VkLmZyZXNoZGVzay5jb20iLCJhY2NvdW50X2lkIjoyNTgwNTIyfQ._WY-WPfxf9aUj83YhitW81qKeKNmt4Kt8LvyFkkIiPU

 

>> The report filter pane will open, Insert the filters and click on the Send To button. 

 

https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTUxMDM0NTk2OTAxLCJkb21haW4iOiJ0YW5naWNsb3VkLmZyZXNoZGVzay5jb20iLCJhY2NvdW50X2lkIjoyNTgwNTIyfQ.xgd4p42s0rokx0XImx78BQHyyO0YODJL5BKuZ5uBvkM

 

>> The system will ask you to choose a file, click on the Schedule... 

https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTUxMDM0NTk3MTgxLCJkb21haW4iOiJ0YW5naWNsb3VkLmZyZXNoZGVzay5jb20iLCJhY2NvdW50X2lkIjoyNTgwNTIyfQ.GdCVWRgb9UTX9lJgCSs2haUUI7lHlB6n5wlyZaJx1RA

 

>> Click on the OK button. Schedule a Report page will open. 

 

https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTUxMDM0NTk3MzAwLCJkb21haW4iOiJ0YW5naWNsb3VkLmZyZXNoZGVzay5jb20iLCJhY2NvdW50X2lkIjoyNTgwNTIyfQ.etB-HQRty9gpx0hDSqApSAY5eiW0irrg6kZeCKbGwc0

>> Insert the values, for example, see the image below: 


Fields description: 

  1. Report Output Type: This is a drop-down field and you can choose which format you want your report PDF, Word, Excel, or Print. 
  2. Next Run Date Formula: Describe when this report should run for example 1D, the report will run on the interval of 1 day. Date Formula
  3. Earliest Start Date and Expiration Date: Insert the date and time for both Sart and expiration date. 

 

When done click on the OK button.

 

https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTUxMDM0NTk3NzE3LCJkb21haW4iOiJ0YW5naWNsb3VkLmZyZXNoZGVzay5jb20iLCJhY2NvdW50X2lkIjoyNTgwNTIyfQ.HkGaaKf2qlKcq7aYu6et-4K3Sw4nlMC-T12eBik1-jc

>> When done click on the OK button.

 

>> The schedule will be done and you will be able to see the reports in the report inbox list page.

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article