SmartConnect Classroom Training Events for Fall 2013

Want to become an integration expert? We’re beginning a new round of SmartConnect Deep Dive classroom training events and would love to have you join us. Mark your calendars and join us at an event below:
September 17th – Fargo, ND*
October 15th & 16th– Chicago, IL
November 19th & 20th– Minneapolis, MN
December 10th & 11th– Phoenix, AZ
January (TBD) – Seattle, WA

*The event in Fargo is a one day, partner-only session, prior to Microsoft’s Technical Airlift. The class fee is ½ off due to the length of the event.

During the sessions, you will receive two full days of hands-on training from our experienced consultants, our latest product training manual, our training image and lunch each day. The cost is $1400/person, however if you send two people from your organization, the second person is ½ off. After you attend classroom training you can expect:

·         To become independent on SmartConnect.
·         To leverage SmartConnect in additional ways at your site or at other customer sites.
·         Provide more value for the customer’s overall solution.

Ready to sign up? Let us know right away so we can walk you through the next steps & reserve your spot in training! Email sales@eonesolutions.comtoday.

View original post here:
SmartConnect Classroom Training Events for Fall 2013

July 24, 2013 · Abbey · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 350

RDS Solution for Dynamics GP on Azure

Did you know as of July 1, 2013, Service Providers can offer hosted Microsoft Dynamics GP solutions through Remote Desktop Services (RDS) running on Windows Azure Virtual Machines? The service provider must obtain the RDS SALs (Subscriber Access Licenses) through a  Microsoft Services Provider License Agreement (SPLA). To read more about licensing RDS with Windows Azure Virtual Machines, see: and the Product Use Rights (PUR) document.

While the Microsoft Dynamics GP 2013 web client offers browser access to the application, there are a few peripheral components that require Remote Desktop Services (formerly known as Terminal Services) for access in a hosted solution. It is now possible to offer these Microsoft Dynamics GP components on Windows Azure Virtual Machines using session-based hosting through RDS. The Microsoft Dynamics GP 2013 on Windows Azure white paper contains guidance on the configuration of RDS on Windows Azure Virtual Machines. You can find the white paper on Partnersource at


On a side note – we’re interested in your Dynamics GP on Azure stories!  Do you have an interesting use for Azure in your Dynamics GP implementations?  Do you have a customer story that is unique or interesting?  Please let us know!  Please email me at and let me know your story!


Jay Manley

RDS Solution for Dynamics GP on Azure

July 24, 2013 · Jay Manley MSFT · No Comments
Tags: ,  · Posted in: Blogs I Follow Total Views: 391

Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 4

Part 4 – Tools for Troubleshooting Web Client issues: the Web Client Diagnostic tool

In Part 2 and Part 3 of this series, I talked about resolving Web Client implementation (installation if you will) and functional issues, respectively, along with some specific information that must be compiled to aid in the troubleshooting process.

No troubleshooting process would be complete should we not have the appropriate set of tools to aid in capturing some of this data. Let’s start with the one tool you are most likely to use when opening a support case with Microsoft: the Web Client Diagnostic tool – in reality, is more like a set of diagnostics than _a_ diagnostic in particular.

The Web Client Diagnostic tool can be accessed once you create a support case and after the creation of an MS Solve case (also known as a Microsoft Fix It center case). The tool must be executed on both web server(s) and session host(s). The tool will collect important data that will allow Microsoft Dynamics GP Support to resolve your case. If you do not receive an invitation to execute the Web Client Diagnostic tool, you are encouraged to ask the Support Engineer on your case to send said invitation.

Support Case submitted

As you become more and more familiar with Web Client support cases, the above message is quite important. If this is missed after creating the case, the support engineer taking your case has no way to provide the Fix It URL shown above back to you.

The support engineer taking your case will need to generate a new link for you to use and pull the diagnostic information.

The URL in the message is what you should copy off to either your email or another editor for safe keeping. Once that is done, you can access both web server(s) and session host(s) machine(s) and then paste the URL into the Web browser and following the guidance provided.

Automated Troubleshooting Services window

This is the default page that will be presented after pasting the URL into the browser once the Diagnostic Web site is launched. Once the Web page is opened, click on the “Run” and the diagnostic package will be downloaded to the local machine.

