Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi all, Please make sure that u have installed Web client from the DVD web Client folder but it will not work by installing that way. Let’s see the steps how to install web client.       1) Please make sure that these components have been installed in your windows OS. For same go to Control Panel, Program and Features . Click from the left hand side Turn Windows features on or off.

Hi all, Lets see how can we install Share point client on windows 7. We would require Share Point Foundation 2010 before installing navision Sharepoint Client. You can download Share Point Foundation from here . Run the setup after downloading the setup. If you are trying to install it in windows 7 as i am doing it, you might find error as shown below -

Hi all, Microsoft have shared the release date of NAV 2013 for Partners. We don't need to wait so long it will be available on 23 September 2012. Here are the complete details of event Click Here. So get ready to using NAV 2013 complete Version. Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, While Restoring a SQL Backup from SQL Server Management Studio sometime we get an error as shown below - System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\SQL\Databases\\TestDB_2012_10.mdf'. (Microsoft.SqlServer.Smo) Cause of Error we typed the name incorrectly during the file name creation in Restore Operation. Resolution  - Check out the file name in Option tab of Restore Database window. You would have put two \\ instead of one while specifying the path where file should get created. Below is the image of what i did - Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, One of my friend reported an error while trying to attached a database received from client to SQL SERVER 2008 R2. The database received have only two files one is .mdf & second one is .ndf. while attaching database to the server he was getting below error - TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'XXX-XX--XX'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Directory lookup for the file "G:\SQLLOG\NAV_D_CQPA_370B_Log.ldf" fa...

Hi all, some time we face issues when RTC Client Crashes. There can be multiple issues for the same. below is the screen shot for same. The Event Viewer Details for the Error is -.NET Runtime 2.0 Error Reporting. EventType clr20r3, P1 microsoft.dynamics.nav.client, P2 6.0.0.0, P3 4d030e65, P4 microsoft.dynamics.nav.client.ui, P5 6.0.0.0, P6 4d030e5c, P7 74e, P8 69, P9 k0r55xemoobpb22dbjzdn4p0sfjo3u25, P10 NIL. Below is the error message for same. Generally these issues comes due to issues in Role Center Pages in Navision 2009 and later. You can filter objects by using filter @*Role* in Pages. Below is the List of Pages in NAV 2009 SP1 IN Database. Case 1 - When the values in cues is negative. Then due to having a negative value in integer field crashes the client. These tables can be found by filtering tables in NAV 2009 & later by @*cue*. Below is the List of Tables in NAV 2009 SP1 IN Database. Most of the fields in these tables are flowfield, if by a...

Hi all, Sometime User want to force the user to click on the Cancel button instead of pushing the Esc key. This can be done From in Navision from Tools Menu in Navision Menu and select Options. There is an option Close Forms On Esc which is by default set to YES, set it to No. Refer to screen below. This option will set the ESC Disabled for all objects. If we want to customize this for a specific form follow steps below - 1. In the form declare a Boolean variable i.e. OverwriteEsc. 2. Set the Cancel property of the Cancelbutton to No 3. In the OnPush trigger of the Cancel button and Ok button: OverwriteEsc := TRUE; 4. In the OnQueryClose Trigger of the form: EXIT(OverwriteEsc); Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, Most of us are aware with Navision Backup but at the same time unaware of SQL Server Backup. So lets discuss how to restore a SQL Database backup. Let see the steps how to restore a SQL Server Database Backup.

Hi all, While Restoring Database on SQL Server Management Studio, some of us encounter an error i.e Error 3154- "The backup set holds a backup of a database other than the existing database". Resolution for the error After selecting the database backup, goto option Tab from the Left Hand Side Menu and click on First Restore Option i.e Overwrite the existing database(WITH REPLACE) as shown in screen below. * Make sure that there is no database file exist at the path mentioned in RESTORE the database file as section  with same file name otherwise it will replace those files. For Reading How to Restore a database from scratch in SQL Server Managment Studio, read article here . Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.in/

