Generate matching colour palettes
Sep25

Generate matching colour palettes

I run a few websites now which means I have had a need to change colours on themes. However, being colourblind, this can be somewhat difficult to mke sure that the colours I am choosing will work together. One site I have found very useful is ColorHexa.com; this is a free color tool providing information about any color and generating matching color palettes for your designs (such as… Continue Reading Ian Grieve’s Article...

Read More
Displaying Images in the Data using Microsoft Power BI
Sep24

Displaying Images in the Data using Microsoft Power BI

I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC).  In this video, I will show you have I get team logos from my dataset to display. < div class=”wp-block-embed__wrapper”> <div… Continue Reading Belinda Allen’s Article on their blog Displaying Images in the Data using Microsoft Power BI I am building a Microsoft...

Read More
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
Issues with Word Templates
Sep23

Issues with Word Templates

Recently, there have been issues with Dynamics GP and Word Templates, due to some changes to the most recent Microsoft Office build releases. Specifically, documents generated in Word Templates cannot be opened in Microsoft Word, once you’re running a build from Sept 8/9th or newer. Today’s post is an attempt to clarify what the situation is, and what is and is not affected and clarify some of… Continue Reading Jen...

Read More
Power Platform: Application Lifecycle Management (Part 2/3) – Solutions and DevOps
Sep22

Power Platform: Application Lifecycle Management (Part 2/3) – Solutions and DevOps

In the previous installment, you saw how to work through a set of prerequisites to get you going in your Power Platform Application Lifecycle Management journey. In this video, I will work through building an app and adding it to a solution and show you some additional Azure DevOps configuration options to link your repository to your Power Platform development environment.Topics Covered:1…. Continue Reading Mariano...

Read More
There’s Power Apps in my Microsoft Teams
Sep22

There’s Power Apps in my Microsoft Teams

Today, on the first day of the 2020 Virtual Microsoft Ignite, Project Oakdale was highlighted.  What is Project Oakdale.  It is like the old Reese’s Peanut Butter Cup commercial….  “There is a Power App in my Teams” or There’s Teams on my Power App.”  Whichever way you say it, it ROCKS!  In this video, I will show you the creation of a Power App, using a table that I’ll create in… Continue Reading...

Read More
Creating Data Parameters with Suggested Values in Microsoft Power BI
Sep21

Creating Data Parameters with Suggested Values in Microsoft Power BI

I have shown you already how to create parameters with SQL Server data in Microsoft Power BI.  This time, I am going to show how to use a suggested list, so rather than manually entering data, I can select my parameter from a dropdown list.  By the way, if you are a US College (American) football fan, you will be excited about the report that is being built! < div class=”wp-block-embed__wrapper”> <div… Continue...

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
Creating data source parameters for SQL Server in Microsoft Power BI
Sep17

Creating data source parameters for SQL Server in Microsoft Power BI

If you want to model data against a development SQL Server environment and deploy against a production SQL Server, in Microsoft Power BI, this video is for you.  In this Tiny tip, I will show you how to create a Parameter, edit your data source, export, and import your work.

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
Power Platform: Application Lifecycle Management (Part 1/3) – Prerequisites
Sep14

Power Platform: Application Lifecycle Management (Part 1/3) – Prerequisites

This series is in response to multiple requests by my viewers to address the topic of Power Apps Application Lifecycle Management (ALM). This series is intended to breakdown the entire process in as much detail as possible, without lengthy explanations on how to get it done or, as often happens, little to no explanations on how you arrived at a particular step or result. My first installment… Continue Reading Mariano...

Read More
What happened to #TipTuesday?
Sep13

What happened to #TipTuesday?

Hey, everyone reading this… no, I haven’t fallen off the face of the earth. I’m hoping to get back into regular blogging this Fall. Ahem, I mean Autumn. (that’s for David Musgrave ). I’ve been fortunate to stay safe & healthy as well as maintain most of my business during COVID-19, that’s the good news. There have been a few unrelated things that have kept me away from my normal blogging…...

