Remove PowerPoint animations from slides
Sep23

Remove PowerPoint animations from slides

PowerPoint is not something I have used very often, but I am now doing webinars on at least a monthly basis at work. I’ve inherited some PowerPoint slidedecks from other people with some features I don’t like; one of those is having to click to display elements on slides. This is something which I now know to be animations and their removal is actually quite straightforward. To remove an… Continue Reading Ian...

Read More
Disable sounds for all Windows 10 Notifications
Sep21

Disable sounds for all Windows 10 Notifications

I’ve been switching off sounds for notifications for different programs for a while as I find the notuification chime far too loud compared to other program sounds, but as I am doing this on five or more machines, it is getting somewhat irritating. I eventually started thinking about a global switch off and wanted to see if this was possible, but since Microsoft moved settings out of the… Continue Reading Ian...

Read More
Our Favourite Add-ons from the recent ISC Software Webinar
Sep18

Our Favourite Add-ons from the recent ISC Software Webinar

In our most recent webinar, on Our Favourite Add-ons, we took a look at six of the add-ons which are preferred solutions from our senior consultants. They all meet a requirement which numerous clients have given to us at different times. Usually, there are several plugins which offer similar functionality which would meet these requirements, but these six add-ons are the ones which we… Continue Reading Ian Grieve’s Article...

Read More
Error opening Word templates from Microsoft Dynamics GP Workflow Action emails
Sep16

Error opening Word templates from Microsoft Dynamics GP Workflow Action emails

A client reported a problem with workflow approvers opening the batch edit list on a Microsoft Dynamics GP General Ledger Batch Approval workflow action email this morning; only a few users are having problems while everyone else is working without problem. The users with the problem are getting this error when trying to open the Transaction Edit List report on the email: Microsoft WordWord… Continue Reading Ian Grieve’s...

Read More
Upcoming Microsoft Dynamics GP Webinars from ISC Software
Sep11

Upcoming Microsoft Dynamics GP Webinars from ISC Software

I’ve been quite busy both in and out of work recently and have lagged in the writing of blog posts, so I thought I’d let you know of the three upcoming monthly webinars I’ll be delivering for ISC Software. We run these webinars on a monthly basis, with occasional extra webinars added to the schedule so it is worth checking the Webinar Schedule page every so often. The upcoming webinars are:

Read More
Show Workflow Approval Status of posted Microsoft Dynamics GP General Ledger batches
Sep10

Show Workflow Approval Status of posted Microsoft Dynamics GP General Ledger batches

I recently deal with a support call for a client where they were having problems creating a report which showed the approval status of GL batches. Building the WfBusObjKey was more complicated than I expected as it requires the date and time from the batch; for an unposted journal this can easily be retrieved from the PA Report Posting Definitions Master (SY00500) table, but for posted batches… Continue Reading Ian...

Read More
What’s New in the Microsoft Dynamics GP October 2020 Release
Sep02

What’s New in the Microsoft Dynamics GP October 2020 Release

I’ve been keeping my out for any news of the next version of Microsoft Dynamics GP but haven’t seen anything on the official blogs (if I’ve missed it, I’d appreciate someone pointing me in the direction), but there have been some recent articles from other partners listing some of the upcoming new functionality. One such article is from Aisling Dynamics Consulting, LLC on the ERP Software… Continue...

Read More
Microsoft Dynamics GP Workflow Payables Batch Approval email not including Word template
Sep01

Microsoft Dynamics GP Workflow Payables Batch Approval email not including Word template

A client has recently been working on a project to implement approval workflows in a few modules of Microsoft Dynamics GP, but had an issue with the Payables Transaction Approvals notification emails not always including the Word template which all of the steps are marked to include. There appeared to be no pattern on which approval emails either did or did not include the Word template; a user… Continue Reading Ian...

Read More
Notepad++ Find and Replace numbers in square brackets
Aug31

Notepad++ Find and Replace numbers in square brackets

I was working with some text the other day which included a lot of references using numbers in square brackets; I needed to remove this text and wanted an easy way of doing it. I did a little research and found that Notepad++, an application I already use, can do regular expression find and replace. The regular expression for a number surrounded by square brackets is: [(d+)] To use the… Continue Reading Ian Grieve’s...

Read More
Books referenced by Bernard Cornwell in the Sharpe series’ historical notes
Aug29

Books referenced by Bernard Cornwell in the Sharpe series’ historical notes

The Richard Sharpe series is a series of historical fiction novels and short stories by Bernard Cornwell centred on the character of Richard Sharpe, charting Sharpe’s progress in the British Army during the Napoleonic Wars, starting from his early career in India through to the Battle of Waterloo and beyond (further details on the series can be found on Wikipedia). In some of the books,… Continue Reading Ian Grieve’s...

