12 Jul’19

Dynamics NAVHow to Run Reports When Report Processing Takes Long to Cause Session Time-Out

Microsoft Dynamics Nav Integration is one of the most popular ERP systems that a lot of companies are using. So many of them have benefited by using this particular software. Especially small and medium-sized companies love this software as it helps them to plan the resources carefully. Installing this software is not a difficult task. Retailers can easily integrate it with other solutions that they are using.

Microsoft Dynamics Nav Inventory Management will help companies keep track of the materials they have in their warehouse. It helps them to plan their purchase, sales and the discounts that they offer to their customers carefully. Here are quick bits of how you can pick the reports easily even when the system is taking too long to process your request.

Introduction:

I’ve observed that when NAV is used for a very long time, the report which needs heavy processing takes long enough to cause Session Time-out. So, fetching reports becomes tedious by manually querying the table.

Pre-requisites:

Microsoft Dynamics NAV, Microsoft Dynamics Business Central

Solution:
The solution is simple, export the Report as an Excel or PDF depending on the data and send Email to the User as an attachment after the processing is complete. Code:
1. Create the Report in Excel Using Excel Buffer.

2. Export the Excel Buffer contents to an XLSX file.

3. Email the Exported Files to appropriate User. In this case, I have hardcoded the user email to my email.

Output:

OutPut
Exporting Progress of Excel Worksheet

 

Exporting Progress of Excel Worksheet
Exported Intermediate file to be emailed
Email received after the report is completely exported.
Email received after the report is completely exported.

Conclusion:
Thus adding a piece of code to send email to the User, can save a lot of hassle. In Business Central, however, it is not possible to modify an existing report. So, you need to export the existing report and merge it in AL using Text-To-Al.

Written by

Olister Rumao

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Time zone Conversion from Microsoft D365 for SSRS Reporting

    6 November’ 2019

    Introduction: Converting Date/Time values according to a time zone is quite challenging task in SSRS Reporting. For D365...

    Read more
  • How to Synchronize Office 365 and Zoho People?

    4 November’ 2019

    If your organization is using Zoho People and Office 365, you will find this article very useful. In this article we are...

    Read more
  • Check Plugin Timeout issues using Tracing in D365 CE

    31 October’ 2019

    In Dynamics plugin implementations, you might have lengthy complex plugins that makes calls to Dynamics several times. I...

    Read more
  • Embed Secure Power BI report using Python Web Application with Flask in Visual Studio 2015

    31 October’ 2019

    In this article, we will embed a Power BI report in a python web application with flask in visual studio 2015. Following...

    Read more
  • Automate sending of Survey (Recurring) – Microsoft Forms Pro

    28 October’ 2019

    You might be having some requirements for automatically sending Microsoft Forms survey in recurrence like there might be...

    Read more