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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Create Installation Package
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. The setup utility allows you to create an installation package which can simply the install of a client by preselecting relevant options. One key point to note is that there is a bug where the installation package will always deploy to a GP2018… Continue Reading azurecurve’s...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install GP PowerShell
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. Another additional product which isn’t widely used, to the best of my knowledge, is GP PowerShell. This alows the use of PowerShell to perform actions, such as creating a new company. To install, launch the setup utility and under Additional… Continue Reading...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install GP Add-in for Microsoft Word
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. After a brief posting hiatus, I am back to continue the series of going hands on installing the new version of Microsoft Dynamics GP Fall 2021 Release. In this post, I am going to take a look at installing one of the additional products which… Continue Reading azurecurve’s...
2021 year in review
It’s hard to believe it’s the start of another year. 2020 felt like it lasted forever while 2021 was a blur. I think 2021 was “2020 one” and 2022 is “2020 two”, which is what this pandemic feels like at the moment, that 2020 has never actually ended. Nearly two years into this pandemic and people still don’t know how to wear a mask properly, but I digress… Anyway, it’s always… Continue Reading Jen...
Happy New Year!
Wishing everyone in the Microsoft Dynamics GP and ClassicPress communities a Happy New Year; hopefully it will be a much better year than the last two years. Image by Gerd Altmann from Pixabay I hope you’ll enjoy Auld Lang Syne from The Choral Scholars of University College Dublin: Read original post Happy New Year! at azurecurve|Ramblings of an IT Professional Continue Reading azurecurve’s Article on their blog Happy New...
Top 10 Blog Posts from 2021
I didn’t do this last year for 2020, but I like to look back at what posts had the most views during the previous year to see what has staying power and what piqued other’s curiosity. Interestingly enough, not a single 2021 blog post made my top 10 list. That’s not too surprising to me since I was inactive for so long into the year, that the posts I had have not had a lot of time yet to gain… Continue Reading...
azurecurve ClassicPress Plugins: Contact Forms
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 A simple contact forms plugin with an options page allowing default settings to be configured; these settings can, in most cases, be overridden when adding… Continue Reading...
azurecurve ClassicPress Plugins: Redirect
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 ; Redirect. Functionality Redirect URIs with a 301 (permanent) or 302 (temporary) redirect; redirects can be edited, toggled on/off and easily deleted if required. URLS for redirect… Continue Reading azurecurve’s...
Canadian Payroll 2021 Year End Update
In all the 2020 excitement, I realized I never posted about the 2020 Year End update. I think 2020 for me was all about getting through day to day things and I just forgot about this. Anyway, I’m back to blogging semi-regularly again and it’s that time of year again. This is a HEADS UP for now, primarily aimed at Dynamics GP Canadian Payroll users. I will update this post as more… Continue Reading Jen Kuntz’s...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Integration Manager First Run
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 Integration Manager installed there are three things we need to do to make it ready for use. Firstly, we nee to launch Integration Manager using right click + Run as Administrator; this ensures the registry entries are created… Continue Reading azurecurve’s Article on...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install Integration Manager
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. In the last post, I covered installing the eConnect Runtime on a client which makes it available to Integration Manager. In this post, I am going to install Integration Manager with both the standard and eConnect adaptors. Launch the Dynamics GP… Continue Reading azurecurve’s...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install eConnect on 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. The first of the additional products I am going to install is the eConnect Runtime; this is a tool which allows you to push/pull information with Microsoft Dynamics GP using another tool such as Integration Manager (which I will install in a… Continue Reading azurecurve’s...
Recent ISC Software Webinar: SmartList Tips And Tricks
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 SmartList UI Columns Searching Favorites Reminders Advanced Searching Exporting/Export Solutions...
ROE issue in Canadian Payroll
This post is about an issue that I found when testing the ROE (Record of Employment) functionality for a client in Dynamics GP. (Since “ROE” is a generic term, this post is specifically about a bug in the Dynamics GP Canadian Payroll module). I opened a case for it and it was quickly confirmed and written up as a quality issue (#91928 in case you need to add yourself or your customer to the… Continue Reading Jen...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Intelligent Edge Has Been Removed
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. One of the small surprises of the Fall 2021 version of Microsoft Dynamics GP is that the Intelligent section has been removed from the Dynamics GP homepage; previously there would have been a link in the top left: It was added to help drive… Continue Reading azurecurve’s...
Pagination in Power Query (follow up)
This post is an unintended follow up to my “mini-series” working through how I am connecting to Harvest and ClickUp APIs in Power Query. After writing up post #4 (iterating over an unknown number of pages), I decided to review the method I used there vs. the method in post #4 (List.Generate). So, today’s post is really just describing another example of how to use List.Generate, this time… Continue Reading Jen...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Desktop Client First Run
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 sample company deployed and a company created, we can check that the client is working correctly by running it for the first time. Log in using the sa account and wait while the SQL Messages are added: If you only have one company,… Continue Reading azurecurve’s...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Create a Company
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. When doing demos, I always have more than one company available so I can show intercompany postings or other items which may need two databases. You can create a new company in GP Utilities; log in using the sa account: Click Next a few times to… Continue Reading azurecurve’s...
Clear Recent Items list in Power BI Desktop
Today’s tip I found completely by accident. In the Open Report window, I had a long list of previous Power BI reports in my “recently used” list, many of which I had long ago deleted or moved. I wanted to clear the list and could not find a way to do that in that screen. With Word or Excel, it’s easy to do in the equivalent screen so it was driving me a little nuts that I was not able to do it… Continue...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Add Sample Company Data
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 system database deployed we can now either add the sample company data or create a company. I’ll create a company in a later post, but first I’m going to add the sample company data; this is the Fabrikam, Inc. which can be used for… Continue Reading...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Deploy System Database
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 first Microsoft Dynamics GP client installed, we can now progres onto deploying the system database. To do this, launch GP Utilities and log in using the sa account: On the Welcome step click Next Select the Advanced installation opton… Continue Reading azurecurve’s...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Install Dynamics GP 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. Microsoft Dynamics GP hasn’t had server components for quite a few years now, so the first part of installing a new version of Dynamics GP, is to install the standard client. I always recommend to clients that the SQL Server just be a SQL server,… Continue Reading...
Pagination in Power Query (Part 2)
This post is the 4th in a “mini-series” where I’m documenting how I’m working with some different APIs for custom reporting. Today’s post is about ClickUp, an app I use for managing projects, but like post #2 about Harvest, it’s less about ClickUp then it is about iterating over an unknown number of pages of results. The specific nuance here is ClickUp returns a list every time, it does…...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Installing the .NET Prerequisite
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 installing any of the Microsoft Dynamics GP components, you need to make sure the system requirements are met. On top of this there is also some prerequisites which need to be installed before the Microsoft Dynamics GP client or other… Continue Reading azurecurve’s...
Connecting to ClickUp in Power Query
This post is the 3rd in a “mini-series” where I’m documenting how I’m working with some different APIs for custom reporting. Today’s post is about ClickUp, an app I use for managing projects. Unlike the Harvest APIs I covered in post 1 & 2, ClickUp’s API is a little more challenging to deal with as there are no indicators about number of records or number of pages in the results so you need...
Hands On with Microsoft Dynamics GP Fall 2021 Release: System Requirements
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 starting to implement, or upgrade to, Microsoft Dynamics GP Fall 2021 Release you should review the System Requirements which detail the compatibility between Dynamics GP and SQL Server, Windows Server and Windows amongst other software. I… Continue Reading azurecurve’s...
Power BI number formatting tips
Here are two tips that I use repeatedly when building reports in Power BI. “Repeatedly” is a bit of a stretch as I’m still a newbie with Power BI but this was remarkably hard to find so I’m blogging for my future self, when I forget. For Tip #1, I love being able to format numbers in Excel easily with the click of a mouse button, but in Power BI, it’s not quite as straight forward. I like… Continue...
Hands On with Microsoft Dynamics GP Fall 2021 Release: Download the Installation Media
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. The Microsoft Dynamics GP Fall 2021 Release is available to download from Microsoft by people with a PartnerSource/CustomerSource login: Full download Hotifx download for updating from GP Fall 2020 Release (18.3) The full download contains… Continue Reading azurecurve’s...
Hands On with Microsoft Dynamics GP October 2021 Release: Series Index
This post is the Hands On with Microsoft Dynamics GP October 2021 Release series index for the series where I am going to go hands on with installing the Microsoft Dynamics GP October 2021 Release and associated products. The series index, below, will automatically update here on azurecurve|Ramblings of a Dynamics GP Consultant as posts are published; if you’re reading elsewhere, check back to… Continue Reading...
Remove Word From Microsoft Office Custom Dictionary
I end up adding lots of words to the dictionary in Microsoft Office; often lots of vendor or product names. I recently added a misspelling of SmartConnect which I needed t remove and I had to do some research to find out how. It’s not actually too complex to do, but there are a few screens you have to go through. You can do this in any of the Office products; this example is done through… Continue Reading...
Pagination in Power Query (Part 1)
This post is the second in a “mini-series” where I’ll document how I’m working with some different APIs for custom reporting in Power BI and Excel. Today’s post is about Harvest again, but only in general terms. The example is their time_entries endpoint but what I’m really covering today I would term more generically as “iterating over a known number of pages” when calling an… Continue Reading Jen...
Hide Feed in Microsoft Edge
This should probably be obvious, but I’ve alwys struggled to switch the feed off in Microsoft Edge. I’ve never found the feed useful in anyway and want to switch it off on every machine on which I use Microsoft Edge. To fully switch it off, click the cog icon and select Custom; under the Content heading you can then choose from several options with Content off being my preference: Read… Continue Reading...
Connecting to Harvest in Power Query
Today’s post is the start of a “mini-series” where I’ll document how I’m working with some different APIs for custom reporting. Today’s post is about Harvest, an app I use for time tracking and billing. This series is aimed at users who may have similar requirements to mine, which was pulling data out of different application APIs for analysis in Power BI and/or Excel. In my limited… Continue...
During Upgrade Company Locked In Microsoft Dynamics GP Utilities
I did an upgrade for a client recently which encountered a problem in one company and crashed; when resuming the upgrade, the Upgrade these companies? step showed a lock against the company which had encountered the problem: It’s a while since I encountered this and I had to look up how to remove the lock; it’s quite simple to do with a small SQL script. To remove the lock, run the below in… Continue Reading...
Power BI matrix column width sizing
I’ve been working with Power BI a lot lately on a “passion project” for myself. I’ll be starting to share more about that in the coming days but first I wanted to share a little tip (that I wish we didn’t need!) for sizing columns on Matrix visuals in Power BI. I’ve read a number of other posts and suggestions around creating a measure with all “X’s” but they have never worked for… Continue Reading Jen...
“The selected company is not configured as a company of the current Microsoft Dynamics GP system database” Error
We been doing a lot of work with a client recently to split their US and UK based systems. The original scope involved implementing Microsoft Dynamics GP for a new company based in the UK; the databases were originally created on the US system and then split off by copying the company database and the system database onto a UK based SQL Server. Along with the client, we did some tidying up of… Continue Reading azurecurve’s...