Page 1 of 4612345678910...2025303540...Last »

Get involved: Enter the GPUG Summit “AppOFF” Competition

David Meego - Click for blog homepageWith the release of Microsoft Dynamics GP 2015, developers were provided with additional Service Based Architecture (SBA) functionality built into the application and development environment.

Service Based Architecture is primarily comprised of two features: Service Enabled Procedures and the .Net Interop.

These two features blur the line of distinction between Dexterity and the .Net development world. Previously tools like Continuum and Visual Studio Tools allowed external developers to interface with Dexterity based applications, but Dexterity itself was unaware of these tools and their integrations.

With Service Based Architecture, Dexterity is now able to get in on the party. It can create code in the form of Service Enabled Procedures which are exposed to the outside world as REST based web services. It can also now use .Net objects, methods, properties and datatypes directly in Dexterity’s sanScript language.

GPUGSummit_Logo

To promote the use of this technology, at the upcoming GPUG Summit confence in Reno, Nevada, USA on the 13-16 October 2015, the Dynamics GP User Group (GPUG) will be hosting an “AppOFF” competition.

The competition is inviting GPUG members to design and create a Dynamics GP related App which can either leverage the default web services included with Microsoft Dynamics GP 2015 or use custom developed Dexterity service enabled procedures to provide additional web services.

The aim is to edcuate members on the tools that can be used to create Apps and so providing some GP related Apps for the community to use, while having some fun with a contest between members.

If you saw the development tools session that Mariano and I presented at Convergence, we showed you can use the Project Siena tool in conjunction with standard GP web services to create functional App in only a few minutes.

For more information on the objectives and guidelines, see Kim Peterson’s blog post

Get involved, enter now.

David

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

Filed under: Conference, Development, GPUG, News Tagged: Conference, GPUG, GPUG Summit 2015, News

Read the article:
Get involved: Enter the GPUG Summit “AppOFF” Competition

August 27, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 7

#GPPT Now that GP Power Tools is available, what happens to my Support Debugging Tool installation?

David Meego - Click for blog homepageIf you follow this blog, I am sure you already know that GP Power Tools has been released through my distribution and support partner, Mekorma, for Microsoft Dynamics GP 2010, GP 2013 and GP 2015.

The question I am hearing now from existing Support Debugging Tool sites is:

Now that GP Power Tools is available, what happens to my Support Debugging Tool installation?“.

The short answer is simple …. Nothing, absolutely nothing.

The long answer is summarised below:

Development: The Support Debugging Tool is discontinued and there is no further development.

Support: The Support Debugging Tool is no longer supported (it was never supported by Microsoft).

Expiry: The Support Debugging Tool will not expire.

If you are using the Support Debugging Tool with Microsoft Dynamics GP 2010 or GP 2013, you should really upgrade to GP Power Tools so you can be on a better product that IS supported and IS being developed futher.

The following articles contain details of the many enhancements, improvements, additional features and fixes that GP Power Tools has over the Support Debugging Tool:

The special introductory annual subscription price of US$365 means that you can have Peace of Mind for a dollar a day. You will even get an extra day for free every four years. :-)

That’s cheaper than a morning coffee and much more useful.

For more information on ordering, please see the GP Power Tools Portal:

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products, Support Debugging Tool Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, SDT, Support Debugging Tool, What’s New

More:
#GPPT Now that GP Power Tools is available, what happens to my Support Debugging Tool installation?

August 26, 2015 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 13

#GPPT Installing GP Power Tools (Upgrading from SDT, Silent Installs and more)

David Meego - Click for blog homepageNow that GP Power Tools has been out for a little while and I have recently released a hotfix that improves the installer as well as fixes some issues found with the tool, it is time to explain how the installer works and answer some frequently asked questions.

Please note that some of the information in this article only relates to the build 20 hotfix (Last Modified: 19-Aug-2015) or later. If you are unsure what build you have, just go and download the latest installer from the Mekorma website. If you look at the installer’s properties, the File Version will show as XX.0.20.4 or later.

