How to run a job to delete Change log entries in NAV ?
Nov08

How to run a job to delete Change log entries in NAV ?

Introduction: We  can enable the change log in Dynamics NAV so we have a history of activities. The change log collects all changes that are made to the table so we can track it. We are good so far but the issue arises when we have millions entries in the system. It not only takes up the memory space of the server but also affects the performance. Hence, I’ve customised a job for deleting… Continue Reading...

Read More
How to send emails to customers in a tabular format in Dynamics NAV?
Oct11

How to send emails to customers in a tabular format in Dynamics NAV?

Introduction: Hello Buddies! I’m back with a blog on sending emails to customers/users in a tabular format  using html tags in NAV. Email have become an integral part of our daily lives. Its amazing that we can do so much with email in Microsoft Dynamics NAV using SMTP mail. In this scenario, any error while importing files is stored in a table Import EDI Error Logs. As soon as the table… Continue Reading...

Read More
Use of Configuration Mode in NAV
Aug23

Use of Configuration Mode in NAV

Introduction: We all know about how to assign different Role Centers to Users based on their requirement. Any change made to the Role Center is applier to all Users who are assigned to them. Sometimes we do require to make minor changes to only a particular user like hiding certain home icons or adding certain pages to the Role Center. This becomes a bit tedious through the NAV Development… Continue Reading...

Read More
How to create KPI Business chart using Chart Control Add-in in NAV
Jul31

How to create KPI Business chart using Chart Control Add-in in NAV

Introduction: Business Chart Control Add-in In Dynamics NAV, you can graphically represent data in charts using Business Chart control add-in. The Business Chart control add-in is provided by the Microsoft.Dynamics.Nav.Client.BusinessChart.dll assembly. The Business Chart control add-in assembly includes an API that you can use to call methods and properties from C/AL code to build your… Continue Reading chrisdsilvablog’s...

Read More
Resolution to SQL Error:Cannot be renamed because the object participates in enforced dependencies. – Chris D’silva’s Blog – Dynamics NAV and Business Central
Jun07

Resolution to SQL Error:Cannot be renamed because the object participates in enforced dependencies. – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: Hey Buddies,…This is what happened… Just a normal day of coding , I was restoring SQL backup from my Live database to my Test database in NAV. everything works cool. 🙂 Test database is restored. Now I navigate to companies and try to rename the company to Test and bang….error! The following SQL Server error was unexpected: Object… Continue Reading chrisdsilvablog’s Article on their...

Read More
Dynamically changing font on run time for Dynamics NAV – Chris D’silva’s Blog – Dynamics NAV and Business Central
May31

Dynamically changing font on run time for Dynamics NAV – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction : Hey! Don’t we fix the font size of our text box in NAV report ? Will it not be cool if we could dynamically change it? 😀 This article  is a quick tip where we can dynamically change the font size of the text on run time based on the length of the text. Pre-requisites : Microsoft Dynamics NAV SQL server Report Builder Steps: Open your development environment and… Continue Reading chrisdsilvablog’s Article on...

Read More
How to get approval Link on Email Notification for Workflow? – Chris D’silva’s Blog – Dynamics NAV and Business Central
Apr23

How to get approval Link on Email Notification for Workflow? – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: We often configure email notification for workflows but to approve them User needs to Login and navigate to Request to approve page in NAV. What if we get a link which directs us to the Request to approve page ? Saves time right! 🙂 This article explains how to get a approval link for Purchase Invoice approvals. Pre-requisites: Microsoft Dynamics NAV 2018 Web… Continue Reading chrisdsilvablog’s Article on...

Read More
How to create Notification part as an Extension for Dynamics NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central
Mar28

How to create Notification part as an Extension for Dynamics NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central

Hi Readers, I’m back with another blog on Extensions. Introduction: Notification has become very import part of our RoleCenters in Dynamics NAV. We get notified by emails or a note if our Job queues fail or some note send from a fellow employee but…… Notification is a System part hence its not visible if you use a web client i.e its a limitation of the web client. 😦

Read More
How to create Custom Workflow(The Extension way) – Chris D’silva’s Blog – Dynamics NAV and Business Central
Feb21

How to create Custom Workflow(The Extension way) – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: Hey! I’m back with my blog series on Workflows. My last blog was on how to create Custom Workflows in Dynamics NAV….This blog is on how to create Custom Workflows in Business Central..the Extension way! Pre-requisites: Business Central On-Premise Visual studio code(VS Code) Steps: Launch Business Central Administration, and enable the below and restart service… Continue Reading chrisdsilvablog’s Article on...

Read More
How to Create a Custom Approval Workflow in Dynamics NAV – Part 2 (with fob attached)pj – Chris D’silva’s Blog – Dynamics NAV and Business Central
Feb01

How to Create a Custom Approval Workflow in Dynamics NAV – Part 2 (with fob attached)pj – Chris D’silva’s Blog – Dynamics NAV and Business Central

