How to Fix a Setup File is from a later version Error from the Support Debugging Tool when doing a Test Upgrade

This post revisits the issue previously discussed in the blog post:  How to Fix a Setup File is from a later version Error from the Support Debugging Tool. The issue is that you receive the error message below from the Support Debugging Tool just after logging into Microsoft Dynamics GP: Setup File is from a…

2

After restarting SQL Server, only ‘sa’ user can log into Microsoft Dynamics GP

Last week, I resolved a rather bizarre case for a customer. The Situation Each time the customer’s SQL Server was restarted for whatever reason, only the ‘sa’ user was able to log into Microsoft Dynamics GP.  Once the ‘sa’ user had logged into Microsoft Dynamics GP at least once, then all the other “normal” users could…

4

VBA: DUOS data stored in the wrong database after switching companies

A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation. Everything worked fine until the users switched companies. After switching company the VBA customisation would still be connected to the DUOS table in the previous company’s…

1

Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions – RW_CoAddrIDInfo broken

Following on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions, I have to admit that I made a mistake. The Problem The update to the RW_CoAddrIDInfo() report writer function has broken the code. It works when no Address ID is supplied to return the information from the default Address information…

6

Currency ID missing in the Currency Translation Default Exchange Table ID’s section of the Multicurrency Setup window

Hi, my name is Tracy Steere and I work with David Musgrave on the Microsoft Dynamics GP Asia Pacific support team. A bit about myself, I started working with Dynamics GP as an assistant Accountant in 1997 by October 1997 I had become a Dynamics GP Consultant for a company called TWO inc. in Durban, South…

1

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

Installing Microsoft Dynamics GP clients using System Center Configuration Manager (SCCM)

This article has its beginnings in a support case for Microsoft Dynamics GP 2013 Word Templates. The problem reported by the customer was that whenever they tried to import a word template back into Dynamics, they would receive the following error: The template you selected cannot be added. The word template document itself did not even…

0

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

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

Microsoft Dynamics GP 2013 Service Pack 2 fixes Named Printers and Page Orientation settings not being honoured

As mentioned in my post, Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog, there was an issue where the feature to allow the printer destination to be changed after the report had been printed to screen did not honour printer setting changes made by Named Printers or the…

15

Date Function Errors from SmartList Account Transactions fixed in Microsoft Dynamics GP 2013 Service Pack 2

A little while ago I spent some time in a long screen sharing session to identify the cause of some really unusual errors being generated from SmartList Account Transactions favourite in Microsoft Dynamics GP 2013 Service Pack 1. This issue has now been fixed for Microsoft Dynamics GP 2013 Service Pack 2. The errors did not…

1

Adobe X performance issues with Citrix Environment

I had a recent case where a customer was having performance problems with printing to PDF files. If you print a report to the screen and then Send to Mail as PDF it was fast, but if you try to directly email the report as a PDF it would be really slow (minutes rather than…

1

Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog

Microsoft Dynamics GP 2013 added a long awaited feature, the ability to change the printer selection for a report after it has printed to the screen output. However, this change has introduced some side effects. Microsoft is aware of the side effects and they should be resolved in an upcoming release. To explain the side…


Why does SmartList not return all of the expected data for large queries?

Here is another support issue that you might come across. I just closed a case where a SmartList was returning less than the expected number of records. If a SQL Statement was executed via the SQL Server Management Studio, it returned more records than were shown in the SmartList. The system was comprised of a…

0