“Unable to obtain the next FAINDEX” Error When Integrating Data into Microsoft Dynamics GP
When doing some work with a client recently, they reported an error in SmartConnect when trying to import new assets into Microsoft Dynamics GP. This integration had been in use for a while and was known to work; it was was only being encountered in a newly created company. The error they were receiving was very brief: Unable to obtain the next FAINDEX A quick search revealed a Microsoft Docs… Continue Reading azurecurve’s...
MVP Renewal for 2022/2023
I’m happy to share that I have been renewed today for the Microsoft MVP award, my 6th award. I am still a little shocked, as I truly did not believe I was consistent enough this past year with my contributions. I am grateful as always to the MVP Program team and Betsy Weber for believing in me. I do hope to get back to my “normal self” one of these days and be a more-frequent contributor and… Continue Reading...
Import Custom Company Colours into Security Informer Module for Microsoft Dynamics GP
This post is part of the GP Elementz from ISC Software series. One of the available modules in the GP Elementz is the Color Changer. This allows you to change the colour of certain elements of the Microsoft Dynamics GP client such as the windows background. Out-of-the-box the available colours are quite strong and I was asked by a client if we could add some softer colours. In order to get… Continue Reading azurecurve’s...
New Book on Microsoft Dynamics GP Workflow Now Available
My tenth book is now available to buy in eBook format from azurecurve Publishing, paperback and Kindle versions from Amazon US and UK. This is a new update to the Workflow book I’ve written three prior editions over the last few years. This edition has had some chapters and sections have been rewritten to either expand or make clearer the topics being covered. It also covers the creation and… Continue Reading...
Microsoft Dynamics GP VBA Showing as Locked
I was asked to help a customer with a new Microsoft Dynamics GP client installation as they were encountering some issues with some old VBA customisations. Hearing it was a new server, I wondered if the problem was that they had used Windows Server 2019, on which VBA customisations will not work and will actually cause Dynamics GP to crash immediately. However, when I delved into the issue… Continue Reading azurecurve’s...
Microsoft Dynamics GP Table Reference Wesbite Updated to Fall 2021 Release
I’ve just updated the Microsoft Dynamics GP Table Reference site to the Fall 2021 Release. Any of the new tables or columns introduced from the version it was (2018 RTM) to 2021 will now be present. If you do notice any omissions or issues, please do get in touch with details and I’ll see about a resolution. As always, if you need version specific tables for Dynamics GP this is available in… Continue Reading...
Enable the Windows Distributed Transaction Coordinator
One of the line of business applications used by a few clients performs updates to both it’s own database and also the Microsoft Dynamics GP database. It does this using code in SQL stored procedures which use transaction boundaries. As the updates are between SQL servers, it does this using BEGIN DISTRIBUTED TRANSACTION rather than the usual BEGIN TRANSACTION; updates of this sort are, as… Continue Reading...
Management Reporter Multicurrency Error
I meant to post this a while ago, but apparently didn’t and have just found the screen shots again. This was reported to me by a client who was trying to run a multicurrency report in Management Reporter. When columns were flagged with currency translations, this error was produced and shown in the Report Queue Status window: An internal error occurred in the provider. Additional information… Continue Reading...
Replace Expired SSL Certificate Binding with the Web Services for Microsoft Dynamics GP
A few years ago I posted about securing the Web Services for Microsoft Dynamics GP which is something I would recommend that everyone does, most especially if they are exposed externally. However, when the certificate expires and needs to be replaced, there are a few steps you need to follow to do this and they are mainly done at the command line as it is the certificate binding which needs to… Continue Reading...
Historical Inventory Trial Balance VS the Historical Stock Status Report in Microsoft Dynamics GP
I’m a little late, but there was a good article fromAngela Eckman Ebensteiner on the Dynamics GP Support and Services Blog on the differences between the Historical Inventory Trial Balance and the Historical Stock Status Report and why the HITB (Historical Inventory Trial Balance) is the one you should be using to determine the value of your stock on a given day and to reconcile with the… Continue Reading...
Clear Pending Batches from Microsoft Dynamics GP Generate EFT File Window
Back in Microsoft Dynamics GP 10 and before, the ability to produce EFT files was not available in UK language installs. This meant a lot of clients used other methods for producing the EFT files and many of them are still using those alternative methods. That said, I’ve done work with a few recently where they had changed banks or otherwise needed to mke changes to the EFT format, so we hve… Continue Reading...
Script to Update Purchasing Unit of Measure in Microsoft Dynamics GP
While I am a big advocate of making changes to data via the front end or using an officially supported integration tool, there are times when a SQL script is the quicker way of making a small update. I recently needed to update the purchasing unit of measure on 60,000 inventory items. The below SQL script was created to make this update: /*Created by Ian Grieve of azurecurve|Ramblings of an IT… Continue Reading...
What NETBIOS Is The Machine On?
I was recently doing some work for a client installing some software and realised that I didn’t know what their NETBIOS was and the application didn’t have a lookup option for the service account so I needed to type the domain and username directly. The IT people I was working with were in a meeting and not going to be available for a while so I couldn’t ask. I did some checking around and… Continue Reading...
Microsoft Dynamics 365 BC Table Reference Website Now Available
A few years ago there was a GP Table Reference website which disappeared with no warning; it had been very helpful, so I created my own version of it. Well, we’ve recently started doing work with Microsoft Dynamics 365 Business Central and there didn’t seem to be a similar website freely available, so I have created my own. The main reason for creating the site is that it will help me… Continue Reading...
MySQL Snippets: Update Statement
This post is part of the series on MySQL Snippets. The following MySQL snippet shows an example UPDATE statement for MySQL; I’m posting this as I have trouble remembering that the order of the MySQL statement is different to that of Microsoft SQL Server; in MySQL the SET clause comes after the JOIN clause, whereas in Microsoft SQL Server, with which I am more experienced, the order is… Continue Reading azurecurve’s...
MySQL Snippets: Series Index
This post is part of the series on MySQL Snippets. Like the other …Snippets series, this one may not get many posts as I’ll be using it to record things I need to remember. In thie series, I’ll be posting MySQL snippets; usually ones which highlight a difference between the MySQL and Microsoft SQL query syntax. MySQL Snippets Read original post MySQL Snippets: Series Index at
Excel Snippets: Substitute Function
I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. I tend to do data manipulation in SQL Server rather than Excel, as it is generally easier to do it in SQL where I can run commands sequentially. However, there are times when I do need to do it in Excel. I recently needed to replace one part of a string of text and really… Continue Reading...
Button to Enable E-Mail Missing From The Creditors Navigation Pane in Microsoft Dynamics GP
I did some work for a client recently where we created a new check remittance layout and showed them how to enable emails in Microsoft Dynamics GP. When we deployed ive however, we encountered a problem whereby they client could not enable, en masse, the creditors for emails as the button was missing fromthe action pane in the Creditors navigation list. On the standalone test system the E-mail… Continue Reading...
More Efficient Grant Script for Microsoft Dynamics GP
I’m not sure how, but I stumbled across an article on the ERP Software Blog by Michael Krasivsky of The Resource Group where he has posted a more efficient version of the Grant.sql script. For those who don’t know, the Grant script is used to apply the correct permissions to SQL objects (tables, views and stored procedures) used by Microsoft Dynamics GP; this script can take a while to run as… Continue Reading...
SmartConnect 2021 – The source was not found, but some or all of the event logs could not be searched
Earlier this year I added SmartConnect from eOne Solutions to a new demo vm (I’m a bit behind with posts). I was able to create the data source and integration without any issues, but then encountered an error when running any of the integrations in SmartConnect: The source was not found, but some or all event logs could not be searched. To create the source, you need permission to real all… Continue Reading...
Dynamics GP Email – Login Failed error
Today’s #TipTuesday post is a pretty short one. A client of mine recently merged with another firm and part of that was everyone getting new email addresses for a new web domain. For most of the users that used email functionality in GP, it was a non-event: they simply logged into the “Exchange Log On” prompt with their new email and password and continued with their task. For one user,… Continue Reading Jen...
Enabling the Canadian Payroll module
Today’s post is short-ish and sweet. In my last post, I documented where to go to get registration keys. In the last part of the post, I had added a note that was specific to Canadian Payroll and today learned that it no longer applies, at least not for recent versions of Dynamics GP. I have edited that part of the post now… This post is a very brief overview of the 2 things that need to be… Continue Reading Jen...
Where can I find my registration keys on CustomerSource?
This is a short post. I went looking for a customer’s registration keys and could not remember how to get to them now that the old CustomerSource links are dead and buried. So… future “me”, this is your reminder! And for those who stumble across this, you’re welcome, I hope the info stays “correct” for the next few years so I don’t have to look for this again! NOTE: I am not covering...
Change SQL Server Analysis Services Deployment Mode from Multidimensional to Tabular
I recently installed SQL Server Analysis Services (SSAS) and used the default settings during the installation. Unfortunately, this meant I installed it using a Deployment Mode of Multidimensional instead of Tabular. I wanted to avoid uninstalling so I did some poking around and found there is a setting file which can be amended to change the Deployment Mode. The file is msmdsrv.ini which is… Continue Reading azurecurve’s...
Change All Folders to Match Current View
Windows Explorer allows you to customise a folder by changing the columns available with the changes only affecting that one folder. However, there is also a method of applying the changed view to all foldersof the same type. This means if you’re working, as I was, on a folder containing photos that you can apply any changes to the columns to all other folders which Windows sees as a photo… Continue Reading...
Find SQL View in All Microsoft Dynamics GP Databases
I recently needed to find which databases in SQL Server had a specific view deployed to them. I’ve created scripts in the past to find SQL objects in all databases (table,trigger and functions), but not one for SQL views. Some of the previous scripts looked in all databases and others were limited to only the Microsoft Dynamics GP databases; this script is one of the latter, using the… Continue Reading azurecurve’s...
Integration Manager Error Importing Fixed Asset
After assisting a client with a server migration, an issue was reported with a fixed asset integration: DOC 1 ERROR: The stored procedure ‘taCreateAssetID’ doesn’t exist. The first thing we checked was to see if the stored procedure did exist, which it did. The next option was a suspicion of permissions. After checking in SQL I found that the service account did not have access to all of the… Continue Reading...
Error Sending Mail Using SQL Database Mail
I was recently doing some testing of a script I created for a client which used SQL Database Mail for sending emails. this was on my one of my demo environments, but I received an error when testing the script: Microsoft Dynamics GP Unhandled database exception: [Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object… Continue...
Update EFT Transfer Method on Creditor EFT Details in Microsoft Dynamics GP
I was doing some work with a client recently where we needed to output two different formats of EFT file for the same bank account. This is possible using the EFT Transfer Method on the bank on the creditors. However, with a large number of creditors we needed a way to update the records in bulk. While it would be possible to do this with a macro, it would be fiddly and take a while. Instead,… Continue Reading azurecurve’s...
Power BI, Excel & GP – SQL sources
Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. The previous posts in the series are: Introduction Starting from scratch Data Access What this post covers In this post, here is what I am going to show, in the context of the Payables Transactions type of… Continue Reading Jen Kuntz’s...
Select Microsoft Dynamics GP GL Accounts for Import
Working on a recent project for a client we needed to extract the chart of accounts from one Microsoft Dynamics GP company and import it into a couple of others (altering the first segment during the process. The below script was created to extract all of the chart of account data in the format required for import through Integration Manager: SELECT [‘Account Index Master’].ACTNUMST AS
Assign a Microsoft SQL Server Role to a User in All Microsoft Dynamics GP Databases
I did some work for a client recently which involved creating a report which could be run against any database; we therefore needed to add the user to a database role in all databases which gave access to the relevant SQL objects. The below script generates a SQL script which can be used to alter the role to assign it to the specified user in all of the Microsoft Dynamics GP company… Continue Reading azurecurve’s Article...
Fixing a OneDrive Which Has Stopped Synchronising
I’ve been using OneDrive for quite a long time, but recently became aware that files created or amended on one PC were not being synchronised to others although it would download files created on other machines, which was why I hadn’t immediately become aware of the issue. I did some general poking around OneDrive and couldn’t find anything wrong so did some searching and found a discussion… Continue Reading...
Enable Workflow Step Email Notifications in Microsoft Dynamics GP
I was doing some work for a client to build a workflow process in Microsoft Dynamics GP recently and we only got the SMTP details quite late in the process. This meant that we built quite a large workflow process without being able to enable the email notifications. Once we did have the SMTP available we needed to go back through all of the steps and enable the email notifications. Rather than… Continue Reading...
Power BI, Excel & GP – Data Access
This is the third post in the series and I am going to dedicate this post to how to access GP data in terms of describing some of the options and factors to consider. Very little of this will have “how to” information about Power Query, but I will continue that in the next post. The previous posts in the series so far are: Introduction Starting from scratch In my last post, “starting from… Continue Reading Jen...
Script to Help Check For Missing Microsoft Dynamics GP Workflow Customisations
If you’re a regular reader, you’ll be aware that I am a big fan of the Microsoft Dynamics GP Workflow module which can be used for the approval of batches, documents, security and more. Workflow can easily be customised to allow for extra fields to be available in the workflow conditions and on the notification emails (which I cover in chapters 9 and 11 of my Microsoft Dynamics GP Workflow… Continue Reading...
Script to Remove Microsoft Dynamics Workflow History Where No Action Is Required
I have quite a few clients using the Microsoft Dynamics GP Workflow module as standard out of the box with no customisations required, but a fair number of clients do have one customisation or another. A few of them have a customisation allowing a SQL view to be used in the workflow conditions and a few have a script like the one in this post to remove some of the workflow history. If you have… Continue Reading...
Script to Remove Advanced Bank Reconciliation Transaction Matches
I do demonstrations of quite a bit of functionality in Microsoft Dynamics GP which often necessitates restored databases or otherwise reversing transactions and processing. One of the modules I’ve done some demonstrations of recently is the Advanced Bank Reconciliation module from Nolan Business Solutions. One of the features of this module is allowing you to atch statement entries with… Continue Reading azurecurve’s...
SmartConnect 2021 Error: “HTTP Error 500.19 – Internal Server Error”
I’ve been doing some work with a client recently implementing SmartConnect 2021, although the client has done much of the install themselves using the manual as a guide (this was their choice to help keep costs down). When we tried to enable the REST API and navigate to the endpoint to check, we were receiving an error: HTTP Error 500.19 – Internal Server Error The requested page cannot be… Continue Reading...
Power BI, Excel & GP – Starting from scratch
The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, literally starting from scratch. From my experience, an audience that is often overlooked are users who want to learn more or improve their skills but doesn’t know where to start, and everything they find starts at a point they don’t understand or can’t get… Continue...
SmartConnect 2021 Error With Excel Data Sources: “Data source name not found and no default driver specified”
We’ve recently upgraded a client from SmartConnect 2018 to SmartConnect 2021 and mosstly had no problems. One issue which came up is when users tried to run an integration which had a Microsoft Excel file as the data source. Each time they tried the integration, and on several machines, they always received the same error: Connection could not be validated ERROR [IM002] [Microsoft][ODBC… Continue...
azurecurve ClassicPress Plugins: Load Admin CSS
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 ; Load Admin CSS. Functionality Change the styling of your admin dashboard with custom CSS. Options are maintained via a Settings page on the azurecurve menu. Example CSS usage to… Continue Reading azurecurve’s...
Error Logging into Jet Hub : “IDX20803: Unable to obtain configuration from: ‘System.String’.”
I did an install of Jet Reports recently on new demo VM and found that I had a problem logging into the Jet Hub. When I tried to log in, I was always getting this error: Error IDX20803: Unable to obtain configuration from: ‘System.String’. I did some debugging myself and got nowhere in working out the cause of the problem as everything looked fine. An online search found an article on the
Web Services Upgrade Error: “The provided windows account is not formatted correctly”
When I do an upgrade of the Web Services For Microsoft Dynamics GP, my usual approach is to ru a two Microsoft supplied scripts which remove all web services objects from the system and company databases; I generally do this as we had problems with the upgrade process within the Configuration Wizard. On a recent upgrade I thought I would give the standard upgrade process aother try, as it is a… Continue Reading...
Create Grant Statement for All Custom Views in Microsoft SQL
On a recent project, I needed to create a new database role for some new SQL views which had been created. Creating the role is easy enough, but to make sure all the relevant views (and there were quite a few) looked like a bigger job until I realised I could select from sys.views and generate the grant script at the same time. In the below script, the first highlighted section is the database… Continue Reading...
Maximum columns in a SmartList
This is most likely the shortest #TipTuesday post I will ever create! I was playing with a SmartList to prep for my upcoming series on Power BI, Excel & Dynamics GP. I stumbled across something I have never seen before: I tried to add too many columns to a SmartList! Here’s the message I received. Apparently, 189 columns is the most you can display in a SmartList (if I’m reading the… Continue Reading Jen...
Microsoft Dynamics GP VBA Entering Debug Mode Without Breakpoint For All Users On First Login
A client reported a problem with some VBA customisations in Microsoft Dynamics GP where the code was stopping as if at a debug point in two places even thought there were no debug points present. Once a user hit F5 to continue the code past a “debug” point, they would not see the problem again until the next time they logged in. I did a lot of investigation and fiddling around, but could not… Continue Reading...
Power BI, Excel & Dynamics GP
Soon I will be starting a new series of posts around Dynamics GP and how to get data out of it with Power BI or Excel via Power Query. There is no shortage of reporting options available for Dynamics GP customers, with many ISV (3rd party) products out there to augment some out of the box options (Report Writer, SmartLists). However, as with accounting departments everywhere, there is a heavy… Continue Reading Jen Kuntz’s...
Microsoft Dynamics GP Statement Emailing “Path for the E-mail Status Report is not set up…” Error
I worked on a Microsoft Dynamics GP upgrade project recently for a client who uses the old Adobe statement process. I am not all that familiar with this as most clients are now using the On Blank Paper statement and the standard emailing functionality. Once the upgrade was complete and we were doing some basic testing we encountered an error when trying to email the statements: Microsoft… Continue Reading azurecurve’s...
Today why you should Learn Selenium in Online
Selenium is an automated web browser, and it allows immediate testing of web applications so that developers can send new releases faster. For businesses, many of you choose it as a valuable test automation tool for web applications testing, and you can retain the selenium online. Selenium is an open-source tool, which means anybody can learn and access it for free online. Any organization can use selenium to test their website or web...