Page 1 of 21312345678910...2025303540...Last »

#GPPT What’s New: Administrator Password vs System Password

David Meego - Click for blog homepageThe Administrator level (Advanced Mode) features of GP Power Tools require application level security, SQL Server sysadmin or dbo status and the System Password (if one is configured) to access them.

So what happens if you want a user to be able access a feature and can provide the security required at the application level and SQL Server level, but you don’t really want to provide them with the Microsoft Dynamics GP System password?

There is a solution. GP Power Tools now allows you to setup a separate Administrator Password instead of the System Password. Use the new Administrator Password Setup window to configure how you want the system to behave.

Administrator Password Setup

Once activated, the system will ask for the GP Power Tools Administrator Password (if one is configured) instead of the System Password. You also have the option to activate the feature, but not enter an Administrator password. This will disable the password request for GP Power Tools Advanced Mode windows while still leaving the System Password active on Dynamics GP system windows.

The second option on the window allows you configure GP Power Tools to not ask users for the Administrator Password when they have access to the Administrator Password Setup window. This is controlled using the GP POWER TOOLS PASSWORD Security Role. The idea here is to make life easier for the system administrator by not challenging them to enter a password every time they want to open an Advanced Mode window.

You can easily identify which password is being requested as the prompts are different on the dialog windows:

System Password         Administrator Password

Now you can choose how you want to secure the administrator level features of 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

Visit site:
#GPPT What’s New: Administrator Password vs System Password

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

#GPPT What’s New: Security Activity Tracking and Security Log

David Meego - Click for blog homepageAs GP Power Tools approaches release, it is time to continue the What’s New series and explain another of the new features added to the product.

You can now enable Security Activity Tracking to collect statistical data on the usage of the various resources and security objects within the system.

This tracking can provide accurate data on which users use particular areas of the Microsoft Dynamics GP application and can be used to assist with the creation of Security Tasks and Security Roles when designing your security model.

The feature is enabled from the Administrator Settings window. Once enabled GP Power Tools will track every call to the application level security system and log whether access was granted or denied.

Administrator Settings 1

The information collected is kept on a user & company, user, company and system basis, so you can analyse the data from whichever angle you wish.

The new Security Log window is used to review the captured activity information. You can view the information for any user and/or company you select. The data can be initially sorted by resource or one of the 3 count columns (Total, Granted or Denied), however once the data is displayed you can click on the column headers to change the sorting as desired.

Security Log 

You can select any row in the data and right click or use the Security button to drill down to the Security Information window. You can right click or use the Open button to open a window or report if you want to see which window or report it is. You can also double click to open the Resource Information to that object or resource.

Finally you can use the checkboxes to select individual resources and/or security objects, then use the Security button to create Security Tasks and Security Roles from the selected items.

Security Log Create Task

You can now build your security model based on actual historical usage data from your own system.

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, Security, What’s New

View the original here:
#GPPT What’s New: Security Activity Tracking and Security Log

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

Microsoft Windows 10 is now here

David Meego - Click for blog homepageFollowing on from yesterday’s post: Microsoft Windows 10 is almost here.

Windows 10 is now here and starting to install on PCs that reserved their free upgrade from Windows 7 or Windows 8.1.

My eldest son has already upgraded his Surface Pro 2 and is trying out Cortana, the Edge browser and the Xbox One integration.

Cortana

He has already tried streaming the video from the Xbox One to his screen. So now he can play Xbox games from his room while he is meant to be studying…. Great. :(

If you want to download the ISO images for Windows 10, check out the official Microsoft site below:

Remember you must upgrade first before you can do a clean install, as mentioned in yesterday’s post.

Enjoy

David

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

Filed under: Microsoft, News, Public Service Announcement, Windows Tagged: General, News, Windows, Windows 10

View the original here:
Microsoft Windows 10 is now here

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

Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites

Few days before I was having client requirement to unassigned around 50K + items from specific sites. There were several help available on web one of is from MVP Mohood (http://mahmoudsaadi.blogspot.com/2013/11/delete-item-site-assignment.html) . I followed his sql query to delete all those items from sites.

But recently I found new feature in Dynamics GP 2013. From Navigation–>Click on Inventory –> Click Items. You have option to add filters base on your requirements.  Check mark items you want to unassigned from sites.  Click on Unassigned Site icon. Select Site and click Unassigned.























You have option to to add site with same screen.

Thanks much
Sandip Jadhav

Continue Reading:
Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites

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

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

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

#GPPT Welcome to the GP Power Tools Public Beta

Vaidhyanathan Mohan:

#MSDYNGP #GPPT David has released GP Power Tools public beta. Fun time ahead.

Originally posted on David Musgrave’s Winthrop Development Consultants Blog:

David Meego - Click for blog homepageToday, I am announcing a free public beta of GP Power Tools for Microsoft Dynamics GP versions 11.0 (GP 2010), 12.0 (GP 2013) and 14.0 (GP 2015).

As you know, I have been working extremely hard on getting GP Power Tools for Microsoft Dynamics GP ready for release and now it is time to get some feedback.

GP Power Tools is the next generation replacement for the Support Debugging Tool.

Read on for more details …

View original 294 more words

Filed under: Uncategorized

View article:
#GPPT Welcome to the GP Power Tools Public Beta

July 7, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 32