22
Sep2013
0 comments
NetIX force manual process
If you need to pick up the outbound files or make the inbound files (BOS Batches) quicker than the 30 minutes
read more
25
Jun2013
0 comments
The whole Job Queue stops when a lock time out occurs
Running NAS with Job Queue will start a timer to process Job Queue Entries every two seconds.
In the original code the Timer is disabled before checking the Job Queue Entries and then enabled again after the process.
read more
21
Jun2013
0 comments
Dynamics NAV Deadlocks and Blocking
There are a number of things to try when dealing with locking in NAV2009, NAV2009R2 and NAV5
read more
20
Feb2013
0 comments
Missing permissions in NAV2009R2
By default Ms Dynamics NAV 09 R2 is missing several permission records for tables that are new in R2. Even in the CRONUS database for NAV 09 R2 these permissions are not included.
read more
16
Jan2013
0 comments
XLCubed Right Click menu missing
When you right click a cell containing an XLCubed formula, the right-click menu for XLCubed should appear.
read more
27
Dec2012
0 comments
NAV Job Queue says “In Process” but job has crashed
If the job encounters an error the Job Queue Entries page will continue to say the job is "In Process". In fact its not and it will never run again until the job is reset.
read more
12
Nov2012
0 comments
Settings to access printer are not valid
We were trying to print from a dotnet assembly. This assembly was being used by a webserver/service running on Windows 2008R2.
Tried applying the registry hack described in http://support.microsoft.com/kb/184291/en-us But was still receiving the error
read more
24
Oct2012
0 comments
Generate xsd from NAV Tables
If you need to generate an xsd to represent a NAV table, use the following SQL command
read more
07
Mar2012
0 comments
Manually install xp_ndo
Sometimes you need to manually install the extended store procedures use by NAV Integrated Security.
read more
24
Nov2011
0 comments
Enable and Disable Service Broker
How to enable and disable service broker
read more
02
Aug2011
0 comments
NAV2009 – An I/O exception occurred during the operation (1)
NAV instantiates some temp folders and files based upon the combination of User Name and NAV Service Tier (NST). These cannot be shared.
read more
22
Jul2011
0 comments
Wrong Date and Time interpretation when using Dynamics NAV Web Services
The client Regional settings affect date and time interpretations within Dynamics NAV. The Region is easily set when using the Classic or Role Tailored Client (RTC). When using a Web Service its also easy, if you know how (like most things in life).
read more
20
Jul2011
0 comments
Cube Calculations of Current Date, Month, Quarter and Year
If you've struggled like me to define BI reports that contain default values for the Year, Month, Date then the following cube calculations might help. Just use these calculations as the selection when the report is defined. Then each time you open the report you'll be referencing the current Year and Month and not the ones you selected when the report was defined.
read more
31
May2011
0 comments
A call to SSPI failed in NAV 2009 R2
It is not unusual for your network security guys to force regular password changes. What is unusual is that once you changed your password you can no longer run NAV RTC. And receive the obscure message
read more
23
May2011
0 comments
Can’t send BizTalk documents from NAV2009 Role Tailored Client
As a regular user in NAV2009R2, attempting to Send a BizTalk document resulted in the error message.
read more
23
May2011
0 comments
Unique External Document No. on Sales Order
If you want to make sure the "External Document No." is unique for each Sell-to customer, use the following code on the OnValidate trigger of the field "External Document No." in the Sales Header table (36)
read more
10
May2011
0 comments
CRM 2011 – NAV 2009 R2 Synchronisation – tips and tricks
The following pointers are little things we picked up while synchronising CRM 2011 and NAV 2009 R2, that were not well documented elsewhere. It doesn't cover everything - just the points that were poorly documented by Microsoft, or not obvious to us.
read more
03
May2011
0 comments
Manually Create NAV Service Instances
In the default installation just one NAV Server Service and one NAV Business Web Service is created. I have found that in real life you need more NAV Server Services, and then you can spread users across them. In one case I created 7 different instances.
read more
08
Apr2011
0 comments
Don’t forget to upgrade xp_ndo.dll
When you upgrade your Dynamics NAV - SQL system to a later version make sure you also update the xp_ndo.dll
read more
31
Mar2011
0 comments
NAV2009R2 DotNet SMTP Add-in
NAV 2009 R2 introduced a new data type - DotNet. Sounded like a good idea but was there any practical use for it? Yes there is.
read more