Loading...

Follow Winthrop Development Consultants | Microsoft D.. on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Winthrop Development Consultants is pleased to announce Build 27 of GP Power Tools (GPPT) for Microsoft Dynamics GP was released on 24-May-2019.

This build incorporates new features and enhancements to all modules of GP Power Tools, as well as general code improvements and fixes to existing functionality. It includes a number of features that were on the wish list, but did not get into the previous build.

To give you an idea of how much has been added, the user guide manual has grown from 385 pages in build 26 to 424 pages in build 27!


IMPORTANT NOTICE: To ensure continued registration after 01-Jul-2018, please update all workstations to Build 24 or later before the current subscription expires. Install over the top of the existing build, no need to uninstall first. You can also copy the updated files from one install to other installs.

Build 27 of GP Power Tools is available for the following Microsoft Dynamics GP versions:

  • Microsoft Dynamics GP 2010 (v11.0)
  • Microsoft Dynamics GP 2013 and GP 2013 R2 (v12.0)
  • Microsoft Dynamics GP 2015 and GP 2015 R2 (v14.0)
  • Microsoft Dynamics GP 2016 and GP 2016 R2 (v16.0)
  • Microsoft Dynamics GP 2018 and GP 2018 R2 (v18.0)
System Features Module Enhancements

Changes to the System Features Module of GP Power Tools include the following:

When capturing logs on startup you can now specify which of the three logging modes to enable.

Added User Name information to the “This transaction is being edited by another user.” for SOP and POP windows.

Added a Calculator which can be used inside Dynamics GP (especially on the web client) and can copy and paste values.

Administrator Tools Module Enhancements

Changes to the Administrator Tools Module of GP Power Tools include the following:

Added Launch File Configuration to allow automatic updating of the Launch File (usually Dynamics.set), without having to visit individual workstations, based on rules defined.

Added Dynamic Product Selection to allow for realtime selection between multiple versions of a window (Original, Modified, Alternate or Modified Alternate) when the window is opened. Normally you can only have access to a single version unless you change user or security records. Now you can just select which version you want from a dialog before it opens.

Added a Security Log Details window to the Security Log, so you can review all user and company access for the selected security object.

Resource Information window now displays multiple results when searching, so you can just click directly on the result you are interested in rather than repeatedly clicking the Search Again button.

Added an option to hide Inactive Users from the Security Information window.

Enhancements to Automatic Logout warning dialog to bring the window to the foreground.

Fixes to Company Login Filter to fix issue with pathnames with folders not being identified correctly.

Developer Tools Module Enhancements

Changes to the Developer Tools Module of GP Power Tools include the following:

Added SQL Gotos, so that additional tasks can be performed based on the selected records from results returned by SQL Execute scripts.

Triggers can now be registered against Modifier Added Fields. Combined with the ability to run scripts against Modifier Added Fields, this allows for business logic to be added to these fields without using Visual Basic for Application (VBA) or Visual Studio Tools. You can now replace VBA modifications with triggers and scripts, and it works great on the Web Client.

Triggers can now be registered against Modal Dialogs. Something that Dexterity itself cannot do, but GP Power Tools can. You can now alter or automate Modal Dialogs simply and quickly.

Triggers running before the Window Pre event can now hide the window, so you can automate the window without the users seeing it being driven.

Added support for Visual Studio Integration Toolkit (VSIT) so that you can use a trigger to add custom application level menus into GP.

Added support for custom URL drill backs so you can add URLs to external documents and have them drill back into Microsoft Dynamics GP and perform any function you desire. For example:

Addition of Release Notes to Developer Tools allows a version history to be recorded with the objects.

Numerous enhancements to the Project Setup window and working with projects in general.

Enhancements to Runtime Execute Custom Web Services and SQL Execute Query Result sets to support data larger than 255 characters.

Added support for using clipboard with Names Button on windows with script editing.

Added Lookup Window Positioning to ensure lookup windows open next to calling window.

Database Tools Module Enhancements

Changes to the Database Tools Module of GP Power Tools include the following:

Added a SQL Login Maintenance window which can be used to reset passwords and check or change password policy settings. New passwords can be entered or generated and emailed to users.

Other Enhancements

For a detailed change log, look at the GPPTools.txt file which is also installed with GP Power Tools into the Microsoft Dynamics GP application folder.

More Information

For more information see the following pages and articles:

The following articles have been updated to include the changes for Build 27:

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

As mentioned yesterday, I am heading to Johannesburg, South Africa for the User Group World Tour 2019 conference and will be offering Dexterity training afterwards.

