Microsoft Dynamics GP

Dynamics GP will not remove hold or why timestamp format in GP matters

If Dynamics GP will not let a SOP module, transaction process hold be removed in the user interface, it may be due to formatting of time stamps. Check no integrating applications have created that hold incorrectly. The issue is that GP is real fussy about formats of timestamps, one place

SQL indexed views are incompatible with Dynamics GP

Microsoft Dynamics GP

Find orphan note records in a Dynamics GP company database

About the Dynamics GP Notes table Notes are held within the SY03900 company table in Dynamics GP. Every note in that notes table has a NOTEINDX, which is used by other tables in GP to reference that note. This makes the notes system extensible, when new modules/addins are created

Microsoft Dynamics GP

Rebuild QTYONORDER of IV00102 Dynamics GP

I had to rebuild the quantity on purchase order of the inventory site qtys table today (On Order in Item Enquiry). Wrote this SQL script that works for our install with our settings, but you should verify your install does not have other modules or modifications that may make this

SQL Server

Yes you can - SQL Server Table Compression and Dynamics GP

Today I attended SqlBits in Manchester UK, where there was a session “Performance tuning SQL server on crappy hardware” by Monica Rathbun. Monica has a the fast and punchy presentation style I enjoyed. Although I had already experienced or knew most of what was covered it was still a good

Microsoft Dynamics GP

SQL server Optimize for Ad hoc Workloads setting in server advanced properties window

TL;DR Turn this option on, from false to true Whilst looking at a problem SQL server instance, I was on the diagnostic journey looking at why the query plan cache was getting totally cleared every few minutes. It turned out the server had bad memory setup and SQL server

Microsoft Dynamics GP

Protocol handler debugging in Dynamics GP (drill down) problems

In previous blog posts we have talked about the way that other applications can drill down into parts of GP by using an direct approach via a pluggable protocol handler that is installed when GP is installed. Sometimes this does not work, to debug if the protocol handler has an

Docker

Diagnosing PowerShell New-GPSystemDatabase error when creating the Dynamics GP system database

The PowerShell modules for GP allow a number of DevOps activities. For example you may install the Dynamics GP Lesson (sample) company TWO and install the system database via these PowerShell modules. I take full advantage of the PowerShell modules when running and building Docker images for Dynamics GP. Today

Microsoft Dynamics GP

Problem with extensions search in visual studio

If you are using Dynamics GP with Visual Studio 2017 –> , you will find that the project templates for Dynamics GP do not show up in the new project or new item menus. I wrote a solution to this in the form of a Visual Studio extension, but it seems

Microsoft Dynamics GP

Deploy Dynamics GP during development using Visual Studio External Tools Menu

I’ve never written this up before, but is a useful technique I use to allow the deployment of GP from the current project active build directory to the application addins folder. Note that in this example PowerShell script, it will empty the addins folder before deploy. This may not

Microsoft Dynamics GP

*Unofficial luggage tag - Phoenix Summit 2018

The above model will download into Windows 10 Print 3D or Paint 3D etc If you have a 3D printer feel free to download the STL for the above luggage tag. Summit2018.stl

Microsoft Dynamics GP

Microsoft Dynamics Community Blogs Notifications now enabled again

It used to be possible to subscribe and thus receive and email whenever blog content was updated in the community blogs. The ability to have an email sent when content changes in the community blogs has been restored after it was lost in the big redesign earlier in the year.

Microsoft Dynamics GP

Are you a Tab or Enter kind of person

Tab or Enter? Navigation from field to field on a form in Microsoft Dynamics GP can be performed using the [Tab] key, or if the option has been set the [Return] key on the keyboard. A quick internet search reveals this ability to change field navigation preference is a standard

Microsoft Dynamics GP

GPUG Summit 2018 Phoenix Arizona–October 15-18th

If you are into Dynamics GP, Power BI, then head over to GPUG Summit summit this October in Arizona – even better, bring your “IT crowd” too! This event has over 215 GP –specific sessions and a separate parallel conferences going on “under the same roof” for business central and Power

