In the blog post series by David Musgrave, he shows how to customise the GP company login boxes, to make them long enough to see very long company names in full. David uses Dexterity in the third part of the series. However in the latest he attempts to do the

"Partner Transaction Manager has disabled its support for remote/network transactions" error message in Microsoft Great Plains eConnect Specifically talking about modern operating systems such as 2008/2012/Win7/Win8. Specifically talking about eConnect version 11, for GP2010 Chill runs through your spine as you install eConnect and

I’d wrongly assumed it to be possible to commit a single sales line qty to multiple purchase order lines until it is fully committed. Frustratingly it does not work this way. * Any single sales line may only be linked to one purchase order line * Multiple sales lines can be

To keep a fresh copy of our test database always available, I scheduled a restore from the live database into the test company database to occur once a week. [Please also checkout my updated related post Automated restore of Live Company to Test Company in GP2013 CHANGES 21 Jan 2015]

To get going with Dynamics GP Templates visit these references they will save your day: Ajit Kurian's Dynamics ERP & SQL Blog - Working with Word Templates in GP 2010 Turning on the gridlines will make it easier to move fields around the layout to see how they

SELECT * FROM iv00108_history; DECLARE @ROWCOUNTER AS INT; SET @ROWCOUNTER = 903843; WHILE @ROWCOUNTER != 0 BEGIN DELETE TOP (1000) IV00108 OUTPUT DELETED.[ITEMNMBR], DELETED.[CURNCYID], DELETED.[PRCLEVEL], DELETED.[UOFM], DELETED.[TOQTY], DELETED.[FROMQTY], DELETED.[UOMPRICE], DELETED.[QTYBSUOM], DELETED.[DEX_ROW_TS] INTO IV00108_History WHERE PRCLEVEL IN ('LIST'); SET

This is a polished Excel document that you can point at your Dynamics GP database and get dashboard information presented in a nice interface. See this post here Analytics For Dynamics GP – BI Solution From Mark Polino (DynamicAccounting.Net) #MSDYNG Looking at the dashboard got me thinking, I really struggle

Background It is a requirement that all inventory should be checked annually at a minimum. There is a further desire to ensure that inventory on the shelf reflects accurately that shown in Dyanamics GP inventory. Various factors can cause a mismatch so since inventory management was invented, stock checks are

Opening a native GP form from VS addin This post covers a self help pattern, to assist developers wishing to open a native GP form from .NET using Visual Studio Tools For GP addin. An example is needed to work with, say it was required to open the Manufacturer’s

Seasonal Splash Screen The network team since I can remember have introduced seasonal splash screens to our Dynamics GP screen through the month of December. Usually with a warm message from the IT team. There are 24 different splash screens, each one switched via the login script, one for each

Problem Building a new Dynamics GP 2010 client I experienced the following error on putting our customisations into the GP 2010 Addin directory. When launching the GP application, the application crashed out. Microsoft.Dynamics.GP.BusinessIntelligence.BIReportDeploymentGP.dll: Method not found: ‘ClearCompanyListProcedure FormProcedures.get_ClearCompanyList()’. Clue to my issue was

Template maintenance in Dynamics GP2010 fails When in REPORTS>>Template Maintenance, after creating a new report from an original report, clicking on “Modify” caused a file not found exception on our install of GP. "File Not Found: C:\DOCUME1\USERXX\LOCAL1\TEMP\file you were savingcreating.docx&

07/11/2013 UPDATE: Partner has referred the matter to GP Fargo… 17/04/2015 UPDATE: New post with a fix Tax registration numbers change The Tax Registration number validation implementation looks to be flawed. Every EC country has VAT number formats they use, and regular expressions can be derived

GP Add in raised exception After applying GP2010 SP3 my GP add in started raising an exception on windows forms that used Entity Framework (EF). The error reported was System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.Lync.Utilities, Version=4.0.0.0…" …but I don’

Updated 18th May 2014 – Amended to improve stability October 2015 - New post Inactivity Auto Logout for Dynamics GP Part II GP2013R2 onwards adds extra considerations Concurrent licences Dynamics GP is licenced on a concurrent user model. Hitting max user count limit, yet having some of the user sessions idle

Member states of the European Union expose thier VAT (Tax Registration Number) validation to the masses via VIES. Below is an example using Amazon’s VAT registration details against the service on the EU website. Here the member state to which the organisation belongs has been selected, then the VAT

This is a really niche problem, as I have not already found it on the internet, I thought it worth posting. Problem When a user tries to void a sales document in Dynamics GP SOP Entry, the user session would hang. Lock escalation in SQL would then follow due to

eConnect WCF exception handling For this example a WCF service reference to the server endpoint running the GP2010 eConnect integration service as a reference named “GPeConnect” is used. If an exception were to occur from eConnect on say the CreateEnity mehods, and the exception examined as type system.exception, then

eConnectProcsRunFirst is not part of eConnectProcessInfo for eConnect 2010 eConnectProcsRunFirst is not present in the schema for GP2010 eConnect. Just to confuse people, the documentation in the eConnect SDK still references it in quite a few places still. Converting eConnectProcsRunFirst to use eConnect 2010 What to do when converting previous

After test upgrade of one of our GP installations we were getting the above error when trying to create a purchase order via eConnect. ‘PA01901’ is one of the project accounting tables, a module we don’t have installed. Late into the night I Googled the issue and found almost

After working to support Dynamics GP Macros in our Visual Studio add in for GP I discovered a new layer of macro language not touched on in Mark Polno’s publication of Kevin Gross’s GP Macro Reference. How to use macros to activate .NET add in forms Use the

How annoying is it that docking can’t be used when developing add ins for Dynamics GP forms? If a panel is docked it slides under the toolbar at the top but upsets the visual styles such as the separator lines on the buttons. See below where the panel has

This post is based on the post by Mark Polino, that pointed out some work by Kevin Gross, a Macro reference for GP Macros that was located here (May 2015 link now dead, glad I preserved it!): http://www.box.net/shared/nbdzqzkt29 The Mark Polino’s post was here:

Replicating GP price table to website To provide our website with bang up to date product prices as they are in our ERP system, we replicate the price table from our ERP system to the website SQL server database. The price table holds nearly two million price rows consisting of

Started looking at the eConnect integration with one of our websites today. We get the following error when the customer has been marked as inactive. Inactive in our world is something the finance department quantity, however we obviously want to still accept sales and ask questions later. The problem is