Dynamics GP & Office 365 – JenKuntz.ca
Jun25

Dynamics GP & Office 365 – JenKuntz.ca

Today’s #TipTuesday is a post about Office 365 and Dynamics GP and is specific to email functionality such as emailing Purchase Orders, EFT Remittances and Sales Documents. Rest assured that most other functionality other than email seems straight-forward and works no matter what (like exporting from Smartlist). (At least that’s my experience although there may be exceptions I am… Continue Reading Jen Kuntz’s Article on...

Read More
DAX 101 – Wrap up in Microsoft Power BI
Jun24

DAX 101 – Wrap up in Microsoft Power BI

In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expressions: Net Margin = SUM(‘Sales Line Items'[Gross… Continue Reading Belinda Allen’s Article...

Read More
Outlook credentials issue – JenKuntz.ca
Jun19

Outlook credentials issue – JenKuntz.ca

A little while ago, I was trying to add one of my Office 365 email accounts back to Outlook and it wasn’t working. I forgot that I needed an app password because I have MFA (Multi-factor authentication) enabled on my domain/tenant. I initially put in my “regular” password and was expecting it to kick back and let me try again; however, it didn’t do that. Adding an account… Continue Reading Jen Kuntz’s Article on their...

Read More
Using DAX Measures across multiple Queries in Microsoft Power BI
Jun17

Using DAX Measures across multiple Queries in Microsoft Power BI

  In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure creates the Salesperson Commission amount.  To achieve this, I’ll have to multiply two fields together that reside in different queries. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Commission :=… Continue Reading Belinda Allen’s Article...

Read More
No Canadian Payroll 2019 Mid-Year Tax Update! – JenKuntz.ca
Jun11

No Canadian Payroll 2019 Mid-Year Tax Update! – JenKuntz.ca

There’s no #TipTuesday today since I had website issues over the weekend and was unable to access it to prepare something. So, this will be a form of a tip in lieu of another topic! There will be no mid-year tax update for Canadian Payroll for Dynamics GP this year, zippo, nada, zilch! Imagine that, not a single jurisdiction has a tax change this mid-year. That’s got to be a… Continue Reading Jen Kuntz’s Article on their...

Read More
Using DAX Measures that Counts the number of Invoices in Microsoft Power BI
Jun10

Using DAX Measures that Counts the number of Invoices in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to count the number of Invoices.  The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX… Continue Reading Belinda Allen’s Article...

Read More
The Dynamics GP Blogster: #PowerApps: Componentizing Google Maps
Jun09

The Dynamics GP Blogster: #PowerApps: Componentizing Google Maps

Hi PowerAppers!PowerApps Canvas Apps Components remain one of those features that seem to have endless possibilities. I have, for quite some time now, been working with the Google Maps API in many of my applications to return a static image pointing to a specific location on the map.As I moved from application to application, I noticed that I always ended up doing the same operations: format… Continue Reading Mariano...

Read More
Making Tooltips easier to read in Microsoft Power BI
Jun07

Making Tooltips easier to read in Microsoft Power BI

In this video, I’ll show you how to format Tooltips in a Microsoft Power BI visual to make them easier on the eyes.  The default of white letters on a black background can be difficult to read.  This 2-minute video will show you simple changes that make tooltips more powerful!

Read More
‘The requested operation could not be completed due to a file system limitation’ – azurecurve
Jun06

‘The requested operation could not be completed due to a file system limitation’ – azurecurve

When I joined ISC Software I received a new laptop which was pretty much a blank slate except for Windows itself. This meant that I had to install and configure everything I needed (I prefer this as it means I can configure everything exactly as I want it). Due to having an SSD, instead of an HDD, in the laptop, I also got an external SSD which I am using for hosting my virtual machines… Continue Reading Ian Grieve’s...

Read More
PowerShell to Promote Domain Controller – azurecurve
Jun05

PowerShell to Promote Domain Controller – azurecurve

When 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… Continue Reading Ian Grieve’s Article on...

Read More
Back to consulting! – JenKuntz.ca
Jun05

Back to consulting! – JenKuntz.ca

There’s an expression “you can take the girl out of consulting but you can’t take the consulting out of the girl”. OK, so that’s not really how that goes, but it fits the situation! As of June 1st (2019), I’m resuming my consulting business – Kuntz Consulting Inc. – and am back to being a Microsoft partner and independent consultant. This is so new that I haven’t even… Continue Reading Jen Kuntz’s Article on their...

Read More
Are you using what you’ve purchased? – JenKuntz.ca
Jun05

Are you using what you’ve purchased? – JenKuntz.ca

Today’s #TipTuesday isn’t a technical tip, it’s more of a business tip. I’ve written this to be specific to Dynamics GP, although what I describe may apply to other applications and software licensing. I have not worked with licensing on any other ERP packages to know if this might be a general rule of thumb or not. If you’ve been using Dynamics GP for any length of time, it… Continue Reading Jen Kuntz’s Article on their...

Read More
SQL Stored Procedure to Generate Sequential Number – azurecurve
Jun04

SQL Stored Procedure to Generate Sequential Number – azurecurve

While much of the work I do is directly with Microsoft Dynamics GP, I also do work for clients which isn’t directly related. I’ve created code to generate numbers a few times in the past and figured I might as well post the base code I use for this to make it easier to find in future. I’ve created it in such a way that several unique numbers can be stored and incremented. The first… Continue Reading Ian Grieve’s Article on...

Read More
Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI
Jun03

Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI

  In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to calculate the total sales price.  Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together.  Look at the two examples below and… Continue Reading Belinda Allen’s Article...

Read More
Add Company Access Back to sa User – azurecurve
Jun03

Add Company Access Back to sa User – azurecurve

We’re busy doing some work for a client for whom we’ve recently taken over the support of their Microsoft Dynamics GP implementation. For the initial set of projects, we’re assisting them in the creation of a standalone test systemm. When you do this, the first thing you need to do is log in using the sa account and reset passwords. However, we found that at some point in the past,… Continue Reading Ian Grieve’s Article on...

Read More
Prepare New SD Card For Raspberry Pi OS: Conclusion – azurecurve
Jun01

Prepare New SD Card For Raspberry Pi OS: Conclusion – 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
Copy Files To The SD Card – azurecurve
May31

Copy Files To The SD Card – 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
Creating a Conditional Title with DAX in Microsoft Power BI
May31

Creating a Conditional Title with DAX in Microsoft Power BI

In this Video, I’ll use DAX to make a visual Title be conditional based on a selection in a filter, using Microsoft Power BI.

Read More
Find SQL Function In All Databases – azurecurve
May31

Find SQL Function In All Databases – azurecurve

I did a few posts back in 2016 on finding objects in SQL (a column in all tables, =’https://www.azurecurve.co.uk/2016/02/find-all-custom-sql-objects-in-database/’>all custom sql objects in a database and trigger in all databases). I needed to find if a function existed in all databases, so I produced the following script which searches in all Microsoft Dynamics GP databases: — drop… Continue Reading Ian...

Read More
Prepare New SD Card For Raspberry Pi OS: Download NOOBS – azurecurve
May30

Prepare New SD Card For Raspberry Pi OS: Download NOOBS – 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
Is there a POP Historical Received Not Invoiced Report Available? – azurecurve
May30

Is there a POP Historical Received Not Invoiced Report Available? – azurecurve

I’ve had a couple of people recently ask if it is possible to get a historical version of the Shipments Received but not invoiced* SmartList favourite (located under . Within SmartList, this is not possible as the point-in-time calculations required for a historical report are too complex for a SmartList, even one driven by a view. While historically this report wasn’t available in… Continue Reading Ian Grieve’s Article on...

Read More
Format SD Card – azurecurve
May29

Format SD Card – 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
Tips on using the Matrix Visual in Microsoft Power BI
May29

Tips on using the Matrix Visual in Microsoft Power BI

In this Video, I’ll show you some tips on using the Microsoft Power BI visual.  I’ll build a GL Account Summary Matrix by month.  

Read More
Currency ID Missing From Batches Integrated Via eConnect – azurecurve
May29

Currency ID Missing From Batches Integrated Via eConnect – azurecurve

We’ve been doing some work with a client recently creating a number of integrations in SmartConnect. One of these was creating General Journals into a consolidation company from other Microsoft Dynamics GP databases. Everything looked fine from a SmartConnect perspective; success reported for the integration and no warnings or errors. However, when we looked at the resulting journal,… Continue Reading Ian Grieve’s Article...

Read More
Install SD Card Formatter – azurecurve
May28

Install SD Card Formatter – 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
Excel Paste Special – Operations – JenKuntz.ca
May28

Excel Paste Special – Operations – JenKuntz.ca

Today’s #TipTuesday is an Excel tip. Did you know there are some funky Paste Special options beyond the basics like Paste Values, Paste Formats etc.? I find if you were to ask most Excel users what Paste Special is, the majority will answer “pasting values instead of formulas”. While that’s definitely true, there are also Paste Operations. There are random circumstances where… Continue Reading Jen Kuntz’s Article on their...

Read More
Using Divide in a DAX Measures in Microsoft Power BI
May28

Using Divide in a DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Gross Margin % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)  

Read More
Implementing SmartList Builder: Review – azurecurve
May28

Implementing SmartList Builder: Review – azurecurve

This post is part of the series on Implementing SmartList Builder from eOne Solutions. Of all of the ISV products I have used with Microsoft Dynamics GP, SmartList Builder is the one I have worked with the longest, and is the one I like the most (looking back I’m surprised it’s taken me this long to do a series like this). It is easy to use, flexible and far better at creating new… Continue Reading Ian Grieve’s Article on...

Read More
Download SD Card Formatter – azurecurve
May27

Download SD Card Formatter – 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
Implementing SmartList Builder: Security – azurecurve
May27

Implementing SmartList Builder: Security – azurecurve

This 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… Continue Reading Ian Grieve’s Article...

Read More
Prepare New SD Card For Raspberry Pi OS: Series Index – azurecurve
May26

Prepare New SD Card For Raspberry Pi OS: Series Index – 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
What Else Can I Use It For? – azurecurve
May25

What Else Can I Use It For? – 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
Using Pi-hole On A Raspberry Pi: Conclusion – azurecurve
May24

Using Pi-hole On A Raspberry Pi: Conclusion – 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
Treemap Bar Chart in Microsoft Power BI
May24

Treemap Bar Chart in Microsoft Power BI

In this video, I’ll use a new custom visual called the Treemap Bar Chart.  It’s like the baby of the Clustered Column Visual and the Treemap Visual.  This was created by MAQ Software. https://maqsoftware.com/

Read More
Implementing SmartList Builder: Register – azurecurve
May24

Implementing SmartList Builder: Register – 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
Updating the Pi-hole – azurecurve
May23

Updating the Pi-hole – 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
Download and Install – azurecurve
May23

Download and Install – azurecurve

This post is part of the series on Implementing SmartList Builder from eOne Solutions. SmartList Builder is downloaded direct from the eOne Solutions website as a zip file: Once yu’ve downloaded the zip file, launch the installer and, on the Welcome screen click Next: Accept the terms of the End-User License Agreement and click ,em>Next: Verify the installation folder and click… Continue Reading Ian Grieve’s Article on...

Read More
Connecting With SSH – azurecurve
May22

Connecting With SSH – 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
Line Chart Formatting in Microsoft Power BI
May22

Line Chart Formatting in Microsoft Power BI

 In this video, I demonstrate formatting the Microsoft Power BI Line Chart visual.  

Read More
SmartList Builder vs. SmartList Designer – azurecurve
May22

SmartList Builder vs. SmartList Designer – azurecurve

This post is part of the series on Implementing SmartList Builder from eOne Solutions. As mentioned in the last post SmartList Builder was directly sold by Microsoft under a licensing agreement for many years until, with the launch of Microsoft Dynamics GP 2013 SP2, the product was released back to the original ISV; a Fargo based ISV called eOne SOlutions. I understand this was because… Continue Reading Ian Grieve’s...

Read More
Change DNS Servers – azurecurve
May21

Change DNS Servers – 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
How to set a longer password on Office 365 – JenKuntz.ca
May21

How to set a longer password on Office 365 – JenKuntz.ca

This is a belated #TipTuesday, posted a day later than usual! Recently, support for longer passwords in Office 365 was announced but oddly enough, in some places the password change dialog boxes still limit you to 16 characters. Here’s how I worked around this. Standard “password reset” feature – 16 char limit Here’s a screenshot of a password reset window in my Office 365… Continue Reading Jen Kuntz’s Article on their...

Read More
What is SmartList Builder? – azurecurve
May21

What is SmartList Builder? – azurecurve

This post is part of the series on Implementing SmartList Builder from eOne Solutions. Before launching into the installation of SmartList Builder, I thought it might be worthwhile to do a post on what it is. All users of Microsoft Dynamics GP will be familiar with SmartList; this is the flexible reporting tool which allows you to generate a report showing a list of master records or… Continue Reading Ian Grieve’s Article...

Read More
Using Pi-hole On A Raspberry Pi: Maintain Blocklists – azurecurve
May20

Using Pi-hole On A Raspberry Pi: Maintain Blocklists – 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
Creating DAX Measures in Microsoft Power BI
May20

Creating DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data. Today’s DAX Expression: Gross Margin % := SUM(‘Sales Line Items'[Gross Margin]) / SUM(‘Sales Line Items'[Total Sales])

Read More
Implementing SmartList Builder: Series Index – azurecurve
May20

Implementing SmartList Builder: Series Index – azurecurve

I’ve posted series on a few different ISV addons for Microsoft Dynamics GP over the last few years, but, somewhat ironically I guess, have not posted all that much about the addin I’ve used the most over the years. That addin is SmartList Builder from eOne Solutions. SmartList Builder allows you to create both brand new SmartLists or modify existing SmartList. You can link up to 32… Continue Reading Ian Grieve’s Article on...

Read More
Using Pi-hole On A Raspberry Pi: Update Blocklists – azurecurve
May19

Using Pi-hole On A Raspberry Pi: Update Blocklists – 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
Whitelisting a Site – azurecurve
May18

Whitelisting a Site – azurecurve

This post is part of the series on using the Pi-hole; this series is a sub-series of the Adventures with a Raspberry Pi. When using a Pi-hole to block adverts, you will come across sites which you want to access, but which are being blocked. The message you will see is not readily apparent that the site has been blocked by the Pi-hole: This is because the error message is displayed by… Continue Reading Ian Grieve’s Article...

Read More
Using Pi-hole On A Raspberry Pi: Disabling Pi-hole – azurecurve
May17

Using Pi-hole On A Raspberry Pi: Disabling Pi-hole – azurecurve

This post is part of the series on using the Pi-hole; this series is a sub-series of the Adventures with a Raspberry Pi. While the Pi-hole has worked very well, there are times when I’ve had issues and wondered if it was the Pi-hole causing them. One of the good features of the Pi-hole is that it is very easy to temporarily disable it, which allows you to either easily rule out the… Continue Reading Ian Grieve’s Article on...

Read More
Adding the Fields to a Visual’s Tooltips in Microsoft Power BI
May17

Adding the Fields to a Visual’s Tooltips in Microsoft Power BI

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.  

Read More