Dynamic Code Blocks (Page 3)

Dynamics GP VAT rate change and how to deal with it

8th July 2020 and the UK government have announced that temporary reduction of VAT rate from 20% to 5% for hospitality sector (on food, accommodation and attractions), from 15th July until 12 January 2021. This gives you only one week to get advice from your ERP support on how to

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

Installing Remote Server Administration Tools for Windows 10

Note to self, run following where the add features option in windows doesn't work. DISM.exe /Online /add-capability /CapabilityName:Rsat.ActiveDirectory.DS-LDS.Tools~~~~0.0.1.0 /CapabilityName:Rsat.BitLocker.Recovery.Tools~~~~0.0.1.0 /CapabilityName:Rsat.CertificateServices.Tools~~~~0.0.1.0 /CapabilityName:Rsat.DHCP.Tools~

Office Interop Access is denied fix for .NET automation of Microsoft Office

Problem, Could not load file or assembly … or one of its dependencies. Access is denied This is the solution to a perplexing issue around Office automation, that many people do not seem to be finding a solution for on forums. The story, on a newly deployed set of PCs, a

Microsoft Dynamics GP

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

Solution to Acrobat reader slow to attach email, Get a link to your file, How do you want to share your file

Our Dynamics GP uses reporting services for generating sales documents, these documents often need to be emailed to customers and suppliers. It was recently brought to my attention that pressing the share icon on Acrobat DC to send a PDF by email launches a new share window. This window seems

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

SQL Server

Failed to grant permission to execute error and Zen Barcode for SSRS 2016 Reporting Services

Copy assemblies into the correct reporting services folder When migrating to a new SQL server the barcodes were causing an issue, firstly because we lacked the barcode assemblies in the reporting services bin folder for the new version of Reporting Services that came with SQL server 2016. Finding the dlls

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

SQL Server

SQL Server upgrade step 'msdb110_upgrade.sql' encountered error 2714, state 6, severity 25

Upgrading SQL server to SP4 or SQL Server 2016 encountered error 'msdb110_upgrade.sql' encountered error 2714, state 6, severity 25 Whilst performing a dummy run for a SQL Server instance upgrade, I encountered this error and it resulted in the SQL service not starting after the upgrade

SQL Server

Prevent SQL job running when another job is running

From SO post: https://stackoverflow.com/questions/200195/how-can-i-determine-the-status-of-a-job CREATE VIEW myschema.Admin_RunningSQLJobs AS SELECT job.NAME ,job.job_id ,job.originating_server ,activity.run_requested_date ,DATEDIFF(SECOND, activity.run_requested_date, GETDATE()) AS Elapsed FROM msdb.dbo.sysjobs_view job JOIN msdb.dbo.sysjobactivity activity ON job.

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.

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/