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)

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

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

Zoom Function in Dynamics NAV 2013

About This Page
How many times have you used function Tools > Zoom? If you have, obviously, you know the keyboard shortcut for that – CTRL+F8, and you use it daily (or at least I do!).

I was watching Dynamics NAV 2013 training “Microsoft Dynamics NAV 2013 Finance New Features – Dimensions” today, and quite a few times Alessandro said “to Zoom in” click… CTRL+ALT+F1.

After a few times trying this keyboard shortcut, I would say, it is better – you can manage this combination with one hand, when for older one you needed two. However, it might be confusing for new Dynamics NAV users to understand “Zoom In” function – as it is no longer called that.

In Dynamics NAV 2013, it’s called “About This Page”. So, whenever, someone will tell you to Zoom In to page details, remember, to either go to Dynamics NAV > Help > About This Page, or CTRL+ALT+F1.

Related Links

Posted in Dynamics NAV / Navision, Dynamics NAV 2013, functionality | Tagged , , | 1 Comment

Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

Sometimes you get a question, which seems so easy, that you know the answer instantly. You need to follow simple steps and the issue will be resolved. However, just to be sure (before giving the answer) you try the solution yourself, and you bang your head into another, totally different issue.

Today, I was trying to answer how to export budgets that have been filtered by dimension to excel (with a possibility to modify the budget in excel and import it back to Dynamics NAV). Hint: it is not enough to apply a filter on Dimension Filter field, in Filters tab, in the Budget form. You need to select “Column Dimensions” on Options tab, in “Functions > Export to Excel” report’s request form. But, I will write about this some other time.

Today, when explaining, how to export the budget with “Column Dimensions” defined, I have encountered the error message: The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.
Error when exporting Budget to Excel - The call to member Add failed

Firstly, I have checked, where the error message originates:
Error when exporting Budget to Excel - Function CreateRange

Secondly, I had a look if this code has been changed in later versions (I was getting error message in Dynamics NAV 5 SP1). Strangely, the function CreateRange in Dynmics NAV 2009 was exactly the same, but I wasn’t getting the error message in newer version.

After further analysis and research, I’ve worked out that this seems to be a known-issue for Dynamics NAV 5 SP1 (lately, I haven encountered quite a few “known-issues”) – the problem occurs when exporting a dimension code that contains blank space (or special characters) to Excel 2003/2007. This, however, works fine when exporting from Dynamics NAV 2009.

So, a workaround (until you will get upgraded to a newer version) would be to follow these steps:

1. Click Financial Management.
2. Expand General Ledger, and then click Budgets.
3. In the Budgets dialog box, click Functions, and then click Export to Excel.
4. In the Export Budget to Excel dialog box, click the Options tab.
5. In the Column Dimensions field, click the ellipsis button (…).
6. In the Dimension Selection dialog box, make sure that the dimension codes in the Code column do not contain a blank space or special characters.
7. If the dimension codes contain a blank space or special characters, rename the dimension codes. For example, if a dimension code is named “My Name,” you can rename the dimension code to “MyName” or “My_Name.”

Posted in Dynamics NAV / Navision, errors | Tagged , , , , , , | 1 Comment

Error: You do not have permission to read the 0 table.

There are quite a few error messages you can get when setting up Dynamics NAV security – database is invalid or cannot be access, you do not have permissions to read the table, etc, etc. And once you have seen them, next time you will know (more or less) possible solution for it. And I thought I have seen all of them by now. However, today, I’ve seen one more error, which I have seen before, but the cause of it was different! You do not have perission to read the 0 table (SUPER user was trying to create another SUPER user and received this error message).

You do not have permission to read the 0 table - Error

So, what could have caused this? Continue reading

Posted in Dynamics NAV / Navision, errors | Tagged , , , , , , , | 1 Comment

How to Create Additional No. Series For the Same Document?

Just a few days ago, I have written How to Create No. Series in Dynamics NAV, and today I got one more question about No. Series. How to create an use additional No. Series for the same document type?

For example, let’s say, that you want to use one number series, for most of your customers:
No. Series Relation - First No. Series

But for, other customers (specifically, customers who own factories), you would like to use another set of number series:
No. Series Relation - Second No. Series

How would you achieve that? Well, (as in most cases with Dynamics NAV setups) this is quite easy.
1. Firstly, you need to create both number series.
2. Secondly, you need to define the first number series in setup (as per our example, that would be in Sales & Receivables Setup, Numbering tab, “Invoice Nos” field, select “CSI” No. Series).
3. Go to Administration > Application Setup > General > No. Series and find “CSI” No. Series. Click Line > Relationships.
No. Series Relation - Series Relationships

4. In the opened form, define second number series (as per our example, that would be FSI):
No. Series Relation - Define Relationship to Second No. Series

And that’s it! Now, when creating sales invoices, all you need to do (after clicking F3, or Edit > New), is to drill down into “No.” field:
No. Series Relation - New Sales Invoice

And you will be able to select one of the two number series: CSI or FSI:
No. Series Relation - Select Second No. Series

Result!
No. Series Relation - Sales Invoice With Different No. Series

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | 1 Comment

Application Method Field on Customer Card, Payments Tab

Recently, I have been asked what is the use of Application Method field on Customer card, on Payments tab? Without looking at the field, my initial response was Huh? (I have never used this field before).
Application Method Field in Customer Table

I quickly jumped into CRONUS UK database and filtered customer list setting Application Method <> Manual. The result – only 1 customer (20000 Selangorian Ltd). This would explain the reason, I’ve never seen this field – even in CRONUS there is only one example!

However, as always, Dynamics NAV help files can answer such straight-forward questions (no need to know everything, right?).

Application Method Field on Customer Card, Payments Tab
In Application Method field you can choose how the program will apply payments for this customer. To determine the application method, click the AssistButton in the field and select one of the two options:

  • Manual – If you select Manual, you must manually specify in the Apply Customer Entries window which sales document a payment applies to.
  • Apply to Oldest – If you select Apply to Oldest, the program will automatically apply the payment to the oldest of the customer’s open entries.

If you do not enter anything here, the application method will be Manual.

 

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

Functions > Reverse Transaction… on Customer Ledger Entries Form in Dynamics NAV

Have you ever noticed a function called Reverse Transaction… on Customer Ledger Entries form? Have you ever needed to use it? Do you know when you can use it?Functions Reverse Transaction on Customer Ledger Entries

Functions > Reverse Transaction… is part of default Dynamics NAV functionality, however it cannot be used on all Customer Ledger Entries. There are a few prerequisites to use that function – Customer Ledger Entry, that we will be able to reverse:

  • must not be reversed already.
    If you are trying to reverse Customer Ledger Entry that has been reversed already (or that has been created because of using Function > Reverse Transaction, you will get error message – You cannot reverse Cust. Ledger Entry No. because the entry has already been involved in a reversal –
    You cannot reverse Cust. Ledger Entry No. because the entry has already been involved in a reversal
  • must not be applied (note: you can unapply entries though, prior to reversing them)
    If you are trying to reverse Customer Ledger Entry, that has been applied, you will get error message saying – You cannot reverse Cust. Ledger Entry No. because the entry is either applied to an entry or has been changed by a batch job – 
    You cannot reverse Cust Ledger Entry No because the entry is either applied to an entry or has been changed by a batch job
  • must be posted from a journal (that is, Journal Batch Name must be filled in).
    If you are trying to reverse Customer Ledger Entry that does not have Journal Batch Name filled in, you will get error message saying – You can only reverse entries that were posted from a journal – 
    You can only reverse entries that were posted from a journal

Related Links

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