Management Reporter 2012 Rollup 6 Available

A couple of days ago , the Dynamics PTS blog announced the release of Management Reporter 2012 Rollup 6. This rollup has a range of new features including: The ability to generate a single report link for a report group … Continue reading

Management Reporter 2012 Rollup 6 Available

August 7, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 304

VBA Compile Error – Expected: expression

I realise that the use of VBA in modifications and customisations is something that needs to be carefully considered with Microsoft Dynamics GP 2013 including a Silverlight based Web Client which cannot use VBA. I had a requirement from a … Continue reading

Excerpt from:
VBA Compile Error – Expected: expression

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

Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 7

Part 7 – Tools for Troubleshooting Web Client issues: Command Line Tools

Parts 5 and Part 6 of this series, both look at some nice GUI-based tools to analyze web and network traffic. The good thing about these tools is that they allow you to analyze things from the comfort of an application window.

However, one needs not to discard some powerful command line base tools that have been around since the early days of DOS – and that’s Disk Operating System, not DOS as in Dos Equis (XX). Today, I will talk about NETSH and NET


Netsh (Network Shell) is a command-line scripting utility that allows you to, either locally or remotely, display or modify the network configuration of a computer that is currently running. Netsh also provides a scripting feature that allows you to run a group of commands in batch mode against a specified computer. Netsh can also save a configuration script in a text file for archival purposes or to help you configure other servers.

With the Netsh.exe tool, you can direct the context commands you enter to the appropriate helper, and the helper then carries out the command. A helper is a Dynamic Link Library (.dll) file that extends the functionality of the Netsh.exe tool by providing configuration, monitoring, and support for one or more services, utilities, or protocols. The helper may also be used to extend other helpers.

You can use the Netsh.exe tool to perform the following tasks:

•  Configure interfaces.
•  Configure routing protocols.
•  Configure filters.
•  Configure routes.
•  Configure remote access behavior for Windows-based remote access routers that are running the Routing and Remote Access Server (RRAS) Service.
•  Display the configuration of a currently running router on any computer.
•  Use the scripting feature to run a collection of commands in batch mode against a specified router.

So, how does this all apply to the Web Client?

WCF services and clients can communicate over HTTP and HTTPS. The HTTP/HTTPS settings are configured by using Internet Information Services (IIS) or through the use of a command-line tool. When a WCF service is hosted under IIS, HTTP or HTTPS settings can be configured within IIS (using the inetmgr.exe tool). If a WCF service is self-hosted – like Session Service, for example – HTTP or HTTPS settings are configured by command-line entries.

At the minimum you will want to configure a URL registration, and add a Firewall exception for the URL your service will be using. Fortunately, this configuration is done for us by the InstallShield application when running the installation of the Web Client runtime services components.

In the Web Client world, we use NETSH to check for namespace reservations and look at how ports are configured in relation to SSL certificates issued.

To display discretionary access control lists (DACLs) for the specified reserved URL or all reserved URLs, proceed to type from the command-line:


To determine how ports are configured, type the following from the command-line:


If the Web Client installation process went well, the Certificate Hash assigned to each port used by Session Service (port 48650), Session Central Service (port 48651), and Runtime Service (port 48652) should match the thumbprint value of the certificate in IIS, as displayed by the show sslcert option.

Certificate hash on each listening port must match that of the certificate in IIS

Much more details can be found in my Windows 8 and Web Client installation series article, Windows 8 and the Microsoft Dynamics GP Web Client Series – Part 4.

For more information on configuring HTTP and HTTPS transports for WCF, take a look at the following MSDN library article:

For more information on how to configure a port with an SSL certificate, take a look at the following MSDN library article:


Netstat (network statistics) is a command-line tool that displays network connections (both incoming and outgoing), routing tables, and a number of network interface (network interface controller or software-defined network interface) and network protocol statistics. It is used for finding problems in the network and to determine the amount of traffic on the network as a performance measurement.

The specific entry we want to run from the command-line in a Web Client environment is as follows:


This will return a list of ports that are in use and the process and application using them. If you want to select a port of your own choosing when installing Web Client, you will want to verify that the post is available and it is allowed through the firewall as necessary.


For more information on netstat, take a look at the following TechNet article:

The Web Client Diagnostic tool, which I talked about in Part 4 of this series collects these two pieces of information (among other command-line tools ran) as part of the data collection procedures performed when opening a Web Client support case.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Read the article:
Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 7

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

Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 6

Part 6 – Tools for Troubleshooting Web Client issues: Other Tools

In Part 5 we looked at Fiddler, a proxy web debugger application and how it is able to break down HTTP and HTTPS traffic between a client app and a Web Server. Today, I will look at 2 tools that go down right to the wire – literally!


Wireshark is a free and open-source packet analyzer. It is used for network troubleshooting, analysis, software and communications protocol development, and education. Originally named Ethereal, in May 2006 the project was renamed Wireshark due to trademark issues.

