Dynamic Code Blocks (Page 3)

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.

Docker

Remove or delete KDSRootKey (KDS Root Key)

When creating GMSA (group managed service account) for Docker it is easy to run scripts too many times leaving yourself with multiple KDSRootKeys – I’m not aware of a Powershell command to remove them, but this user interface based method works to delete the unwanted KDS Root Keys. To view

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

Docker

Docker build and UilttiuyVM: The parameter is incorrect - Failed to regis error

The following error can occur when doing a Docker build. Docker . failed to register layer: re-exec error: exit status 1: output: processUtilityWImage [\\?\C:\ProgramData\docker\windowsfilter](file:///\%3f\C:\ProgramData\docker\windowsfilter) \UtilityVM: The parameter is incorrect. At line: 2 char: 1 + Docker build - -tag tw/gp2018 . + CategoryInfo :NotSpecified:

Docker

Installing Docker onto Windows Server 2016

https://docs.docker.com/install/windows/docker-ee/ Docker comes in two editions, free community edition and enterprise edition. The company Docker and Microsoft entered into a commercial agreement to bring Docker to windows server as a commercially supported container enterprise product. Docker running containers on Windows is the result of

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

.NET 4.6.1 or 4.6.2 seem to break IsInRole()

Upgraded application using IsInRole(), now only returns false (vb.net) Read to the end before making code changes as there is a more obvious thing to check! To support TLS1.2 for PCI requirements I was upgrading one of the applications to 4.6.1, after deployment behaviour controlled by

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

WCF Registered base address schemes are []

Moved WCF service from old server to 2012 server to find the WCF service would not run. It complained that "Could not find a base address that matches scheme http for the endpoint with binding WebHttpBinding. Registered base address schemes are []" Stack overflow post below was the lead

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

Team Foundation Server

TF400409 you do not have licensing right to access this feature

Setting up a new user for team foundation server, although user has been added to all the licencing groups and project groups, they cannot expand the root node of the team collection. They can also not access the portal security pages as it gives the above error. Turned out to

SQL Server

SQL formatting and Power Query

Today I got caught out by using SSMSBoost to SQL format a query being used as the source for a Microsoft Power Query. On updating the stored procedure the query stopped working in Power Query, with the error that the column “Temp” was missing. Looking at the query output in

ClickOnce with report viewer control

Installing SSRS Report Viewer component for Visual Studio 2017 (VS2017) using NUGET For Visual Studio 2017, the SQL server reporting services, report viewer component, for web forms or windows forms has been put into a NuGet package. This means it can be installed into projects where it is required, with

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_

ClickOnce Deployment failing–requires installing into GAC

Note to myself for future for this issue: After making some changes to an application, I went to publish it using Visual Studio, as a ClickOnce application. On trying to install the resulting published application I got presented with the following error. Unable to install or run the application. The

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