Skip to main content

Posts

Showing posts from 2021

Create New User and assign Permission Sets : Using Business Central Administration shell

Hi Folks, In this blog we will see how we can create new users and assigning permission sets using Business Central Administration shell  step by step:- Step-(1) Run Business central Administration Shell as Run as Administrator. Step-(2) Then just Run the below mentioned command and pass unique Windows account tagged with BC user and Server instance as shown below: new-navserveruser Step-(3) New user (Kunal Blog) with blank permission set is now created as shown below: Step-(4) Now Run the below command to assign permission sets and pass the PermissionSetId , WindowsAccount & ServerInstance as parameter: New-NavServerUserPermissionSet Step-(5) Permission Set Id is now assigned as shown in User Permission Sets tab : Note- (1) Pass the correct parameters as Windows Account  &  Server Instance based on your config. (2) We can also create the same using PowerShell ISE. I hope this will help you to create new users & assign Permission sets in Business Cen...

Adding Bullets in SSRS Report : Using HTML Expr in RDLC Report

Hi  Readers, In this article we will see how we can add the bullets or add multiple HTML styles using HTML Expression in the RDLC report. In this example the client requirement is just to add bullet points of attached annexures in RDLC Report: Step-(1) Firstly, create a Placeholder then add Expression value in placeholder properties and makesure to select HTML - Interpret HTML tags as style option in Markup type . Step-(2) Expression value should be like this: Here, if the Delivery Schedule Boolean is true on request page then it will print Delivery Schedule in bullet points form: =IIF(Fields!Annexure_DeliverySchedule.Value=True," <ul><li>Delivery Schedule </li></ul>","") Step-(3) Now just save the layout changes and compile the report, Output should be like this in bullet format: NOTE- We can also use the multiple HTML tags for different styles as per the requirement. Thanks for Reading!! Your valuable feedback will be highly Apprecia...

Add Self Signed (SSL) Certificate to Trusted Root Certification Authority - NAV 2016

Hi Everyone, In this article we will see Steps to Add SSL Certificate to Trusted Root Certification Authority in system. In previous blog we have seen how to Create and Export new SSL Certificate, refer here: https://kunalhuria.blogspot.com/2021/11/microsoft-dynamics-navision-2016-create.html Basically these are the two ways to Add Certificate to Trusted Root Certification Authority: First Way:-  Step-(1) Open  the Microsoft Management Console by (Start > MMC) or Press Win + R key (Run command) and type mmc.exe and click on OK button. Step-(2) Choose File then click on Add/Remove Snap-in in the standalone tab, choose add Step-(3) Now,  Choose the certificates and click on Add button as shown below: Step-(4) I n the wizard, choose the Computer Account >> Local Computer and  press finish to end the wizard. Step-(5)  Close the Add/Remove Snap-in dialog box now. Step-(6) Navigate to Certificates (Local Computer) and choose the Trusted Root Certificati...

Create SSL Certificate using IIS - Microsoft Dynamics Navision 2016

Hi Readers, In this blog we will see how we can create SSL certificate for Demo environment and attach it in Nav Administration to access NavUserPassword. Creating SSL Certificate using IIS :- Step-1 Open  Internet Information Services (IIS) Manager. Step-2 Now select the server where you want to generate the certificate under Connections in left side menu and double click on Server Certificates under IIS tab as shown below: Step-3 Click on Self-Signed Certificate on Action menu shown right side of the window: Step-4 Now Enter the friendly name for the certificate and click on ok button : Step-5 SSL certificate is generated and you will see that in server certificates list. Step-6 Now double click on certificate we have generated (Ex-KunalBlog) and click on Details  option to copy the Thumbprint of the certificate for further use. Step-7 You can also Export the certificate by just Right click on it and choose Export option, specify the path & Password as shown b...

Error Fixed - An error occurred when opening the report designer. A supported version of Visual Studio could not be found (NAV 2016)

Hi Nav Users, In this article we will see how to solve the below mentioned Error in NAV 2016. I am facing this error while opening the RDLC Report designer (Report Layout): --------------------------- Microsoft Dynamics NAV Development Environment -------------An error occurred when opening the report designer. A supported version of Visual Studio could not be found. --------------------------- OK -------------------------- Solution:-  We have to just create the blank folder in Local Disk (C) Directory as mentioned below: C:\ProgramData\Microsoft\VisualStudio\10.0 Note:- Also just check if Use Report Builder value is Yes in Development Environment under  Tools >> Options >> Use Report Builder >> Yes. Now just Restart the Development Environment and then Report layout designer screen will open. I hope this will help you. Stay tuned for more articles!!