Celebrating 11000+ views and 7000+visitors for the year 2018. Thank you readers! As many of them asked me to attach the .fob file. I’ve attached a link at the bottom for your reference. For Part 1 chick here Introduction: Hi folks! I’m back with Part 2 of how to create custom approval workflow in Dynamics NAV. An overview of Part 1, we created an Event Publisher then we created… Continue Reading chrisdsilvablog’s Article...

Read More
How to fetch the top 5 Item’s history in a factbox in NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central
Jan25

How to fetch the top 5 Item’s history in a factbox in NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: Here, the scenario is, I open a Purchase order and add Items to it. When I select on an Item I want to know the Purchase History of it like the Receipt quantity, Posting date etc. Yes,.. I know what your guessing, simply create a Factbox for it . But…now I want the Top 5 history of the Item not all of it . Lets find how to do this. Pre-requisites: Microsoft Dynamics… Continue Reading chrisdsilvablog’s Article...

Read More
How to fetch data in Part type page using a Query in NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central
Jan04

How to fetch data in Part type page using a Query in NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central

Wishing you all a happy and prosperous New year 2019! Introduction: First question is why query? Lets see the advantage of queries. First you can limit the amount of data you retrieve from the server by defining only the specific columns you needYou can join multiple tables into one query saving loop code pattern.They are also light weight than Table Queries.Below is the article which… Continue Reading chrisdsilvablog’s...

Read More
How to merge Items in Microsoft Dynamics NAV ? – Chris D’silva’s Blog – Dynamics NAV and Business Central
Dec13

How to merge Items in Microsoft Dynamics NAV ? – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: A lot of times clients create the same items, customers, vendors. Later they realize it and look for a solution to keep all data associated with item in one unit and avoid duplication of items. Yes, we can achieve this in a few simple steps. This blog articles explains how to merge two items into one in case where duplicates where… Continue Reading chrisdsilvablog’s Article on their...

Read More
How to insert/modify a posted document in NAV – Chris D’silva’s Blog – Dynamics NAV and Business Central
Nov23

How to insert/modify a posted document in NAV – Chris D’silva’s Blog – Dynamics NAV and Business Central

Intoduction We set permissions to user in the User setup to give accessibility to users but we are not allowed to make any changes to posted document even though we assign Super permission to it. The below eror is thrown. This blog explains the steps to modify the posted document. Pre-requisites Microsoft Dynamics NAV 2017 Steps: Open the page throwing error in design… Continue Reading chrisdsilvablog’s Article on their...

Read More
Bar code Integration with Business Central – Chris D’silva’s Blog – Dynamics NAV and Business Central
Nov09

Bar code Integration with Business Central – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: Summary: The bar code scanner scans the bar code. The Item No. against which the bar code is assigned should be populated on Sales Line Subform. Requirement: The mouse cursor is on Sales Line sub form field No. and Bar code scanner scans a bar code.Once the bar code is scanned a Serial No. is populated on No. field of Sales Line sub form Customization should be done to… Continue Reading chrisdsilvablog’s...

Read More
How to create Cue tiles for fetching Pending approvals in a workflow in NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central
Oct26

How to create Cue tiles for fetching Pending approvals in a workflow in NAV? – Chris D’silva’s Blog – Dynamics NAV and Business Central

Hey Readers! Thanks for stopping by. Hope you like my blog. Introduction: In an approval process, approval is sent to a designated person. The person is notified via email also he/she can view the requests in Request to approve page. But,….there are times the person can forget to approve the request which may lead to delay in processes. What if I login into Dynamics NAV where I get the… Continue Reading chrisdsilvablog’s...

Read More
How to add Cue tiles to existing Cue Page in Business Central using VS Code – Chris D’silva’s Blog – Dynamics NAV and Business Central
Oct12

How to add Cue tiles to existing Cue Page in Business Central using VS Code – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: Since the release Business central Online at April 2, 2018, extension has gained its popularity. Here, I’ll be adding cue tiles to the existing Cue page called ‘Project Manager Activities’ using Extension i.e VS code. Pre-requisites: Steps: Create a Table Extension and add the fields you want to add in the cue page. Here the fields are of FieldClass Flowfields which… Continue Reading chrisdsilvablog’s Article...

Read More
How to add fields to existing pages using Extension in Business Central – Chris D’silva’s Blog – Dynamics NAV and Business Central
Sep21

How to add fields to existing pages using Extension in Business Central – Chris D’silva’s Blog – Dynamics NAV and Business Central

Introduction: With the release of Business Central, Extensions have gained its popularity. Here I’ll be adding field to existing page Blanket Purchase Order using Visual studio code (VS Code) Pre-requisites: VS Code Business Central Online Steps: Create a table extension, extending standard table Purchase Header. 2. Create your page extension, here, I’m adding the fields at the… Continue Reading chrisdsilvablog’s Article...

Read More
How to create Cue tiles for Role center in Dynamics NAV 2017 – Chris D’silva’s Blog – Dynamics NAV and Business Central
Sep07

How to create Cue tiles for Role center in Dynamics NAV 2017 – Chris D’silva’s Blog – Dynamics NAV and Business Central

