Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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