Remember to Reactivate Jet Reports When User Made Designer
Mar24

Remember to Reactivate Jet Reports When User Made Designer

I’ve been doing a lot of work with a client on Jet Reports recently. While we were doing a training session, we created some new users and changed some from being ordinary users to being designers via the Jet Licensing portal. When the first user launched Excel, they found they were still an ordinary user without access to design mode. They logged out and back in without the license changing… Continue Reading Ian...

Read More
Web Services for Microsoft Dynamics GP: How to Setup an Active Directory Security Store
Mar23

Web Services for Microsoft Dynamics GP: How to Setup an Active Directory Security Store

To use the Web Services for Microsoft Dynamics GP with TLS 1.2 you need to do two things: Upgrade to the Fall 2020 Release; you can’t just apply the hotfix to an October 2019 or earlier release, but have to use the full download media. Create an Active Directory Security Store. Upgrading Dynamics GP is not a problem, but Active Directory isn’t my area of expertise. Fortunately, Microsoft… Continue Reading Ian...

Read More
Recent ISC Software Webinar: Controls & Security in Microsoft Dynamics GP
Mar22

Recent ISC Software Webinar: Controls & Security in Microsoft Dynamics GP

In our most recent webinar, we took a look at Controls & Security in Microsoft Dynamics GP. In this webinar, we covered how you can improve controls and security in Microsoft Dynamics GP using a mix of standard ad third party functionality. If you want to catch up on this, or any other, webinar, you can do so here. In this blog post, I am going to recap the webinar and cover the salient… Continue Reading Ian Grieve’s...

Read More
ClassicPress Plugin Development: Semantic Versioning 2.0
Mar21

ClassicPress Plugin Development: Semantic Versioning 2.0

This post is part of the ClassicPress Plugin Development series n which I am going to look at both best practice for developing plugins and how I approach some requirements as well as some of the functions I commonly use. When developing plugins for ClassicPress, you need to develop using semantic versioning (or semver) as this will be a requirement of the ClassicPress Directory. Semantic… Continue Reading Ian Grieve’s...

Read More
VBA Snippets: Execute URL or Application
Mar19

VBA Snippets: Execute URL or Application

This post is part of the series on VBA Snippets. it is possible to execute a URL or application in VBA using the Windows Shell Execute API function. In this snippet I am executing a URL, but this could be an application. Before you can call ShellExecute in code you need to add the following line to the declarations at the top of the mdoule: Private Declare Function ShellExecute Lib… Continue Reading Ian Grieve’s Article on...

Read More
VBA Snippets: Sleep
Mar18

VBA Snippets: Sleep

