A Diary of reIMAGINE 2016: Part 4 – At Heathrow Airport

reIMAGINE2016The plane arrived at Heathrow slightly late, apparently due to the airport being busy.

The flight from Newcastle was pleasant enough. I now have three-and-a-quarter hours until my flight to Chicago is due to take-off. The downside is once I get to Chicago, the next connection departs from a different terminal and I have to collect my luggage before going through customs and re-checking my luggage.

And I have to do all of that in one-and-a-half hours.

Slightly concerned, which I voiced on Twitter, but American Airlines responded saying their staff will be happy to help and not to worry. Yeah, still worrying.

As it is my flight is due to arrive in Fargo at 2205 and I am due to start work tomorrow at 0930. I don’t exactly have a lot of latitude in timings if I am going to get any sleep tonight. Why did we book a flight like this, you ask? All of the flights available had similar timings, so there was little actual choice.

Well, I’m going to try to stop borrowing trouble and worrying about it and have a nose about Heathrow Terminal 5 while I am here.

A Diary of reIMAGINE 2016: Part 3 – At Newcastle Airport

reIMAGINE2016The taxi arrived bang on time and I am now not only at the airport, but I have done the baggage drop and gone through security. This time I remembered to take my belt off and keys out of my pocket, so I had no problems.

With a couple of hours to kill before the gate opens, I’ve decided to have a breakfast stottie.

My next check-in, will ne when I am at London airport.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 2 Waiting For The Taxi

reIMAGINE2016Well, just arrived at work and am now waiting for the taxi to take me to the airport.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 1 Leaving Home

reIMAGINE2016Just about to leave on first part of journey to airport.

Overnight, I decided to do a series of posts in diary format. So this is the first of man posts today as I make my way to Fargo.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

I’m at reIMAGINE 2016

reIMAGINE2016I mentioned the other week I am at reIMAGINE this year. I realise I’ve been fairly quiet recently, post-wise, and I am not sure how much I’ll be blogging while I am away, but I intend to return in October and get to get some regularity back to my posting.

Actually, I may take the opportunity to bore you all over the course of my 20 hour trip to Fargo from the UK; I set off at 0700 UK time and arrive 2200 North Dakota time after being on four different flights.

Error Submitting Batch For Workflow 2.0 Approval

Microsoft Dynamics GPWhile preparing earlier today for a client demo on Workflow 2.0, I encountered an error while trying to submit a batch for approval.

Workflow Error

[Microsoft][SQL Server Native Client 11.0][SQL Server][A .NET Framework error occurred during execution of user-defined routine or aggregate "Get "GetAssignedUsers".
System.IO.FileLoadException: Could not load file or assembly 'System.DirectoryServices, Vers[

Continue reading “Error Submitting Batch For Workflow 2.0 Approval”

VBA for Integration Manager to Insert Vendor EFT Bank And Email Addresses

Microsoft Dynamics GPI did a SQL Script back in October 2014 which allowed Vendor EFT Details to be inserted, but, if the client is going to run it themselves, requires the assistance of the IT Department as end users don’t usually have access to SQL Server Management Studio.

For most clients, this hasn’t usually been a problem, but a number of the clients I have worked with recently have had multiple projects on the go at the same time. This has meant that while an IT representative can be available, it isn’t usually very timely and can delay UAT.

As such, I wrote some VBA script for Integration Manager which inserts both the Vendor Email and EFT Details. Continue reading “VBA for Integration Manager to Insert Vendor EFT Bank And Email Addresses”

Microsoft Dynamics GP 2016 Cookbook Now Available

Microsoft Dynamics GPMark Polino and I have been working on a new version of the Microsoft Dynamics GP Cookbook for Dynamics GP 2016. Originally, it was scheduled for publication in January 2017.

However, Mark and I were able to proceed a tad ahead of schedule, meaning the Cookbook is now available:

Microsoft Dynamics GP Cookbook

Despite being early, the quality of the book is as high, if not higher, than previous versions as this book is a genuine collaboration between Mark and I. By splitting the work in this way, we were each able to focus on particular areas in which we had strengths.

We also received good feedback, to guide improvements, from fellow MVPS Leslie Vail and Jivtesh Singh.

You can order the book from Packt Publishing.

Fixing Typo in Fabrikam’s Tax Schedule Description

Microsoft Dynamics GPThe script in this post fixes a typo, in the Fabrikam sample database, in the Tax Schedule Description whereby the h in Purchases was missing. Not a big thing, but I was working on a report which was configured to return the Description as well as the Tax Schedule ID and it was bugging me.

Hence a script to fix it, so I can easily fix it again in future.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
*/UPDATE
	['Tax Schedule Header Master']
SET
	TXSCHDSC = REPLACE(TXSCHDSC, 'Purcase', 'Purchase')
FROM
	TX00101 AS ['Tax Schedule Header Master']
WHERE
	TXSCHDSC LIKE '%Purcase%'