This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This week I had an interesting case from a partner trying to use the Capture Logins script from Knowledge Base (KB) article 878449.
Continue reading
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have been working on a recent support case that had a situation that makes me want to raise this topic again.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)
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 is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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”.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 large SmartList query not returning all the expected data. This post aims to discuss the bigger picture without referencing a specific module or function.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I had a case today where a developer was having issues when using the Customer Combiner. This functionality was part of PSTL (Professional Services Tools Library) and as of Microsoft Dynamics GP 2013 Service Pack 2 is now part of core code.
This is a reposting of an article Sivakumar Venkataraman originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article Viswanathan Neelakantan originally wrote on my Developing for Dynamics GP blog.
In this post we will discuss about the use of recursive querying in SQL Server.
Continue reading
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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?”
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
Back in December 2008, I posted an article providing the spSearchOnAllDB stored procedure, originally created by Oufimtsev Gleb.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 for that purchase. The Input Tax Credits are balanced against the tax they have collected from sales and only the balance is due to the Australian Taxation Office (ATO).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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 Server. Before when a second Dynamics GP system was needed, you would have to install a new instance of SQL Server. Now you can have multiple System Databases on a single server without needing additional instances of SQL Server.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)
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 created users would be missing their menus. The solution was to remove the SDT from the system and recreate the user, or to use SQL to drop the contents of the menu and toolbar tables, which will force them to be recreated.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)
Just before I went on leave over Christmas and New Year, I announced the release of the Support Debugging Tool Build 17.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)
With the release of Microsoft Dynamics GP 2013, I am pleased to announce the release of Build 17 of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Last month, Kelly Youells posted on the Dynamics GP Support and Services Blog about an issue which can cause Microsoft Dynamics GP 2010 Utilities to hang when updating to Service Pack 3 or later. The details of the issue are posted on the blog and also linked to the Dynamics GP 2010 Hot Topic: