Using No-IP For External Access With a Dynamics IP Address: Installing No-IP Client
Feb25

Using No-IP For External Access With a Dynamics IP Address: Installing No-IP Client

This post is part of the short series on using Using No-IP For External Access With a Dynamics IP Address. With a No-IP account created with No-IP the next, and final, step is to install the Dynamic DNS Update Client. This does updates on a paeriodic basis to keep your current IP address in sync with your No-IP host or domain. The client can be downloaded from here: Once downloaded run the… Continue Reading Ian Grieve’s...

Read More
Using No-IP For External Access With a Dynamics IP Address: Creating An Account
Feb22

Using No-IP For External Access With a Dynamics IP Address: Creating An Account

This post is part of the short series on using Using No-IP For External Access With a Dynamics IP Address. Signing up to No-IP for a free account is nice and easy to do. Using the browser of your choice, navigate to https://www.noip.com, enter the hostname you want and select the domain from the list of free ones and click the green ,em>Sign Up button: Enter your Email, Password and check the… Continue Reading Ian...

Read More
azurecurve ClassicPress Plugins: Update Admin Menu
Feb21

azurecurve ClassicPress Plugins: Update Admin Menu

This is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is a brand new one written for ClassicPress; Update Admin Menu. Functionality Allows the reorganisation of the ClassicPress admin menu allowing you to move more often used menu entries to the top of the menu. Download The plugin can be… Continue Reading Ian...

Read More
azurecurve ClassicPress Plugins: From Twitter
Feb20

azurecurve ClassicPress Plugins: From Twitter

This is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is a brand new one written for ClassicPress; From Twitter. Functionality Automate the retrieval of tweets from Twitter and create posts on your ClassicPress site From Twitter includes the following functionality; Search Twitter and… Continue Reading Ian Grieve’s...

Read More
Using No-IP For External Access With a Dynamics IP Address: What Is No-IP?
Feb19

Using No-IP For External Access With a Dynamics IP Address: What Is No-IP?

