Why are objects missing from the Security Resource Descriptions (SY09400) table?


David Meego - Click for blog homepageIf you want to do any reporting on Microsoft Dynamics GP application level security from the SQL Server level, you need to use the Security Resource Descriptions (SY09400) table to map the Resources Type, Dictionary ID and Security/Resource ID to actual named resources that make sense to humans.

I have often seen questions raised about why some systems have all the resources listed in this table and other systems only have a subset of the resources or the table is empty.

Continue reading

PSA: Everything you want to know about the WannaCry ransomware


David Meego - Click for blog homepageCybersecurity is back in the news this week.

The WannaCry ransomware or crypto-virus has infected many computers around the world and highlighted that the threat of scams, viruses, trojans, worms and ransomware is very real and that you need to be forever vigilant to keep your systems and your data safe.

In this article I want to remind everyone of some easy and simple ways to keep yourself safe.

Continue reading

#GPPT What’s New: Security Activity Tracking and Security Log


David Meego - Click for blog homepageAs GP Power Tools approaches release, it is time to continue the What’s New series and explain another of the new features added to the product.

You can now enable Security Activity Tracking to collect statistical data on the usage of the various resources and security objects within the system.

Continue reading

Support Debugging Tool Build 19 released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

It is time to release a new build of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0).

Continue reading

Support Debugging Tool Build 18 released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

It has been a way too long between releases, but I am finally ready to release Build 18 of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0).

Continue reading

Support Debugging Tool Build 17 hotfix 2 released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

Following on from the release of the Support Debugging Tool Build 17 hotfix, I am releasing a hotfix 2 build.

It turns out that some of the changes in the way the Support Debugging Tool adds buttons to the Standard Toolbar were still not perfect. We had a few reports that when the SDT dictionary was installed, newly created users would be missing their menus. The solution was to remove the SDT from the system and recreate the user, or to use SQL to drop the contents of the menu and toolbar tables, which will force them to be recreated.

Continue reading

Support Debugging Tool Build 17 hotfix released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

Just before I went on leave over Christmas and New Year, I announced the release of the Support Debugging Tool Build 17.

Continue reading

Support Debugging Tool Build 17 released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

With the release of Microsoft Dynamics GP 2013, I am pleased to announce the release of Build 17 of the Support Debugging Tool for Microsoft Dynamics GP for versions 10.0, GP 2010 (v11.0) and GP 2013 (v12.0).

Continue reading

Support Debugging Tool Build 16 Hotfix released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

It has been a while since Support Debugging Tool Build 16 was released back in January 2012.

While I have not been able to invest much time in adding new features to the Support Debugging Tool (SDT), I have been able to fix a few issues which have been reported by the community.

Continue reading

SQL Script for Account Level Security


Sivakumar Venkataraman - Click for blog homepageThis is a reposting of an article Sivakumar Venkataraman originally wrote on my Developing for Dynamics GP blog.

I recently joined Microsoft as a Partner Consultant for the Global Partner Services team. I have been associated for more than 8 years in the design, development and implementation of Microsoft Dynamics GP in India, Middle East and US. This is my first post in this blog and it feels great to be posting alongside community experts like David Musgrave, Patrick Roth and others.

Microsoft Dynamics GP offers the Account Level Security option to restrict the access of GL accounts to specific users. There is no specific report (or) Smartlist which is available for viewing the details of the accounts which each user has access to.

Continue reading

Support Debugging Tool Build 16 released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

A week into the New Year and no posts…. what’s happening? Read on to understand where all my spare time has been going….

After over four months of development, testing and documentation, I am thrilled to announce that build 16 of the Support Debugging Tool is now available for download from PartnerSource. This build has over 50 changes and focuses on functionality for logging and debugging issues with Microsoft Dynamics GP, while still having some improvements for the database or application Administrator.

Continue reading

Support Debugging Tool Build 15 update released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

As mentioned in the post, Support Debugging Tool Build 15 released, the Support Debugging Tool for Microsoft Dynamics GP build 15 was released at the end of June with a build labelled as Last Modified: 28-Jun-2011.

Continue reading

Solving Security Privileges Errors Using the Support Debugging Tool


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

If you attended the Microsoft Dynamics GP Technical Conference 2009 in Fargo, North Dakota or Microsoft Dynamics Convergence Atlanta 2010, in Atlanta, Georgia you might have seen a demonstration by Mariano and myself of the Support Debugging Tool for Microsoft Dynamics GP.

Continue reading

Support Debugging Tool Build 14 released


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

It has been a while since we had a new build of the Support Debugging Tool for Microsoft Dynamics GP. So we have decided to release Build 14.  This is primarily a maintenance release with bug fixes, minor enhancements and a couple of new features.  This build can be installed over the top of any existing installed build without needing to remove the old build first.

Continue reading

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


David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Added to the Microsoft Dynamics GP Application Level Security Series.

I am still surprised how many times questions appear on the newsgroups and forums asking about which Security Tasks and Security Roles are needed to access a particular window. It has been a while since I posted anything about the Support Debugging Tool, and this seems like a perfect opportunity to show how simple it is to use the Support Debugging Tool to find this information.

Continue reading