Below are the questions and their answers:

Do I have to uninstall the Support Debugging Tool before installing GP Power Tools?

No, there is no need to uninstall the Support Debugging Tool from Microsoft Dynamics GP if you already have it installed. GP Power Tools and its installer have special code built in for handling the upgrade from the Support Debugging Tool to GP Power Tools.

What happens when upgrading from the Support Debugging Tool to GP Power Tools?

When the GP Power Tools installer detects the Debugger.dic file, it will install an additional Debugger.cnk file and automatically unchunk the file. The now extracted Debugger.dic dictionary will then run some upgrade code. The purpose of this code is to update the product name and file paths in the Dynamics.set launch file so they refer to GP Power Tools instead of the Support Debugging Tool.

The step to update the launch file is needed because the Support Debugging Tool and GP Power Tools share the same product ID 5261, and the Dynamics.set is not updated when installing a chunk for a product ID that already exists in the launch file.

Before you ask, I needed to re-use the same product ID to avoid breaking all the scripts that use Helper Functions that call with name “” in dictionary 5261. Also, it would be unwise to have both products installed at the same time as they would clash.

Next, the installer will install and unchunk the GPPTools.cnk as well as installing the DLL files needed for the .Net scripting functionality. The now extracted GPPTools.dic dictionary also runs some upgrade code. This code will adjust the Dynamics.set to ensure that the Mekorma Product Manager is listed before GP Power Tools in the file. It will also remove the now redundent Support Debugging Tool files.

What happens to all the data and settings I had in the Support Debugging Tool?

All the Support Debugging Tool’s settings are stored in a Debugger.xml file which will be located in the the Data folder or in a shared location if that has been set up.

After GP Power Tools installs and creates its tables in the System Database, it will look for the Debugger.xml file and import it to restore the data and settings.

You can restore a different Debugger.xml or backup to a Debugger.xml file at any time from the Setup Backup and Restore window in GP Power Tools.

Do I have to uninstall when installing a later build of GP Power Tools?

No, You can just install the later build over the top to update the existing instance. You can also use this feature to reinstall or repair an existing instance.

How can I uninstall a specific instance of GP Power Tools?

You can either run the installer and select the instance to be removed from the list of existing instances, or you can select the specific instance from the Control Panel >> Programs and Feature and uninstall it.

Why does the installer stop me uninstalling GP Power Tools when it is still installed in Microsoft Dynamics GP?

The GP Power Tools installer does not want to break your Microsoft Dynamics GP application. If the GP Power Tools files were removed before the product was removed from the Dynamics.set launch file, you will would get missing dictionary errors next time you launched GP.

You must uninstall GP Power Tools from inside the application using the About GP Power Tools window first. This will also remove the security and navigation entries it added and give you the option to remove the SQL objects created. Before removing the tables, GP Power Tools will back up their data to the Debugger.xml file.

Once, the GP Power Tools dictionary is removed from the Dynamics.set launch file and the addin DLLs have been renamed, your Microsoft Dynamics GP system can restart without issues. Now you can run the installer to complete the uninstall.

Can I do a Silent Install of GP Power Tools?

Yes, you can. From build 20 hotfix onwards, the installer supports performing a silent install from a command line with administrator privileges. You can specify the Microsoft Dynamics GP Instance and path to install to.

Below are examples of the syntax:

Installing to default instance of Microsoft Dynamics GP
GPPowerTools_14.00.0020.exe /s INSTALL=TRUE TARGETDIR="C:Program Files (x86)Microsoft DynamicsGP2015"
Installing to default instance of Microsoft Dynamics GP specifying instance name
GPPowerTools_14.00.0020.exe /s INSTALL=TRUE TARGETDIR=" C:Program Files (x86)Microsoft DynamicsGP2015" DYNINSTDESC="(Default)"
Installing to a specified instance of Miicrosoft Dynamics GP
GPPowerTools_14.00.0020.exe /s INSTALL=TRUE TARGETDIR=" C:Program Files (x86)Microsoft DynamicsGP2015R2" DYNINSTDESC="GP2015-R2"

