Page 1 of 4212345678910...2025303540...Last »

Announcing Advanced Dexterity Training in Mexico City on 26-30 September 2016

David Meego - Click for blog homepageLast year, between reIMAGINE 2015 and GPUG Summit 2015, I ran Dexterity Fundamentals Training in Mexico City for the Microsoft Partner, Axentit.

So, this year they have asked me to come back and run an Advanced Dexterity Training class for them between reIMAGINE 2016 and GPUG Summit 2016.

The training will run in the week following the reIMAGINE 2016 conference and will be located at the Axentit offices in Mexico City from Monday 26th September 2016 to Friday 30th September 2016.

Dexterity Splash
This gives me another excuse to show the “Exploding Head” Dexterity logo

After this course I will be running the Dexterity Fundamentals Training in Tampa, Florida in the week before GPUG Summit 2016.

Below is some draft information on the training, however, the agenda might change as I will be getting feedback on specific topics that the attendees would like covered.

Dexterity II (Dexterity Advanced Integration Techniques)

Course Synopsis:

The Dexterity II course is designed to build upon the skills acquired from the Dexterity I course. It will provide advanced knowledge necessary to build applications that are tightly integrated with Microsoft Dynamics GP. The class will focus on building integrations associated with maintenance windows, transaction windows, inquiry windows and reports. In addition, topics such as creating SQL data and upgrading applications will also be discussed.

By actively participating in this class, you will learn:

  • Advanced programming techniques used by Microsoft Dynamics GP to develop Dynamics GP modules
  • How to develop add-on applications that will interact with the Dynamics GP products to meet specific customer requests
  • How to develop add-on applications that will “look and feel” like Dynamics GP and provide a seamless interface between the applications to ensure a professional finished product

Who should attend?

Customers or Partners who will be customizing or building applications to integrate with the Dynamics GP products.

Prerequisites:

  • A basic understanding of Dynamics GP is also needed.
  • Hands on development experience with Dexterity, preferably Dexterity I training course.
  • Familiarity with the Dynamics Software Developer Kit.

Agenda

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

Course Topics

Day 1
Introductions and Overview
Maintenance Window Integration Project
– Using the Great Plains Note object
– Using companion tables
– Implementing triggers to synchronize data

Day 2
Installation Window
– Creating SQL Tables
– Pass through SQL
Transaction Entry Window Integration Project
– Adding fields to an existing scrolling window
– Implementing triggers for data manipulation

Day 3
Inquiry Window Integration Project
– Modify existing inquiry window
– Create a new inquiry window
– Working with temporary tables

Day 4
Reports
– Modifying existing reports to add 3rd party data
– Using calculated fields and Report Writer functions
– Building a Report Options window

Day 5
Reports
– Building a Report Options window (continued)
Upgrading
– Table Conversions
– Installation scripts – adding to a palette, setting security, and adding to the shortcut bar
Error Handling and Debugging

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

To register your interest, so you are notified once more details are available, please contact Mariano Arias via email marias at axentit dot com dot mx.

Hope to see you there.

David

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

Filed under: Development, Dexterity, Training Tagged: Development, Dexterity, Training

Continue Reading:
Announcing Advanced Dexterity Training in Mexico City on 26-30 September 2016

March 30, 2016 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 57

#GPPT Understanding GP Power Tools User vs Administrator features

David Meego - Click for blog homepageRecently, a question was raised about what was required to access GP Power Tools (GPPT) Administrator level features.

GP Power Tools features can be broken down into to levels or modes:

  • Standard Mode or User Level features
  • Advanced Mode or Administrator Level features

Standard Mode features can be used safely by all users and can be accessed once application level security is granted to the windows using the GP POWER TOOLS USER Security Role. This role should be granted to all users for all accessible companies in the system.

Standard Mode includes the following features; Manual Logging Mode, Dex.ini Settings, Resource Information, Security Profiler, Security Information, Security Log, Runtime Executer, SQL Executer, .Net Executer, Configuration Export/Import , ScreenShot, and Send Email.

Advanced Mode features are those administrator level features that could provide access to view or modify data and include scripting in multiple languages and Export/Import facilities. Advanced Mode features require the following:

  • Application level security using the GP POWER TOOLS ADMIN Security Role or POWERUSER Security Role.
  • SQL Server system administrator (sysadmin) or database owner (dbo) privileges to the system database and company databases.
  • The Dynamics GP System Password or the GP Power Tools Administrator Password (depending on how the system is configured).

Advanced Mode features include; Automatic Debugger Mode, Dictionary Control, XML Table Export, XML Table Import, Runtime Execute, SQL Execute, .Net Execute, Configuration Maintenance, Administrator Settings, Administrator Password Setup, Dex.ini Configuration, Database Validation, and Setup Backup and Restore.

