Microsoft Dynamics GP Custom Link Series by Shawn Dorward

Microsoft Dynamics GPMVP Shawn Dorward has recently been taking a look at the use of custom links in Microsoft Dynamics GP. This is an area of Dynamics GP which I have never written about and, while I’ve shown it to a few clients, I don’t think any of them are actually using it.

However, as the series from Shawn shows, custom links can actually be very useful.

The links below are to Shawn’s GP Life Hacks

Microsoft Dynamics GP Custom Link
Using Custom Links to Track Packages, Add Images and More
Adding Custom Links for Customers
Adding Custom Links for Checkbooks, Credit Cards and Currency
Adding Custom Links for Employees
Adding Custom Links for Inventory Items
Adding Custom Links for Vendors
Using Skype for Business from within Dynamics GP

Jet Reports 2018 R2 New Features

Jet ReportsI wrote a blog post on Implementing Jet Reports earlier this year. While I was mid-series a new version of Jet Reports was released, Jet Reports 2018 R2.

Jet Reports published a blog post on the new features and there are some quite nice ones included.

  • Run Reports directly from your Windows Desktop – Run your reports without even starting Excel; just right-click and the new task tray app will let you know when your report is ready.
  • Run Reports in the Background within Excel – No need to wait for your report before you can start using Excel as you can run your report in the background and continue working with your other Excel files.
  • Updated Jet Ribbon and Windows within Excel – The Jet ribbon has been updated and the entire user interface has been refreshed to be more consistent.

    Several items have been rearranged to be easier to find and other related items have been grouped together for a cleaner experience; all configuration settings have been combined under a single button and the run options have also been consolidated.

    In an effort to better explain what they do, the Refresh and Report buttons have been renamed to Run and Run from Cache, respectively.

Details on all of the changes are available on the Jet Reports blog.

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

GP Transaction Search v2: Series Index

Precipio ServicesSteve Endow of Precipio Services has recently launched a new GP Transaction Search addin for Microsoft Dynamics GP. The initial version had only a PM Transaction Search which replaces the Transaction by Document window (Purchasing » Inquiry » Trx by Document) in the Purchasing series.

Following very quickly on from version one, is a second version of the addin which contains a number of enhancements; I decided to do this second series as the installation if v2 differs substantially from v1.

Over the next few posts, I’m going to be taking a look at the installation, configuration and future of version 2 of this add-on.

GP Transaction Search v2
Available Search Windows
Installing the Prerequisites
Downloading and Installing
Customising the Configuration

Getting Normal MPC Black Edition Seek Bar Back

Media Player Classic-BEI accidentally changed the seek bar displayed in MPC-BE when I it had focus, rather than my browser, when I was typing a web address.

I don’t know what exactly it was I typed to change it, but the seek bar in fullscreen became a very basic one:

Basic MPC-BE seek bar

Continue reading “Getting Normal MPC Black Edition Seek Bar Back”

Find Unique Records in Microsoft Excel

Find Unique Records in Microsoft Excel

Microsoft ExcelI’m not very good with Microsoft Excel. People often think that I am becuae I can concatenate data and write if statements and other formula, but, beyond this, my knowledge is very shallow.

There are things that I know you must be able to do, but have no idea how. As such, I often default to loading data into SQL Server to manipluate. When dealng with large quantities of data, I think this is still the best thing to do, but for smaller datasets, using Excel makes more sense.

There may be a number of other posts, covering fairly simple functionality in Microsoft Excel, that I post in future as reminders for myself.

The first of these Excel tips, is identifying unique data. In Excel this is actually quite simple (once you know how).

If I wanted to identify how many unique vendor ids I had in a dataset, I can do this in only a small number of steps.

Select the columns containing the data I want to search; in this case, the Vendor ID and Vendor Name columns. Select the DataSort & Filter section, click Advanced:

Microsot Excel

Continue reading “Find Unique Records in Microsoft Excel”