Notes:

  • The top two examples are essentially the same, if using the default instance of Microsoft Dynamics GP, then you don’t need to specify the instance name. If you do wish to specify the instance name then use “(Default)” for default instance.
  • When specifying the instance, it must match an existing GP instance as it will be checked in the registry.
  • When specifying the path, it must contain a Dynamics.exe of the same version as it will also be checked.

I have multiple installation instances on my system, can I install GP Power Tools for the other instances?

Yes, just run the installer again and select the option to create or update an instance. Then when asked to select the instance, just select a different instance from the list. You can also perform a silent install to a different instance.

The list of instances is read from the registry and so will only contain instances actually installed using the Microsoft Dynamics GP installer.

I have manually created additional application folders, can I install GP Power Tools to the additional folders?

There are times were you might have additional Microsoft Dynamics GP application folders with different products or customisations installed. These folders are often created by manually copying the application folder and editing the paths in the Dynamics.set and Dex.ini files.

These additional folders will not show up as instances in the installer. So use the installer for the actual instance instances first. Then you can copy the files from the installed instance to the additional folders. You will need to locate the chunk files in the appropriate C:Program FilesCommon FilesMicrosoft Dynamics GPGUID folder.

Hint: Use right click >> Properties >> Dictionary tab to confirm the versions of the chunk files.

Copy these files to the application folder:

  • GPPTools.cnk
  • GPPTools.pdf
  • GPPTools.txt
  • GPPTools_License.doc
  • Application.GpPowerTools.dll
  • Application.GpPowerTools.xml
  • Application.GpPowerTools.Metadata.dll (GP 2015 or later only)
  • Application.GpPowerTools.Metadata.xml (GP 2015 or later only)
  • MEP7156.cnk
  • MPRK.dll
  • MEP.chm

Copy these files to the application/Addins folder:

  • WinthropDC.GpPowerToolsVB.dll
  • WinthropDC.GpPowerToolsVC.dll

You will need to run Microsoft Dynamics GP as Administrator once to allow the chunk files to extract.

 

Hope this answers all your questions.

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, News, Products, Support Debugging Tool Tagged: FAQ, GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, SDT, Support Debugging Tool

See more here:
#GPPT Installing GP Power Tools (Upgrading from SDT, Silent Installs and more)

August 24, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 17

Vote now for your 2015 GPUG All Stars

David Meego - Click for blog homepageEach year GPUG (Dynamics GP User Group) recognises three individuals from the Microsoft Dynamics GP community who go above and beyond to help others.

These individuals will be recognised as GPUG All Stars at the upcoming GPUG Summit in Reno, NV, USA.

GPUP All Star

Please vote now… there are only 2 weeks left before the poll closes.

OK, before we go any further, I will admit that I am one of the nominees for this year and that I would love you to vote for me.

That said, there also many other very deserving individuals from both customer and partner organisations.

For more details on the award and the link to the voting poll, please check out Kim “Mamma” Peterson’s blog post

Voting closes on the 31st August 2015, so please vote now.

Happy voting.

David

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

Filed under: GPUG, News Tagged: GPUG, News

Visit site:
Vote now for your 2015 GPUG All Stars

August 15, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 26

#GPPT What’s New: Database Validation, copying databases and upgrades

David Meego - Click for blog homepageThe Database Validation feature was previously demonstrated but never released. GP Power Tools now releases Database Validation for general availability.

Database Validation is a tool designed to ensure that the user, company and table settings at the SQL Server level match what the Microsoft Dynamics GP application says they should be.

Database Validation does not replace any of the tools available already from Microsoft. It performs different functions to Dynamics Utilities, DB Maintenance, or Check Links.

