Workflow in progress have been found in GP. These need to be processed before upgrading.
A colleague was recently performing an upgrade for a client to Microsoft Dynamics GP 2018 R2; this client had previously been a user of the old Dynamics Workflow module (now replaced with Workflow 2.0). They hadn’t used it for a while, but it had never been switched off resulted in the following message being displayed: Microsoft Dynamics GP Utilities Workflows in progress have been found in… Continue Reading Ian...
Web Client images not loading
It’s been quite a while since I did much with the Microsoft Dynamics GP web client; not by choice, but as a consultant my time is driven by the clients requirements. We recently upgraded a client to Microsoft Dynamics GP 2018 R2 and implemented the web client. When we launched the web client we found that none of the images were loading and we were unable to properly log in: Looking in the… Continue Reading Ian...
GP Tech 2019 – Day 3
I’m catching up and am now writing about “today”, day 3 at GP Tech 2019. If you missed my earlier posts from the other days, they are here: Pre-Day Day 1Day 2 The third day of the conference is always a short one – a half day of content and for some, various meetings or simply a chance to start the journey home early. By the time this day rolls around, even though it’s short, most… Continue Reading...
PowerApps | Fabrikam Utility Billing Center sample app
I just got done with presentations at the yearly Microsoft Dynamics GP Technical Conference in Fargo, ND and had the privilege of delivering a session titled Leveraging your on-premises data with the Power Platform.During this session I presented a moderately complex sample application that leverages PowerApps AI Builder Form Processing to capture utility bills. These bills are submitted to… Continue Reading Mariano...
An authentication error has occurred; this could be due to CredSSP encryption oracle remediation
This error first came up early in 2018, but I’ve stumbled across it a couple of times recently and had to hunt around for the solution, so I am posting it here so I know where to find it next time. Microsoft released an update to address vulnerabilities for the Credential Security Support Provider protocol (CredSSP) used by Remote Desktop Protocol (RDP) connections for Windows clients and… Continue Reading Ian...
GP Tech 2019 – Day 2
This is a continuation of the mini-series of posts about the GP Tech Conference in Fargo, ND. If you missed the first two posts, you can find them here: Pre-Day, including golf with Shawn, Taylor & BelindaDay 1 Meeting with Microsoft Day 2 started a lot more slowly for me. I decided to skip a couple of the first morning sessions to join a meeting with a few others to give some… Continue Reading Jen Kuntz’s Article on...
Hyphens in Dynamics GP Fixed Assets
Today’s #TipTuesday is about the Dynamics GP Fixed Assets module. I am going to discuss the restriction around the use of hyphens (dashes) in Fixed Asset IDs. Prior to GP 2013, there was no issue with hyphens and many customers who utilized Fixed Assets had created Asset IDs with them as separators. Of the numerous clients I have been to over the years, every single one of them used hyphens as… Continue Reading Jen...
New features coming to Microsoft Dynamics GP in 2019
The new version of Microsoft Dynamics GP is coming in October this year and a trickle (hopefully) of new features has just been announced at the GP Tech Conference in Fargo, North Dakota. The features have been announced in one of the sessions at the conference which I have unfortunately not been able to attend; the features listed below have been tweeted by attendees I follow on Twitter:
GP Tech 2019 – Day 1
Day 1 of this year’s GP Tech conference was Monday, September 9th. As in previous years, this is a 2.5 day event, with very full days on the Monday and Tuesday followed by a “morning-only” set of content on the Wednesday. As I write this, it’s Wednesday and I’m catching up on my blogs to get them written and posted before I fly out this afternoon for home. If you missed my “Pre-Day”...
Edge Canary: Conclusion
Microsoft have recently announced they are ditching the current version of their Edge browser in favour of a Chromium based browser. In this series, I am going to take a look at the Canary version of this new browser. The bulk of this series was posted a while ago and I’ve continued using Edge Canary for a while now and thought it was time for a review. Edge Canary is a fast browser; my main… Continue Reading Ian...
GP Tech 2019 – Pre-Day
Today’s post is about the trip and pre-day for GP Tech 2019. It’s my annual trek to Fargo, ND, to the home of Dynamics GP! I always look forward to this trip. Saturday – the trip in With limited flight choices on the Sunday, I flew in a day early, on Saturday, and early enough that I had hoped to have a chance to golf one or both days. The Saturday ended up being a thorough rain-out,… Continue Reading Jen...
Force AnyConnect to remember profiles
I have quite a number of client systems I need to connect to using VPNs. While there is a large number of VPNs available, it is inevitable that I would have some used by more than one client. One such as Cisco AnyConnect. By default AnyConnect will remember only the last VPN to which you connected, but it is possible to force it to remember multiple connections by adding a Profile.xml to the… Continue Reading Ian Grieve’s...
SSRS requires that you use local SQL Server relational databases… error
Microsoft Dynamics GP ships with a set of default reports which can be deployed into SQL Server Reporting Services; before doing the deploy, there is a setting in the SSRS web.config file which needs to be changed to avoid a maximum request length error. Recently, when performing an upgrade of a clients system to Microsoft Dynamics GP 23018 R2, the deployment of the reports went fine, but we… Continue Reading Ian Grieve’s...
Microsoft Flow | Passing collections from PowerApps to Flow
In this video I explore how you can pass a collection of records from PowerApps to Microsoft Flow by leveraging the JSON() serialization function. I also cover some other topics like working with JSON schemas, Data Operations, Variables, and Control Structures in Flow. References: PowerApps | Form Processing with AI Builder: https://youtu.be/sVx6gsA2N5MPowerApps | A look at the new JSON()… Continue Reading Mariano Gomez’s...
Remove Microsoft Word Index Entries
I’ve written a few books over the last few years; I use Microsoft Word as it is easy to work in and easy to convert to PDF. Some of the books I have written have been self published. Doing it this ways means that I need to do all of the layout and formatting, such as creating the index. On occasion, I have had a need to remove the index and re-add; this is most often when I am writing a new… Continue Reading Ian...
Where’d my navigation pane go?
Today’s #TipTuesday is a quick one! Last week, a client brought me over to her desk to ask me how to get her Navigation Pane back. It had gone missing for some reason, despite the option “checkmark” still showing as having the pane enabled. The issue Here is what her home screen looked like – not a single grab bar or indicator to make the navigation pane visible. It simply had… Continue Reading Jen...
Copy Account Categories Between Microsoft Dynamics GP Companies
When implementing Microsoft Dynamics GP for a new client, they usually have very similar setup between companies. While you can use the Professional Services Tools Library tool Company Copy, you sometimes need to replicate data which was configured after this function had been used. I’ve previously posted scripts to copy segments and financial calendars; today’s script will copy Account… Continue Reading Ian...
Move Management Reporter To A New Domain
A client recently ran into problems with Management Reporter whereby they had a large number of building blocks accidentally deleted from one building block group. While the easiest solution would be to restore the Management Reporter database to before the blocks were deleted, this was not possible. The client in question has a lot of users across different businesses each it their own… Continue Reading Ian Grieve’s...
Celebrating 10 years!
On Sept 1st., it was the 10th anniversary of my business – Kuntz Consulting Inc. It’s not 10 consecutive years of active business (since I took a brief detour to try full-time employment) but I’m celebrating it anyway! A brief history I had been working in various consulting firms since 2001, as a Dynamics GP consultant. I left the firm I was working for because I was tired of all… Continue Reading Jen...
Cannot Launch SQL Server Management Studio
I work on a variety of test and demo systems and recently stumbled across an oddity with SQL Server Management Studio (SSMS); when I tried to launch it using the shortcut, the splash screen would display, stay on screen for a few seconds before disappearing with SSMS never starting, but no error message appearing or showing in the logs. If I tried to start it by typing ssms in a command prompt… Continue Reading Ian...
Remove Modified Window From Microsoft Dynamics GP
If you have a modified window which is no longer required, it is fairly easy to remove (although these steps will need to be repeated on each client). To remove the window, open Modified (Microsoft Dynamics GP menu » Tools » Customize » Modifier): Select the product which holds the modified window and click OK: The Modified Forms window should display automatically, but if it does not, click… Continue Reading...
Update Navigation Pane Series Order
When I install demo VMs, I usually want everything setup the same way each time I do it. This includes things like inserting UK VAT Rates as well as some more mundane configuration issues like the order of series on the navigation pane. That’s what the script in this post does; it switches off some of the series so they don’t show and reorders the remaining ones into the order I want them… Continue Reading Ian...
Microsoft Dynamics GP 2018 R2 Displays Full Screen By Default
Last year Steve Endow did a post on Microsoft Dynamics GP 2018 always starts full screen and how you can stop it from doing so. The cause is a setting in the Dex.ini file which was set to TRUE: WindowMax=TRUE Prior versions of Dynamics GP had this setting set to FALSE; at the time he posed, Steve wasn’t sure if the setting was always set to TRUE or only if the Web Client Runtime was installed…. Continue Reading Ian...
PowerApps | Introduction to Build Tools for Azure DevOps
This short introductory video walks you through the installation of the PowerApps Build Tools component in an Azure DevOps environment. In addition, I show you where you can find information about PowerApps Build Tools and point you to a hands-on lab you can download to get your PowerApps DevOps journey started. For more information, please check the following sources:PowerApps Build Tools for… Continue Reading Mariano...
Decrypting Microsoft Dynamics GP Passwords Is Now Possible
Microsoft Dynamics GP encrypts its passwords in a way which cannot be decrypted. Or at least it did. DynDeveloper.com, in April, posted an article containing a stored procedure which would allow the passwords such as the system or budget passwords to be decrypted. As well as the stored proc, the article also includes sample code which will return the decrypted system password. The post with… Continue Reading Ian Grieve’s...
Using Node Builder to Create New Node: Conclusion
This post is part of the series on Using Node Builder to Create New Node; in particular I m creating a node to add EFT Bank information when adding a creditor. In this series, I’ve gone through the steps to create a simple node to add EFT Bank details when using SmartConnect to insert a vendor. Node Builder allowed us to create the node without writing any code. Node Builder is the least… Continue Reading Ian...
Using Node Builder to Create New Node: Add SmartConnect Node
This post is part of the series on Using Node Builder to Create New Node; in particular I m creating a node to add EFT Bank information when adding a creditor. Once the GP Resource Cache refreshed, the new node will be available in SmartConnect. To use the node, launch SmartConnect and on the action pane, under GP Connector, click Node Maintenance: Expand Payables and Vendors and right click… Continue Reading Ian Grieve’s...
Microsoft Flow – Form Processing with AI Builder
You previously saw me use a AI Builder to build and train a form processing model to understand a utility bill. I also show how to build a real life PowerApps application to take advantage of the utility billing model and some elements and considerations while doing so. In this new video, I show you how to leverage Microsoft Flow to create a simple orchestration around the same utility bill… Continue Reading Mariano...
Using Node Builder to Create New Node: Update SmartConnect GP Resource Cache
This post is part of the series on Using Node Builder to Create New Node; in particular I m creating a node to add EFT Bank information when adding a creditor. With the node created, we need to make it available for use in SmartConnect before we can actually use it. This is done by refreshing the SmartConnect GP Resource Cache. Do this by launching Microsoft Dynamics GP and selecting GP… Continue Reading Ian Grieve’s...
Using Node Builder to Create New Node: Create Node
This post is part of the series on Using Node Builder to Create New Node; in particular I m creating a node to add EFT Bank information when adding a creditor. To create new node, launch Node Builder from the Windows Start menu. It will start showing a blank screen. In the General Options pane enter the following: Node ID which is all caps with no spaces Node Description Default… Continue Reading Ian Grieve’s Article on...
Using Node Builder to Create New Node: Introduction
A few weeks ago I did a series on Implementing Node Builder; in this new series I am going to cover creating a new node for adding EFT Bank information with a creditor. If you’re reading this on azurecurve, the series index, below, will automatically update; if you’re reading a syndicated post, then you’ll need to check back on the original post. Using Node Builder to Create New Node No… Continue Reading Ian...
Underlying data in Microsoft Power BI Visuals
Some visuals provide the report consumer with the ability to “Drill Down” to the underlying data, i.e. the individual records or rows in the dataset in Microsoft Power BI. In this video, I’ll show you this very feature in a Clustered Column Chart. <div… Continue Reading Belinda Allen’s Article on their blog Underlying data in Microsoft Power BI Visuals Some visuals provide the report consumer with the ability to...
Enable Bitlocker on Removable Drive
When I joined ISC Software I was given a new laptop and associated peripherals which included a removable 1TB SSD. As this SSD travels with me, one of the first things I did was encrypt it with BitLocker. To encrypt a drive with BitLocker, launch Windows Explorer, right click on the drive and select Turn BitLocker On. When the BitLocker Drive Encryption window appears, click Encrypt this drive… Continue Reading Ian...
Microsoft Dynamics GP | Embed PowerApps apps
This video shows how to embed PowerApps applications inside of Microsoft Dynamics GP, leveraging the Connect gadget feature as a mechanism to deliver the application. Learn how you can achieve this in 2 simple steps to create a unique user experience.More information on Dex.ini settings and web client:Dex.ini on this site – click hereWeb client on this site – click hereUntil next post!MG.-<br… Continue Reading...
Disable IE Enhanced Security Configuration
I do a lot of work in virtual machines and this work often involves using the web browser; this is usually just for web client, SSRS or other similar local pages, but even then Internet Explorer Enhanced Security Configuration will get in the way and need to be disabled. I never remember where the setting for this is, so I am posting here to make it easy to find in future. To change the… Continue Reading Ian Grieve’s...
Bulk Export Dynamics GP Document Attachments using .NET
Steve Endow of Precipio Services, the man behind the GP Transaction Search, has created another tool for Microsoft Dynamics GP; this one allows a bulk download of Document Attachments. The tool allows the user to select a Database, Record Type, and indicate whether Deleted attachments should be exported. The attachments can then be previewed before being exported: Full details of this tool is… Continue Reading Ian Grieve’s...
GPUG All*Star 2019 Voting
This is not my typical #TipTuesday blog. I’ve missed the last 2 Tuesdays, and I promise to get back to a regular schedule by end of this summer! In its place is my take on what I look for when considering who to vote for in the GPUG AllStar awards voting process plus a little bit about the difference between a Microsoft MVP and GPUG AllStar. So, let’s get to it! It’s that time… Continue Reading Jen Kuntz’s Article on their...
PowerApps | Persisted Button Pressed Numeric Up/Dn Control – Part 2
This is part 2 of 2 showing how to build a persisted button pressed numeric up/down control. This video shows how to leverage PowerApps components to create a single reusable unit that can be leveraged across other applications. You can find more information about PowerApps Components by watching the following Microsoft MVPs and community members’ videos:Shane Young – Intro PowerApps… Continue Reading Mariano...
Microsoft Dynamics GP Error: “A Countrecords operation on table ‘[Not Found]’ (45).”
I was recently working onsite with a client when I was shown an error message which some users has intermittently been reporting. Every so often they would receive the following error: A Countrecords operation on table ‘[Not Found]’ (45). A little research found me this post by Tim Wappat where he explains this is an error due to a network connection glitch. Network interruptions are known… Continue Reading...
Microsoft Dynamics GP In-Transit Transfer Document Locked
While I was looking at the problem raising In-Transit Transfers I needed to delete all orders with alpha numeric Document Numbers, but was getting an in use error on one of them: I double checked to make sure the user was not really locking the record, and, as I’m not aware of an unlock method in Microsoft Dynamics GP itself, I made a quick trip to SQL. The following query will show the… Continue Reading Ian Grieve’s...
Error Raising In-Transit Transfer in Microsoft Dynamics GP
I was doing some work for a client the other day who was implementing some new functionality in Microsoft Dynamics GP. One of the areas they were working on was Inventory Control. They were testing that everything was working correctly and tried to raise an In Transit Transfer (Inventory Control area page » Transactions » in-Transit transfer Entry); when they entered the Item Number and hit… Continue Reading Ian...
Microsoft Dynamics GP support timeline
Dynamics GP Support timeline ” Incremental Group For users of Dynamics GP, an important factor in any decision around Dynamics GP is whether or not your version is still supported by Microsoft. As Dynamics GP is an on-premise solution where you buy a perpetual license, you create a world where the version you buy is regularly the version you stay...
Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes
I’ve been receiving an error in the Fabrikam Sample Company database when trying to create a new Financial Calendar for a while and finally had the time to track it down. The error appears when you enter a new year and click the Calculate button: Microsoft Dynamics GP[Microsoft][SQL Server Native Client 11.0][SQL Server[Violation of PRIMARY KEY constraint ‘PKSY40100’. Cannot insert...
Whitepaper: What is next for Dynamics GP?
What is next for Dynamics GP? Dynamics GP (formerly known as Great Plains) is at an interesting crossroads. It is the only Dynamics ERP solution that has not been given a cloud upgrade to Dynamics 365 and yet it is still being supported with a roadmap for future updates. In our guide we discuss everything you need to know about Dynamics GP, when it goes out of mainstream support, and what the roadmap means for you. For existing...
Dynamics GP – roadmap and outlook
What does the future hold for Dynamics GP? ” Incremental Group Dynamics GP is in an interesting place. In one sense, it is still an active and supported Microsoft Dynamics product, but on the other hand, it is the forgotten child. Microsoft has completely refreshed Dynamics AX and Dynamics NAV to launch Dynamics 365 for Finance and Operations and Dynamics 365 Business...
Updating your processes in Microsoft Dynamics GP
Updating your processes in Microsoft Dynamics GP ” Incremental Group Unfortunately, what tends to happen in lots of organisations, following go-live, is that everyone just falls into a way of working. A number of people find working with any new system challenging and they generally just learn enough to get by and settle into the processes they have...
Changing System Database Name After Installing the Microsoft Dynamics GP Client
I was installing a new VM to do some testing on and, after installing the Microsoft Dynamics GP, I ran GP Utilities and realised that I had an mistake in the system database name I had defined; the SQL Server I am using already had a deployment of Microsoft Dynamics GP 2018 R2 on it, so could not use my usual name of D18R2 and had to use an alternative. I had decided to name the system database… Continue Reading Ian...
Jo's Did You Know: Item Card Currency Setup is Greyed Out Issue is Easy to Resolve
Recently I received a request for assistance in which a user could not understand why the Item Currency on a New GP Item Number was greyed out and they could not enter an item that had multiple decima…(read more) Continue Reading Jo deRuiter’s Article on their blog GPItem Card Currency Setup is Greyed Out Recently I received a request for assistance in which a user could not understand why the Item Currency on a New GP...
Enhanced Notes Setup Window Missing
A while ago I did a series on Implementing Enhanced Notes from ISC Software Solutions. I more recently installed the add-on again on a different machine and, after doing some initial configuration, wanted to change the settings, couldn’t find the Enhanced Notes Setup window (Administration » Setup» Company » Enhanced Notes » Setup Enhanced Notes): The reason is a simple one; when you deploy…...
PowerApps | Persisted Button Pressed Numeric Up/Dn Control – Part 1
This is part 1 of 2 showing how to build a persisted button pressed numeric up/down control. This video addresses the fundamentals of the control, starting with understanding the button pressed event, how it can be used to start and stop a timer, how to make 2 buttons increase and decrease a text input control, and finally introducing a timer to persist the press. Part 2 will show how to… Continue Reading Mariano Gomez’s...