Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The Support Debugging Tool for Microsoft Dynamics GP has the facility to create non-logging triggers. This are Automatic Debugger Mode triggers that do not automatically start and stop the Dexterity and SQL logging.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was asked recently about the Note Index field and how it is used and in particular about the Note Index field in SY01500 table in the DYNAMICS system database. This post will explain how the field is used as well as explain how it is possible to create the conditions that will generate cross linked notes. Understanding how the conditions can be created will allow you to avoid that situation from occurring.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a followup to last week’s post about Understanding how Microsoft Dynamics GP works with Microsoft SQL Server, I am adding a few more topics about why Microsoft Dynamics GP works the way it does with Microsoft SQL Server. So here goes ….
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The question of how to control the size of the body section of a document such as Sales Order Processing (SOP) Orders and Invoices or Purchase Order Processing (POP) Purchase Orders has come up a number of times before. It was asked again on a Community Forum post a while back. So I thought I would post the answer here.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Many people who have not been working with Microsoft Dynamics GP since the early non-SQL versions of Great Plains Dynamics sometimes wonder about the way that the application works with Microsoft SQL Server.
This is a reposting of an article Dave Duesk originally wrote on my Developing for Dynamics GP blog.
This is really an extension of the blog article that David Musgrave wrote VBA – Welcome to Dynamics Example, but instead of using VBA to play the sound file, we are using Dexterity. The same method is called in the winmm.dll, but this is just the Dexterity way to do it. I didn’t include trigger information on this because you could really put this anywhere.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
I was assisting on a support case recently where we needed to identify transactions in Payables Management history which had missing Apply records. We wanted to add up the total of the Apply records and make sure that they matched the value of the original document amount.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
A question was posted to the newsgroups recently that reminded me that I had also run into the same situation previously.
I was trying to drag a shortcut into a folder that I had also created and it wouldn’t drag & drop for me in my Dynamics GP 10.0. I went back to 9.0 and had no issue doing this but it just wouldn’t work in 10.0.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Many of inquiry windows in Microsoft Dynamics GP have been optimized to leverage SQL Server to increase performance. This is especially common with transaction inquiry windows which can combine data from more than one table (ie. Work, Open and History).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have been seeing a number of reports on Newsgroups and Support cases of Add-In Initialization Errors.
In particular, after installing updates or service packs after v10.00 SP2, receiving the following message:
eOne.Dynamics.GP.ExcelBuilder.Engine.dll: Exception has been thrown by the target of an invocation. InnerException: The type initializer for ‘eOne.Dynamics.GP.ExcelBuilder.GPAddIn’ threw an exception.