Category: C/AL

Value ‘-1’ is not a valid value. The following values can be used >=0.

Hi, Recently one of my colleague was trying to copy “Chart Of Account” to “IC Chart of Account” in NAV 2017 using default “Copy from Chart of Account” functionality.  This is a really nice functionality available because within a single button click all the accounts in “Chart of Accounts” get copied to “IC Chart of …

Continue reading

Understanding COMMIT and transaction scope with temporary records within Microsoft Dynamics NAV

If you did not went through the previous post on “Understanding COMMIT and Transaction Scope within Microsoft Dynamics NAV“,  I suggest you to go through it before start reading this blog post.  What do you think about temporary records and transaction scopes?   Most of developers think temporary records are managed as transactions, but it’s not.  …

Continue reading

Use of Virtual Table : Date – Microsoft Dynamics NAV

This blog post is about something powerful but hidden within Microsoft Dynamics NAV. I believe many developers always work with dates over and over during their day-today life and i’m sure many of you have done many functions which convert, split and do all sort of things with date. Saying that many developers does not …

Continue reading

Understanding COMMIT and Transaction Scope within Microsoft Dynamics NAV

Have you tried and thought about what is the transaction scope. In this blog post I am going to discuss little bit about transaction scopes and how the transaction scope works within Microsoft Dynamics NAV.  In order to check the simple scope I am planning to use below code. Pretty simple, its just inserting a record …

Continue reading

Why Codeunit 1530 : “Request Page Parameters Helper” ignores my report filters

Hi, Last week I was working on a “Customer Statement” Report in Microsoft Dynamics NAV 2017 database. This report was a copy of the original “Statement” (Report 116). Once the modification was done, I simply change the report selection in the Database and then ran the report using Development Environment.  Applied few filters to the …

Continue reading

Microsoft Dynamics NAV 2017 – Home Page

Hi Everyone, I will be posting blog posts about the newly realeased Microsoft Dynamics NAV 2017. This page will be the home page for those blog posts. If you need to know anything specific please post them on the commnet section of the blog post. I will be able to look into those and provide …

Continue reading

Report color code to identify blank rows

Hi, If you have been developing RDLC reports for Dynamics NAV, most probably you might have come across the situations where some blank lines are printing in the body of the report and just a glance you cannot identify from where these lines are coming from.  Very recently one of my colleague asked me to …

Continue reading

My two cents on Dynamics NAV Extensions

Today morning I was reading few blog posts from Microsoft Dynamics NAV MVPs on Dynamics NAV future. In most of blog posts they have focused on the extensions and freezing Dynamics NAV code. Some of them have talked positive about it and some of them have talked against it.  Even though I do not attend any of the Dynamics NAV conferences due to …

Continue reading

What is C/SIDE and C/AL

Stands for:  C/SIDE – Client/Server Integrated Development Environment C/AL –  Client/Server Application Language Description. C/AL is the programming language that used within the development environment for Microsoft Dynamics NAV, and the development environment is called as C/SIDE. C/AL is a database specific programming language and it primarily used to retrieve, insert, and modify the records in the dynamics NAV Database. C/AL is …

Continue reading