SmartConnect 2021 – The source was not found, but some or all of the event logs could not be searched
May23

SmartConnect 2021 – The source was not found, but some or all of the event logs could not be searched

Earlier this year I added SmartConnect from eOne Solutions to a new demo vm (I’m a bit behind with posts). I was able to create the data source and integration without any issues, but then encountered an error when running any of the integrations in SmartConnect: The source was not found, but some or all event logs could not be searched. To create the source, you need permission to real all… Continue Reading...

Read More
Dynamics GP Email – Login Failed error
May10

Dynamics GP Email – Login Failed error

Today’s #TipTuesday post is a pretty short one. A client of mine recently merged with another firm and part of that was everyone getting new email addresses for a new web domain. For most of the users that used email functionality in GP, it was a non-event: they simply logged into the “Exchange Log On” prompt with their new email and password and continued with their task. For one user,… Continue Reading Jen...

Read More
Enabling the Canadian Payroll module
Apr13

Enabling the Canadian Payroll module

Today’s post is short-ish and sweet. In my last post, I documented where to go to get registration keys. In the last part of the post, I had added a note that was specific to Canadian Payroll and today learned that it no longer applies, at least not for recent versions of Dynamics GP. I have edited that part of the post now… This post is a very brief overview of the 2 things that need to be… Continue Reading Jen...

Read More
Where can I find my registration keys on CustomerSource?
Mar29

Where can I find my registration keys on CustomerSource?

This is a short post. I went looking for a customer’s registration keys and could not remember how to get to them now that the old CustomerSource links are dead and buried. So… future “me”, this is your reminder! And for those who stumble across this, you’re welcome, I hope the info stays “correct” for the next few years so I don’t have to look for this again! NOTE: I am not covering...

Read More
Change SQL Server Analysis Services Deployment Mode from Multidimensional to Tabular
Mar21

Change SQL Server Analysis Services Deployment Mode from Multidimensional to Tabular

I recently installed SQL Server Analysis Services (SSAS) and used the default settings during the installation. Unfortunately, this meant I installed it using a Deployment Mode of Multidimensional instead of Tabular. I wanted to avoid uninstalling so I did some poking around and found there is a setting file which can be amended to change the Deployment Mode. The file is msmdsrv.ini which is… Continue Reading azurecurve’s...

Read More
Change All Folders to Match Current View
Mar18

Change All Folders to Match Current View

Windows Explorer allows you to customise a folder by changing the columns available with the changes only affecting that one folder. However, there is also a method of applying the changed view to all foldersof the same type. This means if you’re working, as I was, on a folder containing photos that you can apply any changes to the columns to all other folders which Windows sees as a photo… Continue Reading...

Read More
Find SQL View in All Microsoft Dynamics GP Databases
Mar17

Find SQL View in All Microsoft Dynamics GP Databases

I recently needed to find which databases in SQL Server had a specific view deployed to them. I’ve created scripts in the past to find SQL objects in all databases (table,trigger and functions), but not one for SQL views. Some of the previous scripts looked in all databases and others were limited to only the Microsoft Dynamics GP databases; this script is one of the latter, using the… Continue Reading azurecurve’s...

Read More
Integration Manager Error Importing Fixed Asset
Mar16

Integration Manager Error Importing Fixed Asset

After assisting a client with a server migration, an issue was reported with a fixed asset integration: DOC 1 ERROR: The stored procedure ‘taCreateAssetID’ doesn’t exist. The first thing we checked was to see if the stored procedure did exist, which it did. The next option was a suspicion of permissions. After checking in SQL I found that the service account did not have access to all of the… Continue Reading...

Read More
Error Sending Mail Using SQL Database Mail
Mar15

Error Sending Mail Using SQL Database Mail

