Browse by Tags

Goodbye Nav_Developer, hello NAV Team-blog
20 October 09 12:44 PM | Lohndorf | 0 Comments   
To make things just a little bit simpler, some of the NAV blogs have now been combined into the NAV Team Blog . So from now on, that is where we will blog. All content from this blog has already been migrated to the NAV Team Blog. So this post will be Read More...
How using SQLIndex property can affect which index NAV uses
18 September 09 07:09 AM | Lohndorf | 0 Comments   
The usual rule for specifying a key in NAV is, that it will chose the first key that matches all the fields specified by SETCURRENTKEY, RunformLink, etc. Example: Table 21 "Cust. Ledger Entry" has the following keys (not all of them listed): - Entry No. Read More...
Filed under:
Problems in transformation forms to pages using TransformationTools
14 September 09 01:10 PM | gediminb | 0 Comments   
After Microsoft Dynamics NAV 2009 SP1 release more and more developers start using it and trying to adopt existing solutions for new 3tier environment. Most workload comes from trying to adopt current forms to new object - pages. Particularly transformation Read More...
Table Information including Index information (Usage, Blocks and Reads)
25 August 09 04:34 PM | Lohndorf | 0 Comments   
The query below combines these three queries into one: Index Usage Query Recent Bocking History Table Information Query It can be used to just see the number of records in each table. But also by just changing "ORDER BY", it can be used to see which index Read More...
Filed under: ,
Troubleshooting multi-machine installations of NAV 2009
17 August 09 06:36 PM | lalake | 2 Comments   
The NAV 2009 documentation walkthroughs provide step-by-step instructions for installing NAV 2009 on 2 or 3 machines. However, we have found that some of the same configuration issues come up time after time after installation. When on calls with partners Read More...
Translate this site using Windows Live Translator
12 August 09 07:50 AM | Lohndorf | 0 Comments   
A new translator service is now available for all whose browser is set to one of the following languages: English, German, French, Italian, Spanish, Portuguese, Netherlands Dutch, Russian, Chinese Simplified, Chinese Traditional, Japanese, Korean, Arabic. Read More...
Index Usage Information Tool
16 July 09 07:58 AM | Lohndorf | 0 Comments   
Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.: The tool is using these three Read More...
Filed under:
Attachment(s): iuit.fob
Converting company names for NAV Web Services
10 July 09 01:26 PM | scowri | 0 Comments   
A few weeks ago I saw an up tick in the number of cases having problems accessing exposed web service. Some of the problem has been because the “CRONUS USA, Inc.” company name converts to an unfamiliar “CROUNS_USA_x002C__Inc”. This will be changing in Read More...
Filed under: , ,
How to set dynamically the Key and Sort Order for the pages using NAV 2009 Web Services feature.
08 July 09 08:04 AM | dtacconi | 0 Comments   
The default methods exposed when a page is published are the so-called CRUD (Create, Read, Multiple and Delete) methods. All of those does not allow to set up previously a key for sorting order nor if the records have to be ascending or descending. In Read More...
Filed under:
How to read a SQL Profiler trace file into a SQL table
07 July 09 08:03 AM | Lohndorf | 0 Comments   
Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into Read More...
Filed under:
Strange errors come during change SourceExpr value in NAV report designer...
02 July 09 09:14 AM | gediminb | 0 Comments   
Our colleague raised problem: why he receives strange error during report compile, after he changed SourceExpr value for some control in report designer in NAV 2009. Error message was: Error while validating RDL content: The Value expression for textbox Read More...
Where is the zup file again?
01 July 09 10:12 AM | Lohndorf | 1 Comments   
I keep forgetting where the CustomSettings.config, ClientUserSettings.Config etc files are. So I keep looking it up again in "Where is the zup file" . This time, I collected the location of these files in a NAV form so I don't have to look them up anymore. Read More...
Filed under: ,
Attachment(s): zup.fob
How to manage NAV DBCS data using C#
16 June 09 07:26 AM | dtacconi | 0 Comments   
  It is known that NAV CC (Classic Client) does not support natively DBCS (Double-Byte Character Set) and so does the new NAV 2009 RTC (Role Tailored Client). Due to differences in how the CC and RTC check the code page isn’t still possible to enable Read More...
Filed under:
What do SPNs actually do - NAV 2009
15 June 09 01:36 PM | Lohndorf | 0 Comments   
Three terms keep coming up when setting up NAV 2009 when NAV-server (middle tier) runs on a different machine than SQL Server: - Delegation / Impersonation - Kerberos - SPN Delegation / Impersonation is what it says it is. Kerberos is handled more or Read More...
Filed under:
Setting up NAV 2009 on Three machines
12 June 09 02:38 PM | Lohndorf | 0 Comments   
Setting up delegation and SPNs for NAV 2009 on three machines (when the NAV Server and SQL Server are on two seperate machines) is described in "Walkthrough: Installing the Three Tiers on Three Computers" . But in addition to this, also be aware of the Read More...
Filed under:
More Posts Next page »

Search

This Blog

Syndication

Translate this site using Windows Live Translator:
Page view tracker