Get Dates for Accruals – azurecurve
Sep04

Get Dates for Accruals – azurecurve

As I’ve mentioned before I write a fair bit of SQL code for various projects or support calls and will be posting some of it here. I recently created a report for a client to use to extract transaction lines to use to import as an accruals journal; as part of the extract I worked out the last day of the one month and the first day of the next to use as the transaction and reversing… Continue Reading Ian Grieve’s Article on...

Read More
SQL Collation – SQL_Latin1_General_CP1_CI_AS vs Latin1_General_CI_AS by Craig Verster via WinthropDC – azurecurve
Aug31

SQL Collation – SQL_Latin1_General_CP1_CI_AS vs Latin1_General_CI_AS by Craig Verster via WinthropDC – azurecurve

Over the last few years as we have grown the ERP Practice at Perfect Image we have taken over a number of clients from other Microsoft Dynamics GP partners, both in the UK and elsewhere. Far too many of them have had Dynamics GP installed with the incorrect collation. According to the system requirements, Microsoft Dynamics GP is supported with two collations: SQL_Latin1_General_CP1_CI_AS… Continue Reading Ian Grieve’s...

Read More
New GP Compatibility Page Available – azurecurve
Aug30

New GP Compatibility Page Available – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Implementing Rockton’s SmartFill: Review – azurecurve
Aug29

Implementing Rockton’s SmartFill: Review – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. Over the course of this series, I’ve stepped through the steps to, on a simple level, implement the SmartFill product from Rockton Software. I’ve been quite impressed with what I have seen of SmartFill. It is easy to install and configure and the search seems quite effective. Using the Fabrikam sample… Continue Reading Ian Grieve’s Article on their...

Read More
Customising Search Options – azurecurve
Aug28

Customising Search Options – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. While SmartFill can be used out of the box with the search being configured to lookup on several fields, it is possible to customise the search options so that more fields can be searched against. If we take the Vendor search as an example, it uses the following fields for the sdearch: Vendor ID Vendor… Continue Reading Ian Grieve’s Article on...

Read More
Implementing Rockton’s SmartFill: Configuring Security – azurecurve
Aug27

Implementing Rockton’s SmartFill: Configuring Security – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. As it installs, SmartFill is accessible and the search windows can be used by all users. It can also be administered by anyone with the POWERUSER* role. However, security can be maintained in two ways. The first type of security allowsd the lookup windows to be restricted so certain lookup windows can be… Continue Reading Ian Grieve’s Article on...

Read More
WinthropDC Special Promotion for Pennies for Taylor – azurecurve
Aug24

WinthropDC Special Promotion for Pennies for Taylor – azurecurve

Microsoft Dynamics GP MVP Shawn Dorward’s son, Taylor, was involved in a drowning accident a few weeks ago. Thanks to Taylor’s friends and the emergency teams, Taylor survived but has suffered significant brain damage; he is now on the long road to recovery and making great progress. A Go Fund Me has been running to assist in paying for Taylor’s medical expenses. To assist...

Read More
Microsoft Dynamics GP Roadmap 2018-2020 – azurecurve
Aug24

Microsoft Dynamics GP Roadmap 2018-2020 – azurecurve

At the GP Tech Conference this week, a new road map for Microsoft Dynamics GP was released which runs through to 2020: As announced, earlier this week, the next version of Microsoft Dynamics GP is 2018 R2 and is scheduled for release on the 1st October 2018. As you can see, on the roadmap, Intelligent Edge will be playing more of a role in future releases, but there will also be… Continue Reading Ian Grieve’s Article on...

Read More
Search Using SmartFill – azurecurve
Aug23

Search Using SmartFill – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. With SmartFill now installed, the search windows are available to use. There are many SmartFill search windows available, which all work in the same way, but, for this example, I am using Vendor search. Open the Vendor Maintenance window (). Type OFFICE in the Vendor ID field and hit tab: The SmartFill Make a… Continue Reading Ian Grieve’s Article...