Read More
Using Microsoft Power BI Q&A to ask about a specific field in a column
Sep11

Using Microsoft Power BI Q&A to ask about a specific field in a column

Yesterday I had the pleasure of hanging out with the Microsoft Modern Excel and Power BI user Group.  We were talking about Q&A and discovered, together, a method of asking about data based on the value of a specific column.  While using the Q&A feature of Microsoft Power BI, I have done things like “Show me the revenue where the state is MN” but I had asked in this method.  We were… Continue Reading Belinda...

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
Renaming and Hiding Fields in Microsoft Power BI
Sep04

Renaming and Hiding Fields in Microsoft Power BI

Microsoft Power BI allows for the hiding of fields in Report Mode.    In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX. Today’s DAX Expression: Customer and Class = Customers[Customer Name] & ” ” & Customers[Customer Class] <div… Continue Reading Belinda Allen’s Article on their blog Renaming and Hiding Fields in Microsoft Power BI Microsoft Power BI allows for the...

Read More
Power Automate: Transfer records from SharePoint list to Azure SQL database
Sep03

Power Automate: Transfer records from SharePoint list to Azure SQL database

Majority of times, when we are working with various data sources, we want information to go from one source to another, conditioned to the occurrence of an event. Today, I will show you how to transfer records from a SharePoint list to Azure SQL database tables in response to a timesheet approval event. In the process, you will learn how I leveraged the existing Power Apps Expense template app… Continue Reading Mariano...

Read More
Using DAX with Conditional Formatting in Microsoft Power BI
Sep02

Using DAX with Conditional Formatting in Microsoft Power BI

