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
SQL Function to Remove Alphanumeric Characters – azurecurve
May17

SQL Function to Remove Alphanumeric Characters – azurecurve

I created a customisation recently for a client which would generate a Vendor ID based on the name, by removing alphanumeric characters. In order to make it as flexible as possible, I created the function to accept a parameter for type which will cause the function to strip different characters: A – leaves alpha characters only. N – leaves numeric characters only. AN – leaves… Continue Reading Ian Grieve’s Article on their...

Read More
Using Pi-hole On A Raspberry Pi: Admin Interface – azurecurve
May16

Using Pi-hole On A Raspberry Pi: Admin Interface – 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
IIS Rewrite Rule for Redirect to Directory – azurecurve
May16

IIS Rewrite Rule for Redirect to Directory – azurecurve

The web hosat I am currently with allows multiple domains, but only 6 websites; this means I have to be a little creative sometimes when creating additional sites. I actually have a lot more than six websites being hosted on my account, due to a mix of WordPress MU and redirects to folders. The redirect is done using an IIS rewrite rule. As I may be moving web host soon, I’m posting… Continue Reading Ian Grieve’s Article...

Read More
Using Pi-hole On A Raspberry Pi: Blocked Adverts – azurecurve
May15

Using Pi-hole On A Raspberry Pi: Blocked Adverts – 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
Adding the Q&A Visual in Microsoft Power BI
May15

Adding the Q&A Visual in Microsoft Power BI

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.  

Read More
Disable AutoSave OneDrive and SharePoint Online Files by Default on Excel – azurecurve
May15

Disable AutoSave OneDrive and SharePoint Online Files by Default on Excel – azurecurve

I recently got a new laptop at work which meant getting all applications installed. Previously I’d had Microsoft Office 2016 installed; on the new laptop I got Microsoft Office 365 which came with AutoSave enabled by default in all of the applications, such as Excel and Word, for files opened from SharePoint Online: You can switch off AutoSave using the slider at the top, but this is not… Continue Reading Ian Grieve’s...

Read More
Using Pi-hole On A Raspberry Pi: Series Index – azurecurve
May14

Using Pi-hole On A Raspberry Pi: 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
SQL Alerts with HTML email body – JenKuntz.ca
May14

SQL Alerts with HTML email body – JenKuntz.ca

Today’s #TipTuesday is a bit different from my normal type of post. In the course of monitoring some integrations, I had wanted to change the emails I get when there were issues. What I inherited was email alerts with attachments, without any data that I could use as an Outlook filter to tell me if something was ok or not. I had to open the attachment to see if there were errors. I… Continue Reading Jen Kuntz’s Article on...

Read More
This Workflow Is Locked By Another User And Cannot Be Edited – azurecurve
May14

This Workflow Is Locked By Another User And Cannot Be Edited – azurecurve

I was onsite recently with a client making a Workflow project live and encountered a lock on the workflow we needed to amend. There were no users logged into the company so we knew the lock was an orphaned one. “This workflow is locked by another user and cannot be edited. Please try again later.” The locks on Workflow are stored in the Workflow User Security (WF00104) table; when… Continue Reading Ian Grieve’s...

Read More
Configure Network to use Pi-hole – azurecurve
May13

Configure Network to use 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
Creating DAX Columns in Microsoft Power BI
May13

Creating DAX Columns in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  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 = ‘Sales Line Items'[Total Sales] – ‘Sales Line Items'[Total Costs]

Read More
SQL Script to Delete Unused Segments – azurecurve
May13

SQL Script to Delete Unused Segments – azurecurve

While the General Ledger Year-End Close routine can delete unused segments, during implementation, or creation of new companies , we sometimes end up with segments created which are not needed. The below script can be used to remove all segments not assigned to an account (segments which have been used will not be removed). The script allows the user to define which segment should be… Continue Reading Ian Grieve’s Article...

Read More
Change Pi-hole Admin Password – azurecurve
May12

Change Pi-hole Admin Password – azurecurve

This post is part of the series on building my new Raspberry Pi; this series is a sub-series of the Adventures with a Raspberry Pi. In the last post, I stepped through the installation of the Pi-hole software on a Raspberry Pi. It will install with a admin password provided which you can change (and I would recommend you do so). You can change the password by logging into your Raspberry… Continue Reading Ian Grieve’s...

Read More
In search of the perfect credit card – JenKuntz.ca
May12

In search of the perfect credit card – JenKuntz.ca

A few months ago, I started re-evaluating the credit cards I was using, and checking into the benefits they offer. I was planning a big trip and have never really paid attention too much to the benefits other than the basic rewards they offer (cash back or travel points in various programs etc.). I knew friends who had used some of the warranty extension kinds of benefits, but that’s… Continue Reading Jen Kuntz’s Article...

Read More
Installing Pi-hole On A Raspberry Pi: Install Pi-hole – azurecurve
May11

Installing Pi-hole On A Raspberry Pi: Install Pi-hole – azurecurve

This post is part of the series on building my new Raspberry Pi; this series is a sub-series of the Adventures with a Raspberry Pi. Installing the Pi-hole was something which I was quite concerned about doing. A week or so before I boguth my Pi-hole I mentioned Pi-hole on Twitter and a friend had a go at installing it on an unsed Raspberry Pi he had. He actually had quite a few problems… Continue Reading Ian Grieve’s...

Read More
Edge Canary: Series Index – azurecurve
May11

Edge Canary: Series Index – azurecurve

Microsoft have recently announced they are ditching the current version of their Edge browser in favour of a Chromium based browser. In this series, I am going to take a look at the Canary version of this new browser. If you’re reading this post on azurecurve, the index below will automatically update, otherwise you need to check back on the original post. Browsers, Edge, Edge Canary: Series Index – azurecurveBlog Syndicated with Ian...

Read More
What is Pi-hole? – azurecurve
May10

What is Pi-hole? – azurecurve

This post is part of the series on installing Pi-hole on a Raspberry Pi; this series is a sub-series of the Adventures with a Raspberry Pi. Before launching into the installation of Pi-hole, I thought it might be useful to explain what a Pi-hole is and why you might want to use one. From Wikipedia Pi-hole is a Linux network-level advertisement and Internet tracker blocking application… Continue Reading Ian Grieve’s Article...

Read More
Find Table in All Microsoft Dynamics GP Databases – azurecurve
May10

Find Table in All Microsoft Dynamics GP Databases – azurecurve

I was doing some work with a client recently with a custom extension being tested in some Microsoft Dynamics GP companies. Due to how it is deployed (very manually) we had only deployed it to some databases and not all. Due to other project commitments, no testing was done for a while and when we returned, we weren’t sure if the deployment notes listed all databases correctly or if some… Continue Reading Ian Grieve’s...

Read More
Installing Pi-hole On A Raspberry Pi: Series Index – azurecurve
May09

Installing Pi-hole On A Raspberry Pi: 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
Dynamics GP vs Dynamics 365 Business Central
May09

Dynamics GP vs Dynamics 365 Business Central

  Dynamics GP vs Dynamics 365 Business Central ” Incremental Group For small and medium businesses (SMBs) looking for a new ERP finance solution, there are two options currently available from Microsoft, Dynamics GP and Dynamics 365 Business Central. Dynamics 365 Business Central was only released in 2018 and is a next generation business application built on the cloud and full of new...

Read More
Can I Create a Temp Table With Collation Different to the Server Collation? – azurecurve
May09

Can I Create a Temp Table With Collation Different to the Server Collation? – azurecurve

As with virtually all headlines containing a question, the short answer is no. From the research I have done, the temp table will always be created with the collation of the SQL Server. If you want to skip to the solution, click here. Why would you want a different collation? Well, in this case we need a different collation as there is a third party database which a customisation in… Continue Reading Ian Grieve’s Article...

Read More
Building The Raspberry Pi: Conclusion – azurecurve
May08

Building The 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
SQL Script to Insert Vendors – azurecurve
May08

SQL Script to Insert Vendors – azurecurve

While writing a Rockton Software’s SmartFill product recently, I wanted to do a test on a large dataset. The testing of SmartFill I had done to that point had been on vendors, so I deviced to continue in that vein. I produced the script below which inserts records into the PM Vendor Master File (PM00200) and PM Address MSTR (PM00300) tables bgy copying an existing vendor, but assigning… Continue Reading Ian Grieve’s...

Read More
SmartList stuck on My Reports pane – JenKuntz.ca
May08

SmartList stuck on My Reports pane – JenKuntz.ca

Today’s #TipTuesday post is about troubleshooting an issue with the My Reports home page area/pane and how to remove SmartList favourites from there. The specific scenario here related to favourites that were “stuck” in MyReports after an upgrade to GP 2013 a few years ago. I was reminded of this when I saw this post on the Microsoft Dynamics community forum and someone asked me if I… Continue Reading Jen Kuntz’s Article...

Read More
Securing the Raspberry Pi – azurecurve
May07

Securing the Raspberry Pi – 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 SalesHQ Portal: Conclusion – azurecurve
May07

Implementing SalesHQ Portal: Conclusion – azurecurve

This post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions. I realise working for the company who created and sells the Sales HQ portal prevents me from being a neutral reviewer, so I won’t try to offer a conclusion as I have been doing on recent series. Instead I’ll leave you with a quick recap of… Continue Reading Ian Grieve’s Article...

Read More
Dynamics GP Support and Enhancement for Existing GP Clients – Free Assessment
May06

Dynamics GP Support and Enhancement for Existing GP Clients – Free Assessment

Throughout the previous years of implementing and supporting Dynamics GP, I have worked in several complex environments with quite complicated business needs, although, Dynamics GP has always proved how strong and powerful business solution it can be for small and medium sized companies. Dynamics GP has a long history not only as a financial but also as a management solution to automate and… Continue Reading Dynamics GP...

Read More
Enable SSH For Remote Access – azurecurve
May06

Enable SSH For Remote Access – 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 SalesHQ Portal – azurecurve
May06

Using SalesHQ Portal – azurecurve

This post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions. Over the course of this series, I’ve taken a look at how SalesHQ is implemented. I thought it would be useful to do a post on actually using SalesHQ, but first a reminder that earlier in the series I did a post on What SalesHQ is and what… Continue Reading Ian Grieve’s Article...

Read More
System Configuration Tool – azurecurve
May05

System Configuration Tool – azurecurve

This post is part of the series on building my new Raspberry Pi; this series is a sub-series of the Adventures with a Raspberry Pi. The first time you start the Raspberry Pi, it will automatically load the System Configuration Tool; this is where you can change a number of settings like the password, language or network settings. I’m going to run throuhg the settings I changed, starting… Continue Reading Ian Grieve’s...

Read More
Building The Raspberry Pi: First Run – azurecurve
May04

Building The Raspberry Pi: 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