Read More
Microsoft Dynamics GP 2018 R2 and Year-End Upgrade Blog Series Schedule – azurecurve
Aug22

Microsoft Dynamics GP 2018 R2 and Year-End Upgrade Blog Series Schedule – azurecurve

Aftre the announcement at GP TechConf2018 that the next version of Microsoft Dynamics GP would be 2018 R2, Derek Albaugh, on the Dynamics GP Support and Services Blog announce the schedule for the Microsoft Dynamics GP 2018 R2 and Year-End Upgrade Blog Series. The Microsoft Upgrade Blog Series for Microsoft Dynamics GP 2018 R2 and Year-End Update will give you the information needed for a… Continue Reading Ian Grieve’s...

Read More
Microsoft Dynamics GP 2018 R2 is the Next Version – azurecurve
Aug21

Microsoft Dynamics GP 2018 R2 is the Next Version – azurecurve

Unfortunately, I’ve not been able to attend the GP tech Confernece this week and am having to watch it vicariously on Twitter using the #GPTechConf hashtag. There’s been some interesting updates on Microsoft Dynamics GP 2018 R2 (yep, 2018 R2 and not 2019). The first bit of news is confirmation of the rumour that it would be released on 1st October instead of December. This is… Continue Reading Ian Grieve’s Article on their...

Read More
Implementing Rockton’s SmartFill: Registration – azurecurve
Aug20

Implementing Rockton’s SmartFill: Registration – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. While SmartFill will work without a licence in the Fabrikam sample company, to use it in any other company, you need to register the module. Your partner can purchase the keys for you; once the order is compelte, the registration can be updated in Microsoft Dynamics GP. To do this, open the Rockton Software… Continue Reading Ian Grieve’s Article on...

Read More
Implementing Rockton’s SmartFill: Client Installation – azurecurve
Aug17

Implementing Rockton’s SmartFill: Client Installation – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. The second step in implementing SmartFill is to install the remaining clients. Using the previously downloaded installer, extract the downloaded file and run the SmartFillSetup.exe as Administrator by right-clicking: Verify that correct install of the Microsoft Dynamics GP client is selected and click the… Continue Reading Ian Grieve’s Article on...

Read More
First Client Installation – azurecurve
Aug16

First Client Installation – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. The first step in implementing SmartFill is to install the first client; it’s in this installation where we will deploy the database objects. To install the first client, the first step is to download SmartFill; navigate to the Rockton Software downloads page. In the Product field, select SmartFill and in the… Continue Reading Ian Grieve’s Article...

Read More
What Is SmartFill – azurecurve
Aug15

What Is SmartFill – azurecurve

This post is part of a series of posts on Implementing Rockton’s SmartFill. Before starting the installation, I thought it might be useful to do a post, covering what functionality SmartFill contains. Simply put, SmartFill allows you to perform a more flexible lookup than the standard ones in Microsoft Dynamics GP. For example, you can type only a few characters of an Item Number or… Continue Reading Ian Grieve’s Article...

Read More
Implementing Rockton’s SmartFill: Series Index – azurecurve
Aug14

Implementing Rockton’s SmartFill: Series Index – azurecurve

Implementing Rockton’s SmartFill: Series Index – azurecurve Skip to content   I periodically take a look at different offering from ISVs, of which there are many One that I’ve looked at recently is SmartFill from Rockton Software. They have requested it be implemented on their system as well, and I… Continue Reading Ian Grieve’s Article on their...

Read More
PowerShell to Stop Server Manager Loading – azurecurve
Aug13

PowerShell to Stop Server Manager Loading – azurecurve

One of the things that annoys me about Windows Server 2012 and later, is that the Server Manager launches automatically whenever you log in. This wouldn;t be a problem, if it didn’t take so long to fully launch. Well, I did some exploring and investigation, and it turns out that the Server Manager is being launched at user log on by a Scheduled Task: While you can switch off Server… Continue Reading Ian Grieve’s Article on...

