The 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.
The 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.
I 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.
While preparing earlier today for a client demo on Workflow 2.0, I encountered an error while trying to submit a batch for approval.
[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”
I 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”
Mark 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:
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.
The 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 (https://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).
['Tax Schedule Header Master']
TXSCHDSC = REPLACE(TXSCHDSC, 'Purcase', 'Purchase')
TX00101 AS ['Tax Schedule Header Master']
TXSCHDSC LIKE '%Purcase%'