Thursday, May 17, 2012

Navision RTC Shortcuts vs Classic Shortcuts

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 at this link.

Navision Classic & RTC Shortcuts.


Let me know if you find it usefull.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Tuesday, May 15, 2012

Download Microsoft Dynamics NAV 2013 Beta...

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.

Tuesday, May 8, 2012

Navision Export To Excel with Merge Cell Function

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;

Wednesday, May 2, 2012

VIEW SERVER STATE permission on SQL Server?

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