Read More
Stopping Auto-Play HTML5 Videos In Vivaldi (and Other Chromium Based Browsers) – azurecurve
Aug11

Stopping Auto-Play HTML5 Videos In Vivaldi (and Other Chromium Based Browsers) – azurecurve

I have a very low tolerance threshold for adverts; I largely stopped watching TV becasue of them (atually I no longer have a TV so I guess it would be more accurate to say I stopped watching TV because of them); not only are the adverts irritating in content, but the volumne was usually a lot higher than the TV show wrapped around them. Adverts on the Internet have gone through various… Continue Reading Ian Grieve’s...

Read More
SQL Script to Disable Business Analyzer Fact Pane – azurecurve
Aug10

SQL Script to Disable Business Analyzer Fact Pane – azurecurve

When the Reporting Tools are deployed for Microsoft Dynamics GP a fact pane is enabled in the navigation lists, which gives access to the reports. However, this also causes the navigation lists to be much slower. In some cases, pretty much unusable. While users can switch off the fact pane on navigation lists, they need to be disabled by each user on each list. This means people don;t… Continue Reading Ian Grieve’s Article...

Read More
SQL Script to Notify When Upgrade Complete – azurecurve
Aug09

SQL Script to Notify When Upgrade Complete – azurecurve

This SQL script was written for a client with a large number of databases and which took a long time to update and they needed to upgrade through several versions of Microsoft Dynamics GP. The script checks for start and end times in the DB_UPGRADE table; when they match for all rows, an error is raised. The script was scheduled using SQL Server Agent which was configured to send an email… Continue Reading Ian Grieve’s...

Read More
SQL Script to Change Compatibility of All Databases – azurecurve
Aug08

SQL Script to Change Compatibility of All Databases – azurecurve

When moving databases between servers for an upgrade of Microsoft Dynamics GP, you will, when also upgrading SQL Server, need to change the compatibility level of the databases. Rather than dong this individually, the below script can be run against the system database to generate a script you can then run to update the compatibility level of all databases. The highlighted variable should… Continue Reading Ian Grieve’s...

Read More
SQL Script to Change Database Owner of All Databases – azurecurve
Aug07

SQL Script to Change Database Owner of All Databases – azurecurve

