How to save a few hours when working with Menusuite assignments

Have you ever spent hours adding people to different MenuSuites (that is, taking people of the MenuSuite items one at a time)? If not, count yourself lucky! If you have… you must have thought “there must be a better way of doing this“? Ages ago, after spending a few days assigning various users to different MenuSuites, I was looking for a better way.

MenuSuite Assign Users

And, I have found one!

Let me introduce you to table 2000000061 “User Menu Level”. If we would jump in and open the table, we will see that there are up to two records per user, where “Level” is:

  • User Changes – this is where you right-click on the Menusuite and “Hide” an option. You can remove the menus that you don’t use and the changes will be saved under “User Changes” option.
  • User Restrictions – this is where, administrator when into the Menusuite designer, right-clicked on the menu option and selected “Assign Users…”. In doing so, Administrator can remove menu options, that user should not be able to see. All these changes will be saved under “User Restrictions” option.

The beautiful thing is that all these changes to a menusuite are being saved in “Object” field in table 2000000061 “User Menu Level”. This means, that if we have done required restrictions for one user and we need to implement same restrictions to antoher user, we can just re-use first changes. If you find yourself in situation where you are assigning a lot of users to specific menusuite options, this will save hours of your life!

Let’s say, we have a new user and we need to assign him to the same menusuites as user TOMAS. All we would need to do, is to go into Windows Access Control table, select “System Restrictions” record, copy, paste it, click OK for a warning message and retype the new username instead of Tomas. Job’s done!

Did you know about this table? Have you ever used it? Let me know your thoughts!

Technorati Tags: , , ,

Posted in Dynamics NAV / Navision | Tagged , , , | Leave a comment

How to delete obsolete Dynamics NAV objects? (Version 2)

A while ago, I had an issue, where end-user was not able to delete some objects in custom range (50000 – 99999), because objects were not licensed. I have resolved the issue by creating a “killer object”. Which worked fine, because as a developer, I did have access to range 50000 – 99999. So, I was able to delete obsolete objects.

But, as a few commenters pointed out, this approach doesn’t work if you want to delete objects that are not licensed even on a developer’s license. So, what can we do about it?

Well, Stefan has found a way! If we cannot create an object in NAV (because, license file doesn’t permit to do that), we need to turn to SQL. That’s right… we need to do something that we normally advice end-users not to do – change data in SQL side.

All you need to do, is to run a SQL query that would create a record in Object table. For example:

USE [YOUR DEV DATABASE]
GO

INSERT INTO [Object]
(
[Type],
[Company Name],
[ID],[Name],
[Modified],
[Compiled],
[BLOB Size],
[DBM Table No_],
[Date],
[Time],
[Version List],
[Locked],
[Locked By]
)
VALUES
(
YYY,
”,
XXXXXX,
‘DeleteYYY_XXXXXXX’,
0,
0,
0,
0,
‘1753-01-01 00:00:00.000’,
‘1753-01-01 00:00:00.000’,
”,
0,

)
GO

YYY – Object Type (Integer) has these options:
0 – TableData
1 – Table
2 – Form
3 – Report
4 – Dataport
5 – Codeunit
6 – XMLPort
7 – MenuSuite

Use this at your own risk! 🙂

Posted in Dynamics NAV / Navision | Leave a comment

What SQL permissions do you need to upload a Dynamics NAV license file?

Whenever you get a new license file from your partner, in order to activate the new license file, you need to upload the license file to your server. However, sometimes, you may get an error when uploading the license file. So far, I have seen two error messages, that users usually get:

The following ODBC error occurred: Error: [Microsoft][ODBC SQL Server Driver] Database is invalid or cannot be accessed. State ID: HY024:

Error Database is invalid or cannot be accessed

This error means, that you have only “public” server role and “public” database role. You don’t have more permissions on SQL Server side.

The follow SQL Server error or errors occurred: 229,”42000″,[Microsoft][ODBC SQL Server Driver][SQL Server]The UPDATE permission was denied on the object ‘$ndo$srvproperty’, database ‘master’, schema ‘dbo’.

Error The UPDATE permission was denied

This error is different from the previous one, because you do have more sql permissions on the database from which you are trying to upload a license file. You have db_owner permission on the database side, but you still have only “public” Server Role.

Both of these errors mean that you lack permissions on SQL Server. So, what sql permissions do you actually need to upload a Dynamics NAV license file?

Well, firstly, you need to know what happens when you upload a license file. When you click Tools > License Information > Upload, system will upload the license file to the database you are connected to and then to the “master” database. Therefore, you need sql permissions on both of them.

