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...
Separately compress all sub folders
I started using WordPress for this blog when it launched in June 2011 until last year when, with Gutenberg on the horizon, I migrated to ClassicPress. This migration was easy as ClassicPress is a hard-fork of WordPress 4.9. As part od the migration I opted to rewrite all of my plugins to improve them and make them more secure. I have 32 publically available plugins for ClassicPress. I’ve… Continue Reading Ian...
Calculate distance using longitude and latitude on MariaDB
I’ve recently been doing some more work on my coppr|Distilleries to Visit website and have added Nearest Distilleries and Nearest Attractions sections where I show the nearest 20 distilleries or attractions to the one beign viewed. To do this I loaded GPS co-ordinates to each page and then needed to work out how to calculate the distance between them. Initially I found the ST_Distance MySQL… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Vendor approval enhancements
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 and final enhancement to workflow is that the vendor… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Change approver for active workflow tasks
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 workflow enhancement to Microsoft Dynamics GP is the… Continue Reading Ian...
azurecurve ClassicPress Plugins updated
I migrated to ,a href=’https://www.classicpress.net’/>ClassicPress last year and created ClassicPress versions of all of my plugins. This wasn;t just a case of creating an alternate versions, but extensively rewriting them in order to both add new functionality and to improve their security. I’ve recently made changes to them all again to further improve them. If you use any of my plugins list… Continue...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Export and import workflows
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 workflow enhancement is not a new workflow type, but… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Security Tasks Workflow
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 workflow enhancement is the addition of a new workflow… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Security Roles Workflow
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 workflow enhancement is the addition of a workflow… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: User Security Workflow
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 workflow enhancement is the addition of a user… Continue Reading Ian Grieve’s...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: User Workflow
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 of the workflow enhancements is Workflow approval for… Continue Reading Ian...
New Year’s Resolutions 2020
It’s time to look back on the year 2019 and the last 10 years. I won’t say “the last decade” lest the mansplainers get their shorts in a knot about it technically not being the end of the decade. 10 years ago, I was 4 months into my own consulting business. In 2019, I started the year in an employment role but went back to full time independent consulting in June. Long story short: I think… Continue...
Happy New Year
A Happy new Year to everyone in the Microsoft Dynamics GP and ClassicPress communities and to anyone else reading this. Following on from my Christmas music video, here is Dougie MacLean, OBE, a Scottish singer-songwriter, composer, multi-instrumentalist and record producer with the traditional Scottish song Auld Lang Syne: (Visited 3 times, 2 visits today) Continue Reading Ian Grieve’s Article on their blog Happy New Year A...
Top 10 Blog Posts from 2019
This is a look back at what posts had the most views during 2019. I believe it’s the 3rd year I’ve done this and it is always interesting what old posts continue to be relevant (or at least “hit” via search). The first year I did this, only 4 posts from that year made the top 10, and last year 7 of my 2018 posts hit the top 10. This year 6 posts from 2019 made the top 10… and once again, a… Continue...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Series Index
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements series where I am going hands on with the workflow enhancements 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 workflow enhancements made… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Show Check Number in Apply Sales Document window
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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, and last, financial enhancement is the display of… Continue Reading Ian...
PowerShell to run script bypassing execution policy
In yesterday’s article, I posted a script which can be used to download and delete files from a folder on an FTP site. When I tested it on one computer it worked fine, but on another it failed as the running of PowerShell is restricted. To avoid this error the PowerShell script can be saved to a file with a ps1 extension and then executed using the following (replace the highlighted section… Continue Reading Ian...
Canadian Payroll 2019 Year End Update
This post is extremely late, but I wanted to get it out there anyway for those that have just concluded their last 2019 payrolls for the year. The Canadian Payroll 2019 year end tax updates for Dynamics GP were released on December 18th. Here are some links to get you what you need for this year end. Two reminders for you, depending on what version you are operating: If you are… Continue Reading Jen Kuntz’s Article on...
PowerShell script to download all files from FTP folder then delete files
A few weeks ago, I did an article on making folder backups on an FTP site and <a href='https://www.azurecurve.co.uk/2019/12/making-compressed-mysql-backups-using-cron/'compressed MySQL backups using Cron. With the backups made, they need to be downloaded and this is not something I want to do manually. My initial thought was VBA until common sense kicked in and I opted for PowerShell. I found… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Visual Cue for EFT Vendor on Edit Payment Batch
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancement is the addition of a visual cue… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Document Attach available in Bank Reconciliation
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancement is the addition of Document… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Add Class ID to Fixed Assets Transfer
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancement is the addition of Class ID to… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Show user who posted for Journal Entry Inquiry
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancement is the addition of a User Who… Continue Reading Ian...
Making compressed MySQL backups of multiple databases using Cron
I’ve posted a couple of articles now on making MySQL backups using Cron, time-based scheduler, on Linux based hosting. This is, currently, the last post on this subject. The examples so far have been on backing up single databases, but it is possible to backup multiple databases using one command. The below example shows the syntax to make a compressed backup of all mySQL databases, with the… Continue Reading Ian...
Making compressed MySQL backups using Cron
Earlier this moth I posted an article on making MySQL backups using a href=’https://en.wikipedia.org/wiki/Cron’>Cron, time-based scheduler, on Linux based hosting. Since then I’ve realised that I have two databases which are well over 1GB in size and have now looked into making compressed backups. The below example shows the syntax to make a compressed backup of a mySQL database, with the… Continue Reading...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Expand the view of fiscal periods
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancement is to the Fiscal Period Setup… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Long description for payables transaction entries
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancement is the addition of a Long… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Series Index
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements 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 financial enhancements… Continue Reading Ian...
Power Apps | Robotic Process Automation with AI Builder and UI flow (Part 3/3)
This is the final installment of a 3-part series vlog on Robotic Process Automation with Power Automate UI flows and Microsoft Dynamics GP. In this final episode, I am adding AI Builder capabilities to present an end-to-end solution that you can implement in your business now. This video shows how to combine the power of AI Builder form processing to read a sample utility bill and submit it… Continue Reading Mariano...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: More than 32 report options in Report Group
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements 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 and final enhancement in the System module is the ability… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Filter inactive users in User Access Setup
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements 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 of the new features in the system module, is the ability to… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Sort companies in User Access Setup
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements 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 of the new features in the system module, is the ability… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Date options in SmartLists
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements 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 of the new features in the system module, is the addition… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Compatibility with SQL Server 2019, Windows Server 2019, and Office 2019
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements 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. It strikes me as being a little odd to include compatibility in as a… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Series Index
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements 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 system enhancements made to… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release New Features: Series Index
Following the release of the Microsoft Dynamics GP October 2019 Release, I have recently been hands on installing the new version. Just prior to the release Microsoft did a series of Feature of the Day posts which I echoed and added my thoughts. The Feature of the Day posts didn’t cover all of the new functionality, just the highlights. Well, now that I can go hands on with the new features, I… Continue Reading Ian...
Making folder backups using Cron
As I mentioned in yesterdays post on ,a href=’https://www.azurecurve.co.uk/2019/12/making-mysql-backups-using-cron/’>making backups of mySQL databases, earlier this year I migrated from a Microsoft Windows based web hosting package to a Linux based one. This meant I had to learn a few new ways of doing things, such as backing up databases or files, on a regular repeating basis. This is… Continue Reading Ian...
Making mySQL backups using Cron
Earlier this year I migrated from a Microsoft Windows based web hosting package to a Linux based one. This meant I had to learn a few new ways of doing things, such as backing up databases or files, on a regular repeating basis. This is accomplished on Linux web hosts using the Cron time-based scheduler. I needed to create two types of cron jobs; one to backup databases and one to backup… Continue Reading Ian Grieve’s...
Hands On with Microsoft Dynamics GP October 2019 Release: Install GP Add-in for Microsoft Word
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. The Microsoft Dynamics GP Add-in for Microsoft Word allows the Word Templates used for outputting vendor or customer documents to be amended and have new fields added to them. Things work best if you have both the Microsoft Dynamics… Continue Reading Ian Grieve’s...
Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. The OData service allows for reporting services such as PowerBI to connect to Microsoft Dynamics GP. This post is going to focus on installing the OData service, but at the bottom of this post I’ve included details of a book,… Continue Reading Ian Grieve’s...
Hands On with Microsoft Dynamics GP October 2019 Release: Install GP PowerShell
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. The GP PowerShell module can be used to execute commands against Microsoft Dynamics GP such as creating a new company. The installation is a straightforward one which only needs to be done on a machine on which it nwill be used; there… Continue Reading Ian...
Hands On with Microsoft Dynamics GP October 2019 Release: Verify Web Services
This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. With Web Services not installed, the final step is to verify that everything is working correctly; the steps to verify are the same as those for Dynamics GP 2018 R2 so you can follow the instructions in that post. If the Windows… Continue Reading Ian Grieve’s...