Run the Microsoft Automated Troubleshooting Services app

Once fully downloaded, you will then again be prompted to Run (or Don’t Run) the diagnostic. At the point is where the Diagnostic starts running through its wizard based UI.

Info Screen and Online Privacy Statement

Accept the terms and condition to actually allow Microsoft to gather Web Client specific data points.

Diagnostic Components download

Once accepted, all the diagnostic components are downloaded to the server you are running it on.

Select where to run the diagnostics

Once downloaded, select This Computer as your option and choose Next. The option of A different computer is currently not working as intended.

The package is executed

The Diagnostic tool will then create an multi-task execution package of all the steps to be completed for data collection.

Configuration and Setup information

Next the Diagnostic will begin its first data collection process, focused on Web Client configuration and setup data, once you select on the Start button.

Session Central and Session Host machine tasks

Once the installation and configuration data is collected, the Diagnostic tool will perform data collection on the Web Server (running Session Central Service) and Session Host machines. This screen allows you to click on a hyperlink to obtain further information on the information to be collected.

Session Central and Session Host data collection executing

Click Next to begin the data collection process on Session Central and Session Host.

Diagnostic Results

After gathering all of the information requested, the Diagnostic then packages the data up for submission to the Diagnostic web site. That submission will occur once you select the Next button.
The Diagnostic tool will compile a number of screenshots, a list of Internet Explorer add-ons, performance data, machine configuration data, certificates and port binding information, URL reservation, and much more. Some of this information is collected using command line programs which I will talk about in a future installment.

Send diagnostic data to Microsoft

You can then save a copy of the diagnostic data prior to submitting it to Microsoft. This data is packaged in a cabinet file (.cab) for ease of submission and compression. Click the Send button to initiate the submission of the cab file.

File sent

Once the file has been submitted, then the process is complete. The file is then attached to the original support request, via the Microsoft Service Request (SR) number created by the Fix It.

Tomorrow I will talk about Fiddler and how they can be used throughout the troubleshooting process.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Read the original:
Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 4

July 24, 2013 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 511

Support Debugging Tool – Finding Tables that make up Windows …

Search Dynamics GP Blog. Subscribe. Enter your E-mail address in the box below and subscribe to our blog feed. Subscribe in a reader · ← 7/30: Accounts Receivable Month-end Procedures in Dynamics GP · What Are The 

See original article:
Support Debugging Tool – Finding Tables that make up Windows …

July 23, 2013 · tidestone · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 242

Tech Tues: What the Newly Released Extender & SmartList Builder Templates Are All About

We recently released a new set of templates for Extender and SmartList Builder to use with Microsoft Dynamics GP 2013. I wanted to outline for you what they are and why I think they are a great resource for everyone to use.

Access Extender templates here.

 Access SmartList Builder templates here.

Extender Templates:

We have updated many of the templates that have been posted for Extender Enterprise and have also made some new ones for you to enjoy.  With these templates, we are hoping that you can take and use some of them right out of the box.  Others may need to be modified to fit your business needs or can serve as an example on how to start structuring something you are trying to build.  Some of the Enterprise templates have Dexterity Coding in them that can be used as sample code if you need for another resource you may be creating.

We aren’t done adding to the list, but here is what is posted today. Please note that not all of the templates will completely work on Standard.  When you download them, be sure you are downloading the appropriate file based on which release of Extender you are using.

With all of the Extender Templates, you will find the xml file to import the Extender Setup as well as a pdf file that outlines what each resource in the import does.  To import the xml file, log into Microsoft Dynamics GP 2013 as a user with access to Extender and go to Microsoft Dynamics GP – Tools – Extender – Import.  Then select the xml file to import and click Import.  You will then find a new solution in Extender for the template.

SmartList Builder Templates:

The SmartList Builder Templates are very similar to the ones that have been posted on the Microsoft site for several years, however we have updated them to 2013 and taken advantage of some of the new features that have come out in SmartList Builder since the old ones were built.

While the list is long, what you will find with these templates is that they all mimic one of the default SmartLists that comes with Microsoft Dynamics GP. The real purpose behind these templates is to allow you a starting point to “modify” the existing SmartLists to meet your needs.  We have all had a scenario where we wished the default SmartList had another column, did a calculation, etc.  With these SmartList Builder Templates, you get a starting point to add those additional items you wished the default SmartLists had.