I was recently doing some testing of a script I created for a client which used SQL Database Mail for sending emails. this was on my one of my demo environments, but I received an error when testing the script: Microsoft Dynamics GP Unhandled database exception: [Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object… Continue...

Read More
Update EFT Transfer Method on Creditor EFT Details in Microsoft Dynamics GP
Mar14

Update EFT Transfer Method on Creditor EFT Details in Microsoft Dynamics GP

I was doing some work with a client recently where we needed to output two different formats of EFT file for the same bank account. This is possible using the EFT Transfer Method on the bank on the creditors. However, with a large number of creditors we needed a way to update the records in bulk. While it would be possible to do this with a macro, it would be fiddly and take a while. Instead,… Continue Reading azurecurve’s...

Read More
Power BI, Excel & GP – SQL sources
Mar08

Power BI, Excel & GP – SQL sources

Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. The previous posts in the series are: Introduction Starting from scratch Data Access What this post covers In this post, here is what I am going to show, in the context of the Payables Transactions type of… Continue Reading Jen Kuntz’s...

Read More
Select Microsoft Dynamics GP GL Accounts for Import
Mar04

Select Microsoft Dynamics GP GL Accounts for Import

Working on a recent project for a client we needed to extract the chart of accounts from one Microsoft Dynamics GP company and import it into a couple of others (altering the first segment during the process. The below script was created to extract all of the chart of account data in the format required for import through Integration Manager: SELECT [‘Account Index Master’].ACTNUMST AS

Read More
Assign a Microsoft SQL Server Role to a User in All Microsoft Dynamics GP Databases
Mar03

Assign a Microsoft SQL Server Role to a User in All Microsoft Dynamics GP Databases

I did some work for a client recently which involved creating a report which could be run against any database; we therefore needed to add the user to a database role in all databases which gave access to the relevant SQL objects. The below script generates a SQL script which can be used to alter the role to assign it to the specified user in all of the Microsoft Dynamics GP company… Continue Reading azurecurve’s Article...

Read More
Fixing a OneDrive Which Has Stopped Synchronising
Mar02

Fixing a OneDrive Which Has Stopped Synchronising

I’ve been using OneDrive for quite a long time, but recently became aware that files created or amended on one PC were not being synchronised to others although it would download files created on other machines, which was why I hadn’t immediately become aware of the issue. I did some general poking around OneDrive and couldn’t find anything wrong so did some searching and found a discussion… Continue Reading...

Read More
Enable Workflow Step Email Notifications in Microsoft Dynamics GP
Mar01

Enable Workflow Step Email Notifications in Microsoft Dynamics GP

I was doing some work for a client to build a workflow process in Microsoft Dynamics GP recently and we only got the SMTP details quite late in the process. This meant that we built quite a large workflow process without being able to enable the email notifications. Once we did have the SMTP available we needed to go back through all of the steps and enable the email notifications. Rather than… Continue Reading...

Read More
Power BI, Excel & GP – Data Access
Feb24

Power BI, Excel & GP – Data Access

This is the third post in the series and I am going to dedicate this post to how to access GP data in terms of describing some of the options and factors to consider. Very little of this will have “how to” information about Power Query, but I will continue that in the next post. The previous posts in the series so far are: Introduction Starting from scratch In my last post, “starting from… Continue Reading Jen...

Read More
Script to Help Check For Missing Microsoft Dynamics GP Workflow Customisations
Feb11

Script to Help Check For Missing Microsoft Dynamics GP Workflow Customisations

If you’re a regular reader, you’ll be aware that I am a big fan of the Microsoft Dynamics GP Workflow module which can be used for the approval of batches, documents, security and more. Workflow can easily be customised to allow for extra fields to be available in the workflow conditions and on the notification emails (which I cover in chapters 9 and 11 of my Microsoft Dynamics GP Workflow… Continue Reading...

Read More
Script to Remove Microsoft Dynamics Workflow History Where No Action Is Required
Feb10

Script to Remove Microsoft Dynamics Workflow History Where No Action Is Required

I have quite a few clients using the Microsoft Dynamics GP Workflow module as standard out of the box with no customisations required, but a fair number of clients do have one customisation or another. A few of them have a customisation allowing a SQL view to be used in the workflow conditions and a few have a script like the one in this post to remove some of the workflow history. If you have… Continue Reading...

Read More
Script to Remove Advanced Bank Reconciliation Transaction Matches
Feb09

Script to Remove Advanced Bank Reconciliation Transaction Matches

I do demonstrations of quite a bit of functionality in Microsoft Dynamics GP which often necessitates restored databases or otherwise reversing transactions and processing. One of the modules I’ve done some demonstrations of recently is the Advanced Bank Reconciliation module from Nolan Business Solutions. One of the features of this module is allowing you to atch statement entries with… Continue Reading azurecurve’s...

Read More
SmartConnect 2021 Error: “HTTP Error 500.19 – Internal Server Error”
Feb08

SmartConnect 2021 Error: “HTTP Error 500.19 – Internal Server Error”

I’ve been doing some work with a client recently implementing SmartConnect 2021, although the client has done much of the install themselves using the manual as a guide (this was their choice to help keep costs down). When we tried to enable the REST API and navigate to the endpoint to check, we were receiving an error: HTTP Error 500.19 – Internal Server Error The requested page cannot be… Continue Reading...

Read More
Power BI, Excel & GP – Starting from scratch
Feb07

Power BI, Excel & GP – Starting from scratch

The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, literally starting from scratch. From my experience, an audience that is often overlooked are users who want to learn more or improve their skills but doesn’t know where to start, and everything they find starts at a point they don’t understand or can’t get… Continue...

Read More
SmartConnect 2021 Error With Excel Data Sources: “Data source name not found and no default driver specified”
Feb07

SmartConnect 2021 Error With Excel Data Sources: “Data source name not found and no default driver specified”

We’ve recently upgraded a client from SmartConnect 2018 to SmartConnect 2021 and mosstly had no problems. One issue which came up is when users tried to run an integration which had a Microsoft Excel file as the data source. Each time they tried the integration, and on several machines, they always received the same error: Connection could not be validated ERROR [IM002] [Microsoft][ODBC… Continue...

Read More
azurecurve ClassicPress Plugins: Load Admin CSS
Feb05

azurecurve ClassicPress Plugins: Load Admin CSS

This is part of the azurecurve ClassicPress Plugins series which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is one written specifically for ClassicPress ; Load Admin CSS. Functionality Change the styling of your admin dashboard with custom CSS. Options are maintained via a Settings page on the azurecurve menu. Example CSS usage to… Continue Reading azurecurve’s...

Read More
Error Logging into Jet Hub : “IDX20803: Unable to obtain configuration from: ‘System.String’.”
Feb04

Error Logging into Jet Hub : “IDX20803: Unable to obtain configuration from: ‘System.String’.”

I did an install of Jet Reports recently on new demo VM and found that I had a problem logging into the Jet Hub. When I tried to log in, I was always getting this error: Error IDX20803: Unable to obtain configuration from: ‘System.String’. I did some debugging myself and got nowhere in working out the cause of the problem as everything looked fine. An online search found an article on the

Read More
Web Services Upgrade Error: “The provided windows account is not formatted correctly”
Feb03

Web Services Upgrade Error: “The provided windows account is not formatted correctly”

When I do an upgrade of the Web Services For Microsoft Dynamics GP, my usual approach is to ru a two Microsoft supplied scripts which remove all web services objects from the system and company databases; I generally do this as we had problems with the upgrade process within the Configuration Wizard. On a recent upgrade I thought I would give the standard upgrade process aother try, as it is a… Continue Reading...

Read More

Create Grant Statement for All Custom Views in Microsoft SQL

On a recent project, I needed to create a new database role for some new SQL views which had been created. Creating the role is easy enough, but to make sure all the relevant views (and there were quite a few) looked like a bigger job until I realised I could select from sys.views and generate the grant script at the same time. In the below script, the first highlighted section is the database… Continue Reading...

Read More
Maximum columns in a SmartList
Feb02

Maximum columns in a SmartList

This is most likely the shortest #TipTuesday post I will ever create! I was playing with a SmartList to prep for my upcoming series on Power BI, Excel & Dynamics GP. I stumbled across something I have never seen before: I tried to add too many columns to a SmartList! Here’s the message I received. Apparently, 189 columns is the most you can display in a SmartList (if I’m reading the… Continue Reading Jen...

Read More
Microsoft Dynamics GP VBA Entering Debug Mode Without Breakpoint For All Users On First Login
Feb01

Microsoft Dynamics GP VBA Entering Debug Mode Without Breakpoint For All Users On First Login

A client reported a problem with some VBA customisations in Microsoft Dynamics GP where the code was stopping as if at a debug point in two places even thought there were no debug points present. Once a user hit F5 to continue the code past a “debug” point, they would not see the problem again until the next time they logged in. I did a lot of investigation and fiddling around, but could not… Continue Reading...

Read More
Power BI, Excel & Dynamics GP
Jan31

Power BI, Excel & Dynamics GP

Soon I will be starting a new series of posts around Dynamics GP and how to get data out of it with Power BI or Excel via Power Query. There is no shortage of reporting options available for Dynamics GP customers, with many ISV (3rd party) products out there to augment some out of the box options (Report Writer, SmartLists). However, as with accounting departments everywhere, there is a heavy… Continue Reading Jen Kuntz’s...

Read More
Microsoft Dynamics GP Statement Emailing “Path for the E-mail Status Report is not set up…” Error
Jan31

Microsoft Dynamics GP Statement Emailing “Path for the E-mail Status Report is not set up…” Error

I worked on a Microsoft Dynamics GP upgrade project recently for a client who uses the old Adobe statement process. I am not all that familiar with this as most clients are now using the On Blank Paper statement and the standard emailing functionality. Once the upgrade was complete and we were doing some basic testing we encountered an error when trying to email the statements: Microsoft… Continue Reading azurecurve’s...

Read More
Today why you should Learn Selenium in Online
Jan28

Today why you should Learn Selenium in Online

Selenium is an automated web browser, and it allows immediate testing of web applications so that developers can send new releases faster. For businesses, many of you choose it as a valuable test automation tool for web applications testing, and you can retain the selenium online. Selenium is an open-source tool, which means anybody can learn and access it for free online. Any organization can use selenium to test their website or web...

Read More
Multiple Errors in Microsoft Dynamics GP
Jan28

Multiple Errors in Microsoft Dynamics GP

I received an urgent call from a client early one morning a short time ago. All users logging into Microsoft Dynamics GP were receiving multiple errors across the system rendering it unusable. The first reported error was displayed on login and encountered by all users: …clear table ReportSchedule… A second error was produced when trying to open SmartList and was displayed 12+ times: Error… Continue Reading...

Read More
Error Binding SSL Certificate for Securing Web Services for Microsoft Dynamics GP
Jan27

Error Binding SSL Certificate for Securing Web Services for Microsoft Dynamics GP

I recently helped a client secure the connection for the Web Services for Microsoft Dynamics GP. I sent over the prerequisites for ports, certificates and so on in advance. When I came to binding the certificate I received an error (which I have seen before): SSL Certificate add failed, Error: 1312 A specified logon session does not exist. It may already have been terminated. In the previous… Continue Reading azurecurve’s...

Read More
Change Web Services for Microsoft Dynamics GP Web Server Location In All Companies
Jan26

Change Web Services for Microsoft Dynamics GP Web Server Location In All Companies

In the last post, I posted a script to find which Microsoft Dynamics GP company databases had web services enabled. Todays script is a related one; it can be used to change the web services server location in all companies. This script was created so once a live system was copied to a standalone test system, the web services server can easily be updated to the test server. The highlighted… Continue Reading azurecurve’s...

Read More
Find Microsoft Dynamics GP Databases With Workflow Email Actions Enabled
Jan25

Find Microsoft Dynamics GP Databases With Workflow Email Actions Enabled

I was doing an upgrade for a client the other day and ran some scripts to remove the web services SQL objects as part of the upgrade (I always find that an upgrade of the Web Services for Microsoft Dynamics GP doesn’t work very well, so it’s a quicker and better option to remove and reinstall. As part of the reinstall I needed to deploy them to the companies to which they had previously been… Continue Reading...

Read More
Recent ISC Software Webinar: What’s New in Microsoft Dynamics GP Fall 2021 Release​
Jan24

Recent ISC Software Webinar: What’s New in Microsoft Dynamics GP Fall 2021 Release​

In our most recent webinar, we took a look at SmartList Tips And Tricks. In this webinar, we took a look at how you can get the most out of the Microsoft Dynamics GP SmartList reporting tool. If you want to catch up on this, or any other, webinar, you can do so here. Introduction Roadmap Dynamics GP Ideas Upgrade Process New functionality System Enhancements Financial Enhancements

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install eConnect Server
Jan21

Hands On with Microsoft Dynamics GP Fall 2021 Release: Install eConnect Server

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. Earlier in the series, I installed eConnect on a client; the initial install on the server is the same for when you want to use eConnect in message queuing mode, except there are then three… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
Jan20

Microsoft Dynamics Business Central as a Data Type in Excel via Power BI

While hosting yesterday’s Power Platform Mix it up with New View Strategies, Microsoft Senior Program Manager Blazej Kotelko talked about using Microsoft Dynamics Business Central Data, specifically a dataset in Microsoft Power BI as a source for Data Types in Excel.  Several of us hung out yesterday and tried to do it.  We thought we missed something because it wasn’t working.  Today… Continue Reading Belinda Allen’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install OData Service
Jan20

Hands On with Microsoft Dynamics GP Fall 2021 Release: Install OData Service

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. An OData service is one of the additional products available with Microsoft Dynamics GP; it allows for reporting services such as PowerBI to connect to Microsoft Dynamics GP. I don’t have many… Continue Reading...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Verify Web Services
Jan19

Hands On with Microsoft Dynamics GP Fall 2021 Release: Verify Web Services

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. With the web services installed and configured, we now need to verify that they are working correctly. There are several steps to this verification. Firstly, launch the DynamicsSecurityConsole… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Configure Web Services
Jan18

Hands On with Microsoft Dynamics GP Fall 2021 Release: Configure Web Services

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. With the Web Services for Microsoft Dynamics GP installed, we can now configure them. If you marked the checkbox on the last step of the installer, the wizard will already be open, otherwise… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install Web Services
Jan17

Hands On with Microsoft Dynamics GP Fall 2021 Release: Install Web Services

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. If you’re using the Microsoft Dynamics GP Workflow module for approvals then you will most likely need to install the Web Services for Dynamics GP which allows users to do approval via email…. Continue Reading...

Read More
azurecurve ClassicPress Plugins: Strong Password Generator
Jan15

azurecurve ClassicPress Plugins: Strong Password Generator

This is part of the azurecurve ClassicPress Plugins series which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is one written specifically for ClassicPress ; Contact Forms. Functionality Create password forms allowing users to create strong passwords consisting of upper/lower case letters, numbers and symbols. Options are maintained via… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install GP Web Resource Cache
Jan14

Hands On with Microsoft Dynamics GP Fall 2021 Release: Install GP Web Resource Cache

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. With the web client fully working, there is one element which can be installed to increase performance and this is the Microsoft Dynamics GP Web Resource Cache. The GP Resource Cache is… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Web Client First Run
Jan13

Hands On with Microsoft Dynamics GP Fall 2021 Release: Web Client First Run

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. With the web client installed, we can log into it for the first time and confirm that the install has worked correctly. The address for the web client will be https://{fully qualified domain… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install Web Client Help
Jan12

Hands On with Microsoft Dynamics GP Fall 2021 Release: Install Web Client Help

This post is part of the Hands On with Microsoft Dynamics GP Fall 2021 Release series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. After a href=’https://www.azurecurve.co.uk/2022/01/hands-on-with-microsoft-dynamics-gp-fall-2021-release-configure-web-client/’>configuring the web client, there is another routine which opened… Continue Reading...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Configure Web Client
Jan11

Hands On with Microsoft Dynamics GP Fall 2021 Release: Configure Web Client

This post is part of the series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. With the web client installed, we now need to run through the configuration which creates the web client database. The Microsoft Dynamics GP Web Components Configuration Wizard will have opened automatically when the main install completed. Click… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install the Web Client
Jan10

Hands On with Microsoft Dynamics GP Fall 2021 Release: Install the Web Client

This post is part of the series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. With the prerequisites in place and the client to be used as a web client having had the Web Client Runtime installed, we can install the Web Components themselves. Do this by launching the setup utility and select Web Components under the… Continue Reading azurecurve’s...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Add Web Client Runtime Feature
Jan07

Hands On with Microsoft Dynamics GP Fall 2021 Release: Add Web Client Runtime Feature

This post is part of the series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. I am covering a simple single-machine deployment of the web client over the next few posts; if you’re interested in a guide to implementing a larger scale-out deployment, I have covered this in a book: Implementing the Microsoft Dynamics GP Web… Continue Reading...

Read More
Hands On with Microsoft Dynamics GP Fall 2021 Release: Web Client Prerequisites
Jan06

Hands On with Microsoft Dynamics GP Fall 2021 Release: Web Client Prerequisites

This post is part of the series where I am going to go hands on with installing the Microsoft Dynamics GP Fall 2021 Release and associated products. Before we start on the installation of the web client components themselves, we need to sort out the prerequisites. These prerequisites are all in the Windows feature Internet Information Services (IIS). As the installation and configuration of… Continue Reading azurecurve’s...

Read More