Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Sort companies in User Access Setup

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The second of the new features in the system module, is the ability to sort companies in the User Access Setup window (Administration area page » Setup » System » User Access). This function improves the ease with which access to companies can be granted, or removed, for a user.

The default display order is in Company ID order; this is a numeric identifier which signifies the order in which the companies were created:

User Acces Setup in Company ID order

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Sort companies in User Access Setup”

Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Date options in SmartLists

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The first of the new features in the system module, is the addition of of date options in the SmartList search. The new options added are intended to provide new options for users when searching for transactions in a date range. Instead of needign to specify the start and end date using a between criteria, you can select one of several options which will automatically calculate the start and end dates.

The new options are:

  • Prior Month
  • Next Month
  • Prior Period
  • Next Period
Search Payables Transactions

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Date options in SmartLists”

Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Compatibility with SQL Server 2019, Windows Server 2019, and Office 2019

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

It strikes me as being a little odd to include compatibility in as a new feature, but that’s what Microsoft have done. The October 2019 Release of Microsoft Dynamics GP is compatible with SQL Server 2019, Windows Server 2019 and Office 2019.

This brings Dynamics GP up-to-date with the latest versions of the systems with which it works. There is no mention of version compatibility being removed for older versions, so this means the envelope of supported versions has increased.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements
Compatibility with SQL Server 2019, Windows Server 2019, and Office 2019
Date options in SmartLists
Sort companies in User Access Setup

Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Series Index

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements series where I am going hands on with the system enhancements of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

This post is the series index for the system enhancements made to Microsoft Dynamics GP October 2019 Release

Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements
Compatibility with SQL Server 2019, Windows Server 2019, and Office 2019
Date options in SmartLists
Sort companies in User Access Setup

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

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

Microsoft Dynamics GPFollowing the release of the Microsoft Dynamics GP October 2019 Release, I have recently been hands on installing the new version. Just prior to the release Microsoft did a series of Feature of the Day posts which I echoed and added my thoughts.

The Feature of the Day posts didn’t cover all of the new functionality, just the highlights. Well, now that I can go hands on with the new features, I am going to do a post on each of the new features including my opinion on weather they’re a positive/neutral or negative additional and also how well they work. I’ll split the posts over a few series to separate out the different type of features, but will probably not cover the Payroll or HR ones as these modules are not used in Europe and so I have no experience with them.

This post is the index for the main series, but I have also included the indexes for all sub-series below as well.

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

Making folder backups using Cron

Cron JobsAs I mentioned in yesterdays post on ,a href=’https://www.azurecurve.co.uk/2019/12/making-mysql-backups-using-cron/’>making backups of mySQL databases, earlier this year I migrated from a Microsoft Windows based web hosting package to a Linux based one. This meant I had to learn a few new ways of doing things, such as backing up databases or files, on a regular repeating basis.

This is accomplished on Linux web hosts using the Cron time-based scheduler. I needed to create two types of cron jobs; one to backup databases and one to backup files. Yesterdays post was on the databases and todays is on backing up files.

The syntax for backing up a files using Cron jobs will largely be the same on all web hosts.

The below example shows the syntax to backup a files, with the sections to change highlighted:

/*
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). */
/bin/tar -czvf /home/{username}/backups/backup_{sitename}_$(date +\%Y\%m\%d\%H\%M\%S).tar.gz /home/{username}/{foldername}

Making mySQL backups using Cron

Cron JobsEarlier this year I migrated from a Microsoft Windows based web hosting package to a Linux based one. This meant I had to learn a few new ways of doing things, such as backing up databases or files, on a regular repeating basis.

This is accomplished on Linux web hosts using the Cron time-based scheduler. I needed to create two types of cron jobs; one to backup databases and one to backup files.

The syntax for backing up a MySQL database using Cron jobs will largely be the same on all web hosts.

The below example shows the syntax to backup a mySQL database, with the sections to change highlighted:

/*
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). */
/usr/bin/mysqldump -u {username}-p'{password}' {databasename} > /home/{username}/backups/backup_{databasename}_$(date +\%Y\%m\%d\%H\%M\%S).sql

Hands On with Microsoft Dynamics GP October 2019 Release: Install GP Add-in for Microsoft Word

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 Microsoft Dynamics GP Add-in for Microsoft Word allows the Word Templates used for outputting vendor or customer documents to be amended and have new fields added to them. Things work best if you have both the Microsoft Dynamics GP client and Microsoft Word on the same computer, but this isn;t technically necessary as you could copy the exported Word Template between machines to make the changes and then transfer it back for import.

To install the add-in, launch the Microsoft Dynamics GP setup utility and, under the Additional Products heading, select Microsoft Dynamics GP Add-in for Microsoft Word:

Microsoft Dynamics GP setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install GP Add-in for Microsoft Word”

Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service

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 OData service allows for reporting services such as PowerBI to connect to Microsoft Dynamics GP. This post is going to focus on installing the OData service, but at the bottom of this post I’ve included details of a book, co-written by Mark Polino and I, in which Mark covered configuring OData for use with PowerBI.

To install the OData Service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under the Additional Products heading:

Microsoft Dynamics GP setup utility

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

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

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 GP PowerShell module can be used to execute commands against Microsoft Dynamics GP such as creating a new company. The installation is a straightforward one which only needs to be done on a machine on which it nwill be used; there also needs to be a Dynamics GP client present.

To install GP PowerShell, launch the setup utility and, under the Additional Products header click GP PowerShell:

Microsoft Dynamics GP setup utility

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