Hi all, Sometime client face issues while posting transaction that Table is Locked by a particular User. Yes, i know that if a user is Performing a huge transaction then it happens and we can identify that from File - Database - Information - Session Tab. Here we can get the User Name in Blocking User ID Field. But what if the Blocking user id is BLANK . What can be the reason of the Locking message that client users are getting?

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 Us...

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) ...

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    ---------------------------

Hi all, while connecting to RTC and we have multiple services we find mutiple URL for the service to connect in the window of select server. Lets see how we can remove the list. Resolution - Once we try to connect to a particular service it get stored in the URLHistory key of the client user setting files which is stored in the "C:\Users\username\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\60" . Delete the value from the URLHistory and yes that it, the list will be removed. I hope you will find the soultion usefull. Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.in/

Hi all, NAV TechDays 2011 just ended. Don't worry if you haven't attended the same.  Please go to the link  for downloading videos and Presentation of NAV TechDays 2011.. List of Videos Available on mibuso - NAV TechDays 2011: Let's bring the RoleTailored Client to the next level (Movie) NAV TechDays 2011: Administrating NAV '7.0' with Windows PowerShell 2.0 NAV TechDays 2011: Administrating NAV '7.0' with Windows PowerShell 2.0 (Movie) NAV TechDays 2011: Opening Keynote (Movie) NAV TechDays 2011: Developer Tools in NAV '7.0' (Movie) NAV TechDays 2011: Reporting story in NAV '7.0' (Movie) RTC AddIn DragNDrop   Thanks & Regards, Saurav Dhyani https://www.sauravdhyani.com/

Hi all, I was just thinking that there should an way that when we start an different RTC Client that is not installed in machine, we should not get an error. If you haven't read the post how to do it then go to the link . Why it happens - Role Tailored Client try's to pull up the last service that have been used successfully to connect. As in earlier post we created multiple services for multiple versions and every service is running. So how the RTC client will figure out which service to run when we click on shortcut of a particular version RTC.

Hi all, Sometime while trying to connect database in classic client with windows authentication or connect to Role Tailored Client we face an error message. Error - The following ODBC error occurred: Error: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context  State ID: HY000

Hi all, Now a days Convergence 2012 is going on. If you are unable to attend you can view the presentation using the link . You need to create an account on Virtual Convergence and then from sessions select MS Dynamics NAV. You will find Videos there. Summary of Microsoft Dynamics NAV "7" : The Overwiew-

Hi all, In Case of Report Development in Landscape Format, it was behaving wired. In need to select the printer orientation from the printer settings. But later on I thought about the same and started searching on the web. Then From MSDN i found out that if the report settings in RDLC are done correctly then we don't need to change the printer settings every time.

Hi all, I did some changes in the pages & Reports During run time and save the view.Now i wanted to revert those changes to the standard Navision settings. In Microsoft Dynamics Navision Classic Client we can do this by deleting the zup file as this file store all the personalization settings.But what about the Role tailored Client? For Role Tailored Client there are two ways to do it - 1) Delete the PersonalizationStore.xml. This file is located at \Administrator\Application Data\Microsoft\Microsoft Dynamics NAV.This file is used to store all user changes like resizing the columns in the pages. You can delete this file, If you want to roll back all the changes. The Problem with Way 1 is that it will delete all your settings, what if if you dont want to delete all personalization settings but selective setting. Here is the another way. 2) Go to Object designer, & Run Table 2000000080 Page Data Personalization. This table contain a record for each personalizati...

Hi all, If we don't follow the installation & configuration of NAS properly we find a most common error. The Event Viewer Shows it as Event Type: Error Event Source: Microsoft Dynamics NAV Classic Event Category: None Event ID: 1000 Date: 3/13/2012 Time: 4:43:21 PM User: N/A Computer: XYZ

