Monday, March 28, 2016

Microsoft Dynamics GP 2016 Feauture of the Day Series - Week 1

A busy schedule or perhaps constant movement from one client site to another may have prevented a lot of you from noticing the release of the new Microsoft Dynamics GP 2016 Feature of the Day series.

As customary, my good friend Pam Misialek (twitter: @PamMisialek) has began publishing insights into the soon to be released Microsoft Dynamics GP 2016. Here is a summary of the articles published last week:

Wednesday, March 23, 2016

Microsoft Dynamics GP 2016 Feature of the Day: Web Client

Friday, March 25, 2016

Friday, March 25, 2016

Friday, March 25, 2016

Please stay tune for my summary articles compiling all these features in one place. I will be expanding on some of them soon.

Until next post!

Mariano Gomez, MVP

Monday, March 21, 2016

A .NET Framework error occurred during the execution of user-defined routine or aggregate "GetAssignedUsers"

So, I found myself helping a client to troubleshoot a workflow issue. After configuring workflow a few weeks aback and running a few tests without any issues, we applied Microsoft Dynamics GP 2015 R2 January 2016 Hotfix.

Now, when the client went to execute the workflow, he received the corresponding email indicating there was a purchase order to approve. He then proceeded to click the Approve hyperlink and the process continued as expected.

After clicking the Approve button, the client receive the following error message:

The server encountered an error processing the request. See server logs for more details

The following shows the error as displayed on the client's screen.

At this point, it is worth stating that the workflow ran to completion and the PO appeared completely approved and fine in Dynamics GP, so whatever was causing this error did not seem to interrupt the approval flow.

As good troubleshooters, we went to the Event Viewer to check for additional information as suggested by the Request Error window, and came across the following error message in the log:

A .NET Framework error occurred during the execution of user-defined routine or aggregate "GetAssignedUsers

The complete error is displayed below:

As suggested by many solutions Dynamics GP forum solutions, we executed the following T-SQL statement against the system database:

EXEC wfDeployClrAssemblies;

Fellow MVP Mohammad R. Daoud explains in great detail what this stored procedure does and the CLR assemblies dependency, through an upgrade error he experienced here.

However, redeploying Workflow CLR assemblies did not solve our problem, even after restarting Microsoft Dynamics GP. 

In reviewing the workflow setup under the Workflow Maintenance window in Microsoft Dynamics GP we realized that the workflow had no managers assigned to it:

The client clearly remembers setting up managers before we applied the January 2016 Hotfix to their system -- at this point, we have reasons to believe this is a bug in the Hotfix update. After adding a few managers to the list, the client retried the workflow and all was good, without no errors.

In summary, if you run into this error, check to see if you have managers in the list. If you don't add them. If you do, then run the wfDeployClrAssemblies stored proc against the system database. These steps should solve most of the problems related to this issue.

Until next post!

Mariano Gomez, MVP

Thursday, March 10, 2016

Microsoft Dynamics GP 2016 general availability announced

Hi all, in anticipation to my Microsoft Dynamics GP 2016 HTML 5 web client series, news come from Pam Misialek, with the GP Product Marketing team that GP 2016 will be generally available to the public on May 1, 2016. Pam lists a host of new features, summarized as follow:

  • HTML 5 web client which will allow the we product to work natively on cross-platform environments (Android, iOS or Chrome, Safari, etc).
  • oData services and connections for Power BI 
  • New All-in-One document viewers
And much, much more. As it's been the tradition around each release cadence, please wait for the Feature of the Week Series featured on the Inside Microsoft Dynamics GP team blog.

Now, if you really want to see this stuff up close and personal, come to the Amplify conference in Anaheim, California, to be held from May 23 to May 25, 2016 (see #GPUGAmplify: Amplify your Knowledge with Microsoft and GPUG)

Until next post!

Mariano Gomez, MVP

Thursday, March 3, 2016

#GPUGAmplify: Amplify your Knowledge with Microsoft and GPUG

Anaheim, California: home of the very famous Disneyland entertainment complex, the celebrated ice hockey team, Anaheim Ducks, and why not, some colorful protesting melees as of late. However, this awesome American city in the Southern California enclave will be the host of the newly minted GPUG Amplify (Twitter: #GPUGAmplify) event, a joint venture between Microsoft and the Dynamics GP User Group.

What is GPUG Amplify?

Well, let's start by saying what it is not. #GPUGAmplify is not Convergence and it is not a replacement for the new Microsoft Envision conference. Amplify stands on its own as a new conference that seeks to provide insider information to the Microsoft Dynamics GP community product roadmap, upcoming features and overall vision. In that sense, it seeks to achieve the same goals and fill the gap left by Convergence. In addition, Amplify will deliver some very high quality sessions oriented to new functionality and features that will be available in upcoming releases of Microsoft Dynamics GP. In that sense, it differs from GPUG Summit in that the number of sessions will be far less, but highly specific.

When is GPUG Amplify?

Amplify will be held in Anaheim, California from May 23 - May 25, 2016. Side note: if you time this well, you can book your Memorial Day week in beautiful Southen California. Registrations are currently open with an early bird special ending all the way up to March 25, 2016.

Where to Stay and how to get there?

For the conference, GPUG has partnered with the Marriott Anaheim offering a group rate of $169/night + tax. GPUG has also partnered with Delta Airlines offering a promotional code for those seeking to get a discount given the rushed schedule.

As always, I may be presenting at this event (yet to be defined) and hope to see you there. Don't let the schedule scare you away from enjoying what may be "The Next Big Thing" to grace the Microsoft Dynamics GP world after Convergence.

Until next post!

Mariano Gomez, MVP

Where in the world is Mariano?

Hello folks!

I'm back! Well, it's been a few months of drastic changes in my professional career and the truth is I've been immersed in it all, absorbing as much as I can, and really learning some cool new stuff. Who would have "thonk"?

Now that I'm back in the blogging saddle, I will be talking about upcoming events, the cool new features in the upcoming Microsoft Dynamics GP 2016, as always, I will be bringing back those very cool tips and tricks that make your day go by easily, and of course, looking into those obscure errors and troubleshooting techniques used to resolve them.

I also want to thank all of you who have always graced the comments section of this blog and want to let you know that I will be getting back -- slowly but surely -- to you. This blog would never be what it is without your readership.

Until next post!

Mariano Gomez, MVP