Jigsaw Blog

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

30

Mar
2011
0 comments

Create a CSV file via an XMLport with no field delimiter

You are trying to create a CSV file in NAV2009 using an XMLPort, but you want no field delimiter. read more

03

Feb
2011
0 comments

Registering Compiled C sharp DLL

In an earlier post I gave the command for registering a compiled C# dll. The command I gave was incorrect read more

31

Jan
2011
0 comments

Regsvr32 on 64bit server – no error or message

I had a problem registering a 32bit dll on a 64bit server.

The dll was custom written and replied upon some registry settings.
For example: HKLM\Software\Jigsaw

Turns out that if it's a 32bit dll the registry settings need to be under
HKLM\Software\Wow6432Node\Jigsaw

Moved the registry settings here and regsvr32 then worked.

read more

05

Dec
2010
0 comments

NAV RTC Development Tips

Properties of controls can now be set dynamically. (Well, more dynamically then before). For example, the cells in a column (in a grid) can have a different editable value for each row. I'll describe a quick example of how to do this. read more

02

Dec
2010
0 comments

NAV RTC – Add-ins/dll/com

Creating a control add-in and compilde #c dll's read more

24

Nov
2010
0 comments

SQL Maintenance plan won't run, modify or delete

We recently replaced on SQL server with another. Ths involved server renaming and some of the Maintenance Jobs stopped running. We were unable to delete them through SQL management Studio. They can be manually "adjusted" and then can be deleted. The issue was that the Server name they referred to no longer existed. read more

21

Nov
2010
0 comments

Miscellaneous NAV RTC Development Tips

Creating a menusuite and properties of links read more

18

Nov
2010
0 comments

NAV RTC Development training tools

Some handy tools/sources for learning about development with the RTC read more

15

Nov
2010
0 comments

Microsoft Dynamics NAV Application Objects

Ever wondered what Application objects are include in the two flavours of Business Ready Licensing? read more