Print Value on Conditional basis in SSRS : Using IIF Function in Business Central / Navision

Hi Everyone, In this blog we will see how we can print expression based on some condition in SSRS Report (RDLC Layout).Like, IF (Value1 = true,"kunal","Huria")..This means if value1 is true then its print Kunal else it prints Huria . Step-(1)  Here i am taking this example of my customized Report, if   "Payee Name"  field value is blank then it will Print  Kunal  otherwise it will print  "Payee Name"  field value. Add this code in Textbox Expression as shown below: =IIF(Fields!Payee_Name.Value="","Kunal",Fields!Payee_Name.Value) Step-(2) Output >> This will show the output while generating Report for below cases:- Case-(i) If   "Payee Name" field value is blank : Case-(ii) If "Payee Name" field have some value: Thanks for Reading!! Stay tuned for more Articles!!!

Modify Navision / Business Central Table Fields Data using SQL Database

Hi Readers, In this article we will see how we can directly modify some fields data of Nav / Business Central Tables directly from SQL Server Database. Step-(1) Run SSMS (SQL Server Management Studio) as Administrator and connect it with desired Server Name. Step-(2) Now select the required Database then Right click on Tables >> Filter >> Filter Settings >> and filterout the table using name. For example: Customer.   Step-(3) Select the desired table & Right click on it, then choose Edit Top 200 Rows. Data pane designer window will Open as shown below: Step-(4) Now the above screen shows only top 200 Rows, If we want to show all records just Right click on any field of the data designer pane then select Pane >> SQL this will open the query window. Step-(5) Now to show all records just remove Top (200) from Query and Right click on it then click on Execute SQL. Step-(6) This Data Designer window will show all the records available in the table, yo...

Display Page x of y in SSRS Report : Business Central / Navision

Hi BC Lovers, In this article we will see how we can display Page No. in the Header or footer part of the page in RDLC Report layout, by using inbuilt functions (PageNumber & TotalPages) in SSRS report. Step- (1) Just Open the RDLC Layout (Edit Mode) and add below Expression in required textbox as shown below: Page [&PageNumber] of [&TotalPages]   Step- (2) Now just save & update the Layout and Run the Report, the output will be: I hope it helps!! Thanks for Reading!!! Your valuable comment & feedback is Highly appreciated.

How to Connect Business Central with Visual Studio Code - Part-2

Hi Everyone, In this blog we will see how we can Install & Connect VS Code with Microsoft Dynamics 365 Business Central 2019 W1 On Premise. As discussed in earlier post, we have seen steps to Download & Installation of Microsoft Dynamics 365 Business Central W1 (On-Premise). You can refer below mentioned link for Part-1: https://kunalhuria.blogspot.com/2021/07/installation-microsoft-dynamics-365.html Step-(1) Install Visual Studio Code by following below snapshots: Step-(2) Click Install & then click on Finish button. Step-(3) Now Open Visual Studio Code, On Extension Management Tab (Ctrl + Shift + X),  Install the  AL Language Extension Version v7.4.496506. Step-(4) Now Open Command Pallet and search AL:Go command & hit enter. Step-(5) Now tag the Folder Name or Path where the Project/Extension Files stores. Step-(6) After this, we have to select the Target Platform which means exact BC version we have already installed in the system. 7.0 - For BC 2021 Wa...

Installation : Microsoft Dynamics 365 Business Central (BC-14) - Part-1

Hi Folks, In this article will see all steps to Install MS Dynamics 365 Business Central - 14 (On-Premise) on our machine. Follow the below Link to download the Business Central - 14 setup: https://www.microsoft.com/en-us/download/details.aspx?id=100643 Follow the below mentioned steps for Business Central Installation : Step-(1) Right Click on Setup.exe file and then choose Run as administrator . Step-(2) Click on Next & then I accept button. Step-(3) Now click on Advance Installation Option & then   click on Choose an Installation option. Step-(4) Now Click on Custom option and select the required components. Step-(5) Specify the Parameters & then click on apply button as shown below: Note:- Bydefault basic parameters are already filled in, you can also proceed with same for fresh Installation. Step-(6) Now sit back & relax it will install in a while & you will get Installation successfully dialog box as shown below. In next article we will see how ...