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

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

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

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

SQL Server

SQL bucket filling example permalink

I’m frightened that one day this sample disappears, its from a SQL Server Central.com thread, Filling Bucketsoriginally posted by “ChrisM@work.” -- Originally from: -- http://www.sqlservercentral.com/Forums/Topic568498-338-1.aspx DECLARE @AmountToAllocate INT = 21 ;WITH Calculator AS ( SELECT BucketID, TotalSize, Amount, AmountLeftToAllocate = CASE WHEN @AmountToAllocate >

Microsoft Dynamics GP

Is eConnect Integration Service Multi-threaded?

Personally I have not experienced performance issues with eConnect, so the question to as if the integration service is multi-threaded or now had not crossed my mind before, so here are my thoughts so far after the question popped up. What is the integration service? The eConnect integration service is

Microsoft Dynamics GP

Get the System Database name for Dynamics GP

To get the system database name (used to be known as the DYNAMICS database) from any GP company, use the following SQL: SELECT TOP 1 DBNAME FROM SY00100 (NOLOCK) When issued in the context of a company database, this will tell you the name of the system database that manages

Microsoft Dynamics GP

Prefix “B:” in Dynamics GP script logs

When logging operations to script log in GP, sometimes I see “B:” prefixing sections of the script log. Out of curiosity I asked the community what the B: represents. David Musgrave kindly let me know. It turns out to mean that those parts of the script are running on the

Microsoft Dynamics GP

Determining when inventory reconcile is running in Dynamics GP

If like me you find yourself writing a lot of integrations with Dynamics GP, then you will know that you really should not be messing with data related to inventory whilst the inventory reconcile is processing. Inventory reconcile is responsible for checking that everything tallies up, on summary records. Changing

Microsoft Dynamics GP

Reconcile Dynamics GP inventory -at the speed of light*

*well almost Reconcile routines in Dynamics GP check that related data in the system is kept in sync. They total up summary and related information and check all the numbers are correct over all the tables. If the GP application crashes, say due to network connectivity issues, then data can

Microsoft Dynamics GP

Dynamics GP Conferences–which should I attend?– updated 2017

No matter how you interact with Dynamics GP, as a consultant, end user or software vendor, attending conferences is a vital element to keeping engaged with the product, alerting you to chances, what is possible and hearing from others’ experiences, good or bad. Visiting conferences allows you to network with

Microsoft Dynamics GP

Adding items to list boxes in native Dynamics GP forms using visual studio add-in

List boxes, Drop down lists, Combo Boxes can be added using modifier to Dynamics GP forms, but they are not supported for .NET access from visual studio addins. For example, adding list items to list boxes and combo boxes in native GP forms is not supported via .NET, Dexterity modifications

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