Click here to
Subscribe to
our Newsletter
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In my previous post, I mentioned that I was assisting a developer with an issue. It turned out that the issue he was having was not the cause of an error, but the result of a previous error that the users had not told him about. Once the original error was fixed, the entire problem was solved.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
Because Microsoft Dynamics GP is designed to have separate tables for WORK, OPEN and HISTORY transactions, there are times where it is possible for a transaction record to exist in more than one table. This is usually the result of an error or interruption.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
When a system has a batch that is stuck as marked to post or a transaction that cannot be accessed as it says it is already being edited, the usual instructions are to exit all users from the system and then delete the contents of the activity tracking, and Dexterity session and lock tables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
After the success of the Microsoft Dynamics GP Application Level Security Series, I have decided to release a another series which contains some really useful SQL scripts I have collected over time.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Over the years, the question of how to interact with the Microsoft Dynamics GP OLE Notes from outside the application has been raised many times.
I have responded to newsgroup posts with information that would hopefully lead the developers in the right direction.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series. This is the final article in this series at this time.
Microsoft Dynamics GP version 10.0 introduces a new pessimistic task and role based security model. This new model has a completely different table structure to the previous optimistic user and class based security model. Which means that when upgrading the security settings cannot just be transferred across.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
When attempting to open a window you might receive the following error message:
Cannot access this form because the dictionary containing it is not loaded.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
When access is denied by the application security system to a window, you will receive the following error message:
You don’t have security privileges to open this window. Contact your system administrator for assistance.
Sometimes, the window you expected to open does not, which probably means that the security on that particular window needs to be changed. Other times the window still opens even after the security error, which probably means that a hidden system window failed to open.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
When logging into Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains, you might receive the following error:
You don’t have security privileges to open this window.
Once you click OK, the login appears to complete.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
In the previous post, How to identify the Security Tasks and Security Roles associated with a specific window or report we used the syCurrentResources (SY09400) table to help us identify resources.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
Microsoft Dynamics GP version 10.0 introduces a new pessimistic task and role based security model. This model is defined in the following way:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
For the next couple of weeks, I have decided to focus on Microsoft Dynamics GP application level security and methods for resolving security related issues.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Microsoft Dynamics GP Application Level Security Series.
With the change from the optimistic user and class based security model in Microsoft Dynamics GP v9.0 (and v8.0) to the pessimistic role and task base security model in Microsoft Dynamics GP v10.0, a question that is often asked is how can security settings be transferred between a test and live system.