Implementing Fastpath’s Assure Suite: Sign Into Support Portal
This post is part of the series on Implementing Fastpath's Assure Suite. As part of the pre-installation steps you need to complete a questionnaire. One of the results of this is that the designated administrator will receive an email giving them access to the Fastpath Assure support portal: Click the verification link on the email and select the login method you specified on the… Continue Reading Ian Grieve’s Article...
ClassicPress Development with TortoiseGit: Install Git for Windows
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 TortoiseGit series. A key prerequisite for… Continue Reading Ian Grieve’s...
ClassicPress Development with TortoiseGit: What is TortoiseGit?
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 TortoiseGit series. Project on GitHub can be… Continue Reading Ian Grieve’s...
Power Automate – UI flows Introduction
Hello Friends!I had a chance to sit down with the incredible Jon Levesque, Senior Program Manager on the Microsoft Power Automate team to do a UI Flows 101 session. The result? A video with over 8K views! This video covers the basics:1. How to get started2. Where to find the On-premises Data Gateway3. Installing the UI Flows desktop plug-in4. Types of UI flows5. A simple demo on how to… Continue Reading Mariano Gomez’s...
Power Automate – Setting Up and registering Flic hubs and buttons
Most videos about this subject show you how to create all sort of Flic demos, but most don’t stop to show you how to get the Flic hub and buttons set up and registered with Power Automate. This video will explain where to obtain the software, how and where to install it, the Flic hub and buttons pairing and registration with Power Automate, and how to get a flow started that leverages the hub… Continue Reading Mariano...
Microsoft Dynamics GP February 2020 Hotfix Released
On the 6th February Microsoft announced the release of the Microsoft Dynamics GP 2020 Hotfix. This hotfix is for Microsoft Dynamics GP 2018, 2018 R2 or the October 2019 release , although any compliance related changes will roll into the Microsoft Dynamics GP 2016 mid-year update scheduled for release in June; there will be no more updates on Microsoft Dynamics GP 2015 so those still on that… Continue Reading Ian Grieve’s...
Implementing Fastpath’s Assure Suite: Pre-installation steps
This post is part of the series on Implementing Fastpath's Assure Suite. When you place an order for the Fastpath Assure Suite, you are asked to complete a questionnaire; this is important to get correct as the details on this questionnaire will form the basis for both your registration key and how the Fastpath portal connects to your local system. Once the questionnaire has been sent to… Continue Reading Ian Grieve’s...
Canadian Payroll 2019 T4 issue
The 2019 Canadian Payroll tax updates for Dynamics GP seem like the gift that keeps on giving! Hopefully anyone reading this has already installed the “Round 2” tax update issued in mid-January. If you have not yet installed that and are running Canadian Payroll in GP 2015, 2016 or 2018/18.2, read on! Brief recap The “round 2” update fixed a few issues, that the Dec 2019 update… Continue Reading Jen...
Implementing Fastpath’s Assure Suite: What is Assure Suite?
This post is part of the series on Implementing Fastpath's Assure Suite. The Fastpath Assure Suite is a comprehensive security auditing tool for analysing segregation of duties, critical transactions and key access to systems. While it works with several systems, this series of posts is specifically looking at it working with Microsoft Dynamics GP. Fastpath developed the Assure suite of tools… Continue Reading Ian...
Fixed Assets GL Posting Flow Part 3
Today’s #TipTuesday is a continuation of my Fixed Assets series around G/L posting flow. This post will be the start of what happens during Retirement transactions in Dynamics GP. There are a lot of options around retirements, although in the end most selections don’t impact the results much as you will see. I will be breaking this into different posts to keep the length manageable. Today:… Continue Reading Jen...
Implementing Fastpath’s Assure Suite: Who are Fastpath?
This post is part of the series on Implementing Fastpath's Assure Suite. Before getting to the main subject of the FastPath Assure Suite, I thought it might be useful to give an overview of the company who develops it. That company is Fastpath which is the leading provider of security, audit and compliance solutions for Microsoft Dynamics GP as well as the Dynamics CRM and the other Microsoft… Continue Reading Ian...
Implementing Fastpath’s Assure Suite: Series Index
This series of posts is on the Fastpath Assure Suite of products from Fastpath. I’ve dealt with this product a few times, but have recently implemented it twice, I thought a series of posts would be useful. Over the course of the series, I will cover the installation and configuration of the Assure Suite, but with a specific focus on use of the Audit Trails module; I will return to the series… Continue Reading Ian...
ClassicPress Development with TortoiseGit: Series Index
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. While you can manage your uploads and everything from the GitHub website, I decided it would be somewhat easier to use a Windows application and having used TortoiseSVN, I opted for… Continue Reading Ian Grieve’s...
ClassicPress Development with GitHub: Delete Repository
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. Over the last few posts, I’ve shown how to create and use the GutHub website for managing repositories. I’ve… Continue Reading Ian...
Rewrite domain on Linux hosting to redirect one domain to another
I transitioned from a Windows based host to a Linux based one last year when I changed web host. I had a reasonable understanding of redirecting one domain to another on the Windows host, but am now having to learn how to do it on Linux hosting. I’ve tried doing it through the front-end cPanel controls, but find that it enver works. The most recent one I;’ve tried setting up, I spoke to the… Continue Reading Ian...
Install Dynamics GP Web Services from the command line
I was giving a colleague a hand with a Microsoft Dynamics GP 2018 R2 upgrade recently (the client didn’t want to upgrade to the very latest version) and we encountered a problem with the installation of the Web Services: Setup.exe .NET Framework Error Clr method invocation failed The error message rang a bell, but I couldn;t place it. I did a little investigation and came across a thread on… Continue Reading Ian...
Error loading Hyper-V Virtual Machine Connections
I’ve been using Hyper-V for quite a while and have always just accessed a running VM from the Hyper-V Manager, but you can also use the Virtual Machine Connection. Or you can, in theory, but when you click the drop-down for Virtual Machine you see an error instead of a list of the available virtual machines: I am a local admin on the host machine so, in theory, I should have permissions to… Continue Reading Ian...
Fixed Assets GL Posting Flow Part 2
Back in September, I started a series and honestly figured I would not have taken this long to get to “part 2”! What I’m going to do is make this part of my #TipTuesday series and try to get through it a little bit faster! Today’s post is what happens during the Depreciation routine in Fixed Assets, from a GL posting flow perspective. The previous post in this series was GL posting flow… Continue Reading...
Run escalated PowerShell script from a batch file
I posted a Power Shell snippet a while ago on bypassing the execution policy. More recently I needed to combine that with running a script with administrator permissions. I did a little exploring and found an article by Adam Dimech which contained this code which can be run from a batch file: Change the highlighted section to your saved ps1 file and you can run that script escalated with… Continue Reading Ian Grieve’s...
Stored procedure to get next Dynamics GP Payables Voucher Number
I’ve previously posted SQL stored procedures to get the next GL Journal Number and the next PO Receipt number and today it is the turn of a stored procedure to get the next PM Voucher Number. The stored procedure will call the eConnect stored procedure which gets the next number and increments the stored value. This code was written so I could easily call it from VBA in Integration Manager for… Continue Reading Ian...
ClassicPress Development with GitHub: Commit Files
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. With a repository created, we can now upload the existing project files. Do this by visiting the repository… Continue Reading Ian Grieve’s...
ClassicPress Development with GitHub: Create Repository
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. With us now signed up for GitHub, we can create our first repository. From your dashboard (which is
azurecurve ClassicPress Plugins: All plugins now auto-update
This is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress. I have 35 plugins now published for ClassicPress which have required a manual update whenever I released a new version. Well, CodePotent has developed an Update Manager plugin which can be used to automatically update plugins. This has been integrated into the latest version of… Continue Reading Ian Grieve’s...
Dynamics GP Reconcile to GL missing the option for Inventory
I helped field a query from a client recently on the Reconcile to GL routine (Financial » Routines » Reconcile to GL) showing Payables Management, Receivales Management and Bank Reconciliation, but not Inventory. This client has been a long time user of Microsoft Dynamics GP who had recently upgraded. This issue is a known one, addressed on the Dynamics GP Support and Services Blog. With the… Continue Reading Ian...
azurecurve ClassicPress Plugins: To 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; To Twitter. Functionality Allows posts to be automatically tweeted when they are published. Mark the Post tweet on publish/update? checkbox to post tweet when the post is published (works… Continue Reading Ian Grieve’s...
Wildcard character in Dynamics GP Workflow conditions
I’ve done a lot of work with the Microsoft Dynamics GP Workflow module over the years since it was first released and it still seems to be growing in popularity with clients. Depending on the workflow type being created, the GL account string can be used in conditions to determine the routing for the approver. However, commonly clients want to check the value for a single segment rather than… Continue Reading Ian...
azurecurve ClassicPress Plugins: Markdown
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; Markdown. Functionality This plugin allows a [markdown]shortcode[/markdown] to be applied which will translate markdown into HTML markup for display. Demo Markdown is installed on my… Continue Reading Ian Grieve’s...
“The vendor has an existing purchase order…” error message when using Integration Manager
I’ve recently been working with a client to implement Microsoft Dynamics GP and have been using Integration Manager to import the opening data. While importing payables transactions I encountered the following error: The vendor has an existing purchase order. Choose Continue to post or save. Choose Go To to view a purchasing navigation list. Choose Cancel to return to the window… This… Continue Reading Ian...
azurecurve ClassicPress Plugins: Add Open Graph Tags
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; Add Open Graph Tags. Functionality Add Open Graph Tags to attach rich photos to social media posts to Facebook or LinkedIn, helping to drive traffic to your website. Options allow: Excerpt… Continue Reading Ian Grieve’s...
Back-dating Fixed Asset Retirements
Today’s #TipTuesday is about a message you may receive if you back-date a Fixed Asset retirement in Dynamics GP. I completed a project recently where the client was catching up on some IFRS asset derecognition that, in some cases, had occurred in prior years by the time we got around to doing the retirement in Dynamics GP. While this isn’t an everyday occurrence, if you have to do this… Continue Reading Jen...
SQL Stored Procedure to delete old Microsoft Dynamics GP Document Attachments
The Document Attachment feature was introduced in Microsoft Dynamics GP 2013 RTM and has been enhanced a number of times since. One of the features it does not have is the ability to delete attachments; you can flag them as deleted, but they are not removed from the database. With GDPR rules, clients have become concerned about the information retained in the system without a means to delete… Continue Reading Ian Grieve’s...
SQL View to return Microsoft Dynamics GP Workflow step approvers
I was recently talking to a client who was looking at creating a SQL script which they could run for the auditors which shows the assigned approvers to the steps of a Microsoft Dynamics GP Workflow process. I’d written similar code for others before so I was able to provide them with this view: CREATE VIEW uv_AZRCRV_GetWorkflowSetupStepAssignment AS /*Created by Ian Grieve of… Continue Reading Ian Grieve’s Article on...
ClassicPress Development with GitHub: Sign up for GitHub
When I started developing <a href='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 . The first step to using GitHub for developing with ClasssicPress, is to create a GitHub account; navigate to the landing page, enter a… Continue Reading Ian...
ClassicPress Development with GitHub: Series Index
I have been using ClassicPress to run this blog, and several other sites, since early last year. I have also created new versions of all of my plugins for ClassicPress. When I was working with plugins for WordPress, I used their Plugin Repository for source control which was based off SVN. This wasn’t really the ideal way of doing things, as I should have had my own source control for… Continue Reading Ian Grieve’s...
TLS causing a Microsoft Dynamics GP Workflow approval error
I have recently been doing some work with a client to enable the Web Services for Microsoft Dynamics GP for external approval. This requires a steps to configure them for secure external access; when it was configured we tested on afew devices including Android smart phones and iPhones. We found that everything worked fine, except for the Android devices which returned the following error:
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Paste from Excel in Web Client
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The eighth, and final, new feature from the top user requests, is… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Show the User ID in the Items SmartList
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The seventh new feature from the top user requests, is the storage… Continue Reading Ian...
Checklinks “the keys record has been removed”
Today’s #TipTuesday is about Checklinks, and specifically about a message you may get if you run file maintenance against Sales > Receivables Open Transaction Files. Some general parts of this blog may apply to other errors in checklinks but I’ll focus on this one message for now to keep it simple. File Maintenance Error Message The exact error message looks like this and the text… Continue Reading Jen...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Inactive field added to Item SmartList
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The sixth top requested enhancement is the availability of a column… Continue Reading Ian...
Cdn Payroll Basic Personal Amount calculator
If you are reading this and a user of Microsoft Dynamics GP and Canadian Payroll, you’ll likely have already read my previous post where I’ve indicated that the Canadian Payroll module will not automatically calculate the Basic Personal Amount (Federal) for you. If you are reading this and are not a user of Dynamics GP: don’t worry. The information in this post is generic and should be able… Continue Reading...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Save setting for how to show new POs
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The fifth new feature based on the top requested features, is a new… Continue Reading Ian...
Unlock BitLocker protected drive with PowerShell
I recently needed to unlock a HDD encrypted with BitLocker a number of times. I rapidly decided that entering the password manually every time was not something I wanted to do, so for that day, I needed a command line method of doing it. Fortunately, PowerShell has a commandlet available to do this: $SecureString = ConvertTo-SecureString “{password}” -AsPlainText -Force Unlock-BitLocker… Continue Reading Ian...
Canadian Payroll 2019 YE Update Round 2
Yesterday, Microsoft released a “Round 2” update for Canadian Payroll for Dynamics GP. What is a round 2 update? It’s a change that wasn’t in the first update in December! Typically we don’t see this in Canadian Payroll but the CRA made a relatively last minute change to the federal basic personal exemption that necessitated an update. There are a few minor fixes to be corrected in this round…...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Minimize transaction when Go To is selected for PO that exists
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The fourth enhancement based on top requested features is the… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Exclude Inactive Items on Item Price List Report
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The third enhancement based on the top feature requests is being… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Filter Item Stock Inquiry by Date
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The second enhancement based on the top feature requests is the… Continue Reading Ian...
Microsoft Dynamics GP (18.2) Issue with PSTL After Year End Update 2019
Two of my clients have now had this issue. Both of these clients have been upgraded over the years and started on GP before GP2013. After the 2019 YE Update, Professional Services Tools Library …(read more) Continue Reading Jo deRuiter’s Article on their blog Microsoft Dynamics GP (18.2) Issue with PSTL After Year End Update 2019 Two of my clients have now had this issue. Both of these clients have been upgraded over...
Excel Background Refresh & Pivot Tables
Welcome to my first 2020 #TipTuesday post. Today’s topic is Excel and how a background refresh setting can impact refreshing pivot tables. The background to this post is related to a report I was creating for a client to validate timesheets prior to approval. The report has a couple of queries in them (from SQL) and a pivot table to summarize the data. In order to make the refreshing… Continue Reading Jen Kuntz’s...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Copy Report Option
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. The first enhancement from the top requested features is the… Continue Reading Ian Grieve’s...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Series Index
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series. This post is the series index for the top feature requests made to… Continue Reading Ian...