Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi all, Most of time while trying to attach a database in SQL Server We face a issue. ERROR Message - TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:Databasefilepath.mdf'. (Microsoft SQL Server, Error: 5123) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.4000&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476 ------------------------------ Resolution - While starting SQL Server Managment Studio, dont just double click the icon, Right Click it and select Run As Administrator. Thanks & Regards, Saurav Dhyani

Hi all, Navision have introduced new type of Reports Jet Reports. Lets see some details about the product. As of today Jet Reports Express for Microsoft Dynamics NAV is available for download at PartnerSource and CustomerSource for customers on an active Business Ready Enhancement Plan. Partner Source  JET Reports For Navision Customer Source  Jet Reports For Navision

Hi all, Some Client requires to take database backup on daily basis but due to increasing size of data its is tedious and time consuming if we suggest to go for Navision Backup.At this point the best solution to suggest is to take backup from SQL Server.So lets discuss how to take backup of a database from SQL Server Managment Studio. For taking Backup from SQL Server there are certain steps -

Hi all, While browsing over web about new features of Dynamics NAV 2009 R2, i find some information about same in Waldo Blog. The title of the Blog is Dynamics NAV 2009 R2 is not a "normal" release ... beware!.  After reading the Blog i was surprised and thought that every partner and customer should know about the same. So before upgrading to Dynamics NAV 2009 R2, please read the article at Waldo Blog. You can read the post here .        Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/  

Hi all, I figured out that lot of us find issues while designing Pages. So I thought why not start writing about Pages. Lets see different types of Pages in this Post and Later on in other posts we can discuss how to create them and transform them.

Hi all, Yesterday i restored the backup of a R2 Database in Navision. After Restoring i tried to start the role tailored client but i gave me an error. The error is shown is screenshot below. Resolution for the Error- 1) Open the database in classic client. 2) From the file menu, Under databases select ALTER. 3) Go to Options Tab. 4) First check the Single User check box and Then select check for for Enable for Microsoft Dynamics NAV Server. After that click ok and close the database. Then again follow the steps from 1 to 3 and uncheck the Single user and Click Ok. Try Starting Role Tailored Client, it will work now. Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com

Hi all, Last week I required to do some customization on 5.x database that i have already done on 2009 SP1. It consist of multiple tables and Reports so i was frusted that i have to do it again for 5.x as i cannot just import the objects of 2009 SP1. While looking for some solution on the web, i find out that Mr. Rashed Amini have developed a tool which can downgrade objects from 2009 SP1 to 5.x and older versions of navision. I used the tool and everything worked fine. What this tool does is  remove the 2009 specific areas out of the text file and then importing them into 5.0 or older executables.you can try and test the tool. You can find the tool on Rashed Amini Blog here   here (Updated on 16-11-2015) . Thanks To  +Preslav Velkov  for the Updated Link. Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, While Locking a case in Microsoft Partner/Customer Source it asks about the certain details about Navision Version being used. Most of us find issue where it ask for Navision Build. So in this post we will see where we can find the Application Build for Navision we are using.

Hi all, Most of time customer requires data from Navision, but they also request to have headers in the output. We create a dataport but the problem occurs while having headers for the values. Let’s see how we can do this- Create a new dataport for Customer Table which will export Customer No., Name, City and Contact. Once you are done with creation of dataport and adding dataport fields, go to OnPreDataItem().

Hi all, While trying to figure out new features in Navision 2009 RTC I figured out a new feature called Notes/Links. In Navision 2009 RTC, you will find a system part called as Notes. Let’s see how we can use this. Below is the image which shows a list of Sales order in Role Tailored Client and you can see a note window in the right hand side. As soon as user opens an existing order or creates a new order, he/she can put his comments about the same and notify the user whose windows login is synchronized in the database. As I opened a sales order, I can see a link for creating a new note in the right hand panel (Fact Box). As soon as user clicks on the link to create a new note, he get a window opened which ask for certain information. 1) Your message/ comments. 2) User Id whose you want to send the notification. 3) A Boolean for Notify. User select one of the user from the list and click on the notify Boolean and then save the note. When t

Hi all, We always face issues while using NAS. Lets discuss how we can install, configure and use Navision Application Server (NAS). Go to Server Folder in the installation disk of the Navison version for which you want to start the Navision Application server. Install the server on the disk. This will create a service, go to services.msc to change the startup parameter of the service and use an administrative account to start the service.

Hi all, Sometime we face an error in SQL Server while performing transaction in Navision. ERROR - (Error 9002) The following SQL Server Error or errors occured when accessing the "Table Name" table: 9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for  database 'Database name' is full. To find out why space in the log cannot be reused, see the log_reuse_Wait_desc column in sys.database. SQL: Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where  query. Reason For Error- The error is due to space avilability in the disk where Log file reside. Resoultion - There are multiple options for the resoultion of the same, choose one that best suite you- 1) Backing up the Log. 2) Freeing Disk Space. 3) Moving the Log File to a Different Disk 4) Increasing the size of a log file. 5) Adding a log file on a different disk. 6) Completing or killing a long-

Hi all, A Comman error faced while trying to Run a Report From Role Tailored Client (a report with no layout defined), it try to start the Report Engine from classic Client. It can happen that after updating RTC, you end up with a version of RTC which is not compatible with the default classic client. In this case you will typically get this error message when trying to run the report. First of All you need to find the build of classic and Role tailored client. The Build for both should be same. Following screen shows how to check the build for both client. If the build is diffrent you need to udate the Build using this link (require Partner/Customer source login). If the build is same then we need to find out from where does RTC find the classic client for running classic reports? RTC finds the location of Finsql.exe in this place in registry: (can be opened by typing regedit in RUN) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\

Hi all, We all face situations where clients ask for some  specific   requirement  as per user, as in he want that user cannot see anything other than a certain page or something like this.  By using command line parameters we can  achieve  that.

Hi all, If you get “User ID and password are invalid. try again?” when starting RTC you need to first check that you can login to database in the classic client. Reason for the Error Windows Login is not synchronized with Database. You are trying to connect a database which does not have your windows Login.

Hi all, While Trying to open a database that is created in Navision client with country  specific version we face the error shown below. Error in Classic Client

Hi all, A friend of mine asked me yesterday that one of his client want to change the Drop Down option in RTC Page. As shown in image below, and client says that when he want to choose item No. he don't want No., Description, Base Unit of Measure, Bill of Materials, Unit Price.

Hi all, Debugging of an Add-in in the client is very simple. After the client has started up all you need to do is to attach the Visual Studio to the process of the Role Tailored client. For debugging compile your project with the “Debug” solution configuration.

Hi all, ­­­­we all have read in Microsoft manuals for NAV 2009 Page Development that most of the page control properties are not limited to values yes and no. Now developer can use a Boolean variable and change the property value on the runtime by using that Boolean variable at run time. But what, when I first tried to use same if didn’t worked and I was amazed so I re- read the manuals but didn't find any resolution for the same.

Hi all, When we install Navision 2009 and later on 64 bit operating system, most of us get error like shown below while we try to connect Role Tailored Client or Classic with Windows authentication. In this article, we will discuss why this error message and how to resolve this.