Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi all, During Installation of NAV 2009 & Later, sometime we come across an error which says - Could not connect to the SQL database.  (-2147467259   master      ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on. This error can be occured due to multile Reasons, so there are mutiple resoultion for the same. Resolutions - 1) Did u Run installer as Administrator (If Operating system is Windows 7)?     If not then try intalling using Run as Administrator. 2) Go to services.msc from RUN and check that SQL Server service is running or not. If not start the service and try intalling again. 3) Your Windows does not have sufficient priviledges on the SQL Server. Set up your account with the sysadm server role. Note, that you cannot rely on indirect permissions through Windows group memberships when Vista User Access Control (UAC) is turned on. T

Hi all, While adding export to excel functionality into Reports sometime we face issues while sending numbers with Leading Zeros to excel. In My case customer wanted to export a Report to Excel. Report have first field as Item Number which have Leading Zeros. I created the report and below is the diffrence between excel and Navision Data. The issue at this point is that Leading Zero in Item No. have been skipped. Reason- Excel formatted the cell as integer, while formatting as intger excel removes leading zeros. Beacuse a number starts with zero dosen't make any sense. Resoultion- After seraching through blogs and articles i figurred out a soultion so that excel formats the cell as text not as integer. The solution is simple just to add four single quotes ('''') for the field which you want excel to format as text not as intger. Sample - EnterCell(Row, Column, '''' + "No.", FALSE, FALSE, FALSE); OR ExcelBuffer.Add

Hi all, After an upgrade to NAV 2009 RTC from classic client, a client locked an wiered issue. While accessing a page from Role center client he was getting the error message "The type 'Option' is unsupported for the min/max validation rule".  I checked the page, complied the page but no luck. I checked the tables too that there might be an option field as the message says something about option but no luck.I was not getting the resolution, so i started deleting the fields from page and i identified the field which was giving error. To my surprise it was a Option type of field. I went to properties and identified that the min value for the field have been set to Ship. I don't know why but when i cleared these two values from field properties, the page started working. Resolution - 1) Check the properties of Option Type Field In Table. 2) Check the fields in source table and remove the min & Max value for fields. 3) Remove the values

Hi all, With new release of Role Tailored Client the major problem user & consultants faced is of the shortcuts. The shortcuts that we used till date for the classic client are behaving so wired when we try them on Role Tailored Client. Like Ctrl + F8 was used to zoom the line but nothing happens in Role Tailored Client. F3 was used to create a new record but cursor moves to filter field in Role Tailored Client. and many more. Yeah Ctrl + O still works in same way as it does in classic client. Now after release of NAV 7 / 2013 these shortcuts will not be used as classic client does not exist, so i started learning new shortcuts. While learning these shortcuts i figured out a pattern that these shortcuts are similar to that of any windows application. As for a new document we used Ctrl + N in Microsoft word and excel, new navision RTC shortcuts are similar to these. so lets study and make our work easy by learning these shortcuts. The list of shortcuts can be found

Hi all, Just a quick update on NAV 7 / NAV 2013. Microsoft have launched what we all were waiting for. Microsoft Dynamics NAV 2013 Beta Is Ready For Download in Partner Source.  There are some localized version also available with worldwide (W1) Version. So, if you got a valid partner source login, go to the Microsoft Dynamics NAV 2013 Beta Download Page and download the NAV 7 / NAV 2013 and start playing.  System requirements, Upgrade guide, what's new, and other documents are also available at above Link.

Hi all, While developing reports in classic client with Export to Excel Enabled, client wants to have Header cell merged. This is mostly faced issue. Resolution - What i did is that i added a function in Excel Buffer table which merge specified cell. Function - PROCEDURE MergeRange(FromRow : Integer;FromCol : Integer;ToRow : Integer;ToCol : Integer); VAR   FromRec : Record 370;   ToRec : Record 370; BEGIN   FromRec.VALIDATE("Row No.",FromRow);   FromRec.VALIDATE("Column No.",FromCol);   ToRec.VALIDATE("Row No.",ToRow);   ToRec.VALIDATE("Column No.",ToCol);   XlWrkSht.Range(FromRec.xlColID + FromRec.xlRowID + ':' + ToRec.xlColID + ToRec.xlRowID).Merge; END;

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------