Each SmartList Builder setup has its own xml file to import for that particular SmartList.  To import the xml file, log into Microsoft Dynamics GP 2013 as a user with access to SmartList Builder and go to Microsoft Dynamics GP – Tools – SmartList Builder – Import.  Then select the xml file to import and click Import.  You will then find a new SmartList in SmartList Builder to edit.

You may also be thinking to yourself, I wonder if they are going to do the same for Excel Report Builder and Navigation List Builder.  To answer your thoughts, YES, we are planning create imports for these two as well that mimic the default setups that come with Microsoft Dynamics GP 2013 for the Navigation Lists and Excel Reports.

Have you tried the new templates? Love ‘em or Leave ‘em? Let us know as we love your feedback!

Read More:
Tech Tues: What the Newly Released Extender & SmartList Builder Templates Are All About

July 23, 2013 · Nicole Albertson · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 282

Using Indicators to Visualize Data in SQL Server Reporting Services Reports

SQL Server Reporting Services 2008 R2 introduced many features in the area of graphical display of information. According to MSDN, there were three new features introduced in SQL Server 2008 R2—maps, sparklines and data bars and indicators. This final article of a three-part series on data visualization will explore the features of indicators as we build reports using Dynamics GP data.

Setting the Stage

Indicators are a way of providing immediate visual clues about the status of something. For example, while bar charts are a nice way to compare things to each other, sometimes you want to know the status of things right now so you can take immediate action. Are sales up or down right now? Is there an inventory shortage? By using indicators, you can provide those immediate clues to users that allow them to see the status and then look at the details.


According to Microsoft’s TechNet website, here are four benefits of indicators:

  • Trends by using trending-up, flat (no change) or trending-down arrows
  • State by using commonly recognized symbols, such as checkmarks and exclamation marks
  • Conditions by using commonly recognized shapes, such as traffic lights and signs
  • Ratings by using commonly recognized shapes and symbols that show progress, such as number of quadrants in a square and stars

In this example, let’s build a report that provides indicators based on how much of each item we are selling. The report is going to be grouped by customer class and item class.

First, once we launch Report Builder, we’ll create a data source.

Second, we create a dataset. Here is the query for the dataset.


Once the dataset is created, we will use the toolbar in Report Builder to insert a matrix.


The next step is to add a column where the indicator will be placed.

Click in the matrix and then highlight the Extended Price column. Right-click and choose “Insert Column,” then “Right.”

From the toolbar, click “Indicator.”


Click the new column in the Item Description row.

A window showing indicators appears. In our case, we’re selecting the five-star indicator in the Ratings group.


Once you have placed the indicator in the matrix, right-click on it and choose “Indicator Properties.”

Click on “Values and States.”

Enter the ranges that will determine which star will appear. You will see that there are various options for customizing the indicator on this window.


Enter the values and click “OK.”

Here’s how the report appears in Design mode.


Click the “Run” button to view the report.

Expand the report to view details by Item Description. Notice the varying amount of colors in the stars based on the sales value.


As you can see, the report indicates (Notice how I used the word?) the Cantata FaxPhone 9800 is doing well, whereas the Shoulder Rest – Deluxe White is not.


This article just scratches the surface of adding some visualizations using indicators to your SSRS reports. In just a few steps, you can add these visual elements to your reports. Feel free to experiment using Report Builder or Visual Studio.

For more information, please contact our Microsoft Dynamics GP Support Center.

View article:
Using Indicators to Visualize Data in SQL Server Reporting Services Reports

July 23, 2013 · Charles Allen · No Comments
Tags: , , , , ,  · Posted in: Blogs I Follow Total Views: 448

Microsoft Dynamics GP 2013 SP2 Announced for Q4

A few days ago, Errol Schoenfish on the Inside Microsoft Dynamics GP blog announced the forthcoming Microsoft Dynamics GP 2013 SP2 (or H2 as he named it) for Q4 of the 2013 calendar year. The part of the announcement which … Continue reading

Follow this link:
Microsoft Dynamics GP 2013 SP2 Announced for Q4

July 23, 2013 · Ian Grieve · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 365