When moving databases between servers, you need to make sure the databases are set to have an owner of DYNSA. Rather than dong this individually, the below script can be run against the system database to generate a script you can then run to update the db owner. /* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is... Continue Reading Ian Grieve’s Article on...

Read More
Disabling Microsoft Dynamics GP Reporting Ledgers – azurecurve
Aug06

Disabling Microsoft Dynamics GP Reporting Ledgers – azurecurve

I recently had a query from a client about Reporting Ledgers; to answer the query I enabled them in one of my demo VMs. Afterwards, I was faced with a choice; redeploy the sample company or switch off reporting ledgers. The former was going to take more time than I wanted to spend, but the latter is not possible through the Microsoft Dynamics GP front-end. I took a quick peek at the tables… Continue Reading Ian Grieve’s...

Read More
Dark Mode for azurecurve Launched – azurecurve
Aug04

Dark Mode for azurecurve Launched – azurecurve

Dark Modes for websites are becoming more common and I find myself using them more and more often. I’ve done some development work and a dark mode is now available for azurecurve|Ramblings of a Dynamics GP Consultant. To enable, or disable dark mode, use the drop down select box in the Change Mode widget in the sidebar (ringed in red): As soon as you select azurecurve Dark the page… Continue Reading Ian Grieve’s Article on...

Read More
Microsoft Dynamics GP and Making Tax Digital – azurecurve
Aug03

Microsoft Dynamics GP and Making Tax Digital – azurecurve

New HMRC Legislation for VAT will come into effect from April 2019 for businesses who have turnover above the VAT threshold to use the Making Tax Digital system to meet their VAT obligations using digital reporting and record keeping for VAT. Microsoft have been fairly quiet on the subject with only one page on the Microsoft Support site raising the subject and pointing at an idea on the… Continue Reading Ian Grieve’s...

Read More
Top 15 Microsoft Dynamics GP Blogs by Feedspot – azurecurve
Aug02

Top 15 Microsoft Dynamics GP Blogs by Feedspot – azurecurve

There have been a number of Top x Microsoft Dynamics GP blogs over the last few years. The most recent list is from Feedspot and this site is included in 4th place: Feedspot introduces the Top 15 Microsoft Dynamics GP Blogs, Websites & Newsletters To Follow in 2018 list saying: The Best Microsoft Dynamics GP Blogs from thousands of Microsoft Dynamics GP blogs on the web using search and… Continue Reading Ian Grieve’s...

Read More
Configure Workflow Setup – azurecurve
Jul31

Configure Workflow Setup – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. With Web Services|> now configured for secure connections, the final step in the configuration is to amend the Workflow setup. This is done via the Workflow Setup window (); despite this being on the System part of the menu, it is actually a Company window so any changes made will need to be repeated in all… Continue Reading Ian Grieve’s Article...

Read More
Final Service Configuration – azurecurve
Jul30

Final Service Configuration – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. Over the last few posts, I’ve stepped through the changes to the Web Service configuration files. With all of these changes made, there are a small number of steps to now complte, or confirm as complete. Firstly, as the configuration files have been changed, the Microsoft Dynamics GP Service Host needs to be… Continue Reading Ian Grieve’s Article...

Read More
Dark Mode for Outlook.com Launched – azurecurve
Jul28

Dark Mode for Outlook.com Launched – azurecurve

A dark Mode for Outlook.com is now available. To enable the theme, hit the Settings cog in the top right corner and then move the Dark mode slider to the right: Dark mode will now be enabled: I’ve been finding dark mode on lots of sites much easier to deal with and really like that tis is now available. Microsoft, Outlook.comEmail, Microsoft, Outlook.comPermalinkShortlink Continue Reading Ian Grieve’s Article on their...

Read More
Update GP Workflow Service – azurecurve
Jul27

Update GP Workflow Service – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is a href=’There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is WSBindings.config, the second is the legacy endpoint… Continue Reading Ian Grieve’s Article...

Read More
Update Native Endpoint – azurecurve
Jul26

Update Native Endpoint – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is a href=’There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is WSBindings.config; the second is the legacy endpoint… Continue Reading Ian Grieve’s Article...

Read More
Update Legacy Endpoint – azurecurve
Jul25

Update Legacy Endpoint – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is a href=’There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is WSBindings.config; the second is the legacy endpoint… Continue Reading Ian Grieve’s Article...

Read More
Enabling Secure Connection for Web Services: Update Bindings – azurecurve
Jul24

Enabling Secure Connection for Web Services: Update Bindings – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. There are several configuration files which need to be amended to enable a secure connection for Web Services. The first is WSBindings.config which is, by default, located in C:Program FilesMicrosoft DynamicsGPWebServicesServiceConfigs. There are three sections of this config file which need to be amended,… Continue Reading Ian Grieve’s Article on...

Read More
Update Certificate Binding – azurecurve
Jul23

Update Certificate Binding – azurecurve

This post is part of the Enabling Secure Connection for Web Services series. The first step in enabling a secure connection for web services, is to bind the certificate to the port which will be used for secure access. As mentioned in the last post, I am using port 48666. There are two commands which need to be run to bind the certificate; these need to be run via an elevated command… Continue Reading Ian Grieve’s Article...

Read More
Before You Begin – azurecurve
Jul20

Before You Begin – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Enabling Secure Connection for Web Services: Series Index – azurecurve
Jul19

Enabling Secure Connection for Web Services: Series Index – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Microsoft Dynamics GP Custom Link Series by Shawn Dorward – azurecurve
Jul18

Microsoft Dynamics GP Custom Link Series by Shawn Dorward – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Jet Reports 2018 R2 New Features – azurecurve
Jul17

Jet Reports 2018 R2 New Features – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Organisational Accounts for Workflow in Microsoft Dynamics GP 2018 – azurecurve
Jul16

Organisational Accounts for Workflow in Microsoft Dynamics GP 2018 – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Customising the Configuration – azurecurve
Jul13

Customising the Configuration – azurecurve

This post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services. GP Transaction Search is usable as soon as it has been installed, but can be customised in two ways by amending the GP.TransactionSearch.dll.config which is in the addins folder. Firstly, you can change the SearchAsYouType valuer from True… Continue Reading Ian Grieve’s...

Read More
Downloading and Installing – azurecurve
Jul12

Downloading and Installing – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Installing the Prerequisites – azurecurve
Jul11

Installing the Prerequisites – azurecurve

This post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services. In version 2 there is a new prerequisite; the Visual Studio Integration Toolkit (VSIT) from Winthrop DC. In version 1, the GP Transaction Search window replaced the Transaction by Document window; in this version, VSIT has been used to… Continue Reading Ian Grieve’s Article...

Read More
Available Search Windows – azurecurve
Jul10

Available Search Windows – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
GP Transaction Search v2: Series Index – azurecurve
Jul09

GP Transaction Search v2: Series Index – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Getting Normal MPC Black Edition Seek Bar Back – azurecurve
Jul08

Getting Normal MPC Black Edition Seek Bar Back – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
Find Unique Records in Microsoft Excel – azurecurve
Jul06

Find Unique Records in Microsoft Excel – azurecurve

Find Unique Records in Microsoft Excel I’m not very good with Microsoft Excel. People often think that I am becuae I can concatenate data and write if statements and other formula, but, beyond this, my knowledge is very shallow. There are things that I know you must be able to do, but have no idea how. As such, I often default to loading data into SQL Server to manipluate. When dealng… Continue Reading Ian Grieve’s Article...

Read More
Microsoft Dynamics GP July Hotfix – 2018 Mid Year Tax Update Released – azurecurve
Jul05

Microsoft Dynamics GP July Hotfix – 2018 Mid Year Tax Update Released – azurecurve

Back at the end of June, Microsoft released the Microsoft Dynamics GP July Hotfix – 2018 Mid Year Tax Update. I’ve delayed posting as there was a retraction and re-release of the hotfix due to some changes in Ontario tax and I decided to give it a little time to settle down. There are a number of bug fixes in this release, two of which I reported to Microsoft: Both of these fixes have… Continue Reading Ian Grieve’s Article...

Read More
Enabling Email for All Master Records – azurecurve
Jul04

Enabling Email for All Master Records – azurecurve

If when Microsoft Dynamics GP is implemented, you know that email documents is going to be used, the functionality can be enabled alongside the rest of the system, but for clients who were not, for example, using Purchase Order Processing from the start it needs to be switched on after the fact. When first discussing it with the client, my initial thoughts were to use a macro to enable… Continue Reading Ian Grieve’s...

Read More

Winthrop DC Now Distributing Products Directly – azurecurve

This blog is a personal project; all opinions are my own and do not necessarily reflect those of my employer. This blog and its content is provided “AS IS” with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. The author shall not be liable for any direct, indirect, incidental or consequential damages… Continue Reading Ian...

Read More
MVP Not Renewed for 2018-2019 – azurecurve
Jul02

MVP Not Renewed for 2018-2019 – azurecurve

Well, it seems that doing even more in this renewal period than I did to get the MVP award originally or keep it for three renewals, I have not done enough to retain it for the 2018-2019 year. There seems to have been a mass culling this year, caused by Microsoft assigning more weight to some types of contribution than other types. As a note, the renewal process is opaque with no… Continue Reading Ian Grieve’s Article on...

Read More