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.