Microsoft Dynamics NAV 2013 Now Available

Posted on October 1, 2012 by Tomas

8042884208 fe3c2fb46e Microsoft Dynamics NAV 2013 Now Available

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

Zoom Function in Dynamics NAV 2013

Posted on September 24, 2012 by Tomas

8015624803 cdcfbdc818 Zoom Function in Dynamics NAV 2013
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

Technorati Tags: , ,

Posted in Dynamics NAV / Navision, Dynamics NAV 2013, functionality | Tagged , , | Leave a 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.

Posted on September 21, 2012 by Tomas

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.
8005667885 cb6e715e68 Error when exporting budget to Excel The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

Firstly, I have checked, where the error message originates:
8005670034 39c2d198f8 Error when exporting budget to Excel The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

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

Technorati Tags: , , , , , ,

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

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

Posted on April 2, 2012 by Tomas

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

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

So, what could have caused this? Continue reading →

Technorati Tags: , , , , , , ,

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

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

Posted on January 10, 2012 by Tomas

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:
6668808969 a910ecc052 How to Create Additional No. Series For the Same Document?

But for, other customers (specifically, customers who own factories), you would like to use another set of number series:
6668809233 e1c6aa003e How to Create Additional No. Series For the Same Document?

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.
6668809537 03177839eb How to Create Additional No. Series For the Same Document?

4. In the opened form, define second number series (as per our example, that would be FSI):
6668809647 ff9727948f How to Create Additional No. Series For the Same Document?

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:
6668809879 0517ca4cd3 How to Create Additional No. Series For the Same Document?

And you will be able to select one of the two number series: CSI or FSI:
6668810075 7731faf644 How to Create Additional No. Series For the Same Document?

Result!
6668810247 c01765d60a How to Create Additional No. Series For the Same Document?

Technorati Tags: , , , ,

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

Application Method Field on Customer Card, Payments Tab

Posted on January 9, 2012 by Tomas

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).
6636922857 765bf38064 Application Method Field on Customer Card, Payments Tab

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.

 

Technorati Tags: , , , ,

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

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

Posted on January 8, 2012 by Tomas

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?6636727343 40664c1bfe Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV

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 -
    6636834365 b76cfea88d Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV
  • 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 - 
    6636727623 bbf99eb947 Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV
  • 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 - 
    6636727485 2b265364da Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV

Related Links

Technorati Tags: , , , ,

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