Microsoft Dynamics GP

A collection of 241 posts

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

Microsoft Dynamics GP

SalesPad Mobile Installer

I love the “View Update SQL” button on the SalesPad mobile server installer. This button generates the SQL that is about to be executed against your GP database into a notepad window for inspection. It was reassuring to see and understand what was about to be done to the database.

Microsoft Dynamics GP

Server drop down in Dynamics GP login not showing DSN connection 64bit machine

We have all been there, tired and forget that if the machine is running on 64bit, the WOW64 process is looking after you and the ODBC connection for GP needs setting up in the 32 bit version of the ODBC manager. This catches me out from time to time as

Microsoft Dynamics GP

Developing against Dynamics GP Multiple Bins, tables used

Quick guide to data flow when working with Dynamics GP and multiple bins. Inventory levels As is normally the case, stock levels are maintained by IV00102, in fields QTYONHND (quantity on hand) and ATYALLOC (quantity allocated). When multiple bins is enabled (see post: TSQL determine inventory MultiBinning is enabled in