spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

From the Useful SQL Scripts Series. This stored procedure, originally written by Oufimtsev Gleb from Moscow, allows you to search all columns in all tables in a database for the occurrence of a particular string or value.  Wild card characters such as those supported by the LIKE keyword can be used. For example: _ to wild card a…

18

Useful SQL Scripts Series

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. The posts in the series (so far) include: 01-Dec-2008: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database   03-Dec-2008: Releasing Stuck Batches and Transactions…

14

All about the Dexterity OLE Container

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. Well now, all I need to do point them to Mariano Gomez’s…

1

How to retrieve Quantity On Hand amount using Web Services for Dynamics GP 10.0

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. …

1

Checking eConnect Version Number Programmatically

To date the blog has not had a large amount of content relating to eConnect. So I am going to cheat and point you to a great article by Steve Endow on the Dynamics GP Land blog. Avoid versioning issues with eConnect by knowing how to check the version installed at a site.  See the…

2

The "Do you want to save?" dialog appears when no changes are made

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. I have seen this issue many times caused by Visual Basic for Applications (VBA) code added to the…

0

Information about using v10.0 Security Conversion Tool

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…

3

US Microsoft Dynamics GP Field Team Blog and DynamicAccounting.net

While I am looking around the Blogsphere at all the great content appearing on the various Microsoft Dynamics GP related blogs, I would like to highlight a couple of blogs which have a wealth of content or links to content relating to all things Microsoft Dynamics GP. The Developing for Dynamics GP blog has a more…

1

What does SQL Maintenance really do?

Mariano Gomez has written a great article explaining what the SQL Maintenance (Microsoft Dynamics GP >> Maintenance >> SQL) window in Microsoft Dynamics GP actually does. This was in response to a newsgroup posting asking for more information about this window.  Please have a look at this post What does SQL Maintenance really do?. David

0

How to resolve Dictionary not Loaded errors

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. There are two main reasons for this error: Situation: You are running in Dexterity debug Test Mode (which is a single dictionary…

2

How to resolve Security Privileges errors

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…

5

Web Access to the Public Newsgroups has changed

UPDATE: The old links are working again, so you have the choice of links you can use. It seems that a technical issue took the links offline for a while. If you still get an error message, try refreshing the browser. As of today, it seems that the old links for web access to the Business Solutions (Microsoft…

0

How to resolve Security errors on Login

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. During login, access is required to a number of…

11

How to identify the Security Tasks and Security Roles using the Support Debugging Tool

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. We can also use the Resource Information feature of the Support Debugging Tool for Microsoft…

4

How to identify the Security Tasks and Security Roles associated with a specific window or report

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…

26

Integration Manager product suggestions, please vote!

In order to get any new features added into our products, we need to have votes cast.  This gives the Program Managers an idea if there really is need for certain features to be added. I have added the following items for Integration Manager.  Please vote on the ones you find important. GP- Add the…

10

Microsoft Dynamics GP Application Level Security Series

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. Where possible I will also show how using the Support Debugging Tool for Microsoft Dynamics GP can make the process simpler and quicker. The posts in the series include: 10-Nov-2008: How…

18

Can I customise a 3rd party form with Dexterity?

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. Usually, the developer has created a combined dictionary as per the instructions in the Integrating with Third Party…

21

How to transfer Security Tasks and Roles between Systems

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…

18