However, I will also be offering a day of free GP Power Tools training (available to registered conference attendees) during the pre conference Workshop day on Tuesday 11th June 2019.

GP Power Tools is the ultimate add on for Microsoft Dynamics GP to improve the experience of Administrators, Consultants, Developers and Users. It has features that will benefit all users of GP regardless of the level of the technical experience.

To get an understanding of what GP Power Tools can do for you and how it can solve your pain points, check out the Benefits Presentation.

To get a more in depth look at GP Power Tools, including what’s new in build 26 and build 27, whether you are an existing user or not, come to the workshop day.

In the morning we will be covering the Installation, System Features and the Administrator Tools module. Then in the afternoon we will be covering the Database Tools and Developer Tools modules.

Leveraging GP Power Tools

GP Power Tools from Winthrop Development Consultants is a powerful suite of tools to help you support, administer and customize your Microsoft Dynamics GP system.

This workshop will introduce all the features of the latest builds of GP Power Tools and explain the benefits of each. We will cover the features of all four of the modules so that you have a full understanding of what the tool is capable of and how it can solve your pain points. The modules of GP Power Tools are:

  • System Features module
  • Administrator Tools module
  • Developer Tools module
  • Database Tools module

We will cover topics such as; identifying resources (windows, tables, fields, etc.), resolving application security issues, setting up deny based security, capturing screenshots and logs, troubleshooting the cause of an issue, controlling Dex.ini settings and even avoiding issues by color coding companies.

We will also cover the scripting and programming capabilities of the tools, showing how it can be used to customize the system and fix issues. Also, we will explore the Database Validation feature to understand how this will help ensure your system is in “tip top” shape and so avoid upgrade issues.

David Musgrave, the developer, will guide you through the installation process and use of the tools. You will learn what the recommended configuration is and how to set up the tools to get the most out of it.

Learning Objectives:

  • Installing GP Power Tools.
  • Setting up GP Power Tools to get the most out of it.
  • Identifying dictionary resources and security objects.
  • Capturing Screenshots and logs from the system.
  • Reviewing and changing security access.
  • Using Deny Based Security to control security and hide menus.
  • Troubleshooting issues with customizations.
  • Centrally controlling Dex.ini settings.
  • Usability features such as Company Color Themes and Window Position Memory.
  • How to use Database Validation to fix potential upgrade problems before they occur.
  • How to export and import data as XML files.
  • How to use Advanced Trigger Mode to track down issues.
  • How to use triggers to create customizations.
  • How to write scripts in a variety of scripting languages.
  • How to create user interfaces to your scripts with parameter lists.
  • How to create custom report writer functions to retrieve data from any source.

The above agenda is a guideline and might be re-organised to fit additional topics if time allows.

Please make sure you come in early to take advantage of the free workshop day.

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I will be heading to Johannesburg, South Africa soon for the User Group World Tour 2019 conference organised by Dynamic Communities.

After the conference I have been asked by a customer to run Dexterity Training for some of their staff and so this has been planned to run in the week following the conference. Additional, but limited room, is available at this training and so I am opening this up to any partner or customer who can attend.

Dexterity is the development environment that Microsoft Dynamics GP is built on and the best tool to use for any customisation to the user interface of the product. Knowledge of Dexterity is vital for anyone customising Dynamics GP even when using other languages such as C#, VB.Net and even VBA (Visual Basic for Application).

This training is being offered at a special reduced price and I cannot guarantee that there will be another opportunity to receive this training in the region or at this price.

I will be presenting Dexterity Fundamentals training from Monday 17th June 2019 to Friday 21st June 2019 at the venue Thirdspace at Fourways which is close to the conference hotel, SunSquare Montecasino.

Below are details of the Dexterity Fundamentals training class:

Dexterity I (Dexterity Product Fundamentals) Course Synopsis:

Dexterity I will teach you about the development environment used to build the Microsoft Dynamics GP family of products. This course will provide you with the foundation you need to build integrated, database-independent applications. In addition, you will learn how to provide powerful application functionality for Dynamics.

By actively participating in this class, you will learn:

  • Basic programming techniques used by Microsoft Dynamics GP to develop their core modules
  • How to modify existing Dynamics GP forms and reports in order to make customizations for customers
  • How to develop add-on applications that will interact with the Dynamics GP products to meet specific requests by customers
  • How to package and ship your dictionary allowing Microsoft Dynamics GP to make updates to Dynamics GP without affecting the developer’s dictionary
  • How to register your product with Microsoft Dynamics GP using a unique Product ID to ensure no duplication of add-on applications with the same name
  • How to develop add-on applications that will “look and feel” like Dynamics GP and provide seamless interface between the applications to ensure a professional finished product
  • How to use object triggers, which are scripts in your applications that are invoked by events in Dynamics GP, allowing several developers to deliver enhancements to the same Dynamics GP form
