Page 1 of 83712345678910...2025303540...Last »

Archive for the ‘Blogs I Follow’ Category

#GPPT GP Power Tools Build 20 hotfix 2 released

David Meego - Click for blog homepageIf you come across the problem below, please download the GP Power Tools Build 20 hotfix 2 which is now available from the Mekorma website.

When using the Configuration Export/Import window to import a configuration settings file created with the Support Debugging Tool into GP Power Tools, it will say that there is nothing to import.

This issue was caused by the changes to make GP Power Tools work with SQL tables rather than with temporary tables written to a Debugger.xml file. It happened because the table names written into the configurations settings file was incorrectly changed so that they had a _TEMP suffix.

This hotfix now uses the correct table names when exporting and can read both sets of table names when importing, so it will be able to handle both the correct and incorrect formats.

If you already have GP Power Tools installed, please download this latest hotfix build and install it over the top of your existing instance.

This build can be identified by the Last Modified: 03-Sep-2015 date on the About GP Power Tools window. The installer versions (shown in file properties and under Control Panel >> Programs and Features once installed) are 11.00.0020.5, 12.00.0020.5 and 14.00.0020.5.

Version History

Below is a summary of the changes made for releases 11.00.0020, 12.00.0020 and 14.00.0020 hotfix 2 (Last Modified: 03-Sep-2015):

  • Fixed issue with incorrect table names for Configuration Export/Import causing imports to fail.

Downloads

The download links are on the bottom of Mekorma’s GP Power Tools page.

Note: You might be warned when downloading the installer that the file “is not commonly downloaded”. This is because the security certificate for Winthrop Development Consultants is still new and will take a little time to propagate through the internet. If this happens, you might need to unblock the file using Right-Click >> Properties >> Unblock.

GP Power Tools for Microsoft Dynamics GP – User Guide Manual Documentation

Note: The manual is included with the installer, but is also available as a separate download.

Support Information

Support for GP Power Tools is provided by Winthrop Development Consultants’ distribution and support partner, Mekorma.

Support cases can be logged using the link below:

Support hours are 6:00am to 5:00pm (US Pacific Time), Monday to Friday.

Pricing Information

For customers, the special introductory price for an annual subscription is US$365 per year. That’s Peace of Mind for a dollar a day, and every four years you will get an extra day for free. :)

Please place your orders via Mekorma’s Order Now page:

Partners can request Not for Resale (NFR) registration keys. Please email sales@Mekorma.com with the following details:

  • Contact Name
  • Company Name
  • Company Address
  • Phone Number
  • Your Microsoft Account Number

More Information

For more information, please see the GP Power Tools Portal Page:

You can also look at the GP Power Tools pages on the Winthrop Development Consultants and Mekorma sites:

 

Please post your feedback as comments on this article or using the GP Power Tools Feedback Survey on what you think of this build and what you would like to see in the future.

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

Continued here:
#GPPT GP Power Tools Build 20 hotfix 2 released

September 4, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 7

Friday Funny: What’s wrong with this mathematical proof?

David Meego - Click for blog homepageToday’s Friday Funny is something to see if you can remember your high school algebra.

The following mathematical proof suggests that 2 = 1, which would definitely cause some issues with the accounting type people out there.

So the question is:

“What’s wrong with this mathematical proof?”

Here is the proof that 2 = 1:

  1. Let a and b be equal non-zero quantities
    a = b
  2. Multiply both sides by a
    a2 = ab
  3. Subtract b2 from both sides
    a2 – b2 = ab – b2
  4. Factor both sides
    (a – b)(a + b) = b(a – b)
  5. Divide out (ab)
    a + b = b
  6. Observing that a = b
    b + b = b
  7. Combine like terms on the left
    2b = b
  8. Divide by b
    2 = 1      QED

If you can explain what is wrong here, then you might help explain why:

  • odd <> even
  • black <> white
  • night <> day

Post your explanations in the comments.

Enjoy

David

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

Filed under: Fun Tagged: Friday Funny, Fun

Originally posted here:
Friday Funny: What’s wrong with this mathematical proof?

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

Dexterity Training in Mexico City, Mexico (28th September to 2nd October 2015)

David Meego - Click for blog homepageLast week, I posted details of my Upcoming US Trip for reIMAGINE and GPUG Summit.

In that article I mentioned that I would be running a Dexterity Training session in Mexico City, Mexico during the time in between the reIMAGINE 2015 conference and the GPUG Summit 2015 conference.

Below are the details for the training as there is still some room for additional attendees.

Dexterity Splash

The training is running from Monday 28th September to Friday 2nd October 2015, from 8:30am to 5:30pm.

It is being held at the Axentit office, which is located at:

353 Durango Street,
México City,
Delegación Cuauhtémoc.

It is near from Chapultepec subway station.

If you are interested in attending, please contact Mariano Arias at marias@axentit.com.mx, or by phone at +52 55 52118871.

Looking forward to a great week.

David

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

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

Read more here:
Dexterity Training in Mexico City, Mexico (28th September to 2nd October 2015)

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

