HOw USE OF FINDSET in MS Dynamics NAV 2017?.

How to use FINDSET

As per MSDN,Findset gets the records on the basis of filters applied over the record type.
If now filters are applied then we can use it to update all records present in table using REPEAT UNTIL.

I had defined these two variables in navision.

DIFFERENCE between FINDSET,FINDFIRST,FINDLAST in NAVISION.

FINDSET :- It retrieves 50 records in tables and update it one by one.
FINDLAST :- It points to LAST Record in a DATASET Filter.
FINDFIRST :- It points to FIRST Record in DATASET FILTER.

Following is the code which I had written to get the processed data in a table.

This is the desired result:

How to use DATE2DWY Function in Navision?.

CASE are similar to all other languages in Navision. 

The only difference is in Syntax but the basic concept remains same.

Here I am going to convert a Date to a number using DATE2DWY and that number is used in CASES to define a Weekday in Navision. 

So these variables I had defined:

The Code is very simple just notice the syntax for CASE in Navision.

Here is the result.

How to separate comma separated value in NAV and import the values in table MS Dynamics Navision?

Comma , Separated Value Retrieval

Now a days, we are moving to more around e commerce industry which works in 24*7 format so to ease the performance and manual work we prefer to use web services. These web services include a set of format which includes some logical values. So in this blog we will try to extract some values from a returned web services.

What we are going to use?

There is a function in NAV called SELECTSTR .

Acc. to msdn,

SELECTSTR treats string values as OPTIONS. This means that identical values in different strings are not allowed.

Any trailing commas are removed before the operation begins.

If Number is less than 1 or greater than the number of real values (excluding trailing commas) in the string, then an error is returned.

Quotes are not supported. For example, a,b,"c,d",e is treated as a five-element substring where substring 4 is d".

Example:-

We are going to retrieve 

1.Account Type

2.Url

3.ID

4.Name

from this returned value from web service.

{"type":"Account","url":"/services/data/v32.0/sobjects/Account/001N000000pEFqVIAW"},"Id":"001N000000pEFqVIAW","Name":"aafag"} 

How to implement the customization and store it in the Table.

Declare variables as per need and requirement.

This is the code which I had written for select the string and then simply insert it into our table.

The final result is here.

You can download the objects by:

Click Here.

How to create a PROGRESS Bar in Navision ?

To create a progress bar for a long process in NAV .

We will create 4 variables for calculation and creation of progress bar in navision. These four variable are of type Dialog and Integer.

To create a demo progress bar we will just give AmtToProcess  a value of 500000.We are using a ROUND function for this scenario.And UPDATE function which will 

Update the progress bar for few seconds.

The final result will be like this one.

I hope this code will help you to create progress bar in navision.
And you can more customize the progress bar according to your need.

What is Kiler Object in MS Dynamics NAV?

Most of us may be unaware of this term in MS Dynamics NAV. 

But yes it exists. Howsoever I came across this object in one of my situation in our project. To help others I am bringing you the concept.

Pre-Requirement:

You will need two DB for creating and using killer object in NAV Dev Environment.

What is Killer Object in MS Dynamics NAV?

Killer Objects are basically creation of objects without any defination in those Objects.

How To create Killer Object?

You just have to create a object in one database with existing object id in another Database. I think you have not understand. See in the screenshot.

This is a Killer Object. Just save this Object. You can do this with any of the 7 Objects.

How to Use Killer Object?

Now open that DB where you want to delete the object with same ID.

This Object will not ask you anything in the DB where you are importing the same.

So be careful while using the same.

Advantage:

In a scenario where you want to delete the extra object out of your license range object.

Disadvantage:

Be careful while using such type of object. 

How to use GETFILTER & SETFILTER How to use it and where to use it in MS Dynamics NAV?

Basically these two filters are majorly used in reports creation of NAVISION. Howsoever I read these functions in MSDN Defination.

To get a better view of these two function I am creating a report using these SETFILTER and GETFILTER.

My readers can also see these functions in many base reports from MS Dynamics NAV.

Firstly look at the defination of these two inbuilt Functions in NAV from MSDN.

SETFILTER

Assigns a filter to a field that you specify. via MSDN

GETFILTER

Returns a list of the filters within the current filter group that are applied to a field. via MSDN.

Howsoever now I am creating a report whose filter I AM going to setup with these two functions lets have a look on my screenshots.

I hope this blog will make easier for beginners to learn this functions in details. I also request NAV seniors to comment and correct me for my mistaks in any of my blog written.

According to me,

I use GETFILTER for getting the filetrs on reports which I had defined in

ReqFilterFields I am Showing It here.

Code :

Result:You will receive this filter result 3 Times as i have 3 <>0 records in Customer Table.

In my next blog I will show you how to use setfilter in MS Dynamics NAV 2016.