Jump between tabs on Dynamics NAV form with keyboard shortcuts

Keyboard shortcut: CTRL + Page Up, CTRL + Page Down

I must admit, I am an avid mouse user. I like to click everywhere when working… and while doing that I feel in control. I know it’s inefficient and I adore geeks (and old school accountants) who manage to work with Dynamics NAV without mouse at all. Knowing all these keyboard shortcuts (even without using time-saving tricks)… looks like magic. However, the more time you spend with Dynamics NAV, the more you become like magician yourself! I mean, the more shortcuts you learn anyway.

Everybody knows (ok, I understand that is bad to make generalizations based on… myself, but…) how to switch between forms with CTRL+TAB. And there are plenty of other keyboard shortcuts that we should learn by heart.

However, only recently I found one more shortcut which changed the way I interact with forms… CTRL + PageDown, CTRL + PageUp! It’s like… you can fly through Dynamics NAV form’s tabs! You can fly without touching your mouse again. Sweeeeeeet!

So, how does it work? Go to Customer card.
Customer card, General tab. CTRL+PageDown
You are on General tab. Click CTRL+PageDown.

Customer card, Communication tab. CTRL+PageDown
Communications tab. Click CTRL+PageDown.

Customer card, Invoicing tab. CTRL+PageDown
Invoicing tab. Click CTRL+PageDown.

You get the drill… Now, to jump to previous tab, just click CTRL+PageUp.

Related Links

Technorati Tags: , , ,

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

The fastest way to select a customer on sales order in Dynamics NAV

Dynamics NAV RoleTailored client is all about PRODUCTIVITY. You have as much needed information as possible on one screen, so you could work more efficiently. When in Dynamics NAV Classic client (older versions, that is), in order to be productive, you had to be uber-geek and remember all keyboard shortcuts, in Dynamics NAV RTC client it’s a lot easier to be efficient. Right?

Let’s take an example (let’s create a new sales order for customer “London Candoxy Storage Campus”)… So, we go to Sales Order page, click “New”.

RTC - New Sales Order

Start typing “London C” and you will be offered a list of customers to select. To be fair, inital list is empty (because, it is being filtered by “No.” field).

RTC - Enter Customer Name

However if you will click arrow-down button on your keyboard and arror-right, the filter will be moved to “Name” field and customers that start with “London” will appear for selection.

RTC - Select Customer Name

Now, just select the customer you want (don’t touch your mouse, yet – just click Enter on your keyboard). And done! Easy…

RTC - Order Created

But, let’s not forget how much we loved (still love?) Dynamics NAV Classic version! And (until your Dynamics NAV will get upgraded to the latest version) you might still enjoy the efficiency that Dynamics NAV Classic client can be provide. In fact, if we would look at the same scenario as we just did for RTC, we could achieve same results!

Create a new sales order.

Classic - New Sales Order

Start typing the customer name in “No.” field.

Classic - Enter Customer Name

Obviously, you will not get a list to choose from the existing customers, however if you know the customer name… just type the beginning of it and click enter.

Classic - Order Created

So, who has any other ideas to make the order creation process faster?

Related Links

Technorati Tags: , , , , , , ,

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

How to copy error message when you can’t take a screenshot?

I would like to share quick and easy tip which I use almost everyday (I saw on mibuso forum, back in 2007). If you get an error message and for some reason you can’t take a screenshot of it (let’s face it, if you will ask for someone’s help with this error message, you will need to show them what it said), just click CTRL+C (yes, the simple Copy function, which you use everywhere else anyway). Now, go back to your email client (or notepad, or wordpress – like me) and click CTRL+V.

So, instead of taking a screenshot that would look like this:

Error Message - You do not have permission to run

You will get, error message logged like this:

Microsoft Dynamics NAV Classic
You do not have permission to run the ‘Design, Codeunit, Basic’ System.

Contact your system administrator to have your permissions changed.


And the beauty of this tip – it works not only in Dynamics NAV, but almost anywhere else as well. That is, if you are running Windows! 🙂

Technorati Tags: , ,

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

How do you search for a field in Dynamics NAV Table Designer?

So, how do you search for a field in table designer? Apparently, it is a feature that everybody is waiting for… but there is a trick that could help you!