Read More
Find text in any SQL object
Aug25

Find text in any SQL object

I needed to find custom triggers or views which referenced a certain table and although I thought I had a script which would find text in a SQL object like a trigger, view or stored procedure, I couldn’t find one when I searched my site the other day. It only took me a few minutes to write one; the first highlighted text is the text to search for and the second a limitation on the name of the… Continue Reading Ian...

Read More
SQL script to create macro to delete items in Microsoft Dynamics GP
Aug19

SQL script to create macro to delete items in Microsoft Dynamics GP

I’ve been doing some work with SmartConnect for a client recently where one of the integrations was creating new items. As the project progressed, some of the items which had been imported needed to be replaced with different item numbers. To ensure we didn;t cause problems, I didn’t want to delete items through SQL directly, due to the number and variety of tables involved, so needed to come… Continue Reading Ian...

Read More
Permissions error exporting Microsoft Dynamic GP SmartList Object
Aug17

Permissions error exporting Microsoft Dynamic GP SmartList Object

A client recently reported a problem whereby users were no longer able to export a SmartList favourite to Excel as they were receiving a permissions error when the Excel file opened: The SELECT permission was denied on the object ‘uv_AZRCRVBudgetByMonth’, database LIVE’, schema ‘dbo’ I did some checking and realised that the problem was that the file being opened when the user tried to do an…...

Read More
Jet Hub’s Supported Excel Functions
Aug14

Jet Hub’s Supported Excel Functions

I’ve been doing an increasing amount of work with Jet Reports and have come across two Excel functions which do not work with Jet Hub; they work fine in a Jet Report in Excel, but are apparently not supported in the Jet Hub. The two I’ve encountered problems with are: CONCAT isn’t supported, but the older CONCATENATE function is supported. RATE; this was actually used by a client in a formula… Continue Reading...

Read More
Select all user views and create GRANT SELECT TO DYNGRP statement
Aug13

Select all user views and create GRANT SELECT TO DYNGRP statement

I have a Microsoft Dynamics GP project deployment coming up soon for a client project for which a number of SQL views have been created; I can easily grab a create script for the views from Object Explorer Details in SQL Server Management Studio, but I also need to create the grant statement to give permissions to Dynamic GP users to use the SmartLists Builder objects which use these views.

Read More
Jet Reports Snippet: Calculate last day of last month
Aug12

Jet Reports Snippet: Calculate last day of last month

I’ve been doing some work with a client on Jet Reports recently and one of the items which we discussed, was running a report for the previous month without the user needing to set the date each time; this would allow them to use Jet Hub and schedule the report. A few days ago, I posted an article on getting the last day of the month using an Excel formula. To get the date for use in Jet… Continue Reading Ian...

Read More
Custom Refreshable Excel Reports in Microsoft Dynamics GP navigation lists
Aug11

Custom Refreshable Excel Reports in Microsoft Dynamics GP navigation lists

Mark Polino highlighted a post on Getting Custom with Excel Refreshable Reports on the Dynamics GP Support and Services Blog. I’ve made a lot of use for clients on refreshable Excel reports and have made them available in the navigation list for clients (more recently, I’ve used that to make Jet Reports accessible in the same way): I wasn’t aware this was problematic, but Béat Bucher posted… Continue Reading...

Read More
SQL Stored Procedure to remove Jet Reports’ Report Run History
Aug10

SQL Stored Procedure to remove Jet Reports’ Report Run History

If you’re using Jet Hub with Jet Reports, then when you run a report, the report run is stored in the Jet Services database;through time, this report run history can grow quite large if you either have large reports or are generating lots of reports; combine these together and the history can grow to potentially massive sizes. Jet Hub does not, unfortunately, include an automated clear-down… Continue Reading Ian...

Read More
azurecurve ClassicPress Plugins: Nearby
Aug08

azurecurve ClassicPress Plugins: Nearby

This is part of the which introduces the plugins I have available for ClassicPress. The plugin I am going to cover in this post, is a brand new one I’ve developed to use on two of my other sies; Nearby. Functionality Nearby creates a table of nearby locations (pages) based on GPS co-ordinates; it integrates with Flags from azurecurve, to display a flag next to the location, and Toggle… Continue Reading Ian Grieve’s...

Read More
Excel Snippet: Get first day and last day of month using an Excel formula
Aug07

Excel Snippet: Get first day and last day of month using an Excel formula

It doesn’t come up very often as I do a lot of work using SQL Server rather than Microsoft Excel, but every so often I do need to do some date manipulation in Excel. The formula, below, can be used to get the first and last days of a month (typically used for accruals); I had to do some research to find the syntax for Excel only to be surprised that it was similar to that of SQL Server… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Run Receivables Transaction Import [Video]
Aug06

