#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: 52

Bank Deposit Slip from Dynamics GP.

I want to document one of forgotten feature in Dynamics GP i.e. printing Bank Deposit Slip from Dynamics GP.

User can print Bank Deposit Slip right from Dynamics GP.

Goto–&gtTransactions–>Financial–> Bank Deposits

































Select your transactions–>Click on Print button to print Deposit Slip.





Depend on yours transactions report has all details – Checks #, Cash Details etc . User can take this form to Bank.

I have updated this forms as per customers bank preprinted format.

Thanks much for reading !!!



Until Next Post!!!

View original post here:
Bank Deposit Slip from Dynamics GP.

July 14, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 68

#GPPT 21 Reasons why you should upgrade to GP Power Tools

David Meego - Click for blog homepageAs the release of GP Power Tools approaches, I am hearing the following question from existing users of the Support Debugging Tool:

“Why should I pay to upgrade to GP Power Tools when the Support Debugging Tool is free?”

GP Power Tools will be available for Microsoft Dynamics GP 2010, GP 2013 and GP 2015. This article provides some insight into the enhancements and new features you will get when you upgrade from the Support Debugging Tool to GP Power Tools.

So to start with, here are twenty-one benefits of GP Power Tools:

  • Continuity: GP Power Tools is supported and being improved & enhanced. Also it is available for Microsoft Dynamics GP 2015 and will be available for future versions.
  • Familiarity: GP Power Tools provides all the features you know and love in the Support Debugging Tool.
  • Performance: GP Power Tools is faster because it uses SQL tables rather than the Debugger.xml setup file to store data.
  • Security: GP Power Tools is more secure because it uses SQL tables rather than the Debugger.xml setup file to store data.
  • Simplicity: GP Power Tools is simpler to setup as you no longer need a shared Debugger.xml setup file. The shared folder is still useful for storing logs.
  • More Simplicity: Advanced Mode Dex.ini setting to hide Advanced Mode features has been removed. Feature visibility is only controlled by a user’s application security settings.
  • Navigation: GP Power Tools has easier to use multi-level menus from the main window.
  • More Navigation: GP Power Tools now has an area page as well as sub menus on the application menus.
  • Resource Information: Now includes a Script Explorer for identifying global & form level procedures & functions.
  • Runtime Execute: Can now execute scripts against modified windows and modifier added fields.
  • .Net Execute*: You can now write scripts in Visual C# and Visual Basic.Net and execute them without needing Visual Studio.
  • Mix ‘n’ Match Scripting*: Using Helper Functions you can write scripts using any combination of Dexterity, T-SQL, Visual C# and Visual Basic.Net at the same time.
  • Runtime Executer*: Allows users read only access to execute published Dexterity Scripts.
  • SQL Executer*: Allows users read only access to execute published SQL Scripts.
  • .Net Executer*: Allows users read only access to execute published .Net Scripts.
  • Administrator Password Setup*: You can now have a separate Administrator password for GP Power Tools Advanced Features instead of the System Password.
  • Setup Backup and Restore*: Export and import all GP Power Tools settings to and from a Debugger.xml file.
  • Security Log*: Review data captured by the Security Activity Tracking and create Security Tasks and Security Roles from the data.
  • Database Validation*: Validate that your GP users and companies match your SQL Logins, Users and Databases. Validate that all tables exist in your system and confirm that the tables that do exist have the correct data structure. Ensure smooth upgrades by avoiding potential problems before they occur.
  • Service Procedures*: Create user defined custom Service Procedures that can be called as Web Services (GP 2015 or later) or from Visual Studio or Dexterity.
  • Usability enhancements*: Exit After Processes menu option, Full width fields on the Company Login window and more.

* = New window or feature.

I have invested as massive amount of time into making GP Power Tools a reality. As the development effort is no longer subsidized by Microsoft, it is necessary to ask a token amount to cover the costs of future development.

For the amount of time GP Power Tools will save you, and for a dollar a day there is no reason not to upgrade.

Why not install the free Public Beta and see for yourself?

David

PS: More information on the new features coming soon.

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

View original post here:
#GPPT 21 Reasons why you should upgrade to GP Power Tools

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

Dynamics GP SQL Password – Something Interesting must test it !!!

Dynamics GP – SQL Password.
While working one of my colleague here I found something unusual in Dynamics GP2013 R2 and even GP2015 R2.

We have asked our IT department to create VM with SQL server. They have installed SQL server with ‘sa’ password ‘sql2k12@myowncompany’.

When we were trying to install GP. Utilities ran successfully with ‘sa’ user id and above password, we was able to create Production Company through Dynamics GP utilities but not able to login to Dynamics GP.

Spend almost 2 days to see why we are not able to Login GP. Asked IT team to reformatted server reinstalled SQL but again they given same ‘sql2k12@myowncompany’ password.  Again same story able to login GP Utility but not able to login GP. DYNSA user ID and password is working. Even we have checked all other security screen in Dynamics GP and log file was not showing any error.

Somehow I saw GP user login screen not taking password more than 15 character….!!! Whereas I can type password more than 15 characters in GP utility…!!! We got issue.

Now question is how come Dynamics GP Utility allow to enter password more than 15 character and GP Login screen user password restricted to 15 characters only.


Until Next Post!!!

Read the article:
Dynamics GP SQL Password – Something Interesting must test it !!!

July 13, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 60

Hands On With Microsoft Dynamics GP 2015 R2: Client … – azurecurve

You can prevent this sample company warning message from being displayed, which is quite useful if you use the sample company a lot (as I do for demos and testing of functionality). … Image Email azurecurve View Ian Grieve’s about.me View Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

Taken from:
Hands On With Microsoft Dynamics GP 2015 R2: Client … – azurecurve

July 13, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 56

#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: 57

What is the difference between Private Cloud, Public Cloud, and …

Subscribe. Enter your E-mail address in the box below and subscribe to our blog feed. Email Address … Search Dynamics GP Blog. ← How much does a Microsoft Dynamics GP implementation cost?

See the article here:
What is the difference between Private Cloud, Public Cloud, and …

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