Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. As mentioned in the last post, the client installation these days includes the server installation. With one client now installed, the next step is to deploy the system database.

Do this by launching GP Utilities from the Windows Start menu and log in using the SQL Server sa account:

Welcome to Microsoft Dynamics GP Utilities - login

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Deploy system database”

Hands On with Microsoft Dynamics GP October 2019 Release: Install Microsoft Dynamics GP client

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. In a previous post, i downloaded the media so the next action is to install the client.

Back in the old days of Microsoft Dynamics GP 9, I would have installed the server components first, but since Dynamics GP 10, the client includes the media. When you launch the Setup Utility from the installation media on a machine for the first time, the Microsoft Dynamics GP Bootstrapper Setup will run.

Click Install to install the listed components:

Microsoft Dynamics GP Bootstrapper Setup

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install Microsoft Dynamics GP client”

Hands On with Microsoft Dynamics GP October 2019 Release: Microsoft Dynamics GP client prerequisites

Microsoft Dynamics GPThis post is part of the series where I am going hands on with the new version of Microsoft Dynamics GP.

Before installing any of the Microsoft Dynamics GP components, you need to make sure the system requirements are met. On top of this there is also some prerequisites which need to be met before the Microsoft Dynamics GP client or other components can be installed.

Most of these prerequisites can be handled by installer process, there is one which cannot; this is the .NET Framework 3.5 feature which is installed using the Add Roles and Features Wizard available via Server Manager on Windows Server or using Turn Windows features on or off accessible via Program and Features on Windows.

If the PC or server you’re planning to install Microsoft Dynamics GP onto has an Internet connection, then the .NET can be installed simply by using the wizard. However, if, for whatever reason, you don’t have an Internet connection available, the install process isn’t quite that smooth.

However, for both server and PC you can do an offline install and I have blogged about this several years ago:

The above articles are for older versions of Windows Server and Windows, but the process is exactly the same on current versions.

Hands On with Microsoft Dynamics GP October 2019 Release: Download Microsoft Dynamics GP media

Microsoft Dynamics GPThis post is part of the series where I am going hands on with the new version of Microsoft Dynamics GP.

With the release of Microsoft Dynamics GP October 2019 release, you can download the software in one of two flavours:

The full release is for doing fresh installs or upgrading from versions of Dynamics GP prior to 2018; if you are on 2018 you can download and use the service pack release.

Hands On with Microsoft Dynamics GP October 2019 Release: System Requirements

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP.

The October 2019 release of Microsoft Dynamics GP largely has the same system requirements as Microsoft Dynamics GP 2018 R2 with the addition of the following:

  • Windows Server 2019
  • SQL Server 2019
  • Office 2019

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

Hands On with Microsoft Dynamics GP October 2019 Release: Series Index

Microsoft Dynamics GPThe new version of Microsoft Dynamics GP is the Microsoft Dynamics GP “October 2019” Release on the Modern Lifecycle and was released for download on the 7th October 2019.

In this series of posts, I’ll be going hands on with this new release and installing and configuring the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will, if you’re heading this on azurecurve|Ramblings of a Dynamics GP Consultant, automatically update as posts go-live:

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Series Index”

MDGP October 2019 Release Feature of the Day: More new features?

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP “October 2019” Release on which I am following and adding commentary. The index for this series of posts is here.

Unlike in other years, the Feature of the Day series has not covered all of the new features; I’ll be doing a Hands On series for the installation next, after which I will do a Hands On series with the new features where I’ll cover more of the new functionality. I’ll try to cover everything except the Human Resource & Payroll modules which are not used in the UK.

MDGP October 2019 Release Feature of the Day: Reprint Pay Statements

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP “October 2019” Release on which I am following and adding commentary. The index for this series of posts is here.

The eleventh Feature of the Day is Reprint Pay Statements. Another Payroll feature has been added, whereby you can reprint an entire group of pay statements as duplicates. This is added to the Payroll Reprint Journals report options.

Select Reprint Payroll posting journals –> Reprint Pay Statements. You select an audit trail code on the report option and the duplicate pay statements will print for all the payments made in that check run.

Reprint Payroll Posting Journal Report Options

Continue reading “MDGP October 2019 Release Feature of the Day: Reprint Pay Statements”

MDGP October 2019 Release Feature of the Day: Payroll Option to exclude Additional Withholding Amount

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP “October 2019” Release on which I am following and adding commentary. The index for this series of posts is here.

The tenth Feature of the Day is Payroll Option to exclude Additional Withholding Amount. With this change, when you build the check file, you have the option to include or exclude the additional withholding for Federal, State and Local tax amounts.

By default, any existing build check default ID will have these settings automatically marked. However, you can unmark the settings and save them with the build check default ID and they will be remembered in the future when you select that default ID.

Now, you can do special check runs without having to manually update employees who have setup additional withholding amounts.

Build Payroll Checks

MDGP October 2019 Release Feature of the Day: GL Journal Entry Inquiry Enhancements

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP “October 2019” Release on which I am following and adding commentary. The index for this series of posts is here.

The ninth Feature of the Day is GL Journal Entry Inquiry Enhancements. A number of enhancements have been made to the Journal Entry Inquiry window:

  • The year drop down list will now display in reverse order with the most recent year displayed first. This change has also been included in the following windows:
    • Net Change Inquiry
    • Detail Inquiry
    • Summary Inquiry
    • GL Trial Balance Report options
  • The User who Posted field has been added to the window; this field will display for both open and historical journal entries.
Journal Entry Inquiry