Hi all, While trying to install NAV Application Server(NAS), i faced lots of challenges. So i thought to prepare a How to install NAS. Remember some Points before you start - 1) NAS Require a Windows Login to start. This is because it is a service and it is not possible to define a database login in a service. So you need to create a login in the domain or on the server to do it. 2) SYSADMIN Rights to Windows Login in SQL Server. Now you have your Windows login, but this login has NO rights yet in SQL-server. So you need to create that Windows-login in SQL-server and make him sysadmin. See the manual on how to do that in SQL.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searchi...

Hi all, While trying to open the Report Layout of a Report I faced a strange error that says. --------------------------- Microsoft Dynamics NAV Classic --------------------------- The provided metadata is not valid. --------------------------- I searched on the web and after finding the solution, I was kind of felling angry.

Hi all, Sometime we face the error while trying to connect or change company in Role Center Client. Metadata for object of type Table with id 20000000xx is in a failed state. This is caused by a previous exception:  Object of type Table with id 20000000xx could not be found.  xx Can Be - 01,07,09,10,20,22,24,26,28,29,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,55,56,58,59,63,70. These are the System Hidden Tables in Navision. For the list of hidden tables refer this post . Where is Metadata Stored? Metadata is stored in Table 2000000071 Object Metadata for all navision objects ( visible / hidden). Why this error? This error occured if there in no metadata for any object in the table. When Metadata is Created? This has been created while we restore the database,if you remeber there is a new process in RTC Versions "PROCESSING OBJECTS" after creating keys. How to create Metadata? For Visible objects you can compile the object and the metadata will...

Hi all, While browsing partner source today, i found out some good articles which i thought would be great to share on BLOG so others can read and use the information. Updates from Microsoft (* for all these links to work u need a partner source / customer source Login) - 1) Microsoft Dynamics NAV Developer Toolkit Being Discontinued as of October 1, 2011 2)  Microsoft Dynamics NAV 2009 R2 Pricing and Licensing Announcement 3)  Microsoft Dynamics KB Articles Now Publicly Available Online 4)  Mainstream Support for Microsoft Dynamics NAV 5.0 Ends April 2012 5)  Statement of Directions for NAV '7' Updated! 6)  A new Create PDF feature is available in the RoleTailored client of Microsoft Dynamics NAV 2009 Thanks & Regards, Saurav Dhyani www.sauravdhyani.com

Hi all, Most of time we try to figure out the Hidden Tables in Navision. I required the same list, it took a long time to find all hidden tables, so i thought that it might be useful to others too. This list if for Microsoft Dynamics NAV 2009 R2. 2000000001 Object 2000000007 Date 2000000009 Session 2000000010 Database File 2000000020 Drive 2000000022 File 2000000024 Monitor 2000000026 Integer 2000000028 Table Information 2000000029 System Object 2000000037 Performance 2000000038 AIIObj 2000000039 Printer 2000000040 License Information 2000000041 Field 2000000042 OLE Control 2000000043 License Permission 2000000044 Permission Range 2000000045 Windows Language 2000000046 Automation Servers 2000000047 Server 2000000048 Database 2000000049 Code Coverage 2000000050 Windows Object 2000000052 Windows Group Member 2000000053 Windows Access Control 2000000055 SID - Account ID 2000000056 User SID 2000000058 AllObjWithCaption 2000000059 Breakpoints 200000...

Hi all, While browsing for RTC Report Development i found out something, which i thought to share will all. Some videos for Report Designing in RTC have been uploaded in YouTube.  Have a look on the playlist here . Thanks & Regards, Saurav Dhyani www.sauravdhyani.com

Hi all, Microsoft SQL Server has an import and export wizard that assists you in copying Navision data from one database to another. This import and export wizard is available in any version of SQL Server, and it lets you copy tables, data, functions and other database objects. This is beneficial when you want to move your Navision data to a faster server for better querying performance.

Hi all, Which doing a implentation i found a error, and i thought of sharing same so that others who face this issue can reslove same without spending time which i did. Everything done, from syncronization, change listener but the error remains same as shown in screenshot below. After searching i found out at MSDN that this is due to SQL Server and Firewall. For SQL Server the ports used is 1433. Steps to Resolve Error - 1) On the Start menu, click Run, type WF.msc, and then click OK. 2) In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. 3) In the Rule Type dialog box, select Port, and then click Next. 4) In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next. 5) In the Action dialog box, select Allow the connection, and...

