Power Platform ALM – Visual Studio Code Extensions
Aug03

Power Platform ALM – Visual Studio Code Extensions

Learn about Power Platform extension for Visual Studio Code and how this toolset is improving both the code first developer experience and strengthening the ALM story.  The following topics are covered:  (0:00) – Intro (1:16) – Installing the Power Platform extensions for Visual Studio Code (2:13) – Working with the Power Platform CLI inside of Visual Studio Code (3:42) – Authenticating...

Read More
Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)
Aug02

Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)

I revisit an old video I did couple years ago showing how to pass collections from Power Automate to Power Apps.  This time around, I show how to leverage arrays to accomplish the same. This time around you will learn about:Power Apps trigger in Power Automate Get Rows SQL action Variables actionSelect action and ArraysResponse actionPower Apps Collections To check out my YouTube channel visit: <a… Continue...

Read More
Recent ISC Software Webinar: Lesser Used Modules In Microsoft Dynamics GP
Jul26

Recent ISC Software Webinar: Lesser Used Modules In Microsoft Dynamics GP

In our most recent webinar, we took a look at Lesser Used Modules In Microsoft Dynamics GP. In this webinar, we took a look at some of the lesser known, but very useful modules in Microsoft Dynamics GP. If you want to catch up on this, or any other, webinar, you can do so here. Introduction Licensing Available Modules Starter Pack Extended Pack Lesser User Modules Foundation All-in-One… Continue Reading azurecurve’s...

Read More
New ClassicPress Documentation Hub Now Live
Jul20

New ClassicPress Documentation Hub Now Live

The new ClassicPress Documentation Hub is now live with user and developer guides as well as the Plugins Guidelines for the ClassicPress Plugin Directory, but the big addition is the ClassicPress Code Reference. The bulk of the work done to build the new site was done by Beda Schmid who also wrote the announcement post on the ClassicPress blog. The code reference means that developers can now… Continue Reading azurecurve’s...

Read More
Error Purchasing Requisition in Microsoft Dynamics GP
Jul16

Error Purchasing Requisition in Microsoft Dynamics GP

I’ve been working with a client to create a new standalone Microsoft Dynamics GP test system. We copied the databases to the new SQL Server and were progressing through several tasks making sure everything was aligned and working correctly as they have a number of add-ins which needed to be installed. One user testing the purchasing module encountered an error when trying to transfer a… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP 2016 Now Out of Mainstream Support
Jul14

Microsoft Dynamics GP 2016 Now Out of Mainstream Support

A couple of days ago, I posted about the updated Microsoft Dynamics GP roadmap which goes through 2028. One item which is worth noting, is that Microsoft Dynamics GP 2016 RTM and 2016 R2 are both out of mainstream support as of yesterday and those versions are now in extended support. This means that critical security issues found will be fixed, but no feature enhancements or other bugs will… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP Roadmap to 2028 and Beyond
Jul12

Microsoft Dynamics GP Roadmap to 2028 and Beyond

Terry Heley on the Dynamics GP Support and Services Blog posted an article on Friday on the exciting future of Microsoft Dynamics GP and giving a Lifecycle Update. As part of the article she inked to the published Lifecycle (Roadmap) for Microsoft Dynamics GP which extends to 2028 and beyond for Microsoft Dynamics GP. The published roadmap also shows the end of mainstream and extended support… Continue Reading azurecurve’s...

Read More
ClassicPress Plugin Development: Load Options with Defaults
Jul11

ClassicPress Plugin Development: Load Options with Defaults

This post is part of the ClassicPress Plugin Development series in 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. In the last post I covered saving and loading options in a ClassicPress plugin. When you create a plugin with options you will want to provide defaults to be used before the… Continue Reading...

Read More
ClassicPress Plugin Development: Load and Save Options
Jul10

ClassicPress Plugin Development: Load and Save Options

This post is part of the ClassicPress Plugin Development series in 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 a plugin, most of them will have settings which need to be saved ad recalled. There are functions available in ClassicPress which you can use to do… Continue Reading azurecurve’s Article...

Read More
Excel Snippets: Generate Row Numbers
Jul09

Excel Snippets: Generate Row Numbers

I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. A while ago, I posted an article on generating row umbers in a SQL script; I fielded a question from someone recently on doing the same thing Excel where the row number changes based on two columns of data. Basically when either of the columns were different, the row… Continue Reading...

Read More
SQL Snippets: Manage Data Containing an Apostrophe
Jul08

SQL Snippets: Manage Data Containing an Apostrophe

