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
ClassicPress Plugin Development: Create a Plugin Action Link
May23

ClassicPress Plugin Development: Create a Plugin Action Link

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 with an settings page, it is quite common to add a link to the settings page on the Plugins page; these links are known as plugin action links. This… Continue Reading Ian...

Read More
ClassicPress Plugin Development: Best Practice for Loading Styles and Themes
May22

ClassicPress Plugin Development: Best Practice for Loading Styles and Themes

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. Over the last few posts, I have covered how to register and enqueue scripts and styles. In the posts on loading the admin styles and scripts I mentioned a check to only load… Continue Reading Ian...

Read More
SQL Query to get First Level Items from Microsoft Dynamics GP Manufacturing BOM
May20

SQL Query to get First Level Items from Microsoft Dynamics GP Manufacturing BOM

We’re currently doing some work for a client using the Manufacturing module of Microsoft Dynamics GP and I’ve been involved in the periphery of the manufacturing element while focusing on the financial and distribution parts, but have been assisting with some reporting items. One of them was to help create a report on the Mfg BOM showing only the first level items. The below script, against… Continue Reading Ian...

Read More
Find All Microsoft Dynamics GP Companies With Web Services Enabled
May19

Find All Microsoft Dynamics GP Companies With Web Services Enabled

I’ve recently been doing some work with a client which necessitated the backup of all databases using the Web Services for Microsoft Dynamics GP. The easiest way to determine which databases had the web services enabled, was to run a script checking the Workflow Setup (WF00100) table. I took a copy of my return functional currency for all companies script and amended it to look at the web… Continue Reading Ian...

Read More
GP Upgrade Tips series intro
May18

GP Upgrade Tips series intro

I’m finally ready to get back into a regular blogging rhythm and will be starting a series around Dynamics GP upgrades. I’ve presented on this topic a few times and what I plan on covering is how I approach and manage upgrades. What this series will not be about are the technical “how to upgrade” aspects. There are plenty of other articles out there covering the actual upgrade process and… Continue...

Read More
ClassicPress Plugin Development: Loading Back-End Scripts
May16

ClassicPress Plugin Development: Loading Back-End Scripts

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. jQuery itself is automatically loaded by ClassicPress so we don’t need to do anything to load this ourselves in a plugin; it is just our own jQuery script which we need to… Continue Reading Ian...

Read More
ClassicPress Plugin Development: Loading Front-End Scripts
May15

ClassicPress Plugin Development: Loading Front-End Scripts

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. jQuery itself is automatically loaded by ClassicPress so we don’t need to do anything to load this ourselves in a plugin; it is just our own jQuery script which we need to… Continue Reading Ian...

Read More
Using Small Multiples in Microsoft Power BI
May14

Using Small Multiples in Microsoft Power BI

Microsoft Power BI has a cool feature in Preview, that allows you to split a single visual into multiple visuals based on a filter.  In this video, I take Sales by Customer Class (Group/Category), create small multiples based on the class, and make the axis a class for Items sold. This feature works on several of the “out of the box” visuals.  In the attached video, I will use a… Continue Reading Belinda Allen’s...

Read More
SQL View to Return Microsoft Dynamics GP Item Number Split by Hyphens
May12

SQL View to Return Microsoft Dynamics GP Item Number Split by Hyphens

As with most of the other views I have posted, this is one I have written a few times over the years and am now posting it to make it easy to find next time I need it. This view returns the Item Number from the Item Master (IV00101) table split into sections by hyphens. It assumes the item number has up to three sections, but can easily be extended. With the view deployed, it can easily be… Continue Reading Ian Grieve’s...

Read More
Microsoft Dynamics GP Purchasing All-In-One View Product 258 Error
May11

Microsoft Dynamics GP Purchasing All-In-One View Product 258 Error

I’m working on an implementation project at the moment to migrate a company from an older ERP into Microsoft Dynamics GP for an existing client using Dynamics GP and have been doing a lot of training. One area I covered was the All-in-One View enquiries in Purchasing, Inventory and Sales. After the training one of the users have exploring the system and found that the drilldown from an invoice… Continue Reading Ian...

Read More
ClassicPress Plugin Development: Loading Back-End Stylesheets
May09

ClassicPress Plugin Development: Loading Back-End Stylesheets

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. All of the plugins I have written have a settings page in the admin dashboard, either for settings to be configured or for instructions on how to use the plugin. I often… Continue Reading Ian Grieve’s...

Read More
ClassicPress Plugin Development: Loading Front-End Stylesheets
May08

ClassicPress Plugin Development: Loading Front-End Stylesheets

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. Virtually all of the plugins I have written have output to the front end of a site, usually through use of shortcodes. As there is front end output, I have needed to create… Continue Reading Ian Grieve’s...