Features of Financial Elementz from ISC Software: Run Receivables Transaction Import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on running a Receivables transaction import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Run Receivables Transaction Import video: GP… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Run Receivables Invoices import
Aug06

Features of Financial Elementz from ISC Software: Run Receivables Invoices import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. With the Receivables Transaction Import definition created, we can now use it to import some transactions. I have the template populated with two lines, which are for separate invoices. The Doc Type field should be set to one of the following… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Create Receivables Transaction Import [Video]
Aug05

Features of Financial Elementz from ISC Software: Create Receivables Transaction Import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on creating a Receivables transaction import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Create Receivables Transaction Import video: GP… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Create Receivables Invoices import
Aug05

Features of Financial Elementz from ISC Software: Create Receivables Invoices import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Financial Elementz includes a Receivables Transaction import which can be used to load the following transaction types into Receivables Management: Sales / Invoices Debit Memos Finance Charges Service / Repairs Warranty Credit Memo Returns The… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Run Manual Payments import [Video]
Jul30

Features of Financial Elementz from ISC Software: Run Manual Payments import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on running a Manual Payments import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Run Manual Payments import video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Run Manual Payments import
Jul30

Features of Financial Elementz from ISC Software: Run Manual Payments import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. With a Manual Payment Import Definition created, we can now use it to import data into Microsoft Dynamics GP. The file can include multiple payments, one per row, for different payment types and creditors. The example I am using has a cheque/check… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Create Manual Payments import [Video]
Jul29

Features of Financial Elementz from ISC Software: Create Manual Payments import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on creating a Manual Payments import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Create Manual Payments import video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Create Manual Payments import
Jul29

Features of Financial Elementz from ISC Software: Create Manual Payments import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. As well as the Payables Transaction Import covered over the last couple of posts in this series, Financial Elementz includes a Manual Payments Import with which you can import payments from other systems into Microsoft Dynamics GP. The source file… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Run Payables Transaction import [Video]
Jul28

Features of Financial Elementz from ISC Software: Run Payables Transaction import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on running a Payables Invoices import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Run Payables Invoices import video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Run Payables Transaction import
Jul28

Features of Financial Elementz from ISC Software: Run Payables Transaction import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. With the Payables Transaction Import definition created, we can now use it to import some transactions. I have the template populated with two lines, both of which are for the same invoice. The import will group together header fields which are… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Create Payables Transaction import [Video]
Jul27

Features of Financial Elementz from ISC Software: Create Payables Transaction import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on creating a Payables Invoices import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Create Payables Transaction import video: GP Elementz… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Create Payables Transaction import
Jul27

Features of Financial Elementz from ISC Software: Create Payables Transaction import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Financial Elementz includes a Payables Transaction import which can be used to load the following transaction types into Payables Management: Invoice Finance Charge Misc. Charge Return Credit Memo The import uses an Excel spreadsheet as the… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Run General Ledger import [Video]
Jul24

Features of Financial Elementz from ISC Software: Run General Ledger import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on running a General Ledger import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Run General Ledger import video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Run General Ledger import
Jul24

Features of Financial Elementz from ISC Software: Run General Ledger import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. One a General Ledger Import Definition has been created, it is a simple process to run it whenever needed to import a journal, or journals, from a Microsoft Excel spreadsheet. The spreadsheet can contain a single journal or multiple journals; the… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Create General Ledger import [Video]
Jul23

Features of Financial Elementz from ISC Software: Create General Ledger import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on creating a General Ledger import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Create General Ledger import video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Create General Ledger import
Jul23

Features of Financial Elementz from ISC Software: Create General Ledger import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. The General Ledger Import function of Financial Elementz does not require a specific format, but rather allows the user to define the format, or indeed formats, which can be used. In this example, I am using a fairly simple journal format, very… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: General Ledger Code Import [Video]
Jul22