This post is part of the series on SQL Snippets. I was doing some work with a client recently and they had an issue with some data in SQL Server which they needed change, but weren’t able to do it through the application. The issue was that they had some names in a column marked as a key field which contained an apostrophe and it was causing them problems; the data should not have had an… Continue Reading...

Read More
SQL Snippets: Series Index
Jul07

SQL Snippets: Series Index

This post is the series index for the series on SQL Snippets. This series will build up through time as I post snippets of SQL Script; I’ll also go back and update some of the previously posted SQL snippets to bring them together into one index. SQL Snippets Read original post SQL Snippets: Series Index at azurecurve|Ramblings of an IT Professional Continue Reading azurecurve’s Article on their blog SQL Snippets: Series...

Read More
Validate and Insert/Update Vendor Emails in Microsoft Dynamics GP from a Text File
Jul06

Validate and Insert/Update Vendor Emails in Microsoft Dynamics GP from a Text File

I’ve previously posted a script which could be used to update emails in Microsoft Dynamics GP from a tab delimited text file. I’ve recently been working on a project with a client and created a variation on that script which works only for vendor emails, but validates the data before inserting or updating to ensure that the data is valid. The original script took it on trust that the data was… Continue Reading...

Read More
ClassicPress Plugin Development: Create Submenu for a Custom Post Type
Jul04

ClassicPress Plugin Development: Create Submenu for a Custom Post Type

This post is part of the ClassicPress Plugin Development series in 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. If you’ve created a plugin with a custom post type you can add additional submenus to the custom post types top level menu. I typically use this to add the options page of… Continue Reading...

Read More
ClassicPress Plugin Development: Create Custom Post Type
Jul03

ClassicPress Plugin Development: Create Custom Post Type

This post is part of the ClassicPress Plugin Development series in 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. ClassicPress is intended to be extended and customised and has numerous ways this can be done. Shortcodes are a common way of doing this, but another way is to create a… Continue Reading azurecurve’s...

Read More
MVP Renewal for 2021/2022
Jul02

MVP Renewal for 2021/2022

I was fortunate to be renewed today for the Microsoft MVP award, for the 5th time. When I got awarded the first time in October 2016, I never dreamed that I would be still here 5 cycles later. This year is bittersweet for me, as I’m only getting renewed due to the generosity of the Microsoft MVP Award program team. I only had a single-digit number of contributions logged, far from my normal… Continue Reading Jen...

Read More
Show Value for the Last Date in Microsoft Power BI
Jul01

Show Value for the Last Date in Microsoft Power BI

Another Tiny Tip! Recently I was asked how to only show the data for the last date in a Microsoft Power BI dataset.  I immediately said “DAX”, but ended up with some complexity that was not necessary.  After some rounds with DAX and M, my “aha” moment occurred.  Actually, it was more my “inner data modeler” saying “Belinda….  Get With It!” Filters…  Filters is all… Continue Reading Belinda Allen’s...

Read More
GP Upgrades – know your environment part 3
Jun29

GP Upgrades – know your environment part 3

In my last post, I continued on the “know your environment” topic. So far I have 2 parts to that with a background on the elements to be aware of with core Microsoft components of Dynamics GP plus ISV products, where they are modules/functionality within the Dynamics GP client. In this post, I will delve into external ISV products. Posts in the series Series introProcess overviewKnow… Continue Reading Jen...

Read More
SQL Script to Assign All Bins to All Items in Microsoft Dynamics GP
Jun29

SQL Script to Assign All Bins to All Items in Microsoft Dynamics GP

I try to do as much through the front-end of Microsoft Dynamics GP as possible in order that the correct business logic be applied to the changes as possible. However, sometimes doing it that way takes far too much time. Recently when working with a particular client, we needed to assign all bins to all items. Bins were being being introduced so there were no bins currently assigned, which… Continue Reading azurecurve’s...

Read More
ClassicPress Plugin Development: ClassicPress Plugin Development: Rename First Sublevel Menu of a Custom Top Level Menu
Jun27

ClassicPress Plugin Development: ClassicPress Plugin Development: Rename First Sublevel Menu of a Custom Top Level Menu

This post is part of the ClassicPress Plugin Development series in 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. In the last post I showed how to create a custom top level menu and mentioned it creted both the top level menu and a sublevel menu of the same name. As the below example,… Continue Reading azurecurve’s...

Read More
azurecurve ClassicPress Plugins: Remove Revisions
Jun26