Read More
GeneralUser Error When Migrating Management Reporter to a New Server
May07

GeneralUser Error When Migrating Management Reporter to a New Server

Across the years since it was launched I have done a lot of work with Management Reporter, including many migrations to new servers and upgrades which necessitated a migration to a new server or instance of SQL Server, but have never seen this particular error message before. In this case, I migrated the Management Reporter database to a new server and installed the very latest version of the… Continue Reading Ian Grieve’s...

Read More
Remove all notes in PowerPoint
May06

Remove all notes in PowerPoint

WOW, it’s been some time since I last blogged. I’m alive and well and finally getting back to the right mindset to get back into this. Stay tuned! This is a super easy tip that I learned today. I also learned I’m a super lazy PowerPoint creator. I create PowerPoint presentations by copying the last presentation I did and duplicating a bunch of slides that have the layout I like. 40 slides… Continue Reading Jen...

Read More
Update Microsoft Dynamics GP Customer Emails on Test Including Sent Emails
May06

Update Microsoft Dynamics GP Customer Emails on Test Including Sent Emails

After creating a new script for updating vendor emails on test which includes the emails of sent items, I figured that a similar script will be needed to update the email address on sent emails in the Sales Series. The script below, includes the tables holding sent email information for the Sales Series emails (both Receivables Management and Sales Order Processing) as well as the usual… Continue Reading Ian Grieve’s...

Read More
Matrix (visual) totals and subtotals in Microsoft Power BI
May05

Matrix (visual) totals and subtotals in Microsoft Power BI

In this Tiny Tip, Belinda will uncover the secrets on getting only the (sub)totals that you want to see, using the Microsoft Power BI Matrix visual. The most important thing to note is that the Grand Total is a Sub-total.  This means if you turn off the Sub-Totals, the grand totals disappear as well. The Grand Totals will only always stay visible on the visual if you have the Stepped… Continue Reading Belinda Allen’s...

Read More
Update Microsoft Dynamics GP Vendor Emails on Test Including Sent Emails
May05

Update Microsoft Dynamics GP Vendor Emails on Test Including Sent Emails

About 10 years ago I did a post on changing emails on the test system so they didn’t go outside the organisation. This has worked well for a long time and no-one has mentioned any issues, until this week when I was working with a client and we made some changes to a remittance format and tested by emailing. The remittance itself emailed to the test address fine, but the reprint remittance went… Continue Reading Ian...

Read More
Recent ISC Software Webinar: Powerful document generation for Dynamics GP
May04

Recent ISC Software Webinar: Powerful document generation for Dynamics GP

In our most recent webinar, we took a look at Powerful document generation for Dynamics GP. In this webinar, we covered how dox42 can be used to design attractive document templates in Microsoft Office and integrate data from Microsoft Dynamics GP and other systems such as SharePoint or Microsoft 365. If you want to catch up on this, or any other, webinar, you can do so here. In this blog… Continue Reading Ian Grieve’s...

Read More
Map Folder to a Drive Letter
May03

Map Folder to a Drive Letter

Across the years I have mapped a folder to a drive letter, often to share a drive with an RDP connection where I didn’t want to add the entire c drive, but today, when I needed to do it, I completely forgot how, so I am posting this as an aide-mémoire. In Windows Explorer, right-click on This PC an select Map network drive…: Select the Drive letter and enter the folder using the Universal… Continue Reading Ian...

Read More
ClassicPress Plugin Development: Create a Custom Image Path and URL for Code Potent’s Update Manager
May02

ClassicPress Plugin Development: Create a Custom Image Path and URL for Code Potent’s Update Manager

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. Plugins using the Code Potent Update Manager plugin can have a banner and icon images added to them which are used on the plugin within the admin dashboard. By default these… Continue Reading Ian...

Read More
ClassicPress Plugin Development: Create a Plugin Update Endpoint Using Code Potent’s Update Manager
May01

ClassicPress Plugin Development: Create a Plugin Update Endpoint Using Code Potent’s Update Manager

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. With Code Potent’s Update Manager added to a plugin, a plugin update endpoint can now be created on the update server. On your update server click New » Plugin Endpoint. <span… Continue Reading...

Read More
Using an Inserted Shape as a Navigation option in Microsoft Power BI
Apr30

Using an Inserted Shape as a Navigation option in Microsoft Power BI

In this Tiny Tip, Belinda will show you how to use a new feature to do something cool, using Microsoft Power BI. In this report, there is a page that is Sales by category, with a slicer that displays countries.  There is a similar page, that displays a table with sales line details.  The slicer on the detail page is sync’d with the first page. Belinda will Insert > Shape, selecting… Continue Reading Belinda...

Read More