Let’s find out (I need to find “Line Amount” field in table “Purchase Line”). If you would go to Object Designer and click on table “Purchase Line”. Then click “Design”.

Table 39 Purchase Line - Design

In the table designer, click on a field name column.

Table 39 Purchase Line - In Design Mode

Then, on your keyboard press the SHIFT button and hold it. While holding the SHIFT button, click on arrow-down button once or twice. You will notice, that lines will get selected (that’s what we are after).

Click Arrow-Down Button Twice (While Holding SHIFT key)

Then (I hope you are still holding that SHIFT key button!), if you would click on the first letter of the field name, Navision will start searching for your field.

For my example, I am looking for “Line Amount”, so, if you would click on “L” a few times (while still holding down the SHIFT key), I will jump to “Line No” field – that’s not the one I need…

Found Line No Field

…so, Let’s click “L” again. And again, and again. “Line Discount Amount” – still not the one I need. Let’s click “L” again (still holding the SHIFT key). And here it is – “Line Amount” field.

Found Line Amount Field

I hope you will find this helpful. When I saw this for the first time, I could not believe I was using copy/paste table data to excel just to find a field…

If you have any questions, or suggestions, please leave a comment. Thank you!

Note: this does work with in variables and functions screens as well!

Technorati Tags: , , ,

Posted in Dynamics NAV / Navision, Tips & Tricks | Tagged , , , | 5 Comments

Dynamics NAV Support End Dates (Support LifeCycle)

Dynamics NAV 5.0 Service Pack 1 - Mainstream Support End Date

How often do you get a question – is Dynamics NAV 4.3 still supported? Or, when mainstream support ends for Dynamics NAV 5.0? If you know these dates by heart – well done (geek)!

To be fair, there are only a small number of versions that have been released (Dynamics NAV is not yet in it’s thirties!), so it would be possible to remember all these dates. However, the next time you get this question, and you don’t remember all the dates (or just want to be 100% sure, your answer is correct), just go to Microsoft Product Lifecycle Search and search for Dynamics NAV.

Technorati Tags: , ,

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

How to find the Build Number in Microsoft Dynamics NAV?

finsql.exe - file version

When logging support queries with Microsoft, you are almost always required to provide the build number of your Dynamics NAV version. And, I am sure, most of us have an idea on how to find the build number. At least, when I got this question in the past, without thiking too much, I would find my finsql.exe, go to properties and check “File version” property in Details tab. Easy? It is!

However, once somebody has shown me a great shortcut. I couldn’t believe, that I work with Dynamics NAV for a few years now and I didn’t know this trick. If you have Dynamics NAV client open, just click Help > About Microsoft Dynamics NAV (or Help > About Microsoft Business Solutions-Navision – if you are running older version) and double click where it says “Version (4.0 SP3)”, or “Version (5.00)” or… you get the drill. And, surprise, surprise, you will get the message with a build number in it!

help - about - build number

This little trick saves a few seconds every time!

Another tip (if you have tried this just now on your new shiny Dynamics NAV 2009 R2 classic client and haven’t noticed yourself) – in the latest releases build number is included in the “About” dialog… so, you do not need to double click any more. But the in-built message still works!

Related Links

Technorati Tags: , , , , ,

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

Dynamics NAV Error: The operating system returned the error (131): An attempt was made to move the file pointer before the beginning of the file.

The operating system returned the error (131)

I just love how various Dynamics NAV error messages mean totally different things for people working in different departments. For example, if you received error message (usually, when exporting data to Excel):

The operating system returned error (131):
An attempt was made to move the file pointer before the beginning of the file.

And you are:

  • end-user: Grrrrr! What’s wrong with this computer? I hate this system!
  • consultant: Operating system error? It’s not something I have seen… In your place, I would try calling helpdesk team, they might have seen this error message before.
  • helpdesk: Of course, we can help you! Could you tell us, what steps did you take to get this error message?
  • developer: Simple! Your temporary table has hit the limit of 2 GB!

In this instance, developer is right, but for end-user such explanation would be more or less meaningless. I once too was searching for detailed explanation of this error message and the closest I could get was kriki’s answer:

Because of historical reasons, a file created or opened by Navision CANNOT superate 2GB. If it superates these 2GB, you get that error.

Related Links

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, errors | Tagged , , , , | 7 Comments