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.

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.