OK, I have this table visual in my Microsoft Power BI Report and I want to highlight a row if a column value is “Yes” but do nothing to the background if the value is “No”.  In this Tiny Tip video, I will show you how to achieve this very thing. Today’s DAX Expression: Hold Background Color = VAR _HoldColor = SELECTEDVALUE(Customers[Hold]) RETURN IF(_HoldColor = “Yes”, “#A0D1FF”) <div… Continue Reading...

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
Setting Geographic Data Categories in Microsoft Power BI Q&A
Aug31

Setting Geographic Data Categories in Microsoft Power BI Q&A

Ever use a map visual in Microsoft Power BI, but the locations are not correct?  In this Tiny Tip I will show you how to categorize geographic fields.  For example, we will take the city field and define it as a City.  If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York. <div… Continue Reading Belinda Allen’s Article on their blog Setting...

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
Using Q&A to assist in User Adoption of Microsoft Power BI
Aug28

Using Q&A to assist in User Adoption of Microsoft Power BI

User adoption of any application is a “Hard road to Hoe”.  Sorry, the southerner in me breaks out every now and then.  In this Tiny Tip video, I’ll show you how to make a Microsoft Power BI report page, that will help end users have control over what they see.   <div… Continue Reading Belinda Allen’s Article on their blog Using Q&A to assist in User Adoption of Microsoft Power BI User adoption of any...

Read More
Creating Suggested Questions in Microsoft Power BI Q&A
Aug26

Creating Suggested Questions in Microsoft Power BI Q&A

If you have ever used the Microsoft Power BI Q&A visual, you know it creates “Suggested Questions” for you based on your dataset.  In this Tiny tip, I’ll show you have to create your own list of suggested questions, ones that are relevant to you and your users! <div… Continue Reading Belinda Allen’s Article on their blog Creating Suggested Questions in Microsoft Power BI Q&A If you have ever used the Microsoft...

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
Using Synonyms in Microsoft Power BI Q&A
Aug24

Using Synonyms in Microsoft Power BI Q&A

The Q&A is a super cool visual in Microsoft Power BI.  In this Tiny Tip I will show you how to add synonyms to your data fields so Q&A can recognize different terms that end users may enter.  For example, what if you call your customers “Guests” or “Clients”?  If you do, this tip is for you!  <div… Continue Reading Belinda Allen’s Article on their blog Using Synonyms in Microsoft Power BI Q&A The Q&A is...

Read More
Using a DAX function as a Report Title in Microsoft Power BI
Aug21

Using a DAX function as a Report Title in Microsoft Power BI

Using the Card Visual as a Report Title and a value can save you space on a Microsoft Power BI Report.  In this Tiny Tip I will show you how to make a DAX measure become text for a Report Title.  Because it is a visual, it will even be interactive with the remainder of the report! <div… Continue Reading Belinda Allen’s Article on their blog Using a DAX function as a Report Title in Microsoft Power BI Using the Card...

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
Changing Interactions between visuals in Microsoft Power BI
Aug14

Changing Interactions between visuals in Microsoft Power BI

The ability of visuals to interact with each other in Microsoft Power BI is probably one of the most powerful tools for letting your data talk to you, rather than reading the data.  However, sometimes you might need or want to control how the interactions work.  In this Tiny Tip, I will show you how to make changes to your report so interactions filter rather than highlight, or simply just… Continue Reading Belinda Allen’s...

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
Turning Off Auto-Size Column Width in Microsoft Power BI
Aug12

Turning Off Auto-Size Column Width in Microsoft Power BI

Thanks, Fred Kaffenberger, for sharing your tip with me for the Matrix visual in Microsoft Power BI. Check out this video to see Fred’s suggestion on manually controlling the width of columns.  It’s simple and cool! <div… Continue Reading Belinda Allen’s Article on their blog Turning Off Auto-Size Column Width in Microsoft Power BI Thanks, Fred Kaffenberger, for sharing your tip with me for the Matrix visual in...

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
Power Apps: Save Mixed Reality pictures to SharePoint
Aug10

Power Apps: Save Mixed Reality pictures to SharePoint

In this video you will learn how to save pictures taken in Power Apps Mixed Reality or Augmented Reality viewer to a SharePoint document library.     Some topics covered include: Power Apps ForAll(), With(), Mid(), and Len() functions, the Self operator. Learn to use the Power Automate SharePoint connector and the Create File action, and the base64toBinary() function in an expression. Finally,… Continue Reading Mariano...

Read More
Changing the Report Background in Microsoft Power BI
Aug10

Changing the Report Background in Microsoft Power BI

by @MsBelindaAllen Changing the background of a report in Microsoft Power BI can, and will, change the user’s experience.  In this Tiny Tip I will show you how to make every visual stand out a little more, by just changing the background.       <div… Continue Reading Belinda Allen’s Article on their blog Changing the Report Background in Microsoft Power BI Changing the background of a report in Microsoft...

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
Formatting the Matrix Visual Microsoft Power BI
Aug07

Formatting the Matrix Visual Microsoft Power BI

I love using PivotTables in Microsoft Excel.  When I use them, I always change them to Tabular and remove Subtotals to make them easier to read.  The Matrix visual in Microsoft Power BI is like the Excel PivotTable.  In this Tiny Tip video, I will show you how to make it tabular and remove subtotals. by @MsBelindaAllen <div… Continue Reading Belinda Allen’s Article on their blog Formatting the Matrix Visual Microsoft...

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
Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip)
Aug05

Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip)

by @MsBelindaAllen   In this TINY Video, I will add the last date and time the data in Microsoft Power BI was refreshed.  Old data is bad data!  This is an easy way to make sure you are looking at a good data! <div… Continue Reading Belinda Allen’s Article on their blog Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip) In this TINY Video, I will add the last date and time the data in Microsoft Power BI...

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
Adding multiple Trend Lines in Microsoft Power BI (Tiny Tip)
Aug03

Adding multiple Trend Lines in Microsoft Power BI (Tiny Tip)

by @MsBelindaAllen In this TINY Video, I will add a trend line to my clustered column chart visual in Microsoft Power BI.  Since my visual has 3 columns in each cluster (Legend), I want to have 3 separate trend lines so I can compare the trends of each value in the legend using the same x and y axis.  This 2-minute video shows how to do this! <div… Continue Reading Belinda Allen’s Article on their blog Adding multiple...

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

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.