Dynamic Code Blocks

Microsoft Dynamics GP

Dynamics GP - Arithmetic overflow error converting IDENTITY to data type int

Anyone who looks at raw Dynamics GP tables is familiar with this column DEX_ROW_ID that occurs on most of them. It is an identity column, it auto increments an integer for each new record inserted. In GP it is an of integer data type, this means if the

General Technology Interest

Visualise regular expressions with “REGEXPER”

I have just been shown this is a really cool tool (thanks Pete). Enter a regular expression into the box at the top and it will generate a visual flow diagram of what the regular expression is doing. I think this the presentation is spot on. The site is at

Microsoft Dynamics GP

GPUG Summit 2016 Tampa USA - Part 5

Sadly Last Summit Day started with a last walk into the conference centre along the river walk with its art works, miniature trams and other artefacts along the way. Today Bob starts the day off announcing next year’s summit details, Nashville October 2017. He also lets us know what

Microsoft Dynamics GP

GPUG Summit 2016 Tampa USA - Part 4

I got invited to be interviewed by the Enterprise Software Podcast. As a listener for some time now, I couldn’t turn the offer down… We talked about the GPUG Summit and that more UK engagement is required, I did my best to promote GPUG in the interview. While at

Microsoft Dynamics GP

GPUG Summit 2016 Tampa USA - Part 3

The Microsoft show at the arena on the previous day (day zero), was a controversial late add-on to Summit. It was now day one of "proper" summit, after intros from Bob, Errol Shoenfish took to the stage and showed us power apps and talked Dynamics GP road maps

Microsoft Dynamics GP

GPUG Summit 2016 Tampa USA - Part 2

Microsoft had booked the Ice Hockey Arena booked for 2pm to give a keynote and launch Dynamics 365. That meant I had the morning to myself. I headed out of the hotel first thing (well perhaps 2nd thing haha), to discover the the hotel provides a efficient fleet of free

Microsoft Dynamics GP

GPUG Summit 2016 Tampa USA - Part 1

To Tampa, 22hrs door – door I printed my plastic luggage tag for GPUG Summit 2016 with my 3D printer and was ready to travel. The flight itinerary involved a flight from Newcastle in United Kingdom -> to London -> Miami -> Tampa. In all it took twenty

General Technology Interest

Kill hung IIS windows FTP sessions

During some integration development some FTP sessions got created with keep alive on them, but how to remove them? List active FTP sessions in IIS Sounds simple, but was not so easy. The live sessions are listed in IIS under the ftp site in question. Select the site in IIS

Microsoft Dynamics GP

Enterprise Software Podcast

If you are involved in ERP software, no matter what vendor, then the Enterprise Software Podcast is a good aggregator of news and views on the ERP software market. Informative and usually quite light-hearted.The content is product agnostic and is provides an easy way to keep in touch with

General Technology Interest

Visual Studio menu font size stuck after presenter mode

Presenter mode in visual studio (accessed via the quick launch at top right), allows VS to switch into a larger font layout, ideal for LCD projector presentations. Whilst I had this mode on I had a crash in visual studio and had messed with other settings One of these meant

Microsoft Dynamics GP

Bug with Address Name in SOP Entry of Dynamics GP 2015R2

We found on this issue, setting the ship to address from the main SOP entry window in our production Dynamics GP does not pull the correct field from the Ship To Address Name of the address book record into the order Ship To Field. Instead the company name of the

Microsoft Dynamics GP

Dynamics GP Drill Down Protocol Handler error

When using drill-downs in Dynamics GP the following error message may occur, A error has occurred trying to process your url. To fix this error and solve the problem read on… The error is displayed in the following basic error dialog. There is no information as to what the root

Microsoft Dynamics GP

GP Report Writer still gives me nightmares

People who have had to set invoice, order, purchase order and every other customer facing document layout to meet the company style guidelines using Dynamics GP report writer will curse when its name is used. It has limitations on image sizes, multiline text formatting, to difficulties in getting data from

