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
Could You Contribute To ClassicPress? – azurecurve
May04

Could You Contribute To ClassicPress? – azurecurve

When Gutenberg for WordPress was released I did try to use it, but found it was unusable. Instead I started taking a look at ClassicPress and liked what I saw. I eventually started planning to migrate my sites from WordPress to ClassicPress and outlined my reasons for doing so. I have also invested some time in creating new versions of my plugins for ClassicPress; these plugins are either… Continue Reading Ian Grieve’s...

Read More
Install Operating System – azurecurve
May03

Install Operating System – 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. With the Raspberry Pi built it is time to install the operating system. The SD Card which arrives in the starter kit from Canakit is already loaded with NOOBS, which is an easy operating system installer which contains Raspbian and LibreELEC; it also provides a… Continue Reading Ian Grieve’s...

Read More
Test SalesHQ Portal – azurecurve
May03

Test 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. Once I have SalesHQ deployed and salespeople and/or customers with access, I run a quick test to make sure I can log into the portal. Navigate to the web address you supplied during the implementation (I didn’t use a custom address so have a… Continue Reading Ian Grieve’s...

Read More
Raspberry Pi Build – azurecurve
May02

Raspberry Pi Build – 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 build of the Raspberry PI kit is easily the easiest computer build I’ve done. The starter kit from Canakit is contained within a small box (the separate SD Card in the photo was bought in addition to the one which arrived in the box): Within the box… Continue Reading Ian Grieve’s Article...

Read More
Implementing SalesHQ Portal: Customer Setup – azurecurve
May02

Implementing SalesHQ Portal: Customer Setup – 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. With SalesHQ fully deployed, the final step of configuration is to grant customers access sot they can see their account information online. This is done via a window accessible from Customer Maintenance (). To add access for a customer open… Continue Reading Ian Grieve’s...

Read More
CanaKit Raspberry Pi 3 B+ Complete Starter Kit – azurecurve
May01

CanaKit Raspberry Pi 3 B+ Complete Starter Kit – 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. I have no prior experience dealing with the Raspberry PI, so I went the easy route and bought a starter kit from Amazon: This starter kit includes everything necessary for a working Raspberry PI and includes the most recent version of the Raspberry Pi… Continue Reading Ian Grieve’s Article on...

Read More
Implementing SalesHQ Portal: Salesperson Setup – azurecurve
May01

Implementing SalesHQ Portal: Salesperson Setup – 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. With SalesHQ configured, it is now available to use. However, the first thing we need t do is grant access to salespeople so that they are able to log in. From experience, very few clients actually use salespeople in Microsoft Dynamics GP the… Continue Reading Ian Grieve’s...

Read More
The Dynamics GP Blogster: #MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs
Apr30

The Dynamics GP Blogster: #MSDYN365BC: Building a Development Environment for Microsoft Dynamics GP ISVs

In the previous 3 articles of the series, I talked about the rationale for selecting a container based environment for development purposes, we also installed Docker and downloaded and installed the Microsoft Dynamics 365 Business Central containers for Docker. This then set us on a path to installing the development IDE and selecting a source code control provider to host our AL… Continue Reading Mariano Gomez’s Article...

Read More
Building The Raspberry Pi: Series Index – azurecurve
Apr30

Building The 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
Originating fields in SmartList – JenKuntz.ca
Apr30

Originating fields in SmartList – JenKuntz.ca

Today’s #TipTuesday is a bit about the “Originating” fields in SmartList, what they are and what you may find in them. These fields are found under the Account Transactions SmartList (under Financial) and in certain circumstances, you will be able to extract *some* subledger information from your G/L to supplement your account analysis. What are they? Here are some of the… Continue Reading Jen Kuntz’s Article on their...

Read More
Implementing SalesHQ Portal: Configure SalesHQ – azurecurve
Apr30

Implementing SalesHQ Portal: Configure SalesHQ – 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. After a company has been registered with SalesHQ and you logout and back in, the menu will update with the menu items for the SalesHQ configuration windows: Open the CustomerHQ Setup window (). There is a number of settings required in, or… Continue Reading Ian Grieve’s Article...

Read More
Adventures With A Raspberry Pi: Series Index – azurecurve
Apr29

Adventures With A Raspberry Pi: Series Index – azurecurve

I’ve looked at the Raspberry Pi a number of times over the years, but never bought one as I both lacked a convincing use case and have virtually zero experience with non-Windows operating systems. However, more recently, I have reached my limit with how intrusive online adverts have become and have finally bought a Raspberry Pi and installed Pi-Hole. I have a number of posts about my… Continue Reading Ian Grieve’s Article...

Read More
Portal Deployment on Azure – azurecurve
Apr29

Portal Deployment on Azure – 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. This is a step which ISC Software will perform, but some information is required for this to be accomplished. In the last post in this series, I showed how to register a company with SalesHQ; this generated a unique GUID for each company. For… Continue Reading Ian Grieve’s...

Read More
Disable Push Notifications In Vivaldi – azurecurve
Apr28

Disable Push Notifications In Vivaldi – azurecurve

There are many irritating features of browsing the web with push notifications being the current one which is bugging the crap out of me. So many sites are asking to allow push notifications and I can rarely, if ever, see any reason why anyone would allow them. I migrated to the Vivaldi browser a while ago which is based on Chromium. This means it has access to the Chrome extensions store… Continue Reading Ian Grieve’s...

Read More
Install New Theme In Notepad++ – azurecurve
Apr27

Install New Theme In Notepad++ – azurecurve

I did a post a little while ago on changing the theme in Notepad++, which was brought about by preferring to use dark themes in a lot of apps (such as Outlook.com and here on azurecurve|Ramblings of a Dynamics GP Consultant). With Notepad++ I’ve found that I don’t actually like any of the default dark themes so took a look round to see if I could add a new one. Fortunately, it is… Continue Reading Ian Grieve’s Article on...

Read More
Client First Run – azurecurve
Apr26

Client First Run – 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. After installing the Microsoft Dynamics GP client component, you need to run Microsoft Dynamics GP as administrator as you will be prompted to include new code; click Yes to do so: The next action needs to be performed once to register each… Continue Reading Ian Grieve’s...

Read More
Install Dynamics GP Client Components – azurecurve
Apr25

Install Dynamics GP Client Components – 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. The client component of SalesHQ allows you to configure the portal and grant access to customers and sales people and so needs to be installed on all Microsoft Dynamics GP client machines. With the file you downloaded from ISC Software’s… Continue Reading Ian Grieve’s Article...

Read More
Start Connector Service – azurecurve
Apr24

Start Connector Service – 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. The final step in configuring the connector service, is to start the Elementz CustomerHQ Connector; if you’ve used an account which is already has log on as a service rights, you will not need to perform this step. To start the service, open… Continue Reading Ian Grieve’s...

Read More
More Changes for VAT in Microsoft Dynamics GP April 2019 Hotfix – azurecurve
Apr23

More Changes for VAT in Microsoft Dynamics GP April 2019 Hotfix – azurecurve

Snuck out just before the Easter bank holidays was a new hotfix with some fixes in for the following in UK VAT: To submit the file to HMRC you had to be logged into Microsoft Dynamics GP as user SA. You may incorrectly receive an error in VAT Daybook Obligation period dates do not match with the VAT Daybook Calendar. VAT submission changes required by HMRC. The post on the Dynamics GP… Continue Reading Ian Grieve’s Article...

Read More