This post is part of the series on VBA Snippets. The following VBA snippets can be used to set a pause (sleep) in the code. The first one needs to be in the declarations at the top of the module: Private Declare Sub Sleep Lib “kernel32” (ByVal milliseconds As Long) The second is used where you want the code to pause (my recent use was to pause for five seconds after an error and before… Continue Reading Ian...

Read More
VBA Snippets: Series Index
Mar17

VBA Snippets: Series Index

We’ve recently taken on a new client for support of Microsoft Dynamics GP who has a number of modified forms and reports which have been extended with VBA code to add additional functionality. I have done a reasonable amount of VBA and VB6 in the past, but that was sometime ago and I’ve found myself searching online for examples on how to do some things when they’ve asked for further… Continue Reading Ian...

Read More
ClassicPress Plugin Development: Coding Paradigms
Mar14

ClassicPress Plugin Development: Coding Paradigms

This post is part of the ClassicPress Plugin Development series. There are two code paradigms that can be used when developing for ClassicPress: Procedural Programming Object Oriented Programming There has been many a flame war fought over which is better and which is worse, but in all honesty I believe that both can have their place and there is no one true way of coding. I was going to… Continue Reading Ian Grieve’s...

Read More
ClassicPress Plugin Development: Series Index
Mar13

ClassicPress Plugin Development: Series Index

I started developing plugins for WordPress almost eight years ago and moved to ClassicPress just over two years ago; I now have 47 plugins available for ClassicPress. I am creating this series to show how certain aspects of development for ClassicPress plugins are done, partly to benefit others who take up developing for ClassicPress but also as a quick reference for myself including detailed… Continue Reading Ian Grieve’s...

Read More
Simple Audit for Microsoft Dynamics GP: Conclusion
Mar12

Simple Audit for Microsoft Dynamics GP: Conclusion

This post is part of a series on creating a simple audit for Microsoft Dynamics GP. As I’ve shown over the last few posts, it is relatively easy to create a simple audit on a table in Dynamics GP, but this approach is not vert scalable and requires someone to manually create the SQL triggers. For a client on a shoestring budget and who wanted to audit one table, this approach… Continue Reading Ian Grieve’s Article on...

Read More
Simple Audit for Microsoft Dynamics GP: SQL View for Reporting
Mar11

Simple Audit for Microsoft Dynamics GP: SQL View for Reporting

This post is part of a series on creating a simple audit for Microsoft Dynamics GP. Once the audit table and triggers have been deployed, any changes made through the audit will be recorded and available for reviewing later to see who has been making changes and, more significantly, what was changed. The easiest way of making this available to the client was to create a SmartList for them… Continue Reading Ian Grieve’s...

Read More
Simple Audit for Microsoft Dynamics GP: Create Triggers
Mar10

Simple Audit for Microsoft Dynamics GP: Create Triggers

This post is part of a series on creating a simple audit for Microsoft Dynamics GP. With the table created to store the audited information, the second step is to create the required triggers on the Address Electronic Funds Transfer Master (SY06000) table. For an Vendor EFT audit there are three triggers required: INSERT UPDATE DELETE These triggers will record all new Vendor EFT information… Continue Reading Ian Grieve’s...

Read More
Simple Audit for Microsoft Dynamics GP: Create Table
Mar09

Simple Audit for Microsoft Dynamics GP: Create Table

This post is part of a series on creating a simple audit for Microsoft Dynamics GP. The first step in creating the audit is to create a table in the company database to hold the audited information. From the user point of view there was five pieces of information required: Key for the vendor EFT being amended User ID Date/Time Old Data New Data To make reporting easier and to add an element… Continue Reading Ian Grieve’s...

Read More
azurecurve ClassicPress Plugins: Check Plugin Status
Mar06

azurecurve ClassicPress Plugins: Check Plugin Status

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; Check Plugin Status. Functionality This plugin allows you to check the status of plugins on your site: * Are they in the WordPress Repository. * Do they use a 3rd party update mechanism… Continue Reading Ian Grieve’s...

Read More
Simple Audit for Microsoft Dynamics GP: Introduction
Mar05

Simple Audit for Microsoft Dynamics GP: Introduction

This post is part of a series on creating a simple audit for Microsoft Dynamics GP. I created a simple audit a while ago when a client had a requiremnet to audit the change of EFT details onvendors, but did not have sufficient budget for a full audit product like the Assure Suite from Fastpath. This is not to say that the Assure Suite is expenseive, but the client in question was a very small… Continue Reading Ian Grieve’s...

Read More
Simple Audit for Microsoft Dynamics GP: Series Index
Mar04

Simple Audit for Microsoft Dynamics GP: Series Index

I created a simple audit a while ago when a client had a requirement to audit the change of EFT details on vendors, but did not have sufficient budget for a full audit product like the Assure Suite from Fastpath. This is not to say that the Assure Suite is expensive, but the client in question was a very small client with only two users of Microsoft Dynamics GP. In this series of posts, I will… Continue Reading Ian...

Read More
Receivables HATB With Aging By Due Date (using GL Posting Date)
Mar03

Receivables HATB With Aging By Due Date (using GL Posting Date)

Today’s script, like yesterdays, is an unusual one for me to post, as it is not a script which I have written; it is a script which returns the data for a Receivables HATB With Aging By Due Date (using GL Posting). It was written by Sivakumar Venkataramanback in 2011 and came up in conversation recently; the site he posted it to no longer exists and I had to hunt the script out from the… Continue Reading Ian Grieve’s...

Read More
Receivables HATB With Aging By Due Date (using Document Date)
Mar02

Receivables HATB With Aging By Due Date (using Document Date)

Today’s script is an unusual one for me to post, as it is not a script which I have written; it is a script which returns the data for a Receivables HATB With Aging By Due Date (using Document Date). It was written by Sivakumar Venkataraman back in 2011 and came up in conversation recently; the site he posted it to no longer exists and I had to hunt the script out from the wayback machine to… Continue Reading Ian...

Read More
Recent ISC Software Webinar: Automation in Microsoft Dynamics GP
Mar01

Recent ISC Software Webinar: Automation in Microsoft Dynamics GP

In our most recent webinar, we took a look at Automation in Microsoft Dynamics GP. In this webinar, we covered how automation can be used in Microsoft Dynamics GP to improve efficiencies and accuracy of data. If you want to catch up on this, or any other, webinar, you can do so here. In this blog post, I am going to recap the webinar and cover the highlights of how automation can be used in… Continue Reading Ian Grieve’s...

Read More
azurecurve ClassicPress Plugins: SMTP
Feb28

azurecurve ClassicPress Plugins: SMTP

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; SMTP. Functionality Simple Mail Transport Protocol (SMTP) plugin will intercept the standard wp_mail and send emails via an SMTP server using PHPMAILER. This plugin is multisite compatible;… Continue Reading Ian Grieve’s...

Read More
azurecurve ClassicPress Plugins: Maintenance Mode
Feb27

azurecurve ClassicPress Plugins: Maintenance Mode

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; Maintenance Mode. Functionality Enable maintenance mode to disable the front-end of your ClassicPress site for non-administrators. Users will only see the configured message; administrators… Continue Reading Ian Grieve’s...

Read More
Outlook Not Sending Emails
Feb26

Outlook Not Sending Emails

We recently had anew consultant join us at ISC Software which meant building a new laptop. As she lives fairly near me the laptop and other kit was delivered to me and I did some setup. Once she was logged on there was one unexpected issue with emails not sending in Outlook. I did some checking of settings and found that there is a setting which needed to be enabled for sending of emails; I’m… Continue Reading Ian...

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