Wireshark is cross-platform, using the GTK+ widget toolkit to implement its user interface, and using pcap to capture packets; it runs on various Unix-like operating systems including Linux, OS X, BSD, and Solaris, and on Microsoft Windows. There is also a terminal-based (non-GUI) version called TShark. Wireshark, and the other programs distributed with it such as TShark, are free software, released under the terms of the GNU General Public License.

Wireshark Network Analyzer

Wireshark is very similar to tcpdump, but has a graphical front-end, plus some integrated sorting and filtering options. Wireshark allows the user to put network interface controllers that support promiscuous mode into that mode, in order to see all traffic visible on that interface, not just traffic addressed to one of the interface’s configured addresses and broadcast/multicast traffic. However, when capturing with a packet analyzer in promiscuous mode on a port on a network switch, not all of the traffic travelling through the switch will necessarily be sent to the port on which the capture is being done, so capturing in promiscuous mode will not necessarily be sufficient to see all traffic on the network. Port mirroring or various network taps extend capture to any point on the network.

So why is Wireshark used with the Web Client? Since it analyzes TCP/IP traffic, you could potentially use it to understand if the proper ports are being used by the application when communicating with the Web Server(s) or the Session Host(s), especially when traffic has to traverse intranet, DMZs, and extranet zones on your network. You could potentially determine if there are any translation issues between external DNS addresses and internal network addresses.

ClearSight Analyzer from Fluke Networks

This product is advertised as Wireshark on steroids as it supports the Wireshark decode engine. In addition, it’s able to make sense of all TCP/IP traffic by implementing some powerful graphics showing how machines and devices interact with each other.

Network diagram


Conversation Chart

ClearSight also implements a powerful bounce chart for traffic on single or multi-segment networks. Now here’s the bummer: it’s not free! However, for a small fee you are able to obtain a fully featured product.

If you are more like me – a visual person – then ClearSight is certainly worth the price. If you are comfortable in your own skin looking at TCP/IP raw traffic, then Wireshark is the way to go. In any event, you have two powerful tools that can really breakdown your network traffic with ease, for you to analyze where things may be breaking down, preventing Web Client from functioning.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Visit link:
Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 6

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

Creating a Word Template for Dynamics GP

Creating a Word Template requires working with Microsoft Word and Dynamics GP Report Writer. This post will walk you through the required steps. It’s important to perform these steps in order. You also will be working with the Template Configuration and Template Maintenance in Dynamics GP.

You must have two applications installed before beginning this process:  Microsoft Dynamics GP Add-On for Word and Open XML SDK 2.0 for Microsoft Office. Open XML will be installed when you install Dynamics GP. The Dynamics GP Add-On for Word is located on the Dynamics CD.



To use Microsoft Word with Dynamics GP, you must add the “Developer” tab to your Word ribbon bar. Go to Options | Customize Ribbon and select “Popular Commands.” Add the Developer function to the Ribbon list and then check the box. Click “OK.”


Template Configuration-Reports | Template Configuration

The configuration window allows you to enable a specific form(s) to work as a template.

Expand the trees for Enable, Company and Series. Mark the document(s) for which you want to create a template. Be sure to mark the Enable Report Templates and, if desired, to allow use of the Standard form even though you’re using the template.


The next step is to create a modified GP report in Report Writer. You may want to modify the report with a definition field. You can place the definition field anywhere on the report, regardless of where you place it on the template. You will need to make note of the section where you have placed the field, such as the “Report Header” shown below. (I have added the Vendor ID.) Save and close the report. Go back into Dynamics.


Dynamics | Tools | Setup | System | Alternate Modified Forms & Reports

You must give access to the modified form for the series with which you are working.


Creating an XML File

The next required step is to create an XML file in order to create your template. You will need to go to the entry screen of the series you are working with and bring up a transaction to print. When you print the form, you will select the Standard form and print to a file. The file must be an XML file.

8833-7 8833-8

Click “OK.” Open the file to make sure it is an XML file.


Template Maintenance-Reports | Template Maintenance

Select the report name you will be working with. Be sure to select the modified report.


Once you have selected your modified report, you will be required to create the template you will be working with. Select “Modify.”


Selecting “Modify” will launch Microsoft Word. Click on the “Developer” tab on the ribbon bar. Click on the “Field List” tab on the ribbon bar.


Clicking “Field List” will open the “Source File” window to the left of the document. Select the XML resource. This will populate the report section list.


Once you bring up the source list, you will have to “Remove Source.” Once you click “Remove,” you will then click on “Add Source.” 8833-14

When you click “Add Source,” you will select the XML file you saved. Click “Open.”


This will take you back to Microsoft Word. Select the source file again. Select the Report Section in which you placed the field definition in Report Writer. Scroll down to the field definitions and select the field definition that you put on the modified report in Report Writer. In this example, select “PM_Vendor_MSTR”, “Vendor ID.”


