spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
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.
All about the Dexterity OLE Container
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.
How to retrieve Quantity On Hand amount using Web Services for Dynamics GP 10.0
This is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.
This post is due to requests I have come across in the past and very recently in a support incident. The question raised was how to retrieve quantity amounts like Quantity On Hand for inventory items? This Visual Studio 2005 (C#) sample shows how to retrieve the Quantity On Hand value for an Inventory Item. The SalesItem class provides a Quantities property which is a collection of SalesItemWarehouse objects. The SalesItemWarehouse object contains the different quantity amounts for each Item and Site combination. These values are stored in the IV00102 table.
The “Do you want to save?” dialog appears when no changes are made
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Recently I responded to a newsgroup post where the Sales Transaction Entry (SOP_Entry) window was popping up the “Do you want to save?” dialog when moving between records even though no changes had been made by the user.
Information about using v10.0 Security Conversion Tool
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.
How to resolve Dictionary not Loaded errors
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.
How to resolve Security Privileges errors
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.
How to resolve Security errors on Login
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.
How to identify the Security Tasks and Security Roles using the Support Debugging Tool
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.
How to identify the Security Tasks and Security Roles associated with a specific window or report
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:
- Access to all windows, tables, reports and miscellaneous permissions are classed as Security Operations.
- A set of Security Operations required to perform a specific task are assigned to a Security Task.
- Multiple Security Tasks required to perform a specific role are assigned to a Security Role.
- Each User and Company combination can then have multiple Security Roles assigned to it.
Microsoft Dynamics GP Application Level Security Series
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.
Can I customise a 3rd party form with Dexterity?
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Over the last few weeks I have been asked a number of times about methods of customising a 3rd party form. This purpose of this post is to clarify what can and cannot be achieved with Dexterity.
How to transfer Security Tasks and Roles between Systems
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.
Unhandled Script Exception: Attempt to use old()/diff() from a field that does not have focus
This is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.
A common situation that can happen when coding with Dexterity is an error that you attempted to use the old()/diff() function from a field that doesn’t have focus. The exact error message is as follows:
Unhandled Script Exception: Attempt to use old()/diff() from a field that does not have focus.
Running SQL commands against all GP Company Databases
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Last week, I posted the article below explaining how you can use the osql.exe command to run a script against all Microsoft Dynamics GP company databases. The method described in this post is best if you have a *.sql script file to execute against each company database:
Using ADO with VBA with Report Writer
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects to access data from SQL Server while using the Report Writer.
Using VBA with Report Writer
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well.
How to use Word Mail Merge and Macros to Import Data
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This post explains how to use Microsoft Office Word’s Mail Merge functionality to Import Data into Microsoft Dynamics GP. This method can be useful when working with master records or transactions not supported by any of the existing tools such as Integration Manager, eConnect or Web Services.
[Edit] See note about John Arnold’s Replicator Tool at the bottom of this article.
Running a SQL Script against all GP Company Databases
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
While administering a Microsoft Dynamics GP system, there are times when a fix or change needs to be applied to each company in the system at the SQL Server level. On a system with a large number of companies this can be a very time consuming task.