Shawn’s blog post contains a some really good example of searching and also covers a couple of items, such as all fields of which I was not aware.
While ISC are based in the UK and have an additional office in Dublin, Ireland, the add-ons we sell are available to anyone around the world using Microsoft Dynamics GP. As I have with products from other vendors of add-ons (such as eOne, Fastpath and Jet Reports), I am going to a series of posts on the products available from ISC; in particular I am going to look at the functionality they contain and will at a later date cover the installation and configuration.
I will be interspersing the posts of this series, and sub-series, with other posts as things of interest come up.
On occasion, I have had a need to remove the index and re-add; this is most often when I am writing a new edition of a book. I’ve done a fair bit of searching for ways of doing this and have used a couple of different approaches.
One of the early approaches I came across was to use VBA to strip the index entries out, but more recently I found another, much simpler, way of doing it using find and replace.
Press Ctrl+H to open the
The plugin I am going to cover in this post, is an existing one which has been brought up to coding standards; Theme Switcher.
Theme Switcher allows users to switch between different themes using the supplied widget; example uses would be to allow them to change mode between light and dark themes.
This site uses Theme Switcher to allow users to Change Mode between light and dark; you can try this using the Change Mode widget in the sidebar.
The plugin can be downloaded via my Development site.
I usually end ip trying a few services before finding the one which works every time; that service is Zamzar.
I’ve used it to convert a number of PNGs to PDFs now and also to convert a few other files as well. I find Zamzar to be consistently accurate and reliable for converting files.
The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.
In the last post I configured SSRS, which is fine for most uses. However, Microsoft Dynamics GP requires an additional configuration step. This is not done through the Report Server Configuration Manager, but by editing a config file.
The reason this is required is because of an error produced when deploying the SSRS reports. If you do not change the setting, the error you will receive is the following:
Microsoft Dynamics GP
The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength="20690" in the web.config file and try deploying again.
To avoid this error, requires the SSRS web.config file to be amended. The file, for SQL Server Reporting Services 2017, is located in
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer.
Below is a snippet of code from the web.config file with the added node highlighted:
<httpRuntime executionTimeout="9000" requestValidationMode="2.0" maxRequestLength="20690" />
Add the above, save the file, and SSRS is now ready for the Microsoft Dynamics GP reporting services reports to be deployed.
The Enhanced Security window () allows you to view the security resources and/or operations via the navigation (menus and area pages) or dictionary model:
This third example, shows how to use the new in SQL Server 2016 string_split command:
/* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK). */ SELECT value ,ITEMNMBR ,ITEMDESC ,ITMCLSCD FROM IV00101 CROSS APPLY string_split(RTRIM(ITEMNMBR), '-') WHERE value = 'SHP'
The example is part of the code I used when working on a client project a while ago; the client had a large number of Inventory Items and I needed to select a subset of the Items from the Inventory Master (IV00101).
When the clioent created their items they did so using a hyphen delimiter. Using the string_split command, I was able to separate out the segments of the Item Number and select only one of them in the WHERE clause.
This particular client is being upgraded from Microsoft Dynamics GP 2013 SP2 to 2016 R2.
The problem is that some of the companies are showing as Not implemented. The companies showing this way are the oldest; TEST2016… is actually the main company renamed for testing.
The tenth Feature of the Day I’m going “hands on” with is the Bank Reconciliation Tracks History one which introduced a new window on the Financial Routines menu:
To use this feature, decide if all, a range or one Checkbook should have its reconciliation history moved to history.
Mark the checkbox next to the type of transactions which should be moved and enter a Cut Off date; although the date field is aligned with the Reconciled Deposit Transactions, it apples to all of the transaction types.
Click Process to perform the move of reconciled transactions to history.