Hi all, Today i came across a different type of query,where my client who is using Navision 2009 R2 RTC Client. He wanted to only Role specific jobs to all his users. Yeah we have a hotfix for the same which can hide department button from the Role Center page and user can only see the task that he need to perform. * Detail of the hotfix for hiding department from RTC can be found in this post . But the query was that he don't want to hide the whole department button from the role center page. What he wanted that Users other than finance and Administration can only see all other department than these two. He only wanted to hide Administration and Finance Menu from Department. Unfortunately microsoft have no hotfix for the issue, so i created a suggestion for the same at Microsoft connect. If you think that this is importany than vote for it here . We will find it in new release of navision. But while exploring this option i figured out that if the user wants to hi...

Hi all, This had been so late to share this, but i think people still searching for this. Microsoft have release a hotfix to Remove Departments Menu and Disable Personalization Feature Enhancements in Microsoft Dynamics NAV 2009 RoleTailored Client In Microsoft Dynamics NAV 2009 R2 and in Microsoft Dynamics NAV 2009 SP1 with build 31671 and later the following 2 Personalization feature enhancements have been added:     1.   Remove Departments menu from Navigation Pane      2.   Disable Personalization For more information visit:   CustomerSource or PartnerSource Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, Most of time we heard that this problem in navision can be resolved by deleting ZUP file, lets see what is it and where it is stored. What is ZUP file? The Dynamics NAV ZUP file is used to store the user setup and preferences for the current session so that they are "remembered" for the next session. What operations can be performed on ZUP file? The ZUP file can not be edited but it can be deleted. Where ZUP file is stored in windows XP or windows 7 ? In Windows XP, zup file is stored in - C:\Documents and Settings\ username \Application Data. In Windows 7, zup file is stored in - C:\Users\ Username \AppData\Roaming. Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports. Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout. I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

Hi all, Let see how can we achieve Page Number in RTC Reports as Current Page/Total Pages in RTC Reports. Design any of the standard reports I used purchase invoice, and go to RTC Layout of the report From View - layout. I have added a new text box in the report Header, then i went to expression by right-clicking on the text box.

Hi all, Instead of placing the actions in the standard categories like New, Process and Report, you can also place your action to your own categories. The following steps will show the process with an example: 1) In the object designer, design the page 30 Item Card. 2) Move to the last blank line in the page. 3) Go to the Actions using View Actions. 4) Go to the properties of the Action you want to move to the new Category.     Change the following properties:           Promoted to Yes           PromotedCategory to Category4 .           *Category 4 to 10 are available in the NAV 2009 SP1, other than the standard categories like New, Report and Report.           PromotedIsBig to Yes/No(as required) 5) Go to the Page properties and change the PromotedActionCategoriesML property value like below:      ENU=New,Process,Report,New Category First t...

Hi all, Navision Page Property InstructionalTextML. Used For Declares the multi-language text label that will be displayedon the page before any other user interface element. It only has effect on ConfirmationDialog type Pages . Example - PAGE 343. The Label for the Page - "The quantity on inventory is not sufficient to cover the net change in inventory. Do you still want to record the quantity?" is set as the value of InstructionalTextML property of Page. Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Hi all, This topic describes how to use SQL Server Management Studio to set up SQL Server Agent Mail to use SQL Mail. Before you can use SQL Mail, you must enable SQL Mail and set up a mail profile. SQL Mail can be enabled by opening the Properties dialog box from the SQL Mail node, by using the Surface Area Configuration facet of Policy-Based Management, or by the using the sp_configure stored procedure.

To schedule a database backup operation by using SQL Server Management Studio in SQL Server, follow these steps: 1) Start SQL Server Management Studio. 2) In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list. 3) Click Connect.