Hi Readers! Hope you like my blogs. Give your feedback with likes and comments. Introduction: What’s so special about Cues in NAV? Cues are designed to give users with a quick status of their daily activities, which acts as a prompt them to take action. A Cue is a tile on a page in the Dynamics NAV client that provides a visual representation of business data. So if your like like a… Continue Reading chrisdsilvablog’s...

Read More
Use of Vendor and Customer Workflow in Dynamics NAV – Chris D’silva’s Blog – Dynamics NAV and Business Central
Aug24

Use of Vendor and Customer Workflow in Dynamics NAV – Chris D’silva’s Blog – Dynamics NAV and Business Central

Thanks for Visiting! Follow my blog to get the latest updates. Introduction: We all have noticed Send Approval Request button on Vendor and Customer pages. You can select Customer workflow from the workflow template Sales and Marketing. Vendor  can be configured similar to customer workflow. These standard workflows can be enabled from the workflow page….but what’s the use of it?… Continue Reading chrisdsilvablog’s Article...

Read More
How to Create a Custom Approval Workflow in Dynamics NAV – Part 2 – Chris D’silva’s Blog
Aug10

How to Create a Custom Approval Workflow in Dynamics NAV – Part 2 – Chris D’silva’s Blog

Celebrating 4500+ views and 3000+visitors for the year 2018. Thank you readers! For Part 1 chick here Introduction: Hi folks! I’m back with Part 2 of how to create custom approval workflow in Dynamics NAV. An overview of Part 1, we created an Event Publisher then we created function for sending approval then for approval, for reject and delegate. Part 2- Now we will continue with how… Continue Reading chrisdsilvablog’s...

Read More
How to create a custom approval Workflow in Dynamics NAV – Part 1 – Chris D’silva’s Blog
Jul27

How to create a custom approval Workflow in Dynamics NAV – Part 1 – Chris D’silva’s Blog

Introduction: If we require approval process for  Purchase, Sales orders etc we enable the standard workflows of Dynamics NAV….but if we have a Custom designed page in NAV and we need approval workflows how will the workflow process work? How to set it up? This blog provides a step wise procedure how to create custom workflow from scratch. This Workflow is enabled for the Jobs page in… Continue Reading chrisdsilvablog’s...

Read More
How to send Email Notification to Users using Workflow. – Chris D’silva’s Blog
Jul17

How to send Email Notification to Users using Workflow. – Chris D’silva’s Blog

Hi Readers! Hope you like my blogs. Do give your valuable feedback in the comments section or you can email me via contacts on my blog site https://chrisdsilvablog.wordpress.com Introduction: Many a times in an Approval workflow, we need to notify the user by email to the Approver that approval request is sent also the sender needs to be notified whether the approval request sent is… Continue Reading chrisdsilvablog’s...

Read More
How to send Notes to the Customer from a Custom Page using an Action button in Dynamics NAV – Chris D’silva’s Blog
Jun29
Read More
How to Send Mail with attachment using Streams for reports with request page in Dynamics NAV – Chris D’silva’s Blog
Jun01
Read More
How to change the font colour of a List page based on a condition in Dynamics NAV – Chris D’silva’s Blog
May21
Read More
How to update the selected line in the Subform on click of an action button in the Mainform in NAV – Chris D’silva’s Blog
May04
Read More
How to restrict an action button based on time in Microsoft Dynamics NAV? – Chris D’silva’s Blog
Apr23
Read More
How to setup D365 Business Central? – Chris D’silva’s Blog
Apr05
Read More
How to hide the Delete button in a page in Microsoft Dynamics NAV ? – Chris D’silva’s Blog
Mar20

How to hide the Delete button in a page in Microsoft Dynamics NAV ? – Chris D’silva’s Blog

How to hide the Delete button in a page in Microsoft Dynamics NAV ? – Chris D’silva’s Blog Blog Syndicated with chrisdsilvablog’s Permission

Read More
Error Resolution to “Form.RunModal is not allowed in write transaction” in Microsoft Dynamics NAV – Chris D’silva’s Blog
Mar07
Read More
How to avoid data deletion when Dynamics NAV 2018 extension is published from VS Code? – Chris D’silva’s Blog
Feb21
Read More
How to create Integration Event and subscribe to the Event in NAV 2018 using VS Code – Chris D’silva’s Blog
Feb12
Read More
How to configure Visual Studio Code(VS Code) for Extensions in Microsoft Dynamics NAV 2018 – Chris D’silva’s Blog
Jan31
Read More
Microsoft Dynamics NAV 2018 here! – Chris D’silva’s Blog
Dec12
Read More
Dynamics NAV 2017 and IT-pro content Live! – Chris D’silva’s Blog
Nov24
Read More
How to make an action button accessible only to a particular user in Microsoft Dynamics NAV – Chris D’silva’s Blog
Nov24
Read More
How to login Windows Client and Web Client using ‘NavUserPassword’ Authentication in Microsoft Dynamics NAV – Chris D’silva’s Blog
Nov16
Read More
Bidding Adios to Dynamics NAV 2013 and Dynamics NAV 2013 R2 on January 9,2018 – Chris D’silva’s Blog
Nov15
Read More