How to Customize a standard report in Dynamics Business Central SaaS

Good day to you..…

From this article, I am going to give a solution to a problem which I have seen most of forums. As all of you are aware, still we are not given any proper way to customize a standard report in Dynamics 365 Business Central SaaS version.
Here I am explaining how to create a copy of a standard report from an extension. From that you all can customize a copy of any standard report. To fulfill this scenario, there are 3 main steps.

1. Copy the standard report AL code to an extension.
2. Create a copy of the standard report layout.
3. Merge the AL code and the report layout.

1.Copy the standard report AL code to the extension.

In Business Central SaaS version, Microsoft has not facilitated us to view the base application code directly. But here I am going to copy the AL code of the standard report from the base application library. For that i have already installed the AZ AL Dev Tools/AL Code Outline tool in VS code. Using that tool I can go to the definition of the report. After copying the whole code of the report, I am pasting it in another AL file which is going to be published as a new report. For an example, here I am copying the Aged Account Receivable Report as an extension. Then change the id to 50k range and rename the report. Here I have only the AL code, so I have to find the exact layout matching with this AL code.

Ok. 1st step is done.

2.Create a copy of the standard report layout.

As all you know we can create any number of custom layouts for any report. So I am going to create a custom layout of the standard report. Here I am creating a copy from the built-in layout. Because we want the original layout of the standard report. Then using the Export Layout option i can download the layout as rdl format. Now i have both AL code and as well as the layout. Next step is explained how to merge these two files.
















3.Merge the AL code and the report layout.

When we are creating a report as an extension we can define the path of the layout file in AL code. So i am mapping the downloaded rdl file as the layout of this report. Using Ctr + B, build the object. Now I have an exact copy of the standard report with its all functionalities. Now I can do any modification I want.





Hope this will help you.
Please provide your feedback with a comment.
Thank you and Regards,

Chameera Kavinda

Dynamics NAV Idle Time Setup (Windows Client)

Dynamics NAV Idle Time Setup (Windows Client)

Hi Everyone,

Today we will demonstrate you, how to set idle time in Dynamics NAV for windows client. 

As we all understand, most of the companies need a cost effective ERP solution today and the number of license purchased by the company can be very limited. 

If any user has logged in to the system but doesn't do any work, another user will not be able to work because Dynamics NAV will give an error restricting the user log in as all licenses are in use at that time.

So the solution for this issue is setting up a maximum idle time for the client. Therefore, if any user is logged in but not using the system, the system will automatically end the session of the user.


The first step is to open Dynamics NAV 2017 Administration.

Then you have to select the instance that is been used currently.

The go to the client services tab --> idle time out --> Edit

Type the time out in following format (hh:mm:ss) > Save

Example: For a time out after 15 mins of idle time, you have to set the time as below,

Once the time is set, select the server and restart the server (By clicking right button of the mouse)

Thank you.

Have a good day. 😊

Thil.

SQL Authentication on Microsoft NAV Server Instance

SQL Authentication on Microsoft NAV Server Instance

Hi Allllll,

This topic describes how to configure SQL Authentication on Microsoft NAV Server Instance using Microsoft Dynamics NAV Server Administration tool.
When using SQL Server authentication, Dynamics NAV requires an encryption key to encrypt the credentials(Username and password) that the Microsoft Dynamics NAV Server instance uses to connect to the Dynamics NAV database in SQL Server. The encryption key must be installed on the computer where the Microsoft Dynamics NAV Server is installed and also in the database in SQL Server.

To do that, first you must delete the existing key file, if any. Here I am going to configure SQL authentication for the “DynamicsNAV101” instance.

1. Go to the following path and delete the relevant key file. (Here, ProgramData is a hidden folder).

C:\ProgramData\Microsoft\Microsoft Dynamics NAV\100\Server\Keys

2.     Open the Microsoft Dynamics NAV Server Administration tool.

click Start, enter Microsoft Dynamics NAV Administration in the Search textbox, and then choose the related link.

3. In the console tree, which is in the left pane, expand the node for the computer that contains the Microsoft Dynamics NAV Server instance, and then select the Microsoft Dynamics NAV Server instance.    

4. In the Actions pane, choose Database Credentials.

       5. On the Database Credentials page, click the Edit button.

6. Set the Database Authentication Mode to SQL Server Authentication.
7. In the Database User Name field, type the login name for the database user that you want to use to access the Microsoft Dynamics NAV application database in SQL Server.
8.  In the Password field, type the login password for the database user that you want to use to access the Microsoft Dynamics NAV database in SQL Server.

Add caption

      9. Click Save button, and then click OK button on the Enable Encryption on SQL Server Connections dialog box.

   10. On the Information dialog box about encryption, again click OK button.

11. Click the root of the console tree, which is in the left pane.

12.If the instance is  stopped, then Start it. If the instance is running then Restart it. Also make sure that the server instance is in the Running status all the time.

Thank you.
Chameera