Monthly Archives: December 2011

Import Budget into Excel in Dynamics NAV RTC

When you’re working in the RTC environment in the G/L Budgets, the standard NAV function is that you can export the Budgets into Excel, edit it, then import it back in in the same Excel format. This works fine in the classic client, however, when you try to import the budget in Excel in the RTC environment, you get the error message:

Dates have not been recognised in the Excel worksheet

The problem, as explained by my local Microsoft rep, is caused by the Dynamics NAV server recognizing the field in Datetime instead of just regular date. The solution to this problem is to modify report 81 with the following object.

Report81RTC

The code for the changes is found here:

http://www.mibuso.com/forum/viewtopic.php?f=23&t=46932&p=247791#p247791

Auto-hide Taskbar Does not Autohide in Windows 7

This post is not Dynamics NAV (Navision) related, but I hope it’ll be extremely helpful because real estate space is really scarce on the desktop. Especially when you’re trying to cram all that data on to your screen.

This was troubling me for the longest during one of my demo sessions. Basically, I set my start menu to use auto-hide because I want to utilize all the space on my screen. The taskbar really gets in the way of everything we do.

Sometimes, the taskbar will not auto-hide. After browsing Google, the problem is caused by some notification or processes running in the background. What troubled me was that this only occurs every so often.

The problem is caused by the SQL Server Management Studio. You know, the annoying notification that asks you to give them your opinion on SQL Server. It turns out, you can’t just ignore that or else your taskbar will never autohide. The way to resolve it is to do this:

Basically, you have to set the Behavior of the SSMS notification to Hide Icon and Notifications. After changing this, my Auto-hide taskbar is working again.

If you don’t have SQL Server running in the back end, then I would suggest hiding the Icon and Notification for the different programs to see which one is causing it.