You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

In my previous post, I talked about a cryptographic exception I encountered while upgrading Management Reporter 2012 from CU6 to CU9 (on the way to CU13), while attempting to setup the Data Mart database – see You receive “Could’n retrieve the list of available databases: The connection attempt failed” error when updating Management Reporter 2012. The solution turned out to be very simple, but in the scheme of things a bit time consuming to figure out. Once we had upgraded to CU9, it was time to attempt the upgrade to CU13.

The upgrade process

Upgrading to CU13 was pretty straight forward.  However, after the upgrade, the customer attempted to generate a couple of the many reports from Report Designer with the following error being displayed in Web Viewer:

This report can’t be displayed. Make sure that your computer has an internet connection and that Management Reporter is running. If this problem continues, contact your administrator.

Image
Management Reporter 2012 CU13 error when generating report to Web Viewer

When attempting to open the same report from Report Viewer, we obtained the following exception error, with the Report Viewer application crashing after clicking the OK button:

Exception has been thrown by the target of an invocation.

Image

After the errors, we tried copying the columns, row definitions, and trees onto completely new report objects (rows, columns, and trees), respectively, and tried to run the reports once more, obtaining the same results. The customer relies on this report on a daily basis, so it was critical we fix whatever issue was causing these reports to crash.

After some back and forth with Microsoft Support, it was determined that with CU13 the B0 print control in the row is not working and causing the exception:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.

Microsoft Support is currently working on getting the issue written up and triaged so as soon as a bug number (or a fix!) is available I will publish more about it.

As it stands, we reverted back to CU9 and upgraded to CU12 which did not display the issue described herein.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

View the original here:
You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

September 1, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 13

How to dynamically modify Extender windows

David Meego - Click for blog homepageThis blog article has been prompted by the thread below on the Microsoft Dynamics GP community forum:

I had responded with some information on the thread, but when I tried to implement the suggestions I made, I found that it was not actually possible and that other methods would be needed.

The Extender product is a very clever tool created by my friend Andrew Brown from eOne Solutions, it allows Microsoft Dynamics GP windows to be “extended” with additional custom fields. These fields are entered using additional Extender windows and are stored in a series of tables in SQL Server. Each custom field is stored as a single record in one of a series of SQL tables depending on its datatype. The idea behind the product is to allow customisation of Dynamics GP without needing any coding. That said, the Extender Enterprise product does allow you to add custom logic with scripts.

While Extender itself is very flexible, it can be difficult to customise, or modify the windows. The methods that you would use for a standard window will not work.

The Problem

The issue is that Extender windows as they are seen by the user don’t really exist. The Extender windows that the user sees are dynamically created using a series of hidden template windows. For each type of Extender window or form, there are 10 template windows. The reason for the multiple windows is so that you can open more than one Extender window of each type at a time, Extender just uses the next available window. This is similar to how Dynamics GP has five Note windows which are dynamically used.

Each of these windows has one field of each datatype for each line on the window. When the window is opened by Extender, it reads the setup definition then hides and shows the fields as required to display the correct window. It populates the read-only string fields to display the prompts and also renames the window title. Finally, it resizes the window to remove the extra white space.

Disclaimer: There may be other steps and the order might differ. I don’t have the source code, so this is just my understanding…. but you get the idea. :-)

So, how can I modify a window that is dynamically created from one of the template windows? For our example, I want to disable the delete button on an Extender window, but only when that window is being used as a specified Extender window (based on the Window Extender ID).

Below are some of the usual tools which can be used and details of their limitations:

Customisation Tool Issues Notes
Modifier As the Extender windows are hidden from the Security subsystem, it is not possible to tell Dynamics GP to open a modified version of the window instead of the original. Even if it could work, you would need to modify all 10 windows of the same type and any change would affect all Extender windows of the same type as there is no scripting.
Field Level Security As the Extender windows are hidden from the Security subsystem, they cannot be selected from the Field Level Security Resource Explorer. Even if you could select the window, you would need to modify all 10 windows of the same type and any change would affect all Extender windows of the same type as there is no scripting.
Rockton Software’s Conditional Field Level Security As the Extender windows are hidden from the Security subsystem, they cannot be selected from the Field Level Security Resource Explorer. Even if you could select the window, you would need to modify all 10 windows of the same type. With the conditional scripting it would be possible to check which Extender ID and make the customisation dynamic, but Field Level Security prevents us even selecting the window.
Visual Basic for Applications It would be possible to use VBA scripting to read the Extender ID and create a dynamic customisation. This customisation would have to be repeated for each of the 10 windows and then be deployed to every workstation in your system.

 

The Simpler Solution

Just use GP Power Tools.

Using the Resource Information window in Form mode with the show currently selected window option enabled, I clicked on the Delete Button on the example Extender window that I created. It identified the field as ‘Delete Button’ of window ‘User Defined Window’ of form PT_UD_Window_1.

