Workflow 2.0 Requires Display Names for AD Groups Used as Approver

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPMicrosoft Dynamics GP supports the use of both Active Directory Groups and Users as approvers, but there is a minor catch in the creation of groups which it is easy to stumble over. If you create the group as usual via the Active Directory Users and Computers applet you set a Group name and Group name (pre-Windows 2000):

Active Directory Users and Computers - New Object Group

Continue reading → Workflow 2.0 Requires Display Names for AD Groups Used as Approver

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed SSIS, but if you are using a named Instance of SQL Server, there is a configuration step required.

To make the change, there is a file called MsDtsSrvr.ini which, for SQL Server 2016, is located in C:\Program Files\Microsoft SQL Server\130\DTS\Binn. The ServerName needs to be changed to include the full SQL Server Instance Name (as highlighted below):

MsDtsSrvr.ini file in Notepad

Once the full SQL Server Instance Name was added and the file saved, SSIS is ready to use.

Click to show/hide the How To Install Microsoft SQL Server 2016 Series Index

● Categories: Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed the SQL Server Database Engine and the Reporting Services, but I did not configure Reporting Services. I mentioned that I have had problems before when doing this, so always do it separately.

To configure SQL Server Reporting Services (SSRS), launch Reporting Services Configuration Manager from the Windows Start menu.

Select the Report Server Instance to connect to and click Connect:

Reporting Services Configuration Connection

Continue reading → How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSRS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Series Index

● Ian Grieve ●  ● 13 Comments   ● 

Microsoft Dynamics GPA new version of SQL Server came out last year, and I’ve been creating some new demo machines for use at work. It has become habit to screenshot everything I install or configure, so I decided I might as well post a small series on how to install Microsoft SQL Server 2016 and it’s component parts.

The posts will be made over the coming days and show in the series index, below:

How To Install Microsoft SQL Server 2016
Installing SQL Server Database Engine
Configuring SQL Server Reporting Services
Installing SQL Server Analysis Services
Installing SQL Server Integration Services
SSIS Configuration For Named Instances
Installing SQL Server Management Studio

The installation of SQL Server has been broken down into different posts, as I don’t install all components all of the time, but only install the ones which are required at the time.

● Categories: Microsoft, SQL Server, SQL Server 2016, SSAS 2016, SSIS 2016, SSRS 2016 ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

● Ian Grieve ●  ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I installed the Analysis Cubes server. The next step is to configure the Analysis Cubes.

There are a choice of three Analysis Cubes Configuration Wizards available, one for each of the supported versions of SQL Server. I have selected the SQL Server 2016 version as this is the version of SQL Server I have installed:

Analysis Cubes Configuration Wizards

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the previous but one post in this series covered adding the SBA feature to the desktop client on the web server, the previous covered the installation of the SBA web components and this one will cover the configuration.

After the installation of the web components completes, the Microsoft Dynamics GP Web Components Configuration Wizard will automatically launch. Click Next to proceed:

Microsoft Dynamics GP Web Components Configuration Wizard: Welcome

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

● Categories: Dynamics, GP, Microsoft, Service Based Architecture ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

If you have a number of clients which need Microsoft Dynamics GP installed, this can become somewhat burdensome to ensure that they are all installed exactly the same way; if you do it manually at least. However, via the Microsoft Dynamics GP setup utility, you can build an installation package which much simplifies the job.

To create an installation package, launch the setup utility and select Create Installation Package from under the Install heading:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure & Use OData Service

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I am not going to cover the configuraion and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • Activating OData for better external analysis
  • Secure OData to control access
  • Connecting OData to Excel for Business Intelligence
  • Connecting GP to Power BI with OData
  • Adding Power BI to the home page in Dynamics GP

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2
Install Dynamics GP Client
Deploy System Database
Desktop Client First Run
Create A Company
Install eConnect
Install Integration Manager
Integration Manager First Run
Add Web Client Runtime
Install Web Client Single-Machine Deployment
Configure Web Components
Install Web Components Help
Manage Web Client SQL Server Login
Test Web Client
Install GP Web Resource Cache
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Install Web Services Runtime
Configure Web Services
Verify Web Services
Install Companion Application Service
Install GP PowerShell
Use GP PowerShell To Create a Company
Install GP Add-in for Microsoft Word
Install GP OData Service
Configure & Use OData Service
Create Installation Package
Add Service Based Architecture Feature
Install Service Based Architecture Web Components
Configure Web Components For Service Based Architecture
Add Analysis Cubes Client
Install Analysis Cubes Server
Configure Analysis Cubes
SmartList Designer Favorites In Advanced Lookups
SmartList Favourite Protection
Cancel A Purchase Order Linked To A Purchase Requisition
Batch Edited Message
Purchase Requisition Inquiry Icon
Display Tax Percent for Historical Sales Transactions
GL Distribution Line Display UI change
Link Credit Card Invoices To Original Invoice
Receivables & Payables Distribution Line Display UI Change
Bank Reconciliation Tracks History
Bank Reconciliation Tracks History
POP To FA Link Includes Taxes
Save Fixed Assets With Suffix
● Categories: Dynamics, GP, GP OData Service, Microsoft, Packt Publishing, Publishing ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Use GP PowerShell To Create a Company

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I covered the installation of GP PowerShell; in this I’m going to refer back to a Hands On With Microsoft Dynamics GP 2016 R1 post I did back in May 2016 on how to use GP PowerShell to create a company.

Everything in that post is still relevant and unchanged in Dynamics GP 2016 R2.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2
Install Dynamics GP Client
Deploy System Database
Desktop Client First Run
Create A Company
Install eConnect
Install Integration Manager
Integration Manager First Run
Add Web Client Runtime
Install Web Client Single-Machine Deployment
Configure Web Components
Install Web Components Help
Manage Web Client SQL Server Login
Test Web Client
Install GP Web Resource Cache
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Install Web Services Runtime
Configure Web Services
Verify Web Services
Install Companion Application Service
Install GP PowerShell
Use GP PowerShell To Create a Company
Install GP Add-in for Microsoft Word
Install GP OData Service
Configure & Use OData Service
Create Installation Package
Add Service Based Architecture Feature
Install Service Based Architecture Web Components
Configure Web Components For Service Based Architecture
Add Analysis Cubes Client
Install Analysis Cubes Server
Configure Analysis Cubes
SmartList Designer Favorites In Advanced Lookups
SmartList Favourite Protection
Cancel A Purchase Order Linked To A Purchase Requisition
Batch Edited Message
Purchase Requisition Inquiry Icon
Display Tax Percent for Historical Sales Transactions
GL Distribution Line Display UI change
Link Credit Card Invoices To Original Invoice
Receivables & Payables Distribution Line Display UI Change
Bank Reconciliation Tracks History
Bank Reconciliation Tracks History
POP To FA Link Includes Taxes
Save Fixed Assets With Suffix
● Categories: Dynamics, GP, GP PowerShell, Microsoft ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Install GP PowerShell

● Ian Grieve ●  ● 5 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Microsoft Dynamics GP has a number of PowerShell cmdlets which can be used to, for example, create new companies. To use these cmdlets, GP PowerShell needs to be installed. Launch the setup utility and select GP PowerShell from under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Install GP PowerShell

● Categories: Dynamics, GP, GP PowerShell, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●