GP 2018 Feature of the Day – Additional Sorting

In Dynamics GP 2018, some additional sorting options have now been added to some of the Enquiry windows. This is a direct result of end user feedback on Microsoft Connect.

The new sorting have been added to the following windows:

  • Receivables Transaction Enquiry – By Customer.
  • Receivables Transaction Enquiry – By Document.
    • The ability to sort by Type, Document Number, Document Amount, Amount Remaining and Document Date; by Ascending and Descending order.
  • Payables Transaction Enquiry – By Vendor.
  • Payables Transaction Enquiry – By Transaction.
    • The ability to sort by Document Number, Type, Original Amount, Unapplied Amount and Document Date; by Ascending and Descending order.
  • Bank Reconciliation.
    • New sort options include Payment and Deposit amount; by Ascending and Descending order.

You can check out the PowerPoint slides Here.

Share on Social Media:

GP Installation Package

I’ve just completed a test upgrade for a client and going through the finishing touches and creating a guide for the installation of their client machines for their IT department.

I was trying to think of ways to make the installation of the client machines as simple and as smooth as possible. A GP Installation Package is one of those things, that make it fairly easy to install GP on the client machines even if you have little knowledge of GP; I didn’t really want the client to have to install this, and then have to run the msp file to update to the latest build separately.

There must be a way to do this, right?

Well, Tim Wappat, who also hails from the North East of England, already had a solution. Check out his blog post here.

Creating the installation package from the Dynamics GP 2016 R2 installation media only creates a package on the build that went gold for that release. Therefore, the user would normally have to install the latest update separately.

Tim’s blog explains a way that you can incorporate the msp file into the msi that you run to install GP.

What I did, was download the update and put it into the Updates folder which is in the installation package folder structure. You then open an elevated command prompt and navigate to where the GreatPlains.msi file is and run the following command:

msiexec.exe /a GreatPlains.msi /p Updates\MicrosoftDynamicsGP16-KB4046341-ENU.msp

This command builds the patch into the msi; when you install the package, GP will be on the patched build! Thanks Tim, you’ve saved me and our client some time with that tip!

Share on Social Media: