Jigsaw Blog

22

Sep
2013
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

Jun
2013
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

Jun
2013
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

Feb
2013
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

Jan
2013
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

Dec
2012
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

Nov
2012
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

Oct
2012
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

Mar
2012
0 comments

Manually install xp_ndo

Sometimes you need to manually install the extended store procedures use by NAV Integrated Security. read more

24

Nov
2011
0 comments

Enable and Disable Service Broker

How to enable and disable service broker read more

02

Aug
2011
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

Jul
2011
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

Jul
2011
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

May
2011
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

May
2011
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

May
2011
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

May
2011
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

May
2011
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

Apr
2011
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

Mar
2011
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