Wednesday, November 30, 2016

How to use MARK and MARKED only function in MS Dynamics NAV 2017?

These 2 functions are similar to NAV Developer as we do use for Objects using CTRL +F1.

HERE is an example in which I had used to mark some records of Customer table with Starting Alphabet as "C" and with Location Code as "BLUE".

So Lets see the screenshot for reference :-

The Result is :-

Monday, November 21, 2016

How to INSERT a Record in Customer table and then modify that record?

Use OF AL to update insert delete in MS Dynamics NAV 2017?

We can insert a record and modify that inserted record into table using Codeunit.

For an Example: I am updating my name in Customer table and updating that Name.

Look at this Code.

After Running the Code-unit we got this desired result:-

Saturday, November 19, 2016

Bug Fix Needed on webSite of MSDN for query Function SAVEASCSV?

There is a function explained on MSDN website on this link SAVEASCSV for Query Object.

Syntax of Function :

QueryVariable.SAVEASCSV (FileName[, Format][, FormatArgument])
File Name is a text path where query will be Saved.
Format is a option field with 0/1 as parameters
0 means to provide length maually in FormatArgument between any 2 columns
1 means to provide in FormatArgument as , ; or 'tab' for space.

Bug No. 1

'tab' is not working with 1 as paramater it just copies the word tab in between coluum.
Bug No. 2
Microsoft has not written any example with 'tab'
Bug No. 3
Microsoft should notice that 'tab' is working with 0 and not with 1 as FORMAT parameter.
ScreenShot is attached below :-

Friday, November 18, 2016

Why are 2 Allow Posting Dates in G/L Setup and User Setup are present in MS Dynamics NAV ?

Two Different allow posting dates in General Ledger Setup and User Setup?

Yes one is for common users and one is for particular users.
Here the defined dates will be checked once a posting routine action is done in Navision.

But what is the priority base? Which will be selected if both are defined.

Priority will be given to User Setup first then G/L Setup.
For E.g.
In G/L Setup Dates are : 01012016..01022016
In User Setup Dates are : 01122015..31122015 for user XYZ.

Then while posting first user setup will be checked. That means if user XYZ is posting on date 29122015. Then will be able to post. Hope you understand the concept.

Wednesday, November 16, 2016

NAV 2017 GL SETUP of MS Dynamics NAV :- General Fast Tab Explained

NAV 2017 General Ledger Setup 

NAV 2017 GL SETUP General TAB

NAV 2017 has already been launched with new functionalities both for developers and Client.
Few important fields for developers in General Tab are as follows:-

1. LCY CODE and its SYMBOL Field.
2. Allow Posting Date.
3. BILL TO Sell TO VAT Calc.
4. Invoice Rounding Precision and its method.
5. Use Legacy G/L Entry Locking.

All Setups are placed at one place as in Screen 1 above. We should follow the same in below versions.

Monday, November 14, 2016

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.


FINDSET :- It retrieves 50 records in tables and update it one by one.
FINDLAST :- It points to LAST Record in a 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.

Difference B/W Pass By Reference & Pass By Value (Miracle Solved & Explained For all Languages)

Functions are created in all languages and perform various tasks uniquely. 

That's the reason why functions are useful in a coding of all types Languages.

Creating a Function needs to be needs needs 3 Basic Steps :

1. Defining and Creating the Defination of Function.

2.Calling the Function.

3. Passing the Paraments and Arguments into the function so that it provide output.

as navision is using C/AL Language in its heart to define and work the logics.There is only one thing common is Function.

Calling the Function and creating the Function and Defining the Function.

Due to this Fact , understanding Functions is very much necessary for beginners and experts of NAV TECHNICAL Consultants.

Functions are easy to create in NAV. Now passing the parameters and calling the functions is explained below.

There are two functions which I had created and Called it via 


By Default All Variables in Functions inside NAV Dev are Pass by Value which means a copy is created for parameter and passed.

Variables Used:
CustRec     Record    18
Old Name   Text 50
New Name  Text 50
ChangeCustomerName and ChangeCustomerNameRef are two functions Created in which
Customer variable is taken First one is Pass By Value and Second one is Pass By Reference.

The Code is As Follows :

(This code is only for study purpose taken as Example.If any Objections then Kindly mail)

The Final Result is as under screenshot.

Result 1:-

Result 2: