‘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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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