Microsoft Dynamics GP

Dynamics GP Word Templates does not give option for “Template” in Report Destination Window

It all started when I went to do some work on Word Templates in Dynamics GP after a long absence from them (thankfully). This involved setting up a new template, I lost lots of time and then realised my whole Word template experience was broken. Other users were using word

Microsoft Dynamics GP

Dynamics GP– Process to invoice only fulfilled and shipped items for scheduled, drop-ship or call off sales orders

What are call off orders and scheduled orders? If a customer wants to order 12km of cable supplying for a long running project, but only wants it supplied in 1km despatches over the next twelve weeks, perhaps to different sites. Then this is a call off or a scheduled order.

Microsoft Dynamics GP

UK visitor to USA for conference, GPUG summit

If you are visiting the USA for a conference there are a few things to remember: Passport Obvious? – well amazing how many people realise at the last moment that the passport is expired. Check it early and get it renewed if its nearly at end of life. Visa Once you

Microsoft Dynamics GP

flocking character encoding from a PDF to eConnect

In Dynamics GP SOP line detail entry we have a custom helper window whose task it is to automatically create a new inventory item for our sales staff, when they need one for special orders. The work flow is that the details (as shown in screenshot) of the item to

Microsoft Dynamics GP

ReIMAGINE 2016 - GP 2016R2 Preview of possible new features

The professional GP community are all converging on Fargo, ND in US as I write this for the partner only conference, ReIMAGINE. We are all anticipating more detail on some of the teaser features for Dynamics GP 2016R2 that were released earlier in the year at the Amplify conference in

Visual Studio Duplicate Menu Items

Launching Visual Studio with a full drive caused the menus to duplicate, even after restart and making space they remained. I had to use a Visual Studio reset to clear the problem, be warned it messes up your config, you will need to reinitialise your VS extensions. Devenv.exe /resetuserdata

Microsoft Dynamics GP

Dynamics GP eConnect taIVCreateItemPriceListHeader & item pricing defaults in IV00101

It should be noted that creating/updating a price list header record using eConnect updates the following item card default field values; * Price level, * Pricing method * Price group * Default selling unit of measure These fields are reflected in the GP GUI here: The taIVCreateItemPriceListHeader is not the clear name for

General Technology Interest

Why I find Microsoft One Note handy for blogging UI stuff

There are many instances where there are UI elements on screen that you wish to include in a blog post as text content as well as an image, usually for SEO reasons. It can be laborious and error prone to retype from the image into the blog post, so I

Microsoft Dynamics GP

Using Visual Studio Database project Dynamics GP & source control

Source control of all aspects of a Dynamics GP solution is essential to deliver a reliable, consistent software product or system to the end users. Getting life cycle control of custom objects in the SQL database can be a challenge, even more so when looking at a typical Dynamics GP

Microsoft Dynamics GP

Dynamics GP Multiple Bins SOP10203 allocation corruption duplication

1. When a SOP sales order is fulfilled, a record of the bin allocation to the sales order line is made in SOP10203. 2. When the sales order is subsequently converted to a sales invoice, the bin allocation changed to the SOPNUMBE of the newly created invoice. The Bin allocation

Microsoft Dynamics GP

GP2016 new feature - Visual Studio SDK Project Template support for VS2015

I blogged about Visual Studio 2015 & Dynamics GP Addin Project Templates “install” in a previous post, but thankfully GP2016 Visual Studio SDK brings the installer of the Dynamic GP Add-In project templates to Visual Studio 2015 without any of that hard work. Something I was thankful of when I

Microsoft Dynamics GP

Using Excel to dynamically generate flexible SQL script, fast

Sometimes there is a need to quickly “hack” some SQL for updating many records. Using Excel as a tool to do this allows the power of Excel formulas and filtering to achieve quick generation of SQL. Often it can be quicker to use this method to generate lots of simple