Before you drag that field definition to the template, you will be required to insert a cell where you want to position that field. Click the area of the template and then right-click to insert a cell. In this example, I have inserted a cell in the “Header” section. You can now drag and drop the field definition into that cell.


Once you have made your modifications you will need to save the template as a Word document. It will want to save the file to the temp directory, but it is recommended to save it to a shared location on your server. In this example, I have saved it to my desktop.


Once the Word document is saved, you will return to the Template Maintenance screen.

In the Template Maintenance screen, you will need to add that new template. You may replace the existing template, rename it or create a new named file. Highlight the existing template and click the plus sign above it. This will launch Windows Explorer for you to select your saved Word template.


Select your new Word template, and then click “Open.”


You may get a “Replace” message if you gave the report the same name as the original. Click “Yes.”


You will be required to assign the template to a company or companies and vendor(s). Select “Customers” if you are working with sales templates. You must have at least one “Default” template.

Click “Assign.” This will open an alternate screen.


This is the Company screen. Select the company or companies that will be using this template. Click “Set Default” to select your template.


Click “Save.”


Click “Assign” again for your vendors. Click the plus symbol to open the “Add Vendors” window.


Select a vendor or a range of vendors. Click “OK.”8833-26

Mark the vendors you want to use the template or click “Mark All.” Save.


Close the Template Maintenance screen.

When you go back to the Series Transactions screen, select your document and print the template to the screen to verify your changes. Be sure to select “Template” as your report type.


You should see your template with the modifications you have made.


Note:  Although you may make cosmetic changes to your template in Word, if you add any field definition, you must make that change in Report Writer. Once you have made that change, you are required to create another XML file and start the process again.

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




See the article here:
Creating a Word Template for Dynamics GP

July 26, 2013 · Victoria Bell · No Comments
Tags: , , ,  · Posted in: Blogs I Follow Total Views: 906

Management Reporter – An Unknown Error Has Occurred

After dealing with an obscure and unhelpful Integration Manager error recently, I’ve also had a Management Reporter one; when trying to generate a report the following error was consistently produced; An unknown error has occurred while processing report As well … Continue reading

Continue Reading:
Management Reporter – An Unknown Error Has Occurred

July 26, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,223

Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 1

Part 1 – Microsoft Dynamics GP Support Team’s Posture

With the introduction of the Microsoft Dynamics GP 2013 Web Client, system administrators now face additional challenges when troubleshooting errors produced while accessing the Web Client all the way to using the Microsoft Dynamics GP application itself over the browser.

To understand the troubleshooting process, it’s best to explain the Microsoft Dynamics GP Support team’s posture when addressing a support case: any error event that occur before the Microsoft Dynamics GP login window is presented to the end-user will be treated as a Web Client implementation support issue.

Issues in this category involve everything from the deployment planning of the Web Client up to the point where you obtain the Microsoft Dynamics GP Login window. Items such as issues during the installation of the Web Client, network configuration, certificates, routers, firewall configuration, DNS resolution issues, issues preventing access to the web client Sign In window are all considered issues that prevent an end user from using the Web Client and therefore access Microsoft Dynamics GP.

Web Client Sign In window (Windows Authentication)

Any error event that occurs after the Microsoft Dynamics GP application Login window is presented, and during the normal use of Microsoft Dynamics GP is considered a functional support issue.

Microsoft Dynamics GP Login Window (SQL authentication)

Functional support issues involve everything from issues accessing Microsoft Dynamics GP all the way through using all the application functions within the Web Client: data entry, printing problems, posting issues, Report Writer reporting, SSRS reports, Excel reports, and all issues that may happen within the Microsoft Dynamics GP application while using the Web Client.

Having a clear cut definition between problems will allow you to reach the right support engineer at Microsoft. In addition, implementation issues may require the use of specialized diagnostic tools to collect information about the Web Client installation environment that will allow the support engineer or escalation engineer to better understand how your environment is configured.

In contrast, functional issues would typically follow the standard support protocols you have come to know over the years.

There are some clear benefits to this posturing:

1. A reported problem can be routed to the right support team the first time around. After all, an issue with a certificate may require someone technical from within the support team to address the problem, as opposed to a problem printing a report.

2. Having the right team addressing the issue will allow Support to issue whitepapers, videos, or even training content on how to address the most frequent issues that come to them.

3. Diagnostic information can be served up to the right support engineer at the time a case is created. This is only possible if a problem is tagged as an implementation issue versus a functional issue.

4. It allows both technical and functional support teams at Microsoft to keep stats on product quality, which may result in targeted hotfix or service packs.

Tomorrow I will address the steps involved in resolving an implementation problem and how you can take advantage of some of the latest tools available from Microsoft to assist in the process.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Read the article:
Troubleshooting the Microsoft Dynamics GP 2013 Web Client – Part 1

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