azurecurve ClassicPress Plugins: Remove Revisions

This is part of the azurecurve ClassicPress Plugins series which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is one written specifically for ClassicPress ; Remove Revisions. Functionality While revisions can be disabled or limited in number with settings in the wp-config file, there is no way to allow for the deletion of revisions over… Continue Reading...

Read More
Canadian Payroll Mid-Year Update 2021
Jun23

Canadian Payroll Mid-Year Update 2021

A week or so ago, the mid-year update for Dynamics GP was dropped. For Dynamics GP Canadian Payroll users, there are only tax changes in 1 jurisdiction – New Brunswick. In addition to the CPY updates, there are a number of other fixes in this update. As is typical with the mid-year update, it is more than just Canadian Payroll updates, it’s a full service pack. For all of the details on the… Continue Reading Jen...

Read More
Fixing “This share requires the obsolete SMB1 protocol…”
Jun23

Fixing “This share requires the obsolete SMB1 protocol…”

This is actually an older issue, I didn’t post about as I first came across it months after Microsoft made the change. However, I’ve seen it come up a few times recently after installing Windows updates, so I am posting this as a reminder of how to fix the issue. I have seen this on a couple of client sites which has been referred to the client’s IT department to take action, but I also get… Continue Reading...

Read More
GP Upgrades – know your environment part 2
Jun22

GP Upgrades – know your environment part 2

In my last post in this Dynamics GP upgrade series, I talked about getting to know your environment. The importance of understanding some of the moving parts cannot be understated, if you are “in charge” of your environment in any meaningful way. Reading this series won’t allow you to bypass utilizing a partner or consultant for some things, but hopefully it gives you more background to… Continue Reading Jen...

Read More
Trust Relationship Between This Workstation and the Primary Domain Failed
Jun22

Trust Relationship Between This Workstation and the Primary Domain Failed

Having never seen the below error message before, I have now seen it twice in the last few weeks. The first time was when I started a VM running an old version of Microsoft Dynamics GP for the first time in a few months; the second was when I copied the VM from my laptop onto the server which had a previous copy of the domain controller VM. The second instance was not unexpected, but at least… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP Workflow Navigation Lists Not Working Correctly After Upgrading
Jun21

Microsoft Dynamics GP Workflow Navigation Lists Not Working Correctly After Upgrading

I’ve been involved with a number of upgrade projects recently where we were both upgrading the client to the latest version of Microsoft Dynamics GP, but also introducing some new functionality such as workflow for approvals. Quite a few of these clients are long time users of Dynamics GP who started on version 9 or before. This means that in most cases, when introducing workflow, we find that… Continue Reading...

Read More
azurecurve ClassicPress Plugins: Disable FLoC
Jun20

azurecurve ClassicPress Plugins: Disable FLoC

This is part of the azurecurve ClassicPress Plugins series which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is one written for ClassicPress by John Alrcon which I have now adopted; Disable FLoC. Functionality Have you ever heard of “Federated Learning of Cohorts” – or FLoC? It is Google’s next-generation technique for tracking users… Continue Reading...

Read More
azurecurve ClassicPress Plugins: Username Protection
Jun19

azurecurve ClassicPress Plugins: Username Protection

This is part of the azurecurve ClassicPress Plugins series which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is one written for ClassicPress by John Alrcon which I have now adopted; Username Protection. Functionality This plugin allows you to remove anonymous access to usernames in ClassicPress to help mitigate brute-force attacks. For… Continue Reading...

Read More
SQL Function to Return Last Workflow Final Approval Date
Jun18

SQL Function to Return Last Workflow Final Approval Date

