MVP 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
I 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.
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.
With 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.
This 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:
Continue reading “GP Transaction Search v2: Customising the Configuration”
This 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:
Continue reading “GP Transaction Search v2: Downloading and Installing”
This 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:
Continue reading “GP Transaction Search v2: Installing the Prerequisites”
This 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:
Steve 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 (
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 |
I accidentally changed the seek bar displayed in MPC-BE when 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:
Continue reading “Getting Normal MPC Black Edition Seek Bar Back”
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:
