Kunal Blog

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

Hi Guys, In this article we will see how we can Calculate first and last date of a month from any date. Code:-              action( "Calculate Date" )             {                 ApplicationArea = All;                  trigger  OnAction ()                  var                     FirstDate:  Date ;                     LastDate:  Date ;            ...

 Hi Readers, In this article we will see how we can Run a Page with some default filters by using SetTableView function in Navision / Business Central. Basically, SetTableView applies the table view on the current record as the table view for the page, report or XMLport. In this example, will see how we can Run "Customer List" Page with bydefault filters:  Location Code = " Yellow " & Country/Region Code = " US " Here, we have define 2 local variables one for page that we want to run and other is record variable which is the source table of the running page: pageextension   50100  "Company Info Ext"  extends  "Company Information" {      actions     {          addlast( Navigation )         {              action( "SetTableView" )      ...

Hi Folks, In this blog we will see how user can select which document report will be printed with each document type or how we can print our customize report with standard " Print " action button in Business Central. The default version of BC includes the following Report Selection Pages: Report Selection - Sales  >> (For all types of Sales related reports/Documents). Report Selection - Purchase Report Selection - Inventory Report Selection - Cash Flow Report Selection - Warehouse Report Selection - Service Report Selection - Bank Account Report Selections Reminder/Finance Charge Report Selections Production Order General Journal Template  >> For All types of Journals ( Posting Report ID , Test Report ID etc. fields are available in table). In this example we will see how we can print our customize report just by clicking on  "Print"  or  "Post & Print"  action button on Sales order by perform the following steps:  Type Report Sele...

Hi folks, In this article, will see how to upload a License in Business Central with two different ways. Generally, sometimes our old License gets expired then developer need to upload license to BC database environment or Customer License for specific Roles and Permissions. Error : Your Program License has expired. Here two solutions are available for you both are same but using different apps: 1. Using PowerShell ISE 2. Using Business Central Administration Shell **************** 1. Using PowerShell ISE **************** 1 2 3 4 5 6 7 8 9 10 // Script  for Upload License using PowerShell ISE   Step 1.1- Open PowerShell ISE as Administrator Step 1.2-  Import-Module for Business Central Wave 2, using the following script: Import-Module 'C:\Program Files\Microsoft Dynamics 365 Business Central\150\Service\NavAdminTool.ps1' Step 1.3- Using the following script to import the license: Import-NAVServerLicense -LicenseFile 'C:\license\LS Central-15 Dev License.flf' -Se...