Who should attend?

Customers or Partners who will be customizing or building add-on or standalone applications to integrate with the Dynamics GP products. Also great for Developers working with Visual Studio Tools who want to understand the internal workings of Dynamics GP.

Special Instructions

Prior to attending the course, it is highly recommended that students prepare for the course by going through the Dexterity Quick Start reference manual and working through the lessons in this manual. The Quick Start manual is installed with Dexterity and can be found under the Help-Online Manuals option from within Dexterity. Dexterity is located in the tools folder in the Dynamics GP DVD image.

Agenda

Monday to Friday (5 days) 8:00-5:00 each day

Course Topics

Day 1
Introductions and Overview
Dexterity Resources and Components
Create Basic Data Entry Project

Day 2
Complete Basic Data Entry Project
Script Debugger
Create Basic Lookup Project
Create Multi-user Data Entry Project

Day 3
Complete Multi-user Data Entry Project
Create Transaction Entry Project

Day 4
Complete Transaction Entry Project
Dexterity Utilities
Dynamics Integration Project

Day 5
Object Triggers
Additional Resources and Topics
Report Writer

The above agenda is a guideline and might be re-organised to fit additional topics if time allows.

To register your interest please use the contact us form at link below:

Note: Attendees will need to bring a laptop with Microsoft SQL Server and Microsoft Dynamics GP (working with sample Fabrikam company) installed locally. Dexterity will be installed during the training. Customers can use the same version of SQL and GP as they use in-house.

Please contact us soon to avoid missing out on this great opportunity.

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Following on from last week’s Friday Funny: How do you like your Toast? here is another silly waste of time. Hey, but it’s fun.

This week’s question is “How do you draw a capital X?”

What is the most popular method…. let’s find out.

Answer the poll below and see how you go against everyone else:

Take Our Poll

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This is completely off topic, but a fun way to end the week.

So the question is “How do you like your Toast?”.

Do you like warm soft bread, burnt smoldering charcoal or something in between?

So let’s have some fun and answer the following poll so we can gauge what the majority believe is the perfect slice of toast. Don’t let me naming of the levels affect your selection :

Take Our Poll

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

If you live in Perth and work in the tech industry (or don’t work in the tech industry and want something to do), please come and join some of the Perth based Microsoft MVPs for a free community event on Saturday 25th May 2019.

This all day event (8;30 am to 5:00 pm) will be held at the Civic Administration Centre, City of Canning in Cannington, and will be an exciting day with seven presentations and a Q&A panel session to finish.

For the first time, the Perth Microsoft MVPs will come together to provide you with knowledge and insights on how to innovate & transform business productivity utilising Microsoft PowerApps, Microsoft Flow, Excel, Power BI, Teams, Dynamics, & Azure.

Not only will you be ending the day richer in knowledge, there will be prizes to be won, including a tablet!

For full details, including the agenda, location and presenter details click on the link below:

Registration is free so click on that Register button (on the link above) to sign up for what is going to be a fantastic day.

I know that all the presenters, organisers and definitely me are looking forward to seeing you there.

Register Now!

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

You might have seen some postings on Twitter, Facebook and LinkedIn mentioning that I have been working hard on the next release of GP Power Tools. Well, all the major features planned for Build 27 have been completed.

All that is left to do is beta testing, documentation and a couple of minor features and then it can be released to the Microsoft Dynamics GP community in time for the upcoming conference season for 2019.

Build 26 of GP Power Tools was released in February 2019 and it contained many great new features and enhancements. There were lots of other features that I wanted to get into the build but instead decided it was more important to get all the fixes and features already finished into the hands of the community. Features such as the Automatic Logout and User Activity Tracking have been immensely popular.

After spending a month working on the blog to save the content from the Developing for Dynamics GP blog (which Microsoft have re-enabled), I decided to continue working on GP Power Tools and add the next set of features that were waiting on the “wish list”.  If you have any ideas you want to add to the wish list, let me know. That’s how the product has been shaped by the community (alomg with my desire to push the limits).

So here is a summary of the features and enhancements that you can look forward to in Build 27:

System Module

When capturing logs on startup you can now specify which of the three logging modes to enable.

Added User Name information to the “This transaction is being edited by another user.” for SOP and POP windows.

Administrator Tools Module

Added Launch File Configuration to allow automatic updating of the Launch File (usually Dynamics.set), without having to visit individual workstations, based on rules defined.

