Page 1 of 4512345678910...2025303540...Last »

Developing using Dexterity for Microsoft Dynamics GP 2015

David Meego - Click for blog homepageToday, I was contacted by a fellow Dexterity developer who was having trouble getting Dexterity for Microsoft Dynamics GP 2015 to run Dynamics.dic in Test Mode.

In this article, I will take you through the errors you could get and how to resolve them. Some of these you might know from previous versions, others are new to GP 2015.

For this article I am using Microsoft Dynamics GP 2015 R2 and Dexterity 14.00.0084 which comes on the DVD image. I have copied a clean Dynamics.dic from the application folder into a subfolder in the Dexterity folder. I opened the dictionary with Dexterity and selected Debug >> Test Mode (Ctrl-T).

The first error I get is “You need to run Dynamics.dic Utilities before you can run Dynamics.dic. Do you want to launch Dynamics.dic Utilities now?“.

Error1

Note: The name of the dictionary (in this case Dynamics.dic) will be whatever your development dictionary file is called.

This issue is has been around since the beginning and is because the Dynamics code is looking at the Dex.ini file for the settings INITIAL and SYNCHRONIZE and unless it can find those set to FALSE, it will think that it is the first time Dynamics GP is being launched and ask to go to the Utilities to set up the databases and synchronize the dictionary to the account framework.

Solution: The easiest solution is to copy the Dex.ini file from the Application’s Data subfolder to the Dexterity’s Data subfolder. However, be sure to make the couple of changes below:

  • Change DexHelpPath to point to the Dexterity folder.
  • Add ShowResids=TRUE (for pre GP 2015, GP 2015 now shows Resource IDs as default)

Launching into Test Mode again and I get “Unhandled script exception: SCRIPTS – data area EXCEPTION_CLASS_SCRIPT_MEMORY SCRIPT_CMD_EXTERN

Error2

 Clicking OK and the Login window opens, but it is not fully drawn.

 ErrorLogin

The problem here is that script that reads the ODBC Data Sources for the Server drop down list is trying to call an external library. This library is part of Dynamics GP, but not actually part of Dexterity and so is not installed.

Solution: Copy the GPDWIN32.dll from the Application folder to the Dexterity folder. This issue started from Microsoft Dynamics GP 2010 onwards.


Launching Test Mode again and I can login, but get another error just after login. The error is “Could not load file or assembly ‘Microsoft.Dynamics.GP.BusinessIntelligence.Homepage’ or one of its dependencies. The system cannot find the file specified.“.

Error3

This issue was introduced with Microsoft Dynamics GP 2013 when the homepage was changed.

Solution: Copy the following files from the Application folder to the Dexterity folder:

  • Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll
  • Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.Framework.dll

However, the error will still occur as GP 2015 now also requires the following file to be copied:

  • GPIcons.dll

Finally, you will also need to copy the following file to the folder where your development dictionary resides to avoid warnings when compiling:

  • Microsoft.Dynamics.GP.BusinessObjects.dll

Depending on your scripts you might also need the following files copied to the development dictionary folder to allow compilation without errors:

  • Microsoft.Dynamics.GP.ManagementReporterServices.dll
  • Microsoft.Dynamics.GP.Svc.Application.dll

Now you should be good to go. Good luck.

 

For more information, see these previous articles from my old blog:

 

Hope this article helps make your life easier.

David

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

Filed under: 2015, 2015 R2, Development, Dexterity, Dynamics, GP, Microsoft Tagged: Best Practice, Development, Dexterity, GP 2015

Originally posted here:
Developing using Dexterity for Microsoft Dynamics GP 2015

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

#GPPT What’s New: GP Power Tools is faster and easier to navigate

David Meego - Click for blog homepageAs mentioned in recent posts, GP Power Tools is almost ready for release. The user guide manual documentation is now completed… all 256 pages of it. If you want to get the code now, you can already install the public beta and upgrade to the final release later.

This is the first article in a series of What’s New posts for GP Power Tools. The aim of this series is to highlight some of the new features of the tool and flesh out more details than the 21 reasons to upgrade article.

When creating GP Power Tools, one of the first changes (other than rebranding) was to change the data storage from a Debugger.xml setup file to tables in the system database on SQL Server.

Performance

A bit of history …. The Debugger.xml file was originally used to avoid the creation of any SQL objects to allow easy installation and removal of the Support Debugging Tool for its role as a troubleshooting tool. As the functionality of the tool grew and more data was stored in the Debugger.xml, performance slowed as the data was written to and read from the Debugger.xml file. To help with the read performance, ctree tables were used to cache the contents of the Debugger.xml. Also, the additional features added to the tool meant that the Debugger.xml needed to be stored in a shared network location. Finally, because the tool has lots more functionality than the original troubleshooting tool, it was being left installed on systems and the ease of removal was no longer important.

SQL Server

When creating GP Power Tools, one of the first changes (other than rebranding) was to change the data storage to use SQL Server tables. You would think that this would be a simple change, but it took about two weeks to complete. To make the Debugger.xml setup file work as a storage system required a large amount of custom code. The windows would read the Debugger.xml contents into temporary tables and then read and write from the temporary tables. When saving or applying, the data was written back the Debugger.xml file and the cache tables. All this code needed to be removed and replaced with more conventional code to use the SQL tables. To complicate the conversion, on some windows, data needed to be stored temporarily and only saved to the physical tables when applied. This meant that additional code was needed to store data in temporary tables until applied.

The end result is that when saving data, there is no longer a noticeable pause as the data is written. Also there is no requirement for a shared location to store the Debugger.xml file, however a shared location is still useful to centralize storage of log and export files. Finally, having the data stored in SQL Server is more secure than a shared location in the file system.

Navigation

One of the areas of feedback received about the Support Debugging Tool was that it was difficult to find the options / windows. Part of the cause of this is that when new features were added, their navigation options were just added to the bottom of the Standard Mode or Advanced Mode features.

So GP Power Tools resolves this by providing multiple options for navigation as well as grouping the features. You can still find the main GP Power Tools Logging Control window on the Tools menus of the application and individual windows (both menu or ribbon style). The Ctrl-D keyboard shortcut is also still available.

GP Power Tools Menu   GP Power Tools Menu Ribbon   GP Power Tools Menu Window

You can also find the options on the Standard Toolbar and Quick links on the home page.

Toolbar    GP Power Tools Quick Links

From the main GP Power Tools window, you can use the Options button drop list or the GP Power Tools window menu to access other features. Both of these menus are now broken down with sub menus into functional areas:

  • Resources and Security
  • Scripting
  • Export and Import
  • Administration

GP Power Tools Options Menu 2   GP Power Tools Options Menu 3

GP Power Tools Options Menu 4    GP Power Tools Options Menu 5

Also, GP Power Tools has been added to the application level menus as a sub menu under Transactions, Inquiry, Reports, Cards, Setup, Utilities and Routines.

GP Power Tools Transaction Menu

Finally, GP Power Tools has its own Area page from the Navigation buttons: GP Power Tools Area Page Button

GP Power Tools Area Page Navigation

The Area Page means that navigation on the Microsoft Dynamics GP Web Client is now simpler.

Access to the windows is controlled by application level security and the four automatically created security roles:

  • GP POWER TOOLS USER – For Standard Mode (User) features
  • GP POWER TOOLS ADMIN – For Advanced Mode (Administrator) features
  • GP POWER TOOLS PASSWORD – For Administrator Password Setup window only
  • GP POWER TOOLS SERVICES – For GP 2015 (or later) Service Enabled Procedures

Note: Access to Advanced Mode features also requires sysadmin or dbo access at the SQL Server level and the System Password or Administrator Password (if enabled). The option to hide Advanced Mode features using a Dex.ini setting is no longer used.

So now you should have no trouble navigating the various windows of GP Power Tools by whatever method you decide.

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

Originally posted here:
#GPPT What’s New: GP Power Tools is faster and easier to navigate

July 20, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 21

#GPPT Updates for the GP Power Tools Public Beta

David Meego - Click for blog homepageToday, I am releasing an update to the GP Power Tools Public Beta.

If you have installed a previous version, please download and install this updated code as it contains a number of cosmetic and performance changes that have been identified by beta testers and during the documentation process.

The Beta 3 (Last Modified: 13-Jul-2015) build includes the following changes:

  • The About GP Power Tools window now shows the versions of the Visual C# and Visual Basic.Net Extension Addins if they are installed.
  • The Database Validation window fixes a couple of fields which had incorrect resizing properties and did not move correctly when the window was resized.
  • The Security Log window does not refresh multiple times when changing Display Modes, it will now only refresh once.
  • The GP 2013 build has better compatibility with GP 2013 R2. The Addins were causing errors.
  • The documentation is almost completed (except for Database Validation). The User Guide Manual PDF is now 238 pages long.

Also, have the following guidelines for a smooth installation:

  • If upgrading from the Support Debugging Tool, install Debugger.cnk and GPPTools.cnk first. Do not install any DLLs. Run as Administrator to allow Debugger.cnk to replace the Support Debugging Tool’s Debugger.dic and update the Dynamics.set to use GPPTools.dic in future. Once the changes to Dynamics.set are completed, the DLLs in the application folder and the Addins folder can be installed.
  • After copying the DLL files to the application folder and Addins folder, right click on each one and Unblock the DLL if it is blocked. The Unblock Button will show at the bottom of the General tab.

Unblock

  • If the Addins cause issues, you can remove them, but you will lose the functionality they provide. Please contact me if you have any issues.
  • Login at least once as a user with ‘sa’ or similar permissions to allow the SQL tables in the Dynamics database to be created. If upgrading from the Support Debugging Tool, the Debugger.xml file be imported to populate the SQL tables.
  • Once GP Power Tools is installed, all Support Debugging Tool files (except for the Debugger.xml) will be removed.
  • If upgrading from a previous Beta build, there is no need to un-install, just copy the GPPTools.cnk and replace the DLL files in the appropriate folders.

Enjoy the beta and please provide feedback as comments on this post and via the survey built into GP Power Tools.

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: Beta, GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT, News

Visit site:
#GPPT Updates for the GP Power Tools Public Beta

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

#GPPT Installing the GP Power Tools Public Beta

David Meego - Click for blog homepageNow that the GP Power Tools Public Beta is out there, I know that people will not read the user guide documentation (GPPTools.pdf).

So I thought it would be worth while mentioning some guidelines to make the install as smooth as possible.

Firstly, let’s discuss the contents of the downloaded archive file. The archive contains the following files:

  • GPPTools.cnk

This is the self-installing dictionary containing the Dexterity code for GP Power Tools.

  • Debugger.cnk

This is a self-installing dictionary used for migration from the Support Debugging Tool. It is almost identical to GPPTools.cnk but uses the Debugger.* filenames.

This is required when the Debugger.dic file is already installed as extracting a chunk file will not update the launch file if it already exists. So this will overwrite the old dictionary file and then update the launch file to have the new names for the product and files. When Dynamics GP is restarted, everything now points to the new GPPTools.dic and the code removes Debugger.* files.

Only install this file if the Support Debugging Tool is already in the launch file.

  • GPPTools.txt

This is the read me file which version history information. Installation is optional.

  • GPPTools.pdf

This is the user guide for GP Power Tools. It must be installed if you want the application help system to be able to open the file.

  • License.doc

This is the license agreement for GP Power Tools which you accept by using the product. Installation is optional.

  • Application.GpPowerTools.dll

This is the signed Dictionary Assembly for the GP Power Tools Dexterity dictionary.

  • Application.GpPowerTools.xml

This is the IntelliSense data for Visual Studio for the GP Power Tools Dexterity dictionary.

  • Application.GpPowerTools.Metadata.dll

This is the signed Dictionary Assembly for the GP Power Tools Service Enabled Procedures. For version 14.0 or later.

  • Application.GpPowerTools.Metadata.xml

This is the IntelliSense data for Visual Studio for the GP Power Tools Service Enabled Procedures. For version 14.0 or later.

  • Addins/WinthropDC.GpPowerToolsVC.dll

This addin dll adds Visual C# support to GP Power Tools. Removal will disable the ability to execute Visual C# scripts.

  • Addins/WinthropDC.GpPowerToolsVB.dll

This addin dll adds Visual Basic.Net support to GP Power Tools. Removal will disable the ability to execute Visual Basic.Net scripts and execute Dexterity sanScript against modified dictionaries.

 

Use the following steps will install GP Power Tools:

  1. Copy the files to the Microsoft Dynamics GP application folder and the two dlls to the Addins folder.
  2. For the dll files, right click and select Properties and click the Unblock button if it is shown on the bottom of the first tab.
  3. Launch Microsoft Dynamics GP using Run as Administrator.
  4. If asked to restart after launch file changed, go back to step 3.
  5. Log into Microsoft Dynamics GP using a user ID with system administrator or DBO privileges, such as ‘sa’ or ‘DYNSA’.
  6. GP Power Tools will create its tables and read in the Debugger.xml file if upgrading from the Support Debugging Tool.
  7. You will be asked to assign security to all users, recommended to respond Yes.
  8. You will be reminded to manually assign security to the administrator level users.

Once installed, GP Power Tools can be accessed from the Application and window level Tools menus, the GP Power Tools area page as well as from the GP Power Tools sub menu on the application menus.

Disclaimer: As with all beta code, it is provided “as is” and you use it at your own risk.

If you receive errors from the two Addin dlls, they can be removed to avoid the errors. However the Visual C# and Visual Basic.Net functionality they provide will not be available. Please let me know if you have this issue.

Enjoy the beta and please provide feedback as comments on this post and via the survey built into GP Power Tools.

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: Beta, GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT

Read More:
#GPPT Installing the GP Power Tools Public Beta

July 8, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 31

Friday Funny: Best Marriage Proposal

David Meego - Click for blog homepageThere have been some amazing marriage proposals posted via social media and YouTube over the last few years, but this has got to be one of the coolest one yet.

Maybe that’s just because it is from an Australian guy ….

Watch below to see Liam Cooper’s proposal to his long time girlfriend, Amy Smith:

Aussie guy proposes to girlfriend in packed cinema. Best wedding proposal EVER! (Direct link)

 

Here is the full music video created for the proposal:

Rude by Magic! (Cover & Music Video for Wedding Proposal!) (Direct link)

 

Here are some other movie trailer proposals (in no particular order):

Enjoy

David

PS: Now, go get a tissue and dry your eyes now.

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

Filed under: Fun Tagged: Friday Funny, Fun

Excerpt from:
Friday Funny: Best Marriage Proposal

June 19, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 67

Microsoft Dynamics GP 2015 R2 now available

David Meego - Click for blog homepageThanks to a GPUG forum post from Lou Spevack, I found out that Microsoft Dynamics GP 2015 R2 has been released over the weekend.

The development team are delivering on the faster release schedule promised at the recent conferences.

The links for the downloads are below:

For the DVD image go to the following page:

For the Patch file go to the following page:

I have also created a new page on the blog with the links for all current versions:

Enjoy

David

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

Filed under: 2015 R2, Dynamics, GP, Microsoft, News Tagged: Application, GP 2015, News

Link:
Microsoft Dynamics GP 2015 R2 now available

June 1, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 82

Friday Funny: Email in Real Life

David Meego - Click for blog homepageLast year I posted on my previous blog a funny video article which rang true for me. Well now there is a sequel video which warrants a revisit of the video series.

As someone who has worked in the IT industry for many years with a significant amount of the recent years with a reasonable large corporation that you might have heard of, the videos from Tripp and Tyler are “spot on”.

See both videos below:

 

A Conference Call in Real Life (direct link)

 

Email in Real Life (direct link)

 

See the original post at Friday Funny: A Conference Call in Real Life.

Enjoy

David

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

Filed under: Fun Tagged: Friday Funny, Fun

Read More:
Friday Funny: Email in Real Life

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