About Tudor Coleman

This author has not yet filled in any details.
So far Tudor Coleman has created 54 blog entries.

eConnect Integration Service Will Not Start

The installation of eConnect seems to complete correctly but eConnect Integration Service Will Not Start .   To fix this, I checked the error logs and found this in the Administrative Events: Action: Service Startup and Construction of Service Host Current User Name: Input parameters: Exception type: System.ServiceModel.AddressAccessDeniedException Exception message: HTTP could not register URL http://+:80/Microsoft/Dynamics/GP/eConnect/mex/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details). A quick web search found Adam Liposky’s GPUG blog entry, https://www.gpug.com/blogs/adam-liposky/2014/04/28/econnect-service-starts-and-then-stops. He had three steps, only one of which is necessary. The other two are unwise (sorry Adam). Step 3: “I opened the "Microsoft.Dynamics.GP.eConnect.Service.exe.config" file in notepad, which should be located in the following directory: C:\Program Files\Microsoft Dynamics\eConnect 12.0\Service At the bottom of the file, locate the following setting: <serviceMetadata httpGetEnabled="true" httpGetUrl=" http://localhost/Microsoft/Dynamics/GP/eConnect/mex "/> Change the value for "httpGetEnabled" from "true" to "false". Save and close the file, then try starting the [...]

By | 2018-12-05T16:45:25+00:00 November 16th, 2018|Dynamics GP, Support|

Printing to PDF on Windows 10 and 2016

Have you tried printing to PDF on Windows 10 and 2016 yet? No? Well, you are going to love this. In previous versions of Windows, Microsoft tried to push a file format called XPS. It never quite took off as PDF remained the file format of choice. Printing to PDF was never straight forward and always required the installation of additional software. The good news is that with the newest versions of Windows, Windows 10 and Windows Server 2016, Microsoft has given up on the XPS format and embraced PDF by including native print to PDF functionality! Printing to PDF has never been as simple as it is now. The new, built-in Print to PDF feature will be selectable in your printer list from any application from which you need to print. Simply select the printer Microsoft Print to PDF, click the big print button, select your destination, name the [...]

By | 2018-10-26T16:39:36+00:00 September 21st, 2018|Dynamics GP, Support|

SmartList Favorite Doesn't Return Data

One of my associates, Karen Henkelman, and I found an interesting issue in the GP web client. We had a PowerGP Online Partner open a case complaining that a just created SmartList Favorite wouldn’t return data. We tested it on a Desktop client (PowerGP Online is SAAS, web client only GP solution) and it worked fine. The name contained an apostrophe; “Audit List JL’S”. We removed the apostrophe and problem solved.

By | 2018-07-18T11:23:44+00:00 February 14th, 2018|Dynamics GP|

ADFS 3.0 Remove expiring Token-Signing and Token-Decrypting Certificates

Thank you to Martin Buist @ http://www.martinbuist.com/windows-server-2012r2/how-to-change-token-cer... Once a year a new token certificate needs to be extended in ADFS. If you have autocertificate enrolment on then this wil happen automaticly. However you need to inform the Relying party trust of the new token certificate if they do not use you adfs xml. Most partys do not use this. How does it work. By default the adfs server creates a new certificate 20 days before the primary token certificate expires. 5 days before expiring date the new certificate will be made primary. In this time frame you need to inform your relying party trust and give them the new ADFS certificate. Lets face it. This is not enough time for most partys in my experience. So we need to extend this. Most of us do not want to do this every year. So let’s make this certificate 10 years. Log [...]

By | 2018-07-18T11:23:44+00:00 February 7th, 2017|Dynamics CRM|

Common RDP Problems

If your entire workflow happens on a remote desktop, having problems with missing features or even not being able to connect to the RDP server can bring that workflow to a screeching halt. Here are a couple common problems and suggestions on how to resolve them.Logon Attempt Failed: If you are unable to connect and the RDP window says “logon attempt failed” at the bottom, it is because the username or password used are incorrect. This occurs more often when the RDP file has credentials saved and the password has recently changed. If the credentials are saved, you can simply right click and edit the RDP link file and then delete the stored credentials. It will then ask you to enter new credentials when you try to connect again.                Printer Issues: Another common problem with RDP connections is the printers from your local computer not appearing on the remote desktop session [...]

By | 2018-07-18T19:24:07+00:00 May 17th, 2016|Cloud|

After GP Company database restore: The selected company is not configured as a company of the current Microsoft Dynamics GP syst

After restoring a GP Company Database from another SQL server you may get the following error when trying to log into the restored company: "The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company" The following SQL scripts may resolve the issue. select CompanyDbId = c.CMPANYID ,DynamicsDbId = d.CMPANYID ,DynamicsDbName = d.INTERID ,DynamicsCompanyName = d.CMPNYNAM from sy00100 c left join dynamics..sy01500 d on d.interid = db_name() --update SY00100 set CMPANYID = (select CMPANYID from DYNAMICS..sy01500 where INTERID = db_name())

By | 2018-07-18T11:23:45+00:00 July 16th, 2015|Dynamics GP|

HTML code displayed on the bottom of a navigation list pane instead of returning actual results. GP 2013 and GP 2015.

This has been an issue that Njevity has been struggling with on new GP 2013 and GP 2015 installs. The confusing part has been that it will occasionally go away. With a lot of help from Daryl Anderson at Microsoft we finally found a work around. First of all, the issue goes away as soon as an application is installed that drops a DLL file in the AddIn folder of the GP program files. For cases where there are no DLL files in the AddIns folder simply copy the Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll file from the root of the GP installation (example: c:Program Files (x86)Microsoft DynamicsGP2013) to the AddIns sub-folder.

By | 2018-07-18T11:23:45+00:00 May 22nd, 2015|Dynamics GP|

Give users access to SSRS Report Builder

To create role assignments that grant access to Report Builder Start Report Manager. Click Site Settings. Click Security. If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit. Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: . If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment. Select System User, and then click OK. Click Home. Click the Properties tab. Click the Security tab. If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit. Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: . If you are using forms [...]

By | 2018-07-18T11:23:45+00:00 May 20th, 2015|Dynamics GP|

Dynamics GP Excel Drillback. A connection Microsoft Dynamics GP could not be established. Be sure you are logged on to the appr

According to the following link : http://support.microsoft.com/en-us/kb/2966672 If you're moving your Microsoft Dynamics GP databases and you use the drilldown functionality in the SQL Server Reporting Services or Excel integrated reports, you need to follow the steps below in order to update your server links so the drilldowns will continue to work after the server move: 1. Ensure that everyone has logged out of Microsoft Dynamics GP and close all instances of SQL Server Management Studio. 2. On a machine where Dynamics GP is installed click on Start, then point to All Programs. Then click to expand Microsoft Dynamics, then GP and click on Database Maintenance. 3. When the utility opens select or enter the SQL Server instance name where the Dynamics GP databases are stored. If you are logged in as a domain account with rights to this SQL Server instance you can select the Windows Trusted Authentication method. [...]

By | 2018-07-18T11:23:45+00:00 April 6th, 2015|Dynamics GP|