Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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. ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Developers: Microsoft Dynamics GP 2013 Service Pack 2 moves the Vendor and Customer Combiner & Modifier into core code

    Now before you ask.... the answer is No, I have not spent all week playing XBox One (as mentioned on the last post ). Yes, we did get one and yes the kids have been using it, but the reason I have not posted on the blog is just that I have been very busy with support cases. Talking of support cases...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Support Debugging Tool Build 17 released

    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 build mainly includes fixes and enhancements to existing features as well as changes...
  • Blog Post: Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix

    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: ...
  • Blog Post: Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box)

    A recent post on DynDeveloper.com caught my eye as I have faced a similar problem before and had to work quite hard to get the correct answer. The post was titled: Determine Company_Options from DYNAMICS.dbo.SY01500 and asked how to figure out how to interpret the binary(4) field. I realised that...
  • Blog Post: Support Debugging Tool Build 16 Hotfix released

    It has been a while since Support Debugging Tool Build 16 was released back in January 2012. While I have not been able to invest much time in adding new features to the Support Debugging Tool (SDT), I have been able to fix a few issues which have been reported by the community. So, I felt that...
  • Blog Post: Product Suggestion: eConnect POP Tax Engine

    Over the last few weeks, Mark Polino, MVP over at DynamicAccounting.net has been posting articles asking you to vote for Product Suggestions using the Microsoft Connect site. Well now it is my turn.... History To start with we need a little bit of history: When the Purchase Order Processing...
  • Blog Post: SQL Script for Account Level Security

    I recently joined Microsoft as a Partner Consultant for the Global Partner Services team. I have been associated for more than 8 years in the design, development and implementation of Microsoft Dynamics GP in India, Middle East and US. This is my first post in this blog and it feels great to be posting...
Page 1 of 4 (97 items) 1234