Monday, June 27, 2016

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.


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


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.

Saturday, June 25, 2016

How Sales Order and Sales Credit Memo & Return Order is inter linked with each other?

How to increase the inventory in MS DYNAMICS NAVISION?

So I am going to deal with   

ITEM No. 1300 which has a quantity of 152 in our inventry now.

There are two ways of increasing the Quantity
One by POSITIVE Adjustment and second by Purchasing the item from Purchase order. Lets have a look by creating a sales order and posting it with ship and invoice with quantity 52.
So our net remaining quantity must be equals to 152 - 52 = 100.

So this is my sales order which I have successfully posted with ship and invioce in NAV.

Now have a look on change in ILE.

Here  we can see that inventory is now reduced to 100 items.

Now have look in ILE.

A negative line is created for last sales order.

Before looking into the tables where these lines are created which I will do in my next blog.

Now I am going to create a credit memo for this particular item to see what are the changes on ILE and Item card.

Hurrrey Lets have a look.

Have look in ILE.

Have look in ITEM Card.

The Quantity has been incresed.

Now have a look in Customer Ledger entries for this Customer.

Thursday, June 23, 2016

Posting Routines of sales order in MS DYNAMICS NAVISION at

While creating a SALES ORDER we can post it with 3 options in MS Dynamics NAV.

Either we can do SHIP , INVOICE , SHIP and INVOICE.

In all these 3 cases different lines are created and different tables are hitting in MS Dynamics NAV.
So have a look what are the major tables hitting in all these three different cases.
I am having WC Database in INDIAN Localisation other tables also get hit depending upon the taxation in INDIA.

But basic is always remain same.

While Shipping only these 2 tables and a document is created.
2 tables are interllinked with each other for that I will disscuss in my next blog.
While shipping only Item value is changed or I can say only quatity is chaged and no other imp

In ITEM Ledger Table for each ITEM LINE there were lines like here for 2 items 2  records are created in table.

These are the two lines created for VALUE Entries in MS Dynamics NAV.


While creating the invoice these document and tables get hits up in MS Dynamics Nav.

There is one Document

Posted Sales INVOICE 

Other 5 tables that get hit up in MS DYNAMICS NAV and there are diffrent Lines created accordingly.

GL Entry
VAT Entry
Customer Ledger Entry
Detailed Customer Ledger Entry

I think this is new in MS Dynamis NAV 2016.

What is the difference between XMLPORT & DATAPORT?

What is the major difference between XMLPORT and DATAPORT.

So I am just summarising all these things over here in my R&D. I also request to guests and my senior team in NAV to comment for improving the answer and highlighting the mistakes if so happen by me.

Both are used for exporting and importing from navision.

 Howsoever in 2009 R2 Dataports and XMLPORTS both were available. Now with 2013 R2 BOTH were merged to XMLPPORT and so the related functions and tools were also changed.

What are Dataport?

Dataports are used to export data from Microsoft Dynamics NAV to external
text files, and to import data from external text files into Microsoft Dynamics

What are XMLPORT?

XMLports are used to export and import data to and from external XML
document files. These are similar to dataports, only the XMLport encapsulates

Properties in XML format

These two screens are showing XMLPORT properties and triggers available in 2016 NAV.
We can export and import data in text or Xml using XMLPORT but with Dataport we can only do the same for text files.

I will surely update my blog and add more details once I got In details for these. I also request for your views about the topic. 

Monday, June 20, 2016

What is Server Side Printing and Client Side Printing in MS Dynamics Nav?

Server Side Printing

Server Side Printing is used for resolving the Memory Out Of Exception in MS Dynamics NAV 2013 And Below versions.

Basically in such reports Report is Run in background with a NAS Service.

Such reports are faster and used for those report which are consisting of rows above 70K - 90 K.

Client Side Printing

When Client RTC , App Server , DB Server are on same server then it is termed as Client Side.

When All are on diffrent server then we need to define Server Side Printing.

For more info Kindly visit Click Here

What is the diffrence between SSRS & RDLC Reporting & Classic Reports?

About Classic Client and Report in MS Dynamics NAV Version.

The designing of MS Dynamics NAV Reports in 2009 is called as Classic Client Report Designing where there were tools in NAV Dev Environment Only. Classic Client Report Designing is done within MS Dynamics NAV. Tools are provided in Dev Environment itself. About the background working in MS Dynamics I think it should have taken data direct from database like in SSRS Reporting.

About SSRS Reports SQL Server Reporting.

We can choose SSRS (SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft) reporting in NAV 2013 from the Tools Menu. The reporting is done via directly through SQL Server Based on our System. It is very fast reporting format as data is directly created from SQL SP and taken with tables and reporting services. There are few constraints like the tools provided in the SSRS reporting Dev Environment.

About RDLC Reports Report (Report Defination Language Client Side) 

From NAV 2013 we have only choice For RDLC or SSRS reports. The designer is with Visual Studio. We have options to select our report design tool within Tools menu. RDLC report uses and combines Report.RDLC  medata of Plain XML File with Dataset Defination.

I hope my R&D work have issued and clear some doubts. Although if there is any more suggestion I would like you to comment and tell more viewers of Blog to clear there doubts.

Wednesday, June 15, 2016

The Shocking Revelation of Use Of Codeunit 1.

In codeunit 1 there are 46 inbuilt functions 

created by NAV Team. In this series I found my solution there is a function called as Companyopen()

In this function I did a MESSAGE cutomization.

I also did a customization with Loginstart Function with Message. By which I can popup and show the Name of the USERID with which a Particular user has loggedin.

There is also function for LoginEnd. To be stick to the solution in short I want tp share there are inbuilt 46 code learning functions which can help a junior developer to learn NAV easily.

Get Build No. and Version of MS Dynamics NAV

Build No and version no. are also present inside this Codeunit1 of MS Dynamics Nav.