Added Dynamic Product Selection to allow for realtime selection between multiple versions of a window (Original, Modified, Alternate or Modified Alternate) when the window is opened. Normally you can only have access to a single version unless you change user or security records. Now you can just select which version you want from a dialog before it opens.

Added a Security Log Details window to the Security Log, so you can review all user and company access for the selected security object.

Resource Information window now displays multiple results when searching, so you can just click directly on the result you are interested in rather than repeatedly clicking the Search Again button.

Added an option to hide Inactive Users from the Security Information window.

Developer Tools Module

Added SQL Gotos, so that additional tasks can be performed based on the selected records from results returned by SQL Execute scripts.

Triggers can now be registered against Modifier Added Fields. Combined with the ability to run scripts against Modifier Added Fields, this allows for business logic to be added to these fields without using Visual Basic for Application (VBA) or Visual Studio Tools. You can now replace VBA modifications with triggers and scripts, and it works great on the Web Client.

Triggers can now be registered against Modal Dialogs. Something that Dexterity itself cannot do, but GP Power Tools can. You can now alter or automate Modal Dialogs simply and quickly.

Triggers running before the Window Pre event can now hide the window, so you can automate the window without the users seeing it being driven.

Added support for Visual Studio Integration Toolkit (VSIT) so that you can use a trigger to add custom application level menus into GP.

Added support for custom URL drill backs so you can add URLs to external documents and have them drill back into Microsoft Dynamics GP and perform any function you desire.

Addition of Release Notes to Developer Tools allows a version history to be recorded with the objects.

Numerous enhancements to the Project Setup window and working with projects in general.

Database Tools Module

Added a SQL Login Maintenance window which can be used to reset passwords and check or change password policy settings. New passwords can be entered or generated and emailed to users.

I am really excited to be able to bring all this functionality to you. All this and more is free to existing GP Power Tools users, you just need to install the updated code over the existing installation on your systems.

Please subscribe to the blog or other social media feeds to be notified when Build 27 is released.

Hope to see you in person during the Conference Season 2019, where I will be attending four conferences in three countries over five months.

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I was not planning to post anything for Star Wars Day 2019, but then I came across the video created by the University of Western Australia and decided I needed to share it.

It recognises the sad loss of Peter Mayhew, who passed away on the evening of April 30, 2019 with his family by his side in his North Texas home.

Peter is known for playing everyone’s favourite Wookie, Chewbacca, in the Star Wars movies from 1977 to 2015. His massive 2.18m (7 foot 2 inches) frame was perfect for portraying the larger than life character. Thank you Peter for being a joyful part of many people’s lives.

Star Wars Day 2019 (direct link)

Star Wars Day 2019 - YouTube

If you missed last year’s video when BB-8 was welcomed to the University of Western Australia, here it is.

May the 4th be with you (direct link)

May the 4th be with you - YouTube

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Happy Easter everyone. In Australia, Easter is accompanied by a four day long weekend, so hopefully everyone will get a break from work.

You would have seen that I recently served on Jury Duty. I was lucky to be assigned to a short three day case and was able to get back to work fairly quickly.

I have been continuing the development of GP Power Tools with work on the upcoming build 27 release, which will be awesome, … more details to come.

To put a smile on your face with some geek humour, I thought I would post this comparison of looping methods showing the difference between a while loop and a loop until.

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The conference season for 2019 is approaching and I am going to be very busy doing lots of travelling, presenting, exhibiting and training.

I have been working hard on the development of the Winthrop Development Consulting products with new builds of GP Power Tools, Batch Posting Service Toolkit and Visual Studio Integration Toolkit being released already and another new build of GP Power Tools currently in development.

Winthrop Development Consultants will have a presence at four conferences this year in three countries.

Below are the conferences and their websites (click on the conference names):

User Group World Tour 2019
  • 12-13 June 2019 – Johannesburg, South Africa

Click here to register for the Johannesburg conference.

There is a possibility of running Dexterity training in Johannesburg, so please let me know if you are interested.

User Group Summit Australia 2019
  • 19-23 August 2019 – Melbourne, Australia

Click here to join the mailing list and register your interest (especially for GP content).

GP Technical Conference 2019
  • 9-11 September 2019 – Fargo, North Dakota, USA

The only conference specifically fo Microsoft Dynamics GP Partners, more details coming soon.

User Group Summit North America 2019
  • 15-18 October 2019 – Orlando, Florida, USA

Click here to register for the Orlando conference.

It is very likely that I will be running Dexterity training in Orlando, so please let me know if you are interested.

Looking forward to catching up with as many Microsoft Dynamics GP community members as possible.

David

This article was originally posted on http://www.winthropdc.com/blog.

Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview