Page 1 of 11612345678910...2025303540...Last »

#GPPT What’s New: Series summary for GP Power Tools build 20

David Meego - Click for blog homepageOver the past few weeks I have been posting a number of “What’s New” articles for GP Power Tools build 20.

If you have missed any of them, this article has all the links to the articles, so you can read them at your leisure.

Below is a list of the articles:

For users of the discontinued and unsupported Support Debugging Tool still on Microsoft Dynamics GP 2010 and GP 2013, you now have many reasons to upgrade to GP Power Tools.

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

More:
#GPPT What’s New: Series summary for GP Power Tools build 20

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

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: 32

#GPPT What’s New: Create Custom Service Based Architecture Web Services

David Meego - Click for blog homepageMicrosoft Dynamics GP 2015 added Service Based Architecture (SBA) and .Net Interop functionality to the application. Service Based Architecture allows the Dexterity developer to write global procedures and use meta data to expose these service enabled procedures to the outside world as REST Web Services.

GP Power Tools provides five Service Enabled Procedures which can be used to execute custom business logic created in the Runtime Execute window. These services can be called as Web Services, from Visual Studio Tools using Visual C# or Visual Basic.Net, or from any Dexterity product dictionary using sanScript.

The functions provided by the custom service enabled procedures are controlled by the contents of the Runtime Execute Script ID identified in the URI or first parameter when the procedure was called.

Using the Runtime Execute window you can select one of the five procedures as a custom script purpose, this will populate the script with the template code needed to pass the parameters between the service enabled procedure and the Runtime Execute script.

To provide a flexible multi-purpose parameter format that can work for all version of Dynamics GP, the parameters in and out are passed using the Text datatype. Each line of the Text parameter can be used to represent a separate data field.

The template code populated, when you choose one of the service enabled procedures as a custom script purpose, provides example code using the Customer Master table.

  • ServiceCreateCustom – Create a new record
  • ServiceDeleteCustom – Delete a record
  • ServiceGetCustom – Retrieve a record
  • ServiceUpdateCustom – Update an existing record
  • ServicePostCustom – Perform any additional function (the demo code does maths)

The screenshot below shows the Runtime Execute window with the ServiceDeleteCustom template code. The template code retrieves the Customer ID to be deleted from the first line of the text parameter and then executes the code to locate and remove the record, returning any error codes as the status.

ServiceEnabledProcedures

While the base language for the Runtime Execute window is Dexterity sanScript, you have the option of using Helper Functions to call SQL Execute (T-SQL) scripts, or .Net Execute (Visual C# or Visual Basic.Net) scripts.

In summary, this means that GP Power Tools provides custom web services which can be coded in any combination of Dexterity sanScript, SQL Transact-SQL, Visual C# or Visual Basic.Net.

The possibilities are endless.

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

Follow this link:
#GPPT What’s New: Create Custom Service Based Architecture Web Services

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

Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 2

David Meego - Click for blog homepageFollowing on from my previous post: Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1, I was still not happy with the performance of Dexterity and Microsoft Dynamics GP on my newly updated Windows 10 development machine.

This article takes you through the steps to get your Dexterity and/or Dynamics system running fast on Windows 10.

I normally don’t post multiple articles in one day, but it was worth posting this one and the previous two as soon as possible to help others out there facing the same issues.

Performance Problem

After resolving the pause on exit issue discussed in the previous post, I noticed that Dexterity and Microsoft Dynamics GP where still very sluggish when running. It was taking much to long to log in and everything was like I was running through molasses.

Checking the Task Manager, I could see fairly high CPU usage. Sorting by the CPU column, the culprit was the Antimalware Service Executable. This Windows process is the real-time processing component for Windows Defender.

I have seen issues before with anti virus or malware solutions causing performance issues for Microsoft Dynamics GP and Dexterity, and the easiest way to resolve them is to add some exclusions to the settings for the application.

Part of the issue is that the Dynamics dictionary is a very large single file and the anti virus solution often wants to check the entire file when only a small part of it is being read. So you want to exclude the file type with the extension .DIC.

This is the same issue with the database and log files maintained by SQL Server. So you want to exclude the folder where SQL Server stores its .mdf and .ldf data files.

As a final step (that delivered some of the best performance improvement), I also excluded the executables for Dexterity, Dexterity Utilities and Dynamics. I have five versions of each installed, so that needed 15 entries.

Solution

To make the changes on your Windows 10 system running Windows Defender follow the steps below. If using a different anti virus or malware solution, you can add the same exclusions anyway.

  1. Select Start >> Settings
  2. Select Update & Security >> Windows Defender
  3. Under Exclusions, click Add an exclusion
  4. Under Folders, click Exclude a folder
  5. Locate the SQL Server Data folder and exclude it. On my system it was
    C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATA
  6. Under File Types, click Exclude a file extension
  7. Add .dic as an exclusion
  8. Under Processes, click Exclude a .exe, .com or .scr process
  9. Navigate to the Dex.exe, Dexutils.exe for each version of Dexterity and add it
  10. Also navigate to the Dynamics.exe for each version of Microsoft Dynamics GP and add it

Now test out how fast your system runs Dexterity and/or Microsoft Dynamics GP. Zoom Zoom. :-)

Hope you are happy with your Windows 10 upgrade now.

David

PS: I know adding exclusions weakens your protection, but it does stop you pouring a liquid into the machine in the hopes of dissolving the molasses.

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

Filed under: Development, Dexterity, Dynamics, GP, Microsoft, Windows Tagged: Application, Development, Dexterity, GP 2010, GP 2013, GP 2015, Windows 10

Read More:
Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 2

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

Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1

David Meego - Click for blog homepageNow that I am running Windows 10 and am starting to get back to work with developing for Microsoft Dynamics GP and Dexterity, I have been noticing some serious performance issues.

This article takes you through the steps I used to identify the issue and what I did to resolve the issues. After making the changes listed in this and the next article I am happy with my Windows 10 development environment.

The first issue I noticed was that when I exited Dexterity Test mode, there was a significant delay (about one minute) before I was returned to the Dexterity IDE (Integrated Development Environment). I tested this on multiple Dexterity versions and it still occurred. To make sure that it was nothing in my code, I tested using a clean Dynamics.dic and it still occurred.

To test if it was a Dexterity issue or Microsoft Dynamics GP in general, I started testing with multiple versions of Microsoft Dynamics GP and each time there was a minute pause when exiting. The problem was occurring for all current versions (GP 2010, GP 2013 and GP 2015) in both the runtime and development environments.

Note: I did not have this issue on my other Windows 10 machine, so it does not occur for all machines. It just occurred on my primary development machine. :-(

So now I put my Microsoft Escalation Engineer hat back on to troubleshoot and identify the cause. Using a source dictionary in Dexterity, I used the Script Log to capture the scripts running when you exit GP. The excerpt from the script.log file below shows two calls to the script exitDynamics of form Main Menu with a significant 30 second plus time before the next script.

14:12:04  'Main_Menu FORM POST on form Main Menu'
14:12:04      'exitDynamics of form Main Menu'
14:12:40          'SQLPath', 0, 7, 31, ""
14:12:40          'GetClientUIType()', 0
14:12:40          'Add_Successful_Logout_Record'
14:12:40          'DeleteUserMessages of form sySendMessage', "sa"
14:12:40              'SQLPath', 0, 7, 0, ""
14:12:40          'IsCreated() of form syDeferredPassword', 0
14:12:40      'isDynUtils() of form LibSystem', 0
14:12:40      'exitDynamics of form Main Menu'
14:13:12          'GetClientUIType()', 0
14:13:12          'Add_Successful_Logout_Record'
14:13:12          'DeleteUserMessages of form sySendMessage', "sa"
14:13:12          'IsCreated() of form syDeferredPassword', 0
14:13:12      'smDEX_Clear_Locks', 0, 15
14:13:12          'SQLScriptPath', 0, 7, 3069, ""
14:13:13      'ST_CleanupBeforeLogout'

Looking at this script, the issue had to occur between the start of the script and the first call to the GetClientUIType() function. So I placed a breakpoint at the top of the script and stepped through the script until it hit the pause. Below are the lines of code and the command causing the pause was the DDE_IsAppRunning(CONTAIN) call.


if (TEMPCloseOLE of globals) then
    if DDE_IsAppRunning(CONTAIN) then
        set fDummy to OLE_Exit();
    end if;
end if;

Looking at the DDE_IsAppRunning(CONTAIN) call, I could see that it was inside a conditional statement and so if we changed the value of the global variable TEMPCloseOLE of globals it should be possible to avoid the pause on exit issue.

Using the trusty References facility in Dexterity, I located the TEMPCloseOLE global field and asked what it was referenced by. In the global procedure Setup_System_Variables, I found the following lines.


set sFlag to Defaults_Read(DEXINI_OLECLOSE);
set TEMPCloseOLE of globals to (sFlag <> FALSE_STRING); 

This showed that the TEMPCloseOLE of globals variable was set once based on the Dex,ini setting referred to by the constant DEXINI_OLECLOSE (which evaluates to OLEClose).

With this information in hand I added the following Dex.ini setting to my system and tested again:

OLEClose=FALSE

Et Voila, the delay on exit disappeared. First problem solved. I forwarded my research to Microsoft Support in case anyone else was having this issue…. and it turned out that others had seen it.

The delay on exit issue was reported on the partner forum and my “workaround” solution was provided, then my friend Mariano blogged about it. Here are the links:

Hope this information helps take away the frustration I was having.

David

PS: I don’t really speak French, even though I did study it (and Latin) in primary school in the UK before I moved to Australia. I have even been to France, but that did not help.

PPS: Before you ask, I don’t speak Latin either… it is a dead language and even the Italians don’t speak it any more.

PPPS: OK, yes I know that even though Latin is dead, its influence lives on in many European languages.

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

Filed under: Development, Dexterity, Dynamics, GP, Microsoft, Windows Tagged: Application, Development, Dexterity, GP 2010, GP 2013, GP 2015, Windows 10

Visit site:
Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1

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

#GPPT What’s New: Company based color schemes enhancements

David Meego - Click for blog homepageOne of the most popular features of the now discontinued Support Debugging Tool was the Company based Color Schemes. This feature allowed administrators to specify a different color scheme for each Microsoft Dynamics GP company.

GP Power Tools takes this functionality and enhances it to make it more powerful and easier to use.

To enable the Company based Color Schemes, use the option on the second, Company, tab of the Administrator Settings window.

Administrator Settings 2

Once activated you can either select from the list of built-in themes or you can just use the Select buttons to manually choose the colors for the selected company.

GP Power Tools increases the number of built-in themes from 16 to 52, giving you more quick options for selecting a color scheme.

You can also select a theme and then adjust the colors as desired, just click Select to open the color dialog. Click on Define Custom Colours for a full spectrum of colors.

Color2
Note: Please excuse the correct spelling of “Colour” in this screenshot. :-)

New to GP Power Tools is the ability to select the company to set up colors for.

Previously, you would have to switch to each company and open the Administrator Settings windows to select the color scheme for the current company. Now you can change the company from the current company using the lookup button to open the Company Colors Lookup window.

Administrator Settings Lookup

Note: The lookup can display the colors for each company, however you need to scroll through the list to make them appear. A quirk in Dexterity meant the colors wouldn’t display initially.

Another feature new to GP Power Tools is the option to exempt specific users from the company based color schemes.

Administrator Settings Users

These three new features (more themes, company selection and user selection) were requested by existing users via forums and the feedback survey and were added to the final release after the public beta code was released.

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

Continued here:
#GPPT What’s New: Company based color schemes enhancements

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

#GPPT What’s New: Microsoft Dynamics GP usability enhancements

David Meego - Click for blog homepageGP Power Tools is now released and available via my distribution and support partner, Mekorma.

Continuing on with the What’s New series, today’s article will have a quick look at some of the usability enhancements to the Microsoft Dynamics GP application.

There are a number of features that GP Power Tools adds to Microsoft Dynamics GP to make using the application easier for users and administrators.

The first couple of features add menu entries with keyboard shortcuts to the main application menu. The options are for Raise All Windows to bring all open windows into the foreground above the main application window, and Exit After Processes to exit the application once all background processes are completed.

GP Power Tools Menu

The next features are enabled from the Administrator Settings window. The Prevent application windows from opening outside of the visible desktop area option resolves the issue where windows that remember their last position can open beyond the visible desktop. This problem can also occur with multiple monitor systems when having Microsoft Dynamics GP windows across more than one monitor.

Administrator Settings 2

The Add extra width to company name drop down list on Company Login windows option, adjusts the fields on the Company Login window to use the full width of the window. This ensures that long company names will be displayed in full in the drop down list.

Company Switch

Also once GP Power Tools is installed, the company selection drop down list on the Company Login will default to the company last selected on the window. If you don’t want this enhancement, it can be disabled via the Dex.ini Settings window.

The last feature for today enhances the access denied security message to add the details of the resource that the user is denied access to.

Access Denied With Details

This feature is enabled by default, but can be disabled from the Administrator Settings windows.

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

More:
#GPPT What’s New: Microsoft Dynamics GP usability enhancements

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