Balsamiq Mockups 3: Install
Sep20

Balsamiq Mockups 3: Install

This post is part of the series on Balsamiq Mockups 3. Once you have downloaded Balsamic Mockups 3, launch the file and click the Install button: Once the installation is finished, leave the Run Balsamiq Mockups 3.exe, click Finish: Balsamiq Mockups is built using Adobe AIRm so on first run of the client you will be prompted to install it; click I Agree Balsamiq will then launch and show a… Continue Reading Ian Grieve’s...

Read More
Balsamiq Mockups 3: Download
Sep19

Balsamiq Mockups 3: Download

This post is part of the series on Balsamiq Mockups 3. The desktop version of Balsamiq, Balsamiq Mockups 3, can be easily downloaded and used under a 30 day free trial so you can make sure you’ll be able to use it. After navigating the the link, click the large blue Download Mockups 3 button: On the popup End User License Agreement box, click I Agree: Click save, save as or open/run to… Continue Reading Ian Grieve’s...

Read More
Balsamiq Mockups 3: Licensing
Sep18

Balsamiq Mockups 3: Licensing

This post is part of the series on Balsamiq Mockups 3. Mockups 3 for Desktop is a one time purchase and there are no maintenance costs for the license; in addition, licenses are tied to humans and not a particular machine so you can work on it on a desktop and laptop with the same license. A single user license currently costs $89.99, but there are volume licenses available with discounts… Continue Reading Ian Grieve’s...

Read More
Balsamiq Mockups 3: What is Balsamiq Mockups 3?
Sep17

Balsamiq Mockups 3: What is Balsamiq Mockups 3?

This post is part of the series on Balsamiq Mockups 3. Balsamiq Wireframes is a rapid low-fidelity UI wireframing tool which reproduces the experience of sketching on a notepad or whiteboard, but using a computer. It aims to force you to focus on structure and content early in the design process, avoiding lengthy discussions about colors and details which should come later. Balsamiq have a

Read More
Balsamiq Mockups 3: Series Index
Sep16

Balsamiq Mockups 3: Series Index