Database Validation ensures that the user, company and access information in the application tables matches the logins, databases and database users in SQL Server. It checks for the correct database owner and permission settings for users. It also checks for invalid data in the Dynamics GP Utilities version tables and checks that the account framework settings match between the application, system database and company databases.

Database Validation can also be used to identify SQL tables and views which don’t appear to be used by any of the installed product dictionaries as well as Dexterity table definitions for which the SQL table or view has not been created. For tables that exist in both the Dexterity product dictionaries and in SQL, Database Validation can compare the tables structures to ensure that the columns and datatypes match.

When Database Validation is opened it performs the following checks on the system.

Users and Databases:

  • Confirm that the ‘DYNSA’ SQL Server Login exists
  • Confirm that ‘DYNSA’ is assigned as dbo for the SQL Databases
  • Confirm that the ‘DYNSA’ GP User ID exists
  • Confirm that ‘DYNSA’ is assigned access to all GP Companies
  • Confirm that ‘sa’ is assigned access to all GP Companies
  • Identify GP Companies for which there is no SQL Database
  • Identify GP User IDs for which there is no SQL Login
  • Identify GP Users not assigned to the DYNGRP SQL Role
  • Identify Company Access records for missing Users or Companies
  • Identify missing Database Users as per Company Access records

Dynamics GP Utilities:

Using the records in DB_Upgrade and DU00020 tables in the System database.

  • Identify records for companies that are not installed
  • Identify records for product dictionaries that are not installed

Account Framework:

  • Identify Account Framework from Application Dictionary
  • Identify Account Framework from setup tables in System Database
  • Identify Account Framework from GL_Account_MSTR (GL00100) table in each Company Database

This information is then displayed in the top half of the window. The red crosses and yellow exclamation marks highlight the various issues found.

Database Validation 1

After running the Fix Users, Fix Utilities and Fix Framework processes to fix any issues found during the initial checks, you can click Process to read the dictionaries and compare the tables and views identified against the data in the SQL databases. Then you can click Validate to compare the column and datatype structures for the tables existing in both the product dictionaries and the SQL databases.

Database Validation 4

If any tables are found with incorrect structures, the details are available as a report or via a window to show you the differences.

Database Validation Structure Errors

You can then click Fix Tables. Database Validation provides options to fix the tables depending on whether they contain data and if Dynamics Utilities has a conversion script available.

Examples of Use

Here are some common examples of how using Database Validation makes your life easier:

  1. Before upgrading you can ensure that there are no invalid users or companies in your system, that Dynamics Utilities has no “junk” in its tables, that the account framework settings match everywhere and that all the tables have the correct column structure and security permissions. This will help ensure a smooth upgrade without errors.
  2. When transferring all the databases to a new server, GP Power Tools can recreate all the logins and database users including using the application level encryption and marking the passwords to be changed on next login.
  3. When creating test environments, GP Power Tools can remove all the references to the users and databases that will not be used in the test environment.

For more information on using Database Validation, please review the section in the GP Power Tools User Guide manual PDF, which includes a step by step guide to usage. The manual is installed with the product and is also available as a separate download.

Enjoy

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, What’s New

Excerpt from:
#GPPT What’s New: Database Validation, copying databases and upgrades

August 12, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 30

#GPPT GP Power Tools Build 20 released

David Meego - Click for blog homepageI am so proud and excited to finally release the much anticipated replacement for the discontinued Support Debugging Tool.

Welcome to GP Power Tools for Microsoft Dynamics GP for versions GP 2010 (v11.0), GP 2013 (v12.0 including R2) and GP 2015 (v14.00 including R2).

This first release of GP Power Tools will be build 20 and includes many new features, enhancements to existing features as well as rebranding as a Winthrop Development Consultants product.

GP Power Tools is proudly distributed and supported by Mekorma. For more details on some of the new features please see the What’s New Series on this blog.

Version History

Below is a summary of the changes made for releases 11.00.0020, 12.00.0020 and 14.00.0020, I have divided them into logical sections

