Microsoft Dynamics GP

A collection of 244 posts

Microsoft Dynamics GP

Best Warehouse Management and Barcode Solutions (WMS) for Microsoft Dynamics GP

Last updated: 08th August 2018 What do you mean by barcoding in the warehouse? "is there a barcode solution for Microsoft Dynamics GP?", this is a common question found on Dynamics GP forums. Barcoding in a warehouse environment can span in complexity from simple data capture used to

Microsoft Dynamics GP

Word Template reports format messed up when rendered to PDF Dynamics GP 2015

Dynamics GP2015 Word PDF Alignment wrong After upgrade to GP2015 it was found the modified reports using Word Templates screwed up when sent to email as PDF. Email embedded PDF reports from Dynamics GP messes up the formatting, resulting junk formatting. After a week of investigation and following false leads

SQL Server

Update all XML element nodes in an XML field of a SQL table

I wrote an electronic invoicing solution for Dynamics GP a long time ago. The XML invoices of various formats are stored against the invoice number in the database. The column was upgraded to XML type when SQL sever started supporting it in SQL 2005. Although it is possible to cast

Microsoft Dynamics GP

ERP integration–protecting API keys & cloud credentials

Securely manage your API keys With a greater number of API’s in the enterprise that are dealing with increasingly sensitive business processes or data, it is now more important than ever to actively manage API keys and credentials in a secure way. This is of interest to consultants, developers

Microsoft Dynamics GP

Office Snipping Tool for creating documentation screen grabs - screen shot of the Snipping Tool

The sniping tool is a handy tool that was introduced into the windows operating system and is one of the tools I most frequently use in windows. It is useful when creating documentation for Dynamics GP processes and other software documentation. Recently I wanted to take a screen shot of

Microsoft Dynamics GP

Managing document attachments in Dynamics GP

What is document attach? Dynamics GP 2013R2 introduces document attach, allowing files (photos, PDF’s, drawings, spread sheets, emails etc) to be associated, attached with objects in GP. An attachment icon appears on transactions and cards, window notes and many other places. An example may be attaching customer purchase orders

Microsoft Dynamics GP

Dynamics GP auto roll out of updates

GP is very configurable, that is one of its big strengths. IT teams can update reports and form layouts, developers can create wonderful new add ins, new modules can be added or removed. etc. With these different sources of updates, and frequency of changes, it becomes important to keep GP

Microsoft Dynamics GP

Installing Word Addin GP, upgrade patch cannot be installed error

Switching on msi logging reveals the following extract form the log file: MSI (c) (68:F8) [12:44:21:188]: Full optimizations are not possible in the patch sequencer because new patch[es] had been added in the current transaction. MSI (c) (68:F8) [12:44:21:188]: Applicability checks

econnect

“ta” eConnect stored procedures & upgrades a thought…

eConnect presents a “pre” and “post” procedure for the various document transactions. This allows custom SQL scripts to be ran before and after eConnect transactions. Beware, as anyone who works with eConnect will tell you, these procedures are DROPPED during version upgrades. This understandably makes developers wary of using them,

Microsoft Dynamics GP

GPUG Magazine Q2–2016 is available!

If you didn’t already know, there is a professional magazine for Dynamics GP. Published by the Dynamics GP User Group (GPUG). The magazine has hints & tips, conference and events listings, product and services advertisements that are relevant to the GP market. Also showcased are some of the benefits

Microsoft Dynamics GP

Dynamics GP upgrade changes keyable length of phone numbers

David Musgrave explains how to Changing the Phone Number Format to allow more characters to be inputted through the GP user interface. Using eConnect it is possible to set the full 21 characters of the phone number when changing or creating a record. However as the default for the UK

Microsoft Dynamics GP

Upgrading GP Addin Mods to use EF6

After adding the configuration sections to Dynamics.exe.config <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> <entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.

Microsoft Dynamics GP

Dynamics GP window forms flickering-redrawing during Network Group Policy update

Rolling out Windows 10 to our estate has caused an issue with Dynamics GP interacting with Group Policy updates. The users are experiencing the form windows in Dynamics GP vigorously flickering/updating for about five seconds, at regular, but random intervals through the day. Group policy is a set of

