Support Debugging Tool Build 19 released

It is time to release a new build of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0). Build 19 primarily improves support for Microsoft Dynamics GP 2013 R2 as well as including some fixes and enhancements to existing features. It also adds a couple of new features. Note: Build…

6

Support Debugging Tool Build 18 hotfix released

It had to happen. On my last day of work before going on leave, a bug was discovered in Build 18 of the Support Debugging Tool for Microsoft Dynamics GP. So I am releasing a Build 18 hotfix for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0), the hotfix build is dated as Last Modified: 23-May-2014. The issue…

0

Violation of Primary Key constraint. Cannot insert duplicate key in object error when using Item List

Today, I have another blog post based on a recent support case. The partner logged a case with us where the customer was receiving the error “Violation of Primary Key constraint. Cannot insert duplicate key in object” when they used the Item List in Microsoft Dynamics GP. The table referenced in the error was a temporary…

0

Capture Logins Script from KB 878449 generates Invalid object name error

This week I had an interesting case from a partner trying to use the Capture Logins script from Knowledge Base (KB) article 878449. How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server (KB 878449) When they…


More on SQL Server Connection issues with Microsoft Dynamics GP

I have been working on a recent support case that had a situation that makes me want to raise this topic again. In the past, I have posted a number of articles discussing reasons for connections to SQL Server to be lost. When Microsoft Dynamics GP loses its connection to SQL Server, the Dexterity Runtime automatically…

7

Support Debugging Tool Build 18 released

It has been a way too long between releases, but I am finally ready to release Build 18 of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0). This build includes fixes and enhancements to existing features as well as a few new features. I still have…

6

SQL Server xact abort setting breaks Microsoft Dynamics GP

Happy New Year. Wishing everyone a very successful 2014. I have been back from leave for two weeks, but have been really busy with support cases. One recent case highlighted a SQL Server setting that I have never used before and the negative consequences of changing the setting from its default value of “off”.   Background…

2

TCP Chimney Setting and SQL Server Error: TCP Provider: An existing connection was forcibly closed by the remote host

You might have heard me discuss the TCP Chimney settings before. If not, don’t worry as this post is here to make sure you know about the setting and make sure it is disabled for all your Microsoft Dynamics GP installs. My earlier post which mentions the TCP Chimney settings, discusses an issue with a…

2

Utility Script for CRM Connector Integrating with Dynamics GP Sample Company

This is an interesting script which I have decided to post in this article. When we configure CRM Connector with Dynamics GP for the sample company (Fabricam, Inc.,), there is a known issue in the way the sample company data is structured. As many of you would be aware of, the sample company data has…

1

Recursive Querying in SQL Server

In this post we will discuss about the use of recursive querying in SQL Server. Recently, I got a request from a Partner to develop a SSRS report for the Indented Bill of Materials in the Inventory module. I was going through the Dexterity Indented Bill of Materials report and found out that the report…


Identifying where SmartList Column Data comes from

Recently, I had a support case which asked the following: “When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available. What is the difference between them?” So, I wanted to work out a method to make it fairly easy for customers and…

2

Quick Tip: Unusual behaviour when working with SQL Server from Dexterity

Today, I came across an issue where a feature in Microsoft Dynamics GP would work when the workstation had its regional settings set to United States, but would fail to produce any data when the workstation had its regional setting set to Australia, New Zealand, United Kingdom, etc. We have seen related issues where code…

1

eConnect transaction not rolling back

I ran across an interesting case the other day with eConnect.  I had a similar type of case I wrote about previously, but this one is for a completely different reason. The ISV was moving his working customization from GP 10.0 to GP 2010/2013. The Problem Essentially the customization would use eConnect to create a…

3

Updated: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

From the Useful SQL Scripts Series. Back in December 2008, I posted an article providing the spSearchOnAllDB stored procedure, originally created by Oufimtsev Gleb. Based on feedback in the comments of that article, I have made two lots of updates to the script to fix some issues: It now handles tables and columns with long…

2

Handling Australian GST Requirements for Payables Transactions in eConnect

As part of the handling of Australian Good and Services Tax (GST), Microsoft Dynamics GP needs to be able to track if a Tax Invoice has been received for payables transactions. This is important as a company must have a Tax Invoice for a purchase before they are allowed to claim the Input Tax Credit…

2

Developing with the Microsoft Dynamics GP 2013 Named System Database

Microsoft Dynamics GP 2013 introduced another long sought after feature…. The Named System Database. Instead of the System database being hardcoded to DYNAMICS, a different name can be selected when installing GP. So what does that mean? Well, it means that more than one Dynamics GP system can reside on a single instance of SQL…

0

Support Debugging Tool Build 17 hotfix 2 released

Following on from the release of the Support Debugging Tool Build 17 hotfix, I am releasing a hotfix 2 build. It turns out that some of the changes in the way the Support Debugging Tool adds buttons to the Standard Toolbar were still not perfect. We had a few reports that when the SDT dictionary was installed, newly…

6

Quick Tip: VBA ADO Connection Run-time error ‘3709’

It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while. When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to…

2

Support Debugging Tool Build 17 hotfix released

Just before I went on leave over Christmas and New Year, I announced the release of the Support Debugging Tool Build 17. Well, as much as I try to ensure that there are not any bugs in the code, I managed to introduce one. So this hotfix build fixes the bug which can cause the two Support Debugging…

2