Features of PurchaseHQ from ISC Software: Document Approval [Video]
Apr09

Features of PurchaseHQ from ISC Software: Document Approval [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Document Approvalpost, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Document Approval video: GP Elementz from ISC Software GP Elementz… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Document Approval
Apr09

Features of PurchaseHQ from ISC Software: Document Approval

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. One of the key parts of PurchaseHQ is the integration with the Microsoft Dynamics GP Workflow module which was introduced in Microsoft Dynamics GP 2013 R2 and has been enhanced in almost every version since with additional workflow types being added. The… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Workflow Integration [Video]
Apr09

Features of PurchaseHQ from ISC Software: Workflow Integration [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Workflow Integration post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Workflow Integration video: GP Elementz from ISC Software GP… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: View my orders [Video]
Apr08

Features of PurchaseHQ from ISC Software: View my orders [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an view my orders post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – View My Orders video: GP Elementz from ISC Software GP Elementz from… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: View my orders
Apr08

Features of PurchaseHQ from ISC Software: View my orders

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. As a purchasing user, PurchaseHQ allows me to view my orders. That is any order which I have raised either through PurchaseHQ or Microsoft Dynamics GP itself. On the PurchaseHQ home page, is the My Orders tile which shows me the total number of purchase… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Enter a Purchase Order [Video]
Apr08

Features of PurchaseHQ from ISC Software: Enter a Purchase Order [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Enter a Purchase Order post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Enter a Purchase Order video: GP Elementz from ISC Software GP… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Enter a Purchase Order
Apr08

Features of PurchaseHQ from ISC Software: Enter a Purchase Order

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. When PurchaseHQ is not in Requisition Mode users can enter new purchase order via the portal. This gives them access to simpler, cleaner windows than the standard Microsoft Dynamics GP windows which are accessible from any form-factor device from any… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition [Video]
Apr07

Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Enter a Purchase Requisition post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Enter a Purchase Requisition video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition
Apr07

Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. When PurchaseHQ is in Requisition Mode users can enter new requisition via the portal. This gives them access to simpler, cleaner windows than the standard Microsoft Dynamics GP windows which are accessible from any form-factor device from any… Continue Reading Ian Grieve’s Article on...

Read More
Features of PurchaseHQ from ISC Software: Granting users access [Video]
Apr07

Features of PurchaseHQ from ISC Software: Granting users access [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Granting users access post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Granting users access video: GP Elementz from ISC Software GP… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Granting users access
Apr07

Features of PurchaseHQ from ISC Software: Granting users access

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. PurchaseHQ has two types of user: Approval user who can approve pending approvals in Workflow. Transaction user who would raise requisitions, or orders depending on configuration, and receive goods. No setup is required for approval users; any user who… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Setup images [Video]
Apr06

Features of PurchaseHQ from ISC Software: Setup images [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Setup images post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Setup images video: GP Elementz from ISC Software GP Elementz from ISC… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Setup images
Apr06

Features of PurchaseHQ from ISC Software: Setup images

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. There are three images which can be used by PurchaseHQ. they are: Background Image which is used for the background of PurchaseHQ as an overlay to the default blue background. Company Logo which is displayed in the top left corner by the company… Continue Reading Ian Grieve’s Article...

Read More
Features of PurchaseHQ from ISC Software: Configuration [Video]
Apr06

Features of PurchaseHQ from ISC Software: Configuration [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Introduction to PurchaseHQ post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Configuration video: GP Elementz from ISC Software GP… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Configuration
Apr06

Features of PurchaseHQ from ISC Software: Configuration

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. All configuation of PurchaseHQ is done through add-in installed into Microsoft Dynamics GP. The Purchasing Portal Setup window (Administration area page » Setup » System » PurchaseHQ » PurchaseHQ System Setup) is accessible initially only to the DYNSA or… Continue...

Read More
Reduce size of JPEG or PNG images
Apr05

Reduce size of JPEG or PNG images

I’ve been doing some work on both my websites and the plugins I’ve developed for ,a href=’https://www.classicpress.net/’>ClassicPress in order to make improvements. One of the areas I because aware of, is that the images I am using are larger than they could be. It is possible to compress PNG or JPEG images without any loss of quality. I’ve used a couple of tools to compress the screenshots…...

Read More
ClassicPress Development with GitHub: Creating release zips
Apr04

ClassicPress Development with GitHub: Creating release zips

When I started developing plugins for ClassicPress I decided that I needed to be using source control. As ClassicPress is intending to use GitHub for their plugin directory, it made sense for me to use it as well. This post is part of a series on ClassicPress Development with GitHub. In the last post of this series, when discussing creating a release, I mentioned that you should upload a zip… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Secure access [Video]
Apr03

Features of PurchaseHQ from ISC Software: Secure access [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an secure access post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Secure Access video: GP Elementz from ISC Software GP Elementz from ISC… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Secure access
Apr03

Features of PurchaseHQ from ISC Software: Secure access

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. One of the key principles behind the development of PurchaseHQ was that it be secure and, unlike the Web Services for Microsoft Dynamics GP, it uses a version of the TLS standard which is not being retired in 2020. PurchaseHQ has four components: The… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ [Video]
Apr03

Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ [Video]

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an Introduction to PurchaseHQ post, but I am experimenting with making video alternatives to the standard blog posts. You can watch the GP Elementz – PurchaseHQ – Overview video: GP Elementz from ISC Software GP Elementz… Continue Reading Ian...

Read More
Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ
Apr03

Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ

This post is part of the Features of PurchaseHQ from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. PurchaseHQ, one of the three portals available from ISC Software, is intended as a secure and ​easy to use purchasing portal, which allows (from any internet connected device, anywhere at anytime): Entry of purchase requisitions or purchase orders… Continue Reading Ian Grieve’s...

Read More
Features of PurchaseHQ from ISC Software: Series Index
Apr02

Features of PurchaseHQ from ISC Software: Series Index

This post is part of the GP Elementz from ISC Software series, but is also the series index for the Features of PurchaseHQ from ISC Software sub-series. In this series of posts I am going to take a look at the features of the PurchaseHQ portal. GP Elementz from ISC Software GP Elementz from ISC Software What add-ons are available? GP Elementz Portals Features of PurchaseHQ from… Continue Reading Ian Grieve’s Article on...

Read More
GP Elementz from ISC Software: GP Elementz Portals
Apr02

GP Elementz from ISC Software: GP Elementz Portals

This post is part of the GP Elementz from ISC Software series. There are three GP Elementz portals available from ISC Software for Microsoft Dynamics GP which all share several key features: Access data from anywhere and on any device.​ Safe and secure portals using Microsoft Azure.​​​ Fast and simple set up​​. Ease of use​. Portal branded with your own logo and background… Continue Reading Ian Grieve’s Article on their...

Read More
GP Elementz from ISC Software: What add-ons are available?
Apr01

GP Elementz from ISC Software: What add-ons are available?

This post is part of the GP Elementz from ISC Software series. ISC Software is both a VAR (Value Added Reseller) and an ISV (Independent Software Vendor) who have developed a number of add-ons for Microsoft Dynamics GP. These add-ons come in two forms: GP Elementz portals which are fully response HTML5 portals which securely connect with Microsoft Dynamics GP. GP Elementz are Dexterity… Continue Reading Ian Grieve’s...

Read More
GP Elementz from ISC Software: Series Index
Apr01

GP Elementz from ISC Software: Series Index

I have been working for ISC Software since January 2019. I have been working in the Microsoft Dynamics GP space since 2003 and ISC are now the third partner I have worked for. However, they are somewhat different to the previous companies for whom I have worked in that as well as being a VAR (Value Added Reseller), ISC are also an ISV (Independent Software Vendor) who have a number of add-ons… Continue Reading Ian Grieve’s...

Read More
SQL View to return most recent five purchase orders by vendor
Mar31

SQL View to return most recent five purchase orders by vendor

I don’t recall when I wrote this SQL view, but I stumbled across it when I was looking for something else and thought it worth posting. It uses a common table expression to return the most recent five purchase orders for each vendor. — drop view if it exists IF OBJECT_ID(N’uv_AZRCRV_MostRecentFivePurchaseOrdersByVendor ‘, N’V’) IS NOT NULL DROP VIEW… Continue Reading Ian Grieve’s Article...

Read More
SQL Script to update vendor and customer email addresses
Mar30

SQL Script to update vendor and customer email addresses

Back in August 2011 I posted a SQL script which transfers vendor email addresses from the INET1 to the Email Address field and today’s script is a variation of that one. The original script I posted only did a transfer for vendors and would migrate the INET1 one field regardless of whether there was already something in the Email Address field. This new script only does the transfer if INET1… Continue Reading Ian...

Read More
SQL Script to get all accounts set as available in Purchasing lookups
Mar27

SQL Script to get all accounts set as available in Purchasing lookups

Following on from the last post, in which I posted a script to get accounts linked to a vendor, this post is a script which returns all accounts which are set as available in lookups in the Purchasing series. The SQL is straightforward, but I had to work out the binary entries to check for by saving and checking each combination. /*Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP… Continue Reading Ian...

Read More
SQL Script to get all vendor purchasing accounts
Mar26

SQL Script to get all vendor purchasing accounts

I recently needed to select all assigned purchasing accounts for a particular vendor; this would include both the normal purchasing one on the Vendor Account Maintenance window and the additional ones in the Additional Vendor Accounts window. The SQL is fairly straightforward, but I had to make sure each account was only included once: /*Created by Ian Grieve of azurecurve|Ramblings of a… Continue Reading Ian Grieve’s...

Read More
SQL Script to find SQL Objects containing specific text
Mar25

SQL Script to find SQL Objects containing specific text

I did some work for a client recently which involved some custom SQL objects created by a consultant at their previous VAR. It appeared that there was a consistent prefix on the created objects which meant we could use a script I’ve previously posted to identify them all. However, we quickly realised there were other objects which did not adhere to the naming convention we’d identified…. Continue Reading Ian...

Read More
Implementing Fastpath’s Audit Trail: View reports
Mar24

Implementing Fastpath’s Audit Trail: View reports

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. In yesterday’s post, I took a look at the Data Changes view available in the Fastpath Assure portal for Audit Trail. This is the way of looking at the raw data, but is not the friendliest method of reviewing the audited changes which is available, It is… Continue Reading...

Read More
Power Virtual Agents – Create a Chat Bot for your on-premises ERP
Mar23

Power Virtual Agents – Create a Chat Bot for your on-premises ERP

This video shows how you can combine the power of Microsoft Power Virtual Agents chat bots and Power Automate flows with your on-premises data to provide an all around navigation-free user experience.While this video features Microsoft Dynamics GP as the on-premises ERP, technically speaking, you could create a chat bot for just about any ERP system in the market, whether on-premises or in the… Continue Reading Mariano...

Read More
Implementing Fastpath’s Audit Trail: Review data changes
Mar23

Implementing Fastpath’s Audit Trail: Review data changes

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. With Audit Trails installed, configured with triggers created and a scheduled data collect in place, the audited changes are available for users to view in the Fastpath Assure portal. The first palc you can see them, and the one covered in this post, is… Continue Reading Ian...

Read More
ClassicPress Development with GitHub: Create Release
Mar21

ClassicPress Development with GitHub: Create Release

When I started developing plugins for ClassicPress I decided that I needed to be using source control. As ClassicPress is intending to use GitHub for their plugin directory, it made sense for me to use it as well. This post is part of a series on ClassicPress Development with GitHub. When developing with GitHub, you can make a release; this is a way of grouping together all of the changes since… Continue Reading Ian...

Read More
Implementing Fastpath’s Audit Trail: Ad hoc data collect
Mar20

Implementing Fastpath’s Audit Trail: Ad hoc data collect

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. Ina previous post I covered the scheduled collection of Audit Trails data. This will allow you to schedule a regular collection of data which, for example, may run every day in the early hours, but sometimes you might need to audit ome data same day. To… Continue Reading Ian...

Read More
Implementing Fastpath’s Assure Suite: Assign Permissions
Mar19

Implementing Fastpath’s Assure Suite: Assign Permissions

This post is part of the series on Implementing Fastpath's Assure Suite. In the last post, I showed how to create a new user which would allow that user to log into the portal, but that would not allow them to do anything else; to allow them to do something more you need to assign permissions. There is two ways to assign security and I find the first way to be, by far, the easiest. Firstly, you… Continue Reading Ian...

Read More
Implementing Fastpath’s Assure Suite: Create new portal user
Mar18

Implementing Fastpath’s Assure Suite: Create new portal user

This post is part of the series on Implementing Fastpath's Assure Suite. The management of Fastpath Assure is done through the Fastpath Assure portal (in the UK, the address is https://uk.fastpathassure.com/). The administrator account will be configured by Fastpath when the portal is created with additional users being created by that administrator. To create a new user, log into the portal… Continue Reading Ian...

Read More
Fixed Assets GL Posting Flow Part 8
Mar17

Fixed Assets GL Posting Flow Part 8

Today’s #TipTuesday is the finale of my series on Fixed Asset transactions in Dynamics GP and what G/L accounts get used where. Today is where I will walk through the rest of the catch-all set of scenarios around what kinds of asset changes impact the G/L. The previous posts so far are: Additions with & without YTD/LTD amortizationDepreciation/AmortizationRetirements in the 1st year of… Continue Reading Jen...

Read More
Implementing Fastpath’s Audit Trail: Transfer between systems
Mar17

Implementing Fastpath’s Audit Trail: Transfer between systems

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. As mentioned in a previous post, triggers are created in one company and can be deployed to other companies on the same system, but in a lot of cases, you might need to create them on a development system and then deploy them to the live one. Fastpath… Continue Reading Ian...

Read More
Implementing Fastpath’s Audit Trail: Apply triggers to other companies
Mar16

Implementing Fastpath’s Audit Trail: Apply triggers to other companies

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. When selecting tables to audit in Fastpath Audit Trails you are doing so in one company database. If you are working with a multi-company system you’re generally going to want to audit the same tables in all companies and setting this up manually would… Continue Reading Ian...

Read More
Replacing ClassicPress Cron with system cron
Mar15

Replacing ClassicPress Cron with system cron

ClassicPress is a hard-fork of WordPress 4.9 and has the same functionality as that version of WordPress although version 2 oc ClassicPress is on the way, which is where changes will start to be introduced. Some of my sites have been experiencing a growing number of visitors to the point where it is staring to cause problems. The reason for the problems is that the built-in ClassicPress cron… Continue Reading Ian Grieve’s...

Read More
Power Apps – Using Azure Text Analytics to monitor Coronavirus COVID-19 updates
Mar14

Power Apps – Using Azure Text Analytics to monitor Coronavirus COVID-19 updates

In this video I describe a Disease Monitor App I created as part of the #TemplatesForHumanity effort championed by Keith Wathling (Twitter: @KeithWathling) a couple years ago and that I have completely rehauled to support Coronavirus with an updated interface and approach to retrieve sentiment analysis with Azure Text Analytics.You will learn about: Using Text Analytics API in Power Apps (click… Continue Reading Mariano...

Read More
azurecurve ClassicPress Plugin: Get GitHub File
Mar14

azurecurve ClassicPress Plugin: Get GitHub File

This is part of the 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; Get Github File. Functionality Gets the content of a file from a GitHub repository and outputs using a shortcode. Settings allow default options, such as author, folder, filename to be specified. Additional options to… Continue Reading Ian Grieve’s...

Read More
Implementing Fastpath’s Audit Trail: Apply templates
Mar13

Implementing Fastpath’s Audit Trail: Apply templates

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. A couple of psots ago I covered the creation of triggers for auditing information. This allows you to create any trigger you want, but can be a somewhat long-winded way of doing things. Fortunately, Fastpath provide a number of templates which you can… Continue Reading Ian...

Read More
Implementing Fastpath’s Audit Trail: Create Triggers
Mar12

Implementing Fastpath’s Audit Trail: Create Triggers

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. Once you have tables selected for auditing, the next step is to create the triggers in the database. To create the triggers, click the Create Triggers button on the toolbar: Click OK when prompted that triggers will be removed and reapplied to the… Continue Reading Ian...

Read More
Implementing Fastpath’s Audit Trail: Select tables to audit
Mar11

Implementing Fastpath’s Audit Trail: Select tables to audit

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. Audit Trails tracks changes by creating triggers on SQL Server. When you create the triggers you do so by selecting a table, choosing the events to track and which fields to be audited: You can separately choose to track inserts, updates and deletes by… Continue Reading Ian...

Read More
Fixed Assets GL Posting Flow Part 7
Mar10

Fixed Assets GL Posting Flow Part 7

Today’s #TipTuesday is a continuation of my series on Fixed Asset transactions in Dynamics GP and what G/L accounts get used where. Today is the second-last of the series, where I will walk through a catch-all set of scenarios around what kinds of asset changes impact the G/L. Half of the scenarios are here, and the rest I’ll cover next week. The previous posts so far are: Additions with… Continue Reading Jen...

Read More
Implementing Fastpath’s Audit Trail: Select company to audit
Mar10

Implementing Fastpath’s Audit Trail: Select company to audit

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. While Audit Trails allows you to audit changes to any SQL Server database. When you first log into Audit Trails you will be prompted to login and select a database: This database is the one in which the auditing will be configured (I’ll show how to do… Continue Reading Ian...

Read More
Implementing Fastpath’s Audit Trail: Grant AT Access
Mar09

Implementing Fastpath’s Audit Trail: Grant AT Access

This post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series. The Audit Trails software can be installed on any machines necessary and connect to the same SQL Server database. Users need to be granted access to Audit Trail in order to access the application. To do this, log into Audit Trail and click (Tools » Grant… Continue Reading...

Read More
ClassicPress Development with TortoiseGit: Revert Last Commit
Mar08

ClassicPress Development with TortoiseGit: Revert Last Commit

When I started developing plugins for ClassicPress I decided that I needed to be using source control. As ClassicPress is intending to use GitHub for their plugin directory, it made sense for me to use it as well. This post is part of a series on ClassicPress Development with TortoiseGit which is a sub-series of the ClassicPress Development with GitHub series. When you have changes committed… Continue Reading Ian Grieve’s...

Read More