This can be achieved one of the two ways:

1) You need to have “sysadmin” Server Role.
2) Or, you need to have “db_owner” role on database level for both your NAV database and master database. Then, from “Server Roles”, public role will be sufficient.

Having one of the two of the above, will allow you to upload the license file.

The server license was successfully uploaded

Technorati Tags: , ,

Posted in databases, security, SQL | Tagged , , | Leave a comment

Ctrl + Alt + Delete does not work on remote desktop?

Ctrl + Alt + Delete does not work on remote desktop?
Use Ctrl + Alt + End instead!

Posted in Dynamics NAV / Navision, Tips & Tricks | Leave a comment

Error: The remote session was disconnected because there are no Terminal Server License Servers available to provide a license file

Once in a while when connecting to customer’s system using remote desktop published via Citrix, I get the following error message: The remote session was disconnected because there are no Terminal Server License Servers available to provide a license. Please contact the server administrator.

And because it doesn’t happen too often, each time I end up searching for a fix for this issue. Never again! 🙂 Let’s write it down, and let internet remember.

The Error: The remote session was disconnected because tehre are no Terminal Server License Servers available to provide a license. Please contact the server administrator.

The Fix:
1. Run REGEDIT
2. Take a backup (Export) of folder [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing]
3. Delete [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing] folder
4. Reboot your computer
5. Run “Remote Desktop Connection” shortcut as Administrator (this will recreate MSLicensing folder in registry editor)

Technorati Tags: , , ,

Posted in Dynamics NAV / Navision | Tagged , , , | Leave a comment

Book: Microsoft Dynamics NAV Financial Management

It’s interesting to work in a field where there are almost no books about it. Well, this is not true any more, as nowadays in Dynamics NAV field we have more books than ever before. However, just several years ago, when I first opened Dynamics NAV client, there were almost no books about it. The best you could get (if you worked for a partner) were technical training materials from Microsoft. And, if you work for end-user, then help files were your best friend. However, now (when product is changing so fast) it’s becoming easier to learn about Dynamics NAV. However, every time a new Dynamics NAV book is published, I try to get a hold of it.

And the latest book I’ve managed to get my hands (thank you, Tobin!) on is – Microsoft Dynamics NAV Finanacial Management. I would say the book is different from other Dynamics NAV books. What do I mean by saying that? All the previous books where designed by geeks for geeks (who not only work with NAV, but love it, and want to know every single detail of it). This book is different. It comes to you with a fresh approach – starting from the basics – Financial Management functionality in Dynamics NAV.

First time I have read it, I am not sure I liked it. I have read through all of it in one evening and thought – “what, that’s it“? Then I kept thinking for a few days, would I recommend this book to anyone? Where I work, everyone joining our team, need to take the financial exam in Dynamics NAV, because having the financial management knowledge, is one of the cornerstones of knowing and working with Dynamics NAV. So, would this book be a good place to start?

If you have started working with Dynamics NAV a few weeks ago, and don’t know what can be done with this product – this book will definitely give you an overview and examples of what is possible. If you have worked with Dynamics NAV as end-user for some time now, this book will confirm that you have been doing the tasks the right way. However, if you have worked with Dynamics NAV for a few years now, and you think that you really know ins and outs of the program – the book might give you “what, that’s it?” feeling.

Though, when reading a book for a second time (and third time), I’ve found a few more things that I liked about the book. There might be some things in NAV, which you understand  really well, but when in comes to explaining why this functionality works in particular way to a user who is less familiar with the product (for example, of why you need to nullify incorrectly posted invoice by raising a credit memo with incorrect data, and then raise a new invoice with correct data), this book can give you helpful insights.

If you have started working with Dynamics NAV recently, or if you have a new colleague, I would recommend to read this book. If you have been around for a few years, you might be able to pick up only a few little things, but it’s still worth going through the book.

So, have you read “Microsoft Dynamics NAV Financial Management“? What did you think of it?

Source:

Microsoft Dynamics NAV Financial Management @ PACKT Publishing.

Posted in books, Dynamics NAV / Navision | Leave a comment

Microsoft Dynamics NAV 2013 Now Available

Dynamics 2013 is released!

I think the GAME has started on NAV techdays 2011 (yes, 2011!) – when I first saw the Dynamics NAV 2013 being presented. And it was awesome!

Today, is an AWESOME day as well –Microsoft officially released Dynamics NAV 2013.

Related Links

Technorati Tags: , ,

Posted in Dynamics NAV 2013 | Tagged , , | Leave a comment