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…


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


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…


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…

9

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…

34

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

Are you using the Support Debugging Tool?

You might say that I am biased.  As the developer of the Support Debugging Tool for Microsoft Dynamics GP, I believe that every Microsoft Dynamics GP site (v8.0, v9.0 & v10.0) should have the tool installed. Even if you don’t need it straight away, it is always there when you do.  For example: You might…

5

Unhandled Script Exception: Attempt to use old()/diff() from a field that does not have focus.

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. This situation can arise when…

1

Running SQL commands against all GP Company Databases

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: Running a SQL Script against all GP Company Databases I have…

8

Statement of Direction for Microsoft Dynamics GP

You might have seen some other posts around that the updated Statement of Direction for Microsoft Dynamics GP documentation has been posted on PartnerSource and CustomerSource.  Some points of interest for the developer community are listed below: The Microsoft Dynamics GP 10.0 Feature Pack shipped in June 2008 contains the following: Feature Description XML Source Adapter…

7

Developer Documentation for Microsoft Dynamics GP

I found some great reference pages on PartnerSource and CustomerSource today. They are the Developer Documentation pages for Microsoft Dynamics GP 9.0 and 10.0.  They contain links to information about every customisation tool available as well as links to white papers comparing the tools and the architecture of Microsoft Dynamics GP. The pages below will be a…

3