Kunal Blog

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!!!

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...

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.

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...

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 ...

Hi Readers, In this blog we will see how we can transfer data from " Purchase Header" to "Purchase Invoice Header" & "G/L Entry" table in Business Central. In this example, will create "Remarks" field on Purchase Header table and after posting, flow it to Purchase Invoice Header & G/L Entry tables: Firsly, create required fields ("Remarks") in below mentioned tables by creating table extensions: Purchase Header (38) Purch. Inv. Header (122) Gen. Journal Line (81)  G/L Entry (17) For the Purch. Inv. Header table, you can just create copy the field from purchase header and paste it in  Purch. Inv. Header  table. If the field ID No. is same for that field for both the tables then you don't have to code i.e, it automatically transfer that field data from Purch. Header to Purch. Inv. Header . Step-(1)   tableextension   50104  "Purchase Header Ext"  extends  "Purchase Header" {      fields   ...

Hi Everyone, In this blog we will see how we can setup multiple No. series on Customized / developed features.  In this example, i have Setup No. Series on Employee Detail Card which is my customized page and by clicking on Assist Edit button you can see all No. series attached on Setup with their relationships:  Demonstration:- Step-(1) Create required No. Series in the No. Series and then Setup a relationship between them. Step-(2) Human Resource Setup (Table Extension) >> Create a new field on HR Setup which has Table relation as No. Series Table: tableextension   50101  "Human Resource Setup Ext"  extends  "Human Resources Setup" {      fields     {          // Add changes to table fields here          field( 50000 ; "Employee Code Nos.";  code [ 20 ] ) ...