Script to Insert Microsoft Dynamics GP 2018 R2 Missing Security

Microsoft Dynamics GPEach version of Microsoft Dynamics GP which is introduced sees additional functionality introduced; often this additional functionality means new windows are created. Tis in turns means that the security roles and tasks required by Dynamics Gp change.

A fresh install of Dynamics GP includes all of this new functionality by default, but an existing implementation is not updated.

The reason it isn;t automatically updated is to allow the client to decide if the new functionality should be updated or not. To facilitate this, the Dynamics GP Support and Services Blog provides a script for each version with SQL insert statements for the new roles and tasks.

I’ve previously had a post which I updated with this information, but have now created a permanent page linking to the scripts.

I’ll be keeping this page updated in future for all new versions.

Microsoft Dynamics GP Book Roundup

Microsoft Dynamics GPThere are a number of books available for Microsoft Dynamics GP which have been written by various people across a umber of years (although a few names crop up repeatedly). I thought it might be useful to list the books which are currently available for each version of Microsoft Dynamics GP; some of the books are only available for older versions of Dynamics GP, but the information within is still mostly relevant.

To avoid any appearence of favouritism, I have listed them in Dynamics GP version and author surname order (when multiple authors, the first listed author’s name is used).

Where there is no version in the name I have made by best guess as to which version it was written against.

Microsoft Dynamics GP 2018

Microsoft Dynamics GP 2016

Continue reading “Microsoft Dynamics GP Book Roundup”

Microsoft Dynamics GP Roadmap 2018-2020

Microsoft Dynamics GPAt the GP Tech Conference this week, a new road map for Microsoft Dynamics GP was released which runs through to 2020:

Microsoft Dynamics GP Roadmap 2018-2020

As announced, earlier this week, the next version of Microsoft Dynamics GP is 2018 R2 and is scheduled for release on the 1st October 2018.

As you can see, on the roadmap, Intelligent Edge will be playing more of a role in future releases, but there will also be features requested by customers and the wider community. It is this latter section which is a large part of the new features in the upcoming release.

SQL Script to Change Compatibility of All Databases

Microsoft Dynamics GPWhen moving databases between servers for an upgrade of Microsoft Dynamics GP, you will, when also upgrading SQL Server, need to change the compatibility level of the databases. Rather than dong this individually, the below script can be run against the system database to generate a script you can then run to update the compatibility level of all databases.

The highlighted variable should be changed to the relevant version.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @CompatibilityLevel VARCHAR(140) = 140


SELECT 'USE master
	GO
	ALTER DATABASE [' + DB_NAME() + '] SET COMPATIBILITY_LEVEL = ' + @CompatibilityLevel + '
	GO'
UNION ALL
	SELECT '
		ALTER DATABASE [' + ['Company Master'].INTERID + '] SET COMPATIBILITY_LEVEL = ' + @CompatibilityLevel + '
		GO'
	FROM
		SY01500 AS ['Company Master']
GO

This script doesn’t get the logical file name, but I’ve hooked it into the series I did on Logical File Name SQL Scripts as it will often be needed at the same time.

Click to show/hide the Logical File Name SQL Scripts Series Index

SQL Script to Change Database Owner of All Databases

Microsoft Dynamics GPWhen moving databases between servers, you need to make sure the databases are set to have an owner of DYNSA. Rather than dong this individually, the below script can be run against the system database to generate a script you can then run to update the db owner.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
SELECT 'USE [' + DB_NAME() + ']
	GO
	sp_changedbowner ''DYNSA''
	GO'
UNION
	SELECT 'USE [' + ['Company Master'].INTERID + ']
		GO
		sp_changedbowner ''DYNSA''
		GO'
	FROM
		SY01500 AS ['Company Master']
GO

This script doesn’t get the logical file name, but I’ve hooked it into the series I did on Logical File Name SQL Scripts as it will often be needed at the same time.

Click to show/hide the Logical File Name SQL Scripts Series Index

Organisational Accounts for Workflow in Microsoft Dynamics GP 2018

Microsoft Dynamics GPWith the release of the Microsoft Dynamics GP 2018 July Hotfix you now have the option of using Azure Active Directory Organization Accounts for the originator, approver and manager roles in Microsoft Dynamics GP Workflow.

Making Azure Organisation Accounts work with Workflow for originators, approvers and managers now means that Workflow can be used in pure Azure environments which do not have a traditional Domain Controller available.

Lucas Miller on the Dynamics GP Support and Services Blog has a blog post running through the steps to configure and install the necessary components to use this new functionality.

GP Transaction Search v2: Customising the Configuration

Precipio ServicesThis post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services.

GP Transaction Search is usable as soon as it has been installed, but can be customised in two ways by amending the GP.TransactionSearch.dll.config which is in the addins folder.

Firstly, you can change the SearchAsYouType valuer from True to False; I’d recommend this change for large datasets or where speed issues are detected:

GP.TransactionSearch.dll.config

Continue reading “GP Transaction Search v2: Customising the Configuration”

GP Transaction Search v2: Downloading and Installing

Precipio ServicesThis post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services.

Now that the prerequisites are installed we can download and install the addin. GP Transaction Search can be downloaded from Precipio Services:

Precipio Services

Continue reading “GP Transaction Search v2: Downloading and Installing”

GP Transaction Search v2: Installing the Prerequisites

Precipio ServicesThis post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services.

In version 2 there is a new prerequisite; the Visual Studio Integration Toolkit (VSIT) from Winthrop DC. In version 1, the GP Transaction Search window replaced the Transaction by Document window; in this version, VSIT has been used to allow the GP Transaction Search windows have their own menus.

VSIT is a separate download; there is a download for each version of Microsoft Dynamics GP going back to 2010. Select the correct version and download the file:

http://www.winthropdc.com/products_VSIT.htm#Downloads

Continue reading “GP Transaction Search v2: Installing the Prerequisites”

GP Transaction Search v2: Available Search Windows

Precipio ServicesThis post is part of the series on installing and configuring version 2 of this free GP Transaction Search addin from Steve Endow of Precipio Services.

The second version of GP transaction Search has followed along after version one very quickly. Despite that, it has gone from one search window for Payables Transactions, to including search windows for Receivables Management and Sales Order Processing.

In version one, the search window took over the menu of Transaction by Creditor Enquiry, but in this version, Steve has utilised the Visual Studio Integration Toolkit from Winthrop Development Consultants to create menus for each window:

Purchasing menuSales menu

Click to show/hide the GP Transaction Search v2 Series Index