If the user does not have the elevated privileges at the SQL Server level, they will receive the “You must be logged on as a user with SQL Server system Administrator (sysadmin) or database owner (dbo) privileges to the system and company databases to access this feature.” message.

GPPT_DBO_Error

Note: The message was previously “You must logged on as a user with DBO privileges to access this feature.“, but has been updated to provide more information.

The user who will be accessing Advanced Mode or Administrator Level features does not need to be a POWERUSER, ‘sa’ or ‘DYNSA’. They just need access to the windows and to be granted elevated permissions at the SQL Server level. The permissions are required both for technical reasons and as an extra level of security to ensure that only administrator users can access Advanced Mode features.

Please note that even though the user has elevated privileges, due to their password being encrypted, they can only log in to Dynamics GP and so cannot use those privileges outside Dynamics GP.

For more information on GP Power Tools, please visit the portal:

Hope this explains everything

David

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

Filed under: GP Power Tools, Products Tagged: GP Power Tools, GPPT, SQL

See the original article here:
#GPPT Understanding GP Power Tools User vs Administrator features

March 28, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 42

Announcing Dexterity Training at GPUG Summit 2016 in Tampa, FL, USA

David Meego - Click for blog homepageIt’s official, after discussions with Rich Beliveau from GPUG Academy, it is confirmed that GPUG Academy, with me as trainer, will be offering Dexterity Fundamentals training in the week prior to GPUG Summit 2016 in Tampa, Florida, USA.

The training will run from Monday 3rd October 2016 to Friday 7th October 2016 and will be held at the Microsoft Office in Tampa. GPUG Summit 2016 will follow on 11th to 14th October 2016.

The details and links to register will be published as soon as they are available in mid 2016. This announcement is so you can start the planning process and book the time into your schedules.

Dexterity Splash
I know it is the old logo, but I have always liked this one.

Below is 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.

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:30-5:30 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, so you are notified once more details are available, please email Rich dot Beliveau at dynamiccommunities dot com.

Hope to see you there.

David

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

Filed under: Conference, Development, Dexterity, GPUG, Training Tagged: Conference, Development, Dexterity, GPUG Summit 2016, Training

See original article:
Announcing Dexterity Training at GPUG Summit 2016 in Tampa, FL, USA

March 24, 2016 · WinthropDC · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 63

#GPUGAmplify Early Bird Discount ends Friday 25th March 2016

David Meego - Click for blog homepageAt the beginning of the month, I posted an article announcing the new GPUG Amplify conference being held at the Marriott Anaheim, in Anaheim, California, USA on 23rd to 25th May 2016.

Today’s post is to remind you that the Early Bird Discount ends on Friday 25th March 2016. So make sure you take advantage of the discount and Register now.

Amplify_Logo

If you want to understand the difference between GPUG Amplify and GPUG Summit (in October 2016), please review the diagram published by Bob McAdam.

The GPUG Amplify conference will cover the future direction and roadmap for Microsoft Dynamics GP including the upcoming of Microsoft Dynamics GP 2016. This is your chance to have an open dialog directly with Microsoft and the team behind Microsoft Dynamics GP.

So Register today.

David

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

Filed under: 2016, Conference, Dynamics, GP, GPUG, Microsoft Tagged: GPUG, GPUG Amplify, News

Visit site:
#GPUGAmplify Early Bird Discount ends Friday 25th March 2016

March 23, 2016 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 64

Friday Funny: Camel Maths

David Meego - Click for blog homepageI came across this funny maths puzzle recently. This time it has the answer with it, so you don’t need to work it out.

However, it does have a moral to go with it. :-)

So the story goes:

A father left 17 camels as an asset for his three sons. When the father passed away, his sons opened up the will. The will of the father stated that:

  • The eldest son should get half of 17 camels.
  • The middle son should be given a third of 17 camels.
  • The youngest son should be given ninth of the 17 camels.

As it is not possible to divide 17 into half or 17 by 3 or 17 by 9, the sons started to fight with each other.

So, they decided to go to a wise man. The wise man listened patiently about the will. The wise man, after giving this much thought, brought one camel of his own and added the same to 17. That increased the total to 18 camels.

Now, he started reading the deceased father’s will.

  • Half of 18 = 9. So he gave 9 camels to the eldest son.
  • A third of 18 = 6. So he gave 6 camels to the middle son.
  • A ninth of 18 = 2. So he gave 2 camels to the youngest son.

The sons were happy. But add this up: 9 + 6 + 2 = 17. This leaves 1 camel, which the wise man took back.