Microsoft Dynamics GP

Hacking the suggested items feature in GP to create a flexible sales scripting system

In telesales, and ecommerce we have three common directions to take a sale: * Cross selling * Down selling * Up selling The Suggest Sales Item window by default design is intended to suggest other items that could be added to the sales order, on the basis of a trigger item being added

Microsoft Dynamics GP

Installing both msi & msp package together for Dynamics GP “R2” versions

For those with network deployment to consider, around one hundred machines we do, then Dynamics GP has a neat feature to “Create Installation Package”, which does just that. By selecting the option from the installation media it will package up the local fully configured GP client into an msi installer

Microsoft Dynamics GP

Dynamics GP Visual Studio Tools SDK download

I am used to downloading developer resources from MSDN subscriber downloads or MS Dynamics Customer source I lost the SDK for Visual Studio add-in creation with Dynamics GP. After trying to web search for it I didn’t find anything but the links to the GP2013 version downloads. Visual Studio

Microsoft Dynamics GP

SQL Calculate Customer Balance & On Order amount for Dynamics GP

The values in the Customer summary table RM00103 keep drifting from what they should be. This causes issues with our pick list printing service that was using them in a complex credit checking routine. Sometimes the on order amount could be minus thousands of pounds, leading to goods being despatched

Microsoft Dynamics GP

test company, test database, live company in test database, test company in live database…

How times have changed. Now we have a SAN and ESX Hypervisors hosting our servers, virtualisation and new hardware platforms have made managing enterprise infrastructure so much easier. For developers this had made possible the cloning of live environments, yes webservers, databases, ERP and various integrations can all be plucked

Microsoft Dynamics GP

Dynavistics acquire rights to Trinity (m-hance) source code

The news article linked below reveals that Dynavistics have acquired rights to develop the Myridas products that were acquired themselves by m-hance when they absorbed Trinity Computers during the m-hance acquisition run that achieved a 45% sales growth for the m-hance in 2012. Dynavistics Acquires the Right to Develop Trinity

Microsoft Dynamics GP

Enabling Dynamics GP Modules

It can be confusing where in the GP user interface that functionality in GP is enabled from. It can seem like there is no consistent place to go in order to enable functionality. In this post I’m quickly just going to show some examples and leave it at that…

Microsoft Dynamics GP

Solution to eConnect Requester SOP Transaction trigger not creating output records

eConnect uses a Document Requester system to allow database activity in GP to be tracked, say for the creation of sales orders. It also allows the database to be queried via the eConnect API, without any logging to output tables. Steve Endow has written up here on his blog, 8

Microsoft Dynamics GP

eConnect fails to update field ITMVNDTY (IV00103) from field PRIMVNDR (IV00102)

Why does eConnect not update the IV00103 ITMVNDTY field when changing the primary vendor, PRIMVNDR of IV00102? Table IV00102 item-site This table relates items to sites, including what stock is at each site and which primary default vendor should be used for that site. The default vendor is held in

Microsoft Dynamics GP

Custom links example in Dynamics GP

A post on the Dynamics GP community forum reminded me of something I set up way back, custom links for linking to an item on a website from GP. Dynamics Community Forum for GP Custom Links Custom links are supported for a limited number of prompts within GP; * Chequebook * Credit

Microsoft Dynamics GP

Dynamics GP Fix “Amount Remaining” incorrect on receivables transaction payment apply

For the following Debtor, the GP client server connection was interrupted whilst payments were being applied. This left the apply in an inconstant state. Subsequently the payment was unapplied, leaving the “amount remaining” for the payment double what it should be. This is because removing the apply has “credited” the

Microsoft Dynamics GP

Custom eConnect XML Node–Procedure or function expects parameter, which was not supplied

Custom XML nodes error with parameters It is possible to run your own custom stored procedures from eConnect, by passing in parameters via a custom XML nodes. I have explained this technique in a previous post, there is more information on MSDN too: * This Blog: Using custom nodes in eConnect