The below SQL function returns the last Microsoft Dynamics GP workflow final approval date and time; it is always returned, not just when final approved is the current status. This function was created to be used in a check of approved documents to see when they had last been approved; it was used in conjunction with the SQL function which returns the current workflow status. IF object_id(

Read More
Centralising Dictionaries in Microsoft Dynamics GP
Jun17

Centralising Dictionaries in Microsoft Dynamics GP

For as long as I’ve been working with Microsoft Dynamics GP, I’ve been setting clients up with centralised forms and reports dictionaries in order to simplify deployment. As long as you’re not using VBA which needs to be installed onto each client, centralising the forms and reports dictionaries means you can import and customisations omly once. If each client machine has its own local forms… Continue Reading...

Read More
Setting a Default Location for the Integration Manager Database
Jun16

Setting a Default Location for the Integration Manager Database

Integration Manager installs with a sample database in the install folders as the default database. In virtually every case, the clients I work with have a centralised database shared by all clients. While users can amend the path through the Integration Manager application, you can also add a setting in the Microsoft.Dynamics.GP.IntegrationManager.ini file (by default located in C:Program… Continue Reading azurecurve’s...

Read More
GP Upgrades – know your environment
Jun16

GP Upgrades – know your environment

This is the 3rd post in my series about GP Upgrades. Today’s topic is what I refer to as “getting to know your environment”, as part of the planning process around your upgrade. If you are planning an upgrade, it’s important to understand where the moving parts are, and at least to have what I refer to as a “conversational” knowledge of your GP system, even if you aren’t familiar with...

Read More
Slow Login Into One Microsoft Dynamics GP Company
Jun15

Slow Login Into One Microsoft Dynamics GP Company

I’m working on a few projects for a client at the moment and became aware that logging into their main company was taking almost a minute. Most of the work had been in subsidiaries at the start of the projects, but we’ve moved into the main company now. The subsidiaries are quite quick to log into, say 10 seconds, but the main company was over a minute. It didn’t matter if this was logging… Continue Reading...

Read More
New Location For The Microsoft Dynamics GP Developer Documentation On Microsoft Docs
Jun14

New Location For The Microsoft Dynamics GP Developer Documentation On Microsoft Docs

I’ve been using, off and on, the eConnect developers documentation for a number of years. However, it seems that Microsoft have now closed down the old location and moved the documents to the Microsoft Docs website. The new location is here. I’m posting this here as it took me a long time to actually find the new location. Read original post New Location For The Microsoft Dynamics GP Developer… Continue Reading...

Read More
azurecurve ClassicPress Plugins: Estimated Read Time
Jun13

azurecurve ClassicPress Plugins: Estimated Read Time

This is part of the azurecurve ClassicPress Plugins series which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is one written for ClassicPress by John Alarcon which I have now adopted; Estimated Read Time. Functionality This plugin allows you to display expected reading times on your articles and summaries; a filter allows the read time to… Continue Reading...

Read More
Happy 10th Birthday to azurecurve
Jun12

Happy 10th Birthday to azurecurve

My first post on this site, was 10 years ago today. I had been working with Microsoft Dynamics GP for about 8 years by that time, making a lot of use of blogs by people like David Musgrave, Mark Polino, Leslie Vail and a few others. I’d been running other websites and thought I’d give bogging a go and see if I could contribute back to the Dynamics GP community. In 10 years, I have posted… Continue Reading...

Read More
VBA Snippets: Open a File for Appending
Jun11

VBA Snippets: Open a File for Appending

This post is part of the series on VBA Snippets. The below VBA script can be used to open a text file for appending and then write a line to the bottom of the file; it could be combined with the example in this eries’ last post on selecting records from a Microsoft Dynamics ODBC connection to out put multiple lines. The highlighted section is the path of the output file. Dim objFSO As… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP 2021 Mid-Year Update Released
Jun10

Microsoft Dynamics GP 2021 Mid-Year Update Released

The 2021 Mid-Year update for Microsoft Dynamics GP 2016 and Fall 2020 (18.3) has been released. Full details of the release and download links are available on the Dynamics GP Support and Services Blog. The key piece of new functionality is support for Group VAT functionality in the VAT 100 window in the 18.3 release (this new functionality has not been rolled back to Dynamics GP 2016). The… Continue Reading azurecurve’s...

Read More
User Has Error Logging Into Microsoft Dynamics GP: The stored procedure smCleanupFilesBeforeLogin…
Jun09

User Has Error Logging Into Microsoft Dynamics GP: The stored procedure smCleanupFilesBeforeLogin…

I’ve been working with a client a lot recently, so when one of their users was not able to log into Microsoft Dynamics GP today, they got in touch. The problem only affected one user who got the below error message; all other users were unaffected and could log in normally: The stored procedure smCleanupFilesBeforeLogin returned the following results: DBMS: 0, Microsoft Dynamics GP: 20505. This… Continue Reading...

Read More
Disable Microsoft Word Dark Mode
Jun08

Disable Microsoft Word Dark Mode

A recent update to Microsoft Word saw the page background change from the white which has been used since forever; I’m assuming that I saw this change as I have office set to use the black theme. However, while I want the window black, I don’t want the page background to be black; I want it to continue being white. There is a button on the action pane, on the View tab which allows you to… Continue Reading...

Read More
ClassicPress Plugin Development: Create Submenu on Custom Top Level Menu
Jun06

ClassicPress Plugin Development: Create Submenu on Custom Top Level Menu

This post is part of the ClassicPress Plugin Development series in 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. Once you have added a custom top level menu for your plugin, you can add submenu items. This is done using the add_submenu_page function: add_submenu_page(string… Continue Reading azurecurve’s Article on...

Read More
ClassicPress Plugin Development: Create Custom Top Level Menu
Jun05

ClassicPress Plugin Development: Create Custom Top Level Menu

This post is part of the ClassicPress Plugin Development series in 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. While it is most common to add an option spage for a plugin to the Settings or Security top level menu, it is possible to create a custom top level menu. A top level menu… Continue Reading Ian Grieve’s...

Read More
Recent ISC Software Webinar: Business Intelligence with Microsoft Dynamics GP
Jun04

Recent ISC Software Webinar: Business Intelligence with Microsoft Dynamics GP

In our most recent webinar, we took a look at Business Intelligence with Microsoft Dynamics GP. In this webinar, we covered how business intelligence can be used with Microsoft Dynamics GP. If you want to catch up on this, or any other, webinar, you can do so here. Introduction What is Business Intelligence? What is Jet Analytics? Reporting options with Jet Analytics Jet Reports Excel… Continue Reading Ian Grieve’s Article...

Read More
VBA Snippets: Select Records from Microsoft Dynamics ODBC Connection
Jun03

VBA Snippets: Select Records from Microsoft Dynamics ODBC Connection

This post is part of the series on VBA Snippets. In yesterdays post, I covered adding an ODBC connection to Microsoft Dynamics GP VBA for use n windows or reports. The below is an example of a SQL query using the ODBC connection. SOPType and SopNUmber (highlighted) are fields from a window added to the VBA. This example retries a list of fields from the Sales Transaction Amounts Work… Continue Reading Ian Grieve’s Article...

Read More
VBA Snippets: Adding an SQL ODBC Connection in Microsoft Dynamics GP
Jun02

VBA Snippets: Adding an SQL ODBC Connection in Microsoft Dynamics GP

This post is part of the series on VBA Snippets. There is an ADO connection available to VBA within Microsoft Dynamics GP which you can use, but there are some steps you need to follow to use it. The first step is to declare the variable which will hold the connection. Private madoConn AS ADODB.Connection Then you need to create the connection which this example does using a Connect… Continue Reading Ian Grieve’s Article...

Read More
ClassicPress Plugin Development: Add Plugin Options Page to Security Main Menu
May30

ClassicPress Plugin Development: Add Plugin Options Page to Security Main Menu

This post is part of the ClassicPress Plugin Development series in 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 a plugin, it is usual to create an options page to allow users to configure the plugin. The most common way of making the plugin options page available to… Continue Reading Ian Grieve’s...

Read More
ClassicPress Plugin Development: Add Plugin Options Page to Settings Main Menu
May29

ClassicPress Plugin Development: Add Plugin Options Page to Settings Main Menu

This post is part of the ClassicPress Plugin Development series in 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 a plugin, it is usual to create an options page to allow users to configure the plugin. The most common way of making the plugin options page available to… Continue Reading Ian Grieve’s...

Read More
More Matrix (visual) formatting in Microsoft Power BI
May27

More Matrix (visual) formatting in Microsoft Power BI

The Microsoft Power BI Matrix visual has more features waiting to be unlocked with formatting.  In this Tiny tip, I will show you some of my preferred formatting options.  Specifically, I will show: Changing the Text sizeChanging the alignment of a columnConditional formatting for a column of valuesChanging the values to display as rows rather than columns. The last feature can be a… Continue Reading Belinda...

Read More
SmartList Export: Excel content error
May27

SmartList Export: Excel content error

Last year, I wrote a post about a relatively common SmartList Export error, the “Excel cannot open the file” error. Today, I was working on a client upgrade and cleaned up a ton of minor issues with some Canadian Payroll smartlists they use. In writing this post, I have also developed a quick hatred for SmartList Designer, as you will read later in the post. You’re welcome, eOne Solutions…. Continue Reading Jen...

Read More
GP Upgrades – process overview
May25

GP Upgrades – process overview

Last week I posted the first in a series I am writing relating to Dynamics GP upgrades. This week’s topic is an overview of what the process looks like for many organizations, from the point of view of upgrades I’ve done or been involved with. At the end of this post I’ve included a Context section to further clarify what my background is which will heavily shape the recommendations and… Continue Reading Jen...

Read More