Moral: the attitude of negotiation and problem-solving is to find the 18th camel, i.e. the common ground. To reach a solution, you must believe that there is a solution.

Enjoy

David

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

Filed under: Fun Tagged: Friday Funny, Fun

Read More:
Friday Funny: Camel Maths

March 18, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 56

#GPUG Webinar: Why is the Support Debugging Tool/GP Power Tools so Amazing?

David Meego - Click for blog homepageAfter the huge success at the GPUG Summit 2015 conference, Beat Bucher MVP and I will be presenting an encore performance of our GP Power Tools (GPPT) session as a webinar.

Even though the session title mentions the Support Debugging Tool (SDT), the session focusses on GP Power Tools. This is because the Support Debugging Tool has been discontinued since October 2014 and replaced by GP Power Tools.

The webinar session is being presented as part of the DBA SIG (Database Administrators Special Interest Group). The details of the session are below:

This webinar takes you through some of the many ways that the Support Debugging Tool can make your life administering, supporting, consulting or developing for Microsoft Dynamics GP easier. David Musgrave and Beat Bucher will use real life examples to show how the Support Debugging tool can help. This session also includes demonstrations of GP Power Tools, and its new features.

This webinar is part of the Database Administrators Special Interest Group, whose goal is to help you learn and share expertise, tools and tips for managing and developing for Dynamics GP

DBA SIG: Why is the Support Debugging Tool/GP Power Tools so Amazing?

Thursday 17th March 2016 (10:00 AM) to Thursday 17th March 2016 (11:00 AM) (US EST)

Click here to Register.

For more information see:

Hope to see you there

David

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

Filed under: Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Support Debugging Tool Tagged: GP Power Tools, GPPT, GPUG, SDT, Support Debugging Tool

Continue reading here:
#GPUG Webinar: Why is the Support Debugging Tool/GP Power Tools so Amazing?

March 15, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 51

#GPPT Function MBS_Net_Execute_Available does not exist in the dictionary

David Meego - Click for blog homepageI recently had a support case where the customer was receiving an Add-In Initialization Error when launching Microsoft Dynamics GP which was related to GP Power Tools and the WinthropDC.GpPowerToolsVB.dll or WinthropDC.GpPowerToolsVC.dll add-in.

The Problem

The full error message displayed on launching Microsoft Dynamics GP was:

WinthropDC.GpPowerToolsVC.dll: Fuction MBS_Net_Execute_Available does not exist in the dictionary. Parameter name: scriptName

Below is a screenshot of the error message:

GPPTAddinError

During the troubleshooting steps, we confirmed that if you removed or renamed (by changing the extension) of the WinthropDC.GpPowerToolsVC.dll and WinthropDC.GpPowerToolsVB.dll files in the Addins folder, that Microsoft Dynamics GP would launch without error.

However, once launched there was no sign of GP Power Tools on the menus or area pages.

The Cause

The cause of this issue was that the Dynamics.set launch file was corrupted. There were paths pointed to in the Dynamics.set launch file which did not exist. For custom forms and reports dictionaries, it is alright if the files themselves don’t exist, but the folder path specified must exist. This issue stopped the dictionaries listed after the bad paths from loading.

It is also possible to get the same error if the Dynamics.set launch file does not have the GPPTOOLS.DIC GP Power Tools application dictionary on the correct line in the list of the paths. This could happen if the Dynamics.set launch file is incorrectly manually edited.

Another existing dictionary file was on that line so we did not receive a “dictionary not found” error, however, when the WinthropDC.GpPowerToolsVC.dll and WinthropDC.GpPowerToolsVB.dll addin files attempt to initialize they are unable to locate the expected GP Power Tools resources in that dictionary.

The Solution

To fix the issue we needed to ensure that the Dynamics.set was correct. That it had 2 product lines for the number of installed products (number on first line) and that it had 3 path lines for the number of installed products (for each workstation set, if more than one), and that the paths all pointed to valid folders and files.

Note: Make a backup copy of the Dynamics.set launch file before you edit it.


5261
GP Power Tools

:C:Program Files (x86)/Microsoft Dynamics/GP/GPPTOOLS.DIC
:C:Program Files (x86)/Microsoft Dynamics/GP/Data/GPPT_FRM.DIC
:C:Program Files (x86)/Microsoft Dynamics/GP/Data/GPPT_RPT.DIC

Hope this helps

David

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

Filed under: Dynamics, GP, GP Power Tools, Microsoft, Products Tagged: GP Power Tools, GPPT

See the original article here:
#GPPT Function MBS_Net_Execute_Available does not exist in the dictionary

March 14, 2016 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 51