Hands On with Microsoft Dynamics GP October 2019 Release: Install eConnect

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. With eConnect installed, we can now configure the Incoming Queue; I always do this as I have a number of clients using eConnect in this mode.

As the configuration required hasn’t changed, I’m going to link back to the three posts I did when Dynamics GP 2018 RTM was released:

  1. Configure eConnect Service
  2. Configure eConnect Incoming Queue
  3. Set eConnect Incoming Queue Permissions

Copy Account Categories Between Microsoft Dynamics GP Companies

Microsoft Dynamics GPWhen implementing Microsoft Dynamics GP for a new client, they usually have very similar setup between companies. While you can use the Professional Services Tools Library tool Company Copy, you sometimes need to replicate data which was configured after this function had been used.

I’ve previously posted scripts to copy segments and financial calendars; today’s script will copy Account Categories to a new company ensuring you have the categories in both companies:

Continue reading “Copy Account Categories Between Microsoft Dynamics GP Companies”

PowerShell to Promote Domain Controller

Windows ServerWhen testing Microsoft Dynamics GP, I often need a domain controller within my set of virtual machines. I’ve been promoting a server to be a domain controller manually, but it recently occurred to me that I could probably do the same task using PowerShell.

After doing some research, I came up with four commands which will rename and restart the server, install the Active Directory feature and add a forest.

To rename a server, run the following command, replacing the highligted section with the new server name:

Rename-computer -newname {server name}

Continue reading “PowerShell to Promote Domain Controller”

Implementing SmartList Builder: Security

eOne SolutionsThis post is part of the series on Implementing SmartList Builder from eOne Solutions.

The final element to readying SmartList Builder for use is to configure security so that users without the POWERUSER* role can access it. While this step isn’t absolutely necessary, I would encourage people not to over use the POWERUSER* role.

A better approach would be to create a Super User role instead. Both this role and standard user roles will need to have access to the SmartList Builder windows granting.

This is easy to do, as SmartList Builder ships with some default security tasks and a role:

Security Role Setup

Assign this role to the relevant user or assign the tasks to existing roles and user will, next time they login, be able to access the SmartList Builder window.

Implementing SmartList Builder: Register

eOne SolutionsThis post is part of the series on Implementing SmartList Builder from eOne Solutions.

If you’re testing SmartList Builder, you can use it in the Famrikam Sample company without entering a registration key. However, yo use it on a normal company, even a test one, you will need to input the key.

To do this, log into Microsoft Dynamics GP as a user with the POWERUSER* role and open the SmartList Builder Register window (Administration area page » Setup » SmartList Builder » Register SmartList Builder) and enter the key in the Registration Key field:

SmartList Builder Register

Click Save to sdave the key and close the window.

IIS Rewrite Rule for Redirect to Directory

Microsoft Dynamics GPThe web hosat I am currently with allows multiple domains, but only 6 websites; this means I have to be a little creative sometimes when creating additional sites.

I actually have a lot more than six websites being hosted on my account, due to a mix of WordPress MU and redirects to folders.

The redirect is done using an IIS rewrite rule. As I may be moving web host soon, I’m posting this so that I have easy access should I need.

This code goes in the rewrite section of the web.config file:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
<rewrite>
	<rules>
		<rule name="Rewrite subdomain.azurecurve.co.uk subdomain to dir" enabled="true">
			<match url="^(.*)$" />
			<conditions>
				<add input="{HTTP_HOST}" pattern="^subdomain\.azurecurve\.co\.uk$" />
			</conditions>
			<action type="Rewrite" url="_subdomain.azurecurve.co.uk/{R:1}" />
		</rule>
		<rule name="subdomain.azurecurve* wordpress" patternSyntax="Wildcard">
			<match url="*subdomain.azurecurve*" />
			<conditions>
				<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
				<add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
			</conditions>
			<action type="Rewrite" url="_subdomain.azurecurve.co.uk/index.php" />
		</rule>
</rewrite>

The second rule is, I believe, required specifically for redirects for WordPress sites, the majority of which my rewrites are for.

Implementing SalesHQ Portal: Configure SalesHQ

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

After a company has been registered with SalesHQ and you logout and back in, the menu will update with the menu items for the SalesHQ configuration windows:

Administration menu showing CustomerHQ

Continue reading “Implementing SalesHQ Portal: Configure SalesHQ”

Implementing SalesHQ Portal: Portal Deployment on Azure

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

This is a step which ISC Software will perform, but some information is required for this to be accomplished. In the last post in this series, I showed how to register a company with SalesHQ; this generated a unique GUID for each company.

For ISC Software to deploy the portal, they need the Company ID for each company registered.

Run the script below against your Elementz database, to extract the CompanyID GUIDs:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
SELECT DynamicsDB,CompanyDB,CompanyId FROM CustomerPortalCompany

Once you have this information reply back to the Azure settings email you received before installing the connector service.

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Installing FileZilla Client: Stop Upload of GitHub Files

FileZilla - The free FTP solutionThis post is part of the Installing FileZilla Client series. FileZilla is a free software, cross-platform FTP application, consisting of FileZilla Client and FileZilla Server. Client binaries are available for Windows, Linux, and macOS; server binaries are available for Windows only. This series is taking a look only at the Windows FileZilla client.

With my transition from developing plugins for Wordpress to developing them for ClassicPress I have started to use GitHub (on which I will soon be writing a series). One problem I’ve noticed is that when uploading folders which are GitHub repositories, the GitHub files and folders are also uploaded.

However, this does not need to be the case. To prevent GitHub repository files and folders being uploaded, you can change a setting in FileZilla. To do this, click the View menu and select Directory listing filters:

FileZilla View menu

Continue reading “Installing FileZilla Client: Stop Upload of GitHub Files”

How to Remove a Dependency from a Windows Service

Microsoft Dynamics GPIn the last post I showed how to use sc.exe to add a dependency to a Windows service; the first time I added the dependency to the eOne and eConnect services, I got the service name wrong. This was because the server I was working on had a SQL Server Named instance rather than the default name.

I had to do some searching around how to remove the incorrect dependency, as it was preventing the services from starting:

Services - Windows could not start the eConnect for Microsoft Dynamics GP 2018 Integration Service service on the Local Computer

Continue reading “How to Remove a Dependency from a Windows Service”