Conversion to GP Power Tools

  • Rebranded as Winthrop Development Consultants GP Power Tools for Microsoft Dynamics GP.
  • Converted setting storage from using Debugger.xml file to SQL Tables providing simpler setup and faster performance.
  • Added Menu Navigation and Area Page Navigation.
  • Updated Menu Navigation from GP Power Tools Logging Control window.
  • Removed Advanced Mode Setting which hid Advanced mode features, Security and SQL permissions control access.
  • Added Administrator Controlled Shared Folder for logs and export files into Administrator Settings window.
  • Removed Administrator Controlled Dex.ini Settings from Dex.ini Configuration window.
  • Added Windows Installer to install and uninstall files.

New Features

  • Added Setup Backup and Restore window to allow for the export and importing of the Debugger.xml file.
  • Added Database Validation Feature.
  • Added .Net Execute window to allow C# and VB.Net scripts to written and executed with Microsoft Dynamics GP.
  • Added Helper Functions for loading and executing .Net scripts from Runtime Execute and Automatic Debugger Mode Triggers.
  • Updated .Net Execute window to automatically add Imports or using statements and add references for new dictionaries.
  • Added Read-only .Net Executer window for running published scripts.
  • Added Read-only Runtime Executer window for running published scripts.
  • Added Read-only SQL Executer window for running published scripts.
  • Added option to expand the Company Name drop down list on the Company Login window to Administrator Settings window.
  • Added Exit After Processes menu option to Microsoft Dynamics GP application menu.
  • Added User Defined Custom Service Procedures to Service Based Architecture and Visual Studio Tools.
  • Added Security Activity Tracking setting to Administrator Settings window.
  • Added Security Log window to review data captured by Security Activity Tracking.
  • Added option to use separate Administrator Password instead of System Password.

Enhancements

  • Added Table Type column into the Table Explorer window of the Resource Explorer.
  • Added Field Context Menu Trigger Type to Automatic Debugger Mode Setup window to allow custom context menus with up to 10 items.
  • Added Published checkbox to Runtime Execute and SQL Execute windows.
  • Added Custom Script Purpose drop down list to Runtime Execute window to select specific script templates.
  • Added rw_ReportStart, rw_ReportEnd, rw_TableHeaderString, rw_TableHeaderCurrency, rw_TableLineString, rw_TableLineCurrency to Custom Script Purpose drop down list on Runtime Execute window.
  • Added Custom Service Procedures ServiceCreateCustom, ServiceDeleteCustom, ServiceGetCustom, ServiceUpdateCustom, ServicePostCustomto Custom Script Purpose drop down list on Runtime Execute window.
  • Added SmartList Builder GoTo procedures FillRunProcedureList, GetRunProcedureParameterCount, GetRunProcedureParameterName to Custom Script Purpose drop down list on Runtime Execute window.
  • Updated Names and Table Buttons on Runtime Execute window to use a single Names Button Drop List.
  • Added Reports and Scripts (Procedures & Functions) to Names Button Drop List on Runtime Execute window.
  • Added Scrollbar Width Override options to Dex.ini Settings window using MaxSWScrollbarSize Dex.ini Setting.
  • Added support for Service Enabled Procedures to Resource Information window.
  • Added Script Explorer with Service Enabled Procedure Support to Resource Explorer.
  • Added Service Enabled Procedure support to automatic creation of records in syCurrentResources (SY09400) table.
  • Added Service Enabled Procedure support to Security Information, Security Profiler and Security Log windows.
  • Added support for modified forms dictionaries to Runtime Execute window.
  • Added option for modified forms dictionaries to Helper Functions window.
  • Added MBS_Runtime_Execute_Modified helper function global procedure.
  • Updated Administrator Settings window to allow setting of color themes for any company without having to switch company.
  • Updated Administrator Settings window to allow optional selection of users for company based color themes.
  • Updated Administrator Settings window to increase the number of company based color themes from 16 to 52.
  • Updated Company based color themes to use third color on List Header 1 when Toolbar is unused by Ribbons.
  • Updated Resource Explorer window to identify parent window for scrolling windows for .Net Execute window.