I’ve posted about a number of useful applications in the past (a href=’https://www.azurecurve.co.uk/2019/04/installing-filezilla-client-series-index/’>FileZilla, Windows 10 Calculator Replacement and Notepad++ as examples) and will post more in future. The subject of this small series, is Balsamiq Mockups. Over the next few posts, I’ll take a look at what it is and how to install and use it. <table...

Read More
Workflow in progress have been found in GP. These need to be processed before upgrading.
Sep13

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

Read More
Web Client images not loading
Sep12

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

Read More
An authentication error has occurred; this could be due to CredSSP encryption oracle remediation
Sep11

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

Read More
New features coming to Microsoft Dynamics GP in 2019
Sep10

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:

Read More
Edge Canary: Conclusion
Sep09

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

Read More
Force AnyConnect to remember profiles
Sep06

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

Read More
SSRS requires that you use local SQL Server relational databases… error
Sep05

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

Read More
Remove Microsoft Word Index Entries
Sep04

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

Read More
Copy Account Categories Between Microsoft Dynamics GP Companies
Sep03

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

Read More
Move Management Reporter To A New Domain
Sep02

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

Read More
Cannot Launch SQL Server Management Studio
Aug30

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

Read More
Remove Modified Window From Microsoft Dynamics GP
Aug29

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

Read More
Update Navigation Pane Series Order
Aug28

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

Read More
Microsoft Dynamics GP 2018 R2 Displays Full Screen By Default
Aug27

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

Read More
Decrypting Microsoft Dynamics GP Passwords Is Now Possible
Aug26

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

Read More
Using Node Builder to Create New Node: Conclusion
Aug23

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

Read More
Using Node Builder to Create New Node: Add SmartConnect Node
Aug22

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

Read More
Using Node Builder to Create New Node: Update SmartConnect GP Resource Cache
Aug21

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

Read More
Using Node Builder to Create New Node: Create Node
Aug20

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

Read More
Using Node Builder to Create New Node: Introduction
Aug19

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

Read More
Enable Bitlocker on Removable Drive
Aug16

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

Read More
Disable IE Enhanced Security Configuration
Aug15

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

Read More
Bulk Export Dynamics GP Document Attachments using .NET
Aug14

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

Read More
Microsoft Dynamics GP Error: “A Countrecords operation on table ‘[Not Found]’ (45).”
Aug13

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

Read More
Microsoft Dynamics GP In-Transit Transfer Document Locked
Aug12

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

Read More
Error Raising In-Transit Transfer in Microsoft Dynamics GP
Aug09

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

Read More
Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes
Aug08

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

Read More
Changing System Database Name After Installing the Microsoft Dynamics GP Client
Aug07

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

Read More
Enhanced Notes Setup Window Missing
Aug06

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

Read More
hMailServer: Connect Outlook 2019 Professional
Aug05

hMailServer: Connect Outlook 2019 Professional

Way back in 2015 I did a series on using hMailServer in virtual machine demo environments as a lighter alternative to Exchange. The last post in that series was on connecting Outlook to hMailServer. I am still using hMailServer, but the new version of Outlook, 2019, has changed the process of connecting. In this post, I’m going to run through connecting Outlook 2019 Professional to… Continue Reading Ian Grieve’s...

Read More
Inventory Reconcile Cannot Be Run While Users Are Posting Invoices
Aug02

Inventory Reconcile Cannot Be Run While Users Are Posting Invoices

If you try to run the Inventory Reconcile utility ((Inventory area page » Utilities » Reconcile)) when users are posting invoices, the following error message will be displayed (the same message will be displayed during a Year-End Close): You cannot complete this process while invoices are being posted If users are not posting invoices, this KB article shows all of the tables which need to… Continue Reading Ian...

Read More
Implementing Node Builder: Conclusion
Aug01

Implementing Node Builder: Conclusion

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. I was somewhat surprised that the most recent version available was the 2011 version; I think this shows that Node Builder is not a very popular product, but I am slightly surprised by this as SmartConnect seems to be a… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Connection Issue
Jul31

Implementing Node Builder: Connection Issue

This post is part of the series on Implementing Node Builder; in particular I m creating a node to add EFT Bank information when adding a creditor. The first time I installed Node Builder I received an error when trying to log in: Connection Failed A connection error occurred while trying to connect o the Node Builder database. Check the server settings to ensure Node Builder is pointing to… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Registration
Jul30

Implementing Node Builder: Registration

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. With Node Builder installed we can now launch and register it. Node Builder will be available via the Windows Start menu. When launched, you will be prompted to enter the SQL Server and a user account to connect with;… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Installation
Jul29

Implementing Node Builder: Installation

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. With Node Builder downloaded, we can now start the implementation. The download is a zip file containing NodeBuilder.exe. Extract and run this file. On the Welcome step, click Next: The Choose a file location step allows… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: Downloading
Jul26

Implementing Node Builder: Downloading

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. Node Builder can be downloaded from the eOne Solutions website; there is no requirement to leave your email address when downloading: Click to show/hide the Implementing Node Builder Series Index Implementing Node… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: System Requirements
Jul25

Implementing Node Builder: System Requirements

This post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect. The version of Node Builder available to download, is Node Builder 2011. Neither the online nor downloadable manual specify any system requirements other than Microsoft Dynamics GP. It’s important to note that Node… Continue Reading Ian Grieve’s...

Read More
Implementing Node Builder: What is Node Builder?
Jul24

Implementing Node Builder: What is Node Builder?

This post is part of the series on Implementing Node Builder. Node Builder is a complimentary product to the SmartConnect integration tool (which I blogged about a few months ago); SmartConnect works by providing an integration layer on top of eConnect which allows non-developers to create integrations for Microsoft Dynamics GP; Node Builder allows these same non-developers to create… Continue Reading Ian Grieve’s Article...

Read More
Implementing Node Builder: Series Index
Jul23

Implementing Node Builder: Series Index

Earlier this year I did a series of posts on the SmartConnect integration solution from eOne Solutions; I then followed up with a post on creating a simple General Journal integration. In this series of posts I am going to take a look at the Node Builder product which allows you to easily create additional nodes for integration. If you’re reading this on azurecurve, the series index, below,… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Database Tools Module Enhancements
Jul18

GP Power Tools Build 26 & 27 New Features: New in Build 27: Database Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The fourth area of new features I’m going to cover, is the Database Tools module in which there is one new feature: SQL Login Maintenance window A new SQL Log… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Developer Tools Module Enhancements
Jul17

GP Power Tools Build 26 & 27 New Features: New in Build 27: Developer Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The third area of new features I’m going to cover, is the Developer Tools module in which there are a number of new features: SQL GoTos Triggers against Modal… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Administrator Tools Module Enhancements
Jul15

GP Power Tools Build 26 & 27 New Features: New in Build 27: Administrator Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The second area of new features I’m going to cover, is the Administrator Tools module in which there are a number of new features: Automatic Launch… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: System Module Enhancements
Jul12

GP Power Tools Build 26 & 27 New Features: New in Build 27: System Module Enhancements

This post is part of the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The first area of new features I’m going to cover, is the System module in which there are a number of new features: Select logs to capture on startup Show user… Continue Reading...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 27: Series Index
Jul11

GP Power Tools Build 26 & 27 New Features: New in Build 27: Series Index

This post is the series index for the New Features in GP Power Tools Build 27 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. In this sub-series I am going to take a look at the new features introduced in build 27; the posts are broken down by module for easy reading. GP… Continue Reading Ian...

Read More
GP Power Tools Build 26 & 27 New Features: New in Build 26: Database Tools Module Enhancements
Jul10

GP Power Tools Build 26 & 27 New Features: New in Build 26: Database Tools Module Enhancements

This post is part of the New Features in GP Power Tools Build 26 sub-series of the GP Power Tools Build 26 & 27 New Features series in which I’m taking a look at the changes and new features since I last blogged about GP Power Tools. The fourth area of new features I’m going to cover, is the Database Tools module in which there are a number of new features: New password length Database… Continue Reading Ian...

Read More