GP Upgrades – know your environment part 4
My last post was a few months ago and since then I’ve gotten a little distracted with other things (summer, nicer weather, etc.). I’m ready to try to catch up and finish this upgrade series, continuing on for now with the “know your environment” topic. So far I have covered some product terminology, product types & ISV products, and a bit about identifying external applications. In this… Continue Reading Jen...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Sales Inquiry GoTo
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Sales Inquiry GoTo Financial enhancement. In the Sales Order… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Workflow Approvers Count
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Workflow Approvers Count System enhancement. An option has been… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Settings for All in One Viewer
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Save Settings for All in One Viewer Financial enhancement. Microsoft… Continue Reading...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Default Email on form 1096
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Default Email on form 1096 Financial enhancement. For Dynamics GP… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Add Autopost for Workflow Batches
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Add Autopost for Workflow Batches System enhancement. With this… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Payroll Transaction Entry Defaults
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Save Payroll Transaction Entry Defaults Payroll enhancement. In US… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Mask Social Security Number on W-2
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Mask Social Security Number on W-2 Human Resources… Continue Reading azurecurve’s Article on their...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Save Inquiry Sort Options
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Save Inquiry Sort Options Financial enhancement. This new Financial… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Summary Post Cash Receipt at Batch
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Summary post Cash Receipt at Batch Financial… Continue Reading azurecurve’s Article on their blog...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Update Account Description in Mass Modify
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Update Account Description in Mass Modify Financial enhancement. A… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Scroll Through Account Segments
This post is part of the Microsoft Dynamics GP October 2021 Release Feature of the Day series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Scroll through Account Segments Financial enhancement. This is a… Continue Reading azurecurve’s...
Microsoft Dynamics GP October 2021 Release Feature of the Day: Series Index
This post is the Microsoft Dynamics GP October 2021 Release Feature of the Day series index for the series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. The series index, below, will automatically update here on azurecurve|Ramblings of a Dynamics GP… Continue Reading azurecurve’s Article...
Microsoft Dynamics GP October 2021 (18.4) Now Available
The October 2021 (18.4) release of Microsoft Dynamics GP is now available for download; the official post release announcement is here. The full download is here and the hotfix update for upgrading from 18.2 or 18.3 is here . The latest features and functions added or enhanced are: Financials Scroll Through Account Segments. Default Inquiry Sort Options (Receivables, Payables, Bank… Continue Reading azurecurve’s Article on...
PHP Snippets: If Statements
This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. One of the most basic statemnts you’ll use in PHP is the if statement which is used for conditional statements which perform different actions. The most basic form is the basic if itself which executes when one condition is true: $time = date( “H” ); if ( $time < 12 ){ echo “Good...
PHP Snippets: Sprintf
This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. The sprintf function provides the same functionality as the printf function, but silently. This means you would either need to echo the output or concatenate it with a string and echo that string. $number = 500; $string = ‘miles’; echo sprintf( ‘But I would walk %d %s’, $number, $string ); Click…...
PHP Snippets: Printf
This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. The printf function is similar to the echo function in that it will output text, but differs in that it outputs a formatted string. The syntax of the printf function is: printf( string, arg 1, arg 2, … ) Multiple arguments can be provided to the function for each of the placeholders to be… Continue Reading...
Upgrade Fails on Item Master (IV00101)
Most Microsoft Dynamics GP upgrades run through quickly ad without issue but every so often one will encounter a problem. I had one of the upgrades which encountered a problem recently with a client we’d taken over the support from a previous partner. We always recommend that a test upgrade be done on a standalone server before live to identify exactly this sort of issue. We restored all of… Continue Reading...
PHP Snippets: Quotes
This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. Both single and double quotes are supported in PHP, but there is a significant difference in how they are handled. Single quotes are output “as is” and are the quickest form of quoting. When using single quotes, you would need to concatenate variables with a string to output them:
SQL Snippets: SELECT INTO
This post is part of the series on SQL Snippets. I occasionally need to make a backup of a SQL table and all rows within; while you can create a table and insert the content, this is the long way of doing. Instead you can use SELECT INTO to both create a table with the correct columns and also to copy the data. In the below example I am creating a new table suffixed with the date; the first
PHP Snippets: Echo
This post is part of the PHP Snippets series where I will be covering the basics of developing in PHP. Almost everything you write in PHP ill have an output to the user; the simplest way of doing this is to use the in-built echo function (which you can use with or without parentheses). The below example is a simple echo to output one line of text: echo ‘Hello world!’; You can output multiple… Continue Reading...
ClassicPress Petitions – Let Your Voice Be Heard
ClassicPress started life as a hard-fork of WordPress 4.9; one of the differentiators is the Gutenberg block editor which started by replacing the TinyMCe editor (now generally referred to as the “classic editor”) and is now beig rolled out through other part of a WordPress site. However, this is just one of the differentiators. One of the largest other differences is the decision making… Continue Reading...
Enable Extensions in Vivaldi Private Mode
I don’t use browser private/incognito modes very often, but sometimes when I do I also want some of the installed Extensions to be available. My browser of choice is Vivaldi and it does allow you to enable extensions, on a per extension basis, in private mode. To do this, open the Extensions page from the menu or using Ctrl+Shift+E and click the details button on the plugin you want to enable… Continue Reading...
ClassicPress 1.3.0 Now Available
Earlier this week, the releae of ClassicPress version 1.3.0 was announced; this release focuses on improving accessibility (a11y) which is a key focus for ClassicPress (both the core itself as well as strongly recommending that developers work with accessibility in mind) and one which has a lot of people switching from WordPress as Gutenberg is less accessible that the editor used in… Continue Reading azurecurve’s Article...
Microsoft Dynamics GP Reporting Services Reports Not Supported on SQL Express
Usually when installing or upgrading Microsoft Dynamics GP for clients they will use SQL Server Standard and sometimes Enterprise; very rarely, I’ll encounter a mall client who is using or wants to use SQL Server Express. SQL Server Express is a free version of SQL Server, but which has some limitations. SQL Server Reporting Services (SSRS) is not one of those limitations; you can install SSRS… Continue Reading...
Error With Microsoft Dynamics GP Historical Company Name in Jet Reports
I’ve worked with Jet Reports against Microsoft Dynamics GP with a few clients over the last couple of years (as well as writing a book on using it with Microsoft Dynamics GP). One recent client I was working with developed some reports against the live companies, but we had a problem when trying to include some data from historic companies (after a merger, new companies were created and the… Continue Reading...
PHP Snippets: Series Index
I started developing plugins for WordPress back in 2014 and switched to ClassicPress in early 2019. I’ve been writing a series of posts on ClassicPress Plugin Development and thought a companion series on developing in PHP might be useful to people looking to make a start. Over this series of PHP snippets, I’ll be covering the basics of developing in PHP. The series index, below, will update… Continue Reading...
Update Microsoft Dynamics GP Account Categories From Text File
I’ve recently been working with a client to implement Jet Reports as a replacement for Management Reporter. As part of this implementation, it was necessary to change the account categories in Microsoft Dynamics GP. This particular client has over 1 million account strings in their chart of account which meant any update could not be done manually. While it could technically be done through… Continue Reading...
SQL Snippets: Create and Use Database Role to Restrict Access
This post is part of the series on SQL Snippets. I create a lot of SQL objects such as views, tables, stored procedures and so on. If they will be used from within Microsoft Dynamics then they can simply be assigned to the DYNSA role, but if they are for use in custom reporting or integrations then separate security will be required. Usually for reporting, and especially for integrations,… Continue Reading azurecurve’s...
Check For Colour Accessibility (A11y)
I’ve posted about a few useful websites as a way of remembering and finding them again. Today I am posting another one which is about colour accessibility. Back in September 2020, I posted about a site called ColorHexa which you can use to generate matching colour palettes. This is good as far as it goes, but for web design best practice is that websites need to be accessible. This is… Continue Reading azurecurve’s...
ClassicPress Plugin Development: Save an Options Page
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 an options page created, you need to create the process to save the options when the user changes them. The example I am using in this post is from my Remove… Continue Reading azurecurve’s...
Error Entering Invoice in Microsoft Dynamics GP When Multiple Bins Enabled
I’ve been working on a project implementing Microsoft Dynamics GP for a new client recently. They are a manufacturing company who have bins enabled for storing and tracking items as they move through the factory; goods booked in or out through POP and SOP were also recorded to and from bins. One day during UAT (user acceptance testing) I received an email from the client that users were… Continue Reading azurecurve’s...
VBA To Insert Next Microsoft Dynamics GP DD Transaction Code
I am tending to encourage clients to use SmartConnct from eOne Solutions for integrating data into Microsoft Dynamics GP, but I do still have quote a few clients using Integration Manager. SmartConnect supports the use of custom eConnect nodes which I have created for a few clients, either manually or through using Node Builder (also from eOne). You can accomplish the same result through… Continue Reading azurecurve’s...
Upgrading Post Master Enterprise
Earlier this year I did a series on Implementing Post Master Enterprise from Envisage Software. This is one of my favourite addons for Microsoft Dynamics GP which I have implemented for quite a few customers, including two in the last month. The basic functionality is that it will run as a Windows service and automatically post batches which match the autodetection rules. Envisage also make… Continue Reading azurecurve’s...
Error Posting Dynamics GP Payables Batch In New Company
I noticed recently that if you create a new company in Microsoft Dynamics GP and then use the Company Copy function of the PSTL (Professional Services Tools Library) you will receive an error when trying to post transactions from the Payables Management module: The following errors were found while attempting to post Tax detail information is incorrect. The issue is that while PSTL will copy… Continue Reading azurecurve’s...
ClassicPress Plugin Development: Create an Options Page
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. Anything more than a very simple plugin will hae options which the site administrator will need to be able to change. this means an options page which is added to the… Continue Reading azurecurve’s...
ClassicPress Plugin Development: Get Options Page Title
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 couple of posts in this series, I’ve discussed how options can be loaded and saved, loaded with defaults and loaded with multilevel defaults. Over the next… Continue Reading...
Vivaldi Active Tab Darker Than Other Tabs
I started using Vivaldi browser while it was still in beta test and have seen a number of iterations over the years. Most of the changes have been neutral or beneficial, but one of the latest I’ve found very annoying. I first encountered this in April and forgot to post about it, but I’ve been creating some new VMs and have had the same issue again recently so thought I’d post as a… Continue Reading...
Microsoft Office Jump Lists Not Updating
I had a problem recently where the ump lists for Microsoft Office stopped updating. I did some checking around and a recommended solution I found is to remove large files (> 1MB) from the %AppData%MicrosoftWindowsRecentAutomaticDestinations. I had a look in the folder and did find some large files and so deleted them. Over the next couple of hours, I checked the jump lists and they still… Continue Reading azurecurve’s...
Management Reporter Does Show All Account Descriptions
We’ve recently been implementing Microsoft Dynamics GP for a manufacturing company in England. When verifying that opening balances had imported correctly, the user reported that not all of the rows in Management Reporter were displaying an account description. A quick check around and I found a blog post from nJevity covering this exact subject. Typically Management Reporter is run only to… Continue Reading...
Script Error on Dynamics GP Homepage
During a recent upgrade of Microsoft Dynamics GP, the client supplied a link to be used for a repurposed Intelligent Edge section on the home page. However, once their Intranet site link had been added, users started getting a script error like the below: Internet Explorer Script Error An error has occurred in the script on this page Line: 320 Char: 6 Error: The system cannot find the file… Continue Reading azurecurve’s...
Management Reporter Upgrade Fails The Users Can’t Connect
I recently did a Microsoft Dynamics GP upgrade for a client which included Management Reporter. During the upgrade of Management Reporter to the latest hotfix, we found that the upgrade of the legacy connector failed every time. We spent quite a bit of time looking into the problem and eventually got it to install correctly. When legacy connector was first added, it was added using the FQDN of… Continue Reading...
ClassicPress Turns 3
It does’t seem like it, but ClassicPress is now three years old. Many open source projects don;t last very long, but this hard fork of WordPress 4.9 is still going with a new release in beta test at the moment and the version after in planning. Viktor Nagornyy has written a blog post reviewing what has been accomplished over the last three years, covering topics like improved security and… Continue Reading...
Power Apps – Application Monitoring with Azure Application Insights
In this video, learn to enable Power Apps Application Monitoring with Azure Application Insights. The following topics are covered in this video: (0:00) – Intro (0:36) – What is Azure Application Insights (1:32) – The timesheet app (2:12) – Creating an Application Insight for the timesheet application (3:55) – Identify and copy the application instrumentation key ...
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...
ClassicPress Plugin Development: Load Multilevel 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. Over the last couple of posts, I’ve taken a look at saving and loading options and how to load options with defaults. The defaults in the last post was a single dimension… Continue Reading...
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...