Fixes

  • Fixed SQL Error when running SQL Profile Trace functionality on a SQL Server with Binary sort order.
  • Fixed issue when Resource Information form view automatic display would identify a window incorrectly.
  • Fixed Security Task creation from Security Profiler and Security Log windows to not created records for excluded resources.
  • Fixed Error on GP 2015 Dexterity Runtime Options window by replacing it with a custom Script Options window.
  • Fixed issue where Un-install and Dictionary Control window where unable to obtain write access to the Dynamics.set launch file.
  • Added Fix for bug in Script_GetSystemProperty() function to Resource Explorer window (for v14 only).
  • Added Fix for bug in Script_GetSystemProperty() function to Resource Information window (for v14 only).
  • Added Fix for bug in Script_GetSystemProperty() function to Microsoft Dynamics GP Security Task Entry window (for v14 only).

Downloads

The download links are on the bottom of Mekorma’s GP Power Tools page.

Note: You might be warned when downloading the installer that the file “is not commonly downloaded”. This is because the security certificate for Winthrop Development Consultants is still new and will take a little time to propagate through the internet. If this happens, you might need to unblock the file using Right-Click >> Properties >> Unblock.

Support Information

Support for GP Power Tools is provided by Winthrop Development Consultants’ distribution and support partner, Mekorma.

Support cases can be logged using the link below:

Support hours are 6:00am to 5:00pm (US Pacific Time), Monday to Friday.

Pricing Information

For customers, the special introductory price for an annual subscription is US$365 per year. That’s Peace of Mind for a dollar a day, and every four years you will get an extra day for free. :)

Partners can request Not for Resale (NFR) registration keys.

Please place your orders via Mekorma’s Order Now page:

More Information

For more information, please see the GP Power Tools Portal Page:

You can also look at the GP Power Tools pages on the Winthrop Development Consultants and Mekorma sites:

 

Please post your feedback as comments on this article or using the GP Power Tools Feedback Survey on what you think of this build and what you would like to see in the future.

Thanks to everyone involved with this release, especially the team at Mekorma, the beta testers and the Microsoft Dynamics GP MVPs.

A final massive thank-you to my family who have put up with me being in “programming mode” for the last four months.

David

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

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, News, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT

See original article:
#GPPT GP Power Tools Build 20 released

August 4, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 54

Announcing Winthrop Development Consultants’ partnership with Mekorma

Logo Horizontal

mekorma_logo2

Winthrop Development Consultants is proud to announce its Partnership with Mekorma. Mekorma is now the exclusive distribution and support partner for the Winthrop Development Consultants product range.

The first product in the range is the much anticipated GP Power Tools (formerly known as the Support Debugging Tool) now available for Microsoft Dynamics GP 2010, GP 2013 and GP 2015.

GP Power Tools takes everything great from its predecessor and makes it better. There are many new features and numerous enhancements to existing features. Mekorma, known for their excellent sales and technical support, now bring this to Winthrop Development Consultants and GP Power Tools.

The special introductory price for GP Power Tools is US$365 per year per customer site, which includes unlimited Mekorma Customer Support. The Support services will be available for GP Power Tools during normal office hours of 6:00am – 5:00pm (US Pacific Time). To place an order please fill out the online order form.

To download GP Power Tools, visit the Mekorma website; www.mekorma.com. Downloads are available for Microsoft Dynamics GP 2010, GP 2013 and GP 2015.

I am so excited to finally make this news public.

David

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

Filed under: Business, GP Power Tools, News, Products Tagged: General, GP Power Tools, GPPT, Mekorma, News

See more here:
Announcing Winthrop Development Consultants’ partnership with Mekorma

August 4, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 39