Getting a list of write-offs – JenKuntz.ca
Nov13

Getting a list of write-offs – JenKuntz.ca

A few months ago, when I first started this #TipTuesday series, one of my first posts was around writing off small customer balances. A reader posted a comment last week with a great question: how do you get a list of invoices written off (for an audit, for example)? What I am going to describe below is what would work if you record write offs using the Write Off Amount field in GP or use… Continue Reading Jen Kuntz’s...

Read More
Deploying Jet Views – azurecurve
Nov13

Deploying Jet Views – azurecurve

This post is part of a series of posts on implementing Jet Reports and is part of the Jet Professional sub-series. I’m a little late in posting this one, as I forgot to include it with the original series when I posted it. Jet Professional provides a number of database views which can be used to simplify reporting, rather than using the Microsoft Dynamics GP tables (the structure of… Continue Reading Ian Grieve’s Article...

Read More
Year End Closing – Query Timeout Expired Error | "The Stored Procedure glYearEndCloseMain"
Nov12

Year End Closing – Query Timeout Expired Error | "The Stored Procedure glYearEndCloseMain"

If you are performing the year end closing procedure and encountering the error ” Query Timeout Expired” specifically at step 3 out 7, then an error message popped up ” The stored procedure glYearEndCloseMain returned the following results DBMS … “, you need to know that the GL year end closing procedure has failed as it partially closed the year.  Issue Diagnosis : When closing the year,… Continue...

Read More
Install Microsoft Dynamics GP Add-in for Microsoft Word – azurecurve
Nov12

Install Microsoft Dynamics GP Add-in for Microsoft Word – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. The Microsoft Dynamics GP Add-in for Microsoft Word was… Continue Reading Ian Grieve’s Article on...

Read More
Create Installation Package – azurecurve
Nov09

Create Installation Package – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. In an early post of this series, I installed the Microsoft… Continue Reading Ian Grieve’s Article on...

Read More
Integration Manager First Run – azurecurve
Nov08

Integration Manager First Run – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Which versions of Microsoft Dynamics will be Making Tax Digital compliant?
Nov08

Which versions of Microsoft Dynamics will be Making Tax Digital compliant?

Making Tax Digital Compliance and Microsoft Dynamics ” Incremental GroupMaking Tax Digital (MTD) is a transformational approach to taxation in the UK from HMRC. The first change is coming...

Read More
Install Integration Manager – azurecurve
Nov07

Install Integration Manager – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Not Your Daddy’s Financial Series
Nov06

Not Your Daddy’s Financial Series

I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series.  Feel free to join me! Not your Daddy’s Cash Flow Statement One of the first things we all learn in Business 101 is that Cash is needed to operate a business. We also learned that being Profitable does not mean you have cash in the bank…. Continue Reading Belinda Allen’s Article...

Read More
My Reports in GP – JenKuntz.ca
Nov06

My Reports in GP – JenKuntz.ca

Today’s #TipTuesday post is about the My Reports functionality in Dynamics GP. There was a user question yesterday on the GPUG forums, where someone was asking how to modify their My Reports list. Great question! Here are some tips on getting reports on and off the My Reports list. What is it? My Reports is a section of Dynamics GP where a user can save reports they run frequently so… Continue Reading Jen Kuntz’s Article...

Read More
Install eConnect on Client – azurecurve
Nov06

Install eConnect on Client – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. I already stepped through the installation of eConnect on the… Continue Reading Ian Grieve’s Article...

Read More
Create Company Using PowerShell – azurecurve
Nov05

Create Company Using PowerShell – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. GP PowerShell can be used to create companies and other… Continue Reading Ian Grieve’s Article on...

Read More
Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow
Nov04

Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow

Recently, Business Applications MVP Steve Endow and I delivered a session at the User Group Summits in Phoenix, and in particular, to the GPUG Summit titled, “Microsoft Dynamics GP and Azure Services”. In this course we detailed a number of Azure Services (among the hundreds) that could potentially be used with Microsoft Dynamics GP. Being that I have also been working my way through… Continue Reading Mariano...

Read More
Test GP PowerShell By Getting Available Commands – azurecurve
Nov02

Test GP PowerShell By Getting Available Commands – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Install GP PowerShell – azurecurve
Nov01

Install GP PowerShell – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Configure & Use OData Service – azurecurve
Oct31

Configure & Use OData Service – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. The last post covered the installation of the OData Service… Continue Reading Ian Grieve’s Article...

Read More
Connecting a 2nd PC as a second monitor – JenKuntz.ca
Oct30

Connecting a 2nd PC as a second monitor – JenKuntz.ca

Today’s #TipTuesday is yet another non-Dynamics GP post… I’m on a bit of a roll of finding oddball new things that are worth sharing. I’ll get back to more GP content soon, I promise! Background In a previous post, I had written about some health issues my Dad had. I’ve been hanging out with him and his wife at their home a couple of hours out of town from me, helping them get… Continue Reading Jen Kuntz’s Article on their...

Read More
Install GP OData Service – azurecurve
Oct30

Install GP OData Service – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. The next of the additional products I am going to install, is… Continue Reading Ian Grieve’s Article...

Read More
Web Services on Media Broken – azurecurve
Oct29

Web Services on Media Broken – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. I was going to step through the installation of the Web… Continue Reading Ian Grieve’s Article on...

Read More
Installing TortoiseSVN: Commit Changes – azurecurve
Oct27

Installing TortoiseSVN: Commit Changes – azurecurve

This post is part of the series on installing TortoiseSVN which is I use in the development of WordPress plugins. Once you’ve finished making the required changes to the plugin, the files need to be uploaded to the plugin repository; the example I am using in this post, is some changes I made to the azurecurve Floating Featured Image plugin. To upload the changes, right-click on the… Continue Reading Ian Grieve’s Article...

Read More
Management Reporter vs. Jet Reports – azurecurve
Oct26

Management Reporter vs. Jet Reports – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Install Web Client Resource Cache – azurecurve
Oct26

Install Web Client Resource Cache – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Verify Web Management Console Functions – azurecurve
Oct25

Verify Web Management Console Functions – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Verify Web Client – azurecurve
Oct24

Verify Web Client – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. Now that we have the web client installed, prior to allowing… Continue Reading Ian Grieve’s Article...

Read More
Take company offline – JenKuntz.ca
Oct23

Take company offline – JenKuntz.ca

Today’s #TipTuesday is a feature that was introduced in GP 2013 R2: taking a company offline for maintenance or other periodic routines. What is it? This is a feature under the Administration page > System > Utilities area. The purpose of it is simply to prevent users from logging into one or more companies so that you can be working in it exclusively. Why might you do this? The most… Continue Reading Jen Kuntz’s Article...

Read More
Install GP Web Resource Cache – azurecurve
Oct23

Install GP Web Resource Cache – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Install Web Client Help – azurecurve
Oct22

Install Web Client Help – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
GPUG Summit 2018 Recap – JenKuntz.ca
Oct20

GPUG Summit 2018 Recap – JenKuntz.ca

So, I said I wasn’t going to do a recap but here I am. I thought I’d do a very brief wrap-up of my short week. Previous Posts Here are the posts from earlier in the week: Getting Home There were no misadventures getting home, thankfully. It was a long day of travel with a connection via Vancouver. I decided to splurge and pay to upgrade my seat on the Vancouver to Toronto leg and I’m… Continue Reading Jen Kuntz’s Article...

Read More
Checkout from Repository – azurecurve
Oct20

Checkout from Repository – azurecurve

This post is part of the series on installing TortoiseSVN which is I use in the development of WordPress plugins. With TortoiseSVN installed, we can connect to an existing plugin repository; in this example I am using my azurecurve Series Index plugin. After creating the development folder, TortoiseSVN is available from the right-click context menu. Create the development folder, right… Continue Reading Ian Grieve’s...

Read More
Installing the Microsoft Azure Integration Runtime
Oct19

Installing the Microsoft Azure Integration Runtime

The Integration Runtime (IR) is a customer managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments. It was formerly called as Data Management Gateway. It is used by Business Central and Dynamics GP to provide a one-way data synchronization between your on-premises SQL Server hosting your company… Continue Reading Mariano Gomez’s...

Read More
Configure Web Client – azurecurve
Oct19

Configure Web Client – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. After addin the web client runtime feature, the next step is… Continue Reading Ian Grieve’s Article...

Read More
Add Web Client Runtime Feature – azurecurve
Oct18

Add Web Client Runtime Feature – azurecurve

Hands On with Microsoft Dynamics GP 2018 R2: Add Web Client Runtime Feature Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live… Continue Reading Ian Grieve’s Article...

Read More
GPUG Summit 2018 Day 2 – JenKuntz.ca
Oct18

GPUG Summit 2018 Day 2 – JenKuntz.ca

Today was day 2 of the official portion of GPUG Summit 2018 in Phoenix, and my last day here. I’m flying out early Thursday to head back home, missing the 3rd day (so there will be no recap from me about it!). Here is how my day fared today… Breakfast & Bad News Breakfast was horrible today, for more than one reason. The food today was just not great. Yesterday’s wasn’t outstanding… Continue Reading Jen Kuntz’s...

Read More
Web Client Prerequisites – azurecurve
Oct17

Web Client Prerequisites – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. Over the next few posts I’m going to install, verify and… Continue Reading Ian Grieve’s Article on...

Read More
GPUG Summit 2018 – Day 1 – JenKuntz.ca
Oct17

GPUG Summit 2018 – Day 1 – JenKuntz.ca

Today was day 1 of GPUG Summit in Phoenix. Not much happened today… LOL… ya right! This year is the first year where there was content for the Power Platform (Microsoft Flow, PowerApps and Power BI). Today I took full advantage of that as it is predominantly new content for me and a chance to learn new things that aren’t necessarily Dynamics GP related. As I do with other events,… Continue Reading Jen Kuntz’s Article on...

Read More
How to follow a conference or event – JenKuntz.ca
Oct16

How to follow a conference or event – JenKuntz.ca

Today’s #TipTuesday is another non-product tip, but I’ll be knee-deep in sessions at GPUG Summit by the time many of you read this, so in the interest of a “simpler” topic, this is what I’ve come up with! Today is the first “full” day of the 2018 GPUG (& other UGs) Summit. I get the sense that a lot of users tend to miss out on the news or updates because they aren’t on… Continue Reading Jen Kuntz’s Article on their...

Read More
eConnect Incoming Queue Bug Fixed – azurecurve
Oct16

eConnect Incoming Queue Bug Fixed – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. This post is for those people who skipped Microsoft Dynamics… Continue Reading Ian Grieve’s Article...

Read More
eConnect Services and Permissions – azurecurve
Oct16

eConnect Services and Permissions – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. With eConnect installed on the server there are some changes… Continue Reading Ian Grieve’s Article...

Read More
GPUG Summit 2018 Pre-Day – JenKuntz.ca
Oct15

GPUG Summit 2018 Pre-Day – JenKuntz.ca

Today was a “long” day but a short day at GPUG Summit. This year’s conference is in Phoenix, Arizona. I originally wasn’t planning on attending, so my time here is short due to the length of my stay being primarily a factor of the cost of the flights I could find to get here! Travel Day There is not much of interest on my flights today. The only funny item was the start of the day… Continue Reading Jen Kuntz’s Article on...

Read More
Install eConnect on Server – azurecurve
Oct15

Install eConnect on Server – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. As mentioned in the last post, on the eConnect Prerequisites,… Continue Reading Ian Grieve’s Article...

Read More
Dynamics GP is on docs.microsoft.com! – JenKuntz.ca
Oct14

Dynamics GP is on docs.microsoft.com! – JenKuntz.ca

Great news! Dynamics GP documentation is starting to make its way onto the docs.microsoft.com platform. That is AWESOME! So many of us have been vocal about the lack of updated documentation and this is a good first step about addressing that IMHO. Why is this so great? Take a look at all of the other Microsoft products and services that already have documentation on this platform! It’s… Continue Reading Jen Kuntz’s...

Read More
Installing TortoiseSVN: Installing – azurecurve
Oct13

Installing TortoiseSVN: Installing – azurecurve

This post is part of the series on installing TortoiseSVN which is I use in the development of WordPress plugins. The first step in installing TortoiseSVN is to download the latest version. You can download it from the TortoiseSVN website: Once you’ve downloaded the file, run the inmstaller and, on the Welcome screen, click Next: Accept the terms of the End-User License Agreement by… Continue Reading Ian Grieve’s Article...

Read More
Install eConnect Prerequisites on Server – azurecurve
Oct12

Install eConnect Prerequisites on Server – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series iof posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. I have a number of clients using eConnect in different ways… Continue Reading Ian Grieve’s Article...

Read More
Create A Company – azurecurve
Oct11

Create A Company – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series iof posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. As I work with many clients with more than one company in… Continue Reading Ian Grieve’s Article on...

Read More
Desktop Client First Run – azurecurve
Oct10

Desktop Client First Run – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series iof posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. With the Fabrikam sample company deployed, we can now log… Continue Reading Ian Grieve’s Article on...

Read More
Two Factor Authentication, part 2 – JenKuntz.ca
Oct09

Two Factor Authentication, part 2 – JenKuntz.ca

Today’s #TipTuesday is a continuation of last week’s first post on Two Factor Authentication, 2FA for short. Today I am not getting into examples, as I found an interesting article last week after posting my first blog, that illustrates some of why 2FA and password managers are important. Instead of trying to document what already exists, I focused on some other things in this post and… Continue Reading Jen Kuntz’s Article...

Read More
Add Sample Company – azurecurve
Oct09

Add Sample Company – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series iof posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. In the last post, I deployed the system database; I’m… Continue Reading Ian Grieve’s Article on...

Read More
GP & Intelligent Cloud – first impressions – JenKuntz.ca
Oct09

GP & Intelligent Cloud – first impressions – JenKuntz.ca

Last week, Dynamics GP 2018 R2 was released and the first thing I did was check out and set up the replication with the Intelligent Cloud. I’ve tried a few more things, with somewhat minimal success, which means I need to do some more learning around how to navigate Business Central. In the meantime, here are a few tips around replication that I have figured out, and where I’m at with… Continue Reading Jen Kuntz’s Article...

Read More
Provisioning a Microsoft Dynamics 365 Business Central demo tenant
Oct08

Provisioning a Microsoft Dynamics 365 Business Central demo tenant

With the release of Microsoft Dynamics GP 2018 R2, I had a first look at the update process, then quickly ran into a situation where the option to set up intelligent cloud insights wasn’t showing in my already provisioned Microsoft Dynamics 365 Business Central tenant – See, “Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants. I also noted that… Continue...

Read More
Deploy System Database – azurecurve
Oct08

Deploy System Database – azurecurve

Microsoft Dynamics GP 2018 R2 was released on the 2nd October. In this series iof posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering. The series index will automatically update as posts go-live in this series. With the first first client now installed we need to deploy… Continue Reading Ian Grieve’s Article...

Read More