Microsoft Dynamics GP

Dynamics GP 2018 wrong version of GP2018 Power Shell included

Be aware of an issue with the GP2018 installation media You can see above that the installation media MDGP2018_RTM_DVD_ENUS has under the Additional Products the GP2016 installer for Power Shell. The correct installer has been provided by Microsoft under Customer Source here: https://mbs.microsoft.com/customersource/

Microsoft Dynamics GP

Converting Dynamics GP SOP Master numbers to file system folder hierarchy

Large numbers of files in a folder causes some serious performance issues on windows There are a number of cases where I need to store a document or documents against an “object” in GP for the various system integrations and modifications. This can be problematic where this causes too many

Microsoft Dynamics GP

Dynamics GP Font Size

Increasing font size for GP users with poor eyesight Today one of my co-workers from the infrastructure team asked me to include a “magic file” into our standard GP deployment. The file is activated via a registry key on the user’s machine and provides them with a bigger font

Microsoft Dynamics GP

Microsoft Dynamics GP–United Kingdom, Making Tax Digital (VAT) for business MTD / MTSfb

Update 23rd April 2019 April 2019 Hotfix for Dynamics GP - Making Tax Digital. Microsoft have released a bug fix to the error: You may incorrectly receive an error in VAT Daybook Obligation period dates do not match with the VAT Daybook Calendar. This occurs when logged in as the

Microsoft Dynamics GP

Setting multi-line text box control in a Microsoft Dynamics GP add-in to be empty or blank

When working with multi-line text boxes (Text Tool), rather than single line edit boxes, it is easy to introduce a bug to your application. The text box contents can be set with the the example code below: ItemMaint.LocalTxtExtraInfo.Value = result.ExtraInfoDescription …where the value of the right hand side

Microsoft Dynamics GP

Dynamics GP basic pricing export to Excel with crosstab SQL

The following SQL table function allows exporting of GP prices into Excel. Assumes max of 6 price breaks, but can be expanded. Usage: SELECT * FROM [Extract_PricesCrosstabTable_Fast] ('GBP','TRADE','%') ORDER BY ITEMNMBR -- ============================================= -- Author: Tim Wappat -- Create date: 2010-08-02 -- Description:

Microsoft Dynamics GP

A coutrecords operation on table ‘[Not Found]’ cannot find the table–Dynamics GP

Symptom: User experiencing this error dialog when using navigation lists, but can happen in other areas of Dynamics GP Cause and solutions: This error is caused by the client machine that is running Dynamics GP loosing network connection at some point during the Dynamics GP session. Dynamics GP holds some

Microsoft Dynamics GP

Silent install of Microsoft Dynamics GP eConnect

I needed to do a silent install of eConnect for Dynamics GP but couldn’t find the documentation on how to do it, I figured it out and document it here for future reference: The eConnect installer is found in the additional products folder of the installer image/disk. \MDGP2016_

Microsoft Dynamics GP

Retail Microsoft Dynamics GP Point of Sale Systems (POS)

What retail point of sale (POS), retail store, till Systems are compatible with and also work well with Microsoft Dynamics GP? On my investigation, the market seems to be sparse with only a few products out there: Compass POS- seems to get the most praise and most mentions Salespad POS

General Technology Interest

Enterprise Microsoft Dynamics consultants and developers should sit up and pay attention to Microsoft Graph, a briefing

If you are involved in business software then Microsoft Graph is a really big deal, so sit up and pay attention! Graph is quickly becoming the all pervasive API for access/control of the Microsoft cloud products and services. This is going to encompass Azure AD, Excel, Outlook, OneDrive, OneNote,

Microsoft Dynamics GP

Service Unavailable (HTTP Error 503) Server Error in ‘/lus’ Application–Dynamics GP

Recently user home pages have been showing a few different error messages under the “connect widget” area of the home page. The connect widget is considered by some as a waste of bandwidth and is disabled for all users, to others it is a useful source feed of news and