Microsoft Dynamics GP

A collection of 240 posts

Microsoft Dynamics GP

Dynamics GP, Item description is one hundred character capacity?

A little curiosity of mine is around this finding & why it is so… Fill the item description field of an item in dynamics GP and then paste the text into a notepad application to measure its length. You will find it has a capacity of one hundred characters… Yet have

Microsoft Dynamics GP

Why does Dynamics GP use Table Heaps (no clustered indexes)?

First we should define what a table heap is. A heap is a table without a clustered index. Data is stored in the heap without specifying an order. Usually data is initially stored in the order in which is the rows are inserted into the table, but the Database Engine

Microsoft Dynamics GP

Finding a rogue “dll” causing trouble with “different version of the same dependent assembly”

In Dynamics GP development, we have lots of .dll files around arising from support for many version releases of GP. These files litter our projects and sometimes a dll may go astray and cause trouble by ending up in a folder to which it should not belong. This powershell command

Microsoft Dynamics GP

Dynamics GP next sales order number is corrupted as has become the same as the next quote number range

This problem happened today, first time for a few years, but it used to happen regularly (every few months). The issue is that the auto populated sales order number in sales transaction entry gets overwritten with the number from the quotation number range. My guess for the circumstances of this

Microsoft Dynamics GP

Dynamics GP - Manual Payment does not generate next cheque/check number or document number

Manual Payment empty document number, not defaulted When making a manual payment normally, after selecting the payee, the cheque book attached to that payee is queried for its next cheque number, that is then auto populated into the “Document No” field shown. During month end we found all of a

Microsoft Dynamics GP

Correct reconcile Dynamics GP SOP batch totals and transaction counts without SQL

Sometimes batch totals and transaction counts get corrupted in GP, there can be many reasons behind this. To correct them the check links maintenance routine can be executed for “Sales Work”. This will correct the batch totals but will take a very long time to run and is not the

Microsoft Dynamics GP

Dynamics GP - SQL script to revert multiple bins into single bins

So you want to turn off multiple binning in Dynamics GP and need to record the multiple bin where the stock is held back into the basic single bin field against each location? This script I just used to do that, it will pick the multiple bin with the most

Dynamics 365 Financials

Uppercase in computer records–please no!

From time to time you encounter systems where the company style is to capitalise names in the system. I know of users who might as well glue the caps-lock on! If faced with the, we have always done it this way problem, fight it. Excuses come out like its for

Microsoft Dynamics GP

Dynamics GP–Clicking “on order” in inventory enquiry shows blank empty with no purchase orders

Seen this from three users recently. The issue is that the user clicks the on order hyperlink text in item enquiry to see the purchase orders in Purchase Order Processing Item Enquiry, but nothing is shown in the window. Notice at the bottom it says processing. I assume that this

Microsoft Dynamics GP

Visual Studio 2017 & Dynamics GP Addin Project Templates “install”

Now we have Visual Studio 2017 and again it is awesome! Drop what you are doing and start developing with it right now! If you are a .NET Dynamics GP Addin developer you will find that the project templates are not available for Visual Studio 2017, at the time of

Microsoft Dynamics GP

Bad Power Value from searching on master number in sales transaction smartlist–Dynamics GP

Searching on the Master Number field in the normal Sales Transactions smart list in Dynamics GP can cause an error to occur. In the following screenshot you can see the search, nothing odd there? However on executing the search the following error occurs: Unhandled script exception: Bad power value EXCEPTION_

Microsoft Dynamics GP

Could not load file or assembly Microsoft.Dexterity.Bridge.dll or one of its dependencies – Dynamics GP

When developing Dynamics GP addins, the above error can occur for a number of reasons. It generally means what it says, the referenced assembly is looking for a resource it can’t find on the available search locations. If this is encountered whist developing a Dynamics GP addin while attempting

Microsoft Dynamics GP

Fabrikam Day 12th April 2017

Around the world people are posting photos of local landmarks and a #FabrikamDay banner, just for fun and to celebrate a sense of community around our product, Microsoft Dynamics GP. Here is my contribution in front of The Angel of the North The date is a random date that was