This post is part of the short series on using Using No-IP For External Access With a Dynamics IP Address. No-IP is a service which has been around for quite a long time now (I remember using a competitor of theirs back in 2004 (and possibly earlier) to use an external DNS entry to access a web server I was running at home on a dynamic IP address (my ISP at the time didn’t offer static IP… Continue Reading Ian...

Read More
Using No-IP For External Access With a Dynamics IP Address: Series Index
Feb18

Using No-IP For External Access With a Dynamics IP Address: Series Index

I do a lot of travelling for work and often want to connect to my home system to access a NAS or a computer which has been left on. Unfortunately, I have a dynamic IP address which means the IP address changes whenever the router restarts and, living in rural England, glitches which cause a router restart are not uncommon. The solution to this is to use No-IP; a service I will introduce over… Continue Reading Ian Grieve’s...

Read More
Finding Missing Security Privileges Encountered When Starting Microsoft Dynamics GP
Feb17

Finding Missing Security Privileges Encountered When Starting Microsoft Dynamics GP

I’ve been doing work with a client recently to refrsh their security in Microsoft Dynamics GP. We used the Microsoft Dynamics GP Security Matrixc from Fastpath to get the core security tasks assigned to the relevant roles. However, after security roles were created and testing was done, one user role was received errors when logging into Microsoft Dynamics GP: You don’t have security… Continue Reading Ian...

Read More
Jet Service Tier Windows Service Won’t Start
Feb16

Jet Service Tier Windows Service Won’t Start

I’ve been doing some work with a client recently to implement Jet Reports. We installed the Jet Service Tier to allow the management of data sources in a central repository. However, after installation we were unable to start the service and received an error each time: Error 1067: The process terminated unexpectedly. After doing some investigation, we found that what wasn’t being reported to… Continue Reading Ian...

Read More
Format XML
Feb15

Format XML

I posted a link to a website which will format your SQL code a while back and recently found myself looking for a way of formatting XML code to make it more readable. One of the clients I was working with, had an integration sending data to eConnect to load into Microsoft Dynamics GP, and the XML was coming across as one long string and I needed to make it readable by breaking it over multiple… Continue Reading Ian...

Read More
SQL View Showing Serial Number Allocated to SOP from POP in Microsoft Dynamics GP
Feb12

SQL View Showing Serial Number Allocated to SOP from POP in Microsoft Dynamics GP

A recent project required a report of serial numbers received into Microsoft Dynamics GP on purchase orders and to which sales transaction they’d been allocated. I had a hunt around in my scripts folder and found an old script I’d written which only required some small changes to add the required fields. The script uses INNER JOIN clauses as only assigned serial numbers were wanted, but this… Continue Reading Ian...

Read More
SQL View to Return the Last Restore Date of Microsoft SQL Server Databases
Feb11

SQL View to Return the Last Restore Date of Microsoft SQL Server Databases

This script will create a SQL view to select the last restore date for every database on a Microsoft SQL Server along with the user who performed the restore. It has included a couple of other use columns in the returned data such as the collation_name and compatibility_level: — drop view if it exists IF OBJECT_ID(N’uv_AZRCRVGetLastDatabaseRestoreDate’, N’V’) IS NOT NULL DROP VIEW… Continue Reading...

Read More
SQL Script to Get Assigned Building Block Groups for Companies in Management Reporter
Feb10

SQL Script to Get Assigned Building Block Groups for Companies in Management Reporter

I recently did a Microsoft Dynamics GP and Management reporter upgrade for a client which incuded migrating the databases to a new server. After performing the upgrade, users were unable, in some companies, to see the reports in Management Reporter. When we looked into it, some of the companies had reverted to the Default building block group. To easily identify the companies which had… Continue Reading Ian Grieve’s...

Read More
SQL script to insert emails into Microsoft Dynamics GP
Feb09

SQL script to insert emails into Microsoft Dynamics GP

This is a script I wrote years ago and thought I’d posted it here, but it seems it had never been posted, although I have posted a script to insert test emails against all customers. This script can be used to insert or update email addresses on vendors, customers or items in Microsoft Dynamics GP. The insert doesn’t validate against the records against which the email addresses will be… Continue Reading Ian...

Read More
Error Upgrading to Microsoft Dynamics GP Fall 2020 Release
Feb04

Error Upgrading to Microsoft Dynamics GP Fall 2020 Release

As I mentioned in my last post, I’m in the process of doing upgrades for a couple of clients to the Dynamics GP Fall 2020 Release. Before I started on a clients system, I thought I would upgrade my own demo/test system to the latest version. The upgrade started fine, but then in one of the companies, the upgrade crashed with two errors: Microsoft Dynamics GP Utilities The stored procedure… Continue Reading Ian...

Read More
SQL View to Check Dynamics GP Utilities Upgrade Progress
Feb03

SQL View to Check Dynamics GP Utilities Upgrade Progress

It’s a while since I did an upgrade of Microsoft Dynamics GP, as they are usually assigned to other consultants, but I’ve taken on a couple recently. One of them has 20+ companies and another coming up soon has well above 100+, so I decided I needed a way of seeing how far the upgrade had progressed. The below SQL script creates a view on the upgrade tables showing when the upgrade of a… Continue Reading Ian...

Read More
Change All Microsoft Dynamics GP Posting Reports Set to Print to Screen Output
Feb02

Change All Microsoft Dynamics GP Posting Reports Set to Print to Screen Output

I was helping a client implement Microsoft Dynamics GP last year and advised them to review the posting report setup and decide which ones they wanted to keep. To assist them with this, I ran the below script to change all reports which were set to print the report, to output the report to screen instead. The users can then review the report and determine if they want to keep it or not. /*

Read More
Implementing Post Master Enterprise: Extending Post Master Enterprise
Feb01

Implementing Post Master Enterprise: Extending Post Master Enterprise

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. The Audot-Detect rules covered in the last post are sufficient for those cases when workflow is not being used or when the auto-detect rule can be configured using the Batch Number. I’ve worked with a few clients to implement Post Master Enterprise now and there usually… Continue Reading Ian...

Read More
Implementing Post Master Enterprise: Create Auto-Posting Rules
Jan29

Implementing Post Master Enterprise: Create Auto-Posting Rules

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. From the settings menu select Auto-Detect. Rules are created separately for each batch source and require four settings: Company allows you to choose the company in which the rule is to be applied. Batch Source is the type of transaction, which, in this example, is General… Continue Reading Ian Grieve’s...

Read More
Implementing Post Master Enterprise: First Run
Jan28

Implementing Post Master Enterprise: First Run

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. With the Windows service configured we can move onto running Post Master Enterprise for the first time. The first thing you need to do is configure it to run as administrator. Do this by right-clicking on the shortcut, selecting the Compatibility tab and mark the Run this… Continue Reading Ian Grieve’s...

Read More
Implementing Post Master Enterprise: Configure Windows Service
Jan27

Implementing Post Master Enterprise: Configure Windows Service

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. With Post Master Enterprise installed, the next step is to configure the Windows service as Automatic (Delayed Start); this will ensure that SQL Server is running before Post Master itself starts; this does, of course, assume that Post Master is being installed on the SQL… Continue Reading Ian Grieve’s...

Read More
Implementing Post Master Enterprise: Installation
Jan26

Implementing Post Master Enterprise: Installation

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. Once you have the prerequisites sorted out, launch the Post master setup utility. On the Welcome step, click Next:: Accep the terms of the License Agreement and click Next: Confirm the installation location and click Next: Confirm the installation by clicking Next: There… Continue Reading Ian Grieve’s...

Read More
Implementing Post Master Enterprise: Prerequisites
Jan25

Implementing Post Master Enterprise: Prerequisites

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. The prerequisites for Post master Enterprise are fairly straightforward. Firstly, a client install of Microsoft Dynamics GP is required; this can be used by users, but you’ll need a launch file which doesn’t include the products on the incompatible list and if there are any… Continue Reading Ian...

Read More
Implementing Post Master Enterprise: Incompatible Modules
Jan22

Implementing Post Master Enterprise: Incompatible Modules

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. The installation notes for Post Master note that there are known incompatibilities with some first and third party Microsoft Dynamics GP products which can interfere with the start-up or processing of Post Master. If the below products are installed, a separate launch file… Continue Reading Ian Grieve’s...

Read More
Implementing Post Master Enterprise: What batch types are supported?
Jan21

Implementing Post Master Enterprise: What batch types are supported?

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. Post Master Enterprise can post many, but not all types of batch. For the standard Microsoft Dynamics GP modules, the following batch types are supported: Assembly Entry Clearing Entry General Entry In Transit Invoice Entry Payables Transaction Entry Payment… Continue Reading Ian Grieve’s Article on...

Read More
Implementing Post Master Enterprise: What is Post Master Enterprise?
Jan20

Implementing Post Master Enterprise: What is Post Master Enterprise?

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software. Post Master Enterprise automates the posting process in Microsoft Dynamics GP which can provide for efficiencies by: Eliminating the need for users to perform the repetitive task of selecting batches to post. Reducing the need for users to check for batches to… Continue Reading Ian Grieve’s Article on...

Read More
Implementing Post Master Enterprise: Who are Envisage Software?
Jan19

Implementing Post Master Enterprise: Who are Envisage Software?

This post is part of the series on Implementing Post Master Enterprise for Microsoft Dynamics GP. Envisage Software was started by Andrew Dean, an experienced software development manager with 10 years experience of working for a leading Microsoft Dynamics GP client, in 2007. Their aim is to provide quality ISV tools and customised business software solutions for Microsoft Dynamics GP to both… Continue Reading Ian Grieve’s...

Read More
Implementing Post Master Enterprise: Series Index
Jan18

Implementing Post Master Enterprise: Series Index

In this series of posts I am going to look at implementing Post Master Enterprise for Microsoft Dynamics GP from Envisage Software, an ISV based in Australia. Post Master is one of the auto-posting tools available for Microsoft Dynamics GP and is one which I have sold a number of times. I’ll take a look at the capabilities of the application itself, before moving onto the installation and… Continue Reading Ian...

Read More
SQL View for to Extract Accruals from Microsoft Dynamics GP Payables Management Module
Jan15

SQL View for to Extract Accruals from Microsoft Dynamics GP Payables Management Module

I recently did a webinar for my employer, ISC Software, on Prepayments and Acruals and as part of the accruals section used a SQL View to extract the accruals to be created; as mentioned in thw webinar, the extract cna be done either using a SmartList or a direct query in SmartConnect. The SQL view has been created using the EOMONTH function which si available only in later versions of SQL… Continue Reading Ian Grieve’s...

Read More
Identify and Fix Corrupt SOP Transactions in Microsoft Dynamics GP
Jan14

Identify and Fix Corrupt SOP Transactions in Microsoft Dynamics GP

A client recently logged a support call whereby reports were showing incorrect information, including for transactions which had been deleted. I did some exploring mof data and found that the Sales Transaction Amounts Work (SOP10200) and Sales User-Defined Work History (SOP10106) tables contained rows for transactions which were not in the Sales Transaction Work (SOP10100) table. From… Continue Reading Ian Grieve’s Article...

Read More
SQL View on Sales Order Processing Backorder Transactions
Jan13

SQL View on Sales Order Processing Backorder Transactions

I’ve written this view for a number of different clients over the years, so am posting it here for future reference. It returns only open backorders which have yet top be transferred to order or invoice; it includes PO information so users can easily see if a PO has been raised and if any of it has been receipted. The SQL below includes the CREATE VIEW uv_AZRCRV_SOPOpenBackorders AS /*Created… Continue Reading Ian...

Read More
SQL Query to Get Login Password Expiry
Jan12

SQL Query to Get Login Password Expiry

I don’t recall exactly why this script was required, but the below SQL query can be used to get the expiration date for logins in Microsoft SQL Server. Some of the data is available directly from the sys.sql_logins table, but other pieces had to be retrieved using the LOGINPROPERTY function: SELECT [‘SQL Logins’].name AS ‘LoginName’ ,LOGINPROPERTY([‘SQL Logins’].name,...

Read More
What Data Can SmartConnect Integrate into Microsoft Dynamics GP?
Jan11

What Data Can SmartConnect Integrate into Microsoft Dynamics GP?

I’ve worked with a number of clients on SmartConnect from eOne Solutions this year as well as discussing with a few prospects. SmartConnect is a very flexible tool which can be used to integrate many different types of data. In this respect, it competes with the Microsoft Integration Manage product, but SmartConnect has many other features over Integration Manager. Discussions on SmartConnect… Continue Reading Ian...

Read More
Excluding Folders From a Cron Backup
Jan10

Excluding Folders From a Cron Backup

A while ago, I posted an article on using cron to make backups of folders on Linux web hosting. One issue I’ve become aware of since then is that there are some folders I want to exclude from the backup process. I did some exploring and found the –exclude switch can be used to exclude a single folder; to exclude multiple folders, you can use the switch multiple times. The example below,… Continue Reading Ian...

Read More
Error Posting Journals in One Microsoft Dynamics GP Company
Jan08

Error Posting Journals in One Microsoft Dynamics GP Company

A client reported an urgent support call a short time ago that they could not post any journals and were receiving this error when they tried: Insert failed because the following SET options have incorrect settings: ‘CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS’. Verify that SET options are correct for use with indexed views and/or indexes on comp This error was produced for all users in only one of… Continue Reading Ian...

Read More
Insert Segments from Text File/CSV into Microsoft Dynamics GP
Jan07

Insert Segments from Text File/CSV into Microsoft Dynamics GP

It seems that while I’ve posted about how to update segment descriptions from CSV in Microsoft Dynamics GP and how to copy them to a new company or even all companies, I’ve never actually posted the script I use to insert them. I needed this script the other day and ended up using the update descriptions one as the basis for a new script to insert segments into Dynamics GP; this script will… Continue Reading Ian...

Read More
Management Reporter Currency Does Not Exist Error
Jan06

Management Reporter Currency Does Not Exist Error

I was doing some training on Management Reporter for a client the other week and had an issue to follow up on. The issue was around multicurrency conversion which wasn’t working correctly. When doing some testing around the issue, I was able to reproduce the same currency error the client had encountered: Currency XXXX does not exist for company XXXX. No values will be returned. The currency… Continue Reading Ian...

Read More
Deleting a Windows Service
Jan05

Deleting a Windows Service

I recently uninstalled an application to notice a few days later that the related service was still showing in the Services applet. I’ve previously posted about adding and removing dependencies from a Windows service. As with adding or removing dependencies, the SC command online program can be used to delete a service: SC DELETE {service name} Read original post Deleting a Windows Service at

Read More
Microsoft Dynamics GP Fall 2020 Release Documentation
Jan04

Microsoft Dynamics GP Fall 2020 Release Documentation

As of the October 2019 release, Microsoft Dynamics GP moved onto the Modern Lifecycle which offers continuous support and servicing, including bug fixes, new features and the latest tax updates. There will be one major release per year along with at last two hotfix releases through the year. There are a number of resource pages available or updated for the Fall 2020 Release of Microsoft… Continue Reading Ian Grieve’s...

Read More
New Year’s Resolutions 2021
Jan01

New Year’s Resolutions 2021

It’s that time again, a new calendar year has begun. This year “Happy New Year” has an entirely different meaning to most of us, after what can only reasonably be described as a train wreck of a year. I’m a day late in writing this post this year (even though I’m posting this as Jan 1st), I quite honestly couldn’t find my words yesterday. How was 2020? 2020 started out very well,… Continue...

Read More
Hide Chrome Download Bar
Dec31

Hide Chrome Download Bar

I’ve been using Vivaldi as my main browser since v1 was first launched (and used the beta before that), but sometimes need to use a second browser. Vivaldi have made extensive changes to the UI (written their own and used the Chromium renderer?), but all of the other Chromium browsers I’ve tried all have very similar UIs which suggests they aren’t deviating much from the default. This Include… Continue Reading...

Read More
SmartConnect Service Won’t Start
Dec30

SmartConnect Service Won’t Start

This is an issue which I encountered a while ago, but only recently found the screenshots when doing some tidying up. When I installed SmartConnect I had a problem whereby the service would not start. I’d followed my usual implementation steps, but was receiving this error when trying to start the service: Services The eOne SmartConnect Service service on Local Computer started and then… Continue Reading Ian Grieve’s...

Read More
SmartConnect Error: “The delete permission was denied on the object…”
Dec29

SmartConnect Error: “The delete permission was denied on the object…”

A while back a client using SmartConnect reported an error running one integration; this is one of a set of newly created identical integrations running against a set of companies, but only one of them was failing. The error produced was: Task xxxx failed. Map run will end reporting failure. The DELETE permission was denied on the object ‘xxxx’, database ‘xxxx’, schema ‘dbo’ As there was a…...

Read More
SmartConnect could not find data
Dec28

SmartConnect could not find data

I recently created an integration using SmartConnect for a client as I have many times before; however, when I came to test the integration, my source file was totally ignored and the integration returned an error that no file was found. The integration was using a folder data source with an Excel template; nothing special and something which I have configured many times. I copied the template… Continue Reading Ian...

Read More
Missing Security Roles and Tasks After Upgrading to Microsoft Dynamics GP Fall 2020 Release
Dec24

Missing Security Roles and Tasks After Upgrading to Microsoft Dynamics GP Fall 2020 Release

When upgrading Microsoft Dynamics GP, the security roles and tasks are not automatically updated; this is to avoid overwriting or causing problems with any customizations to these roles and tasks which might have been made. Instead Microsoft provide a set of scripts which you can choose to run to add the missing items. I always recommend clients not directly amend the standard tasks, but make… Continue Reading Ian Grieve’s...

Read More
Installing Pi-hole On A Raspberry Pi: Changing the IP Address
Dec24

Installing Pi-hole On A Raspberry Pi: Changing the IP Address

I recently built a Raspberry Pi and installed Pi-hole onto it for my Dad. I did all of the work at my house and then took it down to his to install onto his network. I had an issue with doing this as it was not picking up a new IP address (it took me a while to work out that this was the problem). Not knowing Linux very well, it took me longer than it would have done with a Windows machine to… Continue Reading Ian Grieve’s...

Read More
Microsoft Dynamics GP Support from ISC Software
Dec23

Microsoft Dynamics GP Support from ISC Software

I’ve worked with Microsoft Dynamics GP for over 17 years and, like most people, do not work for the company with whom I first started. In fact, I am now on my third company working with Microsoft Dynamics GP (and starting to do some work with Microsoft Dynamics Business Central). 18 months after I left the first company they bowed out of supporting Dynamics GP; I now hear from a former client… Continue Reading Ian...

Read More
Workfow Submit button on PM Transaction Entry not working in Microsoft Dynamics GP
Dec23

Workfow Submit button on PM Transaction Entry not working in Microsoft Dynamics GP

I’ve been doing some work with a client to implement the Workflow module of Microsoft Dynamics GP for approvals of Payables Transactions and encountered an oddity; when the user creates a transactions and hits Submit, nothing happens, but was not able to reproduce this on any of my demo or test systems. There was a customised window in use on the client system, so I removed this and tried with… Continue Reading Ian...

Read More
Microsoft Dynamics GP Analytical Accounting Open Transactions SQL Query
Dec22

Microsoft Dynamics GP Analytical Accounting Open Transactions SQL Query

I was looking into a problem reported by a client recently and needed to check the assignment of Analytical Accounting Transaction Dimension Codes to the AA GL transactions and so wrote the below SQL which I am posting to keep it easily accessible should I need it again. /*Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is… Continue Reading Ian Grieve’s...

Read More
Recent ISC Software Webinar: Year-End Best Practice in Microsoft Dynamics GP
Dec21

Recent ISC Software Webinar: Year-End Best Practice in Microsoft Dynamics GP

In our most recent webinar, we took a look at Year-End Best Practice in Microsoft Dynamics GP. In this webinar, we covered how some key points to action or consider before starting, the order in which the year end should be run before running through the closing process in each of the standard modules in Microsoft Dynamics GP covering not only what to do. but also what the year-end closing… Continue Reading Ian Grieve’s...

Read More
Microsoft Dynamics GP Fall 2020 Release New Features: Mask SSN on Human Resource Reports
Dec21

Microsoft Dynamics GP Fall 2020 Release New Features: Mask SSN on Human Resource Reports

This post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available. This post is on the Mask SSN on Human Resource Reports Human Resource & Payroll enhancement. A… Continue Reading Ian...

Read More

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.