Using the Runtime Execute window, I used the Names button to lookup other fields on the PT_UD_Window_1. To display the form on the GP Power Tools Resource Explorer, I ticked the Hidden Forms checkbox. I located the ‘PT Window ID’ field which holds the Extender Window ID.

warning 'PT Window ID' of window 'User Defined Window' of form 'PT_UD_Window_1';

The above code was executed in the context of the Extender Dictionary and confirmed that the field contained the value I was expecting for the open Extender window.

Using the Automatic Debugger Mode Setup window, I created an Automatic Starting, Non-Logging Trigger on the Window Activate Focus event of the window ‘User Defined Window’ of form PT_UD_Window_1 with the following script:

out boolean OUT_Condition;

OUT_Condition = false;

if isopen(form PT_UD_Window_1) then
	case 'PT Window ID' of window 'User Defined Window' of form 'PT_UD_Window_1'
		in ["TEST ITEM 2"]
			disable 'Delete Button' of window 'User Defined Window' of form 'PT_UD_Window_1';
			OUT_Condition = true;
		else
	end case;
end if;

Where “TEST ITEM 2” in the case statement is the Extender Window ID for the window on which I want to disable the Delete Button. If desired, more windows can be added into a list separated by a comma.

Extender Window Delete Example

Using the Window Activate (window gains focus) event is a little lazy but it avoids having to identify the actual script after which our code should run.

Extender Window Delete Example 2

The final step, is to duplicate (using the Duplicate Button) and modify the Triggers for the other 9 windows. It is easiest to copy the script into a Notepad.exe window before modifying the form name on the Resource tab, so it can be pasted back.

Deployment of the customisation is simple… it is already done. The triggers will automatically start working on all workstation on which GP Power Tools is installed.  No need to do anything more.

The example GP Power Tools settings file for the 10 windows can be downloaded from here.

Hope you find this helpful.

David

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

Filed under: Development, Dynamics, GP, GP Power Tools, Microsoft, Modifier, Products Tagged: Application, Extender, GP Power Tools, GPPT, Modifier

Read More:
How to dynamically modify Extender windows

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

Changing the Microsoft Edge home page on Windows 10

David Meego - Click for blog homepageHere is a quick bit of help for those of you new to Windows 10 and the Microsoft Edge browser.

I have already had to help a few people through these steps, so I thought I would post them online for others to see and use.

Most people know how to change the home page(s) in Internet Explorer, but the process for Microsoft Edge is different and has a few steps.

If you want to change the home page for Microsoft Edge, follow the steps below:

  1. Click … in the top right of the Microsoft Edge window.
  2. Click Settings

Once settings is open:

  1. Select Open with A specific page or pages
  2. On drop down list select Custom
  3. Enter the web address you want
  4. Click + sign to add the address
  5. Click X to remove about:start

See the screenshot below for the steps in visual form:

Edge_HomePage

You can repeat steps 3 and 4 if you want more than one home page.

That’s all folks….

David

PS: If you want to import your favourites, click on the 3 lines button and click on the star for favourites. Then click on Import favourites. Once imported, you can drag the folders back up to the top if that is what you prefer.

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

Filed under: Microsoft, Public Service Announcement, Windows Tagged: Microsoft Edge, Windows, Windows 10

More here:
Changing the Microsoft Edge home page on Windows 10

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

Get involved: Enter the GPUG Summit “AppOFF” Competition

David Meego - Click for blog homepageWith the release of Microsoft Dynamics GP 2015, developers were provided with additional Service Based Architecture (SBA) functionality built into the application and development environment.

Service Based Architecture is primarily comprised of two features: Service Enabled Procedures and the .Net Interop.

These two features blur the line of distinction between Dexterity and the .Net development world. Previously tools like Continuum and Visual Studio Tools allowed external developers to interface with Dexterity based applications, but Dexterity itself was unaware of these tools and their integrations.

With Service Based Architecture, Dexterity is now able to get in on the party. It can create code in the form of Service Enabled Procedures which are exposed to the outside world as REST based web services. It can also now use .Net objects, methods, properties and datatypes directly in Dexterity’s sanScript language.

GPUGSummit_Logo

To promote the use of this technology, at the upcoming GPUG Summit confence in Reno, Nevada, USA on the 13-16 October 2015, the Dynamics GP User Group (GPUG) will be hosting an “AppOFF” competition.

The competition is inviting GPUG members to design and create a Dynamics GP related App which can either leverage the default web services included with Microsoft Dynamics GP 2015 or use custom developed Dexterity service enabled procedures to provide additional web services.

The aim is to edcuate members on the tools that can be used to create Apps and so providing some GP related Apps for the community to use, while having some fun with a contest between members.

If you saw the development tools session that Mariano and I presented at Convergence, we showed you can use the Project Siena tool in conjunction with standard GP web services to create functional App in only a few minutes.

For more information on the objectives and guidelines, see Kim Peterson’s blog post

Get involved, enter now.

David

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

Filed under: Conference, Development, GPUG, News Tagged: Conference, GPUG, GPUG Summit 2015, News

Read the article:
Get involved: Enter the GPUG Summit “AppOFF” Competition

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