Microsoft Dynamics GP

VST Controls®™ for Dynamics GP Visual Studio Tools development

I’m so glad the day has finally arrived where I can talk about this innovation, I think this is one of the coolest things in .NET development with Dynamics GP for some time. I have been restless  to give it a go since I was first told about it.

Microsoft Dynamics GP

Screwed Allocations in Dynamics GP

Dynamics GP SOP Entry causing dodgy site allocations This is purely and observational post of a phenomenon we see in GP from time to time. The telesales team perform data entry in the SOP screens at a lightening pace, tabbing through windows, hammering information into the screens very quickly while

Microsoft Dynamics GP

Dynamics GP Stored procedure [smFormatStringsForExecs]

You’ve seen it often enough in GP stored procedures, but what is it doing? EXEC @iStatus = smFormatStringsForExecs @I_vInputString = @I_charEndCustomer, @O_cOutputString = @cEndCustomer OUTPUT, @O_iErrorState = @O_iErrorState OUTPUT The above code snippet is the common code pattern it appears in. I had always assumed, until today that

Microsoft Dynamics GP

Dynamics GP eConnect and handling exceptions under Web API

Beware when using eConnect with ASP.NET Web API. … as exceptions raised by eConnect will not be of type eConnect.Exception thus using our normal typical catch block, such as: catch(eConnectException ex) will not work, because all eConnectExceptions will actually cause the following exception to be raised/returned: System.

Microsoft Dynamics GP

Exporting from SmartList Dynamics GP “returned 29”

Are you experiencing a dialog box with the following text on attempting to export a Smartlist to Excel? “RUN APPLICATION ERROR” "C:\Users\user\AppData\Local\Temp\7\somefilename.xlsx returned 29" This seems to be an error passed back from Excel regarding permissions issues, or lack of communication to

Microsoft Dynamics GP

FP: Couldn’t close table! Dynamics GP Error Solution

I talked before in a previous blog post about the “syContentPageXMLCache cannot find table” error. This and its cousin the “FP: Couldn’t close table!” error are caused when something disrupts Dynamics GP’s long lived open SQL connections between the client and server. This might be due to networking

Microsoft Dynamics GP

What do you call that window GP?

Steve Endow mentioned on twitter the other day about the naming of objects in GP when programming. The inconstancies are astounding, I have to agree, you can spend half an hour trying to determine if the object named something almost like what you want is actually the object you want

Microsoft Dynamics GP

Installing Dynamics GP Intrastat Module

If you are looking for the Intrastat module, it is part of the Main GP install, I think fromGP2013 when more of the product extras were bundled in - but certainly from GP 2015. When running the GP installer the various features that can be installed are offered in the

Microsoft Dynamics GP

SQL to extract contiguous ranges for maintenance tasks in Dynamics GP

From time to time I find some SQL that really makes me smile and sit back and stare at it with awe. Today is one of those days, let me show you… Many of the maintenance windows in Dynamics GP ask for ranges of numbers to be entered. They consist

Microsoft Dynamics GP

Error: This document contains one or more posting holds, Dynamics GP Edit List

If you are experiencing this on SOP Sales Invoice posting edit lists, then maybe you are using drop ship items. Also perhaps you have the Shipping Notification Tool installed? There is no posting hold as such on the document, the posting hold mechanism is being hijacked by the shipping tool

Microsoft Dynamics GP

Empty Matched To Shipment in Purchasing Invoice Entry of Dynamics GP

About from time to time on Euro transactions we get a yellow triangle and empty “Matched to Shipment” field in the Purchasing Invoice Entry window of GP. The problem is always the same, the fields * CURNCYID * CURRNIDX * XCHGRATE * RATECALC Are all either default or missing for the item row in

Microsoft Dynamics GP

OLE Notes Migration

It was time to get our old OLE notes migrated. GP has stopped using OLE notes containers for attachments to notes in the system, mostly due to the need to work with the web browser hosting of GP.  I didn’t want to import the attachments back into the new