Features of Financial Elementz from ISC Software: General Ledger Code Import [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on the General Ledger Code Import and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – General Ledger Code Import video: GP Elementz from ISC… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: General Ledger Code Import
Jul22

Features of Financial Elementz from ISC Software: General Ledger Code Import

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. The General Legder Code Import allows GL accounts to be imported from a CSV file into Microsoft Dynamics GP; it allows the codes to be imported into multiple companies from one CSV file reducing the need for running it multiple times. The order of… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Available imports [Video]
Jul21

Features of Financial Elementz from ISC Software: Available imports [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published a post on the Available imports and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Available Imports video: GP Elementz from ISC Software GP Elementz… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Available imports
Jul21

Features of Financial Elementz from ISC Software: Available imports

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Financial Elementz includes a number of import routines which can be used to import data from Excel spreadsheets into Microsoft Dynamics GP without the need for a tool like Integration Manager or SmartConnect. The available imports are: General… Continue Reading Ian Grieve’s...

Read More
Features of Financial Elementz from ISC Software: Introduction to Financial Elementz [Video]
Jul20

Features of Financial Elementz from ISC Software: Introduction to Financial Elementz [Video]

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Earlier today I published an introduction to Financial Elementz and am accompanying it with this video version of that post. You can watch the GP Elementz – Financial Elementz – Overview video: GP Elementz from ISC Software GP Elementz from… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Introduction to Financial Elementz
Jul20

Features of Financial Elementz from ISC Software: Introduction to Financial Elementz

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Financial Elementz is a set tools that can significantly improve productivity with easy to use windows and reports. Designed and created by ISCs Microsoft Dynamics GP consultants and developers to improve the daily tasks of a typical finance team,… Continue Reading Ian...

Read More
Features of Financial Elementz from ISC Software: Series Index
Jul17

Features of Financial Elementz from ISC Software: Series Index

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series. Financial Elementz is a collection of imports, inquiries and reports from ISC Software which can improve the efficiency of finance/accounting teams by adding functionality to Microsoft Dynamics GP. Over the course of this series, the index, below,… Continue Reading Ian...

Read More
Microsoft Dynamics GP SmartList window won’t open for one user
Jul16

Microsoft Dynamics GP SmartList window won’t open for one user

I was doing some consultancy for a client recently when they took the opportunity to ask me about a problem encountered by one of their users, whereby they were unable to open and use SmartList. it showed in the Windows task bar as open, but they couldn’t see it or bring it to the front. I tried the usual of trying to right click the window in the task bar and hitting Maximize, but this had no… Continue Reading Ian...

Read More
Integration Manager error when running a Sales Order Processing integration
Jul15

Integration Manager error when running a Sales Order Processing integration

I created an integration recently using Integration Manager for a client to import sales invoices into Microsoft Dynamics GP. It worked fine when I was developing it, logged in as DYNSA, and for one of the finance teams managers, but produced an error for the user: Opening source query… Establishing source record count… Beginning integration… DOC 1 ERROR: Unknown Great Plains field… Continue Reading Ian...

Read More
Duplicate last exchange rate in Microsoft Dynamics GP for every day to future date
Jul14

Duplicate last exchange rate in Microsoft Dynamics GP for every day to future date

I’ve been involved in a project which has included a lot of development and therefore a lot of QA and UAT over a period of time. The client’s system is configured with daily exhcnage rates which has caused some issues with testing as not everyone doing testing has access to insert new rates. To provide some consistency in the exchange rate for testing and to ensure that testing is not held up… Continue Reading Ian...

Read More
Accounts accessible to user when Account Level Security in use
Jul13

Accounts accessible to user when Account Level Security in use

the scrpt below returns all the accounts assigned to a specific user (defined at the top) using the Account Level Security module of Microsoft Dynamics GP. The script is configured to only return values if the Account Level Security module is enabled via the Company Setup window (Administration area page » Setup » Company » Company). To remove this restriction the where clause with the comment… Continue Reading...

Read More
Jet Reports with Microsoft Dynamics GP book available
Jul10

Jet Reports with Microsoft Dynamics GP book available

I have a new book available now called Jet Reports with Microsoft Dynamics GP; this book is aimed at end-users or consultants looking to use Jet Reports with Microsoft Dynamics GP for financial and/or operational reporting. The book covers the basics of installing and configuring Jet Reports as well as how to design and build reports using the Excel Add-in, before moving on to step-by-step… Continue Reading Ian Grieve’s...

Read More
Microsoft Dynamics GP running at an appalling slow speed
Jul09

Microsoft Dynamics GP running at an appalling slow speed

On a recent project we encountered an issue with the test ssytem running remarkably slowly in many areas. While logging in took longer than it should have, even opening the SmartList window was taking 45 seconds; when a SmartList favourite was selected, each column header and field was drawn slowly enough that it could be read before the next one appeared. Posting a Payables batch with 50… Continue Reading Ian Grieve’s...

Read More
Switch off SOP/Invoicing warning in Microsoft Dynamics GP
Jul08

Switch off SOP/Invoicing warning in Microsoft Dynamics GP

I often end up creating test, demo or upgrade requirements and have a number of scripts I run against them to make changes. The script below can be used to change the settings for the message displayed when both SOP and Invoicing are both installed. The script is set up to leave the message enabled for Invoicing, but switch it off for Sales Order Processing (the comments include the setting… Continue Reading Ian Grieve’s...

Read More