GP Power Tools Build 26 & 27 New Features: New in Build 27: Database Tools Module Enhancements
Jul18

GP Power Tools Build 26 & 27 New Features: New in Build 27: Database Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The fourth area of new features I’m going to cover, is the Database Tools module in which there is one new feature: SQL Login Maintenance window A new SQL Log… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Developer Tools Module Enhancements
Jul17

GP Power Tools Build 26 & 27 New Features: New in Build 27: Developer Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The third area of new features I’m going to cover, is the Developer Tools module in which there are a number of new features: SQL GoTos Triggers against Modal… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Administrator Tools Module Enhancements
Jul15

GP Power Tools Build 26 & 27 New Features: New in Build 27: Administrator Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The second area of new features I’m going to cover, is the Administrator Tools module in which there are a number of new features: Automatic Launch… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: System Module Enhancements
Jul12

GP Power Tools Build 26 & 27 New Features: New in Build 27: System Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The first area of new features I’m going to cover, is the System module in which there are a number of new features: Select logs to capture on startup Show user… Continue Reading...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Series Index
Jul11

GP Power Tools Build 26 & 27 New Features: New in Build 27: Series Index

This post is the series index for the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. In this sub-series I am going to take a look at the new features introduced in build 27; the posts are broken down by module for easy reading. GP… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Database Tools Module Enhancements
Jul10

GP Power Tools Build 26 & 27 New Features: New in Build 26: Database Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The fourth area of new features I’m going to cover, is the Database Tools module in which there are a number of new features: New password length Database… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Developer Tools Module Enhancements
Jul09

GP Power Tools Build 26 & 27 New Features: New in Build 26: Developer Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The third area of new features I’m going to cover, is the Developer Tools module in which there are a number of new features: Publish Script by Users and/or… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Administrator Tools Module Enhancements
Jul08

GP Power Tools Build 26 & 27 New Features: New in Build 26: Administrator Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The second area of new features I’m going to cover, is the Administrator Tools module in which there are a number of new features: Control Features by… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: System Module Enhancements
Jul05

GP Power Tools Build 26 & 27 New Features: New in Build 26: System Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The first area of new features I’m going to cover, is the System module in which there are a number of new features: Window Visibility System Status Report Send… Continue Reading...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Series Index
Jul04

GP Power Tools Build 26 & 27 New Features: New in Build 26: Series Index

This post is the series index for the New in Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. In this sub-series I am going to take a look at the new features introduced in build 26; the posts are broken down by module for easy reading. GP Power Tools Build 26 & 27… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: Changes Since Last Series
Jul03

GP Power Tools Build 26 & 27 New Features: Changes Since Last Series

This post is part of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. One of the key changes to GP Power Tools, is that it is now directly distributed by WinthropDC rather than by a third party. The third party route was taken, I believe, as a quick way to market after David Musgrave

Read More
GP Power Tools Build 26 & 27 New Features: Series Index
Jul02

GP Power Tools Build 26 & 27 New Features: Series Index

There are a large number of ISV products available to extend Microsoft Dynamics GP, and I’ve taken a look at a very few of them recently. One I looked at last year was the GP Power Tools from Winthrop DC< the company of Microsoft MVP David Musgrave. I took a Hands On look at implementing the GP Power Tools product followed by going hands on with two of the modules: System Module Administrator… Continue Reading Ian...

Read More
PowerShell Snippets: Start-Sleep
Jul01

PowerShell Snippets: Start-Sleep

This post is part of the series on PowerShell Snippets. The following PowerShell command will sleep for the supplied number of milliseconds (replace the highlighted section with the number of milliseconds to sleep): Start-Sleep -Milliseconds {milliseconds} Click to show/hide the PowerShell Snippets Series Index PowerShell Snippets Write-Output Start-Sleep (Visited 5 times, 1 visits… Continue Reading Ian Grieve’s Article on...

Read More
PowerShell Snippets: Write-Output
Jun28

PowerShell Snippets: Write-Output

This post is part of the series on PowerShell Snippets. The following PowerShell command will output the supplied message to the PowerShell console (replace the highlighted section with the message to output): Write-Output {message] Click to show/hide the PowerShell Snippets Series Index PowerShell Snippets Write-Output Start-Sleep (Visited 8 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog PowerShell...

Read More
PowerShell Snippets: Series Index
Jun27

PowerShell Snippets: Series Index

From time to time, I write snippets of PowerShell, which I am going to post into this series for easy recall in future. PowerShell Snippets Write-Output Start-Sleep (Visited 16 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog PowerShell Snippets: Series Index The links in this blog may lead to third-party Web sites to provide access to third-party resources to assist you in finding other services and/or...

Read More
Network Shell Snippets: Delete Bound SSL Certificate
Jun24

Network Shell Snippets: Delete Bound SSL Certificate

This post is part of the series on Network Shell Snippets. The following Network Shell command will delete the bound SSL certificate: netsh http delete sslcert ipport=0.0.0.0:28666 Change the highlighted section to the port number to which the SSL certificate is bound. Click to show/hide the Network Shell Snippets Series Index Network Shell Snippets View URL Reservations Delete URL… Continue Reading Ian Grieve’s Article on...

Read More
Network Shell Snippets: Delete URL Reservation
Jun21

Network Shell Snippets: Delete URL Reservation

This post is part of the series on Network Shell Snippets. The following Network Shell command will delete the specified URL reservations: netsh http delete urlacl URL={reserved url} Replace the highlighted section, including the curly brackets, with the URL reservation to be removed. Click to show/hide the Network Shell Snippets Series Index Network Shell Snippets View URL… Continue Reading Ian Grieve’s Article on their...

Read More
Network Shell Snippets: View URL Reservations
Jun20

Network Shell Snippets: View URL Reservations

This post is part of the series on Network Shell Snippets. The following Network Shell command will list all URL reservations: netsh http show urlacl Click to show/hide the Network Shell Snippets Series Index Network Shell Snippets View URL Reservations Delete URL Reservation Delete Bound SSL Certificate (Visited 9 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog Network Shell Snippets: View URL...

Read More
Network Shell Snippets: Series Index
Jun19

Network Shell Snippets: Series Index

I have a few Network Shell (netsh) snippets of code which I’ve used recently, which I thought I’d post here. There is nothing complicated in what I am posting, I just need somewhere I can easily locate them again in future. Network Shell Snippets View URL Reservations Delete URL Reservation Delete Bound SSL Certificate (Visited 10 times, 1 visits today) Continue Reading Ian Grieve’s Article on their blog...

Read More
PowerShell for Hyper-V: Resume VM
Jun18

PowerShell for Hyper-V: Resume VM

This post is part of the series on PowerShell for Hyper-V. The following PowerShell command can be used to resume a suspended virtual machine (replace the highlighted section with the name of your virtual machine): Resume-VM -Name {VM name} Click to show/hide the PowerShell for Hyper-V Series Index PowerShell for Hyper-V Avoid Error Running PowerShell Scripts Start VM Shut Down VM

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