Set filter in report using Text variable in NAV - Tips, Tricks & Facts #10

Hello everyone, It's been a month since I have written any post. Well, sometimes the work is just as much to occupy all your time that you barely get time to do other stuff.

The complete title of this post must be "Set filter in report using Text variable in which the user can use .. (aka range) and | (aka separator) in NAV" but never mind. 😉

I encountered this situation where I wanted to set filter on the report's dataitem using a text variable. So, I asked this question in some forums and got the answer which helped me resolve my problem and I want to share it with you guys too!

Difference between RESET and CLEAR - Tips, Tricks & Facts #9

Hi guys,

As it is pretty clear from the heading, I am going to compare rec.RESET and CLEAR(rec) in this post.

We are aware of the fact that CLEAR function is used to clear variables of all types. I am going to stick to how does CLEAR work with record type variables for this post.

Common mistakes we make in C/AL - Vol. 3 - Tips, Tricks & Facts #8

In this post I will talk about Significance of Using CALCSUMS in C/AL coding. 

Before writing about this topic I would mention here that, if a tool (or function) is available then we must use it to our system's benefit. Tools or functions are available in AL (or any other development envo.) to reduce the time taken by transactions and faster output generation.

You can find the detailed definition of CALCSUMS on MSDN. This function must be used to calculate sums of a Decimal field. However, the scope of CALCSUMS has been widened to Integer, BigInteger and Duration type fields along with Decimal type fields from NAV 2016 and up.

Common mistakes we make in C/AL - Vol. 1 - Tips, Tricks & Facts #6

Hi peeps, starting a new series of posts on what are the common mistakes made by developers like us which have bad, sometimes worse, impacts on database transactions. And what the kind of coding styles we must avoid to keep the code neat and clean. And what are the DO's and DON'T's for writing C/AL code.

We gotta remember that we are not the last developers who will write a particular code somewhere in the NAV objects. There will be more developers after us who will be carrying the torch and some of them might run into some code which was written by us.

Therefore, your code must better be understandable and optimized!

NAV Debugger Keyboard Shortcuts - Tips, Tricks & Facts #2

Hi Guys. I want share knowledge about something which could save a considerable amount of time while debugging.

Developers like us debug code almost every day. So knowing the shortcuts will save us so much time!

Most of us must be knowing these shortcut keys but for those who don't, checkout this post. I hope it helps you out and debugging takes lesser time.

Lets start with Activating debugger first,

Disable sorting in a list page in Dynamics NAV - Tips, Tricks & Facts #1

Hey Guys, I want to share tips, tricks and facts which might help us in the hour of need!
And this is the 1st post in Tips-Tricks-Facts series.

So coming back to the topic, How do we disable sorting in a List page or Subform page in NAV?

User can sort a list page on any field in standard NAV. In the example shown below, I opened Sales Order and sorted the Lines (Sales Order Subform) on "Quantity" field.

To disable this sorting, follow these steps:

Send Mail with Attachment in NAV 2013 R2

Hi guys,

This article explains a way for Sending an E-mail with PDF attachment in NAV 2013 R2.

Scenario : An E-mail must be sent to Customer when a Sales Invoice is posted in which Sales Invoice is attached.


Desired Output - An E-mail will be sent through Outlook which is configured on the workstation where NAV Client is installed.

Error - The type NavOption is unknown.

Hi guys,

I would like to share the solution to the error which came up with me while developing a report. It is quite a silly mistake which beginners like us make often.

Solution : Go back to the C/AL code and look up that you must have typed a wrong GET statement there.

In my situation, I was doing

SalesHeader.GET("Sales Line"."Document No.");  //Wrong GET

which resulted in 'The type NavOption is unknown.' error.

I corrected my code and wrote,

SalesHeader.GET("Sales Line"."Document Type","Sales Line"."Document No.");  //Correct GET

And this issue was resolved. Hope you will find this useful.

Cheers!
Ishwar

Keep Header Visible when Scrolling through a Report in NAV

Hi,

We get this kind of requirement in reports, so here is an article to guide you.

Register and Consume Codeunit as a Web Service in NAV 2013 R2

Hi Guys,



Today we will be learning :

1. How to Register a Web Service in NAV 2013 R2.
2. How to Consume it using Visual Studio.

Column Grouping in Report in NAV 2013 R2

Hi,

Today we will learn how to Apply Column Grouping on Data in a Report in NAV 2013 R2.

Scenario : We want to analyse Customer wise Sales per Month per Year.

Toggle Visibility in Report in NAV 2013 R2

"Toggle" is an Interactive Reporting Feature of Visual Studio. It makes Data Analysis quite interesting and easy. We will make a very simple report to demonstrate this Feature.

Configuring NAS to schedule Batch Jobs in NAV 2013 R2

The NAS (NAV Application Server) is used and configured to run the batch jobs and processes in background which need recurring execution.

To Schedule Execution of a Batch in NAV 2013 R2, we need to take help of Job Queue.

Create Business Charts from Scratch in NAV 2013 R2

To Create Business Charts in NAV 2013 I will take help of :


> A Query to fetch the Data from Database.
> A Codeunit to fetch the Data from this Query and feed it to the Chart.
> A Page to Display my Chart.