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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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(
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...