Fixed Asset Depreciation Not Calculating in Microsoft Dynamics GP
Aug09

Fixed Asset Depreciation Not Calculating in Microsoft Dynamics GP

I was on a call with a client the other day looking at a few issues with them in Microsoft Dynamics GP. One of the issues was that they had been setting up the Fixed Asset Management module, but when they ran depreciation, nothing happened. We did some exploring and the only difference I could find, from who I would have normally configured the module, was that the Fixed Asset Calendar ((

Read More
Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Client Login
Aug08

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Client Login

This post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central. With the Business Central demo environment installed we can now log in for the first time which you will need to do using the account which did the installation. While Business Central is not a desktop… Continue Reading azurecurve’s...

Read More
Git Command Line Snippets: Add, Commit and Push Changes
Aug07

Git Command Line Snippets: Add, Commit and Push Changes

This post is part of the series on Git Command Line Snippets where I am taking a look at performing actions on GitHub using the git command line. There are three steps required to add your changes to a GitHub repository: Add Commit Push Fistly, you need to add your changes; it is possible to only add specific files, but in my case I always want to add everything; this command will add all… Continue Reading azurecurve’s...

Read More
Git Command Line Snippets: Choose Repository
Aug06

Git Command Line Snippets: Choose Repository

This post is part of the series on where I am taking a look at performing actions on GitHub using the git command line. I am new to working with the git command line so have spent a bit of time reading articles. One thing a lot of them say is to “choose your repository” and then tell you to run commands. When I was doing this it was a bit late and I’d been working all day (getting my excuse… Continue Reading...

Read More
Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Server Installation
Aug05

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Server Installation

This post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central. Once you have downloaded the media, extract the files and launch the setup utility. On the Welcome step, click Next: Accept the terms of the software license and click I accept: Select Advanced… Continue Reading azurecurve’s Article...

Read More
Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Download Software
Aug04

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Download Software

This post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central. When I first downloaded Business Central, I had a false start as I found a page of download oinks on the Microsoft Docs website, but the latest version on there was 2020 Wave 2. I assumed this was the… Continue Reading azurecurve’s...

Read More
Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Selected Server Configuration
Aug03

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Selected Server Configuration

This post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central. in this last post, I covered the system requirements for a demo/test system. Before getting started, I thought I would quickly post on the exact system configuration I am using for this demo… Continue Reading azurecurve’s Article on...

Read More
Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: System Requirements
Aug02

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: System Requirements

This post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central. The full system requirements for Business Central are available on Microsoft Docs. In this post, I’m listing out the requirements for running Business Central in an offline learning/demo environment; I… Continue Reading...

Read More
Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Series Index
Aug01

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Series Index

I’ve recently started doing some work with Microsoft Dynamics 365 Business Central and need access to a demo/test system . While the online version of Dynamics BC is probably the most commonly used and I do have access to an online demo/sandbox environment, I am sometimes working where I do not have an Internet connection and therefore decided that having an on-premise version installed in a… Continue Reading...

Read More
Git Command Line Snippets: Update Name and Email
Jul31

Git Command Line Snippets: Update Name and Email

This post is part of the series on Git Command Line Snippets where I am taking a look at performing actions on GitHub using the git command line. Before you start using Git you need to enter your credentials to identify yourself as the author. The name and email address should both be set to the same as the ones you use in GitHub. To set your username you can use this command: git config… Continue Reading azurecurve’s...

Read More
Git Command Line Snippets: Series Index
Jul30

Git Command Line Snippets: Series Index

Back in April 2020, I did a series on using GitHub when developing for ClassicPress. More recently I have started to take a look at using the git command line to help automate making commits, releases and other actions. I’ m going to use this git snippets series to record the commands I have been using. You can use an ordinary Windows command prompt or PowerShell to run git commands; I started… Continue Reading...

Read More
Bug With End Of Month Payment Terms in Microsoft Dynamics GP
Jul29

Bug With End Of Month Payment Terms in Microsoft Dynamics GP

I was onsite with a client recently and was asked about a problem they were seeing with payment terms. Specifically, the issue was with end of month payment terms where the due date was sometimes being calculated incorrectly. They’d done some testing and identified that it was when the invoice date was the last day of the month that the due date ws incorrect. I did some testing in Fabrikam and… Continue Reading...

Read More
Integration Manager Error – “Source Recordset ‘1’ not found’
Jul28

Integration Manager Error – “Source Recordset ‘1’ not found’

I was talking to a client on a Teams meeting a while ago and they took the opportunity to ask about a problem they were having with Integration Manager. When they tried to run a n integration to import Payables Transactions they were receiving an error: Integration Manager The integration cannot be run because of the following problem(s): – Source Recordset ‘1’ not found – used for Record… Continue...

Read More
SmartConnect Crashes When Trying to Run Integration into Microsoft Dynamics GP
Jul27

SmartConnect Crashes When Trying to Run Integration into Microsoft Dynamics GP

I dealt with a support issue for a client recently where they were reporting that one user could integrate into all but two companies in Microsoft Dynamics GP, but other users couldn’t integrate into any. The problem is that when they tried an integration which failed, SmartConnect simply crashed with nothing in any error logs in either SmartConnect or Windows. As it was working in some… Continue Reading azurecurve’s...

Read More
Recent ISC Software Webinar: A Macro Overview for Microsoft Dynamics GP
Jul26

Recent ISC Software Webinar: A Macro Overview for Microsoft Dynamics GP

In our most recent webinar, we took a look at A Macro Overview for Microsoft Dynamics GP. In this webinar, we took a look at what Microsoft Dynamics GP macros are, how they can be used and ran through some examples. If you want to catch up on this, or any other, webinar, you can do so here. Introduction What are macros and how to use them Pitfalls Recording and Playing Macros Macro by Mail… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: Review
Jul25

Implementing SmartView for Microsoft Dynamics GP: Review

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. It’s been quite a while since I’ve used SmartView myself; I tend to either use SmartList or directly query the database. I’ve done a lot with SmartList Builder, creating many SmartLists over the… Continue Reading...

Read More
Implementing SmartView for Microsoft Dynamics GP: Accessing SmartView External
Jul22

Implementing SmartView for Microsoft Dynamics GP: Accessing SmartView External

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. Once users have been configured for SmartView External, they can get logged in and start using SmartView from outside Dynamics GP. SmartView External is available to users from the Windows Start… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: Configure Users for SmartView External
Jul21

Implementing SmartView for Microsoft Dynamics GP: Configure Users for SmartView External

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. Before users can access SmartView External, they need a user created. These are maintained through ()Microsoft Dynamics GP menu » Tools » SmartView » External Users: Enter a unique User ID along… Continue Reading...

Read More
Implementing SmartView for Microsoft Dynamics GP: Installing SmartView External
Jul20

Implementing SmartView for Microsoft Dynamics GP: Installing SmartView External

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. Once you have SmartView External downloaded, extract and run the installer. Click Next on the welcome step: !–more–>Accept the terms of the End-User License Agreement and click Next: Enter the SQL… Continue Reading...

Read More
Microsoft Dynamics 365 BC Table Reference Website Updated to 2022 Wave 1
Jul19

Microsoft Dynamics 365 BC Table Reference Website Updated to 2022 Wave 1

I created the azurecurve | Dynamics 365 BC Table Reference a few weeks ago to the latest version I could find which was 2020 Wave 2. It turns out that Microsoft are inconsistent with where they put versions of the on premise release of Dynamics BC. I have now found the download for the 2022 Wave 1 version and have updated the BC Table Reference site to that version. If you see any errors or… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: Download SmartView External
Jul19

Implementing SmartView for Microsoft Dynamics GP: Download SmartView External

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. As mentioned earlier in the series, SmartView is available both inside and outside of Microsoft Dynamics GP. The steps so far were all about configuring SmartView inside of Dynamics GP. If you’re… Continue Reading...

Read More
Microsoft Dynamics 365 Business Central 2022 Wave 2 Plan Announced
Jul18

Microsoft Dynamics 365 Business Central 2022 Wave 2 Plan Announced

A few days Microsoft announced the plans for the 2022 Wave 2 version of Microsoft Dynamics 365 Business Central. The plan includes the priorities and areas of focus which are expected to start rolling out to production in October. There are two documents available from Microsoft on what’s coming in 2022 Wave 2. The first is an overview of what’s new and planned, including areas of investment,… Continue Reading...

Read More
Implementing SmartView for Microsoft Dynamics GP: Access SmartView
Jul18

Implementing SmartView for Microsoft Dynamics GP: Access SmartView

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. Once SmartView has been configured and users granted access, SmartView is available for users to use. It is launched from the Microsoft Dynamics GP menu directly under SmartList: Once launched the… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics 365 Business Central Posts Syndicated to Dynamics Community
Jul15

Microsoft Dynamics 365 Business Central Posts Syndicated to Dynamics Community

I’ve long had part of this blog syndicated to the Microsoft Dynamics GP Community, but have just requested and been given syndication of my Dynamics 365 Business Central posts. This means that any post I do for Dynamics BC will be syndicated and available on that site as well as here. I am quite new to Dynamics BC so my early posts will use an approach of “how do I…” covering topics such as… Continue...

Read More
Implementing SmartView for Microsoft Dynamics GP: Configure SmartView
Jul15

Implementing SmartView for Microsoft Dynamics GP: Configure SmartView

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. With the first of the clients installed, we can now do the required configuration. There are only a small number of steps we need to take to prepare SmartView for use. All of the configuration… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: Install SmartView
Jul14

Implementing SmartView for Microsoft Dynamics GP: Install SmartView

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. With SmartView downloaded we can get it installed on the first client. Extract the installer from the zip and launch it. Click Next on the Welcome page: Accept the terms of the End-User License… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: Download SmartView
Jul13

Implementing SmartView for Microsoft Dynamics GP: Download SmartView

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. SmartView can be downloaded from the eOne Solutions website. Select Downloads from the menu and then click on SmartView: Click the red Download button for the required version which will allow you… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: What is SmartView?
Jul12

Implementing SmartView for Microsoft Dynamics GP: What is SmartView?

This post is part of the Implementing SmartView for Microsoft Dynamics GP series were I am taking a look at the SmartView product from eOne Solutions which provides another way of using SmartLists. SmartView provides an alternative, yet fast and flexible, interface to the existing SmartLists in Microsoft Dynamics GP. It is available inside Dynamics GP just like SmartList is, yet it is also… Continue Reading azurecurve’s...

Read More
Implementing SmartView for Microsoft Dynamics GP: Series Index
Jul11

Implementing SmartView for Microsoft Dynamics GP: Series Index

SmartView is an add on from eOne Solutions for Microsoft Dynamics GP which provides another way to use SmartLists; it will work with standard SmartList objects as well as those created with SmartList Designer and SmartList Builder. I have previously done a post explaining who eOne Solutions are, so I’ll not cover that again. I’m quite a big fan of eOne Solutions’ products and have previously… Continue Reading...

Read More
Copy Additional Files for Microsoft Dynamics GP and Integration Manager Installation
Jul08

Copy Additional Files for Microsoft Dynamics GP and Integration Manager Installation

When installing Microsoft Dynamics GP for clients I’ll often create an installation package to simplify the installation process for a client. However, there are often additional files which need to be deployed to a client, such as Financial Elementz, Security Informer or other additional products or ini files for Integration Manager which contain a default location. While you can tell the… Continue Reading...

Read More
SQL View to Return Accounts Assigned to Inventory Item Classes in Microsoft Dynamics GP
Jul07

SQL View to Return Accounts Assigned to Inventory Item Classes in Microsoft Dynamics GP

I was writing a report pulling data from the Inventory Control module of Microsoft Dynamics GP the other day and I needed to include the accounts assigned to the Item Classes. I’ve written this query before and, having a need for it again, I decided to create it as a separate SQL view in order to make it more easily reusable. /*Created by Ian Grieve of azurecurve|Ramblings of an IT… Continue Reading azurecurve’s...

Read More
“Unable to obtain the next FAINDEX” Error When Integrating Data into Microsoft Dynamics GP
Jul06

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

Read More
Import Custom Company Colours into Security Informer Module for Microsoft Dynamics GP
Jul05

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

Read More
New Book on Microsoft Dynamics GP Workflow Now Available
Jul04

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

Read More
Microsoft Dynamics GP VBA Showing as Locked
Jun30

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

Read More
Microsoft Dynamics GP Table Reference Wesbite Updated to Fall 2021 Release
Jun28

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

Read More
Enable the Windows Distributed Transaction Coordinator
Jun24

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

Read More
Management Reporter Multicurrency Error
Jun22

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

Read More
Replace Expired SSL Certificate Binding with the Web Services for Microsoft Dynamics GP
Jun20

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

Read More
Historical Inventory Trial Balance VS the Historical Stock Status Report in Microsoft Dynamics GP
Jun16

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

Read More
Clear Pending Batches from Microsoft Dynamics GP Generate EFT File Window
Jun14

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

Read More
Script to Update Purchasing Unit of Measure in Microsoft Dynamics GP
Jun10

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

Read More
What NETBIOS Is The Machine On?
Jun08

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

Read More
Microsoft Dynamics 365 BC Table Reference Website Now Available
Jun06

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

Read More
MySQL Snippets: Update Statement
Jun02

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

Read More
MySQL Snippets: Series Index
May31

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

Read More
Excel Snippets: Substitute Function
May28

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

Read More
Button to Enable E-Mail Missing From The Creditors Navigation Pane in Microsoft Dynamics GP
May27

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

Read More
More Efficient Grant Script for Microsoft Dynamics GP
May25

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

Read More
SmartConnect 2021 – The source was not found, but some or all of the event logs could not be searched
May23

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

Read More